S_NC_WAPT_SHEET_WORK_ITEMS (ver 13.6.0)
This table is an extension of the students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| AMER_INDIAN | 13.6.0 | VARCHAR2(200) | Indicates the student is American Indian |
| ASIAN | 13.6.0 | VARCHAR2(200) | Indicates the student is Asian. |
| BLACK | 13.6.0 | VARCHAR2(200) | Indicates the student is Black. |
| BORN_OUTSIDE_US | 13.6.0 | VARCHAR2(200) | Indicates the student was born outside of the US |
| CHANGED_BY | 13.6.0 | VARCHAR2(50) | |
| CHANGED_ON | 13.6.0 | DATE | |
| CHANGED_WITH | 13.6.0 | VARCHAR2(50) | |
| CLASS | 13.6.0 | VARCHAR2(200) | |
| CLASS_ID | 13.6.0 | NUMBER(25,10) | |
| COMMENTS | 13.6.0 | VARCHAR2(2000) | |
| FIRST_SCHOOL_YEAR | 13.6.0 | VARCHAR2(200) | |
| FIRST_SCHOOL_YEAR_ID | 13.6.0 | NUMBER(25,10) | |
| GRADE_RANGE | 13.6.0 | VARCHAR2(200) | |
| GRADE_RANGE_ID | 13.6.0 | NUMBER(25,10) | |
| GRADE_SEMESTER | 13.6.0 | VARCHAR2(200) | |
| GRADE_SEMESTER_ID | 13.6.0 | NUMBER(25,10) | |
| HISPANIC | 13.6.0 | VARCHAR2(200) | Indicates the student is Hispanic/Latino. |
| HOMELANG_ID | 13.6.0 | VARCHAR2(200) | Indicates the student's home language code. |
| ID | 13.6.0 | NUMBER(10,0) | Primary key. |
| LEA_CODE | 13.6.0 | VARCHAR2(200) | Indicates the LEA the student is enrolled. |
| LISTENING_RAW | 13.6.0 | VARCHAR2(200) | |
| OUT_SCHOOL_YEAR | 13.6.0 | VARCHAR2(200) | |
| OUT_SCHOOL_YEAR_ID | 13.6.0 | NUMBER(25,10) | |
| PACIFIC_ISLANDER | 13.6.0 | VARCHAR2(200) | Indicates the student is Pacific Islander. |
| READING_RAW | 13.6.0 | VARCHAR2(200) | |
| RETURNED_SCHOOL_YEAR | 13.6.0 | VARCHAR2(200) | |
| RETURNED_SCHOOL_YEAR_ID | 13.6.0 | NUMBER(25,10) | |
| SCHOOL_CODE | 13.6.0 | VARCHAR2(200) | Indicates the student's school of enrollment. |
| SIE_STUDENT_ID | 13.6.0 | NUMBER(25,10) | |
| SPEAKING_RAW | 13.6.0 | VARCHAR2(200) | |
| STATUS | 13.6.0 | NUMBER(25,10) | |
| STUDENTSDCID | 13.6.0 | NUMBER(10,0) | Foreign key that links to the student's table. |
| STUDENT_ID | 13.6.0 | VARCHAR2(200) | |
| TEMP_STUDENT_ID | 13.6.0 | NUMBER(25,10) | |
| TEST_ADMINISTRATOR | 13.6.0 | VARCHAR2(200) | |
| TEST_DTE | 13.6.0 | VARCHAR2(200) | |
| UPLOAD_FILE_ID | 13.6.0 | NUMBER(25,10) | |
| WAPT_ID | 13.6.0 | NUMBER(25,10) | |
| WHITE | 13.6.0 | VARCHAR2(200) | Indicates the student is White. |
| WORK_ID | 13.6.0 | NUMBER(25,10) | |
| WRITING_PL | 13.6.0 | VARCHAR2(200) | |
| WRITING_PL_ID | 13.6.0 | VARCHAR2(200) | |
| WRITING_RAW | 13.6.0 | VARCHAR2(200) |