The following entities are included in the Student Identification and Demographics domain:


Entity: Student

Entity: Parent

Entity: StudentParentAssociation

Entity: StudentEducationOrganizationAssociation


Level 1 Errors - Student Identification and Demographics



Most TEA Ed-Fi codes are hard-coded in Aeries and do not need to be mapped.

* An asterisk in the Label & Aeries Table.Field column indicates a code set where local codes can be used. Any local codes used by the district must be mapped to TEA Ed-Fi codes on School Info > Imports and Exports > Ed-Fi Code Mappings.


Entity: Student

Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
E1523StudentUniqueIdDemographics > Student Data 2Unique ID
STU.CID
E0923LocalStudentIdDemographicsStudent ID
STU.ID
E0001StudentIdDemographics (Student Data 2 tab)Soc-Sec-Num / State Alternate ID
STU.CID (SSN or S-number)
E0706 (C012)GenerationCodeDemographicsSuffix
STU.SF *
Ed-Fi Descriptor Code Set Mapping: Tx Generation Code Descriptor (STU.SF) *
E3007 (C324)AsOfStatusLastFridayOctoberCalculated. See Texas - As-of-Status Code
E3006 (C323)AsOfStatusLastDayEnrollmentCalculated based on last day of school. See Texas - As-of-Status Code
E3009StudentDoNotReportTSDS
Students without a valid Texas ID# (STU.SID) will not be uploaded or will be a Unique ID level 1.5 filter and not promote for State Reporting.  If needed STU.DNR 
E1739 (C234)

NonEnrolledStudentUILActivity (multiple allowed)


Activities and AwardsCode
ACT.CD
Activities and AwardsType
ACT.TY
ACT.CD when ACT.TY = 1
.StudentCensusBlockGroupSet (multiple allowed)
E1648StudentCensusBlockGroupDemographicsStudent Census Block Group
STU.SCB
Address HistoryStudent Census Block Group
ADH.SCB
  • STU.SCB for students who did not have an address change
  • ADH.SCB for students who had an address change
E3010BeginDateEnrollment HistoryStart Date
ENR.ED
Address HistoryEffective Date
ADH.SD
  • ENR.ED for students who did not have an address change
  • ADH.SCB for students who had an address change.

    Date must be within the current School Year.
E3020EndDateAddress HistoryEffective Date
ADH.SD
Only required if student had address change during current school year.
The EndDate is the day before the new Effective Date (ADH.SD)
.CrisisEventSet (multiple allowed)
E1054 (C178)CrisisEvent (multiple allowed)Special ProgramsIndicator Code
PGM.CRI
Special ProgramsProgram Code
PGM.CD
PGM.CRI if PGM.CD = 404
E3010BeginDateSpecial ProgramsStart Date
PGM.PSD
If PGM.CD = 404 and date is within the current school year
E3020EndDateSpecial ProgramsEnd Date
PGM.PED
If PGM.CD = 404 and date is within the current school year
.Name
E0703FirstNameDemographicsFirst Name
STU.FN
E0704MiddleNameDemographicsMiddle Name
STU.MN
E0705LastSurnameDemographicsLast Name
STU.LN
.BirthData
E0006BirthDateDemographicsBirthdate
STU.BD



Entity: Parent

(multiple allowed)

  • Sent for top two contacts based on Contact Order(CON.OR = 01 or 02) who meet the following criteria: 
    • Primary Contact (CON.PC = Y), or
    • Ed Rights Holder (CON.ERH) = Y, or
    • Lives With (CON.LW) = Y, or
    • Portal (CON.AP) = Y 
  • Restricted Contacts (Record Type (CON.CD) = R) are excluded.


Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
E1324ParentUniqueIdDemographics (Student Data 2 tab)Unique ID
STU.CID
ContactsContact Order
CON.OR = 01 or 02
STU.CID-CON.OR
E0706 (C012)GenerationCode ContactsSuffix
CON.SF *
Ed-Fi Descriptor Code Set Mapping: Tx Generation Code Descriptor (STU.SF) *
.Name
E0703FirstNameContactsFirst Name
CON.FN
E0704MiddleNameContactsMiddle Name
CON.MN
E0705LastSurnameContactsLast Name
CON.LN
.Address (multiple allowed)
E1113 (C300)AddressTypeHard-coded as 04 - Mailing
E1114StreetNumberNameContactsAddress
CON.AD
E1115ApartmentRoomSuiteNumberContactsAddress
CON.AD
E1117CityContactsCity
CON.CY
E1118 (C307)StateAbbreviationContactsState
CON.ST
E1119PostalCodeContactsZip Code
CON.ZC
.ElectronicMail (multiple allowed)
E1243ElectronicMailAddressContactsEmail Address
CON.EM
E1242 (C302)ElectronicMailTypeHard-coded as 01
.Telephone (multiple allowed)
E1269TelephoneNumberContactsTelephone
CON.TL
E1455 (C308)TelephoneNumberTypeHard-coded as 02



