The following entities are included in the Prior Year Leaver domain:


Entity: PriorYearLeaver

Entity: PriorYearLeaverParent

Entity: PriorYearLeaverStudentParentAssociation


Level 1 Errors - Prior Year Leaver


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: PriorYearLeaver

  • Data is extracted from the prior year database for students in grade level 7-12 who were enrolled last year but not enrolled at the start of the school window this year (As-of Status Code = A, D, or E)


Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
E3079StudentUIdDemographicsUnique ID
STU.CID
ReferenceSchool

See Education Organization domain > School entity (SchoolID element)

E0017 (C050)GradeLevelDemographicsGrd
STU.GR *
Ed-Fi Descriptor Code Set Mapping: Grade Level Descriptor (STU.GR) *

Any grades above 12 (e.g., TR & 14-18) must be mapped to Grade 12
E3028ExitWithdrawDateEnrollment HistoryLeave Date
ENR.LD
E1001 (C162)ExitWithdrawTypeDemographicsLeaver/Mover Reason
STU.LVR
Attendance EnrollmentReason
ATT.RS *
Ed-Fi Descriptor Code Set Mapping: Exit Withdraw Type Desriptor (ATT.RS) *

STU.LVR is extracted, but values are derived from Exit Withdraw Type Descriptor (ATT.RS) mapping.
0923LocalStudentIdDemographicsStudent ID
STU.ID
E0001StudentIdDemographics (Student Data 2 tab)Soc-Sec-Num / State Alternate ID
STU.CID
E0706 (C012)GenerationCodeDemographicsSuffix
STU.SF *
Ed-Fi Descriptor Code Set Mapping: Tx Generation Code Descriptor (STU.SF) *
E0004 (C013)SexDemographicsLegal Gender
LSI.LGN
DemographicsGender
STU.GN *
Ed-Fi Descriptor Code Set Mapping: Sex Descriptor (STU.GN) *

LSI.LGN if populated; otherwise 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) *

E1596 (C235)AssociateDegreeIndicatorSecondary Stu DataAchievements - Associates Degree
SSD.ADG
Optional. Extracted if SSD.ADG = 2-6; otherwise omitted
E1724 (C230)FinancialAidApplicationActivities and AwardsReason
ACT.RS
Activities and AwardsCode
ACT.CD
01 if ACT.CD = G04 and ACT.RS= F1
02 if ACT.CD = G04 and ACT.RS = F2
E3007 (C324)AsOfStatusLastFridayOctoberCalculated. See Texas - As-of-Status Code,
Codes A, E, or D are extracted.
E0896 (C093)ParentalPermissionAuthorizationsCode
AUT.CD
AuthorizationsType
AUT.TY 
AUT.CD when AUT.TY = 4
  • Most recent record
  • Extracted for students included as a leaver in this entity
E3021 (C332)EndorsementCompleted (multiple allowed)Graduation Status or Profile (Endorsement section)Current Status
GES.ST
Endorsement
GES.EC
Opt-out
STU.EOO
(11th & 12th grade only)
Based on GES.EC if GES.ST = CP (Complete) and STU.EOO is not selected.

Harded-coded:
  • 1 if GES.EC = ST 
  • 2 if GES.EC = BI
  • 3 if GES.EC = PS
  • 4 if GES.EC = AH
  • 5 if GES.EC = MS
E3034 (C335)LanguageInstructionProgramServiceSpecial ProgramsProgram Type
PGM.TY
Special ProgramsProgram Code
PGM.CD
PGM.TY when PGM.CD = 146 or 147
  • Most recent record
  • Extracted for students included as a leaver in this entity
E3063 (C344)StudentCharacteristic (multiple allowed)
In Development
Various (PGM.U99 *)
  • For students with no characteristics the element is sent with empty brackets.
Ed-Fi Descriptor Code Set Mapping: Student Characteristic Descriptor (PGM.U99) *
E0894 (C122)TitleIPartAParticipantSchool OptionsTitle I Part A
LOC.T1
Special ProgramsProgram Type
PGM.TY = 0, A, 6, 7, 9
Special ProgramsProgram Code
PGM.CD 
PGM.TY if PGM.CD =121 or 122, or
  • All students attending a Title I, Part A Schoolwide Program School are reported with a TITLE-I-PART-A-INDICATOR-CODE 6.
  • All students receiving Title I, Part A services at a targeted assistance campus are reported with a TITLE-I-PART-A-INDICATOR-CODE 7.


Requires student to be enrolled in either a Title I school (LOC.T1 is populated) OR enrolled in a non-Title I school but participating in a Title I program.

E0785 (C054)EconomicDisadvantageFree and ReducedNSLP Lunch Type Code
FRE.CD *
Free and ReducedNSLP Eligibility - Start Date
FRE.ESD
Ed-Fi Descriptor Code Set Mapping: Tx Economic Disadvantage Descriptor (FRE.CD) *

