In order to be a student in CUNYfirst, certain records must exist. These records are ACAD_PROG, ACAD_PLAN, STDNT_CAR_TERM and STDNT_ENRL. Every student must have a program record, ACAD_PROG, the layout of which appears below.
A) ACAD_PROG
Field Description
EMPLID Y EMPLID - Empl ID
Y ACAD_CAREER - Academic Career
Y STDNT_CAR_NBR - Student Career Nbr
Y EFFDT - Effective Date
Y 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
...