INSTITUTIONSSR_HE_RET_NAMESSR_HE_CONTACTTYPEPrompt Table: SSR_HE_CNTYP_VW
SCC_HE_ADDR_TYPEPrompt Table: ADDRESS_TYP_TBL
SSR_HE_RET_CTA(SQL Table) |
Index Back |
|---|---|
Return contact address types |
| # | 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_CONTACTTYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Contact Type
Prompt Table: SSR_HE_CNTYP_VW |
| 4 | SCC_HE_ADDR_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Address Type
Prompt Table: ADDRESS_TYP_TBL |