The following entities are included in the Student Academic Record domain:


Entity: StudentAcademicRecord 

Entity: CourseTranscript 

Level 1 Errors - Student Academic Record


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

  • All students in grades 9-12 who were enrolled at any time during the current school year are reported. 
  • Students from last year who are not enrolled in the current year are excluded, as they are reported in the PriorYearLeaver entity.


Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
ReferenceEducationOrganizationSee Education Organization domain > School entity (SchoolID element)
ReferenceStudentSee Student Identification and Demographics domain > Student entity (StudentUniqueId element)
ReferenceSchoolYearSee School Calendar domain > Session entity (SchoolYear element)
E3022 (C333)EndorsementPursuing (multiple allowed)Graduation StatusOpt-out
STU.EOO
Graduation StatusEndorsement
GEC.EC
Graduation StatusCurrent Status
GEC.ST

If:

STU.EOO is not selected, and

Current Status is Not Complete (GES.ST <> CP)


Then:

  • 1 if GES.EC = ST record exists
  • 2 if GES.EC = BI record exists
  • 3 if GES.EC = PS record exists
  • 4 if GES.EC = AH record exists
  • 5 if GES.EC = MS record exists


Otherwise:

If GEC.ST = 0 or STU.EOO is selected, the element is sent as blank.

E1563IndividualGraduationCommitteeReviewDemographics (Student Data 2 tab)Individual Graduation Committee - Review Code
STU.IGR
  • True if STU.IGR = anything other than blank; otherwise False
  • Required for all students in grades 11 and 12
E1596 (C235)AssociateDegreeIndicatorSecondary Student DataAchievements - Associates Degree
SSD.ADG
Only included if SSD.ADG = 2-6; otherwise omitted
E3030FHSPParticipantDemographics (Student Data 2 tab)Grad Type - Code
STU.HSG *
Graduation Requirements
Graduation Status
Track
REQ.GRT *
True if:
  • STU.HSG <> 34, 35, or 55-57, and (i.e., student has not already graduated)
  • REQ.GRT = 34, 35, 55-57, or blank (i.e., on a graduation plan that qualifies the student for FHSP participation); 
  • otherwise False
Ed-Fi Descriptor Code Set Mapping:
  • Diploma Type Descriptor (STU.HSG) *
  • Diploma Type Descriptor (REQ.GRT) *
E3029FHSPDistingLevelParticipantActivities and AwardsType
ACT.TY
Activities and AwardsCode
ACT.CD
Activities and AwardsReason
ACT.RS
True if: 
  • ACT.TY = 4, and 
  • ACT.CD = DLA. and 
  • ACT.RS = DLA-1; 
  • otherwise False
E3021 (C332)EndorsementCompleted (multiple allowed)Graduation StatusOpt-out
STU.EOO
Graduation StatusEndorsement
GEC.EC
Graduation StatusCurrent Status
GEC.ST

If:

STU.EOO is not selected, and

Current Status is Complete (GES.ST = CP)


Then:

  • 1 if GES.EC = ST record exists
  • 2 if GES.EC = BI record exists
  • 3 if GES.EC = PS record exists
  • 4 if GES.EC = AH record exists
  • 5 if GES.EC = MS record exists


Otherwise:

If GEC.ST = 0 or STU.EOO is selected, the element is sent as blank.

.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
ACT.CD when ACT.TY = 3

Local codes can be used but are not reported to TEA.
E1733 (C232)

PostSecondaryCertLicensureResult


Activities and AwardsCertification Result
ACT.PCR
Activities and AwardsType
ACT.TY
ACT.PCR if populated and ACT.TY = 3
E1654IBCExamFeeAmountActivities and AwardsFee
ACT.IBF
Activities and AwardsTYPE
ACT.TY
ACT.IBF if ACT.TY = 3
E1655 (C226)IBCVendorActivities and AwardsVendor
ACT.IBV
Activities and AwardsType
ACT.TY
ACT.IBV if ACT.TY = 3

Must be one of the approved vendors listed as a Certifying Entity in the Industry-Based Certification Approved Vendor Crosswalk for the particular certification.
.Diploma
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) *
E1562

