EMPLIDPrompt Table: GVT_PERSONAL_VW
EMPL_RCDEFFDTDefault Value: %date
EFFSEQDEPENDENT_IDPrompt Table: DEPENDENT_VW
COUNTRYDefault Value: USA
Prompt Table: COUNTRY_TBL
Prompt Table:
CITIZEN_STS_TBL
Set Control Field: COUNTRY
GVT_CITIZENSHIP(SQL Table) |
Index Back |
|---|---|
GVT EE/Dependent CitizenshipUse CITIZENSHIP to record an employee's or dependent's country of citizenship. This record is used for Federal and mimics the Citizenship record, but is different in that it includes EMPL_RCD,EFFDT and EFFSEQ as part of the key. This was done to make Citizenship a child of GVT_PERS_DATA. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: GVT_PERSONAL_VW |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | DEPENDENT_ID |
Character(2) | VARCHAR2(2) NOT NULL |
Dependent ID
Prompt Table: DEPENDENT_VW |
| 6 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: USA Prompt Table: COUNTRY_TBL |
| 7 | CITIZENSHIP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Citizenship Status
Prompt Table:
CITIZEN_STS_TBL
|