INSTITUTIONSSR_HE_RET_NAMESSR_HE_CONTACTTYPEPrompt Table: SSR_HE_CNTYP_VW
SSR_HE_EMAIL_TYPEPrompt Table: SSR_HE_ADTYP_VW
SSR_HE_RET_CTE(SQL Table) |
Index Back |
|---|---|
Return email 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 | SSR_HE_EMAIL_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
HESA Email type
Prompt Table: SSR_HE_ADTYP_VW |