Skip to main content
Skip table of contents

S_NC_ACCESS_WORK (ver 13.6.2)

This table is an extension of the Students table and stored working testing data for a student.

Column Name

Version

Data Type

Description

Absent_Listen14.10.0Varchar2(100)Indicates the student was absent for the Listening part of the test.
Absent_Read14.10.0Varchar2(100)Indicates the student was absent for the Reading part of the test.
Absent_Speak14.10.0Varchar2(100)Indicates the student was absent for the Speaking part of the test.
Absent_Write14.10.0Varchar2(100)Indicates the student was absent for the Writing part of the test.
Access_Cluster14.10.0Varchar2(100)
Access_Work_ID13.6.2Number(11,0)
Active14.10.0Varchar2(100)
Amer_Indian14.10.0Varchar2(100)Indicates the student is American Indian.
Asian14.10.0Varchar2(100)Indicate the student is Aisan.
Audio_Amp_Device14.10.0Varchar2(100)Indicates the student used an audio amplifier device.
Black14.10.0Varchar2(100)Indicates the student is Black.
Booklet_Serial_No14.10.0Varchar2(100)The test booklet serial number.
Braille_Test_Or_Writer14.10.0Varchar2(100)
Changed14.10.0Varchar2(100)
Changed_By14.10.0Varchar2(100)
Changed_On14.10.0Date
Changed_With14.10.0Varchar2(100)
Composite_Confide_H_SCO14.10.0Number(11,0)
Composite_Confide_L_SCO14.10.0Number(11,0)
Composite_Prof_Level14.10.0Varchar2(100)
Composite_Prof_Level_K14.10.0Varchar2(100)
Composite_Scale_SCO14.10.0Varchar2(100)
Compreh_Confide_H_SCO14.10.0Number(11,0)
Compreh_Confide_L_SCO14.10.0Number(11,0)
Compreh_LA_Raw_SCO14.10.0Varchar2(100)


Compreh_Math_Raw_SCO14.10.0Varchar2(100)


Compreh_Prof_Level14.10.0Varchar2(100)
Compreh_Prof_Level_K14.10.0Varchar2(100)
Compreh_Science_Raw_SCO14.10.0Varchar2(100)
Compreh_SCO14.10.0Varchar2(100)
Compreh_SI_Raw_SCO14.10.0Varchar2(100)
Compreh_SS_Raw_SCO14.10.0Varchar2(100)
Computer_Assisted14.10.0Varchar2(100)
Content_Area_Tutor14.10.0Varchar2(100)Indicates the student received tutoring in the particular content area.
Content_Based_ESL14.10.0Varchar2(100)
Date_Of_Testing14.10.0DateThe date the test was administered.
Declined_Listening14.10.0Varchar2(100)
Declined_Reading14.10.0Varchar2(100)
Declined_Speaking14.10.0Varchar2(100)
Declined_Writing14.10.0Varchar2(100)
Developmental_Bilingual14.10.0Varchar2(100)
District_Name14.10.0Varchar2(100)

The name of the district where the student was tested.

District_Number14.10.0Varchar2(100)The LEA number of the district administering the test.
District_Student_ID14.10.0Varchar2(100)The local student number from the LEA.
Dist_Def_Opt_Data14.10.0Varchar2(100)
DOB14.10.0DateThe date of birth of the student.
DOB_Txt14.10.0Varchar2(100)
Dual_Lang_2way_Immersion14.10.0Varchar2(100)Indicates the student participates in a two-way dual language immersion program.
ESE_504_Listen14.10.0Varchar2(100)
ESE_504_Read14.10.0Varchar2(100)
ESE_504_Speak14.10.0Varchar2(100)
ESE_504_Write14.10.0Varchar2(100)
Ethnicity14.10.0Varchar2(100)Indicates if the student is Hispanic/Latino.
First_Enroll14.10.0DateThe date the student first enrolled.
First_Enroll_Txt14.10.0Varchar2(100)
First_Name14.10.0Varchar2(100)The student's first name.
Form_Number14.10.0Number(11,0)The test form number.
Gender14.10.0Varchar2(100)The gender of the student.
Grade14.10.0Number(11,0)The grade level of the student when tested.
Heritage_Lang14.10.0Varchar2(100)The student's heritage language.

