Wisconsin Ed-Fi Data v3.3 - Student CTE Program Associations

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: No Show, State Exclude, or WISE Exclude check box are NOT checked. The enrollment is NOT in a calendar marked Calendar Exclude or Summer School Exclude check box is checked in the calendar or the calendar is in a School marked Exclude. The enrollment is NOT for a Grade marked Grade Level Exclude. State Enrollment Type = Primary
Career Tech Education Concentrator
Post	When a new CTE Program Record is saved for a student where: The CTE Program has a State Code (CIP) and Cluster identified. The CTE Program is marked State Reported. The student CTE Program record associated with the CTE Program is marked Concentrator = Yes. The student Enrollment is in state grade level 11 or 12. If there are multiple enrollments with the same start date in the same school, for unique elements report from enrollments in the following order: First from State Enrollment Type = Primary Then Enrollment Service Type = Primary Then Enrollment Service Type = Special Ed When an enrollment with a higher priority is deleted, the enrollment with lower priority will post a new record. If another student CTE Program record exists for a Program meeting all the above criteria with an earlier start date OR lower programId, do NOT report the second record (Only report one program record for a Career Tech Education Concentrator scenario)
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: The CTE Program has a Non-Course Program Status identified. The CTE Program is marked State Reported. The student CTE Program record associated with the CTE Program is within the dates of the students enrollment in the current/ config year. 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. When a student has two enrollments in the same school for the same start date, record changes with lower priority will not trigger a delete.
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: 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
		Career Tech Education Concentrator	Non-Course Associated Career Tech Education (or College and Career Ready) or Certified Program
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.	M	Student Information > Academic Planning > Start Date
educationOrganization Reference	A reference to the related Education Organization Resource.	Report the School ID for the enrollment determining the record.		M	Student Information > General > Enrollment
programReference	A reference related to the Program resource. Only report the most recent program if a student has 2 academic records for the same config year with the same program/program type .	For Education Organization ID, report: 48856. For Program Name, report "Career and Technical Education". For Program Type, report "Career and Technical Education".	For Education Organization ID, report: 48856 For Program Name, report based on the Non-Course Program Status field on the CTE Program the student has an associated record for, If the Status = "Local Co-Op", report "Non Certified Career Education Program". Otherwise, report "Certified Career Education Program" For Program Type, report the description from the Non-Course Program Status field on the CTE Program the student is assigned to.	M
ctePrograms	The career cluster representing the career path of the Vocational/Career Tech concentrator.	For Career Pathway Type, report the ed-fi code from the Career Cluster on the CTE Program the student has an associated CTE record for. For iac Code Type, report the ed-fi code from the CIP Code on the CTE Program the student has an associated CTE record for.	This field does not report.	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.	O	Student Information > Academic Planning > 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.	This field is optional and does not report.
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 and does not report.
technicalSkillsAssessmentDescriptor	Results of technical skills assessment aligned with industry recognized standards.	This field is optional and does not report.
cteConcentrationCteProgramAreas (_ext ( studentCTEProgram AssociationExtensions (wi_studentCTE ProgramAssociationExtension))	WI Program areas of concentration	Report the Program Concentration Areas on the student's CTE record If (A) Ag & Natural Resource is checked, add 'A' to the array If (B) Business & Info Tech is checked, add 'B' to the array If (F) Family/Consumer Science Edu is checked, add 'F' to the array If (H) Health Science is checked, add 'H' to the array If (M) Marketing is checked, add 'M' to the array If (T) Technology & Engineering is checked, add 'T' to the array Report all values separated by commas in the array	This field does not report.	C	Student Info > Academic Planning > Programs
certificatedProgramStatusDescriptor (_ext ( studentCTEProgramAssociation Extensions (wi_studentCTEProgram Association Extension))	Indicator of Certificated Program Status. Only submit certificated Program status when program reference is 'Certified Career Education Program'. code value : Certified	This field does not report.	Report based on the Non-Course Program Status field on the CTE Program the student has an associated CTE record for, If the Status = "Local Co-Op", do not report. Otherwise, report the program status from the associated Student CTE record. If multiple CTE academic programs exist for a student with the same Non-Course Program but different Student Status values, report all records. If multiple academic programs exist with the same Student Status and Start Date, report from most recent CTE Academic Program record.	C	Student Information > Academic Planning > Programs

Type/Descriptors

Click here to expand...

Certified Program Status Descriptors

Code	Description
A: Agriculture and Natural Resources Education	Agriculture and Natural Resources Education
B: Business and Information Technology Education	Business and Information Technology Education
M: Marketing Education	Marketing Education
F: Family and Consumer Science Education	Family and Consumer Science Education
T: Technology and Engineering Education	Technology and Engineering Education
H: Health Science Education	Health Science Education

CTE Program Status

Code	Description
A: Completed with Certificate	Completed with Certificate
B: Continuing	Continuing
C: Exited	Exited
D: Completed without Certificate	Completed without Certificate