Overview - Student Profile

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

Chronic Level

% Attendance

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

% Attendance

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

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

% Attendance

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

School Year

(METADATA) - The contemporaneous school year for this student annual attributes record. Formatted 1999-2000, 2002-2003, etc.

GPA

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.

# Offenses

The number of discipline incidences entered into the system.

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.

Test Subject

Writing, Reading, Mathematics, Citizenship, Science, ESL, Other.

Score

The primary test score for a given assessment. This value may be either a raw or scaled score dependent upon the type of test. Not applicable to cases where the test result is a waiver or similar result code.

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.

Term

The term number for the related school (1, 2, 3, etc.). Note that dates outside the defined term are set to Term of 0.

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.

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

Begin

The date value MM/DD/YYYY corresponding to the day in the calendar for this record.  Only exists in table to provide production keys to the build process.

School

The full name of the school.

Withdraw Reason

Description of why/how the student was withdrawn from the school.  For example, District School (meaning admitted to another school within the district), Moved, etc.

Begin Date

The date value MM/DD/YYYY corresponding to the day in the calendar for this record.  Only exists in table to provide production keys to the build process.

End Date

The date value MM/DD/YYYY corresponding to the day in the calendar for this record. Only exists in the table to provide production keys to the build process.

Membership Days

The number of school days in which the student was a member of this program based loosely upon the start and end dates defined in the student system.  The number is calculated using the school calendar for either the program school or the Administrative school if no school was assigned.  Weekends and holidays are excluded as are dates outside the school year ()summer).

Program Name

The descriptive names for the programs as defined in the student information system. Title I Reading, Alternative Lottery, ESL Pullout, etc.

Status

Indicates if the status of the student's program membership:  Pending if the start date is later than today; Expired is the end date is prior to today and Active if today is between the start and end date of the program assignment.  The status will be set to Deleted if that record is removed from the Student Information System.

Period

Skill

Curriculum Code

Student

Date

The date of the record.

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.

Average Measure Value

High, Moderate, and Low are the levels of risk calculated. Cut scores for high, moderate, and low risk can be found on the Cut Scores - Risk Analysis dashboard.

Risk Type

The prediction factor category.

Risk Level

High, Moderate, and Low are the levels of risk calculated. Cut scores for high, moderate, and low risk can be found on the Cut Scores - Risk Analysis dashboard.

Count

The number of individual data elements included.

Importance Variable

The name of the data element utilized in the prediction for the probability of on-time graduation.

Importance Variable

The name of the data element utilized in the prediction for the probability of on-time graduation.