S_MD_STU_HSSC_X (ver 16.5.1)

StudentsDCID

16.5.1

Number (10,0)

Primary Key.

Accu_College_Math_Score

16.5.1

Integer

Accuplacer College Math Score

Accu_College_Math_Test_Date

16.5.1

Varchar2 (10)

Accuplacer College Math Test Date (MMYYYY)

Accu_El_Algebra_Score

16.5.1

Integer

Accuplacer Elementary Algebra Score

Accu_El_Algebra_Date

16.5.1

Varchar2 (10)

Accuplacer Elementary Algebra Test Date (MMYYYY)

Accu_Reading_Score

16.5.1

Integer

Accuplacer Reading Score

Accu_Reading_Test_Date

16.5.1

Varchar2 (10)

Accuplacer Reading Test Date (MMYYYY)

Accu_Sentence_Skills_Score

16.5.1

Integer

Accuplacer Sentence Skills Score

Accu_Sentence_Skills_Test_Date

16.5.1

Varchar2 (10)

Accuplacer Sentence Skills Test Date (MMYYYY)

Accu_Writing_Score

16.5.1

Integer

Accuplacer Writing Score

Accu_Writing_Test_Date

16.5.1

Varchar2 (10)

Accuplacer Writing Test Date (MMYYYY)

ACT_Eng_Reading_Score

16.5.1

Integer

ACT English & Reading Score

ACT_Eng_Reading_Test_Date

16.5.1

Varchar2 (10)

ACT English & Reading Test Date (MMYYYY)

ACT_Math_Score

16.5.1

Integer

ACT Mathematics Score

ACT_Math_Test_Date

16.5.1

Varchar2 (10)

ACT Math Test Date (MMYYYY)

ACT_Over_20

16.12.3

Number (1,0)

Course Indicator - ACT Greater than 20

ACT_Over_20_YN

19.5.1.0

Varchar 2 (1)

Course Indicator - ACT Greater than 20

Algebra_Accommodation_Flag

17.6.0

Varchar2 (1)

Indicates if the student took the algebra assessment with accommodations.

Algebra_Accommodation_Flag2

17.6.0

Varchar2 (1)

Indicates if the student took a second algebra assessment with accommodations.

Algebra_Assessment

16.5.1

Varchar2 (4)

Obsolete - 21.5.3.0 Algebra Assessment

Algebra_Assessment2

16.5.1

Varchar2 (4)

Obsolete - 21.5.3.0 2nd Algebra Assessment

Algebra_Assessment_Date

16.5.1

Varchar2 (10)

Algebra Assessment Date (MMYYYY)

Algebra_Assessment_Date2

16.5.1

Varchar2 (10)

2nd Algebra Assessment Date (MMYYYY)

Algebra_Assessment_Status2

16.5.1

Varchar2 (4)

2nd Algebra Assessment Status

Algebra_Invalid_Flag

16.5.1

Varchar2 (4)

Indicates if the Algebra assessment taken has been invalidated.

Algebra_Invalid_Flag2

16.5.1

Varchar2 (4)

Indicates if the secondary Algebra assessment taken has been invalidated.

Algebra_Level

16.5.1

Integer

Algebra Level

Algebra_Level2

16.5.1

Integer

2nd Algebra Level

Algebra_Score

16.5.1

Integer

Algebra Score

Algebra_Score2

16.5.1

Integer

2nd Algebra Score

Algebra_Test_Security_Flag

16.5.1

Varchar2 (4)

Algebra Test Security Flag

Algebra_Test_Security_Flag2

16.5.1

Varchar2 (4)

2nd Algebra Test Security Flag

AltMSA_Student

16.12.3

Varchar2 (1)

AltMSA Identified Student

Apprenticeship_Hrs

23.8.1.0

Integer

Apprenticeship Hours

Apprenticeship_Particip

23.8.1.0

Varchar2(1)

Apprenticeship Participation

AP_ELA_Score

16.5.1

Integer

AP ELA Score

AP_ELA_Test

16.5.1

Varchar2 (4)

AP ELA Test

AP_ELA_Test_Date

16.5.1

Varchar2 (10)

AP ELA Test Date (MMYYYY)

AP_Math_Score

16.5.1

Integer

AP Math Score

AP_Math_Test

16.5.1

Varchar2 (4)

AP Math Test

AP_Math_Test_Date

16.5.1

Varchar2 (10)

AP Math Test Date (MMYYYY)

AYP_Rep_School

16.12.3

Varchar2 (4)

AYP Reporting School

AYP_Rep_System

16.12.3

Varchar2 (2)

AYP Reporting System

