These are some of the more important records which you may or may not use in your queries. Please note that the spelling of the records (tables) needs to be checked.
- 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.