MD - End-of-Year (EoY) 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 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 | Total membership days - absent days | MD_ATTENDANCE_DOWN.days_attending | 4 | 212 | 215 | ||
41 | Days Absent | Absent days based on the absence codes | MD_ATTENDANCE_DOWN.days_absent | 4 | 216 | 219 | ||
42 | Days Not Belonging | For states with a withdrawal rule is First Day Student Not in School, this will be 0 (withdrawal date not a membership day) Sum of the not belonging days | MD_ATTENDANCE_DOWN.days_not_belonging | 4 | 220 | 223 | ||
43 | Unlawful Days Absent | Absent days based on theUnlawful Absence Codes | MD_ATTENDANCE_DOWN.unlawful_days_absent | 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 | Promotion Code | Registration, Entry & Reports, Student Demographic, Academic: Promotion | reg_academic.promotion | MD_ATTENDANCE_DOWN.promotion_code | 2 | 239 | 240 | |
48 | TAS | Registration, Entry & Reports, Student Demographic, Programs, Title 1 | reg_programs.program_value where reg_program_column.state_code_equiv=MDTAS if withdrawal_date, 7/21/current year, then taking 7/21/current year else taking the withdrawal date from the Entry/Withdrawal page Based on the program start and end dates it will pick the title1 before or after or summer value by comparing it with the withdrawal date | MD_ATTENDANCE_DOWN.tas | 1 | 241 | 241 | |
49 | Homeless Primary Nighttime Residence | Registration, Entry & Reports, Student Demographic, Programs, Home: Homeless Night Time Residence | reg_programs.program_value where reg_program_column.state_code_equiv=MDPRIMRESI | MD_ATTENDANCE_DOWN.homeless_primary_nighttime_residence | 1 | 242 | 242 | |
50 | Homeless Served- McKinney | Registration, Entry & Reports, Student Demographic, Programs, Home: Homeless Served-McKinney | reg_programs.program_value where reg_program_column.state_code_equiv=MDSERVMCKN | MD_ATTENDANCE_DOWN.homeless_served_mckinney | 1 | 243 | 243 | |
51 | Homeless Served- Other | Registration, Entry & Reports, Student Demographic, Programs, Home: Homeless Served-Other | reg_programs.program_value where reg_program_column.state_code_equiv=MDSERVOTH | MD_ATTENDANCE_DOWN.homeless_served_other | 1 | 244 | 244 | |
52 | Homeless Unaccompanied Youth Status | Registration, Entry & Reports, Student Demographic, Programs, Home: Homeless-Unaccompanied | reg_programs.program_value where reg_program_column.state_code_equiv=MDUNACCOM | MD_ATTENDANCE_DOWN.homeless_unaccompanied_youth_status | 1 | 245 | 245 | |
53 | Immigrant | Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: | reg_programs.program_value where reg_program_column.state_code_equiv=MDIMMIG | MD_ATTENDANCE_DOWN.immigrant | 1 | 246 | 246 | |
54 | 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 | 247 | 247 | The |
45 | Accountability School | Administration, Registration Setup, Building, State code equiv | reg_building.state_code_equiv where reg.alt_bldg_acct = reg_building.building | MD_ATTENDANCE_DOWN.Accountability_School | 4 | 248 | 251 | |
56 | 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 | 252 | 266 |