Entity: StudentParentAssociation

(multiple allowed)


Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
ReferenceParentSee Student Identification and Demographics domain > Parent entity
Reference StudentSee Student Identification and Demographics domain > Student entity
E1423 (C305)RelationContactsRelationship
CON.RL *
Ed-Fi Descriptor Code Set Mapping: Relation Descriptor (CON.RL) *
E1427ContactPriorityContactsContact Order
CON.OR


Entity: StudentEducationOrganizationAssociation

NOTE: For program BeginDate and End requirements see Texas-Closing Programs & At-Risk Indications At-End-Of-Year 


Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
ReferenceStudentSee Student Identification and Demographics domain > Student entity
ReferenceEducationOrganizationSee Education Organization domain > LocalEducationAgency entity (LocalEducationAgencyID element)
E0004 (C013)SexDemographicsGender
STU.GN *
Ed-Fi Descriptor Code Set Mapping: Sex Descriptor (STU.GN) *
E1064HispanicLatinoEthnicityDemographicsEthnicity
STU.ETH *
Ed-Fi Descriptor Code Set Mapping: Hispanic Latino Ethinicity Boolean Type (STU.ETH) *
E3050 (C304)Race (multiple allowed)DemographicsRace
STU.RC1 *, STU.RC2, STU.RC3, STU.RC4, STU.RC5
Ed-Fi Descriptor Code Set Mapping: Race Descriptor (STU.RC1) *
E3083StudentAcceleratedEducationPlanActivities and AwardsType
ACT.TY
Activities and AwardsDate
ACT.DT
1 if ACT.TY= 6 (Accelerated Instruction) and ACT.DT is within the current school year; otherwise 0
.EmergentBilingualSet (multiple allowed)
E0790 (C061)EmergentBilingualIndicatorSpecial ProgramsCurrent Programs
Program Code

PGM.CD = 148
Special ProgramsProgram Type 
PGM.TY *
Ed-Fi Descriptor Code Set Mapping: Tx Emergent Bilingual Indicator Descriptor (PGM.TY) *

NOTE: 0 is not reported, leave blank when mapping Tx Emergent Bilingual Indicator Descriptor (PGM.TY)
E3010BeginDateSpecial ProgramsCurrent Program
Start Date
PGM.PSD
The first instructional day a student is assigned to the EmergentBilingualIndicator descriptor.
E3020EndDateSpecial ProgramsCurrent Program
End Date
PGM.PED
The first day after the last instructional day a student is assigned to the EmergentBilingualIndicator descriptor.
  • If the EndDate is the last day of school, 'null' is extracted
.TruancySet (multiple allowed)
E3068 (C346)TruancyDemographics (Student Data 2 tab), orTruant
STU.TRU
InterventionsCode
INV.CD *
InterventionsTruancy Complaint Filed
INV.TCF
Ed-Fi Descriptor Code Set Mapping: Tx Truancy Descriptor (INV.CD) *

IMPORTANT: Only code 02 or 03 can be mapped.

Reported as follows:
  • 01 - Truant (STU.TRU) is populated, or
  • 02 - Intervention Code (INV.CD) if mapped to code 02 on Ed-Fi Code Mappings, or
  • 03 - INV.TCF = Y for 
    • Any intervention Code (INV.CD) mapped to 02 Truancy Prevention Measure, or
    • Any intervention Code (INV.CD) mapped to 03 Truancy Complaint Filed

Any custom codes in PGM.TY must be mapped to TEA codes and cannot overlap TEA fixed codes.

