Key |
Record.Fieldname |
Format |
XLAT |
Heading Text |
Source Tables |
Key |
ACAD_CAREER - Academic Career |
Char4 |
|
Career |
ADM_APPL_PROG |
|
ACAD_LOAD_APPR - Approved Academic Load |
Char1 |
N |
Acad Load |
|
|
ACAD_PLAN - Academic Plan |
Char10 |
|
Acad Plan |
ADM_APPL_PLAN |
|
ACAD_PLAN_TYPE - Academic Plan Type |
Char3 |
N |
Plan Type |
ACAD_PLAN_TBL |
|
ACAD_PROG - Academic Program |
Char5 |
|
Acad Prog |
ADM_APPL_PROG |
|
ACAD_PROG_DUAL - Dual Academic Program |
Char5 |
|
Dual Prog |
ADM_APPL_PROG |
|
ACAD_SUB_PLAN - Academic Sub-Plan |
Char10 |
|
Sub-Plan |
ADM_APPL_SBPLAN |
|
ACAD_SUBPLAN_TYPE - Academic Sub-Plan Type |
Char3 |
N |
Sub-Pl Typ |
ACAD_SUBPLN_TBL |
|
ACTION_DT - Action Date |
Date |
|
Action Date |
ADM_APPL_PROG |
Key |
ADM_APPL_NBR - Application Nbr |
Char8 |
|
Appl Nbr |
ADM_APPL_PROG |
|
ADMIT_TERM - Admit Term |
Char4 |
|
Admit Term |
ADM_APPL_PROG |
Key |
APPL_PROG_NBR - Application Program Nbr |
Num3.0 |
|
Prog Nbr |
ADM_APPL_PROG |
|
CAMPUS - Campus |
Char5 |
|
Campus |
ADM_APPL_PROG |
|
DATA_SOURCE - Data Source |
Char2 |
N |
Data source |
'AD' Hard Coded |
|
DECLARE_DT - Declare Date |
Date |
|
Decl Date |
ADM_APPL_PLAN |
|
DESCR_PROG - Description |
Char30 |
|
Descr |
ACAD_PLAN_TBL |
Key |
EFFDT - Effective Date |
Date |
|
Eff Date |
ADM_APPL_PROG |
Key |
EFFSEQ - Effective Sequence |
Num3.0 |
|
Sequence |
ADM_APPL_PROG |
Key |
EMPLID - Empl ID |
Char11 |
|
ID |
ADM_APPL_PROG |
|
EXP_GRAD_TERM - Expected Graduation Term |
Char4 |
|
Exp Grad |
ADM_APPL_PROG |
|
INSTITUTION - Academic Institution |
Char5 |
|
Institution |
ADM_APPL_PROG |
|
JOINT_PROG_APPR - Joint Program Approved |
Char1 |
|
Joint Program |
ADM_APPL_PROG |
|
PLAN_DESCR - Plan Description |
Char40 |
|
Plan Descr |
ACAD_PLAN_TBL |
|
PLAN_SEQUENCE - Plan Sequence |
Num2.0 |
|
Plan Seq |
ADM_APPL_PLAN |
|
PROG_ACTION - Program Action |
Char4 |
|
Prog Actn |
ADM_APPL_PROG |
|
PROG_REASON - Action Reason |
Char4 |
|
Action Rsn |
ADM_APPL_PROG |
|
PROG_STATUS - Academic Program Status |
Char4 |
N |
Status |
ADM_APPL_PROG |
|
REQ_TERM - Requirement Term |
Char4 |
|
Req Term |
ADM_APPL_PROG |
|
ROW_CHECK - ROW CHECK |
Char1 |
|
ROW CHECK |
-- ROW CHECK
CASE
WHEN (ROW_NUMBER() OVER(PARTITION BY
X.EMPLID,
X.ACAD_CAREER,
X.ADM_APPL_NBR
ORDER BY
X.EFFDT DESC,
X.EFFSEQ DESC NULLS LAST))
= 1 THEN 'Y' ELSE 'N' END,
|
|
ROW_COUNT - Number to Purge |
Num8.0 |
|
Row Count |
-- ROW_COUNT
ROW_NUMBER() OVER(PARTITION BY
X.EMPLID,
X.ACAD_CAREER,
X.ADM_APPL_NBR,
X.APPL_PROG_NBR
ORDER BY
X.EFFDT DESC ,
X.EFFSEQ DESC NULLS LAST) FOON,
|
|
ROW_COUNT2 - Row Count |
Num8.0 |
|
Count |
-- ROW_COUNT2
ROW_NUMBER () OVER ( PARTITION BY
X.EMPLID ,
X.ACAD_CAREER ,
X.ADM_APPL_NBR ,
X.APPL_PROG_NBR ,
X.ACAD_PLAN
ORDER BY
X.EFFDT DESC ,
X.EFFSEQ DESC NULLS LAST) FOBAR,
|
|
ROW_COUNT3 - Row Count |
Num8.0 |
|
Count |
-- ROW_COUNT3
ROW_NUMBER () OVER ( PARTITION BY
X.EMPLID ,
X.ACAD_CAREER ,
X.ADM_APPL_NBR ,
X.APPL_PROG_NBR ,
X.ACAD_PLAN ,
X.ACAD_SUB_PLAN
ORDER BY
X.EFFDT DESC ,
X.EFFSEQ DESC NULLS LAST) FUBAR,
|
|
SSR_SHIFT - Academic Shift |
Char12 |
|
Academic Shift |
ADM_APPL_PROG |
|
UM_SUBPLN_DESCR - Subplan Descr |
Char30 |
|
Subplan Descr |
ACAD_SUBPLN_TBL |