Skip to main content
Skip table of contents

S_VA_STU_X (ver 14.5.0)

This table is an extension of the [Students] table.


Column Name

Version

Data Type

Description

StudentsDCID

14.5.0

Number(10,0)

Foreign Key to the Students table.

Advanced_Placement_Code16.5.0Number(11,0)Indicates whether student is enrolled in one or more Advanced Placement courses and/or student has taken the Advanced Placement test. Migrated from: [Students]VA_Adv_Place_Code
Approv_Private_SPED_Schools_TF16.6.0Number(1,0)Migrated from: [Students]VA_approved_private_spec_ed_schools_pupil
Approved_SPED_Reg_Prog_TF16.6.0Number(1,0)Migrated from: [Students]VA_approved_spec_ed_reg_prog
Birth_Country_Code16.5.0Varchar2(5)

A code that identifies the name of the country in which the student was born. Leave blank if student was born in U.S. Migrated from: [Students]VA_BirthCountry

Cambridge_Program_Code16.5.0Number(11,0)Indicates whether student is enrolled in one or more Cambridge Programme (IGCSE & AICE) courses and/or has taken an IGCSE or AICE exam. Migrated from: [Students]VA_SECambPrgCd
CertGnrlStudiesAsscDegFlag_TF17.5.0Number(1,0)Migrated from: [Students]VA_CertGnrlStudiesAsscDegFlag
CertOfProgCompAwardDate 15.2.0DateDate the Certification of Program Completion is awarded
CreditAccommodationFlag_TF17.5.0Number(1,0)

Migrated from: [Students]VA_CreditAccommodationFlag

CTE_Career_Family_Code17.2.0Varchar2(2)Migrated from: [Students]VA_CTE_Career_Family_Code
CTE_Career_Pathway_Code17.5.0Varchar2(5)Migrated from: [Students]VA_CareerPathwayCodeHeadStart
CTE_Competency17.2.0Varchar2(1)Migrated from: [Students]VA_CTE_Competency
CTE_Completer16.6.0Varchar2(5)Migrated from: [Students]VA_CTE_Completer
CTE_Completion_Dt17.2.0DateMigrated from: [Students]VA_CTE_Completion_Dt
CTE_Course_TF16.6.0Number(1,0)Migrated from: [Students]VA_CTE_Course
CTE_Dual_TF16.6.0Number(1,0)Migrated from: [Students]VA_CTE_Dual
CTE_Finisher_Code17.2.0Varchar2(1)Migrated from: [Students]VA_CTE
CTE_Special_Pop_Code17.2.0Varchar2(3)Migrated from: [Students]VA_CTE_Special_Pop_Code
CTE_Tech_TF16.6.0Number(1,0)Migrated from: [Students]VA_CTE_Tech
DeviceAccess_RemLearn20.8.2.0Number(11,0)A new field to store the device access remote learning value of student
Diploma_Seal16.5.0Varchar2(10)

State assigned code to identify any and all diploma seals earned by a graduate. Migrated from: [Students]VA_Diploma_Seal

