Grades and Transcripts

grades

Primary PowerSchool Source Data

Tables: STOREDGRADES (sg), STUDENTS (s), CC, SECTIONS (sec), COURSES (crs) TERMS (t), TERMBINS (tb)Optional configuration: PGFINALGRADES (pgf)

Selection Criteria

Requested for TX Exchange, not collected by TEA; published per Base Profile )with TX section reference)Published for all enrolled students with section grades where:

• Student, section, and/or school not excluded from publishing

• Term/Storecode combination not excluded from publishing (Misc Mapping 'Excluded Reporting Terms')

• Permanent grades published from STOREDGRADES.  Types include: 'Final', 'Semester', 'Grading Period'

• Grade type determined from GradeType mapping or heuristic rules if not mapped

• Progress grades published from PGFINALGRADES if configured and corresponding STOREDGRADES record does not exist

• Type = 'Progress Report', all cases

• Profile config parameter 'PublishFinalGrades' = 1 flags publishing progress grades from PGFINALGRADES

• Publish only if grade <> '-' or percent > 0

Report Output

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

Comments

Grades

gradetypeDescriptor

Permanent Grades from StoredGrades:

• derived from sg.storecode, sec.termid, t.portion, t.abbreviation

• as mapped in GradeType mapping for storecode/term combination

• otherwise heuristic rules and term portion used to determine gradeType

Progress Grades from PGFinalGrades:

• always 'Progress Report'

Y-key

Permanent grade values: 'Final', 'Semester' (also applies to trimesters), 'Grading Period'
Always 'Progress Report' for progress grades

gradingPeriodReference

derived from sg.storecode or pgf.finalgradename by matching on terms.abbreviation or from 'Reporting Terms' mapping; otherwise uses terms record from sg.termid

Y-key

Reporting Terms' misc mapping available for storecodes in termbins that don't match a term abbreviation

gradingPeriodDescriptor

derived from sg.storecode/pgf.finalgradename, t.portion, t.abbreviation

Y

periodSequence

derived from sg.storecode/pgf.finalgradename, t.portion, t.abbreviation

Y

schoolId

sec.schoolid

Y

where = p_schoolid

schoolYear

t.yearid

Y

where = p_yearid

studentSectionAssociationReference

Y-key

v3 reference

beginDate

cc.dateenrolled

Y

min insession date on or after dateenrolled and between section term firstday and lastday

localCourseCode

sec.course_number

Y

trimmed and spaces replaced with underscore

schoolId

sec.schoolid

Y

formatted for publishing

schoolYear

terms.yearid + 1991

Y

sectionIdentifier

E1056

CLASS-ID-NUMBER

Sections: S_TX_SEC_X.E1056_SectionIden_Calc
Manual Stored Grades: S_TX_SGR_X.E1056_SectionIden_Calc
For now, publish only the first 14 chars of the calculated section identifier.

Y

FYI: Override fields (not used in publishing)

• Sections: S_TX_SEC_X.E1056_SectionIden_Ovr

• Stored Grades:  S_TX_SGR_X.E1056_SectionIden_Ovr

sessionName

Composite using t.schoolid, t.abbreviation, t.dcid

Y

FORMAT:  t.schoolid '-' t.abbreviation '-' t.dcid

studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

State-assigned number for student  (STUDENTS.state_studentnumber)

Y

diagnosticStatement

to_char(substr(sg.comment_value, 1, 1024))

N

letterGradeEarned

trim(sg.grade)

C-Y

numericGradeEarned

sg.percent

C-Y

additional fields for display only

sch.school_name

district view only - from sp.schoolid

s.student_number

s.lastfirst

crs.course_name

sec.section_number

sec.termid

gradingPeriodDescriptor shortDescription

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

Comments

studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

derived from sg.studentid

Y

State-assigned number for student  (s.state_studentnumber)

educationOrganizationId

School where section was taken

Y

Requires special handling of sections taken at other schools; will always be student's enrolled school at that time

schoolYear

E1093

SCHOOL-YEAR

trm.yearid from sg.termid + 1991

Y

termDescriptor

E0934

derived from sg.storecode mapping in S_TX_TRM_C

Y

S_TX_TRM_C.AAR_GradeColumn_Mapping

• S1 - '10' Fall Semester

• S2 - '11' Spring Semester

• AV - '24' Year Round

diplomas

[Array]

TX

multiple diplomaTypes possible, publish each with same date diplomaAwardDate and diplomaLevelType
Feb 2022 - moved temporarily to AsOfStatusALeaversExtension entity, reinstated 2022-23 school year

diplomaTypeDescriptor

E0806

GRADUATION-TYPE-CODE

S_TX_STU_X.E0806

TX

diplomaAwardDate

E0791

DATE-OF-GRADUATION

S_TX_STU_X.E0791

