Classic View: System Administration > Ed-Fi
Search Terms: Ed-FI
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
- Field data map for all fields: Data Mapping
Required Fields for Course
| Required Field/Person Association | Campus Location | Ed-Fi resource.endpoint | Validation Rules |
|---|---|---|---|
| Course Start Date | Scheduling > Courses > Sections > Section > Section Schedule Placement | Session.TermDescriptorid | |
| Course End Date | Scheduling > Courses > Sections > Section > Section Schedule Placement | Session.TermDescriptorid | |
| Term | Scheduling > Courses > Sections > Section > Section Schedule Placement | Session.TermDescriptorid | |
| Period | Scheduling > Courses > Sections > Section > Section Schedule Placement | Section.ClassPeriodName | |
| Site Location | Scheduling > Courses > Course > Location Override OR Scheduling > Courses > Sections > Section > Location Override OR System Administration > Resources > School > Entity ID | Section.SiteLocationSchoolId | |
| CTE Minutes per Week | Scheduling > Courses > Course > CTE Minutes per Week OR Scheduling > Courses > Sections > Section > 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. | Scheduling > Courses > Sections > Section > Staff History | Staffs, multiple endpoints StaffSectionAssociations |
|
| Students must be associated to the course. | Schedule > Courses > Sections > Section > Roster | StudentSectionAssociations |
|
Required Fields for Student
| Required field | Campus Location | Ed-Fi resource.endpoint | Validation Rules |
|---|---|---|---|
| Cohort Year | Student Info > General > Graduation > NCLB Cohort End Year.
| StudentSchoolAssociation.ClassOfSchoolYear | |
| Gender | Census > People > Demographics > Person Information > Gender | Student.BirthSexDescriptorId | Must be M or F. |
| Grade | Student Information > General > Enrollments > General Enrollment Information > Grade | StudentSchoolAssociation.EntryGradeLevelDescriptorID | |
| Ethnicity | Census > People > Demographics > Person Information > Race/Ethnicity | StudentEducationOrganizationAssociation.HispanicLatinoEthnicity | |
| Race | Census > People > 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.
