S_MD_STU_X (ver 14.8.0)

StudentsDCID

14.8.0

Number(10,0)

Primary Key.

Accountability_Sch_Override

18.3.0

Varchar2 (10)

The four-digit code assigned to the school for which the student will be reported for Accountability. 

ADAM_MCAP_Testing_Status

24.11.1.0

Varchar2 (11)

Test Status for ADAM MCAP student import.

Case_Number

19.6.2.0

Varchar2(9)

The SNAP or TCA Case Number for Direct Verification.

Concentrator_Designation

16.12.3

Varchar2(2)

CTE - Concentrator Designation

County_Code

19.6.2.0

Varchar2(2)

The two-digit code for the county of residence.

EL_Exempt

16.6.0

Varchar2(1)

Indicator for EL Exempt for End of Year Attendance Collection.

ELL

16.12.3

Varchar2(2)

A student who has a primary or home language other than English and who has been identified as qualifying for ESOL services.

ELL_Begin_Date

16.12.3

Date

The date the a student classified as EL and is receiving ESOL services in any school in the U.S.

ELL_CountryOfBirth

14.9.3

Varchar2(2)

Identifies the student's country of birth.

ELL_End_Date

16.12.3

Date

The date the a student classified as EL and stopped receiving ESOL services in any school in the U.S.

ELL_FirstTimeSummativeTested

17.6.0

Number(1,0)

Indicates if the student took the summative test for the first time in the school year in Maryland.

ELL_HomeLanguage

14.9.3

Varchar2(3)

Indicates the student's home language.

ELL_DateParentRefusedServices

14.9.3

Date

Indicates the date the parent(s) refused EL services.

ELL_InterruptedSchooling

14.9.3

Number(1,0)

Interrupted Schooling

ELL_LiteracyInL1

14.9.3

Number(1,0)

Literacy in L1

ELL_FirstTimePlacementTest

14.9.3

Number(1,0)

Indicates if the student took the EL Placement Test for the first time in the current school year in Maryland.

ELL_DatePlacementTestTaken

14.9.3

Date

Indicates the date the student took the EL Placement Test.

Entry_Status

16.12.3

Varchar2(2)

Entry Status

EL_Exclude_Speaking_Domain

24.6.1.0

Varchar2(1)

Exclude from Speaking Domain.

EL_Exclude_Listening_Domain

24.6.1.0

Varchar2(1)

Exclude from Listening Domain.

EL_Exclude_Reading_Domain

24.6.1.0

Varchar2(1)

Exclude from Reading Domain.

EL_Exclude_Writing_Domain

24.6.1.0

Varchar2(1)

Exclude from Writing Domain.

Exit_Status

16.12.3

Varchar2(2)

Exit Status

Evening_High_Student

16.12.3

Number(1,0)

Evening High Student

FARMS

16.12.3

Number(1,0)

Obsolete Data Element - FARMS Indicator (Lunch Status field is used instead)

Federal_Poverty_Level

22.8.2.0

VarChar2(3)

Indicates a students Federal Poverty level 000-999.

First_Date_In_US_School

16.8.1

Date

First Date attended a US School

First_Year_Ninth_Grade

16.12.3

Number(1,0)

Year for first time 9th Grader

Foreign_Exchange

16.12.3

Number(1,0)

Indicator that the student is a non-US citizen enrolled in a Foreign Exchange Program.

Foster_Care_TF

17.3.0

Number(1,0)

Foster Care Indicator (True/False)

Full_Time_Satus

16.12.3

Varchar2(2)

Full-time Status

Generation

16.12.3

Varchar2(4)

Generation Suffix

Geographic_ID

21.9.2.0

Varchar2(15)

A census block identified by: state/territory (2-digit code), county within a state (3-digit code), tract within a county (6-digit code), and a block within a tract (4-digit code).

Gifted_Talented

16.10.0

Varchar2(1)

Gifted and Talented (Y - Yes, N - No, X - Not Collected or N/A )

Hispan_Lat_TF

17.2.0

Number(1,0)

Indicator that the student traces their origin or descent to Mexico, Puerto Rico, Cuba, Central and South America and other Spanish cultures.

Homeless

16.12.3

Number(1,0)

Indicates whether a student lacks a fixed, regular, and adequate nighttime residence.

Homeless_McKinney

16.12.3

Number(1,0)

Homeless Served-McKinney

Homeless_Other

16.12.3

Number(1,0)

Homeless Served-Other

Homeless_Primary_Residence

16.12.3

Varchar2(2)

Homeless Primary Nighttime Residence

Homeless_Youth

16.12.3

Number(1,0)

Homeless Unaccompanied Youth Status

Immigrant

16.12.3

Number(1,0)

Immigrant

KRA_PC_Informal_Care

19.3.0

Varchar2(1)

Prior Care - Informal Care

KRA_PC_Head_Start

