Skip to main content
Skip table of contents

MD - Attendance Reports

Data Element

Field Name

Field Length

Start Position

End Position

eSchoolplus Table.Column

Download Table.Column

Where in eSchoolPLUS

Early Attendance Report

End of Year Report

September Attendance Report

1

LEA Number 

2

1

2

reg_district.state_code_equiv

MD_ATTENDANCE_DOWN.district

Administration, General Setup, District, District: State Equivalency Code

Y

Y

Y

2

School Number 

4

3

6

If entry withdrawal building (reg_entry_with.building) is blank, gets the school number from reg_building.state_code_equiv

MD_ATTENDANCE_DOWN.Building

 

y

y

y

3

State Assigned Student ID (SASID) 

10

7

16

reg_personal.State_report_id

MD_ATTENDANCE_DOWN.state_report_id

Registration, Entry & Reports, Student Demographic, Personal: State ID

Y

Y

Y

4

Local Student ID Number 

10

17

26

reg.student_id

MD_ATTENDANCE_DOWN.Student_ID

 

Y

Y

Y

5

Last Name 

25

27

51

reg.Last_Name

MD_ATTENDANCE_DOWN.Last_Name

Registration, Entry & Reports, Student Demographic, Registration: Last Name

Y

Y

Y

6

First Name 

15

52

66

reg.First_Name

MD_ATTENDANCE_DOWN.First_Name

Registration, Entry & Reports, Student Demographic, Registration: First Name

Y

Y

Y

7

Middle Name 

15

67

81

reg.Middle_Name

MD_ATTENDANCE_DOWN.Middle_Name

Registration, Entry & Reports, Student Demographic, Registration: Middle Name

Y

Y

Y

8

Generation Code or Suffix 

3

82

84

reg.Generation

MD_ATTENDANCE_DOWN.Generation_Suffix

Registration, Entry & Reports, Student Demographic, Registration: Generation

Y

Y

Y

9

Preferred Name (Optional) 

15

85

99

 

 MD_ATTENDANCE_DOWN.Preffered_Name

 

Y

Y

Y

10

Date of Birth 

8

100

107

reg.Birthdate

MD_ATTENDANCE_DOWN.Date_Birth

Registration, Entry & Reports, Student Demographic, Registration: Birth Date

Y

Y

Y

11

Grade 

2

108

109

reg_entry_with.grade (respective state code from reg_grade.state_code_equiv)

MD_ATTENDANCE_DOWN.Grade

Registration, Entry & Reports, Student Demographic, Entry/withdrawal: Grade

Y

Y

Y

12

Gender 

1

110

110

reg.gender_identity (regtb_gender_identity.state_code_equiv_02)

MD_ATTENDANCE_DOWN.Gender

Registration, Entry & Reports, Student Demographic, Registration: Gender Identity

Y

Y

Y

13

Hispanic/Latino Ethnicity 

1

111

111

reg_personal.Hispanic

MD_ATTENDANCE_DOWN.new_ethnicity

Registration, Entry & Reports, Student Demographic, Personal: Hispanic/Latino Ethnicity

Y

Y

Y

14

American Indian/Alaskan Native 

1

112

112

reg_personal.ethnic_code where ethnic_code = 1 (regtb_ethnicity.state_code_equiv)

MD_ATTENDANCE_DOWN.New_Race

Registration, Entry & Reports, Student Demographic, Personal: Race

Y

Y

Y

15

Asian 

1

113

113

reg_personal.ethnic_code where ethnic_code = 2 (regtb_ethnicity.state_code_equiv)

MD_ATTENDANCE_DOWN.New_Race

Registration, Entry & Reports, Student Demographic, Personal: Race

Y

Y

Y

16

Black or African American 

1

114

114

reg_personal.ethnic_code where ethnic_code = 3 (regtb_ethnicity.state_code_equiv)

MD_ATTENDANCE_DOWN.New_Race

Registration, Entry & Reports, Student Demographic, Personal: Race

Y

