S_NC_ACCESS_DATA (ver 13.6.2)
This table is an extension of the Students table and stores testing information for a Student.
Column Name | Version | Data Type | Description |
---|---|---|---|
Absent_Listen | 14.10.0 | Varchar2(100) | Indicates the student was absent for the Listening part of the test. |
Absent_Read | 14.10.0 | Varchar2(100) | Indicates the student was absent for the Reading part of the test. |
Absent_Speak | 14.10.0 | Varchar2(100) | Indicates the student was absent for the Speaking part of the test. |
Absent_Write | 14.10.0 | Varchar2(100) | Indicates the student was absent for the Writing part of the test. |
Access_Cluster | 14.10.0 | Varchar2(100) | |
Access_Data_ID | 13.6.2 | Number(11,0) | |
Active | 14.10.0 | Varchar2(100) | |
Amer_Indian | 14.10.0 | Varchar2(100) | Indicates the student is American Indian. |
Asian | 14.10.0 | Varchar2(100) | Indicate the student is Aisan. |
Audio_Amp_Device | 14.10.0 | Varchar2(100) | Indicates the student used an audio amplifier device. |
Black | 14.10.0 | Varchar2(100) | Indicates the student is Black. |
Booklet_Serial_No | 14.10.0 | Varchar2(100) | The test booklet serial number. |
Braille_Test_Or_Writer | 14.10.0 | Varchar2(100) | |
COC | 14.10.0 | Varchar2(100) | |
Composite_Confide_H_SCO | 14.10.0 | Number(11,0) | |
Composite_Confide_L_SCO | 14.10.0 | Number(11,0) | |
Composite_Prof_Level | 14.10.0 | Varchar2(100) | |
Composite_Prof_Level_K | 14.10.0 | Varchar2(100) | |
Composite_Scale_SCO | 14.10.0 | Varchar2(100) | |
Compreh_Confide_H_SCO | 14.10.0 | Number(11,0) | |
Compreh_Confide_L_SCO | 14.10.0 | Number(11,0) | |
Compreh_LA_Raw_SCO | 14.10.0 | Varchar2(100) | |
Compreh_Math_Raw_SCO | 14.10.0 | Varchar2(100) | |
Compreh_Prof_Level | 14.10.0 | Varchar2(100) | |
Compreh_Prof_Level_K | 14.10.0 | Varchar2(100) | |
Compreh_Science_Raw_SCO | 14.10.0 | Varchar2(100) | |
Compreh_SCO | 14.10.0 | Varchar2(100) | |
Compreh_SI_Raw_SCO | 14.10.0 | Varchar2(100) | |
Compreh_SS_Raw_SCO | 14.10.0 | Varchar2(100) | |
Computer_Assisted | 14.10.0 | Varchar2(100) | |
Content_Area_Tutor | 14.10.0 | Varchar2(100) | Indicates the student received tutoring in the particular content area. |
Content_Based_ESL | 14.10.0 | Varchar2(100) | |
Date_Of_Testing | 14.10.0 | Date | The date the test was administered. |
Declined_Listening | 14.10.0 | Varchar2(100) | |
Declined_Reading | 14.10.0 | Varchar2(100) | |
Declined_Speaking | 14.10.0 | Varchar2(100) | |
Declined_Writing | 14.10.0 | Varchar2(100) | |
Developmental_Bilingual | 14.10.0 | Varchar2(100) | |
District_Name | 14.10.0 | Varchar2(100) | The name of the district where the student was tested. |
District_Number | 14.10.0 | Varchar2(100) | The LEA number of the district administering the test. |
District_Student_ID | 14.10.0 | Varchar2(100) | The local student number from the LEA. |
Dist_Def_Opt_Data | 14.10.0 | Varchar2(100) | |
DOB | 14.10.0 | Date | The date of birth of the student. |
Dual_Lang_2way_Immersion | 14.10.0 | Varchar2(100) | Indicates the student participates in a two-way dual language immersion program. |
ESE_504_Listen | 14.10.0 | Varchar2(100) | |
ESE_504_Read | 14.10.0 | Varchar2(100) | |
ESE_504_Speak | 14.10.0 | Varchar2(100) | |
ESE_504_Write | 14.10.0 | Varchar2(100) | |
Ethnicity | 14.10.0 | Varchar2(100) | Indicates if the student is Hispanic/Latino. |
First_Enroll | 14.10.0 | Date | The date the student first enrolled. |
First_Name | 14.10.0 | Varchar2(100) | The student's first name. |
Form_Number | 14.10.0 | Number(11,0) | The test form number. |
Gender | 14.10.0 | Varchar2(100) | The gender of the student. |
Grade | 14.10.0 | Number(11,0) | The grade level of the student when tested. |
Heritage_Lang | 14.10.0 | Varchar2(100) | The student's heritage language. |
ID | 14.10.0 | Number(19,0) | Primary Key |
IEP_Status | 14.10.0 | Varchar2(100) | Indicates if the student has an IEP. |
Inclusionary_Support | 14.10.0 | Varchar2(100) | |
Invalid_Listen | 14.10.0 | Varchar2(100) | |
Invalid_Read | 14.10.0 | Varchar2(100) | |
Invalid_Speak | 14.10.0 | Varchar2(100) | |
Invalid_Write | 14.10.0 | Varchar2(100) | |
K_Listen_Raw_Item_Resps | 14.10.0 | Varchar2(50) | |
K_Listen_Scored_Resps | 14.10.0 | Varchar2(50) | |
K_Read_Raw_Item_Resps | 14.10.0 | Varchar2(50) | |
K_Read_Scored_Resps | 14.10.0 | Varchar2(50) | |
K_Speak_Raw_Item_Resps | 14.10.0 | Varchar2(50) | |
K_Speak_Scored_Resps | 14.10.0 | Varchar2(50) | |
K_Write_Raw_Item_Resps | 14.10.0 | Varchar2(50) | |
K_Write_Scored_Resps | 14.10.0 | Varchar2(50) | |
Large_Print_Booklet | 14.10.0 | Varchar2(100) | Indicates if the student was provided a large print test booklet. |
Last_Name | 14.10.0 | Varchar2(100) | The student's last name. |
Length_In_Program | 14.10.0 | Number(11,0) | Indicates how long the student has been served in the program. |
LEP_ID | 14.10.0 | Number(11,0) | Indicates if the student is identified as LEP. |
Listen_Confide_H_SCO | 14.10.0 | Number(11,0) | |
Listen_Confide_L_SCO | 14.10.0 | Number(11,0) | |
Listen_Prof_Level | 14.10.0 | Varchar2(100) | |
Listen_Prof_Level_K | 14.10.0 | Varchar2(100) | |
Listen_Raw_Resps | 14.10.0 | Varchar2(50) | |
Listen_Scale_SCO | 14.10.0 | Varchar2(100) | |
Listen_SCOD_Resps | 14.10.0 | Varchar2(50) | |
Literacy_Confide_H_SCO | 14.10.0 | Number(11,0) | |
Literacy_Confide_L_SCO | 14.10.0 | Number(11,0) | |
Literacy_Prof_Level | 14.10.0 | Varchar2(100) | |
Literacy_Prof_Level_K | 14.10.0 | Varchar2(100) | |
Literacy_Scale_SCO | 14.10.0 | Varchar2(100) | |
Mag_Low_Vision_Aids | 14.10.0 | Varchar2(100) | |
Middle_Name | 14.10.0 | Varchar2(100) | The student's middle name. |
Migrant | 14.10.0 | Varchar2(100) | Indicates if the student is identified as migrant. |
Mod_Pres_Format | 14.10.0 | Varchar2(100) | |
Mod_Test_Dir | 14.10.0 | Varchar2(100) | |
Mod_Timing | 14.10.0 | Varchar2(100) | |
Native_Lang | 14.10.0 | Varchar2(100) | Indicates the student's native language. |
No_Additional_Service | 14.10.0 | Varchar2(100) | |
Oral_Confide_H_SCO | 14.10.0 | Number(11,0) | |
Oral_Prof_Level | 14.10.0 | Varchar2(100) | |
Oral_Prof_Level_K | 14.10.0 | Varchar2(100) | |
Oral_Scale_Confide_L_SCO | 14.10.0 | Number(11,0) | |
Oral_Scale_SCO | 14.10.0 | Varchar2(100) | |
Other_Approved_Accomm | 14.10.0 | Varchar2(100) | |
Pacific_Islander | 14.10.0 | Varchar2(100) | Indicates if the student is Pacific Islander. |
Parent_Refuse_4Services | 14.10.0 | Varchar2(100) | |
Plan_504 | 13.6.2 | Varchar2(100) | Indicates if the student is identified as 504. |
Processed_Flag | 14.10.0 | Varchar2(100) | |
Pull_Out_4Ind_Support | 14.10.0 | Varchar2(100) | Indicates if the student is pulled out for individual support. |
Pull_Out_ESL | 14.10.0 | Varchar2(100) | Indicates if the student is pulled out for ESL support. |
Read_Confide_H_SCO | 14.10.0 | Number(11,0) | |
Read_Confide_L_SCO | 14.10.0 | Number(11,0) | |
Read_Prof_Level | 14.10.0 | Varchar2(100) | |
Read_Prof_Level_K | 14.10.0 | Varchar2(100) | |
Read_Raw_Resps | 14.10.0 | Varchar2(50) | |
Read_Scale_SCO | 14.10.0 | Varchar2(100) | |
Read_SCOD_Resps | 14.10.0 | Varchar2(50) | |
Refused_Listen | 14.10.0 | Varchar2(100) | |
Refused_Read | 14.10.0 | Varchar2(100) | |
Refused_Speak | 14.10.0 | Varchar2(100) | |
Refused_Write | 14.10.0 | Varchar2(100) | |
SchoolID | 14.10.0 | Number(11,0) | The school number for the school where the student is enrolled at testing. |
School_Name | 14.10.0 | Varchar2(100) | The school name for the student for that year. |
School_Number | 14.10.0 | Varchar2(100) | The school number for the student for that year. |
School_Year_ID | 14.10.0 | Number(11,0) | The school year identifier for year tested. |
Scoring_Center_Use | 14.10.0 | Number(11,0) | |
Scribe | 14.10.0 | Varchar2(100) | |
Self_Contained | 14.10.0 | Varchar2(100) | |
Setting_Format_SF | 14.10.0 | Varchar2(100) | |
Shelter_ENG_Instruction | 14.10.0 | Varchar2(100) | |
Short_Segment_Test_Admin | 14.10.0 | Varchar2(100) | |
Speak_Confide_H_SCO | 14.10.0 | Number(11,0) | |
Speak_Confide_L_SCO | 14.10.0 | Number(11,0) | |
Speak_LA_SS_Raw_SCO | 14.10.0 | Varchar2(100) | |
Speak_Math_SCI_Raw_SCO | 14.10.0 | Varchar2(100) | |
Speak_Prof_Level | 14.10.0 | Varchar2(100) | |
Speak_Prof_Level_K | 14.10.0 | Varchar2(100) | |
Speak_Raw_Resps | 14.10.0 | Varchar2(50) | |
Speak_Scale_SCO | 14.10.0 | Varchar2(100) | |
Speak_SCOD_Resps | 14.10.0 | Varchar2(50) | |
Speak_SI_Raw_SCO | 14.10.0 | Varchar2(100) | |
State_Abbr | 14.10.0 | Varchar2(100) | |
State_Def_Opt_Data | 14.10.0 | Varchar2(100) | |
State_Student_ID | 14.10.0 | Varchar2(100) | The State Student ID number. |
State_Support_Deliver_NA | 14.10.0 | Varchar2(100) | |
Struct_Eng_Immers_SDAIE | 14.10.0 | Varchar2(100) | |
StudentsDCID | 13.6.2 | Number(19,0) | A foreign key link to Students.DCID |
Student_Number | 14.10.0 | Number(11,0) | |
Stu_Made_Tape_Read_Test | 14.10.0 | Varchar2(100) | |
Tier | 14.10.0 | Varchar2(100) | |
Title3_Status | 14.10.0 | Varchar2(100) | |
Transitional_Bilingual | 14.10.0 | Varchar2(100) | |
Updated | 14.10.0 | Varchar2(100) | |
WhatCreated | 14.10.0 | Varchar2(50) | |
WhatModified | 14.10.0 | Varchar2(50) | |
White | 14.10.0 | Varchar2(100) | Indicates if the student is White. |
Write_Confide_H_SCO | 14.10.0 | Number(11,0) | |
Write_Confide_L_SCO | 14.10.0 | Number(11,0) | |
Write_LA_SCOS | 14.10.0 | Varchar2(100) | |
Write_LA_SS_SCOS | 14.10.0 | Varchar2(100) | |
Write_Math_Science_SCOS | 14.10.0 | Varchar2(100) | |
Write_Math_SCOS | 14.10.0 | Varchar2(100) | |
Write_Prof_Level | 14.10.0 | Varchar2(100) | |
Write_Prof_Level_K | 14.10.0 | Varchar2(100) | |
Write_Raw_SCOS_1 | 14.10.0 | Number(11,0) | |
Write_Raw_SCOS_2 | 14.10.0 | Number(11,0) | |
Write_Raw_SCOS_3 | 14.10.0 | Number(11,0) | |
Write_Raw_SCOS_4 | 14.10.0 | Number(11,0) | |
Write_Scale_SCO | 14.10.0 | Varchar2(100) | |
Write_Science_SCOS | 14.10.0 | Varchar2(100) | |
Write_SI_SCOS | 14.10.0 | Varchar2(100) |