TX

achievementCategoryDescriptor

LZ

Publish 'Diploma Earned' if diplomaTypeDescriptor and diplomaAwardDate both non-null

TX

Previously '01' Diploma Earned - former TEA descriptor, deleted in Jul 23 spec.  Landing Zone only, not collected by TEA

TX diploma Extensions

TX

     fhspDistingLevelGraduate

E1542

FHSP-DISTING-LEVEL-ACHIEVE-INDICATOR-CODE

S_TX_STU_X.E1542_FHSP_Dist = 2

TX

distingLevelAchievementGraduate

E3089

DISTINGUISHED- LEVEL-ACHIEVEMENT-GRADUATE

S_TX_STU_X.E3089_DIST_LEVEL_ACH_GRAD = 1 then '1'       S_TX_STU_X.E3089_DIST_LEVEL_ACH_GRAD = 0 then '0'

TX

     individualGraduationCommitteeGraduateIndicator

E1562

INDIVIDUAL-GRADUATION-COMMITTEE-GRADUATE-CODE

S_TX_STU_X.E1562 = '02'

TX

     militaryEnlistmentIndicator

E1589

MILITARY-ENLISTMENT-INDICATOR-CODE

S_TX_STU_X.E1589_Military_Enlistment = 1

TX

     financialAidApplicationDescriptor

E1724

FINANCIAL-AID-APPLICATION-CODE

S_TX_STU_X.Fin_Aid_App_Code

TX

added 4-22

     texasFirstEarlyHSCompletionProgramDescriptor

E1736

TEXAS-FIRST-EARLY-HS-COMPLETION-PROGRAM

S_TX_STU_X.E1736_TXFirstEarlyHS

TX

source added in PSSR-315963

TX Extensions

associateDegreeIndicatorDescriptor

E1596

ASSOCIATE-DEGREE-INDICATOR-CODE

S_TX_STU_X.E1596_Associate_Degree_Ind

TX

changed to descriptor Sep 23 spec

fhspDistingLevelParticipant

E3029, E1542

FHSP-DISTING-LEVEL-ACHIEVE-INDICATOR-CODE

S_TX_STU_X.E1542_FHSP_Dist = 1

TX

distingLevelAchievementGraduate

E3089

DISTINGUISHED- LEVEL-ACHIEVEMENT-GRADUATE

S_TX_STU_X.E3089_DIST_LEVEL_ACH_GRAD = 1 then '1'       S_TX_STU_X.E3089_DIST_LEVEL_ACH_GRAD = 0 then '0'

TX

individualGraduationCommitteeReview

E1563

INDIVIDUAL-GRADUATION-COMMITTEE-REVIEW-CODE

S_TX_STU_X.E1563 = '01'

TX

endorsementPursuings

[Array]

TX

     endorsementPursuingDescriptor

E3022

(multiple)

TX

E1544. E1545, E1546, E1547, E1548

               0 - Not Pursuing or Participating

S_TX_STU_X.E1541_FHSP_Part = 0

               1 - Pursuing STEM Endorsement

E1544

STEM-ENDORSEMENT-INDICATOR-CODE

S_TX_STU_X.E1544_STEM_End = 1

               2 - Pursuing Business and Industry Endorsement

E1545

BUSINESS-AND-INDUSTRY-ENDORSEMENT-INDICATOR-CODE

S_TX_STU_X.E1545_BI_End = 1

               3 - Pursuing Public Services Endorsement

E1546

PUBLIC-SERVICES-ENDORSEMENT-INDICATOR-CODE

S_TX_STU_X.E1546_PS_End = 1

               4 - Pursuing Arts and Humanities Endorsement

E1547

ARTS-AND-HUMANITIES-ENDORSEMENT-INDICATOR-CODE

S_TX_STU_X.E1547_AH_End = 1

               5- Pursuing Multi Disciplinary Studies Endorsement

E1548

MULTI-DISCIPLINARY-STUDIES-ENDORSEMENT-INDICATOR-CODE

S_TX_STU_X.E1548_MS_End = 1

industryBasedCertificationSets

[Array]

TX

One record for each certfication for the student in S_TX_STU_PERF_ACKN_C wehre performance_indicator = 'CL'
Feb 2022 - copied temporarily to AsOfStatusALeaversExtension entity, through 2024-25 school year

     dateCertTaken

E1632

EFFECTIVE-DATE

S_TX_STU_PERF_ACKN_C.Status_Date

TX

     ibcVendorDescriptor

E1655

IBC-VENDOR-CODE

S_TX_STU_PERF_ACKN_C.E1655_IBC_Vendor_Code

TX

     postSecondaryCertificationLicensureDescriptor

E1640

POST-SECONDARY-CERTIFICATION-LICENSURE-CODE

S_TX_STU_PERF_ACKN_C.E1655_IBC_Indicator_Code

