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) |