INSTITUTIONPrompt Table: INSTITUTION_TBL
COUNTRYPrompt Table: COUNTRY_TBL
Prompt Table: SSR_HE_CODE_VW
Prompt Table: SSR_HE_CODE_VW
Y/N Table Edit
Default Value: Y
SCC_HE_NATIONAL(SQL Table) |
Index Back |
|---|---|
Nationality Mappings |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 3 | SCC_HE_NATIONALITY | Character(30) | VARCHAR2(30) NOT NULL |
HESA Nationality
Prompt Table: SSR_HE_CODE_VW |
| 4 | SCC_HE_DOMICILE | Character(30) | VARCHAR2(30) NOT NULL |
HESA Domicile
Prompt Table: SSR_HE_CODE_VW |
| 5 | SSR_HE_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Active
Y/N Table Edit Default Value: Y |