IndividualGraduationCommitteeGraduateIndicator

Demographics (Student Data 2 tab)Individual Graduation Committee - Grad Code
STU.IGG
True if STU.IGG = any value other than 00; otherwise False
3089DistingLevelAchievementGraduateActivities and AwardsType
ACT.TY
Activities and AwardsCode
ACT.CD
Activities and AwardReason
ACT.RS
1 if 
  • ACT.TY = 4 (Performance Acknowledgement), and 
  • ACT.CD = DLA and ACT.RS = DLA-2, or
  • ACT.CD = TEC;
otherwise 0

Note: 
  • If ACT.CD = TEC, it does not matter what ACT.RS is; the value 1 is extracted.
  • These activities are extracted for all ACT dates.
E1724 (C230)
FinancialAidApplication
Activities and AwardsType
ACT.TY
Activities and AwardsCode
ACT.CD
Activities and AwardsReason
ACT.RS
ACT.RS when ACT.TY = 5 and ACT.CD = G04
01 if ACT.RS = FA1
02 if ACT.RS = FA2
E1736 (C233)TexasFirstEarlyHSCompletionProgramActivities and AwardsReason
ACT.RS
Activities and AwardsCode
ACT.CD
ACT.RS when ACT.CD = TEC
1 if ACT.RS = TEC-1
2 if ACT.RS = TEC-2
otherwise blank



Entity: CourseTranscript

  • Summer courses are included if HIS.ST is one of the schools that are syncing.


Element ID
(Code Table)
Data Element NameAeries PageLabel & 
Aeries Table.Field
ReferenceCourseSee Teaching and Learning domain > Course entity
ReferenceStudentAcademicRecordSee Student Academic Record domain > StudentAcademicRecord entity
ReferenceSectionSee Teaching and Learning domain > Section entity
E0949 (C136)CourseAttemptResultTranscriptsPass/Fail Credit Status
HIS.PF*
Ed-Fi Descriptor Code Set Mapping: Tx Course Attempt Result Descriptor (HIS.PF) *

Records with blank values will fail as level 1 validation errors.
E1080CollegeCreditHoursTranscriptsCollege Credit Hours
HIS.CH
E1011DualCreditIndicatorCoursesCourse Level
CRS.CL
TranscriptsDual Enrollment Credit School (College Level Courses)
HIS.SDE
1 if CRS.CL = 24 and HIS.SDE > 0; otherwise 0
E1058ATCIndicatorMaster ScheduleArticulated Crs
MST.AC
1 if MST.AC = Yes; otherwise 0
E3091SummerSchoolIndicatorTranscriptsYear
HIS.YR
TranscriptsTm (term)
HIS.TE
Courses (Other tab)Type
CRS.TY
If HIS.YR in the current school year and CRS.TY = R
E3097 (C355)DropoutRecoveryCourseCompletionSchool Options
school
OPT.SC
Dropout Recovery Campus
OPT.NM = 'DropoutRecoveryCampus'
TranscriptsCrs ID
HIS.CN
Courses (Other tab)Type
CRS.TY
Courses (Characteristics tab)Code
CCH.CD
Transcripts > Course HistoryCharacteristics Code
CHC.CD
status
CHC.TG
  • 02 if course was completed remotely via Distance Learning* at a Dropout Recovery Campus (OPT.NM = 'DropoutRecoveryCampus' = True)
  • 01 if course was NOT completed remotely via Distance Learning at a Dropout Recovery Campus 
  • Otherwise, omitted


*Remote/Distance Learning courses defined as:

  • HIS.CN = CRS.TY = Z, or
  • HIS.CN = course where CCH.CD = Z, or where CHC.CD = Z and CHC.TG = ''
(C135)

CRS.CSQ * 


Ed-Fi Descriptor Code Set Mapping: Tx Course Sequence Descriptor (CRS.CSQ) * 


Level 1 Errors - Student Academic Record


See Also: Ed-Fi - Troubleshooting Errors.


TSDS ErrorRecommendation

400 BAD_REQUEST

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

Verify that student reference matches school.