MD - September Attendance Report
Data Element | Field Name | Where in eSchoolPLUS | eSchoolplus Table.Column | Download Table.Column | Field Length | Start Position | End Position | Note |
1 | LEA Number | Administration, General Setup, District, District: State Code Equivalent | reg_district.state_code_equiv | MD_ATTENDANCE_DOWN.district | 2 | 1 | 2 | |
2 | School Number |
| If entry withdrawal building (reg_entry_with.building) is blank, then get the school number from reg_building.state_code_equiv | MD_ATTENDANCE_DOWN.Building | 4 | 3 | 6 | |
3 | State Assigned Student ID (SASID) | Registration, Entry & Reports, Student Demographic, Personal: State ID | reg_personal.State_report_id | MD_ATTENDANCE_DOWN.state_report_id | 10 | 7 | 16 | |
4 | Local Student ID Number |
| reg.student_id | MD_ATTENDANCE_DOWN.Student_ID | 10 | 17 | 26 | |
5 | Last Name | Registration, Entry & Reports, Student Demographic, Registration: Last Name | reg.Last_Name | MD_ATTENDANCE_DOWN.Last_Name | 25 | 27 | 51 | |
6 | First Name | Registration, Entry & Reports, Student Demographic, Registration: First Name | reg.First_Name | MD_ATTENDANCE_DOWN.First_Name | 15 | 52 | 66 | |
7 | Middle Name | Registration, Entry & Reports, Student Demographic, Registration: Middle Name | reg.Middle_Name | MD_ATTENDANCE_DOWN.Middle_Name | 15 | 67 | 81 | |
8 | Generation Code or Suffix | Registration, Entry & Reports, Student Demographic, Registration: Generation | reg.Generation | MD_ATTENDANCE_DOWN.Generation_Suffix | 3 | 82 | 84 | |
9 | Preferred Name (Optional) |
|
| MD_ATTENDANCE_DOWN.Preffered_Name | 15 | 85 | 99 | |
10 | Date of Birth | Registration, Entry & Reports, Student Demographic, Registration: Birth Date | reg.Birthdate | MD_ATTENDANCE_DOWN.Date_Birth | 8 | 100 | 107 | |
11 | Grade | Registration, Entry & Reports, Student Demographic, Entry/withdrawal: Grade | reg_entry_with.grade( its respective state code from reg_grade.state_code_equiv) | MD_ATTENDANCE_DOWN.Grade | 2 | 108 | 109 | |
12 | Gender | Registration, Entry & Reports, Student Demographic, Registration: Gender Identity | reg.gender_identity (regtb_gender_identity.state_code_equiv_02) | MD_ATTENDANCE_DOWN.Gender | 1 | 110 | 110 | |
13 | Hispanic/Latino Ethnicity | Registration, Entry & Reports, Student Demographic, Personal: Hispanic/Latino Ethnicity | reg_personal.Hispanic | MD_ATTENDANCE_DOWN.new_ethnicity | 1 | 111 | 111 | |
14 | American Indian/Alaskan Native | Registration, Entry & Reports, Student Demographic, Personal: Race | reg_personal.ethnic_code where ethnic_code = 1 (regtb_ethnicity.state_code_equiv) | MD_ATTENDANCE_DOWN.New_Race | 1 | 112 | 112 | |
15 | Asian | Registration, Entry & Reports, Student Demographic, Personal: Race | reg_personal.ethnic_code where ethnic_code = 2 (regtb_ethnicity.state_code_equiv) | MD_ATTENDANCE_DOWN.New_Race | 1 | 113 | 113 | |
16 | Black or African American | Registration, Entry & Reports, Student Demographic, Personal: Race | reg_personal.ethnic_code where ethnic_code = 3 (regtb_ethnicity.state_code_equiv) | MD_ATTENDANCE_DOWN.New_Race | 1 | 114 | 114 | |
17 | Native Hawaiian or Other Pacific Islander | Registration, Entry & Reports, Student Demographic, Personal: Race | reg_personal.ethnic_code where ethnic_code = 4 (regtb_ethnicity.state_code_equiv) | MD_ATTENDANCE_DOWN.New_Race | 1 | 115 | 115 | |
18 | White | Registration, Entry & Reports, Student Demographic, Personal: Race | reg_personal.ethnic_code where ethnic_code = 5 (regtb_ethnicity.state_code_equiv) | MD_ATTENDANCE_DOWN.New_Race | 1 | 116 | 116 | |
19 | Homelessness Status | Registration, Entry & Reports, Student Demographic, Programs: HomeLess | If there is a value reg_programs.program_value where reg_program_column.state_code_equiv=MDHOMELESS, then Y Else N | MD_ATTENDANCE_DOWN.homeless | 1 | 117 | 117 | |
20 | Title I Indicator | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Title I | reg_programs.program_value where reg_program_column.state_code_equiv=MDTitle1 | MD_ATTENDANCE_DOWN.title_1 | 1 | 118 | 118 | |
21 | Free/Reduced Price Meal Eligibility | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Meal Status | reg_programs.program_value where reg_program_column.state_code_equiv=MDFARMS | MD_ATTENDANCE_DOWN.free_reduced_lunch | 1 | 119 | 119 | |
22 | Migrant Status | Registration, Entry & Reports, Student Demographic, Personal: Migrant | reg_personal.migrant | MD_ATTENDANCE_DOWN.Migrant | 1 | 120 | 120 | |
23 | Foreign Exchange Student Indicator | Registration, Entry & Reports, Student Demographic, Personal: Foreign Exchange Student | reg_programs.program_value where reg_program_column.state_code_equiv=MDFOREXCH | MD_ATTENDANCE_DOWN.foreign_exchange_student | 1 | 121 | 121 | |
24 | Special Education (SE) Indicator | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Special Education Indicator | reg_programs.program_value where reg_program_column.state_code_equiv=MDSpecED | MD_ATTENDANCE_DOWN.special_education | 1 | 122 | 122 | |
25 | Special Education End Date | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Special Education Indicator | reg_programs.end_date where reg_program_column.state_code_equiv=MDSpecED | MD_ATTENDANCE_DOWN.special_ed_end_date | 8 | 123 | 130 | |
26 | Special Education Certificate Status | Registration, Entry & Reports, Student Demographic, Academic: Diploma Type | reg_academic.diploma_type (its respective state code equiv from regtb_diplomas table) if C62, then Y Else N | MD_ATTENDANCE_DOWN.special_ed_certificate | 1 | 131 | 131 | |
27 | Multilingual Learner (ML) Status | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Multilingual Learner | reg_programs.program_value where reg_program_column.state_code_equiv=MDLEP | MD_ATTENDANCE_DOWN.ELL | 1 | 132 | 132 | |
28 | Multilingual Learner Entry into the US | Registration, Entry & Reports, Student Demographic, Registration: US Enrollment Date | reg.US_Enroll_Date | MD_ATTENDANCE_DOWN.el_us_entry | 8 | 133 | 140 | |
29 | Multilingual Learner Service Begin Date | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Multilingual Learner | If the ELL status is E or Y then reg_programs.start_date where reg_program_column.state_code_equiv=MDLEP | MD_ATTENDANCE_DOWN.ell_begin_date | 8 | 141 | 148 | |
30 | Multilingual Learner Service End Date | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Multilingual Learner | If the ELL status is E then reg_programs.end_date where reg_program_column.state_code_equiv=MDLEP | MD_ATTENDANCE_DOWN.ell_end_date | 8 | 149 | 156 | |
31 | Multilingual Learner ELA Assessment Exempt Status | Registration, Entry & Reports, Student District Defined, Accommodations Multilingual Learner: MLA Assessment Exempt Status | reg_user.field_value where screen_number = 11012 and field_number = 100 | MD_ATTENDANCE_DOWN.ela_assessment_exempt | 1 | 157 | 157 | |
32 | Foster Care Status |
| Defaulted to N | MD_ATTENDANCE_DOWN.foster_care | 1 | 158 | 158 | |
33 | Military Connected Indicator | Registration, Entry & Reports, Student District Defined, MD Student Record: Active Duty Military Parent | reg_user.field_value where screen_number = 11002 and field_number = 4 | MD_ATTENDANCE_DOWN.military_connected | 1 | 159 | 159 | |
34 | Gifted and Talented Student Indicator | Registration, Entry & Reports, Student District Defined, MD Student Record: Gifted/Talented | reg_user.field_value where screen_number = 11002 and field_number = 5 | MD_ATTENDANCE_DOWN.gifted | 1 | 160 | 160 | |
35 | Filler |
|
|
| 32 | 161 | 192 | |
36 | Submission Date | Current Date | Current date when you run the report | MD_ATTENDANCE_DOWN.Submission_Date | 8 | 193 | 200 | |
37 | Entry Status | Registration, Entry & Reports, Student Demographic, Entry/Withdrawal: Entry Code | reg_entry_with.Entry_code | MD_ATTENDANCE_DOWN.entry_status | 1 | 201 | 201 | |
38 | Entry Code | Registration, Entry & Reports, Student Demographic, Entry/Withdrawal: Entry Code | reg_entry_with.entry_code | MD_ATTENDANCE_DOWN.entry_code | 2 | 202 | 203 | |
39 | Entry Date | Registration, Entry & Reports, Student Demographic, Entry/Withdrawal: Entry Date | reg_entry_with.entry_date | MD_ATTENDANCE_DOWN.entry_date | 8 | 204 | 211 | |
40 | Days Attending | Calculated Value | Total membership days - absent days | MD_ATTENDANCE_DOWN.days_attending | 4 | 212 | 215 | |
41 | Days Absent | Calculated Value | Absent days based on the absence codes | MD_ATTENDANCE_DOWN.days_absent | 4 | 216 | 219 | |
42 | Filler | 4 | 220 | 223 | ||||
43 | Filler | 4 | 224 | 227 | ||||
44 | Exit Status | Registration, Entry & Reports, Student Demographic, Entry/Withdrawal: withdrawal Code | reg_entry_with.withdrawal_code (its respective state code equivalent from regtb_withdrawal) the first digit of the withdrawal code | MD_ATTENDANCE_DOWN.withdrawal_status | 1 | 228 | 228 | |
45 | Exit Code | Registration, Entry & Reports, Student Demographic, Entry/Withdrawal: withdrawal Code | reg_entry_with.withdrawal_code (its respective state code equivalent from regtb_withdrawal) the last 2 digits of the withdrawal code | MD_ATTENDANCE_DOWN.withdrawal_code | 2 | 229 | 230 | |
46 | Exit Date | Registration, Entry & Reports, Student Demographic, Entry/Withdrawal: withdrawal Date | reg_entry_with.withdrawal_date | MD_ATTENDANCE_DOWN.withdrawal_date | 8 | 231 | 238 | |
47 | Pre-K Full-Time Status | Refer Next Column | For PreK grades - blank Y – PreK who attends school for a full day N – Prek student who attends school for less than a full day | MD_ATTENDANCE_DOWN.prek_full_status | 1 | 239 | 239 | |
48 | State-Aid Eligibility | Registration, Entry & Reports, Student Demographic, Programs, State AID: State Aid Eligibility | reg_programs.program_value where reg_program_column.state_code_equiv=MDSTATEAID | MD_ATTENDANCE_DOWN.state_aid_elig | 2 | 240 | 241 | |
49 | Evening High Student | Registration, Entry & Reports, Student Demographic, Programs >Evening High School: Evening High School | reg_programs.program_value where reg_program_column.state_code_equiv=MDEVENING | MD_ATTENDANCE_DOWN.eh_student | 1 | 242 | 242 | |
50 | Evening High Number of Courses | Number of courses count for the student in schd_stu_course | MD_ATTENDANCE_DOWN.eh_num_courses | 1 | 243 | 243 | ||
51 | Part-Time Student | If grades from 9 to 12, then Y Else N | MD_ATTENDANCE_DOWN.pt_student | 1 | 244 | 244 | ||
52 | Part-Time Number of Courses | Number of courses count for the student in schd_stu_course | MD_ATTENDANCE_DOWN.pt_num_courses | 1 | 245 | 245 | ||
53 | Opt-Out | Registration, Entry & Reports, Student Demographic, Personal: FERPA Flags | reg_personal.ferpa_name | MD_ATTENDANCE_DOWN.opt_out | 1 | 246 | 246 | |
54 | Number of College Courses | reg_user.field_value where MDTB_DEFINED_FIELDS .code=MDCOLLCRS | MD_ATTENDANCE_DOWN.num_college_crs | 1 | 247 | 247 | ||
55 | Dual Enrollment | Defaulted to N | Defaulted to N | 1 | 248 | 248 | ||
56 | Direct Certification | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Meal Status | reg_programs.program_value where reg_program_column.state_code_equiv=MDFARMS | MD_ATTENDANCE_DOWN.direct_certification | 1 | 249 | 249 | The |
57 | Pre-K Tier Status | Registration, Entry & Reports, Student District Defined, MD Student Record: Pre-K Tier Status | reg_user.field_value where screen_number = 11002 and field_number = 6 | MD_ATTENDANCE_DOWN.PRE_K_TIER_STATUS | 1 | 250 | 250 | |
58 | Federal Poverty Level | Registration, Entry & Reports, Student District Defined, MD Student Record: Federal Poverty Level | reg_user.field_value where screen_number = 11002 and field_number = 7 | MD_ATTENDANCE_DOWN.FED_POVERTY_LEVEL | 3 | 251 | 253 | |
59 | Geo Location ID | Registration, Entry & Reports, District Defined Screen, MD Student Record: Geolocation ID | reg_user.field_value where screen_number = 11002 and field_number = 8 | MD_ATTENDANCE_DOWN.GEO_LOCATION_ID | 15 | 254 | 268 |