Y

Y

17

Native Hawaiian or Other Pacific Islander 

1

115

115

reg_personal.ethnic_code where ethnic_code = 4 (regtb_ethnicity.state_code_equiv)

MD_ATTENDANCE_DOWN.New_Race

Registration, Entry & Reports, Student Demographic, Personal: Race

Y

Y

Y

18

White 

1

116

116

reg_personal.ethnic_code where ethnic_code = 5 (regtb_ethnicity.state_code_equiv)

MD_ATTENDANCE_DOWN.New_Race

Registration, Entry & Reports, Student Demographic, Personal: Race

Y

Y

Y

19

Homelessness Status

1

117

117

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

Registration, Entry & Reports, Student Demographic, Programs: HomeLess

Y

Y

Y

20

Title I Indicator 

1

118

118

reg_programs.program_value where reg_program_column.state_code_equiv='MDTitle1'

MD_ATTENDANCE_DOWN.title_1

Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Title I

Y

Y

Y

21

Free/Reduced Price Meal Eligibility 

1

119

119

reg_programs.program_value where reg_program_column.state_code_equiv='MDFARMS'

MD_ATTENDANCE_DOWN.free_reduced_lunch

Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Meal Status

Y

Y

Y

22

Migrant Status 

1

120

120

reg_personal.migrant

MD_ATTENDANCE_DOWN.Migrant

Registration, Entry & Reports, Student Demographic, Personal: Migrant

Y

Y

Y

23

Foreign Exchange Student Indicator 

1

121

121

reg_programs.program_value where reg_program_column.state_code_equiv='MDFOREXCH'

MD_ATTENDANCE_DOWN.foreign_exchange_student

Registration, Entry & Reports, Student Demographic, Personal: Foreign Exchange Student

Y

Y

Y

24

Special Education (SE) Indicator

1

122

122

reg_programs.program_value where reg_program_column.state_code_equiv='MDSpecED'

MD_ATTENDANCE_DOWN.special_education

Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Special Education Indicator

Y

Y

Y

25

Special Education End Date

8

123

130

reg_programs.end_date where reg_program_column.state_code_equiv='MDSpecED'

MD_ATTENDANCE_DOWN.special_ed_end_date

Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Special Education Indicator

Y

Y

Y

26

Special Education Certificate Status 

1

131

131

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

Registration, Entry & Reports, Student Demographic, Academic: Diploma Type

y

Y

Y

27

English Learner (EL) Status 

1

132

132

reg_programs.program_value where reg_program_column.state_code_equiv='MDLEP'

MD_ATTENDANCE_DOWN.ELL

Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: English Language Learner

Y

Y

Y

28

English Learner Entry into the US

8

133

140

Reg.US_Enroll_Date

MD_ATTENDANCE_DOWN.el_us_entry

Registration, Entry & Reports, Student Demographic, Registration: US Enrollment Date

Y

Y

Y

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_ATTENDANCE_DOWN.ell_begin_date

Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: English Language Learner

Y

Y

Y

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_ATTENDANCE_DOWN.ell_end_date

Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: English Language Learner

 Y

Y

Y

31

English Learner ELA Assessment Exempt Status

1

157

157

reg_user.field_value where screen_number = 11012 AND field_number = 100

MD_ATTENDANCE_DOWN.ela_assessment_exempt

Registration, Entry & Reports, Student District Defined, Accommodations English Learners (EL): ELA Assessment Exempt Status

 Y

Y

Y

32

Foster Care Status

1

158

158

Defaulted to N

MD_ATTENDANCE_DOWN.foster_care

 

 Y

y

Y

33

Military Connected Indicator

1

159

159

reg_user.field_value where screen_number = 11002 AND field_number = 4

MD_ATTENDANCE_DOWN.military_connected

Registration, Entry & Reports, Student District Defined, MD Student Record: Active Duty Military Parent

 Y

Y

Y

34

Gifted and Talented Student Indicator

1

160

160

reg_user.field_value where screen_number = 11002 AND field_number = 5

