These are some of the more important records which you may or may not use in your queries.
- 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 used. 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.