Description
Student information. The data grain is student.
Columns
| Column Name | Description |
|---|---|
student_id |
Unique identifier for the student |
business_id |
Unique identifier for the business |
student_last_name |
The last name of the student |
student_first_name |
The first name of the student |
student_preferred_first_name |
The preferred first name of the student |
student_full_name |
The full name of the student |
date_of_birth |
The birth date of the student |
student_age_in_month |
Age of the student, represented in completed months |
student_age_group |
Student's age in completed years; <1 year indicates under 12 months |
student_age_group_order |
Numeric value used to sort student_age_group from youngest to oldest |
student_grade |
The grade level of the student; enumerated: 'Kindergarten', 'First', 'Second', 'Third', 'Fourth', 'Fifth', 'Sixth', 'Seventh', 'Pre-K', 'Eighth', or 'Not provided' |
meal_pricing_status |
The current pricing status for the student's meals; enumerated: 'Paid', 'Free', or 'Reduced' |
enrollment_status |
The current enrollment status for the student; enumerated: 'Active Enrollment' (student has at least one active enrollment), 'Scheduled Future Enrollment' (student has no active enrollment but has at least one future enrollment), 'Completed Enrollment' (student has no active or future enrollments but has at least one expired enrollment), 'No Enrollment' (student has never been Enrolled) |
student_profile_url |
The Kangarootime URL for the student profile |
student_key |
Unique natural key for students (first name + last name + date of birth + business_id); this is useful for counting unique students |