Tool Search: Ed-Fi
This association represents the career and technical education (CTE) program that a student participates in. The association is an extension of the StudentProgramAssociation particular for CTE programs.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
Action | Business Rules |
---|---|
Pre-conditions/ All Scenarios | |
If Ed-Fi Configuration Profile = Choice + Opt in, do NOT report any records. | |
If Ed-Fi Configuration Profile = Choice, do NOT report any records. | |
A Student must have a valid enrollment in order for a record to Post where:
| |
Career Tech Education Concentrator | |
Post | When a new CTE Program Record is saved for a student where:
|
Put | When an enrollment is updated for a student. |
Put | When the student CTE Program record driving the record is updated for a student. |
Delete | When the student CTE Program record driving the record is marked Concentrator = No. |
Non-Course Associated Career Tech Education (or College and Career Ready) | |
Post | When a new CTE Program Record is saved for a student where:
|
State Endorsed Regional Pathways | |
Post | When a new CTE Program Record is saved for a student with a reportable enrollment.
|
Put | When the student CTE Program record driving the record is updated for a student |
All Scenarios | |
Post | When an enrollment is updated to be reportable AND the student meets the criteria for one of the reporting scenarios. |
Delete/ Post | When the start date of an enrollment is changed. |
Delete | When an enrollment is deleted or one of the check boxes for No Show, State Exclude, or WISE Exclude are checked. |
Delete | When an enrollment service type is changed to Partial (S) for an enrollment previously triggering a record.
|
Delete | When the student CTE program record driving the record is deleted. |
School Exclude, Calendar Exclude, Resource Toggle and Resync Logic
This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.
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
This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.
Action | Trigger |
---|---|
Post/Delete | Natural Key changes:
|
Delete | Cascading Deletes: N/A - no dependent resources. |
Scope Year Logic
This table describes scope year logic of this object.
Logic |
---|
The record will send to and year that the student's Career Tech record overlaps with. |
Data will only send for the years that have valid configuration. |
Event Queue Detail
This table describes the Event Queue Detail of this object.
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 | Data Source GUI Path | Database Field | ||
---|---|---|---|---|---|---|---|
Career Tech Education Concentrator | Non-Course Associated Career Tech Education (or College and Career Ready) or Certified Program | State Endorsed Regional Pathway (for 19-20 only) | |||||
beginDate | The month, day, and year on which the Student first received services. | Report "07/01/xxxx" where xxxx is the start year of the record config year. | Report the start date of the student CTE program record. | Report "07/01/xxxx" where xxxx is the start year of the record config year. | M | Student Information > Academic Planning > Career Tech > Status > Start Date | |
educationOrganizationReference | A reference to the related Education Organization Resource. |
| M | Student Information > General > Enrollment | |||
programReference | A reference related to the Program resource. |
|
|
| M | ||
ctePrograms | The career cluster representing the career path of the Vocational/Career Tech concentrator. |
|
|
| O | Program Admin > Career Tech > Cluster Program Admin > Career Tech > State Code (CIP) | |
endDate | The month, day, and year on which the Student exited the Program or stopped receiving services. | Report "06/30/xxxx" where xxxx is the end year of the record config year. | Report the end date of the student CTE program record. | Report "06/30/xxxx" where xxxx is the end year of the record config year. | O | Student Information > Academic Planning > Career Tech > Status > End Date | |
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. |
| |||||
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. |
| |||||
technicalSkillsAssessmentDescriptor | Results of technical skills assessment aligned with industry recognized standards. |
| |||||
cteConcentrationCteProgramAreas (_ext ( studentCTEProgram AssociationExtensions (wi_studentCTE ProgramAssociationExtension)) | WI Program areas of concentration | Report the Program Concentration Areas on the student's CTE record
|
|
| C | Student Information > Academic Planning > Career Tech > Program Concentration Areas | |
certificatedProgramStatusDescriptor (_ext ( studentCTEProgram AssociationExtensions (wi_studentCTEProgram AssociationExtension)) | Indicator of Certificated Program Status. Only submit certificated Program status when program reference is 'Certified Career Education Program'. |
| Report based on the Non-Course Program Status field on the CTE Program the student has an associated CTE record for,
|
| C | ||
stateEndorsedRegional CareerPathwayStatusD escriptor (_ext ( studentCTE ProgramAssociationExtensions (wi_studentCTEProgram AssociationExtension) | Indicator of StateEndorsedRegionalCareerPathwayStatusOnly submit StateEndorsed Regional CareerPathway Status when program reference is 'State Endorsed Regional Career Pathway Program' |
|
| Report from Concentrator field on the CTE Program the student has an associated CTE record for
| C | Student Information > Academic Planning > Career Tech > Status Student Information > Academic Planning > Career Tech > Concentrator |