...
EMPLID - Empl ID (key)
ACAD_CAREER - Academic Career (key)
STDNT_CAR_NBR - Student Career Nbr (key)
EFFDT - Effective Date (key; the current record is the maximum effective date, less than or equal to today, for the EMPLID, ACAD_CAREER and STDNT_CAR_NBR)
EFFSEQ - Effective Sequence (key; this field allows multiple transactions for the EFFDT. The current record is the maximum effective sequence for the EFFDT.)
INSTITUTION - Academic Institution (this is not a key but should be considered one because there are multiple institutions in CUNYfirst. Always delimit your selection by INSTITUTION.)
ACAD_PROG - Academic Program (the student's program - MPA, MA, MBA, UGRD, etc.)
PROG_STATUS - Academic Program Status ('AC' - active – a student MUST be active to be term activated; 'CM' - completed – the student has graduated; 'CN' - cancelled; 'DC' - discontinued; 'DM' - dismissed. This field is derived from PROG_ACTION.)
PROG_ACTION - Program Action (what is happening, such as MATR - matriculation, DATA - data change, DISC - discontinuation, etc.)
ACTION_DT - Action Date (the date of the action, always defaults to today's date)
PROG_REASON - Action Reason (why the action is taking place)
ADMIT_TERM - Admit Term (the term when the student started)
EXP_GRAD_TERM - Expected Graduation Term (the term when the student should graduate)
REQ_TERM - Requirement Term (the term which governs the rules for graduation.)
ACAD_LOAD_APPR - Approved Academic Load
CAMPUS - Campus
DEGR_CHKOUT_STAT - Degree Checkout Status (if a student has applied for graduation, or has graduated; 'AG' - applied, 'AW' - awarded, etc.)
COMPLETION_TERM - Completion Term (the term in which the student graduated)
ACAD_PROG_DUAL - Dual Academic Program
JOINT_PROG_APPR - Joint Program Approved
ADM_APPL_NBR - Application Nbr (if this student came through the Admissions process, this number can be used to retrieve the application.)
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 (the user who added the record.)
SCC_ROW_ADD_DTTM - Created (when the record was added.)
SCC_ROW_UPD_OPRID - Updated By (the user who change the record last.)
SCC_ROW_UPD_DTTM - Last Update Date/Time (when the record was changed last.)
B) ACAD_PLAN contains the student's plan, which is the major or minor. A student MUST have one plan but there could be more than one. ACAD_PLAN is owned by ACAD_PROG, so the five keys of ACAD_PROG MUST equal the first five keys of ACAD_PLAN. The table layout is below.
...
- EMPLID
- ACAD_CAREER
- STDNT_CAR_NBR
- EFFDTEFFSEQ
...
- EFFSEQ
...
- Other related tables which contain important information are:
- ACAD_PROG_TBL – details about the program.
- ACAD_PLAN_TBL – details about the plan.
...