S_SC_STU_HIGHACH_C (ver 14.7.2)
This table is a child of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 14.7.2 | Number(10,0) | Primary key. |
STUDENTSDCID | 14.7.2 | Number(10,0) | A foreign key that relates the child table to the [Students] table. |
GT_ACADEMIC_AREA | 14.7.2 | Varchar2(1) | Indicates the academic area that the student qualifies for gifted and talented. |
GT_ARTISTIC_DISCIPLINE | 14.7.2 | Varchar2(1) | Indicates the artistic area that the student qualifies for gifted and talented. |
HIGHACH_1 | 14.7.2 | Varchar2(10) | Indicates the code for the student's first high achievement level. |
HIGHACH_2 | 14.7.2 | Varchar2(10) | Indicates the code for the student's second high achievement level. |
HIGHACH_3 | 14.7.2 | Varchar2(10) | Indicates the code for the student's third high achievement level. |
HIGHACH_4 | 14.7.2 | Varchar2(10) | Indicates the code for the student's fourth high achievement level. |
SCHOOL_ID | 14.7.2 | Number(11,0) | The schoolid for the original record creation. |
SCHOOLID_UPDATED | 14.7.2 | Number(11,0) | The schoolid for the user updating a record. |
START_DT | 14.7.2 | Date | The start date for this record's codes. |
STOP_DT | 14.7.2 | Date | The end date for this record's codes. |
YEAR_ID | 14.7.2 | Number(11,0) | The Year for this record. |