...
Field Description
EMPLID - Empl ID
ACAD_(key; should equal that of ACAD_PROG.)
ACAD_CAREER - Academic Career Career (key; should equal that of ACAD_PROG.)
INSTITUTION - Academic Institution (key; should equal that of ACAD_PROG.)
STRM - Term (key)
REG_CARD_DATE - Registration Card Date
WITHDRAW_CODE - Withdrawal \ Cancel
WITHDRAW_REASON - Withdrawal \ Cancel Reason
WITHDRAW_DATE - Withdrawal \ Cancel Date
LAST_DATE_ATTENDED - Last Date of Attendance
STDNT_CAR_NBR - Student Career Nbr (NOT a key; should equal that of ACAD_PROG.)
ACAD_PROG_PRIMARY - Primary Academic Program
ACAD_LOAD_APPR - Approved Academic Load
ACADEMIC_LOAD - Academic Load
FA_LOAD - Financial Aid Load
ACAD_LEVEL_PROJ - Academic Level - Projected
ACAD_LEVEL_BOT - Academic Level - Term Start
ACAD_LEVEL_EOT - Academic Level - Term End
NSLDS_LOAN_YEAR - NSLDS Loan Year
OVRD_ACAD_LVL_PROJ - Override Projected Level
OVRD_ACAD_LVL_ALL - Override All Academic Levels
ELIG_TO_ENROLL - Eligible to Enroll
OVRD_MAX_UNITS - Override Maximum Units
MAX_TOTAL_UNIT - Max Total Units
MAX_NOGPA_UNIT - Max No GPA Units
MAX_AUDIT_UNIT - Max Audit Units
MAX_WAIT_UNIT - Max Wait List Units
MIN_TOTAL_UNIT - Min Total Units
OVRD_BILL_UNITS - Override Billing Units
PROJ_BILL_UNT - Projected Bill Units
UNT_TAKEN_PRGRSS - Units Taken for Progress
UNT_PASSD_PRGRSS (if the student is enrolled in credit-bearing courses, this number will be greater than zero.)
UNT_PASSD_PRGRSS - Units Passed for Progress (*** any field starting with UNT is a term total.)
UNT_TAKEN_GPA - Units Taken Toward GPA
UNT_PASSD_GPA - Units Passed Toward GPA
UNT_TAKEN_NOGPA - Units Taken Not Toward GPA
UNT_PASSD_NOGPA - Units Passed Not Toward GPA
UNT_INPROG_GPA - Units In Progress - GPA
UNT_INPROG_NOGPA - Unit In Progress - Not for GPA
GRADE_POINTS - Grade Points
UNT_AUDIT - Units Audited
UNT_TRNSFR - Units Transferred
TRF_TAKEN_GPA - Transfer Taken for GPA
TRF_TAKEN_NOGPA - Transfer Taken Not for GPA
TRF_PASSED_GPA - Transfer Passed for GPA
TRF_PASSED_NOGPA - Transfer Passed Not for GPA
TRF_GRADE_POINTS - Transfer Grade Points
UNT_TEST_CREDIT - Units from Test Credit
UNT_OTHER - Units from Other Credit
UNT_TAKEN_FA - Fin Aid Progress Units Taken
UNT_PASSD_FA - Fin Aid Progress Units Passed
UNT_TAKEN_FA_GPA - FA Units Taken Toward GPA
GRADE_POINTS_FA - Financial Aid Grade Points
UNT_TERM_TOT - Total Term Units
RESET_CUM_STATS - Reset Cum Stats at Term Start
TOT_TAKEN_PRGRSS - Total Taken for Progress (*** any field starting with TOT is a career total.)
TOT_PASSD_PRGRSS - Total Passed for Progress
TOT_TAKEN_GPA - Total Taken Toward GPA
TOT_PASSD_GPA - Total Passed Toward GPA
TOT_TAKEN_NOGPA - Total Taken Not Toward GPA
TOT_PASSD_NOGPA - Total Passed Not Toward GPA
TOT_INPROG_GPA - Total In Progress - GPA
TOT_INPROG_NOGPA - Total In Progress -Not for GPA
TOT_AUDIT - Total Audited
TOT_TRNSFR - Total Transferred
TOT_TEST_CREDIT - Total From Test Credit
TOT_OTHER - Total from Other Credit
TOT_CUMULATIVE - Total Cumulative Units
TOT_GRADE_POINTS - Total Grade Points
TOT_TAKEN_FA - Total Fin Aid Units Taken
TOT_PASSD_FA - Total Fin Aid Units Passed
TOT_TAKEN_FA_GPA - Total Fin Aid Taken Toward GPA
TOT_GRD_POINTS_FA - Total Fin Aid Grade Points
FORM_OF_STUDY - Form of Study
TERM_TYPE - Term Unit Type
CLASS_RANK_NBR - Class Rank Nbr
CLASS_RANK_TOT - Class Rank Total
SEL_GROUP - Tuition Group
TUIT_CALC_REQ - Tuition Calc Required
TUIT_CALC_DTTM - Tuit Calc Date Time
FA_STATS_CALC_REQ - FA Stats Calculation Required
FA_STATS_CALC_DTTM - FA Stats Calc Date Time
FA_ELIGIBILITY - Program Eligibility Flag
BILLING_CAREER - Billing Career
UNIT_MULTIPLIER - Unit Multiplier
ACAD_YEAR - Academic Year
ACAD_GROUP_ADVIS - Academic Group of Advisor
CUR_RESIDENT_TERMS - Current In Residence Terms
TRF_RESIDENT_TERMS - Transfer In Residence Terms
CUM_RESIDENT_TERMS - Cumulative In Residence Terms
REFUND_PCT - Refund Percentage
REFUND_SCHEME - Refund Scheme
PRO_RATA_ELIGIBLE - Pro-Rata Eligible
FULLY_ENRL_DT - Fully Enrolled Date
ENRL_ON_TRANS_DT - Show Enrollment on Transcript
STATS_ON_TRANS_DT - Show Statistics on Transcript
FULLY_GRADED_DT - Fully Graded Date
EXT_ORG_ID - External Org ID
COUNTRY - Country
STUDY_AGREEMENT - Study Agreement
START_DATE - Start Date for Gen Standing PO
END_DATE - End Date
MAX_CRSE_COUNT - Max Total Courses
CUR_GPA - Current GPA (term GPA, after grades are posted.)
CUM_GPA - Cumulative GPA
REGISTERED - Registered
OVRD_TUIT_GROUP - Override Tuition Group
OVRD_WDRW_SCHED - Override Withdrawal Schedule
TUITION_RES_TERMS - Tuition Residency
OVRD_INIT_ADD_FEE - Override Initial Add Fees
OVRD_INIT_ENR_FEE - Override Initial Enroll Fee
TC_UNITS_ADJUST - TC Units Adjustment
LOCK_IN_AMT - Lock In Amount
LOCK_IN_DT - Lock In Date
ACAD_CAREER_FIRST - First Time in Career
ACADEMIC_LOAD_DT - Academic Load Change Date
UNTPRG_CHG_NSLC_DT - Unit Progrss Changed Date NSC
SSR_ACTIVATION_DT - Term Activation Date
SSR_TRF_CUR_GPA - Transfer Credit Current GPA
SSR_COMB_CUR_GPA - Combined Current GPA
SSR_CUM_EN_GPA - Enrollment Cumulative GPA
SSR_TOT_EN_GRDPTS - Enrollment Grade Points
SSR_TOT_EN_TKNGPA - Units Taken Toward GPA
SSR_CUM_TR_GPA - Transfer Credit Cumulative GPA
SSR_TOT_TR_GRDPTS - Transfer Credit Grade Points
SSR_TOT_TR_TKNGPA - Units Taken Toward GPA
Key Description
A) STDNT_ENRL is created when a student enrolls in a class or is waitlisted for that class. Even if the student subsequently drops the class, the record remains, but the status changes. STDNT_ENRL is owned by STDNT_CAR_TERM. The layout is below.A) Working backwards, the STDNT_ENRL contains the following keys:
- EMPLID
- ACAD_CAREER
- INSTITUTION
- STRM
- CLASS_NBR
- T
...