See Texas - Truancy Information and State Reporting
E3014DateMetDemographics (Student Data 2 tab), orDate Met
STU.TDM (only displayed if STU.TRU = Yes)
InterventionsDate
INV.DT
Only if date is within current school year
.DyslexiaServicesSet (multiple allowed)
E1650 (C224)DyslexiaServicesSpecial ProgramsCurrent Programs
Program Code

PGM.CD = 400
Special ProgramsServices Received
PGS.SR *
Ed-Fi Descriptor Code Set Mapping: Tx Dyslexia Services Descriptor (PGS.SR) *
E3010BeginDateSpecial ProgramsCurrent Program
Start Date
PGM.PSD

The first day the student is assigned to the Dyslexia Services Descriptor. The Begin Date does not need to be within the current school year.
E3020EndDateSpecial ProgramsCurrent Program
End Date
PGM.PED
The first day after the last instructional day a student was assigned to the program
  • If the EndDate is the last day of school, 'null' is extracted
.EconomicDisadvantageSet (multiple allowed)
E0785 (C054)EconomicDisadvantageFree and ReducedNSLP Lunch Type Code
FRE.CD *
Ed-Fi Descriptor Code Set Mapping: Tx Economic Disadvantage Descriptor (FRE.CD) *
E3010BeginDateFree and ReducedNSLP Eligibility - Start Date
FRE.ESD

Start date must be within the current school year.
E3020EndDateFree and ReducedNSLP Eligibility - End Date
FRE.EED
The first day after the last instructional day a student was assigned to the program
  • If the EndDate is the last day of school, 'null' is extracted
.FosterCareTypeSet (multiple allowed)
E1528 (C196)FosterCareTypeSpecial Programs

Current Programs

Program Code

PGM.CD = 190

Special ProgramsProgram Type
PGM.TY *
Ed-Fi Descriptor Code Set Mapping: Tx Foster Care Type Descriptor (PGM.TY) *

NOTE: 0 is not reported, leave blank in mapping Tx Foster Care Type Descriptor (PGM.TY) 
E3010BeginDateSpecial ProgramsCurrent Program
Start Date
PGM.PSD

Start date must be within the current school year.
E3020EndDateSpecial ProgramsCurrent Program
End Date
PGM.PED
The first day after the last instructional day a student was assigned to the program
  • If the EndDate is the last day of school, 'null' is extracted
.HomelessStatusSet (multiple allowed)
E1082 (C189)HomelessStatusSpecial ProgramsCurrent Programs

Program Code

PGM.CD = 191

Special ProgramsCurrent Programs
Homeless Dwelling Type

PGM.HDT *
Ed-Fi Descriptor Code Set Mapping: Tx Homeless Status Descriptor (PGM.HDT) *

PGM.HDT is extracted; only displayed if PGM.CD = 191
E3010BeginDateSpecial ProgramsCurrent Program
Start Date
PGM.PSD

Start date must be within the current school year.
E3020EndDateSpecial ProgramsCurrent Program
End Date
PGM.PED
The first day after the last instructional day a student was assigned to the program
  • If the EndDate is the last day of school, 'null' is extracted
.UnaccompaniedYouthSet (multiple allowed)
E1084 (C192)UnaccompaniedYouthSpecial ProgramsCurrent Programs

Program Code

PGM.CD = 191

Special Programs

Current Programs
Unaccomp Youth

PGM.UY *
Ed-Fi Descriptor Code Set Mapping: Tx Unaccompanied Youth Descriptor (PGM.UY) *

PGM.UY is extracted; only displayed if PGM.CD = 191
E3010BeginDateSpecial ProgramsCurrent Program
Start Date
PGM.PSD

Start date must be within the current school year.
E3020EndDateSpecial ProgramsCurrent Program
End Date
PGM.PED
The first day after the last instructional day a student was assigned to the program
  • If the EndDate is the last day of school, 'null' is extracted
.UnschooledAsyleeRefugeeSet (multiple allowed)
E1076 (C183)UnschooledAsyleeRefugeeSpecial ProgramsCurrent Programs

Program Code

PGM.CD = 406

Special ProgramsProgram Type
PGM.TY *
Ed-Fi Descriptor Code Set Mapping: Tx Unschooled Asylee Refugee Descriptor (PGM.TY) *
E3010BeginDateSpecial ProgramsCurrent Program
Start Date
PGM.PSD

