S_NC_WAPT_SHEET_AUDIT_ITEMS (ver 13.6.0)
This table is an extension of the students table.
Column Name | Version | Data Type | Description |
---|---|---|---|
ACTION | 13.6.0 | VARCHAR2(1) | |
ACTIVE | 13.6.0 | VARCHAR2(1) | |
ADJUSTED_CPL | 13.6.0 | NUMBER(25,10) | |
AUDIT_ID | 13.6.0 | NUMBER(25,10) | |
BETWEEN_3_21 | 13.6.0 | VARCHAR2(1) | Indicates the student's age is between 3 and 21. |
BORN_OUTSIDE_US | 13.6.0 | VARCHAR2(1) | Indicates the student was born outside of the US. |
CHANGED_BY | 13.6.0 | VARCHAR2(50) | |
CHANGED_COMMENT | 13.6.0 | VARCHAR2(2000) | |
CHANGED_ON | 13.6.0 | DATE | |
CHANGED_WITH | 13.6.0 | VARCHAR2(50) | |
CLASS_ID | 13.6.0 | NUMBER(25,10) | |
COMPREHENSION | 13.6.0 | NUMBER(25,10) | |
CPL | 13.6.0 | NUMBER(25,10) | |
FIRST_SCHOOL_YEAR_ID | 13.6.0 | NUMBER(25,10) | . |
GENDER_ID | 13.6.0 | NUMBER(25,10) | Indicates the student's gender. |
GRADE_ID | 13.6.0 | NUMBER(25,10) | |
GRADE_SEMESTER_ID | 13.6.0 | NUMBER(25,10) | |
HOMELANG_ID | 13.6.0 | NUMBER(25,10) | Indicates the student's home language code. |
ID | 13.6.0 | NUMBER(10,0) | Primary key |
IMMIGRANT | 13.6.0 | VARCHAR2(1) | Indicates if the student is an immigrant. |
IMM_YEAR_ID | 13.6.0 | NUMBER(25,10) | |
LEA_CODE | 13.6.0 | VARCHAR2(3) | Indicates the student's LEA. |
LEP_STATUS_ID | 13.6.0 | NUMBER(25,10) | Indicates the student's LEP status. |
LISTENING_PL_ID | 13.6.0 | NUMBER(25,10) | |
LISTENING_RAW | 13.6.0 | NUMBER(25,10) | |
OUT_SCHOOL_YEAR_ID | 13.6.0 | NUMBER(25,10) | |
READING_PL_ID | 13.6.0 | NUMBER(25,10) | |
READING_RAW | 13.6.0 | NUMBER(25,10) | |
RETURNED_SCHOOL_YEAR_ID | 13.6.0 | NUMBER(25,10) | |
SCHOOL_CODE | 13.6.0 | VARCHAR2(3) | Indicates the student's school of enrollment. |
SCHOOL_YEAR_ID | 13.6.0 | NUMBER(25,10) | |
SIE_STUDENT_ID | 13.6.0 | NUMBER(25,10) | |
SPEAKING_PL_ID | 13.6.0 | NUMBER(25,10) | |
SPEAKING_RAW | 13.6.0 | NUMBER(25,10) | |
STUDENTSDCID | 13.6.0 | NUMBER(10,0) | Foreign key that links to the students table. |
STUDENT_ID | 13.6.0 | VARCHAR2(9) | |
TEST_ADMINISTRATOR | 13.6.0 | VARCHAR2(50) | |
TEST_DTE | 13.6.0 | DATE | |
TIER_ID | 13.6.0 | NUMBER(25,10) | |
WAPT_ID | 13.6.0 | NUMBER(25,10) | |
WRITING_PL_ID | 13.6.0 | NUMBER(25,10) | |
WRITING_RAW | 13.6.0 | NUMBER(25,10) |