Student Transcripts

Academic records including student course grades, credits earned, and cumulative academic achievement by term and school year.

StudentAcademicRecords

Cumulative record of academic achievement for a student per term including credits, GPA, and class ranking.

Primary PowerSchool Source Data

Core tables used in this resource:

• StoredGrades

• Terms

• Students

• Termbins

Selection Criteria

Business logic for publishing this resource:

• Single enrollment record per student selected (prioritizing Record_Type='S' over 'R')

• StoredGrades exist for student at specified school

• Term matches YearID and is part of current school year

• StoredGrade SectionID must exist in termbins OR SectionID = 0 (manual entry)

• termbins TermID must match the stored grade term

Resource Output

Expected output from the selection criteria:

• StudentKeyID (Students.DCID)

• StudentUID (Unique State Student Number)

• AcademicRecordOrgID (School Organization ID)

• SchoolYear (YearID + 1991)

• Term_DX (Descriptor: Y1, S1-S8, T1-T8, N1-N3, X1-X8, F1-F8 based on portion and abbreviation)

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Elements

Details of each data element published in this resource:

CourseTranscripts

Final record of student performance in courses including grades, credits earned, and course details.

Primary PowerSchool Source Data

Core tables used in this resource:

• CC (Class Enrollment)

• StoredGrades

• Sections

• Courses

• Terms

• Students

• S_GA_CC_X (GA extension - course override)

• S_GA_CRS_X (GA extension - course state exclusion)

• S_GA_SGR_X (GA extension - stored grade exclusion and override)

Selection Criteria

Business logic for publishing this resource:

• Single enrollment record per student selected (prioritizing Record_Type='S')

• Class enrollment (CC) exists between first year day and last year day of school year

• Section must not be excluded from state reporting (Exclude_State_Rpt_YN = 0)

• StoredGrade exists for student-section combination

• Term matches school year YearID

• Course override extension (S_GA_CC_X.ExcludeFromSC) must be 0 or null

• Course state exclusion (S_GA_CRS_X.State_ExcludeFromReporting) must be 0 or null

• StoredGrade exclusion (S_GA_SGR_X.ExcludeFromSC) must be 0 or null

• StoredGrade course override (S_GA_SGR_X.COURSEOVERRIDE) must be null

• Maximum date range in termbins matching term and school

• Two branches: (1) Class enrollments linked to sections, (2) Manual entries where SectionID=0

Resource Output

Expected output from the selection criteria:

• StudentKeyID (Students.DCID)

• StudentUID (Unique State Student Number)

• LEAOrgID (LEA/District ID)

• AcademicRecordOrgID (School ID for academic record)

• SchoolOrgID (School ID)

• CourseKeyID (Course code formatted)

• SectionKeyID (Section DCID | Course DCID)

• LocalCourseCode (Formatted local course code)

• InstructionSchoolID (Section or StoredGrade school)

• SchoolYear (YearID + 1991)

• Term_DX (Term descriptor)

• CourseAttemptResult_DX (Pass, Fail, Incomplete, Withdrawn based on grade logic)

• EarnedCredits (Credits earned, 0.0 if grade < 9 unless HS approved)

• FinalLetterGrade (Letter grade: A-F or Z if no grade expected)

• FinalNumericGrade (Numeric grade 0-100 from percent)

• CourseTitle (Course name)

• SectionNumber (Section number)

• CourseNumberName (Course number/name combined)

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Elements

Details of each data element published in this resource: