Taskforce Mart - Student Term Profile
The mart_taskforce.student_term_profile mart aggregates data about a student in academic terms. Metadata about students and terms are presented together here.
BQ Prod Dataset Locations
mart_taskforce
Interactive Mart Dependency Diagram
Schema
mart/taskforce/student_term_profile
Field Structure and Subcategories
This mart focuses on both students and terms:
Student
Static Metadata
us_residency
is_english_first_language
is_first_generation_hed_student
race_indication
is_minority
sex
academic_career_name
directory_block
Term-based Metadata
athletic_participant_sport
cen_academic_level
cen_academic_load
eot_academic_load
gpa_academic_term
gpa_cumulative
in_honors_program
registration_status
academic_major_name
academic_minor_name
Terms
term_name
term_type
term_begin_date
term_end_date
Student - Static Metadata
These fields describe attributes of the learner, and we don't expect these to ever change. However, each student will have a row for each term in which they are enrolled, so expect these values to be copied in each row seen for each person-term row in the mart.
Student - Term-based Metadata
These fields are tied to the behaviors or status of students as they relate to academic terms. For example, cumulative GPA will update as more academic terms complete. Similarly, a student may enter the honors program one term but then leave in a later term. Each student will have a row for each term in which they are enrolled, and these values may be distinct when looking across rows per person-term.
\
Last updated