Resource Overview
-
Ed-Fi endpoint:
/data/v3/studentEducationOrganizationAssociations -
Published view/entity: Student Demographics
-
Purpose: Student demographic data and information specific to a student's relationship with an Education Organization
-
Source query:
StudentEduOrgAssociation -
Dependencies:
studentSchoolAssociations
Resource Output
|
Data Element (Ed-Fi target) |
Data View Column Name |
Submission |
[Table]Field (PowerSchool Source) |
Business Rules |
Comments |
|---|---|---|---|---|---|
|
educationOrganizationReference.educationOrganizationId |
LEAOrgID |
Y |
Staging rule: studentEduOrgAssociations LEAOrgId.LEAOrgId |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: LEAOrgID. |
|
studentReference.studentUniqueId |
StudentUID |
Y |
[Students]dcid; Transformation: EDFI_TN_LIB.getStudentUniqueId(p_profileid, s.dcid) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: StudentUID. |
|
addresses[].addressTypeDescriptor |
AddressTypePhysical_DX |
Y |
Staging rule: studentEduOrgAssociations 'Physical' |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: AddressTypePhysical_DX. |
|
addresses[].stateAbbreviationDescriptor |
StateAbbreviationPhysical_DX |
Y |
Publishing framework or supporting query Query alias: StateAbbreviationPhysical_DX |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: StateAbbreviationPhysical_DX. |
|
addresses[].apartmentRoomSuiteNumber |
AptRoomSuiteNumberPhysical |
Conditional |
[Students]street |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: AptRoomSuiteNumberPhysical. |
|
addresses[].buildingSiteNumber |
BuildingSiteNumberPhysical |
Conditional |
Publishing framework or supporting query Query alias: BuildingSiteNumberPhysical |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: BuildingSiteNumberPhysical. |
|
addresses[].city |
CityPhysical |
Y |
[Students]City |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: CityPhysical. |
|
addresses[].countyFIPSCode |
CountyFIPSCodePhysical |
Conditional |
Publishing framework or supporting query Query alias: CountyFIPSCodePhysical |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: CountyFIPSCodePhysical. |
|
addresses[].latitude |
LatitudePhysical |
Conditional |
Publishing framework or supporting query Query alias: LatitudePhysical |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: LatitudePhysical. |
|
addresses[].longitude |
LongitudePhysical |
Conditional |
Publishing framework or supporting query Query alias: LongitudePhysical |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: LongitudePhysical. |
|
addresses[].nameOfCounty |
NameOfCountyPhysical |
Conditional |
Publishing framework or supporting query Query alias: NameOfCountyPhysical |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: NameOfCountyPhysical. |
|
addresses[].postalCode |
PostalCodePhysical |
Y |
[Students]Zip |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: PostalCodePhysical. |
|
addresses[].streetNumberName |
StreetNumberNamePhysical |
Y |
[Students]street |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: StreetNumberNamePhysical. |
|
addresses[].periods[].beginDate |
AddressBeginDatePhysical |
Y |
Publishing framework or supporting query Query alias: AddressBeginDatePhysical |
Required by the production resource definition when the resource is published. |
JSON type: datetime. Query alias: AddressBeginDatePhysical. |
|
addresses[].periods[].endDate |
AddressEndDatePhysical |
Y |
Publishing framework or supporting query Query alias: AddressEndDatePhysical |
Required by the production resource definition when the resource is published. |
JSON type: datetime. Query alias: AddressEndDatePhysical. |
|
addresses[].localeDescriptor |
LocalePhysical_DX |
Conditional |
Publishing framework or supporting query Query alias: LocalePhysical_DX |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: LocalePhysical_DX. |
|
addresses[].congressionalDistrict |
CongressionalDistrictPhysical |
Conditional |
Publishing framework or supporting query Query alias: CongressionalDistrictPhysical |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: CongressionalDistrictPhysical. |
|
addresses[].addressTypeDescriptor |
AddressTypeMailing_DX |
Y |
Staging rule: studentEduOrgAssociations 'Mailing' |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: AddressTypeMailing_DX. |
|
addresses[].stateAbbreviationDescriptor |
StateAbbreviationMailing_DX |
Y |
Publishing framework or supporting query Query alias: StateAbbreviationMailing_DX |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: StateAbbreviationMailing_DX. |
|
addresses[].apartmentRoomSuiteNumber |
AptRoomSuiteNumberMailing |
Conditional |
Publishing framework or supporting query Query alias: AptRoomSuiteNumberMailing |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: AptRoomSuiteNumberMailing. |
|
addresses[].buildingSiteNumber |
BuildingSiteNumberMailing |
Conditional |
Publishing framework or supporting query Query alias: BuildingSiteNumberMailing |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: BuildingSiteNumberMailing. |
|
addresses[].city |
CityMailing |
Y |
[Students]Mailing_City |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: CityMailing. |
|
addresses[].countyFIPSCode |
CountyFIPSCodeMailing |
Conditional |
Publishing framework or supporting query Query alias: CountyFIPSCodeMailing |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: CountyFIPSCodeMailing. |
|
addresses[].latitude |
LatitudeMailing |
Conditional |
Publishing framework or supporting query Query alias: LatitudeMailing |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: LatitudeMailing. |
|
addresses[].longitude |
LongitudeMailing |
Conditional |
Publishing framework or supporting query Query alias: LongitudeMailing |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: LongitudeMailing. |
|
addresses[].nameOfCounty |
NameOfCountyMailing |
Conditional |
Publishing framework or supporting query Query alias: NameOfCountyMailing |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: NameOfCountyMailing. |
|
addresses[].postalCode |
PostalCodeMailing |
Y |
[Students]Mailing_Zip |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: PostalCodeMailing. |
|
addresses[].streetNumberName |
StreetNumberNameMailing |
Y |
[Students]Mailing_street |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: StreetNumberNameMailing. |
|
addresses[].periods[].beginDate |
AddressBeginDateMailing |
Y |
Publishing framework or supporting query Query alias: AddressBeginDateMailing |
Required by the production resource definition when the resource is published. |
JSON type: datetime. Query alias: AddressBeginDateMailing. |
|
addresses[].periods[].endDate |
AddressEndDateMailing |
Y |
Publishing framework or supporting query Query alias: AddressEndDateMailing |
Required by the production resource definition when the resource is published. |
JSON type: datetime. Query alias: AddressEndDateMailing. |
|
addresses[].localeDescriptor |
LocaleMailing_DX |
Conditional |
Publishing framework or supporting query Query alias: LocaleMailing_DX |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: LocaleMailing_DX. |
|
addresses[].congressionalDistrict |
CongressionalDistrictMailing |
Conditional |
Publishing framework or supporting query Query alias: CongressionalDistrictMailing |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: CongressionalDistrictMailing. |
|
cohortYears[].cohortYearTypeDescriptor |
CohortYearType_DX |
Y |
Staging rule: studentEduOrgAssociations 'Ninth grade' |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: CohortYearType_DX. |
|
cohortYears[].schoolYearTypeReference.schoolYear |
CohortSchoolYear |
Y |
[S_TN_STU_X]YearEnteredNinthGrade; Transformation: case when xts.YearEnteredNinthGrade is not null then xts.YearEnteredNinthGrade else null end |
Required by the production resource definition when the resource is published. |
JSON type: number. Query alias: CohortSchoolYear. |
|
disabilities[].disabilityDescriptor |
Disability_DX |
Y |
Publishing framework or supporting query Query alias: Disability_DX |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: Disability_DX. |
|
disabilities[].orderOfDisability |
DisabilityOrder |
Y |
Publishing framework or supporting query Query alias: DisabilityOrder |
Required by the production resource definition when the resource is published. |
JSON type: number. Query alias: DisabilityOrder. |
|
electronicMails[].electronicMailTypeDescriptor |
ElectronicMailType1_DX |
Y |
Staging rule: studentEduOrgAssociations 'Home/Personal' |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: ElectronicMailType1_DX. |
|
electronicMails[].electronicMailAddress |
ElectronicMailAddress1 |
Y |
[Students]DCID |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: ElectronicMailAddress1. |
|
electronicMails[].primaryEmailAddressIndicator |
PrimaryEmailIndicator1 |
Conditional |
Publishing framework or supporting query Query alias: PrimaryEmailIndicator1 |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: boolean. Query alias: PrimaryEmailIndicator1. |
|
hispanicLatinoEthnicity |
HispanicLatinoEthnicity |
Conditional |
[Students]fedethnicity; Transformation: case when (s.fedethnicity > 0 or exists (select 1 from StudentRace sr where sr.StudentId = and trim(sr.racecd) = 'HI')) then 1 else 0 end |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: boolean. Query alias: HispanicLatinoEthnicity. |
|
languages[].languageDescriptor |
Language1_DX |
Y |
[S_TN_STU_X]NativeLanguage; transformation: CASE lower(trim(xts.NativeLanguage)) WHEN 'gwo' THEN 'GWO' WHEN 'kea' THEN 'KEA' WHEN 'rhg' THEN 'RHG' WHEN 'prs' THEN 'PRS' WHEN 'quc' THEN 'QUC' WHEN 'oth' THEN 'OTH' ELSE NVL(lower(trim(xts.NativeLanguage)), '1290') END |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: Language1_DX. |
|
languages[].uses[].languageUseDescriptor |
LanguageUse11_DX |
Y |
Staging rule: studentEduOrgAssociations 'Native language' |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: LanguageUse11_DX. |
|
languages[].uses[].languageUseDescriptor |
LanguageUse12_DX |
Y |
Publishing framework or supporting query Query alias: LanguageUse12_DX |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: LanguageUse12_DX. |
|
languages[].languageDescriptor |
Language2_DX |
Y |
Publishing framework or supporting query Query alias: Language2_DX |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: Language2_DX. |
|
languages[].uses[].languageUseDescriptor |
LanguageUse2_DX |
Y |
Publishing framework or supporting query Query alias: LanguageUse2_DX |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: LanguageUse2_DX. |
|
limitedEnglishProficiencyDescriptor |
LimitedEnglishProficiency_DX |
Conditional |
[S_TN_STU_X]ELB |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: LimitedEnglishProficiency_DX. |
|
oldEthnicityDescriptor |
OldEthnicity_DX |
Conditional |
Publishing framework or supporting query Query alias: OldEthnicity_DX |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: OldEthnicity_DX. |
|
races[].raceDescriptor |
Race_DX |
Y |
Staging rule: studentRaces race.RaceDX |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: Race_DX. |
|
sexDescriptor |
Sex_DX |
Conditional |
[Students]Gender; Transformation: CASE upper(s.gender) WHEN 'F' THEN 'Female' WHEN 'M' THEN 'Male' ELSE 'Not Selected' END |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: Sex_DX. |
|
studentCharacteristics[].studentCharacteristicDescriptor |
Characteristic_DX |
Y |
Staging rule: stuEduOrgCharUniques stdeducharUnique.descriptor |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: Characteristic_DX. |
|
studentCharacteristics[].periods[].beginDate |
BeginDate |
Y |
Staging rule: studentEduO to_char(stdeduchar.beginDate, 'YYYY-MM-DD') |
Required by the production resource definition when the resource is published. |
JSON type: datetime. Query alias: BeginDate. |
|
studentCharacteristics[].periods[].endDate |
EndDateActual |
Conditional |
Staging rule: studentEduOrgCharacteristics to_char(stdeduchar.endDate, 'YYYY-MM-DD') |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: datetime. Query alias: EndDateActual. |
|
studentIdentificationCodes[].studentIdentificationSystemDescriptor |
IdentCodeSystem_DX |
Y |
Staging rule: studentIdentificationCodes ident.descriptor |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: IdentCodeSystem_DX. |
|
studentIdentificationCodes[].assigningOrganizationIdentificationCode |
IdentCodeAssigningOrg |
Y |
Staging rule: studentIdentificationCodes ident.org |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: IdentCodeAssigningOrg. |
|
studentIdentificationCodes[].identificationCode |
IdentificationCode |
Y |
Staging rule: studentIdentificationCodes ident.code |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: IdentificationCode. |
|
studentIndicators[].indicatorName |
IndicatorName |
Y |
Publishing framework or supporting query Query alias: IndicatorName |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: IndicatorName. |
|
studentIndicators[].indicator |
Indicator |
Y |
Publishing framework or supporting query Query alias: Indicator |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: Indicator. |
|
studentIndicators[].indicatorGroup |
IndicatorGroup |
Conditional |
Publishing framework or supporting query Query alias: IndicatorGroup |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: IndicatorGroup. |
|
tribalAffiliations[].tribalAffiliationDescriptor |
TribalAffiliation1_DX |
Y |
Publishing framework or supporting query Query alias: TribalAffiliation1_DX |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: TribalAffiliation1_DX. |
|
tribalAffiliations[].tribalAffiliationDescriptor |
TribalAffiliation2_DX |
Y |
Publishing framework or supporting query Query alias: TribalAffiliation2_DX |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: TribalAffiliation2_DX. |
|
_ext.dateEnteredUS |
EnteredUSDate |
Conditional |
[S_TN_STU_X]Datefirstenrolledinusschool; Transformation: to_char(xts.datefirstenrolledinusschool, 'YYYY-MM-DD') |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: datetime. Query alias: EnteredUSDate. |