Attendance Detail

Dimension

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).

Dimension

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.

Dimension

Status

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

Dimension

Ethnicity

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

Dimension

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.

Dimension

Grade

The student's grade level.

Dimension

Current Cumulative GPA

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

Dimension

Mobility

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

Dimension

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.

Dimension

Language

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

Dimension

SE

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

Dimension

Month

Dimension

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.

Measure

% Attendance

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

Dimension

Attendance Period

Dimension

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.

Measure

# Period Absent

Dimension

Day

Dimension

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.

Measure

# Days

Dimension

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.

Dimension

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.

Dimension

Date

The date of the record.

Dimension

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.

Dimension

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.

Dimension

Date

The date of the record.

Dimension

School

The full name of the school.

Dimension

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.

Dimension

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)

Dimension

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.