Diploma_Type16.6.0Number(11,0)Migrated from: [Students]VA_DiplomaType
Disability_Status_Section_2_TF16.6.0Number(1,0)Migrated from: [Students]SOL_Sped_Exit_2_Yrs
Disabled_TF16.6.0Number(1,0)Migrated from: [Students]VA_disabled
Disadvantaged_TF16.5.0Number(1,0)Indicates whether a student is economically disadvantaged at any point during the school year. Migrated from: [Students]VA_Disadvantaged
Distance_Learning_Flag_TF16.6.0Number(1,0)Migrated from: [Students]VA_DistanceLearning
DriverEdDate 15.4.0DateThis field is obsolete as of SR Version 15.4.0
DriverEdGrade 15.4.0Varchar2(7)This field is obsolete as of SR version 15.4.0
Dual_Enrollment_TF16.6.0Number(1,0)Migrated from: [Students]VA_Dual
Early_College_Scholar_Progcode16.5.0Number(11,0)State assigned code that identifies students who are participating in the Governor's Early College Scholar Program and/or the Commonwealth Scholar Program. Migrated from: [Students]VA_EarlyCollegeScholarProgCD
ELL_Composite_Score16.6.0Number(25,10)Migrated from: [Students]VA_ELL_Composite_Score
ELL_Literacy_Score16.6.0Number(25,10)Migrated from: [Students]VA_ELL_Literacy_Score
ELL_Test_Tier16.6.0Varchar2(1)Migrated from: [Students]VA_ELL_Test_Tier
Enrolled_Alternative_Prog_TF16.6.0Number(1,0)Migrated from: [Students]VA_Alternative
ESL_Code16.5.0Number(11,0)Code that indicates student's current ESL status. Migrated from: [Students]VA_LEP_Serv_Cd
First_Year_9th_Grade_Code16.6.0Number(11,0)Migrated from: [Students]VA_1st_Year_9th_Grade_Code
Formerly_EL17.9.0Number(11)Indicates whether the student was formerly EL
Foster_Care_Flag_TF16.6.0Number(1,0)Migrated from: [Students]VA_FosterCare
Full_Time_Virtual_Progcode16.5.0Varchar2(1)Indicates whether student enrolled in a full course of study for all educational services in a virtual program. This virtual program of study may or may not be a board-approved MOP program. Migrated from: [Students]VA_FTVirtual_ProgCode
GED_Program_Code16.5.0Number(11,0)Code that indicates the student is enrolled in a program leading to a GED, such as ISAEP or GAD program. Migrated from: [Students]VA_GED_Code
Gifted_Code16.5.0Varchar2(4)Code that indicates the area of giftedness for a student placed in a gifted program or that the student was referred to and found eligible for the gifted program. Migrated from: [Students]VA_Gifted_Code
Gifted_Referral_TF16.5.0Number(1,0)Indicates whether student was referred to the Gifted Program between July 1 and June 30 of the current school year. Migrated from: [Students]VA_GiftedReferralFlag
Grad_Completer_Code16.5.0Number(11,0)Code that identifies the type of graduation diploma or completion document the student received. Migrated from: [Students]VA_Grd_Comp_Code
Grade_Level_Code16.5.0Varchar2(3)Code that identifies the grade level at which a student receives services in a school or an educational institution during a given academic session. Migrated from: [Students]VA_GradeCode
Graduation_Date16.6.0DateMigrated from: [Students]VA_Grad_Date
Graduation_Plan_Code16.5.0Number(11,0)

Code that identifies the post-graduate plans of the student. Migrated from: [Students]VA_Grd_Plan_Code

HeadStart_PCode20.8.2.0Varchar2(2)A new field to store the Student's Head Start provider code
Home_Language_Code16.5.0Varchar2(5)

Code that identifies the language or dialect routinely spoken in a studnet's home. Migrated from: [Students]VA_HomeLang

Homeless_TF16.6.0Number(1,0)Migrated from: [Students]VA_Homeless
IB_Code16.5.0Varchar2(1)

Code to identify that student is enrolled in one or more IB (International Baccalaureate Program) courses and/or has taken the IB exam. Migrated from: [Students]VA_IB_Cd

Immigrant_TF16.5.0Number(1,0)

Indicates whether the student is classified as an "immigrant." Migrated from: [Students]VA_Immigrant

International_BACC_Program_TF16.5.0Number(1,0)

Code that indicates the student is enrolled in the International Baccalaureate Program and working toward an IB diploma. Migrated from: [Students]VA_Bacc

InternetAccess_RemLearn20.8.2.0Number(11,0)A new field to store internet access remote learning value of the student
Kindergarten_Readiness_TF16.5.0Number(1,0)

