INSTITUTIONSSR_HE_LOCIDSSR_HE_LOC_VW(SQL View) |
Index Back |
|---|---|
KIS Location ViewKIS Location View |
| SELECT l.institution , l.ssr_he_locid , l.ssr_he_locname FROM PS_SSR_HE_LOCN l WHERE l.EFFDT=( SELECT MAX(EFFDT) FROM PS_SSR_HE_LOCN WHERE INSTITUTION=l.INSTITUTION ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SSR_HE_LOCID |
Character(2) | VARCHAR2(2) NOT NULL | Location ID |
| 3 | SSR_HE_LOCNAME | Character(100) | VARCHAR2(100) NOT NULL | Location Name |