Skip to main content
Skip table of contents

Schedule

Student Narrative

TypeColumn 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

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

Student Detailed Schedule

TypeColumn Label / Definition
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

Department

The long name for the department.  Mathematics Education, English Education, Trade and Industrial Education, etc.

Dimension

Sec

(METADATA) - The section designation for the Course being offered (to distinguish this course from the same course being offered during the same semester/term).

Dimension

Sem

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

Dimension

Staff Name

Staff members full name formatted last name, first name (e.g., Sinatra, Nancy).

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.