FRE.CD for the most recent FRE.ESD
E0790 (C061)EmergentBilingualIndicatorSpecial ProgramsProgram Type
PGM.TY *
Special ProgramsProgram Code
PGM.CD
Ed-Fi Descriptor Code Set Mapping: Tx Emergent Bilingual Indicator Descriptor (PGM.TY) *

PGM.TY if PGM.CD = 148
E1528 (C196)FosterCareTypeSpecial ProgramsProgram Type
PGM.TY *
Special ProgramsProgram Code
PGM.CD
Ed-Fi Descriptor Code Set Mapping: Tx Foster Care Type Descriptor (PGM.TY) *

PGM.TY if PGM.CD = 190
E1082 (C189)HomelessStatusSpecial ProgramsHomeless Dwelling Type
PGM.HDT *
Special ProgramsProgram Code
PGM.CD
Ed-Fi Descriptor Code Set Mapping: Tx Homeless Status Descriptor (PGM.HDT) *

PGM.HDT if PGM.CD = 191
E1529 (C197)MilitaryConnectedStudentSpecial ProgramsProgram Type
PGM.TY *
Special ProgramsProgram Code
PGM.CD
Ed-Fi Descriptor Code Set Mapping: Tx Military Connected Student Desriptor (PGM.TY) *

PGM.TY if PGM.CD = 192
E0794SpecialEducationStudentSpecial EducationPrimary Disability
CSE.DI
Special Education (Disabilities History tab)Primary Disability
DHS.DI
Special EducationEntry Date/Exit Date
CSE.ED/CSE.XD
Primary Disability is entered on Disabilities History tab (DHS.DI) but extracted from General tab.

1 if CSE.DI/DHS.DI exists in current school year; otherwise 0   
.Name
E0703FirstNameDemographicsLegal First Name
LSI.LFN
DemographicsFirst Name
STU.FN
LSI.LFN if populated; otherwise STU.FN
E0704MiddleNameDemographicsLegal Middle Name
LSI.LMN
DemographicsMiddle Name
STU.MN
LSI.LMN if populated; otherwise STU.MN
E0705LastSurnameDemographicsLegal Last Name
LSI.LLN
DemographicsLast Name
STU.LN
LSI.LLN if populated; otherwise STU.LN
.BirthData
E006BirthDateDemographicsBirthdate
STU.BD
.Language (multiple allowed)
E3033 (C092)

Language

DemographicsStudent Language
STU.HL *
DemographicsHome Language
STU.CL

Ed-Fi Descriptor Code Set Mapping: Language Descriptor (STU.HL); Also maps to STU.CL *

  • If STU.HL and STU.CL are different, both are extracted with the corresponding LanguageUse element codes.
  • If STU.HL and STU.CL are the same, the Language element is extracted once, but both LanguageUse element codes are extracted.
E3035 (C336)LanguageUse

Hard-coded according to Language element (E3033): 


For Home Language (STU.CL):

uri://tea.texas.gov/LanguageUseDescriptor#01


For Student Language (STU.HL):

uri://tea.texas.gov/LanguageUseDescriptor#02

.IndustryBasedCertificationSet (multiple allowed)
E1632DateCertTakenActivities and AwardsDate
ACT.DT
Activities and AwardsType
ACT.TY
ACT.DT when ACT.TY = 3
E1640 (C214)PostSecondaryCertificationLicensureActivities and AwardsCode
ACT.CD
Activities and AwardsType
ACT.TY
ACD.CD when ACT.TY = 3
  • Local codes can be added but are not reported to TEA.
E1733 (C232)PostSecondaryCertLicensureResultActivities and AwardsCertification Result
ACT.PCR
Activities and Awards

Type
ACT.TY
ACT.PCR if populated; otherwise omitted
  • DateCertTaken must be in current school year.
E1654IBCExamFeeAmountActivities and AwardsFee
ACT.IBF
Activities and AwardsType
ACT.TY
Activities and AwardsCode
ACT.CD
ACT.IBF if ACT.TY = 3 and ACT.CD is populated
E1655 (C226)

IBCVendor

Activities and AwardsVendor
ACT.IBV
Activities and AwardsType
ACT.TY
ACT.IBV IF ACT.TY = 3
  • Must be an approved vendor listed as a Certifying Entity in the Industry-Based Certification Approved Vendor Crosswalk for the particular certification
.GraduationSet
Included if:
  • Leaver Status (STU.LVR) = 01
  • Grade (STU.GR) >= 9
  • Graduation Date (STU.DG) > July 1st of prior year
E0791DiplomaAwardDateDemographics (Student Data 2 tab)Grad Type - Date
STU.DG
E0806 (C062)DiplomaTypeDemographics (Student Data 2 tab)Grad Type - Code
STU.HSG *
Ed-Fi Descriptor Code Set Mapping: Diploma Type Descriptor (STU.HSG) *

