Nebraska Ed-Fi Data v3.1 - Student CTE Program Associations

Classic View: System Administration > Ed-Fi

Search Terms: 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.

After the 2028 release, this resource is no longer being reported.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When an the student has a Career Tech Program record that overlaps the configured year and the student has an enrollment in the configured year. Do not send records if the Calendar Exclude check box is checked in the calendar the student is enrolled. Do not send records if the School Exclude check box is checked in the calendar the student is enrolled. Do not send a record if the No Show check box is checked.
Put	When the Programs> Career Tech Programs record is updated by the following fields, all student's records will be updated. State Code (CIP)
Put	When the student's Academic Planning> Career Tech Program Detail record has changed for a student. Student Status End Date Non-Traditional Participation
Delete/Post	When the start date of a Career Tech Program record is 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

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: LEA Reference - District Numbers cannot change after data has been sent. If a district number changes, we would expect an Ed-Fi error and this change would not be supported. If an Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the Ed-Fi ID Change triggers. Start Date - if the start date of the record changes, the record will delete then repost with new date.
Delete	Cascading Deletes: N/A - no dependent resources.

Action

Trigger

Post/Delete

Natural Key changes:

LEA Reference - District Numbers cannot change after data has been sent. If a district number changes, we would expect an Ed-Fi error and this change would not be supported.
If an Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the Ed-Fi ID Change triggers.
Start Date - if the start date of the record changes, the record will delete then repost with new date.

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
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 following: "Program Reference.	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. If a previous year's record was closed without an end date and the school year has changed from the year that the record was created, do not report.	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.	Reports 'True' if the Non-Traditional Participation checkbox is checked. Else, report 'False'.	O	Student Information> Academic Planning> Programs> Program Type: Career Tech Program> Non-Traditional Participation	programparticipation.nonTraditional
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.	Always report 'False'.	O
reasonExitedDescriptor	The reason the child left the Program within a school or district.	This field is optional, does not report.	O
servedOutsideOfRegular Session	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.	Report the EdFi code value from the Exit Reason selected.	O

Arrays

ctePrograms

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
careerPathwayDescriptor	A sequence of courses within an area of interest that is a student’s educational road map to a chosen career.	Report the 'Career Pathway Type' from the program name selected in the droplist. If the pathway is not mapped, do not report.	M	Program Admin> Programs> Career Tech Programs> Pathway/Program Name	program.name
cipCode	Number and description of the CIP Code associated with the student’s CTEProgram.	Reports the State Code (CIP) from the Career Tech Program being reported.	O	Program Admin> Programs> Career Tech Programs> State Code (CIP)	program.code
cteProgramCompletionIndicator	A boolean indicator of whether the Student has completed the CTEProgram.	Reports 'True' if the student has a Student Status that is mapped in Resource Preferences. Report 'False' if the student has a Student Status that is not mapped in Resource Preferences or the Student Status is blank.	O	Student Information> Academic Planning> Program Type= Career Tech Program> Student Status	programparticipation.studentStatus
primaryCTEProgramIndicator	A boolean indicator of whether this CTEProgram, is the student’s primary CTEProgram.	This field does not report.	O
TechnicalSkillAssessment		Report the Ed-Fi code value from the Exit Reason selected.

Type/Descriptors

Program Name:

Technical Skill Attainment Descriptor:

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
02	Met Technical Skill Attainment through third party assessment	Met Technical Skill Attainment through third party assessment
03	Met Technical Skill Attainment through Locally developed criterion	Met Technical Skill Attainment through Locally developed criterion
04	Did not meet Technical Skill Attainment	Did not meet Technical Skill Attainment
05	Met Technical Skill Attainment through dual credit and/or courses	Met Technical Skill Attainment through dual credit and/or courses
11	Artificial Insemination (AI) Certification	Artificial Insemination (AI) Certification
12	Commercial Driver's License	Commercial Driver's License
13	Emergency Medical Technician (EMT)	Emergency Medical Technician (EMT)
14	Forklift	Forklift
15	Livestock Quality Assurance Certification	Livestock Quality Assurance Certification
16	Medication Aid	Medication Aid
17	Mental Health First Aid	Mental Health First Aid
18	Microsoft Office Specialist Certification	Microsoft Office Specialist Certification
19	NCCER National Registry	NCCER National Registry
20	Nursing Assistant/CNA	Nursing Assistant/CNA
21	OSHA 10hr. Certification	OSHA 10hr. Certification
22	Pesticide Applications License	Pesticide Applications License
23	Pharmacy Technician	Pharmacy Technician
24	Phlebotomy Technician	Phlebotomy Technician
25	ServSafe	ServSafe
26	W!SE Financial Literacy Certificate	W!SE Financial Literacy Certificate
99	Met Tech Skill Attainment Through Industry Certification: Other/Unknown	Met Tech Skill Attainment Through Industry Certification: Other/Unknown

Level of Program Participation:

Ed-Fi Code Value	Ed-Fi Short Description	Ed-Fi Description
01	Career Education Participant	Career Education Participant
02	Career Education Participant with Postsecondary	Career Education Participant with Postsecondary
03	Career Education Concentrator	Career Education Concentrator
04	Career Education Concentrator with Postsecondary	Career Education Concentrator with Postsecondary

Program Name	Ed-Fi Short Description	Career PathwayType
Career and Technical Education	Career and Technical Education	Agriculture, Food and Natural Resources
Career and Technical Education	Career and Technical Education	Architecture and Construction
Career and Technical Education	Career and Technical Education	Arts, A/V Technology and Communications
Career and Technical Education	Career and Technical Education	Business, Management and Administration
Career and Technical Education	Career and Technical Education	Education and Training
Career and Technical Education	Career and Technical Education	Finance
Career and Technical Education	Career and Technical Education	Foundational, Exploratory, Career Dev, or Other
Career and Technical Education	Career and Technical Education	Government and Public Administration
Career and Technical Education	Career and Technical Education	Health Science
Career and Technical Education	Career and Technical Education	Hospitality and Tourism
Career and Technical Education	Career and Technical Education	Human Services
Career and Technical Education	Career and Technical Education	Information Technology
Career and Technical Education	Career and Technical Education	Law, Public Safety, Corrections and Security
Career and Technical Education	Career and Technical Education	Manufacturing
Career and Technical Education	Career and Technical Education	Marketing, Sales and Service
Career and Technical Education	Career and Technical Education	Science, Technology, Engineering and Mathematics
Career and Technical Education	Career and Technical Education	Transportation, Distribution and Logistics