ID

ver 13.6.2

Number(19,0)

A unique identifier to allow multiple rows per student

IEP_Status14.10.0Varchar2(100)Indicates if the student has an IEP.
IMM_ID14.10.0Number(11,0)
Inclusionary_Support14.10.0Varchar2(100)
Invalid_Listen14.10.0Varchar2(100)
Invalid_Read14.10.0Varchar2(100)
Invalid_Speak14.10.0Varchar2(100)
Invalid_Write14.10.0Varchar2(100)
K_Listen_Raw_Item_Resps14.10.0Number(11,0)
K_Listen_Scored_Resps14.10.0Number(11,0)
K_Read_Raw_Item_Resps14.10.0Number(11,0)
K_Read_Scored_Resps14.10.0Number(11,0)
K_Speak_Raw_Item_Resps14.10.0Number(11,0)
K_Speak_Scored_Resps14.10.0Number(11,0)
K_Write_Raw_Item_Resps14.10.0Number(11,0)
K_Write_Scored_Resps14.10.0Number(11,0)
Large_Print_Booklet14.10.0Varchar2(100)Indicates if the student was provided a large print test booklet.
Last_Name14.10.0Varchar2(100)The student's last name.
Length_In_Program14.10.0Number(11,0)Indicates how long the student has been served in the program.
LEP_ID14.10.0Number(11,0)Indicates if the student is identified as LEP.
Listen_Confide_H_SCO14.10.0Number(11,0)
Listen_Confide_L_SCO14.10.0Number(11,0)
Listen_Prof_Level14.10.0Varchar2(100)
Listen_Prof_Level_K14.10.0Varchar2(100)
Listen_Raw_Resps14.10.0Number(11,0)
Listen_Scale_SCO14.10.0Varchar2(100)
Listen_SCOD_Resps14.10.0Number(11,0)
Literacy_Confide_H_SCO14.10.0Number(11,0)
Literacy_Confide_L_SCO14.10.0Number(11,0)
Literacy_Prof_Level14.10.0Varchar2(100)
Literacy_Prof_Level_K14.10.0Varchar2(100)
Literacy_Scale_SCO14.10.0Varchar2(100)
Mag_Low_Vision_Aids14.10.0Varchar2(100)
Middle_Name14.10.0Varchar2(100)The student's middle name.
Migrant14.10.0Varchar2(100)Indicates if the student is identified as migrant.
Mod_Pres_Format14.10.0Varchar2(100)
Mod_Test_Dir14.10.0Varchar2(100)
Mod_Timing14.10.0Varchar2(100)
Native_Lang14.10.0Varchar2(100)Indicates the student's native language.
No_Additional_Service14.10.0Varchar2(100)
Oral_Confide_H_SCO14.10.0Number(11,0)
Oral_Prof_Level14.10.0Varchar2(100)
Oral_Prof_Level_K14.10.0Varchar2(100)
Oral_Scale_Confide_L_SCO14.10.0Number(11,0)
Oral_Scale_SCO14.10.0Varchar2(100)
Other_Approved_Accomm14.10.0Varchar2(100)
Pacific_Islander14.10.0Varchar2(100)Indicates if the student is Pacific Islander.
Parent_Refuse_4Services14.10.0Varchar2(100)
Plan_50413.6.2Varchar2(100)Indicates if the student is identified as 504.
PreID14.10.0Varchar2(100)
Processed_Flag14.10.0Varchar2(100)
Pull_Out_4Ind_Support14.10.0Varchar2(100)Indicates if the student is pulled out for individual support.
Pull_Out_ESL14.10.0Varchar2(100)Indicates if the student is pulled out for ESL support.
Read_Confide_H_SCO14.10.0Number(11,0)
Read_Confide_L_SCO14.10.0Number(11,0)
Read_Prof_Level14.10.0Varchar2(100)
Read_Prof_Level_K14.10.0Varchar2(100)
Read_Raw_Resps14.10.0Number(11,0)
Read_Scale_SCO14.10.0Varchar2(100)
Read_SCOD_Resps14.10.0Number(11,0)
Refused_Listen14.10.0Varchar2(100)
Refused_Read14.10.0Varchar2(100)
Refused_Speak14.10.0Varchar2(100)
Refused_Write14.10.0Varchar2(100)
School_Name14.10.0Varchar2(100)The school name for the student for that year.
School_Number14.10.0Varchar2(100)The school number for the student for that year.
School_Year_ID14.10.0Number(11,0)The school year identifier for year tested.
Scoring_Center_Use14.10.0Number(11,0)
Scribe14.10.0Varchar2(100)
Self_Contained14.10.0Varchar2(100)
Setting_Format_SF14.10.0Varchar2(100)
Shelter_ENG_Instruction14.10.0Varchar2(100)
Short_Segment_Test_Admin14.10.0Varchar2(100)
SIE_Student_ID14.10.0Number(11,0)
Speak_Confide_H_SCO14.10.0Number(11,0)
Speak_Confide_L_SCO14.10.0Number(11,0)
Speak_LA_SS_Raw_SCO14.10.0Varchar2(100)
Speak_Math_SCI_Raw_SCO14.10.0Varchar2(100)
Speak_Prof_Level14.10.0Varchar2(100)
Speak_Prof_Level_K14.10.0Varchar2(100)
Speak_Raw_Resps14.10.0Number(11,0)
Speak_Scale_SCO14.10.0Varchar2(100)
Speak_SCOD_Resps14.10.0Number(11,0)
Speak_SI_Raw_SCO14.10.0Varchar2(100)
State_Abbr14.10.0Varchar2(100)
State_Def_Opt_Data14.10.0Varchar2(100)
State_Student_ID14.10.0Varchar2(100)The State Student ID number.
State_Support_Deliver_NA14.10.0Varchar2(100)
Struct_Eng_Immers_SDAIE14.10.0Varchar2(100)

