Tool Search: Ed-Fi
If approval from the state has been received to submit data corrections for past year data, create a CSV file containing all the records that have been sent and how these records should look after data corrections have been made.
The tables below describe important 915 file data with information on the database location, Campus UI location, and Ad hoc location for each of these elements as they exist within Campus. With this information, you can modify and extract data from the database or build the CSV file using the Ad hoc Filter Designer.
For more information about the Filter Designer, see the Create an Ad hoc Filter Using the Query Wizard article.
2022-2023 School Year
The following information only pertains to the 2022-2023 school year.
Students
See the Student Needs Resource for calculated values logic.
| Element | Campus UI and Database Location | Ad hoc Location |
|---|---|---|
| studentUniqueId | Demographics > EdFi ID Person.edFiId | Student > Demographics > edFiID Student > Demographics > Ed Fi ID History > edFiID |
| firstName | Identities > Legal First Name Identity.legalFirstName Identities > First Name identity.firstName | Student > Demographics > firstName Student > Demographics > legalFirstName Student > Demographics > Identity History > firstName Student > Demographics > Identity History > legalFirstName |
| middleName | Identities > Legal Middle Name Identity.legalMiddleName Identities > Middle Name Identity.middleName | Student > Demographics > middleName Student > Demographics > legalMiddleName Student > Demographics > Identity History > middleName Student > Demographics > Identity History > legalMiddleName |
| lastName | Identities > Legal Last Name Identity.legalLastName Identities > Last Name Identity.lastName | Student > Demographics > lastName Student > Demographics > legalLastName Student > Demographics > Identity History > lastName Student > Demographics > Identity History > legalLastName |
| generationCodeSuffix | Identities > Legal Suffix Identity.legalSuffix Identities > Suffix Identity.suffix | Student > Demographics > suffix Student > Demographics > legalSuffix Student > Demographics > Identity History > suffix Student > Demographics > Identity History > legalSuffix |
| birthDate | Identities > Birth Date Identity.birthDate | Student > Demographics > birthdate Student > Demographics > Identity History > birthdate |
| birthSexDescriptor | Identities > Legal Gender Identity.legalGender Identities > Gender Identity.gender | Student > Demographics > gender Student > Demographics > legalGender Student > Demographics > Identity History > gender Student > Demographics > Identity History > legalGender |
| birthCity | Demographics > Birth City Identity.birthCity | N/A |
| birthStateAbbreviationDescriptor | Identities > Birth State Identity.birthState | Student > Demographics > birthState Student > Demographics > Identity History > birthState |
| birthCountryDescriptor | Identities > Birth Country Identity.birthCountry | Student > Demographics > birthCountry Student > Demographics > Identity History > birthCountry |
| dateEnteredUS | Identities > Date Entered US Identity.dateEnteredUS | Student > Demographics > Identity History > dateEnteredUS |
Student School Associations
This includes the following resources:
- studentSchoolAssociationLocalEducationAgency
- studentSchoolAssociationMembershipFTEs
- studentSchoolAssociationSpecialEnrollments
- studentSchoolAssociationTuitionPayers
See the Student School Association Resource for calculated values logic.
When a student is a Summer Withdrawal/No Show, then the studentSchoolAssociations is the only resource that needs to be submitted. There is no need to submit the SSALocalEducationAgency, SSAMembershipFTEs, SSASpecialEnrollments, or SSATuitionPayers resources.
Student School Associations
| Element | Campus UI Location | Ad hoc Location |
|---|---|---|
| exitWithdrawReasonDescriptor | Enrollments > Withdrawal Reason EnrollmentAZ.withdrawalReason | Student > Learner > State Localized Elements > withdrawalReason |
| membershipTypeDescriptor | Enrollments > State Reporting Fields > Local Service Type EnrollmentAZ.localServiceType | Student > Learner > State Localized Elements > localServiceType |
classOfSchoolYearTypeReference schoolYear | Graduation > NCLB Cohort End Year Graduation.cohortYearNCLB | Student > Learner > Graduation elements > cohortYearNCLB |
| entryTypeDescriptor | Enrollments > Start Status Enrollment.startSstatus | Student > Learner > Active Enrollment > Core elements > startStatus |
| exitWithdrawTypeDescriptor | Enrollments > End Status Enrollment.endStatus Enrollments > Graduation (Year End Status) Enrollment.yearEndStatus Enrollments > End Action Enrollment.endAction | Student > Learner > Active Enrollment > Core elements > endStatus Student > Learner > Active Enrollment > State Localized Elements > yearEndStatus Student > Learner > Active Enrollment > Core elements > endAction |
schoolYearTypeReference schoolYear | Calendar Information > End Date Calendar.endYear | Student > School Calendar > End Year |
| entryDate | Enrollments > Start Date Enrollment.startDate | Student > Learner > Active Enrollment > Core elements > startDate |
| entryGradeLevelDescriptor | Enrollments > Grade Enrollment.grade | Student > Learner > Active Enrollment > Core elements > grade |
| exitWithdrawDate | Enrollments> End Date Enrollment.endDate | Student > Learner > Active Enrollment > Core elements > endDate |
schoolReference schoolId | School Information > School > Entity ID School.entityID | Student > School > entityID |
studentReference studentUniqueId | Demographics > EdFi ID Person.edFiID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
calendarReference calendarCode schoolId schoolYear | School Information > Entity ID School.entityID Calendar Information > End Date Calendar.endYear (District Entity ID - School Entity ID - Days per Week - Structure ID) | Student > School > entityID Student > School Calendar > End Year |
Student School Association Local Education Agency
| Element | Campus UI and Database Location | Ad hoc Location |
|---|---|---|
localEducationAgencyReference localEducationAgencyId | Enrollments > Resident District Enrollment.residentDistrict | Student > Learner > Active Enrollment > State Reporting elements > residentDistrict |
| membershipResponsibilityDescriptor | Reports 03. | N/A |
| StartDate | Enrollments > Start Date or Effective Date Enrollment.startDate customStudent.effectiveDate | Student > Learner > Active Enrollment > Core elements > startDate |
| EndDate | Enrollments > End Date or Effective Date Enrollment.endDate customStudent.effectiveDate | Student > Learner > Active Enrollment > Core elements > endDate |
Student School Association Membership FTEs
| Element | Campus UI Location | Ad hoc Location |
|---|---|---|
| fteStartDate | Enrollments > Start Date or Effective Date Enrollment.startDate customStudent.effectiveDate | Student > Learner > Active Enrollment > Core elements > startDate |
| fteEndDate | Enrollments > End Date OR Effective Date Enrollment.endDate customStudent.effectiveDate | Student > Learner > Active Enrollment > Core elements > endDate Value may also be calculated. See documentation to confirm. |
| membershipFTEDescriptor | Enrollments > FTE % Enrollment.percentEnrolled Attribute Dictionary > Enrollment > School Membership FTE > Default Value customStudent.value | Student > Learner > Active Enrollment > State Reporting elements > percentEnrolled Student > Learner > Active Enrollment > Custom Enrollment > percentEnrolled Student > Learner > All Enrollments > School > effectiveDate |
Student School Association Special Enrollment
| Element | Campus UI Location | Ad hoc Location |
|---|---|---|
| specialEnrollmentStartDate | Enrollments > Start Date or Effective Date Enrollment.startDate customStudent.effectiveDate | Student > Learner > Active Enrollment > Core elements > startDate |
| specialEnrollmentEndDate | Enrollments > End Date Enrollment.endDate customStudent.effectiveDate | Student > Learner > Active Enrollment > Core elements > endDate Value may also be calculated. See documentation to confirm. |
| specialEnrollmentDescriptor | Enrollments > Special Enrollment Enrollment.nclbChoice Attribute Dictionary > Enrollment> Special Enrollment > Default Value customStudent.value | Student > Learner > Active Enrollment > State Reporting elements > nclbChoice Student > Learner > Active Enrollment > Custom Enrollment > nclbChoice |
Student School Association Tuition Payers
| Element | Campus UI Location | Ad hoc Location |
|---|---|---|
| payerStartDate | Enrollments > Start Date or Effective Date Enrollment.startDate customStudent.effectiveDate | Student > Learner > Active Enrollment > Core elements > startDate |
| payerEndDate | Enrollments > End Date Enrollment.endDate customStudent.effectiveDate | Student > Learner > Active Enrollment > Core elements > endDate Value may also be calculated. See documentation to confirm. |
| tuitionPayerDescriptor | Enrollments > Tuition Payer Enrollment.stateAid Attribute Dictionary > Enrollment > Tuition Payer > Default Value customStudent.value | Student > Learner > Active Enrollment > State Reporting elements > stateAid Student > Learner > Active Enrollment > Custom Enrollment > stateAid |
Student Needs
See the Student Needs Resource for the population of each of these fields. Depending on the need, a field could be hard coded or the date could be populated based on specific logic.
| Element | Campus UI and Database Location | Ad hoc Location |
|---|---|---|
educationOrganizationReference educationOrganizationId | School Information > Entity ID School.entityID | Student > School > entityID |
studentReference studentUniqueId | Demographics > EdFi ID Person.edFi | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
| studentNeedDescriptor | Flags > Need ProgramParticipation.need Homeless > Start Date, End Date Homeless.startDate Homeless.endDate Title 1 > Title 1 Service Title1.title1Service Eligibility Eligibility Eligibility.eligibility Documents > Plan (locked) > Primary Disability PlanState.disability1 PlanState.disability2 PlanState.disability3 PlanState.disability4 PlanState.disability5 English Learners (EL) > EL Services LEPServiceType.type Gifted > Gifted Need gifted.participation Homeless > Unaccompanied Youth homeless.unaccompaniedYouth | Student > Learner > Programs/Flags > need Student > Learner > Programs/Flags > Programs > need Student > Learner > Homeless > Homeless > startDate/endDate Student > Learner > Title1 > Title1 > title1Service Student > FRAM > Eligibility > eligibility Student > Learner > Active Enrollment > Special Ed elements > disability# --- # = 1, 2, 3, 4, 5, or 6 Student > Learner > Early Learning > serviceType Student > Learner > Gifted > Gifted > participation Student > Learner > Homeless > Homeless > unaccompaniedYouth |
| studentNeedEntryDate | Flags > Start Date ProgramParticipation.startDate Homeless > Start Date Homeless.startDate Title 1 > Start Date Title1.startDate Eligibility record > Start Date Eligibility.startDate Enrollment > Start Date Enrollment.startDate Documents IEP (locked) > IEP Start Date Plan.startDate EL Services > Start Date lepService.startDate Gifted > Start Date Gifted.startDate | Student > Learner > Programs/Flags > startDate Student > Learner > Programs/Flags > Programs > startDate Student > Learner > Homeless > Homeless > startDate Student > Learner > Title1 > Title1 > startDate Student > FRAM > Eligibility > startDate Student > Learner > Active Enrollment > Core elements > startDate Student > Learner Planning > Learning Plans > planStartDate Student > Learner > Early Learning > serviceStartDate Student > Learner > Gifted > Gifted > startDate |
| studentNeedExitDate | Flags > End Date ProgramParticipation.endDate Homeless > End Date Homeless.endDate Title 1 > End Date Title1.endDate Eligibility record > End Date Eligibility.endDate Enrollment > End Date Enrollment.endDate Day Setup > Days Day.date Documents > IEP (locked), Evaluation (locked) > Exit Date Evaluation.exitDate Plan.endDate EL Services > End Date lepServices.endDate Gifted > End Date Gifted.endDate | Student > Learner > Programs/Flags > endDate Student > Learner > Programs/Flags > Programs > endDate Student > Learner > Homeless > Homeless > endDate Student > Learner > Title1 > Title1 > endDate Student > FRAM > Eligibility > endDate Student > Learner > Active Enrollment > Core elements > endDate Student > Learner Planning > Evaluations > exitDate Student > Learner Planning > Learning Plans > planEndDate Student > Learner > Early Learning > serviceEndDate Student > Learner > Gifted > Gifted > endDate |
| primaryStudentNeedIndicator | Documents (locked) > Enrollment Status > Primary, Secondary, Tertiary When the studentNeed is built from PlanState.disability1, value = 'true'; else value = 'false' | Student > Learner > Active Enrollment > Special Ed elements > disability1 |
| primaryNightTimeResidenceDescriptor | Homeless > Primary Nighttime Residence Homeless.primaryNightTimeResidence | Student > Learner > Homeless > Homeless > primary NightTimeResidence |
Student Special Education Program Associations
See the Student Special Education Program Associations Resource for the population of each of these fields.
| Element | Campus UI and Database Location | Ad hoc Location |
|---|---|---|
| beginDate | Documents (locked) > Education Plan > IEP Start Date Plan.startDate Enrollments > Start Date Enrollment.startDate | Student > Learner Planning > Learning Plans > planStartDate Student > Learner > Active Enrollment > Core elements > startDate |
educationOrganizationReference educationOrganizationId | Documents (locked) > Enrollment Status > SPED Funded School School Information > Entity ID School.entityID | Student > School > entityID |
| endDate | Documents > Exit Evaluation > Exit Date (earliest date) ExitEval.exitDate Enrollment > End Date Enrollment.endDate Documents > IEP > Start Date, End Date Plan.startDate Plan.endDate | Student > Learner Planning > Learning Plans > planEndDate Student > Learner Planning > Learning Plans > planStartDate Student > Learner > Active Enrollment > Core elements > endDate |
| reasonExitedDescriptor | Documents > Exit Evaluation > Exit Reason Enrollment > Exit Status When exitEval.exitReason exists, the mapped edFiCode is sent. | This is a calculated field and cannot be retrieved in Ad hoc. |
| specialEducationSettingDescriptor | Documents > Plan > Current Plan > Enrollment Status > Special Ed Setting Plan.specialEdSetting SpecialEdState.specialEdSetting Special Ed > Special Ed Setting Enrollment.specialEdSetting | Student > Learner > Active Enrollment > Special Ed elements > specialEdSetting Student > Learner Planning > Learning Plans > specialEdSetting |
| mainSPEDSchool | Douments > Enrollment Status > SPED Concurrency Type Plan.spedConcurrencyTpe | Student > Learner > State Localized Elements > spedConcurrencyType |
programReference educatioOrganizationId programName programTypeDescriptor | educationOrganizationId: District Information > Entity ID Plan > Enrollment Status > Funded SPED Service DOR customDistrict.attributeID programName: Plan > Enrollment Status > Special Ed Setting Enrollment.specialEdSetting | Student > School > Custom School > districtEntityID |
studentReference studentUniqueId | Demographics > EdFi ID Person.edFiID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
| assessmentCategoryDescriptor | Documents > Evaluation > Assessment Category Evaluation.assessmentCategory | Student > Learner Planning > Evaluations > assessmentCategory |
| assessmentPeriodDescriptor | Documents > Evaluations > Evaluation Type Evaluation.type | Student > Learner Planning > Evaluations > type |
| assessmentOutcomesSummaryDescriptor | Documents > Evaluation > Assessment Outcomes Summary Evaluation.assessmentOutcome | Student > Learner Planning > Evaluations > assessmentOutcome |
Student Education Organization Responsibility Association
See the Student Education Organization Responsibility Association Resource for the population of each of these fields.
| Element | Campus UI and Database Location | Ad hoc Location |
|---|---|---|
| beginDate | Documents > Education Plan > IEP Start Date Plan.startDate Enrollments > Start Date Enrollment.startDate | Student > Learner Planning > Learning Plans > planStartDate Student > Learner > Active Enrollment > Core elements > startDate |
| responsibilityDescriptor | IEP | |
educationOrganizationReference educationOrganizationId | Plan > Enrollment Status > SPED Funded School School Information > Entity ID School.entityID | Student > School > entityID |
studentReference studentUniqueId | Demographics > EdFi ID Person.edFiID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
| endDate | Documents > Evaluation >Exit Evaluation> Exit Date Evaluation.exitDate Enrollments > End Date Enrollment.endDate Documents (locked) > Education Plan > IEP End Date Plan.endDate | Student > Learner Planning > Evaluations > exitDate Student > Learner Planning > Learning Plans > planEndDate Student > Learner > Active Enrollment > Core elements > endDate |
Student Program Associations
See the Student Program Associations Resource for the population of each of these fields. Depending on the program, a field could be hardcoded or the date could be populated based on specific logic.
| Element | Campus UI and Database Location | Ad hoc Location |
|---|---|---|
educationOrganizationReference educationOrganizationId | School Information > Entity ID School.entityID | Student > School > entityID |
programReference educationOrganizationId programName programTypeDescriptor | Program Name Title 1 > Title 1 record > Title 1 Service Title1.title1Service English Learners (EL) > EL Service > Service Type LepService.name Education Organization Id School Information > District Entity ID customSchool.districtEntityID District Information > Entity ID customDistrict.entityID | Program Name is hard coded for some programs so cannot always be retrieved in ad hoc Student > Learner > Programs/Flags > code Student > Learner > Programs/Flags > Programs > code Student > Learner > Title1 > Title1 > title1Service Student > Learner > EL > EL Service > name Student > School > Custom School > districtEntityID Student > District > Custom District > entityID |
studentReference studentUniqueId | Demographics > EdFi ID Person.edFiID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
| beginDate | Flags > Start Date ProgramParticipation.startDate Enrollments > Start Date Enrollment.startDate Title 1 > Start Date Title1.startDate EL Services > Start Date LepService.startDate Gifted > Start Date Gifted.startDate Gifted > No Gifted Program (Resource does not report if this field is checked - a value of 1 in ad hoc) 21st CCLC > Start Date TwentyFirstCCLC.startDate | Student > Learner > Programs/Flags > startDate Student > Learner > Programs/Flags > Programs > startDate Student > Learner > Title1 > Title1 > startDate Student > Learner > Active Enrollment > Core elements > startDate Student > Learner > Early Learning > serviceStartDate Student > Learner > Gifted > Gifted > startDate Student > Learner > Gifted > Gifted > exclude Student > Learner > State programs > TwentyFirstCCLC > startDate |
| endDate | Flags > End Date ProgramParticipation.endDate Enrollments > End Date Enrollment.endDate Title 1 > End Date Title1.endDate EL Services > End Date LepService.endDate Gifted > End Date Gifted.endDate 21st CCLC > End Date TwentyFirstCCLC.endDate | Student > Learner > Programs/Flags > endDate Student > Learner > Programs/Flags > Programs > endDate Student > Learner > Title1 > Title1 > endDate Student > Learner > Active Enrollment > Core elements > endDate Student > Learner > Early Learning > serviceEndDate Student > Learner > Gifted > Gifted > endDate Student > Learner > State Programs > TwentyFirstCCLC > endDate |
| reasonExitedDescriptor | Flags > Exit Reason PorgramParticipation.exitReason Reports the edFiCode mapped to the Exit Reason. EL Services > Exit Reason LepService.exitReason May report differently based on other logic. 21st CCLC > Exit Reason TwentyFirstCCLC.exitReason | LepService.exit reason: Student > Learner > EL > EL Service > exitReason ProgramParticipation.exitReason:
This is a calculated field and cannot easily be retrieved from Ad hoc. Student > Learner > State Programs > TwentyFirstCCLC > exitReason |
Student School Attendance Events
See the Student School Attendance Events Resource for the population of each of these fields. Depending on the program, a field could be hard coded or the date could be populated based on specific logic.
| Element | Campus UI and Database Location | Ad hoc Location |
|---|---|---|
| eventDuration | Sent for EXCUSED_ABSENCE and UNEXCUSED_ABSENCE records only "0.25", "0.5", "0.75" or "1" | This is a calculated field and cannot be retrieved in Ad hoc. |
| attendanceEventCategoryDescriptor | EXCUSED_ABSENCE = "1" UNEXCUSED_ABSENCE = "2" IN_ATTENDANCE = "3" IN ATTENDANCE - DL = "4" ABSENCE - DL = "5" "1", "2", "3", "4", or "5" | This is a calculated field based on the absent code/learning modality code entered for a student and cannot easily be retrieved in Ad hoc. |
| instructionalMinutes | Sent for IN_ATTENDANCE records only, Attendance Type 017 sum(attendanceUnit.units) (period.startTime - period.endTime, (in minutes)) - period.lunchtime - attendanceCode.presentMinutes | Student > Attendance > Positive Attendance Detail > units |
| eventDate | Student Attendance > Date Attendance.date | Student > Attendance > Daily Exact Detail > date |
studentReference studentUniqueId | Demographics > EdFi ID Person.edFiID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
schoolReference schoolId | School Information > Entity ID School.entityID | Student > School > entityID |
sessionReference schoolId schoolYear sessionReference | School Information > Entity ID School.entityID Calendar Informatin > End Date Calendar.endYear | Student > School > entityID Student > School Calendar > End Year |
| ModalityTimeTypeDescriptorId | Sent for Learning Modality records only "Percentage" | This is hardcoded to this value. |
| ModalityTypeDescriptorId | Sent for Learning Modality records only "Remote" | This is hardcoded to this value. |
| ModalityTime | Sent for Learning Modality records only "25", "50", "75", or "100" | This is a calculated field and cannot be retrieved in Ad hoc. |
Student Section Associations
See the Student Section Associations Resource for the population of each of these fields. Depending on the program, a field could be hard coded or the date could be populated based on specific logic.
| Element | Campus UI and Database Location | Ad hoc Location |
|---|---|---|
| beginDate | Schedule > Roster Start Date Roster.startDate Term Setup > Start Date (of term course is in) Terms.startDate | Student > Learner > Schedule > startDate Student > Learner > Schedule > Course/Section > Section Schedule > termStart |
sectionReference localCourseCode schoolId schoolYear sectionIdentifier sessionName | Course Information > Number Course.number School Information > Entity ID School.entityID Calendar Information > End Date Calendar.endYear | Student > Learner > Schedule > Course/Section > courseNumber Student > School > entityID Student > School Calendar > End Year |
studentReference studentUniqueId | Census > People > Demographics > EdFi ID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
| concurrentEnrollment | Course Information > Post Secondary customCourse.value Need to do a join on the following tables to get the correct value: CustomCourse and CampusAttribute Join on attributeId Where CampusAttribute.element is postSecondary and CustomCourse.courseID is the course student is rostered in | Student > Learner > Schedule > Course/Section > Custom Course > postSecondary |
| dualCredit | Course Information > Dual Credit CustomCourse.value Section Information > Dual Credit Roster Batch Edit > Dual Credit Need to do a join on the following tables to get the correct value: CustomCourse and CampusAttribute Join on attributeId Where CampusAttribute.element is dualCredit and CustomCourse.courseID is the course student is rostered in | Student > Learner > Schedule > Course/Section > Custom Course > dualCredit Student > Learner > Schedule > Course/Section > Custom Section> dualCredit |
| endDate | Schedule > Roster End Date Roster.endDate Term Setup > End Date (of term course is in) Terms.endDate | Student > Learner > Schedule > endDate Student > Learner > Schedule > Course/Section > Section Schedule > termEnd |
| courseEntryDescriptor | New Enrollment - N Re-Entry - R Transfer - R "T", "R", or "N" | This is a calculated field based on how a student is scheduled into a course and cannot easily be retrieved in Ad hoc. |
| courseExitDescriptor | Content Complete - Full Credit - CF Content Complete - Partial Credit - CP Content Complete - No Credit/Academic Progress - CN Left the School - LS Open Ended Course - OE Schedule Change - SC "CF", "CP", "CN", "LS", "OE", or "SC" | This is a calculated field based on how a student completed a course and cannot easily be retrieved in Ad hoc. |
Sessions
See the Sessions Resource for the population of each of these fields.
| Element | Campus UI and Database Location | Ad hoc Location |
|---|---|---|
| sessionName | Ed-Fi > Configuration > Resources Preferences > Sessions > Ed-Fi Code EdFiMapping.edFiValue | N/A |
schoolReference schoolId | School Information > Entity ID School.entityID | Course > School > entityID |
schoolYearTypeReference schoolYear | Calendar Information > End Date Calendar.endYear | Course > School Calendar > End Year |
| beginDate | Term Setup > Start Date Term.startDate | N/A |
| endDate | Term Setup > End Date Term.endDate | N/A |
| termDescriptor | Configuration > Resources Preferences > Sessions > Ed-Fi Code EdFiMapping.edFiValue | N/A |
| totalInstructionalDays | Term Setup > Start/End Date of term Day Setup > Day Detail > Instruction | This is a calculated field based on how many instructional days are set up in the calendar for a given term. |
Course Offerings
See the Course Offerings Resource for the population of each of these fields.
| Element | Campus UI and Database Location | Ad hoc Location |
|---|---|---|
| localCourseCode | Course Information > Number Course.number | Course > Course Information > courseNumber |
courseReference courseCode educationOrganizationId | Course Information > State Code Course.stateCode District Information > Entity ID District.entityID | Course > Course Information > stateCode Course > School > Custom School > districtEntityID |
schoolReference schoolId | Section Information > Location Override Course.provider School Information > Entity ID School.entityID | Course > School > entityID |
sessionReference schoolId schoolYear sessionName | School Information > Entity ID School.entityID Calendar Information > End Date Calendar.endYear | Course > School > entityID Course > School Calendar > End Year |
| scheduleDate | Section Information > Section Schedule Placement Term Setup > Start Date | This is populated with every date the course is scheduled to be held so cannot be retrieved from Ad hoc. |
| instructionalMinutesPlanned | Section Information > Section Schedule Placement Term Setup > Start Date Period Setup > Time | This is populated with the total period minutes for each day the course is scheduled and cannot be retrieved from Ad hoc. |
| localCourseTitle | Course Information > Name Course.name | Course > Course Information > courseName |
Class Periods
See the Class Periods Resource for the population of each of these fields.
| Element | Campus UI and Database Location | Ad hoc Location |
|---|---|---|
| classPeriodName | Period Setup > Name Period.name | This field is not in Ad hoc. |
schoolReference schoolId | School Information > Entity ID School.entityID | Course > School > entityID |
| endTime | Period Setup > End Time Period.endTime | Course > Section Information > Section Schedule > Section Schedule > periodEnd |
| startTime | Period Setup > Start Time Period.startTime | Course > Section Information > Section Schedule > Section Schedule > perioStart |
Locations
See the Locations Resource for the population of each of these fields.
| Element | Campus UI Location | Ad hoc Location |
|---|---|---|
| classroomIdentificationCode | Room Setup > Name Room.name | This field is not in Ad hoc. |
schoolReference schoolId | School Information > Entity ID School.entityID | Course > School > entityID |
Sections
See the Sections Resource for the population of each of these fields.
| Element | Campus UI and Database Location | Ad hoc Location |
|---|---|---|
| sectionIdentifier | Section Information >Section ID Section.sectionID | Course > Section Information > sectionID |
courseOfferingreference localCourseCode schoolId schoolYear sessionName | School Information > Entity ID School.entityID Calendar Information > End Date Calendar.endYear | Course > School > entityID Course > School Calendar > endYear |
locationReference classroomIdentificationCode schoolId | Room Setup > Name Room.name School Information > Entity ID School.entityID | Course name is not in Ad hoc Course > School > entityID |
siteLocationSchoolReference classroomIdentificationCode schoolId | Course Information > Location Override Course.provider Section Information > Location Override Section.provider School Information > Entity ID School.entityID | Course > Course Information > provider Course > Section Information > provider Course > School > entityID |
| availableCredits | Course Grading Tasks > Credit GradingTaskCredit.credit | This is a calculated field based on all grading tasks on a course and cannot be retrieved from Ad hoc. |
| courseLevelCharacteristics | Course Information > Level Course.level Course Information > Dual Credit Course.dualCredit Section Information > Dual Credit Section.dualCredit | Course > Course Information > level Course > Course Information > Custom Course > dualCredit Course > Section Information > Custom Section > dualCredit |
| educationalEnvironmentDescriptor | Section Information > Instructional Setting Section.instructionalSetting | Course > Section Information > instructionalSetting |
| offeredGradeLevels | Reports the lowest and the highest grade level of students scheduled in the course section. | This is a calculated field based on students scheduled into a course and cannot be retrieved from Ad hoc. |
| sequenceOfCourse | Defaults to 1. | |
| minutesPerWeek | Section Information > CTE Minutes per Week Override Section.instructionalTime Course Information > CTE Minutes per Week Course.instructionalTime | Course > Course Information > courseInstructionalTime Section > Section Information > sectionInstructionalTime |
Previous School Years
2021-2022 School Year
The following information only pertains to the 2021-2022 school year.
Students
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| studentUniqueId | person.edfiid | Census > People > Demographics > EdFi ID | Student > Demographics > edFiID OR Student > Demographics > Ed Fi ID History > edFiID |
| firstName | identity.legalFirstName OR identity.firstName | Census > People > Identities > Legal First Name OR Census > People > Identities > First Name | Student > Demographics > firstName OR Student > Demographics > legalFirstName Student > Demographics > Identity History > firstName OR Student > Demographics > Identity History > legalFirstName |
| middleName | identity.legalMiddleName OR identity.middleName | Census > People > Identities > Legal Middle Name OR Census > People > Identities > Middle Name | Student > Demographics > middleName OR Student > Demographics > legalMiddleName Student > Demographics > Identity History > middleName OR Student > Demographics > Identity History > legalMiddleName |
| lastName | identity.legalLastName OR identity.lastName | Census > People > Identities > Legal Last Name OR Census > People > Identities > Last Name | Student > Demographics > lastName OR Student > Demographics > legalLastName Student > Demographics > Identity History > lastName OR Student > Demographics > Identity History > legalLastName |
| generationCodeSuffix | identity.legalSuffix OR identity.suffix | Census > People > Identities > Legal Suffix OR Census > People > Identities > Suffix | Student > Demographics > suffix OR Student > Demographics > legalSuffix Student > Demographics > Identity History > suffix OR Student > Demographics > Identity History > legalSuffix |
| birthDate | identity.birthdate | Census > People > Identities > Birth Date | Student > Demographics > birthdate Student > Demographics > Identity History > birthdate |
| birthSexDescriptor | identity.LegalGender or identity.gender | Census > People > Identities > Legal Gender OR Census > People > Identities > Gender | Student > Demographics > gender OR Student > Demographics > legalGender Student > Demographics > Identity History > gender OR Student > Demographics > Identity History > legalGender |
| birthCity | identity.birthcity | Census > People > Demographics > Birth City | Not currently in Ad hoc. |
| birthStateAbbreviationDescriptor | Identity.birthState | Census > People > Identities > Birth State | Student > Demographics > birthState Student > Demographics > Identity History > birthState |
| birthCountryDescriptor | Identity.birthcountry | Census > People > Identities > Birth Country | Student > Demographics > birthCountry Student > Demographics > Identity History > birthCountry |
| dateEnteredUS | identity.dateEnteredUS | Census > People > Identities > Date Entered US | Student > Demographics > Identity History > dateEnteredUS |
Student School Associations
This includes the following resources:
- studentSchoolAssociationLocalEducationAgency
- studentSchoolAssociationMembershipFTEs
- studentSchoolAssociationSpecialEnrollments
- studentSchoolAssociationTuitionPayers
Users should reference the following documentation for the population of calculated fields: Arizona Ed-Fi Data v3.5 - Student School Associations
Note: If a student is a Summer Withdrawal/No Show, then the studentSchoolAssociations is the only resource that needs to be submitted. There is no need to submit the SSALocalEducationAgency, SSAMembershipFTEs, SSASpecialEnrollments, or SSATuitionPayers resources.
Student School Associations
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| exitWithdrawReasonDescriptor | EnrollmentAZ.withdrawalReason | Student Information > General > Enrollments > Withdrawal Reason | Student > Learner > State Localized Elements > withdrawalReason |
| membershipTypeDescriptor | EnrollmentAZ.localServiceType | Student Information > General > Enrollments > State Reporting Fields > Local Service Type | Student > Learner > State Localized Elements > localServiceType |
classOfSchoolYearTypeReference schoolYear | Graduation.cohortYearNCLB | Student Info > General > Graduation > NCLB Cohort End Year | Student > Learner > Graduation elements > cohortYearNCLB |
| entryTypeDescriptor | Enrollment.startSstatus | Student Information > General > Enrollments > Start Status | Student > Learner > Active Enrollment > Core elements > startStatus |
| exitWithdrawTypeDescriptor | Enrollment.endStatus Enrollment.yearEndStatus enrollment.endAction | Student Information > General > Enrollments > End Status Student Information > General > Enrollments > Graduation (Year End Status) Student Information > General > enrollments > End Action | Student > Learner > Active Enrollment > Core elements > endStatus Student > Learner > Active Enrollment > State Localized Elements > yearEndStatus Student > Learner > Active Enrollment > Core elements > endAction |
schoolYearTypeReference schoolYear | Calendar.endYear | Calendar > Calendar > End Date | Student > School Calendar > End Year |
| entryDate | Enrollment.startDate | Student Information > General > Enrollments > Start Date | Student > Learner > Active Enrollment > Core elements > startDate |
| entryGradeLevelDescriptor | Enrollment.grade | Student Information > General > Enrollments > Grade | Student > Learner > Active Enrollment > Core elements > grade |
| exitWithdrawDate | Enrollment.endDate | Student Information> General> Enrollments> End Date | Student > Learner > Active Enrollment > Core elements > endDate |
schoolReference schoolId | School.entityID | System Administration > Resources > School > Entity Id | Student > School > entityID |
studentReference studentUniqueId | Person.edFiID | Census > People > Demographics > EdFi ID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
calendarReference calendarCode schoolId schoolYear | School.entityID Calendar.endYear | System Administration > Resources > School > Entity Id Calendar > Calendar > End Date District Entity Id - School Entity Id - Days per Week - Structure Id | Student > School > entityID Student > School Calendar > End Year |
Student School Association Local Education Agency
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
localEducationAgencyReference localEducationAgencyId | enrollment.residentDistrict | Student Information > General > Enrollments > Resident District | Student > Learner > Active Enrollment > State Reporting elements > residentDistrict |
| membershipResponsibilityDescriptor | Report '03' | ||
| StartDate | Enrollment.startDate OR customStudent.effectiveDate | Student Information > General > Enrollments > Start Date or Effective Date | Student > Learner > Active Enrollment > Core elements > startDate |
| EndDate | Enrollment.endDate OR customStudent.effectiveDate | Student Information > General > Enrollments > End Date or Effective Date | Student > Learner > Active Enrollment > Core elements > endDate |
Student School Association Membership FTEs
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| fteStartDate | Enrollment.startDate OR Customstudent.effectiveDate | Student Information > General > Enrollments > Start Date OR Effective Date | Student > Learner > Active Enrollment > Core elements > startDate |
| fteEndDate | Enrollment.endDate OR Customstudent.effectiveDate | Student Information > General > Enrollments > End Date OR Effective Date | Student > Learner > Active Enrollment > Core elements > endDate Value may also be calculated. See documentation to confirm. |
| membershipFTEDescriptor | Enrollment.percentEnrolled OR Customstudent.value | System Administration > Custom > Attribute Dictionary> Enrollment > School Membership FTE > Default Value OR Student Information > General > Enrollments > FTE % | Student > Learner > Active Enrollment > State Reporting elements > percentEnrolled Student > Learner > Active Enrollment > Custom Enrollment > percentEnrolled Student > Learner > All Enrollments > School > effectiveDate |
Student School Association Special Enrollment
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| specialEnrollmentStartDate | Enrollment.startDate OR CustomStudent.effectiveDate | Student Information > General > Enrollments > Start Date OR Effective Date | Student > Learner > Active Enrollment > Core elements > startDate |
| specialEnrollmentEndDate | Enrollment.endDate OR CustomStudent.effectiveDate | Student Information > General > Enrollments > End Date | Student > Learner > Active Enrollment > Core elements > endDate Value may also be calculated. See documentation to confirm. |
| specialEnrollmentDescriptor | enrollment.nclbChoice OR customstudent.value | System Administration > Custom > Attribute Dictionary > Enrollment> Special Enrollment > Default Value OR Student Information > General > Enrollments > Special Enrollment | Student > Learner > Active Enrollment > State Reporting elements > nclbChoice Student > Learner > Active Enrollment > Custom Enrollment > nclbChoice |
Student School Association Tuition Payers
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| payerStartDate | Enrollment.startDate OR CustomStudent.effectiveDate | Student Information > General > Enrollments > Start Date OR Effective Date | Student > Learner > Active Enrollment > Core elements > startDate |
| payerEndDate | Enrollment.endDate OR CustomStudent.effectiveDate | Student Information > General > Enrollments > End Date | Student > Learner > Active Enrollment > Core elements > endDate Value may also be calculated. See documentation to confirm. |
| tuitionPayerDescriptor | Enrollment.stateAid OR CustomStudent.value | System Administration > Custom > Attribute Dictionary > Enrollment > Tuition Payer > Default Value OR Student Information > General > Enrollments > Tuition Payer | Student > Learner > Active Enrollment > State Reporting elements > stateAid Student > Learner > Active Enrollment > Custom Enrollment > stateAid |
Student Needs
User should reference the following documentation for the population of each of these fields. Depending on the need, a field could be hardcoded or the date could be populated based on specific logic: Arizona Ed-Fi - Student Needs
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
educationOrganizationReference educationOrganizationId | School.entityid | System Administration > Resources > School > Entity ID | Student > School > entityID |
studentReference studentUniqueId | Person.edFiID | Census > People > Demographics > EdFi ID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
| studentNeedDescriptor | ProgramParticipation.need OR Homeless.StartDate/Homeless.EndDate OR Title1.title1Service OR PlanState.disability1 OR PlanState.disability2 PlanState.disability3 PlanState.disability4 PlanState.disability5 OR LEPServiceType.type OR gifted.participation homeless.unaccompaniedYouth | Student Information > General > Flags > Need OR Student Information > Program Participation > Homeless OR Student Information > Program Participation > Title 1 > Title 1 Service OR FRAM > Eligibility > eligibility record > Eligibility OR AZ locked Plan > Enrollment Status > Primary Disability OR Student Information > Program Participation > English Learners (EL) > EL Services OR Student Information > Program Participation > Gifted > Gifted Need OR | Student > Learner > Programs/Flags > need Student > Learner > Programs/Flags > Programs > need Student > Learner > Homeless > Homeless > startDate/endDate Student > Learner > Title1 > Title1 > title1Service Student > FRAM > Eligibility > eligibility Student > Learner > Active Enrollment > Special Ed elements > disability# --- # = 1, 2, 3, 4, 5, or 6 Student > Learner > Early Learning > serviceType Student > Learner > Gifted > Gifted > participation Student > Learner > Homeless > Homeless > unaccompaniedYouth |
| studentNeedEntryDate | ProgramParticipation.StartDate OR Homeless.startDate OR Title1.startDate OR Enrollment.startdate OR Plan.startDate OR lepservice.StartDate OR gifted.StartDate | Student Information > General > Flags > Start Date OR Student Information > Program Participation > Homeless > Start Date OR Student Information > Program Participation > Title 1 > Start Date OR FRAM > Eligibility > eligibility record > Start Date OR Student Information > General > Enrollment Start Date OR AZ locked Plan > Education Plan > IEP Start Date OR Student Information > General> Program Participation > EL > EL Services > Start Date OR Student Information > Program Participation > Gifted > Start Date | Student > Learner > Programs/Flags > startDate Student > Learner > Programs/Flags > Programs > startDate Student > Learner > Homeless > Homeless > startDate Student > Learner > Title1 > Title1 > startDate Student > FRAM > Eligibility > startDate Student > Learner > Active Enrollment > Core elements > startDate Student > Learner Planning > Learning Plans > planStartDate Student > Learner > Early Learning > serviceStartDate Student > Learner > Gifted > Gifted > startDate |
| studentNeedExitDate | ProgramParticipation.EndDate OR Homeless.EndDate OR Title1.endDate OR Enrollment.enddate OR Evaluation.exitDate/Plan.endDate OR lepservice.StartDate OR gifted.EndDate | Student Information > General > Flags > End Date OR Student Information > Program Participation > Homeless > End Date OR Student Information > Program Participation > Title 1 > End Date OR FRAM > Eligibility > eligibility record > End Date OR Student Information > General > Enrollment End Date OR System Administration > Calendar > Calendar> Days OR AZ locked Evaluation > Exit Evaluation > Exit Date OR AZ locked Plan > Education Plan > IEP End Date OR Student Information > General> Program Participation > EL > EL Services > End Date OR Student Information > Program Participation > Gifted > End Date | Student > Learner > Programs/Flags > endDate Student > Learner > Programs/Flags > Programs > endDate Student > Learner > Homeless > Homeless > endDate Student > Learner > Title1 > Title1 > endDate Student > FRAM > Eligibility > endDate Student > Learner > Active Enrollment > Core elements > endDate Student > Learner Planning > Evaluations > exitDate Student > Learner Planning > Learning Plans > planEndDate Student > Learner > Early Learning > serviceEndDate Student > Learner > Gifted > Gifted > endDate |
| primaryStudentNeedIndicator | If studentNeed is built from PlanState.disability1, value = 'true'; else value = 'false' | AZ locked Plan > Enrollment Status > Primary, Secondary, Tertiary | Student > Learner > Active Enrollment > Special Ed elements > disability1 |
| primaryNightTimeResidenceDescriptor | Homeless.primaryNightTimeResidence | Student Information > Program Participation > Homeless > Primary Nighttime Residence | Student > Learner > Homeless > Homeless > primaryNightTimeResidence |
Student Special Education Program Associations
User should reference the following documentation for the population of each of these fields as there is specific logic used in some cases instead of a specific field in Campus: Arizona Ed-Fi - Student Special Education Program Associations
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| beginDate | Plan.startDate OR Enrollment.startDate | AZ locked Plan > Education Plan > IEP Start Date OR Student Information> General > Enrollments > Start Date | Student > Learner Planning > Learning Plans > planStartDate Student > Learner > Active Enrollment > Core elements > startDate |
educationOrganizationReference educationOrganizationId | School.entityid | AZ locked Plan > Enrollment Status > SPED Funded School OR System Administration > Resources > School > Entity ID | Student > School > entityID |
| endDate | Earliest date of ExitEval.exitDate, Enrollment.endDate, Plan.endDate, LastInstructionalDay or calendar. | Student Information> General > SPED > Documents > Exit Evaluation > Exit Date OR Student Information > General > Enrollment > End Date OR IEP End Date OR IEP Start Date | Student > Learner Planning > Learning Plans > planEndDate Student > Learner Planning > Learning Plans > planStartDate Student > Learner > Active Enrollment > Core elements > endDate |
| reasonExitedDescriptor | IF exitEval.exitReason exists - send mapped edFiCode | Student Information > General > SPED > Documents > Exit Evaluation > Exit Reason OR Student Information > General > Enrollment > Exit Status | This is a calculated field and cannot be retrieved in Ad hoc. |
| specialEducationSettingDescriptor | Enrollment.specialEdSetting OR Plan.specialEdSetting OR Specialedstate.specialEdSetting | Student Information > Special Ed > Documents > Plan > Current Plan > Enrollment Status> Special Ed Setting OR Student Information > Special Ed > Special Ed Setting | Student > Learner > Active Enrollment > Special Ed elements > specialEdSetting Student > Learner Planning > Learning Plans > specialEdSetting |
| mainSPEDSchool | Plan.spedConcurrencyType | Plan > Enrollment Status > | Student > Learner > State Localized Elements > spedConcurrencyType |
programReference educatioOrganizationId programName programTypeDescriptor | CustomDistrict.attributeid Enrollment.specialEdSetting 'Special Education' | educationOrganizationId: System Administration > Resources > District Information > Entity ID OR: Plan > Enrollment Status > programName: Plan > Enrollment Status > Special Ed Setting | Student > School > Custom School > districtEntityID |
studentReference studentUniqueId | Person.edFiID | Census > People > Demographics > EdFi ID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
| assessmentCategoryDescriptor | Evaluation.assessmentCategory | Student Information > SPED > General > Documents > Evaluation > Assessment Category | Student > Learner Planning > Evaluations > assessmentCategory |
| assessmentPeriodDescriptor | Evaluation.type | Student Information > SPED > General > Documents > Evaluations > Evaluation Type | Student > Learner Planning > Evaluations > type |
| assessmentOutcomesSummaryDescriptor | Evaluation.assessmentOutcome | Student Information > SPED > General > Documents > Evaluation > Assessment Outcomes Summary | Student > Learner Planning > Evaluations > assessmentOutcome |
Student Education Organization Responsibility Association
User should reference the following documentation for the population of each of these fields as there is specific logic used in some cases instead of a specific field in Campus: Arizona Ed-Fi - Student Education Organization Responsibility Association
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| beginDate | Plan.startDate OR enrollment.startdate | AZ locked Plan > Education Plan > IEP Start Date OR Student Information> General> Enrollments> Start Date | Student > Learner Planning > Learning Plans > planStartDate Student > Learner > Active Enrollment > Core elements > startDate |
| responsibilityDescriptor | "IEP" | ||
educationOrganizationReference educationOrganizationId | school.entityId | AZ locked Plan > Enrollment Status > SPED Funded School OR System Administration > Resources > School > Entity ID | Student > School > entityID |
studentReference studentUniqueId | Person.edFiID | Census > People > Demographics > EdFi ID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
| endDate | Evaluation.exitDate OR plan.endDate | AZ locked Evaluation>Exit Evaluation> Exit Date OR Student Information> General> Enrollments> End Date OR AZ locked Plan > Education Plan > IEP End Date | Student > Learner Planning > Evaluations > exitDate Student > Learner Planning > Learning Plans > planEndDate Student > Learner > Active Enrollment > Core elements > endDate |
Student Program Associations
User should reference the following documentation for the population of each of these fields. Depending on the program, a field could be hardcoded or the date could be populated based on specific logic: Arizona Ed-Fi - Student Program Associations
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
educationOrganizationReference educationOrganizationId | School.entityid | System Administration > Resources > School > Entity ID | Student > School > entityID |
programReference educationOrganizationId programName programTypeDescriptor | Program.code LepService.name Title1.title1Service CustomSchool.districtEntityID OR CustomDistrict.entityID | Program Name Programs Participation > Title 1 > Title 1 record > Title 1 Service Programs Participation > English Learners (EL) > EL Service > Service Type Education Organization Id System Administration > Resources > Resources > School Editor > District Entity ID OR System Administration > Resources > Resources > District Information > Entity ID | Program Name is hardcoded for some programs so cannot always be retrieved in ad hoc Student > Learner > Programs/Flags > code Student > Learner > Programs/Flags > Programs > code Student > Learner > Title1 > Title1 > title1Service Student > Learner > EL > EL Service > name Student > School > Custom School > districtEntityID Student > District > Custom District > entityID |
studentReference studentUniqueId | Person.edFiID | Census > People > Demographics > EdFi ID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
| beginDate | ProgramParticipation.startDate OR LepService.startDate OR Enrollment.startDate OR Gifted.startDate/Gifted.exclude OR twentyFirstCCLC.startDate | Student Information > General > Flags > Start Date OR Enrollment Start Date OR Programs Participation > Title 1 > Title 1 record > Start Date OR Student Information > Program Participation > EL > EL Services > Start Date OR Student Information > Program Participation > Gifted > Start Date Student Information > Program Participation > Gifted > No Gifted Program (Resource does not report if this field is checked - a value of 1 in ad hoc) OR Student Information > Program Participation > State Programs > 21st CCLC > Start Date | Student > Learner > Programs/Flags > startDate Student > Learner > Programs/Flags > Programs > startDate Student > Learner > Title1 > Title1 > startDate Student > Learner > Active Enrollment > Core elements > startDate Student > Learner > Early Learning > serviceStartDate Student > Learner > Gifted > Gifted > startDate Student > Learner > Gifted > Gifted > exclude Student > Learner > State programs > TwentyFirstCCLC > startDate |
| endDate | ProgramParticipation.EndDate OR LepDervice.EndDate OR Enrollment.endDate OR Gifted.endDate OR twentyFirstCCLC.endDate | Student Information > General > Flags > End Date OR Student Information > General > Enrollment End Date OR Programs Participation > Title 1 > Title 1 record > End Date OR Student Information > General > Program Participation > EL > EL Services > End Date OR Student Information > Program Participation > Gifted > End Date OR Student Information > Program Participation > State Programs > 21st CCLC > End Date | Student > Learner > Programs/Flags > endDate Student > Learner > Programs/Flags > Programs > endDate Student > Learner > Title1 > Title1 > endDate Student > Learner > Active Enrollment > Core elements > endDate Student > Learner > Early Learning > serviceEndDate Student > Learner > Gifted > Gifted > endDate Student > Learner > State Programs > TwentyFirstCCLC > endDate |
| reasonExitedDescriptor | For LEP:
For ProgramParticipation:
twentyFirstCCLC.exitReason | Student Information > General > Flags > Exit Reason Student Information > General > Program Participation > EL > EL Services > Exit Reason Student Information > Program Participation > State Programs > 21st CCLC > Exit Reason | LepService.exit reason: Student > Learner > EL > EL Service > exitReason ProgramParticipation.exitReason:
Note: This is a calculated field and cannot easily be retrieved from Ad hoc Student > Learner > State Programs > TwentyFirstCCLC > exitReason |
Student School Attendance Events
User should reference the following documentation for the population of each of these fields as there is specific logic used in some cases instead of a specific field in Campus: Arizona Ed-Fi - Student School Attendance Events
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| eventDuration | "0.25", "0.5", "0.75" or "1" | Sent for EXCUSED_ABSENCE and UNEXCUSED_ABSENCE records only | This is a calculated field and cannot be retrieved in Ad hoc |
| attendanceEventCategoryDescriptor | "1", "2", "3", "4", or "5" | EXCUSED_ABSENCE = "1" UNEXCUSED_ABSENCE = "2" IN_ATTENDANCE = "3" IN ATTENDANCE - DL = "4" ABSENCE - DL = "5" | This is a calculated field based on the absent code/learning modality code entered for a student and cannot easily be retrieved in Ad hoc |
| instructionalMinutes | sum(attendanceUnit.units) OR (period.startTime - period.endTime, (in minutes)) - period.lunchtime - attendanceCode.presentMinutes | Sent for IN_ATTENDANCE records only, Attendance Type 017 | Student > Attendance > Positive Attendance Detail > units |
| eventDate | Attendance.date | Student Information > General > Attendance > Date | Student > Attendance > Daily Exact Detail > date |
studentReference studentUniqueId | Person.edFiID | Census > People > Demographics > EdFi ID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
schoolReference schoolId | School.entityID | System Administration > Resources > School > Entity Id | Student > School > entityID |
sessionReference schoolId schoolYear sessionReference | School.entityID Calendar.endYear | System Administration > Resources > School > Entity Id Calendar > Calendar > End Date | Student > School > entityID Student > School Calendar > End Year |
| ModalityTimeTypeDescriptorId | "Percentage" | Sent for Learning Modality records only | This is hardcoded to this value. |
| ModalityTypeDescriptorId | "Remote" | Sent for Learning Modality records only | This is hardcoded to this value. |
| ModalityTime | "25", "50", "75", or "100" | Sent for Learning Modality records only | This is a calculated field and cannot be retrieved in Ad hoc. |
Student Section Associations
User should reference the following documentation for the population of calculated fields: Arizona Ed-Fi - Student Section Associations
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| beginDate | roster.startDate OR terms.startDate | Student Information > General > Schedule > Roster Start Date OR System Administration > Calendar > Calendar > Terms > Start Date (of term course is in) | Student > Learner > Schedule > startDate Student > Learner > Schedule > Course/Section > Section Schedule > termStart |
sectionReference localCourseCode schoolId schoolYear sectionIdentifier sessionName | Course.number School.entityID Calendar.endYear | Scheduling > Course > Number System Administration > Resources > School > Entity Id Calendar > Calendar > End Date | Student > Learner > Schedule > Course/Section > courseNumber Student > School > entityID Student > School Calendar > End Year |
studentReference studentUniqueId | Person.edFiID | Census > People > Demographics > EdFi ID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
| concurrentEnrollment | CustomCourse.value Need to do a join on the following tables to get the correct value: CustomCourse and CampusAttribute Join on attributeId Where CampusAttribute.element is postSecondary and CustomCourse.courseID is the course student is rostered in | Scheduling > Course > Post Secondary | Student > Learner > Schedule > Course/Section > Custom Course > postSecondary |
| dualCredit | CustomCourse.value Need to do a join on the following tables to get the correct value: CustomCourse and CampusAttribute Join on attributeId Where CampusAttribute.element is dualCredit and CustomCourse.courseID is the course student is rostered in | Scheduling > Course > Dual Credit Scheduling > Course > Section > Dual Credit Scheduling > Course > Section> Roster Batch Edit > Dual Credit | Student > Learner > Schedule > Course/Section > Custom Course > dualCredit Student > Learner > Schedule > Course/Section > Custom Section> dualCredit |
| endDate | Roster.endDate OR Terms.endDate | Student Information > General > Schedule > Roster End Date OR System Administration > Calendar > Calendar > Terms > End Date (of term course is in) | Student > Learner > Schedule > endDate Student > Learner > Schedule > Course/Section > Section Schedule > termEnd |
| courseEntryDescriptor | "T", "R", or "N" | New Enrollment - N Re-Entry - R Transfer - R | This is a calculated field based on how a student is rostered into a course and cannot easily be retrieved in Ad hoc. |
| courseExitDescriptor | "CF", "CP", "CN", "LS", "OE", or "SC" | Content Complete - Full Credit - CF Content Complete - Partial Credit - CP Content Complete - No Credit/Academic Progress - CN Left the School - LS Open Ended Course - OE Schedule Change - SC | This is a calculated field based on how a student completed a course and cannot easily be retrieved in Ad hoc. |
Course Transcripts
User should reference the following documentation for the population of calculated fields: Arizona Ed-Fi - Course Transcripts
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| courseAttemptResultDescriptor | Reports 'Pass', 'Fail', or 'Incomplete' TranscriptCredit.creditsAttempted AND TranscriptCredit.creditsEarned | Student Information > General > Transcripts > Earned AND Student Information > General > Transcripts > Attempted | This is a calculated field based on either the student's grade or the students credits and cannot easily be retrieved in Ad hoc. These fields may be helpful: Student > Grading > Grading Detail> passingScore Student > Grading > Grading Detail > credit |
courseReference courseCode educationOrganizationId | Course.stateCode District.entityID | Scheduling > Course > State Code System Administration > Resources > District Information > Entity Id | Student > Learner > Schedule > Course/Section > stateCode Student > School > Custom School > districtEntityID |
studentAcademicRecordReference educationOrganizationId schoolYear studentUniqueId termDescriptor | School.entityID Calendar.endYear Person.edFiID | System Administration > Resources > School > Entity Id Calendar > Calendar > End Date Census > People > Demographics > EdFi ID | Student > School > entityID Student > School Calendar > End Year Student > Demographics > edFiID |
| alternativeCourseCode | TranscriptCourse.courseNumber | Student Information > General > Transcripts > Course Number | Student > Grading > Grading Detail > courseNumber |
| alternativeCourseTitle | TranscriptCourse.courseName | Student Information > General > Transcripts > Course Name | Student > Grading > Grading Detail > courseName |
| attemptedCredits | TranscriptCredit.creditsAttempted | Student Information > General > Transcripts > Attempted | Student > Grading > Grading Detail > credit |
| courseTitle | TranscriptCourse.courseName | Student Information > General > Transcripts > Course Name | Student > Grading > Grading Detail > courseName |
| earnedCredits | TranscriptCredit.creditsEarned | Student Information > General > Transcripts > Earned | This is a calculated field and cannot be retrieved in Ad hoc |
| finalLetterGradeEarned | TranscriptCourse.score | Student Information > General > Transcripts > Current Score OR Score > Name | Student > Grading > Grading Detail > score |
| whenTakenGradeLevelDescriptor | Enrollment.grade | Student Information > General > Enrollments > Grade | Student > Learner > Active Enrollment > Core elements > grade |
| finalLetterGradeDescriptor | TranscriptCourse.score | Student Information > General > Transcripts > Current Score OR Score > Name | This field uses the student's score and maps it to an Ed-Fi grade descriptor stored in the resource preferences so it cannot be easily retrieved in Ad hoc. Student > Grading > Grading Detail > score |
Sessions
User should reference the following documentation for the population of calculated fields: Arizona Ed-Fi - Sessions
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| sessionName | EdFiMapping.edFiValue | System Administration > Ed-Fi > Configuration > Resources Preferences > Sessions > Ed-Fi Code | This field is not in Ad hoc. |
schoolReference schoolId | School.entityID | System Administration > Resources > School > Entity ID | Course > School > entityID |
schoolYearTypeReference schoolYear | Calendar.endYear | Calendar > Calendar > End Date | Course > School Calendar > End Year |
| beginDate | Term.startDate | System Administration > Calendar > Calendar > Terms > Start Date | This field is not in Ad hoc. |
| endDate | Term.endDate | System Administration > Calendar > Calendar > Terms > End Date | This field is not in Ad hoc. |
| termDescriptor | EdFiMapping.edFiValue | System Administration > Ed-Fi > Configuration > Resources Preferences > Sessions > Ed-Fi Code | This field is not in Ad hoc. |
| totalInstructionalDays | System Administration > Calendar > Calendars > Term Setup > Start/End Date of term System Administration > Calendar > Calendars > Days | This is a calculated field based on how many instructional days are set up in the calendar for a given term. |
Course Offerings
User should reference the following documentation for the population of calculated fields: Arizona Ed-Fi - Course Offerings
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| localCourseCode | Course.number | Scheduling > Course > Number | Course > Course Information > courseNumber |
courseReference courseCode educationOrganizationId | Course.stateCode District.entityID | Scheduling > Course > State Code System Administration > Resources > District Information > Entity Id | Course > Course Information > stateCode Course > School > Custom School > districtEntityID |
schoolReference schoolId | Course.provider School.entityID | Course > Location Override Course > Section > Location Override System Administration > Resources > School > Entity Id | Course > School > entityID |
sessionReference schoolId schoolYear sessionName | School.entityID Calendar.endYear | System Administration > Resources > School > Entity Id Calendar > Calendar > End Date | Course > School > entityID Course > School Calendar > End Year |
| scheduleDate | Course > Section > Section Schedule Placement System Administration > Calendar > Calendar > Terms > Start Date | This is populated with every date the course is scheduled to be held so cannot be retrieved from Ad hoc. | |
| instructionalMinutesPlanned | Course > Section > Section Schedule Placement System Administration > Calendar > Calendar > Terms > Start Date System Administration > Calendar > Calendar > Periods | This is populated with the total period minutes for each day the course is scheduled and cannot be retrieved from Ad hoc. | |
| localCourseTitle | Course.name | Scheduling > Course > Name | Course > Course Information > courseName |
Class Periods
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| classPeriodName | Period.name | System Administration > Calendar > Calendar > Periods > Name | This field is not in Ad hoc |
schoolReference schoolId | School.entityID | System Administration > Resources > School > Entity ID | Course > School > entityID |
| endTime | Period.endTime | System Administration > Calendar > Calendar > Periods > End Time | Course > Section Information > Section Schedule > Section Schedule > periodEnd |
| startTime | Period.startTime | System Administration > Calendar > Calendar > Periods > Start Time | Course > Section Information > Section Schedule > Section Schedule > perioStart |
Locations
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| classroomIdentificationCode | Room.name | System Administration> Resources> Resources> Rooms > Name | This field is not in Ad hoc |
schoolReference schoolId | School.entityID | System Administration > Resources > School > Entity ID | Course > School > entityID |
Sections
User should reference the following documentation for the population of calculated fields: Arizona Ed-Fi - Sections
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| sectionIdentifier | Section.sectionID | Scheduling > Courses > Sections >Section Id | Course > Section Information > sectionID |
courseOfferingreference localCourseCode schoolId schoolYear sessionName | School.entityID Calendar.endYear | System Administration > Resources > School > Entity Id Calendar > Calendar > End Date | Course > School > entityID Course > School Calendar > endYear |
locationReference classroomIdentificationCode schoolId | Room.name School.entityId | System Administration > Resources > Resources > Rooms > Name System Administration> Resources> School> Entity ID | Course name is not in Ad hoc Course > School > entityID |
siteLocationSchoolReference classroomIdentificationCode schoolId | Course.provider Section.provider School.entityID | Scheduling > Courses > Location Override Scheduling > Courses > Sections > Location Override System Administration > Resources > School > entityID | Course > Course Information > provider Course > Section Information > provider Course > School > entityID |
| availableCredits | GradingTaskCredit.credit | Scheduling > Course > Grading Tasks > Credit | This is a calculated field based on all grading tasks on a course and cannot be retrieved from Ad hoc. |
| courseLevelCharacteristics | Course.level Course.dualCredit Section.dualCredit | Scheduling > Courses > Level Scheduling > Courses > Dual Credit Scheduling > Courses > Sections > Dual Credit | Course > Course Information > level Course > Course Information > Custom Course > dualCredit Course > Section Information > Custom Section > dualCredit |
| educationalEnvironmentDescriptor | Section.instructionalSetting | Scheduling > Courses > Sections > Instructional Setting | Course > Section Information > instructionalSetting |
| offeredGradeLevels | Reports the lowest and the highest grade level of students scheduled in the course section | This is a calculated field based on students rostered into a course and cannot be retrieved from Ad hoc. | |
| sequenceOfCourse | Defaulted to 1 | ||
| minutesPerWeek | Course.instructionalTime OR Section.instructionalTime | Course > Section > CTE Minutes per Week Override OR Course > CTE Minutes per Week | Course > Course Information > courseInstructionalTime Section > Section Information > sectionInstructionalTime |
2020-2021 School Year
The following information only pertains to the 2020-2021 school year.
Students
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| studentUniqueId | person.edfiid | Census > People > Demographics > EdFi ID | Student > Demographics > edFiID OR Student > Demographics > Ed Fi ID History > edFiID |
| firstName | identity.legalFirstName OR identity.firstName | Census > People > Identities > Legal First Name OR Census > People > Identities > First Name | Student > Demographics > firstName OR Student > Demographics > legalFirstName Student > Demographics > Identity History > firstName OR Student > Demographics > Identity History > legalFirstName |
| middleName | identity.legalMiddleName OR identity.middleName | Census > People > Identities > Legal Middle Name OR Census > People > Identities > Middle Name | Student > Demographics > middleName OR Student > Demographics > legalMiddleName Student > Demographics > Identity History > middleName OR Student > Demographics > Identity History > legalMiddleName |
| lastName | identity.legalLastName OR identity.lastName | Census > People > Identities > Legal Last Name OR Census > People > Identities > Last Name | Student > Demographics > lastName OR Student > Demographics > legalLastName Student > Demographics > Identity History > lastName OR Student > Demographics > Identity History > legalLastName |
| generationCodeSuffix | identity.legalSuffix OR identity.suffix | Census > People > Identities > Legal Suffix OR Census > People > Identities > Suffix | Student > Demographics > suffix OR Student > Demographics > legalSuffix Student > Demographics > Identity History > suffix OR Student > Demographics > Identity History > legalSuffix |
| birthDate | identity.birthdate | Census > People > Identities > Birth Date | Student > Demographics > birthdate Student > Demographics > Identity History > birthdate |
| birthSexDescriptor | identity.LegalGender or identity.gender | Census > People > Identities > Legal Gender OR Census > People > Identities > Gender | Student > Demographics > gender OR Student > Demographics > legalGender Student > Demographics > Identity History > gender OR Student > Demographics > Identity History > legalGender |
| birthCity | identity.birthcity | Census > People > Demographics > Birth City | Not currently in Ad hoc |
| birthStateAbbreviationDescriptor | Identity.birthState | Census > People > Identities > Birth State | Student > Demographics > birthState Student > Demographics > Identity History > birthState |
| birthCountryDescriptor | Identity.birthcountry | Census > People > Identities > Birth Country | Student > Demographics > birthCountry Student > Demographics > Identity History > birthCountry |
| dateEnteredUS | identity.dateEnteredUS | Census > People > Identities > Date Entered US | Student > Demographics > Identity History > dateEnteredUS |
Student School Associations
This includes the following resources
- studentSchoolAssociationLocalEducationAgency
- studentSchoolAssociationMembershipFTEs
- studentSchoolAssociationSpecialEnrollments
- studentSchoolAssociationTuitionPayers
Users should reference the following documentation for the population of calculated fields: Arizona Ed-Fi - Student School Association Resource
Note: If a student is a Summer Withdrawal/No Show, then the studentSchoolAssociations is the only resource that needs to be submitted. There is no need to submit the SSALocalEducationAgency, SSAMembershipFTEs, SSASpecialEnrollments, or SSATuitionPayers resources.
Student School Associations
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| exitWithdrawReasonDescriptor | EnrollmentAZ.withdrawalReason | Student Information > General > Enrollments > Withdrawal Reason | Student > Learner > State Localized Elements > withdrawalReason |
| membershipTypeDescriptor | EnrollmentAZ.localServiceType | Student Information > General > Enrollments > State Reporting Fields > Local Service Type | Student > Learner > State Localized Elements > localServiceType |
classOfSchoolYearTypeReference schoolYear | Graduation.cohortYearNCLB | Student Info > General > Graduation > NCLB Cohort End Year | Student > Learner > Graduation elements > cohortYearNCLB |
| entryTypeDescriptor | Enrollment.startSstatus | Student Information > General > Enrollments > Start Status | Student > Learner > Active Enrollment > Core elements > startStatus |
| exitWithdrawTypeDescriptor | Enrollment.endStatus Enrollment.yearEndStatus enrollment.endAction | Student Information > General > Enrollments > End Status Student Information > General > Enrollments > Graduation (Year End Status) Student Information > General > enrollments > End Action | Student > Learner > Active Enrollment > Core elements > endStatus Student > Learner > Active Enrollment > State Localized Elements > yearEndStatus Student > Learner > Active Enrollment > Core elements > endAction |
schoolYearTypeReference schoolYear | Calendar.endYear | Calendar > Calendar > End Date | Student > School Calendar > End Year |
| entryDate | Enrollment.startDate | Student Information > General > Enrollments > Start Date | Student > Learner > Active Enrollment > Core elements > startDate |
| entryGradeLevelDescriptor | Enrollment.grade | Student Information > General > Enrollments > Grade | Student > Learner > Active Enrollment > Core elements > grade |
| exitWithdrawDate | Enrollment.endDate | Student Information> General> Enrollments> End Date | Student > Learner > Active Enrollment > Core elements > endDate |
schoolReference schoolId | School.entityID | System Administration > Resources > School > Entity Id | Student > School > entityID |
studentReference studentUniqueId | Person.edFiID | Census > People > Demographics > EdFi ID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
calendarReference calendarCode schoolId schoolYear | School.entityID Calendar.endYear | System Administration > Resources > School > Entity Id Calendar > Calendar > End Date District Entity Id - School Entity Id - Days per Week - Structure Id | Student > School > entityID Student > School Calendar > End Year |
Student School Association Local Education Agency
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
localEducationAgencyReference localEducationAgencyId | enrollment.residentDistrict | Student Information > General > Enrollments > Resident District | Student > Learner > Active Enrollment > State Reporting elements > residentDistrict |
| membershipResponsibilityDescriptor | Report '03' | ||
| StartDate | Enrollment.startDate OR customStudent.effectiveDate | Student Information > General > Enrollments > Start Date or Effective Date | Student > Learner > Active Enrollment > Core elements > startDate |
| EndDate | Enrollment.endDate OR customStudent.effectiveDate | Student Information > General > Enrollments > End Date or Effective Date | Student > Learner > Active Enrollment > Core elements > endDate |
Student School Association Membership FTEs
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| fteStartDate | Enrollment.startDate OR Customstudent.effectiveDate | Student Information > General > Enrollments > Start Date OR Effective Date | Student > Learner > Active Enrollment > Core elements > startDate |
| fteEndDate | Enrollment.endDate OR Customstudent.effectiveDate | Student Information > General > Enrollments > End Date OR Effective Date | Student > Learner > Active Enrollment > Core elements > endDate Value may also be calculated. See documentation to confirm. |
| membershipFTEDescriptor | Enrollment.percentEnrolled OR Customstudent.value | System Administration > Custom > Attribute Dictionary> Enrollment > School Membership FTE > Default Value OR Student Information > General > Enrollments > FTE % | Student > Learner > Active Enrollment > State Reporting elements > percentEnrolled Student > Learner > Active Enrollment > Custom Enrollment > percentEnrolled Student > Learner > All Enrollments > School > effectiveDate |
Student School Association Special Enrollment
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| specialEnrollmentStartDate | Enrollment.startDate OR CustomStudent.effectiveDate | Student Information > General > Enrollments > Start Date OR Effective Date | Student > Learner > Active Enrollment > Core elements > startDate |
| specialEnrollmentEndDate | Enrollment.endDate OR CustomStudent.effectiveDate | Student Information > General > Enrollments > End Date | Student > Learner > Active Enrollment > Core elements > endDate Value may also be calculated. See documentation to confirm. |
| specialEnrollmentDescriptor | enrollment.nclbChoice OR customstudent.value | System Administration > Custom > Attribute Dictionary > Enrollment> Special Enrollment > Default Value OR Student Information > General > Enrollments > Special Enrollment | Student > Learner > Active Enrollment > State Reporting elements > nclbChoice Student > Learner > Active Enrollment > Custom Enrollment > nclbChoice |
Student School Association Tuition Payers
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| payerStartDate | Enrollment.startDate OR CustomStudent.effectiveDate | Student Information > General > Enrollments > Start Date OR Effective Date | Student > Learner > Active Enrollment > Core elements > startDate |
| payerEndDate | Enrollment.endDate OR CustomStudent.effectiveDate | Student Information > General > Enrollments > End Date | Student > Learner > Active Enrollment > Core elements > endDate Value may also be calculated. See documentation to confirm. |
| tuitionPayerDescriptor | Enrollment.stateAid OR CustomStudent.value | System Administration > Custom > Attribute Dictionary > Enrollment > Tuition Payer > Default Value OR Student Information > General > Enrollments > Tuition Payer | Student > Learner > Active Enrollment > State Reporting elements > stateAid Student > Learner > Active Enrollment > Custom Enrollment > stateAid |
Student Needs
Users should reference the following documentation for the population of each of these fields. Depending on the need, a field could be hard-coded or the date could be populated based on specific logic: Arizona Ed-Fi - Student Needs Resource
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
educationOrganizationReference educationOrganizationId | School.entityid | System Administration > Resources > School > Entity ID | Student > School > entityID |
studentReference studentUniqueId | Person.edFiID | Census > People > Demographics > EdFi ID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
| studentNeedDescriptor | ProgramParticipation.need OR ic_Homeless.StartDate/Homeless.EndDate OR ic_Title1.title1Services OR PlanState.disability1 OR PlanState.disability2 PlanState.disability3 PlanState.disability4 PlanState.disability5 OR LEPServiceType.type | Student Information > General > Flags > Need OR Student Information > Program Participation > Homeless OR Student Information > Program Participation > Title 1 > Title 1 Service OR FRAM > Eligibility > eligibility record > Eligibility OR AZ locked Plan > Enrollment Status > Primary Disability OR Student Information > Program Participation > English Learners (EL) > EL Services | Student > Learner > Programs/Flags > need Student > Learner > Programs/Flags > Programs > need Student > Learner > Homeless > Homeless > startDate/endDate Student > Learner > Title1 > Title1 > title1Service Student > FRAM > Eligibility > eligibility Student > Learner > Active Enrollment > Special Ed elements > disability# --- # = 1, 2, 3, 4, 5, or 6 Student > Learner > Early Learning > serviceType |
| studentNeedEntryDate | ProgramParticipation.StartDate OR ic_Homeless.startDate OR Title1.startDate OR Enrollment.startdate OR Plan.startDate OR lepservice.StartDate | Student Information > General > Flags > Start Date OR Student Information > Program Participation > Homeless > Start Date OR Student Information > Program Participation > Title 1 > Start Date OR FRAM > Eligibility > eligibility record > Start Date OR Student Information > General > Enrollment Start Date OR AZ locked Plan > Education Plan > IEP Start Date OR Student Information > General> Program Participation > EL > EL Services > Start Date | Student > Learner > Programs/Flags > startDate Student > Learner > Programs/Flags > Programs > startDate Student > Learner > Homeless > Homeless > startDate Student > Learner > Title1 > Title1 > startDate Student > FRAM > Eligibility > startDate Student > Learner > Active Enrollment > Core elements > startDate Student > Learner Planning > Learning Plans > planStartDate Student > Learner > Early Learning > serviceStartDate |
| studentNeedExitDate | ProgramParticipation.EndDate OR ic_Homeless.EndDate OR Title1.endDate OR Enrollment.enddate OR Evaluation.exitDate/Plan.endDate OR lepservice.StartDate | Student Information > General > Flags > End Date OR Student Information > Program Participation > Homeless > End Date OR Student Information > Program Participation > Title 1 > End Date OR FRAM > Eligibility > eligibility record > End Date OR Student Information > General > Enrollment End Date OR System Administration > Calendar > Calendar> Days OR AZ locked Evaluation > Exit Evaluation > Exit Date OR AZ locked Plan > Education Plan > IEP End Date OR Student Information > General> Program Participation > EL > EL Services > End Date | Student > Learner > Programs/Flags > endDate Student > Learner > Programs/Flags > Programs > endDate Student > Learner > Homeless > Homeless > endDate Student > Learner > Title1 > Title1 > endDate Student > FRAM > Eligibility > endDate Student > Learner > Active Enrollment > Core elements > endDate Student > Learner Planning > Evaluations > exitDate Student > Learner Planning > Learning Plans > planEndDate Student > Learner > Early Learning > serviceEndDate |
| primaryStudentNeedIndicator | If studentNeed is built from PlanState.disability1, value = 'true'; else value = 'false' | AZ locked Plan > Enrollment Status > Primary, Secondary, Tertiary | Student > Learner > Active Enrollment > Special Ed elements > disability1 |
| primaryNightTimeResidenceDescriptor | ic_Homeless.primaryNightTimeResidence | Student Information > Program Participation > Homeless > Primary Nighttime Residence | Student > Learner > Homeless > Homeless > primaryNightTimeResidence |
Student Special Education Program Associations
Users should reference the following documentation for the population of each of these fields as there is specific logic used in some cases instead of a specific field in Campus: Arizona Ed-Fi - Student Special Education Program Associations
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| beginDate | Plan.startDate OR Enrollment.startDate | AZ locked Plan > Education Plan > IEP Start Date OR Student Information> General > Enrollments > Start Date | Student > Learner Planning > Learning Plans > planStartDate Student > Learner > Active Enrollment > Core elements > startDate |
educationOrganizationReference educationOrganizationId | School.entityid | System Administration > Resources > School > Entity ID | Student > School > entityID |
| endDate | Earliest date of ExitEval.exitDate, Enrollment.endDate, Plan.endDate, LastInstructionalDay or calendar. | Student Information> General > SPED > Documents > Exit Evaluation > Exit Date OR Student Information > General > Enrollment > End Date OR IEP End Date OR IEP Start Date | Student > Learner Planning > Learning Plans > planEndDate Student > Learner Planning > Learning Plans > planStartDate Student > Learner > Active Enrollment > Core elements > endDate |
| reasonExitedDescriptor | IF exitEval.exitReason exists - send mapped edFiCode | Student Information > General > SPED > Documents > Exit Evaluation > Exit Reason OR Student Information > General > Enrollment > Exit Status | This is a calculated field and cannot be retrieved in Ad hoc. |
| specialEducationSettingDescriptor | Enrollment.specialEdSetting OR Plan.specialEdSetting OR Specialedstate.specialEdSetting | Student Information > Special Ed > Documents > Plan > Current Plan > Enrollment Status> Special Ed Setting OR Student Information > Special Ed > Special Ed Setting | Student > Learner > Active Enrollment > Special Ed elements > specialEdSetting Student > Learner Planning > Learning Plans > specialEdSetting |
| mainSPEDSchool | Plan.spedConcurrencyType | Plan > Enrollment Status > | Student > Learner > State Localized Elements > spedConcurrencyType |
programReference educatioOrganizationId programName programTypeDescriptor | CustomDistrict.attributeid Enrollment.specialEdSetting 'Special Education' | educationOrganizationId: System Administration > Resources > District Information > Entity ID OR: Plan > Enrollment Status > programName: Plan > Enrollment Status > Special Ed Setting | Student > School > Custom School > districtEntityID |
studentReference studentUniqueId | Person.edFiID | Census > People > Demographics > EdFi ID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
| assessmentCategoryDescriptor | Evaluation.assessmentCategory | Student Information > SPED > General > Documents > Evaluation > Assessment Category | Student > Learner Planning > Evaluations > assessmentCategory |
| assessmentPeriodDescriptor | Evaluation.type | Student Information > SPED > General > Documents > Evaluations > Evaluation Type | Student > Learner Planning > Evaluations > type |
| assessmentOutcomesSummaryDescriptor | Evaluation.assessmentOutcome | Student Information > SPED > General > Documents > Evaluation > Assessment Outcomes Summary | Student > Learner Planning > Evaluations > assessmentOutcome |
Student Program Associations
Users should reference the following documentation for the population of each of these fields. Depending on the program, a field could be hard-coded or the date could be populated based on specific logic: Arizona Ed-Fi - Student Program Associations Resource
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
educationOrganizationReference educationOrganizationId | School.entityid | System Administration > Resources > School > Entity ID | Student > School > entityID |
programReference educationOrganizationId programName programTypeDescriptor | Program.code CustomSchool.districtEntityID OR CustomDistrict.entityID | Programs Participation > Title 1 > Title 1 record > Title 1 Service System Administration > Resources > Resources > School Editor > District Entity ID OR System Administration > Resources > Resources > District Information > Entity ID | Student > Learner > Programs/Flags > code Student > Learner > Programs/Flags > Programs > code Student > School > Custom School > districtEntityID Student > District > Custom District > entityID |
studentReference studentUniqueId | Person.edFiID | Census > People > Demographics > EdFi ID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
| beginDate | ProgramParticipation.startDate OR LepService.startDate OR Enrollment.startDate | Student Information > General > Flags > Start Date OR Enrollment Start Date OR Programs Participation > Title 1 > Title 1 record > Start Date OR Student Information > General> Program Participation > EL > EL Services > Start Date | Student > Learner > Programs/Flags > startDate Student > Learner > Programs/Flags > Programs > startDate Student > Learner > Title1 > Title1 > startDate Student > Learner > Active Enrollment > Core elements > startDate Student > Learner > Early Learning > serviceStartDate |
| endDate | ProgramParticipation.EndDate OR LepDervice.EndDate OR Enrollment.endDate | Student Information > General > Flags > End Date OR Student Information > General > Enrollment End Date OR Programs Participation > Title 1 > Title 1 record > End Date OR Student Information > General > Program Participation > EL > EL Services > End Date | Student > Learner > Programs/Flags > endDate Student > Learner > Programs/Flags > Programs > endDate Student > Learner > Title1 > Title1 > endDate Student > Learner > Active Enrollment > Core elements > endDate Student > Learner > Early Learning > serviceEndDate |
| reasonExitedDescriptor | For LEP:
For ProgramParticipation:
| Student Information > General > Flags > Exit Reason Student Information > General > Program Participation > EL > EL Services > Exit Reason | LepService.exit reason: Student > Learner > EL > EL Service > exitReason ProgramParticipation.exitReason:
Note: This is a calculated field and cannot easily be retrieved from Ad hoc. |
Student School Attendance Events
Users should reference the following documentation for the population of each of these fields as there is specific logic used in some cases instead of a specific field in Campus: Arizona Ed-Fi - Student School Attendance Events Resource
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| eventDuration | "0.25", "0.5", "0.75" or "1" | This is a calculated field and cannot be retrieved in Ad hoc. | |
| attendanceEventCategoryDescriptor | "1", "2", or "3" | EXCUSED_ABSENCE = "1" UNEXCUSED_ABSENCE = "2" IN_ATTENDANCE = "3" | This is a calculated field based on the absent code entered for a student and cannot easily be retrieved in Ad hoc. |
| instructionalMinutes | sum(attendanceUnit.units) OR (period.startTime - period.endTime, (in minutes)) - period.lunchtime - attendanceCode.presentMinutes | Sent for IN_ATTENDANCE records only, Attendance Type 017 | Student > Attendance > Positive Attendance Detail > units |
| eventDate | Attendance.date | Student Information > General > Attendance > Date | Student > Attendance > Daily Exact Detail > date |
studentReference studentUniqueId | Person.edFiID | Census > People > Demographics > EdFi ID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
schoolReference schoolId | School.entityID | System Administration > Resources > School > Entity Id | Student > School > entityID |
sessionReference schoolId schoolYear sessionReference | School.entityID Calendar.endYear | System Administration > Resources > School > Entity Id Calendar > Calendar > End Date | Student > School > entityID Student > School Calendar > End Year |
Student Section Associations
Users should reference the following documentation for the population of calculated fields: Arizona Ed-Fi - Student Section Associations Resource
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| beginDate | roster.startDate OR terms.startDate | Student Information > General > Schedule > Roster Start Date OR System Administration > Calendar > Calendar > Terms > Start Date (of term course is in) | Student > Learner > Schedule > startDate Student > Learner > Schedule > Course/Section > Section Schedule > termStart |
sectionReference localCourseCode schoolId schoolYear sectionIdentifier sessionName | Course.number School.entityID Calendar.endYear | Scheduling > Course > Number System Administration > Resources > School > Entity Id Calendar > Calendar > End Date | Student > Learner > Schedule > Course/Section > courseNumber Student > School > entityID Student > School Calendar > End Year |
studentReference studentUniqueId | Person.edFiID | Census > People > Demographics > EdFi ID | Student > Demographics > edFiID Student > Demographics > Identity History > Ed Fi ID History > edFiID |
| concurrentEnrollment | CustomCourse.value Need to do a join on the following tables to get the correct value: CustomCourse and CampusAttribute Join on attributeId Where CampusAttribute.element is postSecondary and CustomCourse.courseID is the course student is rostered in | Scheduling > Course > Post Secondary | Student > Learner > Schedule > Course/Section > Custom Course > postSecondary |
| dualCredit | CustomCourse.value Need to do a join on the following tables to get the correct value: CustomCourse and CampusAttribute Join on attributeId Where CampusAttribute.element is dualCredit and CustomCourse.courseID is the course student is rostered in | Scheduling > Course > Dual Credit Scheduling > Course > Section > Dual Credit Scheduling > Course > Section> Roster Batch Edit > Dual Credit | Student > Learner > Schedule > Course/Section > Custom Course > dualCredit Student > Learner > Schedule > Course/Section > Custom Section> dualCredit |
| endDate | Roster.endDate OR Terms.endDate | Student Information > General > Schedule > Roster End Date OR System Administration > Calendar > Calendar > Terms > End Date (of term course is in) | Student > Learner > Schedule > endDate Student > Learner > Schedule > Course/Section > Section Schedule > termEnd |
| courseEntryDescriptor | "T", "R", or "N" | New Enrollment - N Re-Entry - R Transfer - R | This is a calculated field based on how a student is rostered into a course and cannot easily be retrieved in Ad hoc. |
| courseExitDescriptor | "CF", "CP", "CN", "LS", "OE", or "SC" | Content Complete - Full Credit - CF Content Complete - Partial Credit - CP Content Complete - No Credit/Academic Progress - CN Left the School - LS Open Ended Course - OE Schedule Change - SC | This is a calculated field based on how a student completed a course and cannot easily be retrieved in Ad hoc. |
Course Transcripts
Users should reference the following documentation for the population of calculated fields: Arizona Ed-Fi - Course Transcripts Resource
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| courseAttemptResultDescriptor | Reports 'Pass', 'Fail', or 'Incomplete' TranscriptCredit.creditsAttempted AND TranscriptCredit.creditsEarned | Student Information > General > Transcripts > Earned AND Student Information > General > Transcripts > Attempted | This is a calculated field based on either the student's grade or the students credits and cannot easliy be retieved in Ad Hoc. These fields may be helpful Student > Grading > Grading Detail> passingScore Student > Grading > Grading Detail > credit |
courseReference courseCode educationOrganizationId | Course.stateCode District.entityID | Scheduling > Course > State Code System Administration > Resources > District Information > Entity Id | Student > Learner > Schedule > Course/Section > stateCode Student > School > Custom School > districtEntityID |
studentAcademicRecordReference educationOrganizationId schoolYear studentUniqueId termDescriptor | School.entityID Calendar.endYear Person.edFiID | System Administration > Resources > School > Entity Id Calendar > Calendar > End Date Census > People > Demographics > EdFi ID | Student > School > entityID Student > School Calendar > End Year Student > Demographics > edFiID |
| alternativeCourseCode | TranscriptCourse.courseNumber | Student Information > General > Transcripts > Course Number | Student > Grading > Grading Detail > courseNumber |
| alternativeCourseTitle | TranscriptCourse.courseName | Student Information > General > Transcripts > Course Name | Student > Grading > Grading Detail > courseName |
| attemptedCredits | TranscriptCredit.creditsAttempted | Student Information > General > Transcripts > Attempted | Student > Grading > Grading Detail > credit |
| courseTitle | TranscriptCourse.courseName | Student Information > General > Transcripts > Course Name | Student > Grading > Grading Detail > courseName |
| earnedCredits | TranscriptCredit.creditsEarned | Student Information > General > Transcripts > Earned | This is a calculated field and cannot be retreived in Ad Hoc. |
| finalLetterGradeEarned | TranscriptCourse.score | Student Information > General > Transcripts > Current Score OR Score > Name | Student > Grading > Grading Detail > score |
| whenTakenGradeLevelDescriptor | Enrollment.grade | Student Information > General > Enrollments > Grade | Student > Learner > Active Enrollment > Core elements > grade |
| finalLetterGradeDescriptor | TranscriptCourse.score | Student Information > General > Transcripts > Current Score OR Score > Name | Student > Grading > Grading Detail > score |
Sessions
User should reference the following documentation for the population of calculated fields: Arizona Ed-Fi - Sessions Resource
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| sessionName | EdFiMapping.edFiValue | System Administration > Ed-Fi > Configuration > Resources Preferences > Sessions > Ed-Fi Code | This field is not in Ad hoc. |
schoolReference schoolId | School.entityID | System Administration > Resources > School > Entity ID | Course > School > entityID |
schoolYearTypeReference schoolYear | Calendar.endYear | Calendar > Calendar > End Date | Course > School Calendar > End Year |
| beginDate | Term.startDate | System Administration > Calendar > Calendar > Terms > Start Date | This field is not in Ad hoc. |
| endDate | Term.endDate | System Administration > Calendar > Calendar > Terms > End Date | This field is not in Ad hoc. |
| termDescriptor | EdFiMapping.edFiValue | System Administration > Ed-Fi > Configuration > Resources Preferences > Sessions > Ed-Fi Code | This field is not in Ad hoc. |
| totalInstructionalDays | System Administration > Calendar > Calendars > Term Setup > Start/End Date of term System Administration > Calendar > Calendars > Days | This is a calculated field based on how many instructional days are set up in the calendar for a given term. |
Course Offerings
User should reference the following documentation for the population of calculated fields: Arizona Ed-Fi - Course Offerings Resource
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| localCourseCode | Course.number | Scheduling > Course > Number | Course > Course Information > courseNumber |
courseReference courseCode educationOrganizationId | Course.stateCode District.entityID | Scheduling > Course > State Code System Administration > Resources > District Information > Entity Id | Course > Course Information > stateCode Course > School > Custom School > districtEntityID |
schoolReference schoolId | Course.provider School.entityID | Course > Location Override Course > Section > Location Override System Administration > Resources > School > Entity Id | Course > School > entityID |
sessionReference schoolId schoolYear sessionName | School.entityID Calendar.endYear | System Administration > Resources > School > Entity Id Calendar > Calendar > End Date | Course > School > entityID Course > School Calendar > End Year |
| scheduleDate | Course > Section > Section Schedule Placement System Administration > Calendar > Calendar > Terms > Start Date | This is populated with every date the course is scheduled to be held so cannot be retrieved from Ad hoc | |
| instructionalMinutesPlanned | Course > Section > Section Schedule Placement System Administration > Calendar > Calendar > Terms > Start Date System Administration > Calendar > Calendar > Periods | This is populated with the total period minutes for each day the course is scheduled and cannot be retrieved from Ad hoc. | |
| localCourseTitle | Course.name | Scheduling > Course > Name | Course > Course Information > courseName |
Class Periods
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| classPeriodName | Period.name | System Administration > Calendar > Calendar > Periods > Name | This field is not in Ad hoc. |
schoolReference schoolId | School.entityID | System Administration > Resources > School > Entity ID | Course > School > entityID |
| endTime | Period.endTime | System Administration > Calendar > Calendar > Periods > End Time | Course > Section Information > Section Schedule > Section Schedule > periodEnd |
| startTime | Period.startTime | System Administration > Calendar > Calendar > Periods > Start Time | Course > Section Information > Section Schedule > Section Schedule > periodStart |
Locations
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| classroomIdentificationCode | Room.name | System Administration> Resources> Resources> Rooms > Name | This field is not in Ad hoc. |
schoolReference schoolId | School.entityID | System Administration > Resources > School > Entity ID | Course > School > entityID |
Sections
Users should reference the following documentation for the population of calculated fields: Arizona Ed-Fi - Sections Resource
| Element | Campus Database Location | Campus UI Location | Ad hoc Location |
|---|---|---|---|
| sectionIdentifier | Section.sectionID | Scheduling > Courses > Sections >Section Id | Course > Section Information > sectionID |
courseOfferingreference localCourseCode schoolId schoolYear sessionName | School.entityID Calendar.endYear | System Administration > Resources > School > Entity Id Calendar > Calendar > End Date | Course > School > entityID Course > School Calendar > endYear |
locationReference classroomIdentificationCode schoolId | Room.name School.entityId | System Administration > Resources > Resources > Rooms > Name System Administration> Resources> School> Entity ID | Course name is not in Ad hoc Course > School > entityID |
siteLocationSchoolReference classroomIdentificationCode schoolId | Course.provider Section.provider School.entityID | Scheduling > Courses > Location Override Scheduling > Courses > Sections > Location Override System Administration > Resources > School > entityID | Course > Course Information > provider Course > Section Information > provider Course > School > entityID |
| availableCredits | GradingTaskCredit.credit | Scheduling > Course > Grading Tasks > Credit | This is a calculated field based on all grading tasks on a course and cannot be retrieved from Ad hoc. |
| courseLevelCharacteristics | Course.level Course.dualCredit Section.dualCredit | Scheduling > Courses > Level Scheduling > Courses > Dual Credit Scheduling > Courses > Sections > Dual Credit | Course > Course Information > level Course > Course Information > Custom Course > dualCredit Course > Section Information > Custom Section > dualCredit |
| educationalEnvironmentDescriptor | Section.instructionalSetting | Scheduling > Courses > Sections > Instructional Setting | Course > Section Information > instructionalSetting |
| offeredGradeLevels | Reports the lowest and the highest grade level of students scheduled in the course section | This is a calculated field based on students rostered into a course and cannot be retrieved from Ad hoc. | |
| sequenceOfCourse | Defaulted to 1 | ||
| minutesPerWeek | Course.instructionalTime OR Section.instructionalTime | Course > Section > CTE Minutes per Week Override OR Course > CTE Minutes per Week | Course > Course Information > courseinstructionalTime Section > Section Information > sectioninstructionalTime |