Indicates whether a kindergarten student who turns 5 between October 1 and December 31st was administered a readiness assessment PRIOR to the student's first day of kindergarten. Migrated from: [Students]VA_KindergartenReadiness

Lang_Instr_Edu_Prg_Type19.1.0Varchar2(20)Indicates student's Language Instruction Educational Program type.
LEP_Code16.6.0Number(11,0)Migrated from: [Students]VA_LEP_Code
LEP_Proficiency_Code16.6.0Number(11,0)Migrated from: [Students]VA_LEP_Proficiency_Code
LEP_State_Code16.6.0Number(11,0)Migrated from: [Students]VA_LEP_State_Cd
Migrant_TF16.6.0Number(1,0)Migrated from: [Students]VA_Migrant
Military_Compact_Flag_TF16.5.0Number(1,0)Indicates whether an underage student can attend kindergarten in Virginia under the Interstate Compact on Educational Opportunity for Military Children. Migrated from:VA_MilCompStaFlag
Military_Connected 15.8.2Varchar2(2)Indicates whether student is connected to military.
MOP_Flag16.5.0Varchar2(1)

Indicates whether student is in a virtual school/program where the curriculum and delivery is provided by an approved Multidivision Online Provider. Migrated from:[Students]VA_MopFlag

MOP_Number_Classes16.5.0Number(11,0)The number of secondary classes student took via a MOP program. Migrated from [Students]VA_MOP_numclasses
MOP_Resident_Division16.5.0Varchar2(20)

For students in virtual schools/programs where the curriculum and delivery is provided by an approved Multidivision Online Provider, this is a three-digit state-assigned Division number of the division where the student physically resides Migrated from: [Students]VA_MOP_Residentdivision

Multiple_Years_Grade_12_TF16.6.0Number(1,0)Migrated from: [Students]VA_Multiple12
Neglected_Delinquent_Code16.6.0Number(11,0)Migrated from: [Students]VA_NegDelinquent_Code
Neglected_Delinquent_TF16.6.0Number(1,0)Migrated from: [Students]VA_Neglected
Non_Public_School_TF16.6.0Number(1,0)Migrated from: [Students]VA_public
Non_Public_Student_FTE16.5.0Number(11,0)

Identifies the part-time student attending school to take one or two courses. This includes home-schooled and private schooled students. Migrated from: [Students]VA_np_fte

Parent_RemLearnDecision20.8.2.0Varchar2(1)A new field to store parent remote learning decision value
PCT_APPORTIONMENT15.10.3Number(25,10)Percent apportionment (Membership Share) for use by Principal's Report.
PK_Experience_Code16.5.0Number(11,0)State assigned code to identify the current or most recent PK (pre-kindergarten) experience of PK and kindergarten students. Migrated from: [Students]VA_PK_experience_code
PK_Funding_Source 15.8.2Varchar2(2)The preschool funding source (Head Start, Title I, local funding, etc)
PK_Weekly_Time_Code16.5.0Number(11,0)State assigned code that identifies the average amount of time the student spends each week in the program specified by the PK Experience Code. Migrated from: [Students]VA_PK_weekly_time
Primary_Disability_Code17.5.0Varchar2(11)Code that identifies the primary disability type for a student who is eligible for services under the Individuals with Disabilities Education Act (IDEA) and who has an Individualized Education Program (IEP) or services planned. Migrated from [Students]VA_Primary_Dis_Code
Primary_Nighttime_Res_Code16.5.0Number(11,0)

Code to identify the initial primary night residence when the student is identified as homeless at any time during the school year. Migrated from: [Students]VA_PrimNight_ResCode

Projected_LEP_State_Code16.6.0Number(11,0)Migrated from: [Students]VA_Proj_LEP_State_Cd
ProjectGraduation 14.9.0Number(1,0)

Column 46 in SOL Student Data Upload File Requirements.

Column 45 in VAAP, VGLA, VSEP Student Data Upload File Requirements.

Provider_Description_Code16.5.0Varchar2(2)

