Attendance Detail

Student ID

The student's code or ID number for the SIS system. This is padded with proceeding zeros to seven positions (e.g., 82901 becomes 0082901).

Age

The student's age in years - computed from Birthdate. This is the current age of an Active student, and the age at withdrawal date if Inactive.

Status

A high-level status grouping: Active, Pre-Enrolled, Expelled, Transferred-Out, Graduated, etc.

Ethnicity

The student's primary racial background: American Indian/Alaska Native, Asian/Pacific Islander, Black, Hispanic, Unknown/Unspecified, White.

Current School

School name where the student is currently enrolled - Beechcroft High School, Welcome Center at North, Prof. Inst. Walnut Ridge Hs, etc.  Use in reports & analyses only as a student attribute - enrollment fact data should be used for student profiles.

Grade

The student's grade level.

Current Cumulative GPA

The student's cumulative GPA calculated and frozen from the previous school year.  This is the unweighted GPA.

Mobility

The number of times a student has changed schools during the past 365 days (past 12 months).

ELL

Indicates whether the student is currently active in an English as a Second Language program (Yes or No)?  If the student is withdrawn and was participating in ESL at the time of withdrawing then they will be set to Yes.

Language

The student's primary language:  English, Spanish, Hmong, Urdu, etc.  The default of null to English is in synch with most State Reporting.

SPED

Indicates (Yes/No) whether the student is currently receiving special education services (either in regular classroom or special ed unit).

Month

Year

The school year for the related school. 1999-2000, 2000-2001, 2001-2002, etc. Note that dates outside the defined school year are set to School Year of 0.

% Attendance

Total number of days attended divided by the total possible days of attendance.

Year

The school year for the related school. 1999-2000, 2000-2001, 2001-2002, etc. Note that dates outside the defined school year are set to School Year of 0.

# Period Absent

Day

Year

The school year for the related school. 1999-2000, 2000-2001, 2001-2002, etc. Note that dates outside the defined school year are set to School Year of 0.

# Days

Year

The school year for the related school. 1999-2000, 2000-2001, 2001-2002, etc. Note that dates outside the defined school year are set to School Year of 0.

Course Name

The full name for the course - this is the primary course name to be used in most reports, analyses, and filters.  In state/multi-district deployments this is often conformed to the State or NCES Course Description.

Date

The date of the record.

Absence Reason

The primary reason for the absence. If a class spans 2 or 3 periods it will typically have 2 or 3 absence entries (one for each period) and the reason could potentially vary.  Typical values include Unexcused, Medical, Athletic, NA (Not Applicable), etc. Reasons can (and often do) vary by School.

Attendance Type

The type of attendance data for that period.  As this is an absence (or negative attendance) table the types are: Absence, Late (Tardy), or Unknown.

Date

The date of the record.

School

The full name of the school.

Type

Code to indicate the type of attendance day for this student on this date:  FD = Full Day Absence, AM = AM Only Absence, PM = PM Absence Only, LF = Late AM & PM, LA = Late AM Only, LP = Late PM Only and PR = Present   Note:  If ABSENT_CODE and ABSENT_CODE are both Null then the student will not be considered absent (even though their is an elem_attendances record) and the attendance_type will be set to PR.

Authorized

Flag to indicate whether the absence or late/tardy authorized?  If an absence was authorized (in-school suspension, school function, etc.) then it is not countable for reporting but still considered a classroom absence.   Yes, No or NA (if the student was present)

Absence Reason

The primary reason for the absence.  The primary reason is the one assigned if both morning & afternoon absence reasons matched, or if only a single reason was assigned for the morning or afternoon, or the morning reason if morning & afternoon reasons differ.  If a class spans 2 or 3 periods it will typically have 2 or 3 absence entries (one for each period) and the reason could potentially vary and the primary reason would be the most cited one.  Typical values include Unexcused, Medical, Athletic, NA (Not Applicable), etc.  Reasons can (and often do) vary by School.