Biology_Accommodation_Flag

17.6.0

Varchar2 (1)

Indicates if the student took the biology assessment with accommodations.

Bio_Assessment

16.5.1

Varchar2 (4)

Obsolete - 21.5.3.0 Biology Assessment

Bio_Assessment_Date

16.5.1

Varchar2 (10)

Biology Assessment Date (MMYYYY)

Bio_Invalid_Flag

16.5.1

Varchar2 (4)

Biology Invalid Flag

Bio_Level

16.5.1

Integer

Biology Level

Bio_Score

16.5.1

Integer

Biology Score

Bio_Test_Security_Flag

16.5.1

Varchar2 (4)

Biology Test Security Flag

Bridge_Plan_Alg

16.12.3

Varchar2 (1)

Algebra - Bridge Plan/Waiver Student

Bridge_Plan_Bio

16.12.3

Varchar2 (1)

Biology - Bridge Plan/Waiver Student

Bridge_Plan_Eng2

16.12.3

Varchar2 (1)

English 2 - Bridge Plan/Waiver Student

Bridge_Plan_Gov

16.12.3

Varchar2 (1)

Government - Bridge Plan/Waiver Student

Bridge_Proj_Status_ELA

18.5.0

Varchar2 (1)

An indicator of the student's status on the Bridge Plan for Academic Validation in English/Language Arts.

Bridge_Proj_Status_Gov

18.5.0

Varchar2 (1)

An indicator of the student's status on the Bridge Plan for Academic Validation in Government.

Bridge_Proj_Status_Math

18.5.0

Varchar2 (1)

An indicator of the student's status on the Bridge Plan for Academic Validation in Math.

Bridge_Proj_Status_Sci

18.5.0

Varchar2 (1)

An indicator of the student's status on the Bridge Plan for Academic Validation in Science.

CCR_Elg_Status_alg1

24.7.3.0

Varchar2 (2)

Math Mastery ALG1.

CCR_Elg_Status_alggrade

24.7.3.0

Varchar2 (2)

Math Mastery Grade.

CCR_Elg_Status_ela10

24.7.3.0

Varchar2 (2)

ELA10 Proficiency.

CCR_Elg_Status_GPA

24.7.3.0

Varchar2 (2)

Academic Success GPA.

CCR_Math_Flag

16.5.1

Varchar2 (5)

"Y" or "N" indicator that the student met the College and Career Readiness determination in Math at the end of their 11th grade year.

CCR_Math_Flag_12

18.5.0

Varchar2 (1)

"Y" or "N" indicator that the student met the College and Career Readiness determination in Math at the end of their 12th grade year.

CCR_ELA_Flag

16.5.1

Varchar2 (5)

"Y" or "N" indicator that the student met the College and Career Readiness determination in English/Language Arts (ELA) at the end of their 11th grade year.

CCR_ELA_Flag_12

18.5.0

Varchar2 (1)

"Y" or "N" indicator that the student met the College and Career Readiness determination in English/Language Arts (ELA) at the end of their 12th grade year.

CCR_Option1A

24.5.2.0

Boolean

CCR is determined by Option 1A of After 2 years of high school the GPA >= 3.0 (unweighted) and Algebra I grade of A, B, or C.

CCR_Option1B

24.5.2.0

Boolean

CCR is determined by Option 1B of After 2 years of high school the GPA >= 3.0 (unweighted) and Algebra I MCAP score of >=750.

CCR_Option2

24.5.2.0

Boolean

CCR determined by Option 2 where Score of >=750 on BOTH Algebra I MCAP or English 10 MCAP.

CCR_Interim_Standard

24.5.2.0

Boolean

CCR determined by Interim Standard where Score of >=750 on BOTH Algebra I MCAP, Geometry MCAP, Algebra II MCAP, or 520 on SAT Math and >= 750 on English 10 MCAP.

CCR_Sub_Assmnt_Status_Math

22.6.3.0

Varchar2 (2)

An indicator that the student was assessed for College and Career Readiness in Math.

CCR_Sub_Assmnt_Status_Eng

22.6.3.0

Varchar2 (2)

An indicator that the student was assessed for College and Career Readiness in English.

CCR_Sub_Elg_Status_Math

22.6.3.0

Varchar2 (2)

An indicator that the student met the College and Career Readiness standard in Math.

CCR_Sub_Elg_Status_English

22.6.3.0

Varchar2 (2)

An indicator that the student met the College and Career Readiness standard in English.

CIP_Code

16.12.3

Varchar2 (20)

Career and Technology Education CIP

Complete_Adv_Tech_Ed

16.12.3

Number (1,0)

