Skip to main content
Skip table of contents

MD - Early 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 the 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
if summer_withdrawal is Y, then the first digit of the 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
if summer_withdrawal is Y, then the last 2 digits of the 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)
for states with the withdrawal date is the last day of school for students, this will be 1

Sum of the not belonging days

MD_ATTENDANCE_DOWN.days_not_belonging

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

Accountability School

Administration, Registration Setup, Building, State Code Equivalent

reg_building.state_code_equiv where reg.alt_bldg_acct = reg_building.building

MD_ATTENDANCE_DOWN.Accountability_School

4

239

242

48

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

243

243

The Direct Certification field value is calculated based on the presence and status of the Meal Status program. If the latest program record for the student has a STATE_CODE_EQUIV of D, direct_cert is set to Y. Otherwise, it is set to N.

49

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

244

258

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.