SSR_RI_EPAV_NLD

(SQL View)
Index Back

Current View (edu prov attrib)

/* 2021-10-06: fix for Bug-ID: 32929597 - RIOv3 */

SELECT DISTINCT A.INSTITUTION , A.SSR_RI_EDU_GOV_NLD , B.ACAD_ORG , 'eigenOnderwijsaanbiederSleutel' , '' , B.ACAD_ORG , '' , 0 , %DateNull , '' , C.SCC_CAF_ATTR_VAL FROM %Table(SSR_RI_EPS_NLD) A JOIN %Table(ACAD_ORG_TBL) B ON A.INSTITUTION = B.INSTITUTION AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM %Table(ACAD_ORG_TBL) B_ED WHERE B.ACAD_ORG = B_ED.ACAD_ORG AND B_ED.EFFDT <= %CurrentDateIn) JOIN %Table(SSR_RI_EPWL_NLD) EPW ON B.INSTITUTION = EPW.INSTITUTION AND B.ACAD_ORG = EPW.ACAD_ORG LEFT OUTER JOIN %Table(ACAD_ORG_CAF) C ON A.SCC_CAF_ATTRIB_NM = C.SCC_CAF_ATTRIB_NM AND B.ACAD_ORG = C.ACAD_ORG AND B.EFFDT = C.EFFDT WHERE %EffdtCheck(SSR_RI_EPS_NLD A_ED,A,%CURRENTDATEIN) AND A.EFFDT = EPW.EFFDT

# 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 SSR_RI_AT_NAME_NLD Character(50) VARCHAR2(50) NOT NULL Common Attribute
5 SSR_RI_AT_VAL_NLD Character(20) VARCHAR2(20) NOT NULL Attribute Value
6 SSR_RI_AT_TVAL_NLD Character(50) VARCHAR2(50) NOT NULL Text Value
7 SSR_RI_AT_BVAL_NLD Character(1) VARCHAR2(1) NOT NULL Yes/No Value
8 SSR_RI_AT_NVAL_NLD Number(32,11) DECIMAL(31,11) NOT NULL Numeric Value
9 SSR_RI_AT_DVAL_NLD Date(10) DATE Date Value
10 SSR_RI_AT_LVAL_NLD Long Character CLOB Text Value
11 SSR_RI_EPV_COD_NLD Character(12) VARCHAR2(12) NOT NULL Educational Provider Code