SSR_HE_PLAN_VW

(SQL View)
 Index Back

Create HESA Acad Plans


SELECT DISTINCT A.INSTITUTION ,A.ACAD_PLAN ,A.DESCR FROM PS_ACAD_PLAN_TBL A WHERE EXISTS ( SELECT 'x' FROM PS_SSR_HE_PLAN B WHERE A.INSTITUTION = B.INSTITUTION AND A.ACAD_PLAN = B.ACAD_PLAN ) AND A.EFF_STATUS = 'A' AND A.EFFDT= ( SELECT MAX(EFFDT) FROM PS_ACAD_PLAN_TBL A1 WHERE A.INSTITUTION = A1.INSTITUTION AND A.ACAD_PLAN = A1.ACAD_PLAN )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description