No longer used. Replaced with Complete_Adv_Tech_Ed_YN.

Complete_Adv_Tech_Ed_YN

19.4.1.0

VarChar2 (1)

Completed Course Indicator - Approved Advanced Tech Ed

Complete_Foreign_Lang

16.12.3

Number (1,0)

No longer used. Replaced with Complete_Foreign_Lang_YN.

Complete_Foreign_Lang_YN

19.4.1.0

VarChar2 (1)

Completed Course Indicator - Foreign Language

Complete_Mathematics

16.12.3

Number (1,0)

No longer used. Replaced with Complete_Mathematics_YN.

Complete_Mathematics_YN

19.4.1.0

VarChar2 (1)

Completed Course Indicator - Mathematics

Complete_Science

16.12.3

Number (1,0)

No longer used. Replaced with Complete_Science_YN.

Complete_Science_YN

19.4.1.0

VarChar2 (1)

Completed Course Indicator - Science

Completion_Code

16.5.1

Varchar2 (5)

Completion Code

Completion_Status

16.5.1

Varchar2 (5)

Completion Status

Dual_Enroll_Earned_Credit

18.5.0

Varchar2 (1)

"Y" or "N" indicator that the student earned credit for a dual enrollment opportunity.

Dual_Enroll_ELA

16.5.1

Varchar2 (5)

Dual Enrollment - ELA

Dual_Enroll_Math

16.5.1

Varchar2 (5)

Dual Enrollment - Math

Dual_Enroll_Participated

18.5.0

Varchar2 (1)

"Y" or "N" indicator that the student participated in a dual enrollment opportunity. 

ELA_Accommodation_Flag

17.6.0

Varchar2 (1)

Indicates if the student took the ELA assessment with accommodations.

ELA_Accommodation_Flag2

16.5.1

Varchar2 (4)

Indicates if the student took a second ELA assessment with accommodations.

ELA_Assessment

16.5.1

Varchar2 (4)

Obsolete - 21.5.3.0 English/Language Arts (ELA) Assessment

ELA_Assessment2

16.5.1

Varchar2 (4)

Obsolete - 21.5.3.0 2nd English/Language Arts (ELA) Assessment

ELA_Assessment_Date

16.5.1

Varchar2 (10)

ELA Assessment Date (MMYYYY)

ELA_Assessment_Date2

16.5.1

Varchar2 (10)

2nd ELA Assessment Date (MMYYYY)

ELA_Assessment_Status2

16.5.1

Varchar2 (4)

2nd ELA Assessment Status

ELA_Invalid_Flag

16.5.1

Varchar2 (4)

Indicates if the ELA assessment taken has been invalidated.

ELA_Invalid_Flag2

16.5.1

Varchar2 (4)

Indicates if the secondary ELA assessment taken has been invalidated.

ELA_Level

16.5.1

Integer

ELA Level

ELA_Level2

16.5.1

Integer

2nd ELA Level

ELA_Score

16.5.1

Integer

ELA Score

ELA_Score2

16.5.1

Integer

2nd ELA Score

ELA_Test_Security_Flag

16.5.1

Varchar2 (4)

ELA Test Security Flag

ELA_Test_Security_Flag2

16.5.1

Varchar2 (4)

2nd ELA Invalid Flag

Gov_Accommodation_Flag

17.6.0

Varchar2 (1)

Indicates if the student took the government assessment with accommodations.

Gov_Assessment

16.5.1

Varchar2 (4)

Obsolete - 21.5.3.0 Government Assessment

Gov_Assessment_Date

16.5.1

Varchar2 (10)

Government Assessment Date (MMYYYY)

Gov_Invalid_Flag

16.5.1

Varchar2 (4)

Government Invalid Flag

Gov_PassFail

16.5.1

Integer

Government Pass/Fail Flag

Gov_Score

16.5.1

Integer

Government Score

Gov_Test_Security_Flag

16.5.1

Varchar2 (4)

Government Test Security Flag

GPA_Over_3

16.12.3

Number (1,0)

Obsolete - 24.7.3.0 - Course Indicator - GPA Greater than 3.0

GPA_Over_3_YN

24.7.3.0

Varchar2 (1)

GPA Over 3.0.

Grade_09_Tracker

22.6.3.0

Varchar 2(2)

“Y” or “N” indicator that at the end of a 9th grade student’s first year, the student is on track towards meeting LEA graduation requirement.

Grade_09_Credit_Accumulated

22.6.3.0

Number (25,10)

Indicates the number of credits accumulated by a 9th grade student during the first year of high school.

grade_09_sem_crs_fails

