...
EMPLID - Empl ID
ACAD_CAREER - Academic Career
STDNT_CAR_NBR - Student Career Nbr
EFFDT - Effective Date
EFFSEQ - Effective Sequence
INSTITUTION - Academic Institution
ACAD_PROG - Academic Program
PROG_STATUS - Academic Program Status
PROG_ACTION - Program Action
ACTION_DT - Action Date
PROG_REASON - Action Reason
ADMIT_TERM - Admit Term
EXP_GRAD_TERM - Expected Graduation Term
REQ_TERM - Requirement Term
ACAD_LOAD_APPR - Approved Academic Load
CAMPUS - Campus
DEGR_CHKOUT_STAT - Degree Checkout Status
COMPLETION_TERM - Completion Term
ACAD_PROG_DUAL - Dual Academic Program
JOINT_PROG_APPR - Joint Program Approved
ADM_APPL_NBR - Application Nbr
APPL_PROG_NBR - Application Program Nbr
DATA_FROM_ADM_APPL - Data from Admissions Appl
SSR_RS_CANDIT_NBR - Candidate Number
SSR_APT_INSTANCE - APT Instance
SSR_YR_OF_PROG - Year of Program
SSR_SHIFT - Academic Shift
SSR_COHORT_ID - Cohort Tag
SCC_ROW_ADD_OPRID - Created By
SCC_ROW_ADD_DTTM - Created
SCC_ROW_UPD_OPRID - Updated By
SCC_ROW_UPD_DTTM - Last Update Date/Time
and one plan – a student may have multiple plans but one is required. A student must be active in a program in order to be term activated. That process creates the STDNT_CAR_TERM record and a student will have one of these records for each term he/she is term activated. Finally, for each term and each class in which a student is enrolled, a STDNT_ENRL record is created.
...