INSTITUTIONSSR_RI_EUN_COD_NLDACAD_PROGSSR_RI_EUN_ST_DTCTHR=Contact hours
ECTS=ECTS
HOUR=Hours
SBU=Study load hours
STPT=Study points
SSR_RI_EUPV_NLD(SQL View) |
Index Back |
|---|---|
Edu Unit Period Current View |
| SELECT E.INSTITUTION , E.SSR_RI_EUN_COD_NLD , ' ' AS ACAD_PROG , E.EFFDT , E.DESCR , E.DESCR200 , CASE WHEN E1.LANGUAGE_CD = 'ENG' THEN E1.DESCR200 ELSE ' ' END , E.SSR_RI_LD_UNT_NLD , E.SSR_RI_LOAD_NLD , CAST(E.DESCRLONG AS VARCHAR(3000)) FROM PS_SSR_RI_EDUNT_NL E LEFT OUTER JOIN PS_SSR_RI_EDUNTLNG E1 ON E.SSR_RI_EUN_COD_NLD = E1.SSR_RI_EUN_COD_NLD AND E1.LANGUAGE_CD = 'ENG' AND E.EFFDT = E1.EFFDT WHERE E.EFFDT >= ( SELECT MIN(E_ED1.EFFDT) FROM PS_SSR_RI_EDUNT_NL E_ED1 WHERE E_ED1.SSR_RI_EUN_COD_NLD = E.SSR_RI_EUN_COD_NLD AND E_ED1.EFF_STATUS = 'A') AND E.EFFDT <= ( SELECT MAX(E_ED.EFFDT) FROM PS_SSR_RI_EDUNT_NL E_ED WHERE E_ED.SSR_RI_EUN_COD_NLD = E.SSR_RI_EUN_COD_NLD AND E_ED.effdt <= %CurrentDateIn) AND E.EFF_STATUS = 'A' UNION SELECT B.INSTITUTION , A.SSR_RI_EUN_COD_NLD , B.ACAD_PROG , B.EFFDT , B.DESCR , %Coalesce(RTRIM(A.SSR_DESC200_NLD) ,B.DESCR) , ' ' , ' ' , 0 , CAST('' AS VARCHAR(3000)) AS SSR_RI_EDU_LNM_NLD FROM %Table(SSR_PRG_NRM_NLD) A JOIN %Table(ACAD_PROG_TBL) B ON A.INSTITUTION = B.INSTITUTION AND A.ACAD_PROG = B.ACAD_PROG AND A.EFFDT = B.EFFDT JOIN %Table(SCC_CMPLOAD_NLD) CL ON B.ACAD_PROG = CL.ACAD_PROG AND B.EFFDT = CL.EFFDT WHERE B.EFFDT >= ( SELECT MIN(B_ED.EFFDT) FROM PS_ACAD_PROG_TBL B_ED WHERE B_ED.ACAD_PROG = B.ACAD_PROG AND B_ED.EFF_STATUS = 'A') AND B.EFFDT <= ( SELECT MAX(B_ED.EFFDT) FROM PS_ACAD_PROG_TBL B_ED WHERE B_ED.ACAD_PROG = B.ACAD_PROG AND B_ED.effdt <= %CurrentDateIn) AND B.EFFDT NOT IN ( SELECT B_IED.EFFDT FROM PS_ACAD_PROG_TBL B_IED WHERE B_IED.ACAD_PROG = B.ACAD_PROG AND B_IED.EFFDT = ( SELECT MAX(B_IED1.EFFDT) FROM PS_ACAD_PROG_TBL B_IED1 WHERE B_IED1.ACAD_PROG = B_IED.ACAD_PROG AND B_IED1.EFFDT > ( SELECT MAX(B_EDX.EFFDT) FROM PS_ACAD_PROG_TBL B_EDX WHERE B_EDX.ACAD_PROG = B.ACAD_PROG AND B_EDX.EFF_STATUS = 'A' AND B_EDX.EFFDT <= %CurrentDateIn ) AND B_IED1.EFF_STATUS = 'I' AND B_IED1.EFFDT <= %CurrentDateIn) ) AND B.HEGIS_CODE = ' ' AND CL.SSR_RIO_YN_NLD = 'Y' AND A.SSR_RI_EUN_COD_NLD NOT IN ( SELECT SSR_RI_EUN_COD_NLD FROM %Table(SSR_RI_EDUNT_NL)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SSR_RI_EUN_COD_NLD |
Character(12) | VARCHAR2(12) NOT NULL | RIO STAP Educational Unit Code |
| 3 | ACAD_PROG |
Character(5) | VARCHAR2(5) NOT NULL | Academic Program |
| 4 | SSR_RI_EUN_ST_DT |
Date(10) | DATE | RIO STAP Educational Unit Start Date |
| 5 | SSR_RI_EDU_SNM_NLD | Character(30) | VARCHAR2(30) NOT NULL | Edu unit short name |
| 6 | SSR_RI_DSC225_NLD | Character(225) | VARCHAR2(225) NOT NULL | Description |
| 7 | SSR_RI_DSC225E_NLD | Character(225) | VARCHAR2(225) NOT NULL | Description Language(ENG) |
| 8 | SSR_RI_LD_UNT_NLD | Character(4) | VARCHAR2(4) NOT NULL |
RIO STAP Academic Load Unit
CTHR=Contact hours ECTS=ECTS HOUR=Hours SBU=Study load hours STPT=Study points |
| 9 | SSR_RI_LOAD_NLD | Number(5,0) | INTEGER NOT NULL | RIO STAP Academic Study Load |
| 10 | SSR_RI_EDU_LNM_NLD | Long Character | CLOB | Edu unit long name |