STU.HSG if populated; otherwise the TSDS descriptor for 34 - Foundation HS Program
E1562IndividualGraduationCommitteeGraduateIndicatorDemographics (Student Data 2 tab)Individual Graduation Committee - Grad Code
STU.IGG
1 if STU.IGG = any value other than 00 or blank; otherwise 0.

Only extracted for students in grade 11 or 12.
E1589MilitaryEnlistmentIndicatorSecondary Stu DataAct. Military
SSD.ADM
1 if SSD.ADM = Y; otherwise 0
E1542FHSPDistingLevelGraduateActivities and AwardsType
ACT.TY
Activities and AwardsCode
ACT.CD
Activities and Awards
Reason
ACT.RS
1 if ACT.TY = 4, ACT.CD = DLA, and ACT.RS = DLA-2; otherwise 0
E1736 (C233)TexasFirstEarlyHSCompletionProgramActivities and AwardsCode
ACT.CD
Activities and AwardsReason
ACT.RS
1 if ACT.CD = TEC and ACT.RS = TEC-1.
2 if ACT.CD = TEC and ACT.RS = TEC-2; 
otherwise blank.
.Address
E1113 (C300)AddressTypeHard-coded:

For Home:
uri://tea.texas.gov/AddressTypeDescriptor#01

For Mailing:
uri://tea.texas.gov/AddressTypeDescriptor#04
E1114StreetNumberNameDemographicsAddress
STU.AD
E1115ApartmentRoomSuiteNumberDemographicsAddress
STU.AD
E1117CityDemographicsCity
STU.CY
E1118
(C307)
StateAbbreviationDemographicsState
STU.ST
E1119

PostalCode

DemographicsZip
STU.ZC
.ElectronicMail (multiple allowed)
E1243

ElectronicMailAddress

Demographics (Student Data 2 tab)

Personal - Stu Email

STU.SPE
DemographicsStudent's Email
STU.SEM
STU.SPE if populated; otherwise STU.SEM
E1242 (C302)

ElectronicMailType

Hard-coded for each type:
01 - Home/Personal
02 -
.Telephone (multiple allowed)
E1269TelephoneNumberDemographicsTelephone-Primary
STU.TL
E1455 (C308)

TelephoneNumberType

Hard-coded for Home: uri://tea.texas.gov/TelephoneNumberTypeDescriptor# 02



Entity: PriorYearLeaverParent

(multiple allowed)  

  • Only sent for Primary Contact (CON.PC = Y). 
  • Restricted Contacts (Record Type (CON.CD) = R) are excluded.
Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
E3078ParentUIdDemographics (Student Data 2 tab)Unique ID
STU.CID
ContactsContact Order
CON.OR
STU.CID-CON.OR
E0706 (C012)GenerationCodeContactsSuffix
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
E1113 (C300)AddressTypeHard-coded:

For Home:
uri://tea.texas.gov/AddressTypeDescriptor#01

For Mailing:
uri://tea.texas.gov/AddressTypeDescriptor#04
E1114StreetNumberNameContactsAddress
CON.AD
E1115ApartmentRoomSuiteNumberContactsAddress
CON.AD
E1117CityContactsCity
CON.CY
E1118 (C307)StateAbbreviationContactsState
CON.ST
E1119PostalCodeContactsZip Code
CON.ZC
.ElectronicMail
E1243ElectronicMailAddressContactsEmail Address
CON.EM
E1242 (C302)ElectronicMailTypeHard-coded as 01 - Home/Personal
.Telephone
E1269TelephoneNumberContactsTelephone
CON.TL
E1455 (C308)TelephoneNumberTypeHard-coded as 02 - Home

Entity: PriorYearLeaverStudentParentAssociation

(multiple allowed)

Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
ReferencePriorYearLeaverParentSee Prior Year Leaver domain > PriorYearLeaverParent entity
ReferencePriorYearLeaverSee Prior Year Leaver domain > PriorYearLeaver entity
E1423 (C305)RelationContactsRelationship
CON.RL *
Ed-Fi Descriptor Code Set Mapping: Relation Descriptor (CON.RL) *
E1427ContactPriorityContactsContact Order
CON.OR




Level 1 Errors - Prior Year Leaver


See Also: Ed-Fi - Troubleshooting Errors.


TSDS ErrorRecommendation

400 BAD_REQUEST

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

Verify that leaver student First Name exists.

400 BAD_REQUEST

{message: “Validation of 'PriorYearLeaver' failed. AsOfStatusLastFridayOctoberDescriptorId is required.”}

Verify that As Of Status exists for the student.


400 BAD_REQUEST

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

Verify that Exit Withdrawal Type is valid C162 value.

400 BAD_REQUEST

{message: “The request is invalid.”,“modelState”: {“request. Id”: [“The value 'id' is not valid for Id.”],“request. BirthCity”: [],“request. BirthDate”: [“The value 'birthDate' is not valid for BirthDate”}

Verify that Birth City and Birth Date exist for the leaver student.

Verify that Birth Date format contains hyphens.