StudentsDCID

ver 13.6.2

Number(19,0)

A foreign key link to STUDENTS.DCID

Stu_Made_Tape_Read_Test14.10.0Varchar2(100)
Tier14.10.0Varchar2(100)
Title3_Status14.10.0Varchar2(100)
Transitional_Bilingual14.10.0Varchar2(100)
Updated14.10.0Varchar2(100)
WhatCreated14.10.0Varchar2(50)
WhatModified14.10.0Varchar2(50)
White14.10.0Varchar2(100)Indicates if the student is White.
Write_Confide_H_SCO14.10.0Number(11,0)
Write_Confide_L_SCO14.10.0Number(11,0)
Write_LA_SCOS14.10.0Varchar2(100)
Write_LA_SS_SCOS14.10.0Varchar2(100)
Write_Math_Science_SCOS14.10.0Varchar2(100)
Write_Math_SCOS14.10.0Varchar2(100)
Write_Prof_Level14.10.0Varchar2(100)
Write_Prof_Level_K14.10.0Varchar2(100)
Write_Raw_SCOS_114.10.0Number(11,0)
Write_Raw_SCOS_214.10.0Number(11,0)
Write_Raw_SCOS_314.10.0Number(11,0)
Write_Raw_SCOS_414.10.0Number(11,0)
Write_Scale_SCO14.10.0Varchar2(100)
Write_Science_SCOS14.10.0Varchar2(100)
Write_SI_SCOS14.10.0Varchar2(100)
JavaScript errors detected

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

If this problem persists, please contact our support.

Contact Support Close