GPProgressTest (ver10.0.0)
For reporting purposes, this table contains the derived value of a student's status for a graduation plan's test requirement from the values in the StudentTestScore table. Data assessed by selecting a group of students and then navigating to [Select Function] arrow > Graduation Progress Report Data Capture (or Special Functions > Group Functions > Graduation Progress Report Data Capture).
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| GPStudentTestWaiverID | 10.0.0 | Number(19,0) | Internal number for the associated GPStudentTestWaiver record. Indexed. |
| ID | 10.0.0 | Number(19,0) | A unique sequential number generated by the PowerSchool. Required. Indexed. |
| IsAdvancedPlan | 10.0.0 | Number(1,0) | Column holds Boolean data indicating if the plan version is advanced plan (value=1) or legacy/deprecated (value=0). Required. Defaults to 0. |
| Status | 10.0.0 | Number(5,0) | Indicates the student's current status of the requirement for this test requirement. Valid values: 0=not taken, 1=waived, 2=failed, 3=passed. Defaults to 0. |
| StudentsDCID | 10.0.0 | Number(10,0) | Internal number for the associated Students record. Required. Indexed. |
| GPTestconfigID | 10.0.0 | Number(19,0) | Internal number for the associated GPTestConfig record. Required. Indexed. |
WhenCreated | 10.0.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. Required. |
WhoCreated | 10.0.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |