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.