S_NC_HIST_RANK (ver 13.6.0)
This table is an extension of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| DATERANKED | 13.6.0 | DATE | Indicates the date of the ranking. |
| GPA | 13.6.0 | VARCHAR2(80) | The GPA used for the ranking. |
| GPAMETHOD | 13.6.0 | VARCHAR2(50) | The GPA method used for the ranking. |
| GRADE_LEVEL | 13.6.0 | NUMBER(11,0) | The grade level of the student at the time of the ranking. |
| ID | 13.6.0 | NUMBER(19,0) | Primary key. |
| OUTOF | 13.6.0 | NUMBER(11,0) | The class size for the grade level at the time of the ranking. |
| PSGUID | 13.6.0 | VARCHAR2(50) | |
| RANK | 13.6.0 | NUMBER(11,0) | The student's class rank. |
| SCHOOLID | 13.6.0 | NUMBER(11,0) | The school number for the student. |
| SCHOOLNAME | 13.6.0 | VARCHAR2(60) | The name of the school where the student is enrolled. |
| STORECODE | 13.6.0 | VARCHAR2(10) | |
| STUDENTID | 13.6.0 | NUMBER(11,0) | The student number. |
| STUDENTSDCID | 13.6.0 | NUMBER(19,0) | Foreign key to link to the students table. |
| UNUSED1 | 13.6.0 | NUMBER(11,0) | |
| UNUSED2 | 13.6.0 | VARCHAR2(100) | |
| UNUSED3 | 13.6.0 | VARCHAR2(100) | |
| UNUSED4 | 13.6.0 | VARCHAR2(100) | |
| UNUSED5 | 13.6.0 | VARCHAR2(100) | |
| YEARID | 13.6.0 | NUMBER(11,0) | The year id of the rank record. |