Student Grade (SG) Table Import File Layout
To import historical grade records in to the StoredGrades table, you must create a tab-delimited file with the following column headers and field sequence. It is necessary to delete fields from the Stored Grade report text file to complete the import.
You must run the Stored Grades report to create an extract file for import. The Stored Grades DCID field is required for the import. You must modify the file layout with the information to be imported. The existing data in the fields is lost if a file is imported with missing information in any of the custom fields.
Column Header | Definition | Related PowerSchool Field |
|---|---|---|
DCID | Record Identifier for the record. DO NOT MODIFY | [StoredGrades]Course_Number |
VER | Verified credits earned by the student for this course. | [StoredGrades]VA_Verified_Credit |
SUB | Value should be 1 if this course is a substitute credit course or 0 if this course is not a substitute credit course. | [StoredGrades]VA_Substitute_Credit |
DL | Value should be 1 if this is a distance learning course or 0 if this course is not a distance learning course. | [StoredGrades]VA_Distance_Learning |
DE | Value should be 1 if this is a dual enrollment course or 0 if this course is not a dual enrollment course. | [StoredGrades]VA_Dual_Enrollment |
AP | Value should be 1 if this is an advanced placement course or 0 if this course is not an advanced placement course. | [StoredGrades]VA_Advanced_Placement |
ACC | Value should be 1 if this is an accelerated course or 0 if this course is not an accelerated course. | [StoredGrades]VA_Accelerated |
HON | Value should be 1 if this is an honors course or 0 if this course is not an honors course. | [StoredGrades]VA_Honors |
IB | Value should be 1 if this is an International Baccalaureate course or 0 if this course is not an International Baccalaureate course. | [StoredGrades]VA_Baccalaureate |
ALTSCHOOLID | School ID for a course taken in another district. | [StoredGrades]Alternate_School_Number |
ALTCOURSEID | NCES course number for a course taken at another district. | [StoredGrades]VA_Alternate_Course_ID |