Code that defines the description of the services provided. Migrated from:[Students]VA_prov_desc

The use of this field is discontinued for state reporting purposes and now resides on the State/Province-VA > Discontinued tab.

Provider_Id16.5.0Varchar2(20)

Locally defined identification number must be unique within the division (i.e. employee id, teacher id, tax id). Migrated From: [Students]VA_loc_prov_id

The use of this field is discontinued for state reporting purposes and now resides on the State/Province-VA > Discontinued tab.

Provider_Name16.5.0Varchar2(50)

The name of the other provider. Must be the name of a specific private school, contracting company or unlicensed individual. Migrated from [Students]VA_prov_name

The use of this field is discontinued for state reporting purposes and now resides on the State/Province-VA > Discontinued tab.


Refugee_TF16.6.0Number(1,0)Migrated from: [Students]VA_Refugee
Regional_Prog_Taking_SOL_TF16.6.0Number(1,0)Migrated from: [Students]SOL_RP_Code
Reporting_School16.5.0Varchar2(20)

Four-digit state-assigned School number that identifies the school for which membership, funding, graduation status and high school completion status are attributed. Migrated from:[Students]VA_ReportingSchool

Responsible_Division16.5.0Varchar2(20)Three-digit state-assigned Division number of the division where: A.) the student resides, B.) attends a school through open enrollment, C.) tuition is waived, or D.) any student with a disability for whom the division is legally responsible for providing a Free Appropriate Public Education. Migrated from:[Students]VA_ResponsibleDistrict
Responsible_School16.5.0Varchar2(20)Four-digit state-assigned School number of the school where: A.) the student resides, B.) attends a school through open enrollment, or C.) tuition is waived. Migrated from:[Students]VA_ResponsibleSchool
Retention_TF16.5.0Number(1,0)

Indicates whether that a student was retained in the same grade (status at the end of the school year). Migrated from [Students]VA_Retention

School_Choice_Status_Code16.5.0Number(11,0)State-assigned code that indicates the student's eligibility and election to participate in School Choice. Migrated from:[Students]VA_SchoolChoiceStatusCD
School_Counselor16.6.0Varchar2(60)Migrated from: [Students]VA_School_Counselor
SDU_Local_Use_Data15.12.0Varchar2(9)

Column 41 in SOL Student Data Upload File Requirements.

Column 41 in VAAP, VGLA, VSEP Student Data Upload File Requirements.

Serving_Division16.5.0Varchar2(20)Three-digit, state-assigned Division number that identifies the division, agency or regional program that provides services to the student. Migrated from:[Students]ResponsibleDisctrict.
Serving_School16.5.0Varchar2(20)Three-digit, state-assigned Division number that identifies the division, agency or regional program that provides services to the student. Migrated from:[Students]VA_ServingSchool.
Session_Name17.9.0Varchar2(30)

Use to store Session Name for SOL Testing (no longer used)

