• Created by Unknown User (mmcgovern1), last modified on Aug 04, 2014

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

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.

 

  1. 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.   
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.

 

  • No labels