23.8.1.0

Integer

Grade 09 Semester Course Failures.

IB_ELA_Score

16.5.1

Integer

IB ELA Score

IB_ELA_Test

16.5.1

Varchar2 (4)

IB ELA Test

IB_ELA_Test_Date

16.5.1

Varchar2 (10)

IB ELA Test Date (MMYYYY)

IB_Math_Score

16.5.1

Integer

IB Math Score

IB_Math_Test

16.5.1

Varchar2 (4)

IB Math Test

IB_Math_Test_Date

16.5.1

Varchar2 (10)

IB Math Test Date (MMYYYY)

Linking_Alg

16.12.3

Number (1,0)

Algebra - Linking Study Student (2008 only)

Linking_Bio

16.12.3

Number (1,0)

Biology - Linking Study Student (2008 only)

Linking_Eng2

16.12.3

Number (1,0)

English 2 - Linking Study Student (2008 only)

Linking_Gov

16.12.3

Number (1,0)

Government - Linking Study Student (2008 only)

MHSA_Grad_Require_ELA

18.5.0

Varchar2 (2)

An indicator of how the student met the Maryland High School Assessment graduation requirement in English/Language Arts.

MHSA_Grad_Require_Gov

18.5.0

Varchar2 (2)

An indicator of how the student met the Maryland High School Assessment graduation requirement in Government.

MHSA_Grad_Require_Math

18.5.0

Varchar2 (2)

An indicator of how the student met the Maryland High School Assessment graduation requirement in Math.

MHSA_Grad_Require_Sci

18.5.0

Varchar2 (2)

An indicator of how the student met the Maryland High School Assessment graduation requirement in Science.

Met_All_Grad_Require

16.12.3

Number (1,0)

Met All Local Graduation Requirements

PARCC_AlgebraII_Assess_Date

16.5.1

Varchar2 (10)

PARCC Algebra II Assessment Date

PARCC_AlgebraII_Level

16.5.1

Integer

PARCC Algebra II Level

PARCC_AlgebraII_Score

16.5.1

Integer

PARCC Algebra II Score

PARCC_English11_Assess_Date

16.5.1

Varchar2 (10)

PARCC English 11 Assessment Date

PARCC_English11_Level

16.5.1

Integer

PARCC English 11 Level

PARCC_English11_Score

16.5.1

Integer

PARCC English 11 Score

PARCC_Geometry_Assess_Date

16.5.1

Varchar2 (10)

PARCC Geometry Assessment Date

PARCC_Geometry_Level

16.5.1

Integer

PARCC Geometry Level

PARCC_Geometry_Score

16.5.1

Integer

PARCC Geometry Score

Program_Completion

16.12.3

Varchar2 (4)

High School Program Completion

Proj_Cd_Alg

16.12.3

Varchar2 (50)

Algebra - Bridge Plan Project Code

Proj_Cd_Bio

16.12.3

Varchar2 (50)

Biology - Bridge Plan Project Code

Proj_Cd_Eng2

16.12.3

Varchar2 (50)

English 2 - Bridge Plan Project Code

Proj_Cd_Gov

16.12.3

Varchar2 (50)

Government - Bridge Plan Project Code

Promotion_Code

16.5.1

Varchar2 (5)

Promotion Code

Ready_For_PS_Success_AP

18.5.0

Varchar2 (1)

"Y" or "N" indicator that the student met a score of 3 or higher on an Advanced Placement Exam.

Ready_For_PS_Success_IB

18.5.0

Varchar2 (1)

"Y" or "N" indicator that the student met a score of 4 or higher on an International Baccalaureate Program Exam.

Ready_For_PS_Success_SAT

18.5.0

Varchar2 (1)

"Y” or N” indicator that the student met a score on the SAT of 530 or higher in math and 480 or higher in ERBW.

Ready_For_PS_Success_ACT

18.5.0

Varchar2 (1)

"Y” or N” indicator that the student received an ACT Composite score of 21 or better.

Ready_For_PS_Success_ASVAB

18.5.0

Varchar2 (1)

"Y” or N” indicator that the student met the designated standard on the ASVAB examination.

Ready_For_PS_Success_Seal

18.5.0

Varchar2 (1)

"Y” or N” indicator that the student earned the "Seal of Biliteracy."

Ready_For_PS_Success_Apprn

18.5.0

Varchar2 (1)

Indicator of the type of apprenticeship program the student completed.

Re_Assessment_Math

16.5.1

Varchar2 (5)

Re-assessment - Math

Re_Assessment_Math_Code

16.5.1

Varchar2 (5)

Re-assessment - Math Code

