MD - High School Data Collection (HSDC)
Data Element | Field Name | Field Length | Start Position | End Position | eSchoolplus Table.Column | Download Table.Column | Where from eSchoolPLUS |
---|---|---|---|---|---|---|---|
1 | LEA Number | 2 | 1 | 2 | reg_district.state_code_equiv | MD_HSDC_DOWN.LEA_Number | Administration, General Setup, District, District: State Equivalency Code |
2 | School Number | 4 | 3 | 6 | If State res building (Reg.State_Res_Building) is blank, only get the school number from reg_building.state_code_equiv | MD_HSDC_DOWN.Building | |
3 | State Assigned Student ID (SASID) | 10 | 7 | 16 | Reg_personal.State_report_id | MD_HSDC_DOWN.State_Reporting_ID | Registration, Entry & Reports, Student Demographic, Personal: State ID |
4 | Local Student ID Number | 10 | 17 | 26 | Reg.student_id | MD_HSDC_DOWN.Student_ID | |
5 | Last Name | 25 | 27 | 51 | Reg.Last_Name | MD_HSDC_DOWN.Last_Name | Registration, Entry & Reports, Student Demographic, Registration: Last Name |
6 | First Name | 15 | 52 | 66 | If there is a legal first name, the first name is picked from reg_legal_info.legal_first_name | MD_HSDC_DOWN.First_Name | Registration, Entry & Reports, Student Demographic, Personal: First Name |
7 | Middle Name | 15 | 67 | 81 | Reg.Middle_Name | MD_HSDC_DOWN.Middle_Name | Registration, Entry & Reports, Student Demographic, Registration: Middle Name |
8 | Generation Code or Suffix | 3 | 82 | 84 | Reg.Generation | MD_HSDC_DOWN.Generation_Suffix | Registration, Entry & Reports, Student Demographic, Registration: Generation |
9 | Preferred Name (Optional) | 15 | 85 | 99 | If there is a legal first name on the Personal page (reg_legal_info.legal_first_name), the Preferred name will be picked from the Registration page (Reg.First_Name) | MD_HSDC_DOWN.Preferred_Name | Registration, Entry & Reports, Student Demographic, Registration: First name |
10 | Date of Birth | 8 | 100 | 107 | Reg.Birthdate | MD_HSDC_DOWN.Date_Birth | Registration, Entry & Reports, Student Demographic, Registration: Birth Date |
11 | Grade | 2 | 108 | 109 | Reg_entry_with.grade (its respective state code from reg_grade.state_code_equiv) | MD_HSDC_DOWN.Grade | Registration, Entry & Reports, Student Demographic, Entry/withdrawal |
12 | Gender | 1 | 110 | 110 | reg.gender_identity (regtb_gender_identity.state_code_equiv_02) | MD_HSDC_DOWN.Gender | Registration, Entry & Reports, Student Demographic, Registration: Gender |
13 | Hispanic/Latino Ethnicity | 1 | 111 | 111 | reg_personal.Hispanic | MD_HSDC_DOWN.Hispanic_Latino | Registration, Entry & Reports, Student Demographic, Personal: Hispanic/Latino Ethnicity |
14 | American Indian/Alaskan Native | 1 | 112 | 112 | reg_personal.ethnic_code where ethnic_code = 1 (regtb_ethnicity.state_code_equiv) | MD_HSDC_DOWN.American_Indian_Alaskan | Registration, Entry & Reports, Student Demographic, Personal: Race |
15 | Asian | 1 | 113 | 113 | reg_personal.ethnic_code where ethnic_code = 2 | MD_HSDC_DOWN.Asian | Registration, Entry & Reports, Student Demographic, Personal: Race |
16 | Black or African American | 1 | 114 | 114 | reg_personal.ethnic_code where ethnic_code = 3 | MD_HSDC_DOWN.Black_African_American | Registration, Entry & Reports, Student Demographic, Personal: Race |
17 | Native Hawaiian or Other Pacific Islander | 1 | 115 | 115 | reg_personal.ethnic_code where ethnic_code = 4 | MD_HSDC_DOWN.Native_Hawaiian | Registration, Entry & Reports, Student Demographic, Personal: Race |
18 | White | 1 | 116 | 116 | reg_personal.ethnic_code where ethnic_code = 5 | MD_HSDC_DOWN.White | Registration, Entry & Reports, Student Demographic, Personal: Race |
19 | Homelessness Status | 1 | 117 | 117 | reg_programs.program_value where reg_program_column.state_code_equiv='MDHOMELESS' | MD_HSDC_DOWN.Homelessness_Status | Registration, Entry & Reports, Student Demographic, Programs, HOME - Homeless: Homeless |
20 | Title I Indicator | 1 | 118 | 118 | reg_programs.program_value where reg_program_column.state_code_equiv='MDTitle1' | MD_HSDC_DOWN.Title_1_Indicator | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Title I |
21 | Free/Reduced Price Meal Eligibility | 1 | 119 | 119 | reg_programs.program_value where reg_program_column.state_code_equiv='MDFARMS' | MD_HSDC_DOWN.Free_Reduced_Meal | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Meal Status |
22 | Migrant Status | 1 | 120 | 120 | Reg_personal.migrant | MD_HSDC_DOWN.Migrant_Status | Registration, Entry & Reports, Student Demographic, Personal: Migrant |
23 | Foreign Exchange Student Indicator | 1 | 121 | 121 | reg_programs.program_value where reg_program_column.state_code_equiv='MDFOREXCH' | MD_HSDC_DOWN.Foreign_Exchange | Registration, Entry & Reports, Student Demographic, Programs, FOREX - Foreign Exchange Student: Foreign Exchange Student |
24 | Special Education (SE) Indicator | 1 | 122 | 122 | reg_programs.program_value where reg_program_column.state_code_equiv='MDSpecED' | MD_HSDC_DOWN.SpEd_Indicator | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Special Education Indicator |
25 | Special Education End Date | 8 | 123 | 130 | reg_programs.end_date where reg_program_column.state_code_equiv='MDSpecED' | MD_HSDC_DOWN.SpEd_End_Date | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Special Education Indicator |
26 | Special Education Certificate Status | 1 | 131 | 131 | reg_programs.program_value where reg_program_column.state_code_equiv='MDSpCertif' | MD_HSDC_DOWN.SpEd_Certificate | |
27 | English Learner (EL) Status | 1 | 132 | 132 | reg_programs.program_value where reg_program_column.state_code_equiv='MDLEP' | MD_HSDC_DOWN.English_Learner_Status | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: English Language Learner |
28 | English Learner Entry into the US Date | 8 | 133 | 140 | Reg.US_Enroll_Date | MD_HSDC_DOWN.EL_Entry_Into_US_Date | Registration, Entry & Reports, Student Demographic, Registration: US Enrollment Date |
29 | English Learner Service Begin Date | 8 | 141 | 148 | If the ELL status is E or Y, the reg_programs.start_date where reg_program_column.state_code_equiv='MDLEP' | MD_HSDC_DOWN.EL_Service_Begin_Date | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: English Language Learner |
30 | English Learner Service End Date | 8 | 149 | 156 | If the ELL status is E, the reg_programs.end_date where reg_program_column.state_code_equiv='MDLEP' | MD_HSDC_DOWN.EL_Service_End_Date | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: English Language Learner |
31 | English Learner ELA Assessment Exempt Status | 1 | 157 | 157 | reg_user.field_value where screen_number = 11012 AND field_number = 100 | MD_HSDC_DOWN.ELA_Exempt_Status | Registration, Entry & Reports, Student District Defined, Accommodations English Learners (EL): ELA Assessment Exempt Status |
32 | Foster Care Status | 1 | 158 | 158 | Defaulted to N | MD_HSDC_DOWN.Foster_Care_Status | |
33 | Military Connected Indicator | 1 | 159 | 159 | reg_user.field_value where screen_number = 11002 AND field_number = 4 | MD_HSDC_DOWN.Military_Connected_Indicator | Registration, Entry & Reports, Student District Defined, MD Student Record: Active Duty Military Parent |
34 | Filler | 33 | 160 | 192 | |||
35 | Submission Date | 8 | 193 | 200 | Current date when you run the report | MD_HSDC_DOWN.Submission_Date | |
36 | MCA Graduation Requirement - Math | 2 | 201 | 202 | reg_programs.program_value where reg_program_column.state_code_equiv='MHSAMATH' | MD_HSDC_DOWN.MHSA_Graduation_Requirement_Math | Registration, Entry & Reports, Student Demographic, Programs, GRDRQ - MHSA Graduation Requirement: Math |
37 | MCA Graduation Requirement - ELA | 2 | 203 | 204 | reg_programs.program_value where reg_program_column.state_code_equiv='MHSAELA' | MD_HSDC_DOWN.MHSA_Graduation_Requirement_ELA | Registration, Entry & Reports, Student Demographic, Programs, GRDRQ - MHSA Graduation Requirement: ELA |
38 | MCA Graduation Requirement - Science | 2 | 205 | 206 | reg_programs.program_value where reg_program_column.state_code_equiv='MHSASCI' | MD_HSDC_DOWN.MHSA_Graduation_Requirement_Science | Registration, Entry & Reports, Student Demographic, Programs, GRDRQ - MHSA Graduation Requirement: Science |
39 | MCA Graduation Requirement - Government | 2 | 207 | 208 | reg_programs.program_value where reg_program_column.state_code_equiv='MHSAGOVT' | MD_HSDC_DOWN.MHSA_Graduation_Requirement_Govt | Registration, Entry & Reports, Student Demographic, Programs, GRDRQ - MHSA Graduation Requirement: Govt |
40 | Bridge Project Status - Math (Optional) | 1 | 209 | 209 | ltdb_stu_subtest.score where ltdb_subtest_score.state_code_equiv ='BPSMATH' | MD_HSDC_DOWN.Bridge_Project_Status_Math | |
41 | Bridge Project Status - ELA (Optional) | 1 | 210 | 210 | ltdb_stu_subtest.score where ltdb_subtest_score.state_code_equiv ='BPSELA' | MD_HSDC_DOWN.Bridge_Project_Status_ELA | |
42 | Bridge Project Status - Science (Optional) | 1 | 211 | 211 | ltdb_stu_subtest.score where ltdb_subtest_score.state_code_equiv ='BPSSci' | MD_HSDC_DOWN.Bridge_Project_Status_Science | |
43 | Bridge Project Status - Government (Optional) | 1 | 212 | 212 | ltdb_stu_subtest.score where ltdb_subtest_score.state_code_equiv ='BPSGov' | MD_HSDC_DOWN.Bridge_Project_Status_Government | |
44 | Met Local Graduation Requirements | 1 | 213 | 213 | If the Diploma type state code equiv is C60, the indicator will be Y | MD_HSDC_DOWN.Met_Local_Grad_Requirements | Registration, Entry & Reports, Student Demographic, Academic: Diploma Type |
45 | High School Program Completion Status | 2 | 214 | 215 | md_v_hssc_cip.HS_Completion | MD_HSDC_DOWN.HighSchool_Program_Completion | Registration, Entry & Reports, Student District Defined, Guidance Counselor Information: HS Completer |
46 | CTE Concentrator | 1 | 216 | 216 | schd_course_user where screen_number = 301 AND field_number IN (2,3,5,7,9) AND field_value = 'Y' | MD_HSDC_DOWN.CTE_Concentrator | |
47 | FILLER (CTE Completer populated by MSDE) | 1 | 217 | 217 | |||
48 | Career and Technical Education CIP Code | 6 | 218 | 223 | reg_user.field_value where screen_number=99 and field_number=18 | MD_HSDC_DOWN.CTE_CIP_Code | Registration, Entry & Reports, Student District Defined, Guidance Counselor Information: CIP Code |
49 | Technical Skills Assessment 1 (TSA) Result | 1 | 224 | 224 | reg_user.field_value where screen_number='11001' and field_number=3 | MD_HSDC_DOWN.Tech_Skills_Assessment_Result_1 | Registration, Entry & Reports, Student District Defined, MD CTE Assessments |
50 | Technical Skills Assessment 1 (TSA) Code | 6 | 225 | 230 | reg_user.field_value where screen_number='11001' and field_number=1 | MD_HSDC_DOWN.Tech_Skills_Assessment_Code_1 | Registration, Entry & Reports, Student District Defined, MD CTE Assessments |
51 | Technical Skills Assessment 2 (TSA) Result | 1 | 231 | 231 | reg_user.field_value where screen_number='11001' and field_number=3 | MD_HSDC_DOWN.Tech_Skills_Assessment_Result_2 | Registration, Entry & Reports, Student District Defined, MD CTE Assessments |
52 | Technical Skills Assessment 2 (TSA) Code | 6 | 232 | 237 | reg_user.field_value where screen_number='11001' and field_number=1 | MD_HSDC_DOWN.Tech_Skills_Assessment_Code_2 | Registration, Entry & Reports, Student District Defined, MD CTE Assessments |
53 | Technical Skills Assessment 3 (TSA) Result | 1 | 238 | 238 | reg_user.field_value where screen_number='11001' and field_number=3 | MD_HSDC_DOWN.Tech_Skills_Assessment_Result_3 | Registration, Entry & Reports, Student District Defined, MD CTE Assessments |
54 | Technical Skills Assessment 3 (TSA) Code | 6 | 239 | 244 | reg_user.field_value where screen_number='11001' and field_number=1 | MD_HSDC_DOWN.Tech_Skills_Assessment_Code_3 | Registration, Entry & Reports, Student District Defined, MD CTE Assessments |
55 | Technical Skills Assessment 4 (TSA) Result | 1 | 245 | 245 | reg_user.field_value where screen_number='11001' and field_number=3 | MD_HSDC_DOWN.Tech_Skills_Assessment_Result_4 | Registration, Entry & Reports, Student District Defined, MD CTE Assessments |
56 | Technical Skills Assessment 4 (TSA) Code | 6 | 246 | 251 | reg_user.field_value where screen_number='11001' and field_number=1 | MD_HSDC_DOWN.Tech_Skills_Assessment_Code_4 | Registration, Entry & Reports, Student District Defined, MD CTE Assessments |
57 | FILLER (Industry Certification populated by MSDE) | 1 | 252 | 252 | |||
58 | Rigorous HS Indicator - Foreign Language | 1 | 253 | 253 | Calculated Value [if the total earn credit is more than or equal to 2 (from mr_stu_hdr.earn_credit) for Lang state ID (mr_crsequ_det.state_id), the Indicator will be Y.] | MD_HSDC_DOWN.Rigorous_Indicator_Foreign | |
59 | Rigorous HS Indicator - Math | 1 | 254 | 254 | Calculated Value [if the total earn credit is more than or equal to 1 (from mr_stu_hdr.earn_credit) for MATH state ID (mr_crsequ_det.state_id), the Indicator will be Y.] | MD_HSDC_DOWN.Rigorous_Indicator_Math | |
60 | Rigorous HS Indicator - Science | 1 | 255 | 255 | Calculated Value [if the total earn credit is more than or equal to 4 (from mr_stu_hdr.earn_credit) for SCIENCE state ID (mr_crsequ_det.state_id), the Indicator will be Y.] | MD_HSDC_DOWN.Rigorous_Indicator_Science | |
61 | Rigorous HS Indicator - Approved Adv. Tech Ed. | 1 | 256 | 256 | Calculated Value [if the total earn credit is more than or equal to 2 (from mr_stu_hdr.earn_credit) for TECH state ID (mr_crsequ_det.state_id), the Indicator will be Y.] | MD_HSDC_DOWN.Rigorous_Indicator_AdvancedTechEd | |
62 | Rigorous HS Indicator - SAT | 1 | 257 | 257 | If the combined score of MATH and VERB at the test level (ltdb_stu_subtest.score where ltdb_subtest_score.state_code_equiv='SATMATH' and 'SATVERB') is greater than 1000, the indicator will be Y | MD_HSDC_DOWN.Rigorous_Indicator_SAT | |
63 | Rigorous HS Indicator - ACT | 1 | 258 | 258 | If the score of ACT at the test level (ltdb_stu_subtest.score where ltdb_subtest_score.state_code_equiv='SATACT') is greater than 20, the indicator will be Y | MD_HSDC_DOWN.Rigorous_Indicator_ACT | |
64 | Rigorous HS Indicator - GPA | 1 | 259 | 259 | If the Cumulative GPA (mr_stu_gpa.cum_gpa) value is greater than 3, the indicator will be Y | MD_HSDC_DOWN.Rigorous_Indicator_GPA | |
65 | Filler (Rigorous High School Program Indicators Met populated by MSDE) | 1 | 260 | 260 | |||
66 | Readiness for PS Success - AP | 1 | 261 | 261 | If no score available for AP at the test level (ltdb_stu_subtest.score where ltdb_subtest_score.state_code_equiv='PSRDYAP'), search if there is a program for AP (reg_programs.program_value where reg_program_column.state_code_equiv='PSRDYAP') | MD_HSDC_DOWN.Readiness_PS_Success_AP | Registration, Entry & Reports, Student Demographic, Programs, PSRDY - Readiness for PS Success |
67 | Readiness for PS Success - IB | 1 | 262 | 262 | If no score available for IB at the test level (ltdb_stu_subtest.score where ltdb_subtest_score.state_code_equiv='PSRDYIB'), search if there is a program for IB (reg_programs.program_value where reg_program_column.state_code_equiv='PSRDYIB') | MD_HSDC_DOWN.Readiness_PS_Success_IB | Registration, Entry & Reports, Student Demographic, Programs, PSRDY - Readiness for PS Success |
68 | Readiness for PS Success - SAT | 1 | 263 | 263 | If no score available for SAT at the test level (ltdb_stu_subtest.score where ltdb_subtest_score.state_code_equiv='SATMATH'), search if there is a program for SAT (reg_programs.program_value where reg_program_column.state_code_equiv='PSRDYSAT') | MD_HSDC_DOWN.Readiness_PS_Success_SAT | Registration, Entry & Reports, Student Demographic, Programs, PSRDY - Readiness for PS Success |
69 | Readiness for PS Success - ACT | 1 | 264 | 264 | If no score available for ACT at the test level (ltdb_stu_subtest.score where ltdb_subtest_score.state_code_equiv='SATACT'), search if there is a program for ACT (reg_programs.program_value where reg_program_column.state_code_equiv='PSRDYACT') | MD_HSDC_DOWN.Readiness_PS_Success_ACT | Registration, Entry & Reports, Student Demographic, Programs, PSRDY - Readiness for PS Success |
70 | Readiness for PS Success - ASVAB | 1 | 265 | 265 | reg_programs.program_value where reg_program_column.state_code_equiv='PSRDYASVAB' | MD_HSDC_DOWN.Readiness_PS_Success_ASVAB | Registration, Entry & Reports, Student Demographic, Programs, PSRDY - Readiness for PS Success |
71 | Readiness for PS Success - Seal of Biliteracy | 1 | 266 | 266 | reg_programs.program_value where reg_program_column.state_code_equiv='PSRDYSEAL' | MD_HSDC_DOWN.Readiness_PS_Success_Seal_Of_Biliteracy | Registration, Entry & Reports, Student Demographic, Programs, PSRDY - Readiness for PS Success |
72 | Readiness for PS Success - Apprenticeship | 1 | 267 | 267 | reg_programs.program_value where reg_program_column.state_code_equiv='PSRDYAPPRN' | MD_HSDC_DOWN.Readiness_PS_Success_Apprenticeship | Registration, Entry & Reports, Student Demographic, Programs, PSRDY - Readiness for PS Success |
73 | Filler (Readiness for Postsecondary Success Indicators Met populated by MSDE) | 2 | 268 | 269 | |||
74 | Dual Enrollment - Participated | 1 | 270 | 270 | reg_programs.program_value where reg_program_column.state_code_equiv='DUALPART' | MD_HSDC_DOWN.Dual_Enrollment_Participated | Registration, Entry & Reports, Student Demographic, Programs, DUAL - Dual Enrollment: Participated |
75 | Dual Enrollment - Earned Credit | 1 | 271 | 271 | reg_programs.program_value where reg_program_column.state_code_equiv='DUALEARN' | MD_HSDC_DOWN.Dual_Enrollment_Earned_Credit | Registration, Entry & Reports, Student Demographic, Programs, DUAL - Dual Enrollment: Earned Credit |
76 | Filler (Prior CCR elements removed) | 8 | 272 | 279 | |||
77 | New CCR Subject Assessment Status - Math | 2 | 280 | 281 | reg_user.field_value where screen_number = 11013 AND field_number = 9 | MD_HSDC_DOWN.CCR_Sub_Assessment_Status_MATH | Registration, Entry & Reports, Student District Defined, College and Career Readiness: CCR Sub Assess Status - Math |
78 | New CCR Subject Eligibility Status - Math | 2 | 282 | 283 | reg_user.field_value where screen_number = 11013 AND field_number = 10 | MD_HSDC_DOWN.CCR_Sub_Eligibility_Status_MATH | Registration, Entry & Reports, Student District Defined, College and Career Readiness: CCR Sub Elig Status - Math |
79 | New CCR Subject Assessment Status - English | 2 | 284 | 285 | reg_user.field_value where screen_number = 11013 AND field_number = 11 | MD_HSDC_DOWN.CCR_Sub_Assessment_Status_ENG | Registration, Entry & Reports, Student District Defined, College and Career Readiness: CCR Sub Assess Status - Eng |
80 | New CCR Subject Eligibility Status - English | 2 | 286 | 287 | reg_user.field_value where screen_number = 11013 AND field_number = 12 | MD_HSDC_DOWN.CCR_Sub_Eligibility_Status_ENG | Registration, Entry & Reports, Student District Defined, College and Career Readiness: CCR Sub Elig Status - Eng |
81 | Filler (CCR Status populated by MSDE) | 1 | 288 | 288 | |||
82 | New Ninth Grade Tracker | 2 | 289 | 290 | reg_user.field_value where screen_number = 11013 AND field_number = 13 | MD_HSDC_DOWN.Grade9_Tracker | Registration, Entry & Reports, Student District Defined, College and Career Readiness: 9th Grade Tracker |
83 | New Ninth grade - credits accumulated (Optional) | 5 | 291 | 295 | reg_user.field_value where screen_number = 11013 AND field_number = 14 | MD_HSDC_DOWN.Grade9_Credits | Registration, Entry & Reports, Student District Defined, College and Career Readiness: 9th Grade Credits Accumulated |
84 | New Ninth grade - semester core course failures (Optional) | 2 | 296 | 297 | reg_user.field_value where screen_number = 11013 AND field_number = 15 | MD_HSDC_DOWN.Grade9_Sem_Course_Failures | Registration, Entry & Reports, Student District Defined, College and Career Readiness: 9th Grade Sem Course Failures |
85 | Apprenticeship – Currently in program (Optional) | 2 | 298 | 299 | Will be Y-01 if the vector Apprenticeship in the student’s PSRDY program is currently active (that is, has no end date) and has a value of Y or O. | MD_HSDC_DOWN.Apprenticeship_Participation | Registration, Entry & Reports, Student Demographic, Programs, PSRDY - Readiness for PS Success, Based on Apprenticeship field value and status. |
86 | Apprenticeship – Hours accrued (Optional) | 3 | 300 | 302 | reg_programs.program_value where reg_program_column.state_code_equiv='PSRDYAPPHR' | MD_HSDC_DOWN.Apprenticeship_Hours | Registration, Entry & Reports, Student Demographic, Programs, PSRDY - Readiness for PS Success, Apprenticeship Hours. |
87 | Accountability Reporting School (populated by MSDE based on EOY Attendance) | 4 | 303 | 306 |