19.3.0

Varchar2(1)

Prior Care - Head Start

KRA_PC_Prek

19.3.0

Varchar2(1)

Prior Care - Prekindergarten Public School

KRA_PC_Chld_Care_Cntr

19.3.0

Varchar2(1)

Prior Care - Child Care Center

KRA_PC_Family

19.3.0

Varchar2(1)

Prior Care - Family Child Care

KRA_PC_NP_Nursery

19.3.0

Varchar2(1)

Prior Care - Nonpublic Nursery School

KRA_PC_KG_Repeat

19.3.0

Varchar2(1)

Prior Care - Kindergarten Repeated

KRA_Predominant_Prior_Care

14.8.0

Varchar2(1)

Type of Predominant Prior Care

KRA_Home_Care_TF

14.8.0

Number(1,0)

Home Care

KRA_Other_PC_Head_Start_TF

14.8.0

Number(1,0)

Head Start - Other Prior Care

KRA_Other_PC_Prek_TF

14.8.0

Number(1,0)

Prekindergarten - Other Prior Care

KRA_Other_PC_Chld_Care_Cntr_TF

14.8.0

Number(1,0)

Child Care Center - Other Prior Care

KRA_Other_PC_Family_TF

14.8.0

Number (1,0)

Family Child Care - Other Prior Care

KRA_Other_PC_Nursery_TF

14.8.0

Number(1,0)

Non-Public Nursery - Other Prior Care

KRA_Other_PC_Even_Start_TF

14.8.0

Number(1,0)

Even Start - Other Prior Care

KRA_Other_PC_Hippy_TF

14.8.0

Number(1,0)

HIPPY - Other Prior Care

KRA_Other_PC_Prnts_As_Tchrs_TF

14.8.0

Number(1,0)

Parents as Teachers - Other Prior Care

KRA_Other_PC_PreSchool_SPED_TF

14.8.0

Number(1,0)

Preschool Special Education - Other Prior Care

KRA_Other_PC_Not_Listed_TF

14.8.0

Number(1,0)

Other Not Listed - Other Prior Care

Limited_English_Proficiency

16.12.3

Number(1,0)

Obsolete Data Element - Limited English Proficiency (ELL field is used instead)

Migrant

16.12.3

Number(1,0)

Indicator of a migratory student.

Military_Dependent

17.3.0

Varchar2(1)

Student is a dependent of parent serving in the military.

MISA_Exclude

17.1.0

Number(1,0)

Exclude from MISA Report

Number_College_Courses

15.10.3

Integer

Number of College Courses

Number_Of_Courses

16.12.3

Number(1,0)

Number of Courses

Opt_Out_Directory

16.12.3

Number(1,0)

Opt Out of Directory

parcc_exclude

14.11.0

Number(1,0)

Exclude Student from PARCC Testing

parcc_Retest

14.11.0

Number(1,0)

Student is retaking Test

parcc_lepReadingExempt

14.11.0

Number(1,0)

Exempt from reading test due to LEP

parcc_lepMathExempt

14.11.0

Number(1,0)

Exempt from reading test due to LEP

parcc_accomm_ELL

14.11.0

Number(1,0)

ELL Accommodations

parcc_accomm_504

14.11.0

Number(1,0)

504 Accommodations

parcc_accomm_IEP

14.11.0

Number(1,0)

IEP Accommodations

parcc_accomm_Paper

14.11.0

Number(1,0)

Paper Accommodations

parcc_accomm_TranslationMath

14.11.0

Number(1,0)

Math Test Translation

parcc_accomm_Reader

14.11.0

Number(1,0)

Human Reader

parcc_accomm_LargePrint

14.11.0

Number(1,0)

Test format Large print

parcc_accomm_Braille

14.11.0

Number(1,0)

Test format Braille

parcc_accomm_Signer

14.11.2

Number(1,0)

Human Signer

parcc_MAT_IncExc

14.11.2

Varchar2(1)

Include or Exclude from grade 3-8 MAT test

parcc_ELA_IncExc

14.11.2

Varchar2(1)

Include or Exclude from grade 3-8 ELA test

parcc_ALGI_IncExc

14.11.2

Varchar2(1)

Include or Exclude from ALG I test

parcc_ALGII_IncExc

14.11.2

Varchar2(1)

Include or Exclude from ALG II test

parcc_GEO_IncExc

14.11.2

Varchar2(1)

Include or Exclude from GEO test

Part_Time_Day_Student

16.12.3

Number (1,0)

Part-time Day Student

PreId_ALGI_Retest

17.10.0

Number(1,0)

Obsolete 20.11.1.0 Indicates if a student's test attempt is a retest for ALGI

PreId_ALGII_Retest

17.10.0

Number(1,0)

Obsolete 20.11.1.0 Indicates if a student's test attempt is a retest for ALGII

