EMPLIDEMPL_RCDDefault Value: N
Default Value: N
Default Value: N
Default Value: N
Default Value: N
Prompt Table: GP_PYENT
0=Cumulative
1=Week 1/Month 1
Prompt Table: PERSON_ADDRESS
GPGB_EXPAT(SQL Table) |
Index Back |
|---|---|
P46 Expat InformationThe record is used to hold the details of employees seconded to work in UK (Expats) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | START_DATE | Date(10) | DATE NOT NULL | Start Date for Gen Standing PO |
| 4 | GPGB_CITIZEN | Character(1) | VARCHAR2(1) NOT NULL |
To determine if European Economic Area or Commoweath citizen
Default Value: N |
| 5 | GPGB_P45_STLOAN | Character(1) | VARCHAR2(1) NOT NULL | Continue Student Loan Deductions from P45. |
| 6 | GPGB_P46_STATMNTA | Character(1) | VARCHAR2(1) NOT NULL |
P46 - Statement A
Default Value: N |
| 7 | GPGB_P46_STATMNTB | Character(1) | VARCHAR2(1) NOT NULL |
P46 - Statement B
Default Value: N |
| 8 | GPGB_P46_STATMNTC | Character(1) | VARCHAR2(1) NOT NULL |
P46 - Statement C
Default Value: N |
| 9 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 10 | GPGB_EPM6_IND | Character(1) | VARCHAR2(1) NOT NULL |
EPM6 (Modified Scheme) Indicator
Default Value: N |
| 11 | PAY_ENTITY | Character(10) | VARCHAR2(10) NOT NULL |
Pay Entity
Prompt Table: GP_PYENT |
| 12 | TAXCODE_UK | Character(15) | VARCHAR2(15) NOT NULL | Tax Code |
| 13 | TAX_BASIS_UK | Character(1) | VARCHAR2(1) NOT NULL |
Tax Basis
0=Cumulative 1=Week 1/Month 1 |
| 14 | ADDRESS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Address Type
Prompt Table: PERSON_ADDRESS |
| 15 | GPGB_EDI_REF | Number(14,0) | DECIMAL(14) NOT NULL | GPUK EDI stores EDI transaction number |