...
- ACAD_PROG - This is the core of the student system. For someone to be a student, there must be an ACAD_PROG record (and at least one ACAD_PLAN record) present. The key structure of this record is EMPLID, ACAD_CAREER, STDNT_CAR_NBR, EFFDT and EFF_SEQ. Even though INSTITUTION is not a key, it must also be considered because the CUNY Installation has twenty four institutions and without that added delimiter, the query would return too many rows.
- ACAD_PROG_TBL - This is the set-up table where all academic programs are defined and stored. All programs must be added to this set-up table before they can be assigned to a student. Some examples programs are NDEGU, UGRD and CBUIS on the undergraduate career level and MBA, MPA, MS, etc. on the graduate level. The keys to this table are INSTITUTION, ACAD_PROG & EFFDT.
- ACAD_PLAN - This is where the major or minor is stored for the student. A student must have at least one of these record and it is a child of ACAD_PROG. It shares the same keys (EMPLID, ACAD_CAREER, STDNT_CAR_NBR, EFFDT and EFF_SEQ) as ACAD_PROG and has one more, ACAD_PLAN. The five keys of ACAD_PLAN must equal the first five keys of ACAD_PLAN.
- ACAD_PLAN_TBL - This is the set-up table where the academic plans are defined and stored. All plans must be added to this set-up table before they can be assigned to a student. The keys to this table are INSTITUTION, ACAD_PLAN & EFFDT.
- ACAD_SUBPLAN - This is where a student's concentration is kept. A student may or may not have a subplan but it is a child of ACAD_PLAN and shares the six keys of ACAD_PLAN (EMPLID, ACAD_CAREER, STDNT_CAR_NBR, EFFDT, EFF_SEQ & ACAD_PLAN). The field, ACAD_SUBPLAN, is also a key in this table. Because ACAD_SUBPLAN is optional for the student, be sure to do an outer join with ACAD_PLAN.
- ACAD_SUBPLAN_TBL - This is the set-up table where the academic subplans are defined and stored. All subplans must be added to this set-up table before they can be assigned to a student. The keys to this table are INSTITUTION, ACAD_SUBPLAN & EFFDT.
- ADM_APPL_DATA - This record contains basic data for an applicant in Student Admissions. These are applicants, not students, and this record contains the ADMIT_TYPE.
- ADM_APPL_PROG - This record is similar to ACAD_PROG but on the Student Admissions side. It is a child of ADM_APPL_DATA.
- ADM_APPL_PLAN - This record is similar to ACAD_PLAN but on the Student Admissions side. It is a child of ADM_APPL_PROG.
- ADM_APPL_SUBPLAN - This record is similar to ACAD_SUBPLAN but on the Student Admissions side. It is a child of ADM_APPL_PLAN.