PreId_ELA9_IncExc

17.10.0

Varchar2(1)

Obsolete 20.11.1.0 Indicates if a student is to be included, if not taking an associated course, or excluded, if taking an associated course, from the file for ELA9

PreId_ELA9_Retest

17.10.0

Number(1,0)

Obsolete 20.11.1.0 Indicates if a student's test attempt is a retest for ELA 9

PreId_ELA10_IncExc

17.10.0

Varchar2(1)

 Indicates if a student is to be included, if not taking an associated course, or excluded, if taking an associated course, from the file for ELA9

PreId_ELA10_Retest

17.10.0

Number(1,0)

Obsolete 20.11.1.0 Indicates if a student's test attempt is a retest for ELA10

PreId_ELA11_IncExc

17.10.0

Varchar2(1)

Obsolete 20.11.1.0 Indicates if a student is to be included, if not taking an associated course, or excluded, if taking an associated course, from the file for ELA9

PreId_ELA11_Retest

17.10.0

Number(1,0)

Obsolete 20.11.1.0 Indicates if a student's test attempt is a retest for ELA11

PreId_Exclude_All

17.10.0

Number(1,0)

Flag used to identify students who are excluded from all State testing except for Alternate Assessments.

PreId_GEO_Retest

17.10.0

Number(1,0)

Obsolete 20.11.1.0 Indicates if a student's test attempt is a retest for Geometry

PreId_HSBIO_IncExc

17.10.0

Varchar2(1)

Indicates if a student is to be included, if not taking an associated course, or excluded, if taking an associated course, from the file for HS biology

PreId_HSGOV_IncExc

17.10.0

Varchar2(1)

Indicates if a student is to be included, if not taking an associated course, or excluded, if taking an associated course, from the file for HS Government

PreId_SCI_IncExc

17.10.0

Varchar2(1)

Indicates if a student is to be included, if not taking an associated course, or excluded, if taking an associated course, from the file for grades 5 or 8 science

PreK_Tier_Status

22.8.2.0

VarChar2(1)

Indicates a student's Pre-K Tier Status.

Primary_Disability

16.12.3

Varchar2(4)

Indicates the primary disability of a student

Promotion_Code

16.12.3

Varchar2(4)

Promotion Code

Race_Amer_Ind_TF

17.2.0

Number(1,0)

A student having origins in any of the original peoples of North and South America and maintains cultural affiliation or community attachment.

Race_Asian_TF

17.2.0

Number(1,0)

A student having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian Subcontinent.

Race_Black_TF

17.2.0

Number(1,0)

A student having origins in any of the original peoples of the black racial groups of Africa.

Race_Hawaiian_TF

17.2.0

Number(1,0)

A student having origins in any of the original peoples of the original peoples of Hawaii, Guam, Samoa, or Other Pacific Islander.

Race_White_TF

17.2.0

Number(1,0)

A student having origins in any of the original peoples of Europe, Middle East, or North America.

Secondary_Disability

16.10.1

Varchar2(2)

Indicates the students secondary disability if identified.

Student_Type

16.10.1

Varchar2(1)

Student Type (P - Public (default), C - Charter, H - Homeschool)

Sec504_Begin_Date

16.12.3

Date

Code 504 Begin Date

Sec504_End_Date

16.12.3

Date

Code 504 End Date

Sec504_Plan

16.12.3

Number(1,0)

Obsolete. 504 uses Special_Education Value '3' or '4'.

Single_Parent

16.12.3

Varchar2(2)

CTE - Single Parent

SOC_IncExc

20.11.2.0

Varchar2(1)

Include or Exclude from SOC test

Special_Education

16.12.3

Varchar2(2)

Indicator that the student has a disability(ies) and receives special education and related services under IDEA.

SpecEd_Begin_Date

16.12.3

Date

Date that the student began special education services.

SpecEd_End_Date

16.12.3

Date

Date that the student exited special education services.

Special_Ed_Certificate

16.12.3

Number(1,0)

Indicator that the student's IEP indicates the student is on track to receive a MD High School Certificate of Program Completion.

State_Aid_Eligibility

16.12.3

Varchar2(4)

State Aid Eligibility

Targeted_Assistance

16.12.3

Number(1,0)

Targeted Assistance Program (TAS)

Tech_Assess

16.12.3

Number(1,0)

CTE - Technical Assessment

Tech_Assess_Attain

16.12.3

Number(1,0)

CTE - Technical Skill Attainment

Tech_Assess_Attempt

16.12.3

Number(1,0)

CTE - Technical Assessment Attempted

Test_Status

20.11.1.0

VarChar2(1)

Students MD Test Status

Title_III_Status

16.10.0

Varchar2(1)

Title III Limited English Proficient Participation Status

Title_One

16.12.3

Number(1,0)

Indicator that the student is participating in and served by programs under Title I.