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
person_id	INTEGER	The UDP ID of the student.
academic_term_id	INTEGER	The UDP ID for the academic_term.
athletic_participant_sport	STRING	The sport a student is participating in as a National Collegiate Athletic Association (NCAA) athlete. (option set)
cen_academic_level	STRING	The student's Academic level at the census date of an Academic term, as determined by the institution. (option set)
cen_academic_load	STRING	The student's Academic load at the census date of an Academic term, as determined by the Institution. (option set)
eot_academic_load	STRING	The student's Academic load at the end of an Academic term, as determined by the Institution. (option set)
gpa_academic_term	NUMERIC	The GPA of a post-secondary student in this Academic term at the University. This is usually computed by computing the sum of Grade points earned that count toward GPA by the sum of Credits earned that count toward GPA.
gpa_cumulative	NUMERIC	The cumulative GPA of a post-secondary student through to their most recently completed Academic term at the University, but not including the term for which this is a record. This GPA is intended to cover the whole career of a post-secondary student up until the beginning of this Academic term. This is usually computed by computing the sum of Grade points earned that count toward GPA by the sum of Credits earned that count toward GPA.
in_honors_program	INTEGER	Indicates whether a student is enrolled in any honors program during the term. 1 = in honors program.
registration_status	STRING	Indicates the registration status of a student for a particular Academic term. (option set)
us_residency	STRING	The person’s residency status in the United States. (option set)
is_english_first_language	INTEGER	Indicates whether English is the first language of the person. If false, it is assumed that some other language is the individual's first language even if the student is proficient in English.
is_first_generation_hed_student	INTEGER	Indicates whether the student is in the first generation of their family to attend an institution of higher education.
race_indication	STRING	Indicates the student's self-identified race. Values of "No Race Indicated" and "Some Other Race" are populated in the absence or redaction of race data.
is_minority	INTEGER	Indicates if the student belongs to an identified minority race_indication.
sex	STRING	The legal sex of the person. (option set)
term_name	STRING	The human-readable name for the academic term.
term_type	STRING	The type of Academic term. (option set)
term_begin_date	DATE	The beginning date of the term.
term_end_date	DATE	The ending date of the term.
academic_major_name	STRING	The institutional description of the academic major.
academic_minor_name	STRING	The institutional description of the academic minor.
academic_career_name	STRING	The description of the Academic career at the Institution.
directory_block	STRING	A variable used to describe persons currently electing to block their directory information as per FERPA, or those who previously had a block but are requesting it be removed. A null value indicates that the related person does not have a FERPA directory block, and values may be shared in accordance with standard data agreements. This block is only valid for institutional affiliated records. (option set)

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.

\