Classic View: System Administration > Ed-Fi
Search Terms: Ed-Fi
If you have received approval from the state to submit data corrections for past year data, you must create a CSV file containing all the records that have been sent and how these records should look after data corrections have been made.
To help in this process, 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.
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 |
2019-2020 School Year
The following information only pertains to the 2019-2020 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 Resource
| 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 |
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 hardcoded 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 | |||
|---|---|---|---|
| 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 |
Sessions
Users 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
Users 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 |
| endOfCourseAssessmentCodeDescriptor | 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 endOfCourseAssessment and CustomCourse.courseID is the course student is rostered in | Scheduling > Course > End of Course Assessment | Course > Course Information > Custom Course > endOfCourseAssessment |
| 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
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 |
