| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 4 |
GPCH_TX_CANTON |
Character(2) |
VARCHAR2(2) NOT NULL |
Canton
Prompt Table:
GPCH_TX_CANT_VW
|
| 5 |
GPCH_TX_VILLAGE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Municipality Code
Prompt Table:
GPCH_TX_MNPL_VW
|
| 6 |
CITIZENSHIP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Citizenship Status
Default Value: GPCH_CTZN_VW.CITIZENSHIP_STATUS
Prompt Table:
GPCH_CITIZEN_VW
|
| 7 |
GPCH_TX_EXEMPT_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Exempt from Withholding Tax
Y/N Table Edit
Default Value: N
|
| 8 |
EXPIRATN_DT |
Date(10) |
DATE |
Expiration Date
|
| 9 |
COUNTRY_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
From Country
Prompt Table:
COUNTRY_TBL
|
| 10 |
GPCH_TX_TRF_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tariff Group
A=A Single Person
B=B Sole Earner (Married)
C=C Double Earner
D=D Secondary Occupation
K=K Cohabitants GR Only
L=I1 Spouse Intl Function 0.5 GE
M=I2 Spouse Intl Function 1.0 GE
N=I3 Spouse Intl Function 1.5 GE
O=I4 Spouse Intl Function 2.0 GE
V=V Double Earner (Female) VD
|
| 11 |
GPCH_TX_NUM_CHILD |
Character(1) |
VARCHAR2(1) NOT NULL |
Number of Children
|
| 12 |
GPCH_TX_CHRCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Church Tax
1=Including Church Tax
2=Excluding Church Tax
|
| 13 |
GPCH_TX_TRF_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Withholding Tax Tariff
Prompt Table:
%RECNAME_EDIT
|
| 14 |
GPCH_TX_OVRD_TARIF |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Tariff
Y/N Table Edit
Default Value: N
|
| 15 |
GPCH_TX_OVRD_AMT |
Number(11,4) |
DECIMAL(10,4) NOT NULL |
Override Tax Amount
|
| 16 |
GPCH_TX_OVRD_PCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Override Percent
|
| 17 |
GPCH_TX_QS_PROVED |
Character(1) |
VARCHAR2(1) NOT NULL |
ST Status Proved
Y/N Table Edit
Default Value: N
|
| 18 |
GPCH_TX_VALID_TODT |
Date(10) |
DATE |
Valid to Date
|
| 19 |
GPCH_GR_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override
Y/N Table Edit
Default Value: N
|
| 20 |
GPCH_TX_QS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Exempt From Source Tax
Y/N Table Edit
Default Value: N
|
| 21 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 22 |
GPCH_TX_EST_YRLY |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Estimated yearly income for source tax
Default Value: 0
|
| 23 |
GPCH_TX_SPOUSE_WL |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether spouse works in Switzerland. Required for Source Tax GE and TI
0=No
1=Works in Switzerland
2=Works in Geneva
3=Works outside Switzerland
Default Value: 0
|
| 24 |
GPCH_TX_SEX_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Source Tax Gender Override
F=Female
M=Male
|
| 25 |
GPCH_TX_VD_ID |
Number(9,0) |
DECIMAL(9) NOT NULL |
VD Source TAX ID
|
| 26 |
GPCH_TX_VD_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Source TAX Event
A=A-Hire
B=B-Termination
C=C-Marriage
D=D-BeginAllowance
E=E-EndAllowance
F=F-FTE change
G=G-separated
H=H-divorced
I=I-Death
|
| 27 |
GPCH_BEGIN_DATE |
Date(10) |
DATE |
Begin Date
|
| 28 |
COMMENTS |
Long Character |
CLOB |
Comment
|