Skip to main content
Skip table of contents

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_INDIAN13.6.0 VARCHAR2(200)

Indicates the student is American Indian

ASIAN13.6.0 VARCHAR2(200)Indicates the student is Asian.
BLACK13.6.0 VARCHAR2(200)Indicates the student is Black.
BORN_OUTSIDE_US13.6.0 VARCHAR2(200)Indicates the student was born outside of the US
CHANGED_BY13.6.0 VARCHAR2(50)
CHANGED_ON13.6.0 DATE
CHANGED_WITH13.6.0 VARCHAR2(50)
CLASS13.6.0 VARCHAR2(200)
CLASS_ID13.6.0 NUMBER(25,10)
COMMENTS13.6.0 VARCHAR2(2000)
FIRST_SCHOOL_YEAR13.6.0 VARCHAR2(200)
FIRST_SCHOOL_YEAR_ID13.6.0 NUMBER(25,10)
GRADE_RANGE13.6.0 VARCHAR2(200)
GRADE_RANGE_ID13.6.0 NUMBER(25,10)
GRADE_SEMESTER13.6.0 VARCHAR2(200)
GRADE_SEMESTER_ID13.6.0 NUMBER(25,10)
HISPANIC13.6.0 VARCHAR2(200)Indicates the student is Hispanic/Latino.
HOMELANG_ID13.6.0 VARCHAR2(200)Indicates the student's home language code.
ID13.6.0 NUMBER(10,0)Primary key.
LEA_CODE13.6.0 VARCHAR2(200)Indicates the LEA the student is enrolled.
LISTENING_RAW13.6.0 VARCHAR2(200)
OUT_SCHOOL_YEAR13.6.0 VARCHAR2(200)
OUT_SCHOOL_YEAR_ID13.6.0 NUMBER(25,10)
PACIFIC_ISLANDER13.6.0 VARCHAR2(200)Indicates the student is Pacific Islander.
READING_RAW13.6.0 VARCHAR2(200)
RETURNED_SCHOOL_YEAR13.6.0 VARCHAR2(200)
RETURNED_SCHOOL_YEAR_ID13.6.0 NUMBER(25,10)
SCHOOL_CODE13.6.0 VARCHAR2(200)Indicates the student's school of enrollment.
SIE_STUDENT_ID13.6.0 NUMBER(25,10)
SPEAKING_RAW13.6.0 VARCHAR2(200)
STATUS13.6.0 NUMBER(25,10)
STUDENTSDCID13.6.0 NUMBER(10,0)Foreign key that links to the student's table.
STUDENT_ID13.6.0 VARCHAR2(200)
TEMP_STUDENT_ID13.6.0 NUMBER(25,10)
TEST_ADMINISTRATOR13.6.0 VARCHAR2(200)
TEST_DTE13.6.0 VARCHAR2(200)
UPLOAD_FILE_ID13.6.0 NUMBER(25,10)
WAPT_ID13.6.0 NUMBER(25,10)
WHITE13.6.0 VARCHAR2(200)Indicates the student is White.
WORK_ID13.6.0 NUMBER(25,10)
WRITING_PL13.6.0 VARCHAR2(200)
WRITING_PL_ID13.6.0 VARCHAR2(200)
WRITING_RAW13.6.0 VARCHAR2(200)



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.