MD_ATTENDANCE_DOWN.gifted

Registration, Entry & Reports, Student District Defined, MD Student Record: Gifted/Talented

Y

Y

Y

35

Filler

32

161

192

 

 

 

 Y

Y

Y

36

Submission Date 

8

193

200

Current date when you run the report

MD_ATTENDANCE_DOWN.Submission_Date

 

Y

Y

Y

37

Entry Status 

1

201

201

reg_entry_with.Entry_code

if summer_withdrawal is Y, the first digit of the entry code

MD_ATTENDANCE_DOWN.entry_status

Registration, Entry & Reports, Student Demographic, Entry/Withdrawal: Entry Code

Y

Y

Y

38

Entry Code

2

202

203

reg_entry_with.entry_code

if summer_withdrawal is Y, the last 2 digits of the entry code

MD_ATTENDANCE_DOWN.entry_code

 Registration, Entry & Reports, Student Demographic, Entry/Withdrawal: Entry Code

Y

Y

Y

39

Entry Date

8

204

211

reg_entry_with.entry_date

MD_ATTENDANCE_DOWN.entry_date

Registration, Entry & Reports, Student Demographic, Entry/Withdrawal: Entry Date

Y

Y

Y

40

Days Attending

4

212

215

Total membership days - absent days

MD_ATTENDANCE_DOWN.days_attending

Y

Y

Y

41

Days Absent

4

216

219

Absent days based on the absence codes

MD_ATTENDANCE_DOWN.days_absent

Y

Y

Y

42

Days Not Belonging

4

220

223

For states with withdrawal rule is First Day Student Not in School, this will be 0 (withdrawal date not a membership day)

For states with withdrawal date is last day of school for student, this will be 1

Sum of the not belonging days

MD_ATTENDANCE_DOWN.days_not_belonging

Y

Y

N

43

Unlawful Days Absent

4

224

227

Absent days based on the Unlawful Absence Codes

MD_ATTENDANCE_DOWN.unlawful_days_absent

N

Y

N

42

Filler

4

220

223

N

N

Y

43

Filler

4

224

227

Y

N

Y

44

Exit Status

1

228

228

reg_entry_with.withdrawal_code (its respective state code equiv from regtb_withdrawal)

first digit of withdrawal code

MD_ATTENDANCE_DOWN.withdrawal_status

Registration, Entry & Reports, Student Demographic, Entry/Withdrawal: withdrawal Code

Y

Y

Y

45

Exit Code

2

229

230

reg_entry_with.withdrawal_code (its respective state code equiv from regtb_withdrawal)

last two digits of withdrawal code

MD_ATTENDANCE_DOWN.withdrawal_code

Registration, Entry & Reports, Student Demographic, Entry/Withdrawal: withdrawal Code

Y

Y

Y

46

Exit Date

8

231

238

reg_entry_with.withdrawal_date

MD_ATTENDANCE_DOWN.withdrawal_date

Registration, Entry & Reports, Student Demographic, Entry/Withdrawal: withdrawal Date

Y

Y

y

49

Accountability School

4

239

242

reg_building.state_code_equiv where reg.alt_bldg_acct = reg_building.building

MD_ATTENDANCE_DOWN.Accountability_School

Administration, Registration Setup, Building, State code equiv

Y

Y

N

50

Direct Certification

1

243

243

reg_programs.program_value where reg_program_column.state_code_equiv='MDFARMS'

MD_ATTENDANCE_DOWN.direct_certification

 Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind: Meal Status

Y

Y

Y

51

Promotion Code

2

239

240

reg_academic.promotion

MD_ATTENDANCE_DOWN.promotion_code

Registration, Entry & Reports, Student Demographic, Academic: Promotion

N

Y

N

52

TAS

1

241

241

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 with the withdrawal date

MD_ATTENDANCE_DOWN.tas

Registration, Entry & Reports, Student Demographic, Programs, Title 1

N

Y

N

53