Start date may be in a prior school year.
E3020EndDateSpecial ProgramsCurrent Program
End Date
PGM.PED
The first day after the last instructional day a student was assigned to the program
  • If the EndDate is the last day of school, 'null' is extracted
.EarlyReadingIndicatorSet (multiple allowed)
E1522 (C195)EarlyReadingIndicatorSpecial ProgramsCurrent Programs

Program Code

PGM.CD = 402

Special ProgramsProgram Type PGM.TY *
Ed-Fi Descriptor Code Set Mapping: Tx Early Reading Indicator Desriptor (PGM.TY) *
E3010BeginDateSpecial ProgramsCurrent Program
Start Date
PGM.PSD

Start date must be within the current school year.
E3020EndDateSpecial ProgramsCurrent Program
End Date
PGM.PED
The first day after the last instructional day a student was assigned to the program
  • If the EndDate is the last day of school, 'null' is extracted
.MilitaryConnectedStudentSet (multiple allowed)
E1529 (C197)MilitaryConnectedStudentSpecial ProgramsCurrent Programs

Program Code

PGM.CD = 192

Special ProgramsProgram Type
PGM.TY*
Ed-Fi Descriptor Code Set Mapping: Tx Military Connected Student Descriptor (PGM.TY) *

NOTE: 0 is not reported, leave blank in mapping Tx Military Connected Student Descriptor (PGM.TY)
E3010BeginDateSpecial ProgramsCurrent Program
Start Date
PGM.PSD

Start date may be in a prior school year.
E3020EndDateSpecial ProgramsCurrent Program
End Date
PGM.PED
The first day after the last instructional day a student was assigned to the program
  • If the EndDate is the last day of school, 'null' is extracted
.DyslexiaRiskSet (multiple allowed)
E1644 (C222)DyslexiaRiskSpecial Programs (Program Screenings tab)Program Screenings
Program Code
PGR.CD = 399
Status
PGR.ST *
DemographicsGrd
STU.GR
Ed-Fi Descriptor Code Set Mapping: Tx Dyslexia Risk Descriptor (PGR.ST) *

PGR.ST if PGR.CD = 399 and STU.GR = KG or 1.
Only reported for students in grades KG or 1.
E1732 (C231)DyslexiaScreeningExceptionReasonSpecial Programs (Program Screenings tab)Reason
PGR.RS *
Ed-Fi Descriptor Code Set Mapping: Tx Dyslexia Screening Exception Reason Descriptor (PGR.RS) *

Must be reported for KG and 1st grade students who were not screened for dyslexia or related disorder.
E3010BeginDateSpecial Programs (Program Screenings tab)Date
PGR.DT

All students must be screened each year in KG and 1st grade. The Begin Date needs to be within the current school year for each grade.
E3020EndDateNot sent. Screening records do not have an end date.
.PKProgramTypeSet (multiple allowed)
E1078 (C185)PKProgramTypeEarly Childhood DevelopmentProgram Type
ECD.PTC *
Ed-Fi Descriptor Code Set Mapping: Tx Pk Program Type Descriptor (ECD.PTC) *

NOTE: 0 is not reported, leave blank in mapping Tx Pk Program Type Descriptor (ECD.PTC) 
E3010BeginDateEarly Childhood DevelopmentStart Date ECD.SD

Start date must be within the current school year.
E3020EndDateEarly Childhood DevelopmentEnd Date              ECD.ED
The first day after the last instructional day a student was assigned to the program
  • If the EndDate is the last day of school, 'null' is extracted
.PKFundingSourceSet (multiple allowed)
E3044 (C186)PKFundingSourceEarly Childhood Development

Primary Funding Type ECD.FT1 *
Early Childhood Development

Secondary Funding Type

ECD.FT2

Ed-Fi Descriptor Code Set Mapping: Tx Pk Funding Source Descriptor (ECD.FT1) *
E3040OrderOfPKFundingSourceEarly Childhood DevelopmentHard-coded

1 for ECD.FT1
2 for ECD.FT2
E3010BeginDateEarly Childhood DevelopmentStart Date
ECD.SD

Start date must be within the current school year.
E3020EndDateEarly Childhood DevelopmentEnd Date  
ECD.ED
The first day after the last instructional day a student was assigned to the program
  • If the EndDate is the last day of school, 'null' is extracted