TX

database values are TX descriptor codeValues

     postSecondaryCertLicensureResultDescriptor

E1733

POST-SECONDARY-CERTIFICATION-LICENSURE-RESULT

S_TX_STU_PERF_ACKN_C.E1733_IBC_Cert_Result

TX

added 4-22

     ibcExamFeeAmount

E1654

IBC-EXAM-FEE-AMOUNT

S_TX_STU_PERF_ACKN_C.E1654_IBC_Exam_Fee_Amt

TX

endorsementCompleteds

[Array]

TX

8-22 changed from endorsementCompletedSets

     endorsementCompletedDescriptor

E3021

(multiple)

TX

E1544. E1545, E1546, E1547, E1548

          1 - Completed STEM Endorsement

E1544

STEM-ENDORSEMENT-INDICATOR-CODE

S_TX_STU_X.E1544_STEM_End = 2

          2 - Completed Business and Industry Endorsement

E1545

BUSINESS-AND-INDUSTRY-ENDORSEMENT-INDICATOR-CODE

S_TX_STU_X.E1545_BI_End = 2

          3 - Completed Public Services Endorsement

E1546

PUBLIC-SERVICES-ENDORSEMENT-INDICATOR-CODE

S_TX_STU_X.E1546_PS_End = 2

          4 - Completed Arts and Humanities Endorsement

E1547

ARTS-AND-HUMANITIES-ENDORSEMENT-INDICATOR-CODE

S_TX_STU_X.E1547_AH_End = 2

          5- Completed Multi Disciplinary Studies Endorsement

E1548

MULTI-DISCIPLINARY-STUDIES-ENDORSEMENT-INDICATOR-CODE

S_TX_STU_X.E1548_MS_End = 2

additional fields for display only

sch.school_name

district view only - from sp.schoolid

s.student_number

s.lastfirst

sg.grade_level

grade level during specified school year

CourseTranscripts

Primary PowerSchool Source Data

Tables: STOREDGRADES (sg), STUDENTS (s), CC, SECTIONS (sec), COURSES (crs) TERMS (trm), GRADESCALEITEM (gsi), COURSESCOREFIELDS (ccf), S_TX_TRM_C (xttrm), S_TX_GSI_X (xtgsi), S_TX_SERVICE_ID_S (svcid)
Note: Courses table joined on sg.course_number.  In some cases sg.course_number may be different from sections.course_number.

Selection Criteria

Publish final grades in state-downloaded and locally published courses during current year for enrolled students

• Student and section not excluded from publishing

• includes manually entered grades published as sections (see selection criteria for CourseOfferings)

• exclude if course, section, or grade excluded from PEIMS or otherwise excluded from publishing

• Include final grades for all students where state course code exists

• Publish one CourseTranscript record for each StoredGrades record mapped for final grade reporting in S_TX_TRM_C

• S_TX_TRM_C.Final_Grade = 1

• AND S_TX_TRM_C.AAR_GradeColumn_Mapping is not null (allowed values: 'S1', 'S2', 'AV')

• Include 'AV' grades only if credit awarded or no 'S2' record exists for student section

• References StudentAcademicRecord with matching year and term

Future: include manually-entered stored grades with termid in current year but no begin/end date

• No section record created

• Not reported to TEA (state may need to add Exclude flag)

FYI, legacy rule for TEA reporting:

• Include final grades in high school credit courses or TX VSN courses

• Service Id (state course code) must not start with 'SA', 'SE', SR', 'SS' or '8'

• S_TX_SGR_X.Explanation_Code_Combined does not include 'L' or '3' (field is CSV list)

• Alternate CDC is blank (or same as reporting district)

• High school credit course if S_TX_SERVICE_ID_S.Elig_For_HS = 1, join on state course code = service_id and context yearid

• VSN course if Non-Campus Based Instruction code = '04' or '05'

• Course flag and section override: S_TX_CRS_X.E1072, S_TX_SEC_X.E1072_Non_Campus_Based_Instr

• Storedgrades override: S_TX_SGR_X.Non_Campus_Based_Instr

 Report Output

Resource

Data Element

 Description

TX Element

TX Element Name

Stored in [Table]Field

Required?

Comments

courseAttemptResultDescriptor

E0949

PASS/FAIL-CREDIT-INDICATOR-CODE

Calculated value in S_TX_SGR_X.E0949_PF_Calc; STOREDGRADES.GPA_Custom2 is override.
Calculated values include:

• 01  Course Was Passed And Credit Was Received

• 02  Course Was Failed No Credit Received – 1st Occurrence This School Year

• 09  Course Work Is Incomplete And No Credit Has Been Awarded

• Published for HS Incomplete ('I' or user-defined - use CodeSet Mapping?)

• Default when no final grade found for HS course

