Resource Overview
-
Ed-Fi endpoint:
/data/v7/grades -
Published view/entity: Grade
-
Purpose: The overall score or assessment tied to a course over a period of time
-
Source query:
Grade -
Dependencies:
gradingPeriods,studentSectionAssociations
grade
This educational resource represents an overall score or assessment tied to a course over a period of time, for example, the grading period. Student grades are usually a compilation of marks and other scores.
Primary PowerSchool Source Data
-
[Courses]
-
[Sections
-
[Terms]
-
[StoredGrades]
-
[Students]
Selection Criteria
Records are published if the following criteria are met:
-
The student was published in the Student category.
-
StudentUniqueId must be populated in PowerSchool.
-
The student must not be excluded from state reporting.
-
The school where the grade was earned must not be excluded from state reporting.
-
The course must have a valid state course code.
-
The section at the school where the grade was recorded must not be excluded from state reporting.
-
The Stored Grades record must not be excluded from transcripts.
Resource Output
|
Data Element (Ed-Fi target) |
Data View Column Name |
Submission |
[Table]Field (PowerSchool Source) |
Business Rules |
Comments |
|---|---|---|---|---|---|
|
gradingPeriodReference.gradingPeriodDescriptor |
GradingPeriod_DX |
Y |
Publishing framework or supporting query Query alias: GradingPeriod_DX |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: GradingPeriod_DX. |
|
gradingPeriodReference.periodSequence |
PeriodSequence |
Y |
Publishing framework or supporting query Query alias: PeriodSequence |
Required by the production resource definition when the resource is published. |
JSON type: number. Query alias: PeriodSequence. |
|
gradingPeriodReference.schoolId |
SchoolOrgID |
Y |
Publishing framework or supporting query Query alias: SchoolOrgID |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: SchoolOrgID. |
|
gradingPeriodReference.schoolYear |
SchoolYear |
Y |
Staging rule: grades p_yearid + 1991 |
Required by the production resource definition when the resource is published. |
JSON type: number. Query alias: SchoolYear. |
|
studentSectionAssociationReference.studentUniqueId |
StudentUID |
Y |
[Students]DCIDd; Transformation: EDFI_TN_LIB.getStudentUniqueId(p_profileid, s.dcid) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: StudentUID. |
|
studentSectionAssociationReference.schoolId |
SchoolOrgID |
Y |
Publishing framework or supporting query Query alias: SchoolOrgID |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: SchoolOrgID. |
|
studentSectionAssociationReference.schoolYear |
SchoolYear |
Y |
Staging rule: grades p_yearid + 1991 |
Required by the production resource definition when the resource is published. |
JSON type: number. Query alias: SchoolYear. |
|
studentSectionAssociationReference.localCourseCode |
LocalCourseCode |
Y |
[Courses]DCID; [Courses]Course_number; [Sections]DCID; [Sections]ID; [Sections]Section_number; Transformation: EDFI_TN_LIB.formaLocalCourseCode(p_profileid, crs.dcid, crs.course_number, p_yearid, sec.dcid, sec.id, sec.section_number) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: LocalCourseCode. |
|
studentSectionAssociationReference.sectionIdentifier |
UniqueSectionCode |
Y |
[Sections]DCIDd; Transformation: CST_PUBWORKFLOW_LIB.formaSectionCodeBase(p_profileid, sec.dcid, p_orgid) |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: UniqueSectionCode. |
|
studentSectionAssociationReference.sessionName |
SessionName |
Y |
Publishing framework or supporting query Query alias: SessionName |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: SessionName. |
|
studentSectionAssociationReference.beginDate |
SectionAssocBeginDate |
Y |
[Terms]Firstday; [Terms]Lastday [StoredGrades]Studentid; [StoredGrades]Sectionid; Transformation: to_char ( coalesce ( ( SELECT min(cd.date_value) FROM calendar_day cd JOIN cc ON cd.schoolid = p_schoolid AND cd.insession = 1 AND cd.date_value between t.firstday AND t.lastday AND cc.studentid = sg.studentid AND abs(cc.sectionid) = sg.sectionid AND cd.date_value >= cc.dateenrolled ), t.firstday ), 'YYYY-MM-DD' ) |
Required by the production resource definition when the resource is published. |
JSON type: datetime. Query alias: SectionAssocBeginDate. |
|
gradeTypeDescriptor |
GradeType_DX |
Y |
Publishing framework or supporting query Query alias: GradeType_DX |
Required by the production resource definition when the resource is published. |
JSON type: string. Query alias: GradeType_DX. |
|
letterGradeEarned |
EarnedLetterGrade |
Conditional |
Publishing framework or supporting query Query alias: EarnedLetterGrade |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: EarnedLetterGrade. |
|
numericGradeEarned |
EarnedNumericGrade |
Conditional |
Publishing framework or supporting query Query alias: EarnedNumericGrade |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: number. Query alias: EarnedNumericGrade. |
|
diagnosticStatement |
DiagnosticStatement |
Conditional |
[StoredGrades]Comment_value; transformation: trim(to_char(substr(sg.comment_value, 1, 300))) |
Submit when the source alias is populated and the parent structure is applicable. |
JSON type: string. Query alias: DiagnosticStatement. |