Credit-weighted term GPA at the FFFD institution after fffd_start_date, using degree-seeking terms and attempted credits; invalid GPA records are excluded.
October 19, 2026
Credit-weighted term GPA at the FFFD institution after fffd_start_date, using degree-seeking terms and attempted credits; invalid GPA records are excluded.
October 19, 2026
Post-FFFD disposition from ps_graduation.sql: award within/after 150% of expected time, Nebraska/out-of-state transfer, or workforce entry.
October 19, 2026
Text label for the award selected in the latest-institution/latest-term logic, prioritizing postsecondary type, award level, and CIP tie-breakers; missing award is labeled No degree.
October 19, 2026
Career-cluster name for the selected latest institution’s final program CIP. The loader applies a small set of CIP corrections and explicit overrides; missing matches become Undeclared/unknown.
October 19, 2026
Text label for the maximum award_code observed across two-year and four-year academic awards for degree-seeking students; absence is labeled No degree and codes 17+ are grouped as Doctoral.
October 19, 2026
Six-digit career-cluster ID for the latest award CIP code, using the 2020 CIP-to-career-cluster crosswalk. Missing crosswalk values become 0.
October 19, 2026
Persisted flag read from vw_ps_persistence for the student.
October 19, 2026
Retained flag read from vw_ps_persistence for the student.
October 19, 2026
Sum of first-term attempted course credits with course_instruction_mode 3 (traditional) at the FFFD institution/start date; transcript and course-section values are coalesced.
October 19, 2026
Sum of first-term attempted course credits with course_instruction_mode 1 (hybrid) at the FFFD institution/start date; transcript and course-section values are coalesced.
October 19, 2026
Sum of first-term attempted course credits with course_instruction_mode 2 (online) at the FFFD institution/start date; transcript and course-section values are coalesced.
October 19, 2026
Career-cluster ID for primary_program_one in the FFFD term, using the 2020 CIP-to-career-cluster crosswalk; missing matches become 0.
October 19, 2026
1 when Nebraska postsecondary or National Student Clearinghouse enrollment begins before fffd_start_date; otherwise 0.
October 19, 2026
Sum of quarter-4 UI wages in the calendar year of fffd_start_date; NULL is converted to 0.
October 19, 2026
First-term math classification at the FFFD institution and start date. Math transcript rows are classified as no math, math, or foundational math using remedial_course_math_flag plus institution-specific course-number overrides.
October 19, 2026
Reported term_gpa for the FFFD institution and start date.
October 19, 2026
Sum of first-term course credit hours for withdrawn or zero-grade-point courses at the FFFD institution and start date, restricted to grade_mode 1 and positive credits.
October 19, 2026
Months from the selected postsecondary exit reference date to the earliest qualifying sustained UI employment. The query estimates the month within the first quarter from the wage pattern and threshold; the loader floors negative results at zero.
October 19, 2026
Most recently reported non-unknown gender across K-12, two-year, and four-year enrollment, ordered by source start date.
October 19, 2026
Start date of the earliest fall first-time, full-time, degree-seeking undergraduate term selected with the same rules as fffd_institution.
October 19, 2026
Institution for the earliest fall first-time, full-time, degree-seeking undergraduate term. The loader restricts starts to May-October, excludes likely four-year graduate terms, and resolves ties by postsecondary type and institution ID.
October 19, 2026
Derived from state_hs_graduation in degree-seeking postsecondary enrollment and the presence of K-12 records. Nebraska takes precedence, other known states become OOS, and absent information becomes UNK.
October 19, 2026
Latest degree-seeking postsecondary institution. Within the latest term, the loader selects the institution with the greatest total transcript credits, then the greatest numeric institution ID on ties.
October 19, 2026
Credit-weighted postsecondary term GPA at the selected latest institution for degree-seeking records: sum(term_gpa * attempted credits) / sum(attempted credits). GPAs above 4 and inconsistent zero-GPA records are excluded.
October 19, 2026
Postsecondary system associated with the selected latest degree-seeking institution. Selection uses the greatest total transcript credits at the latest term, with the greatest numeric institution ID as tie-breaker; institution IDs are mapped to CC, NU, or NSCS.