Re_Assessment_Math_Score

16.5.1

Integer

Re-assessment - Math Score

Re_Assessment_ELA

16.5.1

Varchar2 (5)

Re-assessment - ELA

Re_Assessment_ELA_Code

16.5.1

Varchar2 (5)

Re-assessment - ELA Code

Re_Assessment_ELA_Score

16.5.1

Integer

Re-assessment - ELA Score

Re_Assessment_Accu_Writing

16.5.1

Integer

Re-assessment - Accuplacer Writing

Re_Assessment_Accu_Sentence

16.5.1

Integer

Re-assessment - Accuplacer Sentence Skills

Results_Alg

16.12.3

Number (1,0)

Algebra - Completer Results

Results_Bio

16.12.3

Number (1,0)

Biology - Completer Results

Results_Eng2

16.12.3

Number (1,0)

English 2 - Completer Results

Results_Gov

16.12.3

Number (1,0)

Government - Completer Results

SAT_Math_Score

16.5.1

Integer

SAT Mathematics Score

SAT_Math_Test_Date

16.5.1

Varchar2 (10)

SAT Math Test Date (MMYYYY)

SAT_Over_1000

16.12.3

Number (1,0)

Course Indicator - SAT Greater than 1000

SAT_Over_1000_YN

19.5.1.0

Varchar2 (1)

Course Indicator - SAT Greater than 1000

SAT_Reading_Score

16.5.1

Integer

SAT Reading/EBRW Score

SAT_Reading_Test_Date

16.5.1

Varchar2 (10)

SAT Reading/EBRW Date (MMYYYY)

Status_Alg

16.12.3

Varchar2 (2)

Algebra - Regular HSA Status

Status_Bio

16.12.3

Varchar2 (2)

Biology - Regular HSA Status

Status_Eng2

16.12.3

Varchar2 (2)

English 2 - Regular HSA Status

Status_Gov

16.12.3

Varchar2 (2)

Government - Regular HSA Status

Status_Mod_Alg

16.12.3

Varchar2 (2)

Algebra - Modified HSA Status

Status_Mod_Bio

16.12.3

Varchar2 (2)

Biology -Modified HSA Status

Status_Mod_Eng2

16.12.3

Varchar2 (2)

English 2 -Modified HSA Status

Status_Mod_Gov

16.12.3

Varchar2 (2)

Government -Modified HSA Status

Status_Plus_Alg

16.12.3

Varchar2 (2)

Algebra - Modified HSA Status Plus+

Status_Plus_Bio

16.12.3

Varchar2 (2)

Biology - Modified HSA Status Plus+

Status_Plus_Eng2

16.12.3

Varchar2 (2)

English 2 - Modified HSA Status Plus+

Status_Plus_Gov

16.12.3

Varchar2 (2)

Government - Modified HSA Status Plus+

Tech_Assess_1_TSA_Result

18.5.0

Varchar2 (1)

A description of the student's results on the technical skills assessment.

Tech_Assess_1_TSA_Code

18.5.0

Varchar2 (10)

Six digit code as designated by MSDE.

Tech_Assess_2_TSA_Result

18.5.0

Varchar2 (1)

A description of the student's results on the technical skills assessment.

Tech_Assess_2_TSA_Code

18.5.0

Varchar2 (10)

Six digit code as designated by MSDE.

Tech_Assess_3_TSA_Result

18.5.0

Varchar2 (1)

A description of the student's results on the technical skills assessment.

Tech_Assess_3_TSA_Code

18.5.0

Varchar2 (10)

Six digit code as designated by MSDE.

Tech_Assess_4_TSA_Result

18.5.0

Varchar2 (1)

A description of the student's results on the technical skills assessment.

Tech_Assess_4_TSA_Code

18.5.0

Varchar2 (10)

Six digit code as designated by MSDE.

Tech_Assess_Attain_Overrride

17.6.0

Varchar2 (1)

Indicates if the value stored in Tech_Assess_ Attain is to be overridden with the value selected in the override field.

Tech_Assess_Attempt_Overrride

17.6.0

Varchar2 (1)

Indicates if the value stored in Tech_Assess_ Attempt is to be overridden with the value selected in the override field.

Tech_Assess_Available_Overrride

17.6.0

Varchar2 (1)

Indicates if the value stored in Tech_Assess is to be overridden with the value selected in the override field.

Transition_Course_Math

16.5.1

Varchar2 (5)

Indicates if the twelfth-grade student completed a Transition Course in mathematics.

Transition_Course_ELA

16.5.1

Varchar2 (5)

Indicates if the twelfth-grade student completed a Transition Course in ELA.