INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
SSR_HE_EXT_SYSSSR_HE_EXSYS_VW(SQL View) |
Index Back |
|---|
| SELECT A.INSTITUTION , A.SSR_HE_EXT_SYS , ( SELECT B.DESCR FROM PS_SCC_EXT_SYS_TBL B WHERE B.SCC_EXTERNAL_SYS=A.SSR_HE_EXT_SYS) FROM PS_SSR_HE_CONFIG A UNION SELECT A.INSTITUTION , A.SCC_EXTERNAL_SYS , ( SELECT B.DESCR FROM PS_SCC_EXT_SYS_TBL B WHERE B.SCC_EXTERNAL_SYS=A.SCC_EXTERNAL_SYS) FROM PS_SSR_HE_CONFIG A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION |
| 2 | SSR_HE_EXT_SYS |
Character(3) | VARCHAR2(3) NOT NULL | SID External System |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |