Tool Search Term: Ed-Fi
This association represents the career and technical education (CTE) program that a student participates in. The association is an extension of the Student Program Association particular for CTE programs.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | When the student has a Career Tech Program record that overlaps the configured year AND the student has an enrollment in the configured year AND has one or more of the following selected:
Do not send records if the Calendar Exclude checkbox is marked in the calendar in which the student is enrolled. Do not send records if the School Exclude checkbox is marked in the calendar in which the student is enrolled. Do not send a record if the No Show checkbox is marked. |
| Put | All student records are updated when the Programs > Career Tech Programs record is changed on the following fields:
|
| Delete/Post | When the student's Academic Planning > Career Tech Program Detail record has changed.
|
| Delete | When the Career Tech Program record is deleted. |
| Delete | If the Career Tech start/end dates are changed and the record no longer overlaps the configured year. |
School Exclude, Calendar Exclude, Resource Toggle and Resync Logic
| Action | Trigger |
|---|---|
| None | If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send. |
| Resync | If a record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table. |
| Resync | If a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS. |
| Resync | If a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes. |
Natural Key Changes, Cascading Updates, and Deletes Logic
| Action | Trigger |
|---|---|
| Post/Delete | Natural Key changes:
|
| Delete | Cascading Deletes: N/A - no dependent resources. |
Scope Year Logic
| Logic |
|---|
The record sends to and year that the student's Career Tech record overlaps with. |
| Data only sends for the years that have valid configuration. |
Resource Preferences
Data Element Label | Mapping Needed |
|---|---|
| Career Tech Pathway/Program Name | careerPathwayDescriptor |
| Student Status | cteProgramCompletionIndicator |
| Select the Program Type Descriptor associated with this Program | Program Type Descriptor |
Student's Career Tech Program Certifications Status is = Passing Student's Career Tech Program Certifications Status is = Attempted Student does not have a Career Tech Program Certifications record | Technical Skills Assessment Descriptors |
Event Queue Detail
| Campus Table | Ed-Fi Action | Fields |
|---|---|---|
| programs | Put | The primary table for sending data for this resource. |
| programparticipation | Put | The primary table for sending data for this resource. |
Object Data Elements
Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.
| Data Element Label | Business Requirement | Business Rules | M, C or O | Location |
|---|---|---|---|---|
| id | The unique identifier of the resource. | M | ||
| beginDate | The month, day, and year on which the Student first received services. | Reports the start date of the Career Tech Program the student is assigned. | M | Student Information > Academic Planning> Programs > Program Type: Career Tech Program > Start Date programparticipation.startdate |
| educationOrganization Reference | A reference to the related Education Organization Resource. | Reports the Natural Key of the Local Education Agencies resource. | M | |
| programReference | A reference related to the Program resource. | Reports the Natural Key of the Programs resource. | M | |
| studentReference | A reference to the related Student resource. | Reports the Natural Key of the Students resource. | M | |
| ctePrograms | The career cluster representing the career path of the Vocational/Career Tech concentrator. | See array section below for requirements. | O | |
| endDate | The month, day, and year on which the Student exited the Program or stopped receiving services. | Reports the end date of the Career Tech Program the student is assigned. | O | Student Information > Academic Planning > Programs > Program Type: Career Tech Program > End Date programparticipation.enddate |
| nonTraditionalGenderStatus | Indicator that student is from a gender group that comprises less than 25% of the individuals employed in an occupation or field of work. | This field is optional, does not report. | O | |
| privateCTEProgram | Indicator that student participated in career and technical education at private agencies or institutions that are reported by the state for purposes of the Elementary and Secondary Education Act (ESEA). Students in private institutions which do not receive Perkins funding are reported only in the state file. | This field is optional, does not report. | O | |
| reasonExitedDescriptor | The reason the child left the Program within a school or district. | This field is optional, does not report. | O | |
| servedOutsideOfRegularSession | Indicates whether the Student received services during the summer session or between sessions. | This field is optional, does not report. | O | |
| services | Indicates the Service(s) being provided to the Student by the Program. | This field is optional, does not report. | O | |
| technicalSkillsAssessment Descriptor | Results of technical skills assessment aligned with industry recognized standards. | This field is optional, does not report. | O |