.AcceleratedInstructionSet (multiple allowed)
(Extracted for students where StudentAcceleratedEducationPlan = 1)
E3084 (C352)AcceleratedInstructionSubjectActivities and AwardsCode
ACT.CD
Activities and AwardsType
ACT.TY
ACT.CD when ACT.TY = 6

All subjects for this element start with 'AI' in Aeries
E3085 (C353)

StudentAcceleratedInstructionParticipation

Activities and AwardsReason
ACT.RS
Activities and AwardsType
ACT.TY
ACT.RS when ACT.TY = 6

All Reasons for this element start with 'AI' in Aeries
E3086AssignedHoursAcceleratedInstructionActivities and AwardsHours Assigned
ACT.HA
Activities and AwardsType
ACT.TY
ACT.HA when ACT.TY = 6
E3087CompletedHoursAcceleratedInstructionActivities and AwardsHours Completed
ACT.HR
Activities and AwardsType
ACT.TY
ACT.HR when ACT.TY = 6
E3088 (C354)

DifferenceReasonHoursAcceleratedInstruction

Activities and AwardsHours Difference Reason
ACT.HDR

Activities and AwardsTo be determined
ACT.HDR when ACT.TY = 6
.Address (multiple allowed)
E1113 (C300)AddressTypeHard-coded as 04-Mailing
E1114StreetNumberNameDemographicsAddress
STU.AD
E1115ApartmentRoomSuiteNumberDemographicsAddress
STU.AD
E1117CityDemographicsCity
STU.CY
E1118 (C307)StateAbbreviationDemographicsState
STU.ST
E1119PostalCodeDemographicsZip Code
STU.ZC
.Language (multiple allowed)
E3033 (C092)LanguageDemographicsStudent Language
STU.HL *
DemographicsHome Language
STU.CL *
Ed-Fi Descriptor Code Set Mapping: Language Descriptor (STU.HL) Also maps to values in STU.CL *

Both are sent if populated
E3035 (C336)LanguageUse02 if STU.HL
01 if STU.CL
.StudentCharacteristic (multiple allowed) (multiple Periods for each characteristic allowed)
E3063 (C344)StudentCharacteristicAt Risk (01)
Special Programs
Program Code
PGM.CD = 409
E3010PeriodBeginDateSpecial ProgramStart Date
PGM.PSD
E3020EndDateSpecial ProgramEnd Date
PGM.PED

NOTE:  If EmergentBilingualIndicator is 1, the start date can be in a prior school year with no end date.

E3063 (C344)StudentCharacteristicImmigrant (02)Secondary Stu Data

US School < 3 Yrs

SSD.SUS = Y
E3010PeriodBeginDateDemographicsDist Enter Dt
STU.DD, if blank default to July 1 of current school year
E3020EndDate
N/A
E3063 (C344)StudentCharacteristicMigratory (03)
Special Programs
Program Code
PGM.CD = 135
E3010PeriodBeginDate
Special Programs
Start Date
PGM.PSD
E3020EndDate
Special Programs
End Date
PGM.PED
E3063 (C344)StudentCharacteristicDyslexia (04)
Special Programs

Program Code
PGM.CD = 400
E3010PeriodBeginDate
Special Programs
Start Date
PGM.PSD
E3020EndDate
Special Programs
End Date
PGM.PED
E3063 (C344)StudentCharacteristicECHS (06)
Special Programs
Program Code
PGM.CD = 410
E3010PeriodBeginDate
Special Programs
Start Date
PGM.PSD
E3020EndDate
Special Programs
End Date
PGM.PED
E3063 (C344)StudentCharacteristicP-TECH (07)
Special Programs
Program Code
PGM.CD = 411
E3010PeriodBeginDate
Special Programs
Start Date
PGM.PSD
E3020EndDate
Special Programs
End Date
PGM.PED
E3063 (C344)StudentCharacteristicNew Tech (08)In development
E3010PeriodBeginDateIn development
E3020EndDateIn development
E3063 (C344)StudentCharacteristicIEP Continuer (09)Special Education (Student Services tab)Service
CSV.CD = 950
E3010PeriodBeginDateSpecial Education (Student Services tab)Start Date
CSV.DT
E3020EndDateSpecial Education (Student Services tab)Ending Date
CSV.ED
E3063 (C344)StudentCharacteristicStar of Texas (10)Activities and AwardsType
ACT.TY = 2
Activities and AwardsCode
ACT.CD = STX
E3010PeriodBeginDateActivities and AwardsDate
ACT.DT
E3020EndDate
N/A
E3063 (C344)StudentCharacteristicPK Eligible Prior Year (11)Early Childhood DevelopmentPK Eligible Previous Year
ECD.PRE = Y
E3010PeriodBeginDateEarly Childhood DevelopmentStart Date
ECD.SD
E3020EndDateEarly Childhood DevelopmentEnd Date
ECD.ED
E3063 (C344)StudentCharacteristicSection 504 (12)
Special Programs, or
Program Code
PGM.CD = 101
504 Plansrecord exists
E3010PeriodBeginDate
Special Programs, or 
Start Date
PGM.PSD
504 PlansEffective Date
FOF.SD
E3020EndDate
Special Programs, or 
End Date
PGM.PED
504 PlansLeave Date
FOF.ED
E3063 (C344)StudentCharacteristicIntervention Strategy (13)InterventionsCode
INV.CD *

