INSTITUTIONSSR_RI_EUN_BND(SQL View) |
Index Back |
|---|---|
Pop Select Bind Edu Unit |
| SELECT DEL.INSTITUTION ,DEL.SSR_RI_EUN_COD_NLD FROM PS_SSR_RI_MEUN_NLD DEL UNION SELECT DISTINCT A.INSTITUTION , A.SSR_RI_EUN_COD_NLD FROM %Table(SSR_RI_EDUNT_NL) A WHERE %EffdtCheck(SSR_RI_EDUNT_NL A_ED, A, %CURRENTDATEIN) |
| # | 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 |