SOA_Adjustment_LEP_TF16.6.0Number(1,0)Migrated from: [Students]SOL_SOA_LEP
SOA_Adjustment_Transfer_TF16.6.0Number(1,0)Migrated from: [Students]SOL_SOA_Transfer
SOL_AYP_A16.6.0Varchar2(1)Migrated from: [Students]SOL_AYP_A
SOL_AYP_B16.6.0Varchar2(1)Migrated from: [Students]SOL_AYP_B
SOL_AYP_C16.6.0Varchar2(1)Migrated from: [Students]SOL_AYP_C
SOL_AYP_D16.6.0Varchar2(1)Migrated from: [Students]SOL_AYP_D
SOL_D_Code_TF16.6.0Number(1,0)Migrated from: [Students]SOL_D_Code
SOL_Fall_NonWriting16.6.0Varchar2(300)Migrated from: [Students]SOL_Fall_NonWriting
SOL_Fall_Writing_TF16.6.0Number(1,0)Migrated from: [Students]SOL_Fall_Writing
SOL_Sum_NonWriting16.6.0Varchar2(5)Migrated from: [Students]SOL_Sum_NonWriting
SOL_VP_VA_Test_TF16.6.0Number(1,0)Migrated from: [Students]SOL_VP_VA_Test
Special_Services16.5.0Varchar2(2)Discontinued, previously used for Student Record Exchange Information. Migrated from: [Students]VA_SRE_SP_SVCS
SPED_Parentally_Placed_Stu_TF16.6.0 Number(1,0)Migrated from: [Students]VA_SEStuWasParPlaced
SPED_Placement_Code16.6.0Number(11,0)Migrated from: [Students]VA_SEPlacementCd
SPED_PRIM_DIS_SVC_Percent_Day16.6.0 Number(25,10)Migrated from: [Students]VA_SEPriSvcPct
SPED_Reg_Early_Child_Set16.6.0Varchar2(1)Migrated from: [Students]VA_SEStuInRegErlyChldSet
SPED_Regional_TuitReim_Dis_CD17.2.0Varchar2(2)Migrated from: [Students]VA_SERegTuitReimDisCode
SPED_Regional_TuitReimFrstSem17.2.0Number(25,10)Migrated from: [Students]VA_SERegTuitReimFrstSem
SPED_Regional_TuitReimSecSem17.2.0Number(25,10)Migrated from: [Students]VA_SERegTuitReimSecSem
SPED_Regional_TuitReimSumSem17.2.0Number(25,10)Migrated from: [Students]VA_SERegTuitReimSumSem
SPED_Sec_DIS_SVC_Percent_Day16.6.0Number(25,10)Migrated from: [Students]VA_SESecSvcPct
SPED_Secondary_Disability_Code16.6.0Number(11,0)Migrated from: [Students]VA_SESecDisCd
SPED_Secondary_Serv_Division16.6.0Varchar2(20)Migrated from: [Students]VA_SESecSrvDiv
SPED_Secondary_Serv_School16.6.0Varchar2(20)Migrated from: [Students]VA_SESecSrvSch
SPED_STU_REG_Class_Percent16.6.0Number(25,10)Migrated from: [Students]VA_SERegClassPct
SPED_Third_DIS_SVC_Percent_Day16.6.0Number(25,10)Migrated from: [Students]VA_SEThirdSvcPct
SPED_Third_Disability_Code16.6.0Number(11,0)Migrated from: [Students]VA_SEThirdDisCd
SPED_Third_Serv_Division16.6.0Varchar2(20)Migrated from: [Students]VA_SEThirdSrvDiv
SPED_Third_Serv_School16.6.0Varchar2(20)Migrated from: [Students]VA_SEThirdSrvSch
SPED_TimeReg_Early_ChildSet16.6.0Varchar2(1)Migrated from: [Students]VA_SEStuInRegErlyChldSetHrs
SPED_Weekly_Time_Percent16.6.0Number(25,10)Migrated from: [Students]VA_Sp_Ed_Per

SRC_Active_Status

14.5.0

Varchar2(1)

Indicates whether student is considered Active for purposes of Student Record Collection.

Student_Comments16.6.0Varchar2(360)Migrated from: [Students]VA_StudentComments
Summer_Drop_TF16.6.0Number(1,0)Migrated from: [Students]VA_Summ_Drop
Summer_Writing_TF16.6.0Number(1,0)Migrated from: [Students]SOL_Sum_Writing
Supp_Ed_Serv_Provider_Num_Eng16.6.0Varchar2(5)Migrated from: [Students]VA_SuppEdServProviderNumEng
Supp_Ed_Serv_Provider_Num_Math16.6.0Varchar2(5)Migrated from: [Students]VA_SuppEdServProviderNumMath
Suppl_Ed_Serv_Status_Code16.5.0Number(11,0)

Retired by VADOE 2013. Migrated from:[Students]VA_SupplEdServStatusCD

