Taskforce Mart - Student Term Profile

• Interactive Mart Dependency Diagram
• Schema
• Field Structure and Subcategories

  • Student - Static Metadata
  • Student - Term-based Metadata

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

The following visualization shows the construction of this data mart defined in the UDP marts repository. More information on the repository and diagram can be found on this marts page.

Click here to open the interactive chart.

mart_taskforce.student_term_profile

Schema

mart/taskforce/student_term_profile

Field Name	Type	Description

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.

\