S_NJ_STU_Credentials_Awarded_C (ver 17.4.0)
This table is a child table of the [Students] table.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| Id | 17.4.0 | Number(10,0) | System generated Primary Key. |
| S_NJ_Credentials_SID | 17.4.0 | Number(10,0) | Foreign key to the S_NJ_Credentials_S table. |
| Date_Awarded | 17.4.0 | Date | Date credential was awarded to the student. |
| YearId | 17.4.0 | Number(10,0) | 2 digit yearId of the school year in which the credential was awarded. |
| SchoolId | 17.4.0 | Number(10,0) | School ID of the school from which the credential was awarded. |
| Rank | 17.4.0 | Number(10,0) | Used to the rank student credentials in case the student has multiple credentials within the same school year. |
| CIP_Code | 17.4.0 | VarChar2(6) | CIP code corresponding to the assigned credential. |