Student Term Profile
Last updated
Last updated
The mart_taskforce.student_term_profile mart aggregates data about a student in academic terms. Metadata about students and terms are presented together here.
mart_taskforce
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.
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)
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.
term_name
STRING
The human-readable name for the academic term.
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)
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
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.
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.
\