Homeless Primary Nighttime Residence

1

242

242

reg_programs.program_value where reg_program_column.state_code_equiv='MDPRIMRESI'

MD_ATTENDANCE_DOWN.homeless_primary_nighttime_residence

Registration, Entry & Reports, Student Demographic, Programs, Home: Homeless Night Time Residence

N

Y

N

54

Homeless Served - McKinney

1

243

243

reg_programs.program_value where reg_program_column.state_code_equiv='MDSERVMCKN'

MD_ATTENDANCE_DOWN.homeless_served_mckinney

Registration, Entry & Reports, Student Demographic, Programs, Home: Homeless Served-McKinney

N

Y

N

55

Homeless Served - Other

1

244

244

reg_programs.program_value where reg_program_column.state_code_equiv='MDSERVOTH'

MD_ATTENDANCE_DOWN.homeless_served_other

Registration, Entry & Reports, Student Demographic, Programs, Home: Homeless Served-Other

N

Y

N

56

Homeless Unaccompanied Youth Status

1

245

245

reg_programs.program_value where reg_program_column.state_code_equiv='MDUNACCOM'

MD_ATTENDANCE_DOWN.homeless_unaccompanied_youth_status

Registration, Entry & Reports, Student Demographic, Programs, Home: Homeless-Unaccompanied

N

Y

N

57

Immigrant

1

246

246

reg_programs.program_value where reg_program_column.state_code_equiv='MDIMMIG'

MD_ATTENDANCE_DOWN.immigrant

Registration, Entry & Reports, Student Demographic, Programs, NCLB - No Child Left Behind:

N

Y

N

58

Pre-K Full-Time Status

1

239

239

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

N

N

Y

59

State-Aid Eligibility

2

240

241

reg_programs.program_value where reg_program_column.state_code_equiv='MDSTATEAID'

MD_ATTENDANCE_DOWN.state_aid_elig

Registration, Entry & Reports, Student Demographic, Programs, State AID: State Aid Eligibility

N

N

Y

60

Evening High Student

1

242

242

reg_programs.program_value where reg_program_column.state_code_equiv='MDEVENING'

MD_ATTENDANCE_DOWN.eh_student

Registration, Entry & Reports, Student Demographic, Programs >Evening High School: Evening High School

N

N

Y

61

Evening High Number of Courses

1

243

243

number of courses count for the student in schd_stu_course

MD_ATTENDANCE_DOWN.eh_num_courses

N

N

Y

62

Part-Time Student

1

244

244

If grades from 9 to 12, then Y else N

MD_ATTENDANCE_DOWN.pt_student

N

N

Y

63

Part-Time Number of Courses

1

245

245

Nnumber of courses count for the student in schd_stu_course

MD_ATTENDANCE_DOWN.pt_num_courses

N

N

Y

64

Opt-Out

1

246

246

reg_personal.ferpa_name

MD_ATTENDANCE_DOWN.opt_out

Registration, Entry & Reports, Student Demographic, Personal: FERPA Flags

N

N

Y

65

Number of College Courses

1

247

247

reg_user.field_value where MDTB_DEFINED_FIELDS .code='MDCOLLCRS'

MD_ATTENDANCE_DOWN.num_college_crs

N

N

Y

66

Dual Enrollment

1

248

248

Defaulted to N

N

N

Y

67

Pre-K Tier Status

1

250

250

reg_user.field_value where screen_number = 11002 AND field_number = 6

MD_ATTENDANCE_DOWN.PRE_K_TIER_STATUS

Registration, Entry & Reports, Student District Defined, MD Student Record: Pre-K Tier Status

N

N

Y

68

Federal Poverty Level

3

251

253

reg_user.field_value where screen_number = 11002 AND field_number = 7

MD_ATTENDANCE_DOWN.FED_POVERTY_LEVEL

Registration, Entry & Reports, Student District Defined, MD Student Record: Federal Poverty Level

N

N

Y

JavaScript errors detected

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

If this problem persists, please contact our support.