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