INSTITUTIONPrompt Table: INSTITUTION_TBL
SEXF=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
Prompt Table: SSR_HE_GENDERVW
Prompt Table: SSR_HE_CODE_VW
Y/N Table Edit
Default Value: Y
Prompt Table: SCC_HE_SEXO_VW
SCC_HE_GENDER(SQL Table) |
Index Back |
|---|---|
Gender 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 | SEX |
Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec Prompt Table: SSR_HE_GENDERVW |
| 3 | SSR_HE_SEXID | Character(30) | VARCHAR2(30) NOT NULL |
HESA SEXID
Prompt Table: SSR_HE_CODE_VW |
| 4 | SSR_HE_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Active
Y/N Table Edit Default Value: Y |
| 5 | SCC_HE_SEXIDS | Character(30) | VARCHAR2(30) NOT NULL |
HESA Sex Identifier
Prompt Table: SCC_HE_SEXO_VW |