INSTITUTIONSSR_HE_RET_NAMESSR_HE_PRORETVW(SQL View) |
Index Back |
|---|
| SELECT institution , ssr_he_ret_name , ssr_he_ret_type , ssr_he_prd_code FROM PS_SSR_HE_INST_HER WHERE ssr_he_ret_type= 'OFFSHORE' AND SSR_HE_ACTIVE='Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | SSR_HE_RET_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Return Name |
| 3 | SSR_HE_RET_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Return Type |
| 4 | SSR_HE_PRD_CODE | Character(10) | VARCHAR2(10) NOT NULL | Reporting Period |