Ed-Fi Descriptor Code Set Mapping:  Student Characteristic Descriptor (INV.CD) *


If a student has an INV.CD code that is mapped to code 13 for the current school year, the characteristic is synced to INV.DD and INV.ED

E3010PeriodBeginDateInterventionsStart Date
INV.DD
E3020EndDateInterventionsEnd Date
INV.ED
E3063 (C344)StudentCharacteristicPregnancy Related Services (14)Special ProgramsProgram Code
PGM.CD = 162
E3010PeriodBeginDateSpecial ProgramsStart Date
PGM.PSD
E3020EndDateSpecial ProgramsEnd Date
PGM.PED
E3063 (C344)StudentCharacteristicGifted and Talented (15)Special Programs, orProgram Code
PGM.CD = 127
Gifted/Talentedrecord exists
E3010PeriodBeginDateSpecial Programs, orStart Date
PGM.PSD
Gifted/TalentedParticipation - Start Date
GTE.PSD
E3020EndDateSpecial Programs, orEnd Date
PGM.PED
Gifted/TalentedParticipation - End Date
GTE.PED
Included if Start Date is in current or prior year
E3063 (C344)StudentCharacteristicAdult Previous Attendance (16)School Options (school)Dropout Recovery Campus
OPT.NM = DropoutRecoveryCampus
Secondary Stu Data (school)Adult Prev Att
SSD.APA = Y
SSD.APA is only available at schools where OPT.NM = DropoutRecoverCampus is enabled.
E3010PeriodBeginDateEnrollment HistoryEnter Date
ENR.ED
Most recent record in the current school year
E3020EndDateEnrollment HistoryLeave Date
ENR.LD
E3063 (C344)StudentCharacteristicGeneral Education Homebound (17)Special ProgramsProgram Code
PGM.CD = 412
E3010PeriodBeginDateSpecial ProgramsStart Date
PGM.PSD
E3020EndDateSpecial ProgramsEnd Date
PGM.PED
E3063 (C344)StudentCharacteristicParent Request Retention (18)RetentionsCode
RET.CD = PR
E3010PeriodBeginDateRetentionsDate
RET.DT
E3020EndDate
N/A
E3063 (C344)StudentCharacteristicBilingual/ESL Summer School (19)Special ProgramsProgram Code
PGM.CD =145
E3010PeriodBeginDateSpecial ProgramsStart Date
PGM.PSD
E3020EndDateSpecial ProgramsEnd Date
PGM.PED
E3063 (C344)StudentCharacteristicAdditional Days Program Participation (20)In development
E3010PeriodBeginDateIn development
E3020EndDateIn development
E3063 (C344)StudentCharacteristicVirtual Student Not in Membership (21)Special ProgramsProgram Code
PGM.CD =413
E3010PeriodBeginDateSpecial ProgramsStart Date
PGM.PSD
E3020EndDateSpecial ProgramsEnd Date
PGM.PED
E3063 (C344)StudentCharacteristicR-PEP Participation (22)In development
E3010PeriodBeginDateIn development
E3020EndDateIn development
E3063 (C344)StudentCharacteristicDropout Recovery Program (23)School Options

Dropout Recovery Campus

OPT.NM = 'DropoutRecoveryCampus'

