The following article provides information on how to set up data for reporting CTE information for Ed-Fi.
For more information, please refer to the following Arizona Documentation:
- Arizona Documentation: https://www.azed.gov/cte
Required Fields for Course
| Required Field/Person Association | Campus Location | Ed-Fi resource.endpoint | Validation Rules |
|---|---|---|---|
| Course Start Date | Section Information > Section Schedule Placement | Session.TermDescriptorid | |
| Course End Date | Section Information > Section Schedule Placement | Session.TermDescriptorid | |
| Term | Section Information > Section Schedule Placement | Session.TermDescriptorid | |
| Period | Section Information > Section Schedule Placement | Section.ClassPeriodName | |
| Site Location | Course Information > Location Override OR Section Information > Location Override OR School Information > Entity ID | Section.SiteLocationSchoolId | |
| CTE Minutes per Week | Course Information > CTE Minutes per Week OR Section Information > CTE Minutes per Week Override | Sections | Must meet the following min/max rules
|
| A teacher must be associated to course except for articulated post secondary. | Section Staff History | Staffs, multiple endpoints StaffSectionAssociations |
|
| Students must be associated to the course. | Section Roster | StudentSectionAssociations |
|
Required Fields for Student
| Required field | Campus Location | Ed-Fi resource.endpoint | Validation Rules |
|---|---|---|---|
| Cohort Year | Graduation > NCLB Cohort End Year. If NCLB Cohort End Year = Null, do not report. | StudentSchoolAssociation.ClassOfSchoolYear | |
| Gender | Demographics > Person Information > Gender | Student.BirthSexDescriptorId | Must be M or F. |
| Grade | Enrollments > General Enrollment Information > Grade | StudentSchoolAssociation.EntryGradeLevelDescriptorID | |
| Ethnicity | Demographics > Person Information > Race/Ethnicity | StudentEducationOrganizationAssociation.HispanicLatinoEthnicity | |
| Race | Demographics > Person Information > Race/Ethnicity | StudentEducationOrganizationAssociationRace.RaceDescriptorId |
CTE Processing Schedule
- The Student Teacher Course (STC) Process must run successfully. This process loads the student teacher course information into AzEDS.
- A daily job in the ODS will run after the AzEDS Integrity processing jobs and sends the successfully processed data onto the CTE data mart.
- The CTE Processing job will complete CTE specific data validation and then output the data on the CTE error report or on the respective CTE tabs in the CTE Data Portal. This job usually runs around 1pm each day.
Note: If all steps run without error, the soonest data can be seen in the CTE Data Portal is after 1pm the day after the data was loaded. For example, if the data was loaded on Monday, the soonest it could be in the CTE Data Portal is 1pm on Tuesday. It can take up to a week to load when there are issues in AzEDS systems then follow-up issues in the ODS data copy to the CTE data mart.
