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.

ActionBusiness 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)

PutWhen an enrollment is updated for a student.
PutWhen the student CTE Program record driving the record is updated for a student.
DeleteWhen 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
PostWhen an enrollment is updated to be reportable AND the student meets the criteria for one of the reporting scenarios.
Delete/ PostWhen the start date of an enrollment is changed.
DeleteWhen 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.
DeleteWhen 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.

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf 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.
ResyncIf 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.
ResyncIf 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.

ActionTrigger
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.
DeleteCascading 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 TableEd-Fi ActionFields
programsPutThe primary table for sending data for this resource.
programparticipationPutThe 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 ConcentratorNon-Course Associated Career Tech Education (or College and Career Ready) or Certified Program


beginDateThe 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.MStudent Information > Academic Planning > Start Date
educationOrganization
Reference
A reference to the related Education Organization Resource.
  1. Report the School ID for the enrollment determining the record.
M

Student Information > General > Enrollment


programReferenceA 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 .
  1. For Education Organization ID, report: 48856.
  2. For Program Name, report "Career and Technical Education".
  3. For Program Type, report "Career and Technical Education".
  1. For Education Organization ID, report: 48856
  2. 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"
  3. For Program Type, report the description from the Non-Course Program Status field on the CTE Program the student is assigned to.
M

cteProgramsThe career cluster representing the career path of the Vocational/Career Tech concentrator.
  1. 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.
  2. 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.
  1. This field does not report.
O

Program Admin > Career Tech > Cluster

Program Admin > Career Tech > State Code (CIP)



endDateThe 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.OStudent 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.

  1. This field is optional and does not report.



privateCTEProgramIndicator 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.
  1. This field is optional and does not report.



technicalSkillsAssessmentDescriptor

Results of technical skills assessment aligned with industry recognized standards.

  1. This field is optional and does not report.



cteConcentrationCteProgramAreas
(_ext ( studentCTEProgram
AssociationExtensions (wi_studentCTE
ProgramAssociationExtension))
WI Program areas of concentrationReport the Program Concentration Areas on the student's CTE record
  1. If (A) Ag & Natural Resource is checked, add 'A' to the array
  2. If (B) Business & Info Tech is checked, add 'B' to the array
  3. If (F) Family/Consumer Science Edu is checked, add 'F' to the array
  4. If (H) Health Science is checked, add 'H' to the array
  5. If (M) Marketing is checked, add 'M' to the array
  6. If (T) Technology & Engineering is checked, add 'T' to the array
  7. Report all values separated by commas in the array
  1. This field does not report.
CStudent 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


  1. 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,
  1. If the Status = "Local Co-Op", do not report.
  2. 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.
CStudent Information > Academic Planning > Programs

Type/Descriptors

Click here to expand...

Certified Program Status Descriptors

Code Description
A: Agriculture and Natural Resources EducationAgriculture and Natural Resources Education
B: Business and Information Technology EducationBusiness and Information Technology Education
M: Marketing EducationMarketing Education
F: Family and Consumer Science EducationFamily and Consumer Science Education
T: Technology and Engineering EducationTechnology and Engineering Education
H: Health Science EducationHealth Science Education

CTE Program Status

CodeDescription
A: Completed with CertificateCompleted with Certificate
B: ContinuingContinuing
C: ExitedExited
D: Completed without CertificateCompleted without Certificate