SSR_RI_EPBV_NLD

(SQL View)
 Index Back

Current View(edu prov BRIN)


SELECT A.INSTITUTION , A.SSR_RI_EDU_GOV_NLD , C.ACAD_ORG , B.SCC_BRINCD_NLD , D.SCC_CAF_ATTR_VAL , CASE WHEN E.EFFDT > C.EFFDT THEN E.EFFDT ELSE C.EFFDT END , CASE WHEN F.EFF_STATUS = 'I' THEN F.EFFDT END AS END_DT FROM %Table(SSR_RI_EPS_NLD) A JOIN %Table(ACAD_ORG_TBL) C ON A.INSTITUTION = C.INSTITUTION JOIN %Table(SSR_RI_EPWL_NLD) EPW ON C.INSTITUTION = EPW.INSTITUTION AND C.ACAD_ORG = EPW.ACAD_ORG JOIN %Table(SSR_RI_HCMP_NLD) B ON A.INSTITUTION = B.INSTITUTION AND B.ACAD_ORG = C.ACAD_ORG JOIN %Table(SCC_BRINCD_NLD) E ON B.SCC_BRINCD_NLD = E.SCC_BRINCD_NLD LEFT OUTER JOIN %Table(ACAD_ORG_CAF) D ON A.SCC_CAF_ATTRIB_NM = D.SCC_CAF_ATTRIB_NM AND C.ACAD_ORG = D.ACAD_ORG AND C.EFFDT = D.EFFDT JOIN %Table(ACAD_ORG_TBL) F ON C.INSTITUTION = F.INSTITUTION AND C.ACAD_ORG = F.ACAD_ORG WHERE C.EFFDT = ( SELECT MIN(C1.EFFDT) FROM %Table(ACAD_ORG_TBL) C1 WHERE C1.ACAD_ORG = C.ACAD_ORG AND C1.EFFDT <= %CurrentDateIn AND C1.EFF_STATUS = 'A' ) AND E.EFFDT = ( SELECT MIN(E_ED.EFFDT) FROM %Table(SCC_BRINCD_NLD) E_ED WHERE E.SCC_BRINCD_NLD = E_ED.SCC_BRINCD_NLD AND E_ED.EFFDT <= %CurrentDateIn AND E_ED.EFF_STATUS = 'A' ) AND %EffdtCheck(SSR_RI_EPS_NLD A_ED,A,%CURRENTDATEIN) AND A.EFFDT = EPW.EFFDT AND F.EFFDT = ( SELECT MAX(F_ED.EFFDT) FROM %Table(ACAD_ORG_TBL) F_ED WHERE F.ACAD_ORG = F_ED.ACAD_ORG AND F_ED.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 SSR_RI_EDU_GOV_NLD Character(20) VARCHAR2(20) NOT NULL Educational Board Code
3 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
4 SCC_BRINCD_NLD Character(4) VARCHAR2(4) NOT NULL BRINcode
5 SSR_RI_EPV_COD_NLD Character(12) VARCHAR2(12) NOT NULL Educational Provider Code
6 FROM_DT Date(10) DATE NOT NULL From Date
7 END_DT Date(10) DATE end date