Attendance Detail
Student Narrative
Type | Column Label / Definition |
---|---|
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 | SPED Indicates (Yes/No) whether the student is currently receiving special education services (either in regular classroom or special ed unit). |
Attendance Trends by Month
Type | Column Label / Definition |
---|---|
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. |
Period Attendance
Type | Column Label / Definition |
---|---|
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 |
Day of Week Absences
Type | Column Label / Definition |
---|---|
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 |
Period Absence History
Type | Column Label / Definition |
---|---|
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. |
Daily Absence History
Type | Column Label / Definition |
---|---|
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. |