• 13  Non-High School Course Passed

• Default for non-HS courses

Other values require entry in override field, GPA_Custom2.

Calculated values derived from cc.termid, sg.grade, sg.percent, sg.potentialcrhrs, sg.earnedcrhrs, gsi.graduationcredit, gsi.cutoffpercentage, gsi.isproficient

Y

Calculated values for High School courses, identified using S_TX_SERVICE_ID_S (svcid)

• svcid.elig_for_hs = 1 where svcid.yearid = context yearid and svcid.service_id = state course code

• if poterntialcrhrs > = and earnedcrhrs = potentialcrhrs then '01'

• If numeric grade > = 70 then '01'

• If letter grade = 'I' then '09' (current UI allows entering other 'Incomplete' grades at runtime, need to replace with mapping)

• If numeric grade < 70 and (potentialcrhrs > 0 or numeric grade > 0) then '02'

• if xtgsi.passing_grade = 1 for letter grade (using gsi lookup), then '01'

• if xtgsi.passing_grade = 0 or null (using gsi lookup), then '02'

• Default to '09'

Calculated values for non-HS courses (all courses not identified as HS credit in S_TX_SERVICE_ID_S)

• If numeric grade >= 70 then '13'

• If numeric grade < 70 and numeric grade > 0 then '14'

• if xtgsi.passing_grade = 1 for letter grade (using gsi lookup), then '13'

• if xtgsi.passing_grade = 0 or null (using gsi lookup), then '14'

• Default to '13'

courseReference

Y

courseCode

E0724

SERVICE-ID

Stored Grades Override: S_TX_SGR_X.Alt_Course_Number (if populated)
Section Override: S_TX_SEC_X.Alt_Course_Number (if populated)
Course Default: COURSESCOREFIELDS.alt_course_number

Courses/StoredGrades Course_Number is not normally used unless:

• Section StoredGrades (type 1-3) - use Courses.Course_Number if:

• all of above are blank

• and Courses.Course_Number is valid 8-char ServiceId

• Manual Entry StoredGrades (type 4) - use StoredGrades.Course_Number if:

• StoredGrades.Course_Number doesn't reference a district course

• and srgx.Alt_Course_Number is blank

• and StoredGrades.Course_Number is valid 8-char ServiceId

Y

Same as for CourseOfferings

educationOrganizationId

Ref

1

Y

TEA-specified EducationOrganizationId for State courses

studentAcademicRecordReference

studentUniqueId

E1523

TX-UNIQUE-STUDENT-ID

derived from cc.studentid

Y

State-assigned number for student  (s.state_studentnumber)

educationOrganizationId

State-assigned number for school where section was taken

Y

Requires special handling of sections taken at other schools; will always be student's enrolled school at that time

schoolYear

E1093

SCHOOL-YEAR

trm.yearid from sg.termid + 1991

Y

termDescriptor

derived from sg.storecode mapping in S_TX_TRM_C

Y

S_TX_TRM_C.AAR_GradeColumn_Mapping

• S1 - '10' Fall Semester

• S2 - '11' Spring Semester

• AV - '24' Year Round

attemptedCredits

sg.potentialcrhrs

N

earnedCredits

LZ

sg.earnedcrhrs

Y

Validation rule 43415-000B list this as mandatory field for TEA

whenTakenGradeLevel

E0017

GRADE-LEVEL-CODE

sg.grade_level

N

not collected by TEA

finalLetterGradeEarned

sg.grade

N

trim(sg.grade)

finalNumericGradeEarned

sg.percent

N

if sg.percent > 0 then sg.percent else if sg.grade is null then 0 else null

courseTitle

crs.course_name

N

trimmed

alternativeCourseCode

crs.course_number

N

replace(trim(course_number),' ','_')

TX Extensions

collegeCreditHours

E1081

COLLEGE-CREDIT-HOURS

S_TX_SGR_X.College_Credit_Hours

TX

Override, usually set at course, S_TX_CRS_X.E1081; section override: S_TX_SEC_X.E1081_College_Credit

dualCreditIndicator

E1011

DUAL-CREDIT-INDICATOR-CODE

S_TX_SGR_X.Dual_Credit

TX

Override, usually set at course, S_TX_CRS_X.E1011_Dual_Credit; section override: S_TX_SEC_X.E1011_Dual_Credit

atcIndicator

E1058

ATC-INDICATOR-CODE

S_TX_SGR_X.ATC_Indicator_Code

TX

Override, usually set at course, S_TX_CRS_X.E1058_ATC_Indicator; section override: S_TX_SEC_X.E1058_ATC_Indicator

additional fields for display only

sch.school_name

district view only - from sp.schoolid

s.student_number

s.lastfirst

sgx.grade_level_code (override), sg.grade_level

sec.section_number

u.lastfirst derived from sec.teacher