SSR_RI_OPDV_NLD

(SQL View)
 Index Back

Current View (prog/coh attr)

(off. Progr. Cohort attributes) /* 2021-10-06: fix for Bug-ID: 32929597 - RIOv3 */

SELECT A.INSTITUTION , A.SSR_RIO_PRG_UUID , A.SSR_RI_COH_COD_NLD ,'opleidingsvorm' AS SSR_RI_AT_NAME_NLD ,B.SSR_STUDY_MTHD_NLD AS SSR_RI_AT_VAL_NLD ,'' ,'' ,0 ,%DateNull ,'' ,10 ,B.SSR_STUDY_MTHD_NLD AS SSR_BR_FIELDVL_NLD ,X.XLATLONGNAME AS SSR_BR_XMLVL_NLD ,'02' AS SSR_RI_ATRTYPE_NLD FROM %Table(SSR_RI_OPCV_NLD) A JOIN %Table(TERM_TBL) TT ON A.STRM = TT.STRM AND A.ACAD_CAREER = TT.ACAD_CAREER JOIN %Table(SCC_CMPCHRT_NLD) B ON (A.STRM %Concat '-' %Concat B.SSR_COHORT_ID) = A.SSR_RI_COH_COD_NLD JOIN %Table(PSXLATITEM) X ON X.FIELDNAME = 'SSR_STUDY_MTHD_NLD' AND B.SSR_STUDY_MTHD_NLD = X.FIELDVALUE JOIN %Table(SSR_RIO_PRG_NLD) B1 ON B.ACAD_PROG = B1.ACAD_PROG AND B.CAMPUS = B1.CAMPUS AND B.ACAD_LOAD_APPR = B1.ACAD_LOAD_APPR WHERE A.SSR_RIO_PRG_UUID = B1.SSR_RIO_PRG_UUID AND %EffdtCheck(SCC_CMPCHRT_NLD B_ED,B,TT.TERM_BEGIN_DT) UNION SELECT A.INSTITUTION , A.SSR_RIO_PRG_UUID , A.SSR_RI_COH_COD_NLD ,'deelnemersplaatsen' AS SSR_RI_AT_NAME_NLD ,%NumToChar(B.SSR_NUM_STDNTS_NLD) AS SSR_RI_AT_VAL_NLD ,'' ,'' ,0 ,%DateNull ,'' ,11 ,%NumToChar(B.SSR_NUM_STDNTS_NLD) AS SSR_BR_FIELDVL_NLD ,%NumToChar(B.SSR_NUM_STDNTS_NLD) AS SSR_BR_XMLVL_NLD ,'04' AS SSR_RI_ATRTYPE_NLD FROM %Table(SSR_RI_OPCV_NLD) A JOIN %Table(TERM_TBL) TT ON A.STRM = TT.STRM AND A.ACAD_CAREER = TT.ACAD_CAREER JOIN %Table(SCC_CMPCHRT_NLD) B ON (A.STRM %Concat '-' %Concat B.SSR_COHORT_ID) = A.SSR_RI_COH_COD_NLD JOIN %Table(SSR_RIO_PRG_NLD) B1 ON B.ACAD_PROG = B1.ACAD_PROG AND B.CAMPUS = B1.CAMPUS AND B.ACAD_LOAD_APPR = B1.ACAD_LOAD_APPR WHERE A.SSR_RIO_PRG_UUID = B1.SSR_RIO_PRG_UUID AND %EffdtCheck(SCC_CMPCHRT_NLD B_ED,B,TT.TERM_BEGIN_DT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 SSR_RIO_PRG_UUID Character(50) VARCHAR2(50) NOT NULL Program UUID
3 SSR_RI_COH_COD_NLD Character(20) VARCHAR2(20) NOT NULL Cohort Tag
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 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
12 SSR_BR_FIELDVL_NLD Character(254) VARCHAR2(254) NOT NULL /* 2021-10-13: fix for Bug-ID: 32929597 - RIOv3 */
13 SSR_BR_XMLVL_NLD Long Character CLOB /* 2021-10-13: fix for Bug-ID: 32929597 - RIOv3 */ Converted to long.
14 SSR_RI_ATRTYPE_NLD Character(2) VARCHAR2(2) NOT NULL RIO Attribute Type /* 2021-10-13: fix for Bug-ID: 32929597 - RIOv3 */ Additional translate value 06.
01=Text
02=Enumeration
03=Date
04=Number
05=Boolean
06=Long text