This chart compares UM_FLT_PRGPLN, UM_FLAT_PRGPLAN, UM_PRGPLAN_CENS & UM_PRGPLAN_STRM.
| all fields | um_flt_prgpln | um_flat_prgplan | um_prgplan_strm | um_prgplan_cens | |||
| ACAD_CAREER | X | X | X | X | |||
| ACAD_PROG | X | ||||||
| EMPLID | X | X | X | X | |||
| INSTITUTION | X | X | X | X | |||
| PROG_STATUS | X | ||||||
| STDNT_CAR_NBR | X | X | X | X | |||
| STRM | X | X | X | ||||
| UM_ACAD_PLAN_DESC1 | X | X | X | ||||
| UM_ACAD_PLAN_DESC2 | X | X | X | ||||
| UM_ACAD_PLAN_DESC3 | X | X | X | ||||
| UM_ACAD_PLAN_DESC4 | X | X | X | ||||
| UM_ACAD_PLAN_DESC5 | X | X | X | ||||
| UM_ACAD_PLAN_DESC6 | X | X | X | ||||
| UM_ACAD_PLAN_DESC7 | X | X | X | ||||
| UM_ACAD_PLAN_TYP1 | X | X | X | ||||
| UM_ACAD_PLAN_TYP2 | X | X | X | ||||
| UM_ACAD_PLAN_TYP3 | X | X | X | ||||
| UM_ACAD_PLAN_TYP4 | X | X | X | ||||
| UM_ACAD_PLAN_TYP5 | X | X | X | ||||
| UM_ACAD_PLAN_TYP6 | X | X | X | ||||
| UM_ACAD_PLAN_TYP7 | X | X | X | ||||
| UM_ACAD_PLAN1 | X | X | X | X | |||
| UM_ACAD_PLAN2 | X | X | X | X | |||
| UM_ACAD_PLAN3 | X | X | X | X | |||
| UM_ACAD_PLAN4 | X | X | X | X | |||
| UM_ACAD_PLAN5 | X | X | X | X | |||
| UM_ACAD_PLAN6 | X | X | X | ||||
| UM_ACAD_PLAN7 | X | X | X | ||||
| UM_ACAD_PROG1 | X | X | X | ||||
| UM_ACAD_PROG2 | X | X | X | ||||
| UM_ACAD_PROG3 | X | X | X | ||||
| UM_ACAD_PROG4 | X | X | X | ||||
| UM_ACAD_PROG5 | X | X | X | ||||
| UM_ACAD_PROG6 | X | X | X | ||||
| UM_ACAD_PROG7 | X | X | X | ||||
| UM_ACAD_SUB_PLN1A | X | ||||||
| UM_ACAD_SUB_PLN1B | X | ||||||
| UM_ACAD_SUB_PLN1C | X | ||||||
| UM_ACAD_SUB_PLN2A | X | ||||||
| UM_ACAD_SUB_PLN2B | X | ||||||
| UM_ACAD_SUB_PLN2C | X | ||||||
| UM_ACAD_SUB_PLN3A | X | ||||||
| UM_ACAD_SUB_PLN3B | X | ||||||
| UM_ACAD_SUB_PLN3C | X | ||||||
| UM_ACAD_SUB_PLN4A | X | ||||||
| UM_ACAD_SUB_PLN4B | X | ||||||
| UM_ACAD_SUB_PLN4C | X | ||||||
| UM_ACAD_SUB_PLN5A | X | ||||||
| UM_ACAD_SUB_PLN5B | X | ||||||
| UM_ACAD_SUB_PLN5C | X | ||||||
| UM_CIP_CODE1 | X | ||||||
| UM_CIP_CODE2 | X | ||||||
| UM_CIP_CODE3 | X | ||||||
| UM_CIP_CODE4 | X | ||||||
| UM_CIP_CODE5 | X | ||||||
| UM_DECLARE_DT1 | X | ||||||
| UM_DECLARE_DT2 | X | ||||||
| UM_DECLARE_DT3 | X | ||||||
| UM_DECLARE_DT4 | X | ||||||
| UM_DECLARE_DT5 | X | ||||||
| UM_DEGREE1 | X | X | |||||
| UM_DEGREE2 | X | X | |||||
| UM_DEGREE3 | X | X | |||||
| UM_DEGREE4 | X | X | |||||
| UM_DEGREE5 | X | X | |||||
| UM_DEGREE6 | X | ||||||
| UM_DEGREE7 | X | ||||||
| UM_PLAN_DESCR1 | X | ||||||
| UM_PLAN_DESCR2 | X | ||||||
| UM_PLAN_DESCR3 | X | ||||||
| UM_PLAN_DESCR4 | X | ||||||
| UM_PLAN_DESCR5 | X | ||||||
| UM_PLAN_SEQ1 | X | X | X | ||||
| UM_PLAN_SEQ2 | X | X | X | ||||
| UM_PLAN_SEQ3 | X | X | X | ||||
| UM_PLAN_SEQ4 | X | X | X | ||||
| UM_PLAN_SEQ5 | X | X | X | ||||
| UM_PLAN_SEQ6 | X | X | X | ||||
| UM_PLAN_SEQ7 | X | X | X | ||||
| UM_PLAN_TYPE1 | X | ||||||
| UM_PLAN_TYPE2 | X | ||||||
| UM_PLAN_TYPE3 | X | ||||||
| UM_PLAN_TYPE4 | X | ||||||
| UM_PLAN_TYPE5 | X | ||||||
| UM_PROG_STATUS1 | X | X | X | ||||
| UM_PROG_STATUS2 | X | X | X | ||||
| UM_PROG_STATUS3 | X | X | X | ||||
| UM_PROG_STATUS4 | X | X | X | ||||
| UM_PROG_STATUS5 | X | X | X | ||||
| UM_PROG_STATUS6 | X | X | X | ||||
| UM_PROG_STATUS7 | X | X | X | ||||
| UM_SUBPLN_DESCR_1A | X | ||||||
| UM_SUBPLN_DESCR_1B | X | ||||||
| UM_SUBPLN_DESCR_1C | X | ||||||
| UM_SUBPLN_DESCR_2A | X | ||||||
| UM_SUBPLN_DESCR_2B | X | ||||||
| UM_SUBPLN_DESCR_2C | X | ||||||
| UM_SUBPLN_DESCR_3A | X | ||||||
| UM_SUBPLN_DESCR_3B | X | ||||||
| UM_SUBPLN_DESCR_3C | X | ||||||
| UM_SUBPLN_DESCR_4A | X | ||||||
| UM_SUBPLN_DESCR_4B | X | ||||||
| UM_SUBPLN_DESCR_4C | X | ||||||
| UM_SUBPLN_DESCR_5A | X | ||||||
| UM_SUBPLN_DESCR_5B | X | ||||||
| UM_SUBPLN_DESCR_5C | X | ||||||
| UM_TRNSCR_DESCR1 | X | ||||||
| UM_TRNSCR_DESCR2 | X | ||||||
| UM_TRNSCR_DESCR3 | X | ||||||
| UM_TRNSCR_DESCR4 | X | ||||||
| UM_TRNSCR_DESCR5 | X | ||||||
| UM_TRNSCR_DESCR6 | X | ||||||
| UM_TRNSCR_DESCR7 | X |
| tables used | um_flt_prgpln | um_flat_prgplan | um_prgplan_strm | um_prgplan_cens |
| ACAD_PLAN | x | x | x | x |
| ACAD_PLAN_TBL | x | x | x | x |
| ACAD_PROG | x | x | x | x |
| ACAD_SUBPLAN | x | |||
| ACAD_SUBPLN_TBL | x | |||
| STDNT_CAR_TERM | x | x | x | |
| TERM_TBL | x | x | ||
| Effective date logic: | ||||
EFFDT <= SYSDATE | EFFDT <= SYSDATE | EFFDT <= TERM_END_DT* | EFFDT <= Census (2/15, 8/15 or 10/15) | |
*TERM_END_DT field is from PS_TERM_TBL
Attachments:
REPORT-480 flat view comparisons 3-7-19.xlsx (application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)