ADM Attendance File Layout
Data Element Name | Field Length | Req'd | Zero Padded | Field position | eSchoolPlus Table.Column | Download Table.Column | Where in eSchoolPlus? |
---|---|---|---|---|---|---|---|
Demographic Filler | 18 | N | N | 558 – 568 | . |
|
|
Enrolled Program Type Code | 2 | Y | Y | 569 - 570 | Determined based on the reg_calendar.state_code_equiv from the student's reg_entry_with.calendar, combined with student program enrollment. | or_att_down.pgm_type_code |
|
Enrolled Date | 8 | Y | Y | 571 - 578 | reg_entry_with.entry_date | or_att_down.enrolled_date |
|
Enrollment End Date | 8 | N | Y | 579 - 586 | reg_entry_with.withdrawal_date | or_att_down.exit_date |
|
Enrollment End Date Code | 2 | Y | Y | 587 - 588 | reg_entry_with.withdrawal code --> state code equiv. Default it to 1A for prog type code 01 and 00 for type codes 02 and 03. | or_att_down.ADMEndDtcd |
|
Diploma Issued Type Code | 1 | Y | Y | 589 – 589 | reg_academic.diploma_type | or_att_down.DiplomaTypCd |
|
Withdrawal Factor Code | 2 | Y | Y | 590 - 591 | reg_programs. | or_att_down.withdraw_facor |
|
Session Days | 3 | N | Y | 592 - 594 | Sum of attt_stu_day_memb. | or_att_down.session_days |
|
Days Present | 4 | N | Y | 595 – 598 | Calculated. Session Days minus Days Absent | or_att_down.days_present |
|
Days Absent | 4 | N | Y | 599 - 602 | Sum of att_stu_day_totals. Absent_time for selected View | or_att_down.days_absent |
|
Instructional Hours | 7 | N | Y | 603 - 609 | reg_programs. | or_att_down.hrs_of_instruction |
|
Full Time Equivalency | 2 | Y | Y | 610 – 611 | reg_calendar. | or_att_down.FTE |
|
Enrolled Tuition Type Code | 1 | Y | N | 612 - 612 | reg_programs. | or_att_down.tuition_type_code |
|