The use of this field is discontinued for state reporting purposes and now resides on the State/Province-VA > Discontinued tab.

Tech_Prep_TF16.6.0Number(1,0)Migrated from: [Students]VA_tech_prep
Temporary_Condition_TF16.6.0Number(1,0)Migrated from: [Students]VA_SOL_Temp_Cond
Term_Grad_Non_Writing_TF16.6.0Number(1,0)Migrated from: [Students]SOL_Term_Grad
TermGradWriting 15.1.0Number(1,0)Indicates whether student is a term grad in the writing administration period.
Title1TAS 14.9.0Number(11,0)

Column 18 in SOL Student Data Upload File Requirements.

Column 18 in VAAP, VGLA, VSEP Student Data Upload File Requirements.

Title_1_Code16.5.0Varchar2(2)Code that indicates type of program funded by Title I if the student attends a Target Assisted school, i.e. reading, math, reading and math. Migrated from: [Students]VA_Title1_Code
Transcript_ACT_Exclude_YN17.4.0Varchar2(1)Indicates whether the ACT test scores on the VA Transcript are excluded.
Transcript_Class_Rank16.4.0Varchar2(30)Indicates class rank for transferred out and/or graduated students
Transcript_GPA16.4.0Number(25,10)Indicates whether non-cumulative type GPAs as Core GPA service only returns cumulative type GPAs
Transcript_GPA216.4.0Number(25,10)Indicates whether non-cumulative type GPAs as Core GPA service only returns cumulative type GPAs
Transcript_GPA2_Name16.4.0Varchar2(50)Name of GPA on transcript.
Transcript_GPA_Name16.4.0Varchar2(50)Name of GPA on transcript.
Transcript_SAT_Exclude_YN17.4.0Varchar2(1)Indicates whether the SAT test scores are excluded on the VA Transcript.
Transcript_SATSUBJ_Exclude_YN17.4.0Varchar2(1)Indicates whether the SAT subject area is excluded on the VA Transcript.
Truancy_Conference_TF16.5.0Number(1,0)Indicates whether a truancy conference was held with the student's parent after the student had accumulated six absences during the school year without indication of the parent's or guardian's awareness and support of such absence.Migrated from: [Students]VA_Truancy_Conf
Tuition_Paid_Code16.5.0Varchar2(3)Code that indicates the tuition equivalent to the state's contribution towards educational costs (i.e. ADM) is paid by or received from a public entity for this student. Migrated from:[Students]VA_TuitionPaid
Unaccom_Homeless_Youth_Flag_TF16.5.0Number(1,0)Indicates whether the student is an unaccompanied homeless youth. Migrated from: [Students]VA_Unacc_Hless_Youth_Flag
Virginia_Ethnicity_Race_Code16.5.0Varchar2(10)

Code for one or more races with which the student identifies. Migrated from: [Students]VA_ERCode

W8_Dropout_Reason16.5.0Varchar2(2)Code associated with W880 to identify the reason the student discontinued school. Migrated from [Students]VA_Dropout_Reason
LocalAwardCreditOverride19.8.2.0Varchar2(1)Overrides the number of locally awarded verified credits earned for SRC reporting only
RegStu_PercentTime20.8.2.0Number(11,0)A new field to store regional percent time
RemInstr_PercentTime20.8.2.0Number(11,0)A new field to store remote instruction percent time
SplPerm_LocAwardOverride19.8.2.0Varchar2(1)Overrides the number of special permission locally awarded verified credits earned for SRC reporting only
CreditAccomodation19.8.2.0Varchar2(10)State assigned codes for credit accommodations.
Early_Int_Serv19.8.2.0Varchar2(1)Indicates whether student received CEIS or CCEIS services at any point during the school year.
IntensiveSupport19.8.2.0Varchar2(2)Intensive Support Services code.

JavaScript errors detected

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

If this problem persists, please contact our support.

Contact Support Close