In order to be an enrolled a student in CUNYfirst, certain records must exist. These 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
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
one program 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.
Key Description
A) Working backwards, the STDNT_ENRL contains the following keys:
- EMPLID
- ACAD_CAREER
- INSTITUTION
- STRM
- CLASS_NBR
- T
For each class, a student will have one of these records. This does not mean that the student is enrolled. For that, the field STDNT_ENRL_STATUS must be checked. If a student is enrolled, the status will be 'E'; if a student is waitlisted for a class, the status will be 'W'; if the student was enrolled and subsequently dropped the class, the status would be 'D'. Therefore, you must check the STDNT_ENRL_STATUS for 'E' to determine in which classes a student is enrolled or even if this is an enrolled student for the term.
...