Enrollment HistorySchool
ENR.SC
E3010PeriodBeginDateEnter Date
ENR.ED
E3020EndDateLeave Date
ENR.LD



Extracted for students enrolled at a dropout recovery campus any time during the current school year (ENR.SC =

= OPT.SC where OPT.NM = 'DropoutRecoveryCampus' = True)

.ElectronicMail (multiple allowed)
E1243ElectronicMailAddressDemographicsStudent's Email
STU.SEM
DemographicsPersonal Stu Email
STU.SPE
both are sent if populated
E1242 (C302)ElectronicMailType01 if STU.SPE
02 if STU.SEM 
.Telephone (multiple allowed)
E1269TelephoneNumberDemographicsTelephone - Primary
STU.TL
E1455 (C308)TelephoneNumberTypehard-coded as 02 - Home




Level 1 Errors - Student Identification and Demographics


See Also: Ed-Fi - Troubleshooting Errors.


TSDS ErrorRecommendation
Student Education Organization Association Exception was thrown while upserting StudentEducationOrganizationAssociation, dateMet is a required property for TxStudentEducationOrganizationAssociationTruancySet and cannot be nullEnter the Truancy Date met (STU.TDM) on the Demographics (Student Data 2 tab) for all students where STU.TRU = Y.

Query to find all truant students missing Truancy Date met:

LIST STU IF TRU = "Y" AND TDM = NULL

Unexpected Error Occurred on the ServerVerify that there are no overlapping begin and end dates or duplicate records in Aeries for any sets of data.  We have requested from TEA that more information on which set of data is causing this error.
Exception was thrown while creating ‘{EntityName}’ … The # item of the ‘{EntitySetName}’ collection is a duplicateVerify that there are not overlapping begin and end dates or duplicate records in Aeries for that set of data.

400 BAD_REQUEST

{message: “Validation of 'Parent' failed.\n\tValidation of 'ParentAddresses' failed.\n\t\tParentAddress[0]: AddressTypeDescriptorId is required.\n\t\tParentAddress[0]:

PostalCode is required.\n\t\tParentAddress[0]: StreetNumberName is required}.

Verify Parent Address street name, street number, and postal code, which are required fields.

400 BAD_REQUEST

{message: “Validation of 'Parent' failed.\n\tValidation of 'ParentAddresses' failed.\n\t\tParentAddress[0]: AddressTypeDescriptorId is required.\n”}.

Verify Parent Address street name.

403 FORBIDDEN

{message: “Authorization denied. No relationships have been established between the caller's education organization id claim (194902) and the resource item's 'ParentUniqueId' value.”}

Verify that parent was loaded to ODS.

400 BAD_REQUEST

{message: “Validation of 'Parent' failed. FirstName is required.”}

Verify that parent first name is entered.

Error Message Issue

400 BAD_REQUEST

{message: “Unable to resolve value

“uri:/tea.texas.gov/AsOfStatusLastDayEnrollmentDescriptor#B” to an existing

“AsOfStatusLastDayEnrollmentDescriptor” resource.”}


Verify that As Of Status is H or I.

400 BAD_REQUEST

{message: “Validation of 'Student' failed. Unable to resolve value 'uri:/tea.texas.gov/CrisisEventDescriptor#10' to an existing 'CrisisEventDescriptor' resource.”}

Verify that Crisis Event is a valid value in C178.


403 FORBIDDEN

{message: “Authorization denied. No relationships have been established between the caller's education organization id claim (194902) and the resource item's 'StudentUniqueId' value.”}


409 CONFLICT

{message: “Access to the resource item could not be authorized because the 'Student' was not found.”}


Verify that student was loaded to ODS.

400 BAD_REQUEST

{message: “Validation of 'StudentParentAssociation' failed. Parent reference could not be resolved.”}

Verify that parent was loaded to ODS.

403 FORBIDDEN

{message: “Authorization denied. No relationships have been established between the caller's education organization id claim (194902) and one or more of the following properties of the resource item: 'ParentUniqueId', 'StudentUniqueId'”}

Verify that parent and student are associated.

403 FORBIDDEN

{message: “Authorization denied. No relationships have been established between the caller's education organization id claim (194902) and the resource item's 'StudentUniqueId' value.”}

Verify that student and parent were loaded to ODS.
CON