Skip to main content
Skip table of contents

Student Transcripts

This category captures the cumulative record of academic achievement for a student in the form of student diploma information. The Student Transcripts category includes the following data views and resources:

Academic Records

This view captures information about student diplomas as published in the studentAcademicRecord resource. The layout includes the School Name, Student Number, Student Name, and Grade Level, along with Exit Date, Exit Type, High School Completion Credential, Wisconsin Student Number, Last Publish Date, and the Publishing ID.

studentAcademicRecord

This educational resource represents the student and diploma information.

Primary PowerSchool Source Data

  • [Students]
  • [ReEnrollments]

  • [S_WI_STU_X]

  • [S_WI_REN_X]

Selection Criteria

Records are published if the following criteria are met:

  • The student's school of enrollment must not be excluded from state reporting.
  • The student's school of enrollment must have an Ed-Fi State School number.
  • The student's school of enrollment must have a WISEdata Reporting option.
  • The student must not be excluded from state reporting.
  • A student record has been published for the student.
  • The studentUniqueId (Wisconsin Student Number/WISEid) must be populated in PowerSchool.
  • The student must have at least one school enrollment with an Entry Date that falls on or within the date range defined by [Terms]FirstDay and [Terms]LastDay of the year for the Term selected in the PowerSchool UI.
  • The enrollment ExitDate is greater than the EntryDate.
  • The student is in grade level 9 or above.
  • The value for the student's High School Credential Type ([S_WI_STU_X]Credential) is not blank.

Resource Output

  • A studentAcademicRecord is published for each student enrolled in the current school year who meets the selection criteria.
  • Only information from the student's most recent school of enrollment is published. When changes to any of the following elements occur within PowerSchool, an update to the student's Academic Record is published:
    • ExitDate or ExitCode modified
    • GradeLevel modified
    • Student transfers to School 999999
    • [S_WI_STU_X]Credential added or modified
  • The studentAcademicRecord resource is dependent on the prior publishing of the following resources: student and studentSchoolAssociation.
  • LEAs and Schools may upload (publish) data to the ODS in real time ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Data Element

Description

[Table]Data Type

Stored in [Table]Field

Req’d

educationOrganizationReference

A reference to the related school resource.

R

/educationOrganizationID

The education organization that is associated with the student academic record.

Integer

SchoolId downloaded from State

Derived from:

[S_WI_SCH_X]EdFi_StateSchoolNumber, or if this field is blank then

[Schools]Alternate_School_Number] if greater than 0

Otherwise, [Schools]School_Number

[ReEnrollments]SchoolID (historical)

R

schoolYearTypeReference

The identifier for the school year.

String

[Terms]YearID

R

studentReference

A reference to the related student resource.   

R

/studentUniqueId

Identifies the student associated with the student academic record.

Integer

[Students]State_StudentNumber

R

termDescriptor

The term for the session during the school year.

String

‘Annual’ is published in all records.

R

diplomas – studentAcademicRecordDiploma array

This array represents the cumulative record of academic achievement for a student.

* This array is required if applicable to the student; otherwise, it is excluded from publishing.

O*

/diplomaType

The type of diploma/credential that is awarded to a student in recognition of his/her completion of the curricular requirements.

String

[S_WI_STU_X]Credential

[S_WI_REN_X]Credential

R:  'Regular diploma'

E:  'High school equivalency credential, other than GED'

C: 'Other diploma'

R

/diplomaAwardDate

The month, day, and year on which the student met graduation requirements and was awarded a diploma.

Date-time

[Students]ExitDate

[Reenrollments]ExitDate

The most recent exit date from the current school year is published.

R

/achievementCategoryDescriptor

This descriptor defines the category of achievement attributed to the student.

String

[S_WI_STU_X]Credential

[S_WI_REN_X]Credential

R or E: 'Diploma earned'

C: ‘Certificate earned’

R


courseTranscripts

This educational resource represents the student and diploma information.

Primary PowerSchool Source Data

  • [Students]
  • [ReEnrollments]

  • [S_WI_STU_X]

  • [S_WI_REN_X]

  • [StoredGrades]
  • [Courses]

Selection Criteria

Records are published if the following criteria are met:

  • The student's school of enrollment must not be excluded from state reporting.
  • The student's school of enrollment must have an Ed-Fi State School number.
  • The student's school of enrollment must have a WISEdata Reporting option.
  • The student must not be excluded from state reporting.
  • A student record has been published for the student.
  • The studentUniqueId (Wisconsin Student Number/WISEid) must be populated in PowerSchool.
  • The student must have at least one school enrollment with an Entry Date that falls on or within the date range defined by [Terms]FirstDay and [Terms]LastDay of the year for the Term selected in the PowerSchool UI.
  • The enrollment ExitDate is greater than the EntryDate.
  • The student is in grade level 9 or above.
  • The value for the student's High School Credential Type ([S_WI_STU_X]Credential) is not blank.
  • The stored grade must be marked to be included on the transcript.
  • The course and section must not be marked as excluded from state reporting for records with a section/course in the database.

Resource Output

  • A courseTranscript record is published for each stored grade for a student for grades 9 and above.
  • The courseTranscript resource is dependent on the prior publishing of the following resources: student, studentSchoolAssociation and studentAcademicRecord.
  • LEAs and Schools may upload (publish) data to the ODS in real time ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Data Element

Description

[Table]Data Type

Stored in [Table]Field

Req’d

courseReference

A reference to the related school resource.

R

/educationOrganizationID

The education organization that is associated with the student academic record.

Integer

Hardcoded to 48856

R

/courseCodeState Course Code. Derived from the course list downloaded from the state and associated based on the SCED 5 Code, the Course code and then the alternate course number.StringState Course Code Downloaded from WISEData.R

externalEducationOrganizationReference /educationOrganizationId

The identifier for the school year.

String

SchoolId downloaded from State

Derived from:

[S_WI_SCH_X]EdFi_StateSchoolNumber, or if this field is blank then

[Schools]Alternate_School_Number] if greater than 0

Otherwise, [Schools]School_Number

[ReEnrollments]SchoolID (historical)

R

studentAcademicRecordReference

A reference to the related student resource.   

R

/studentUniqueId

Identifies the student associated with the student academic record.

Integer

[Students]State_StudentNumber

R

/educationOrganizationIdThe organization where this class was taught.

SchoolId downloaded from State

Derived from:

[S_WI_SCH_X]EdFi_StateSchoolNumber, or if this field is blank then

[Schools]Alternate_School_Number] if greater than 0

Otherwise, [Schools]School_Number

[ReEnrollments]SchoolID (historical)

R
/schoolYearThe identifier for the school year.Integer[Terms]YearIDR
/termDescriptorThe identifier for the associated term based on the term associated with the stored grade.String[Terms]IDR

courseAttemptResultDescriptor

The identifier of the attempt result of the grade.

String

Determined with the following order:

  1. When the first letter of the grade is W, then Withdrawn is published.
  2. If the CC records associated with this grade have been dropped, then Withdrawn is published.
  3. When Earned Credits = Potential Credits, then Pass is published.
  4. When Eared Credits < Potential Credits or grade is blank and Exclude from GPA is marked, then Incomplete is published.
  5. When grade is blank and percent is blank or 0 and earned credits is 0, then Pass is published.
  6. When the first letter of grade is P, N, or S, then Pass is published.
  7. When the first letter of grade is I, then Incomplete is published.
  8. When the first letter of grade is F, then Fail is published.
  9. When the grade scale grade is marked with Graduation Credit or Is Proficient, then Pass is published.
  10. When the grade scale grade is not marked with Graduation Credit, then Fail is published.
  11. If nothing qualifies above, then Pass is published.

R

attemptedCreditsCredits attempted for this class.Number[StoredGrades] PotentialCrHrsO
earnedCreditsCredits earned for this class.Number[StoredGrades] EarnedCrHrsR
whenTakenGradeLevelDescriptorGrade level when this class was takenString[StoredGrades] Grade_LevelO
methodCreditEarnedDescriptorMethod of how the credit was earned. Based on Transfer Credit or Classroom Credit.StringWhen the stored grade is not associated with a local section and the store code is not SS, then Transfer credit is published, otherwise, Classroom credit is published.O
finalLetterGradeEarnedFinal Grade Letter earned.String[StoredGrades] GradeO
finalNumericGradeEarnedFinal Percentage earned.Number

[StoredGrades] Percent

If Percent > 0, the Percent is published.
If Grade is blank and Percent is 0 or blank, then 0 is published.
Otherwise, blank is published.

O
alternativeCourseTitleLocal Course NameString[Courses] Course_NameO
alternativeCourseCodeLocal Course NumberString[Courses] Course_NumberO



Back to top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close