| # |
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
Default Value: 0
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: PER_ORG_ASGN_VW.HIRE_DT
|
| 4 |
GPDE_TX_SCHEDULE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Schedule
A=Tax Schedule A
B=Tax Schedule B
C=Tax Schedule B(on Application)
C=Tax Schedule B(on Application)
Default Value: A
|
| 5 |
GPDE_TX_CHAMBSTATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Chamber State
00=none
01=Bremen
02=Saarland
03=Bremen BC
|
| 6 |
GPDE_TX_METHOD_OVD |
Character(1) |
VARCHAR2(1) NOT NULL |
Monthly Adjustment
Y/N Table Edit
Default Value: N
|
| 7 |
GPDE_TX_RECALC_OVD |
Character(1) |
VARCHAR2(1) NOT NULL |
Annual Adjustment
Y/N Table Edit
Default Value: Y
|
| 8 |
GPDE_TX_CHRCH_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Church Annual
Y/N Table Edit
Default Value: Y
|
| 9 |
GPDE_TX_CRD_CONFRM |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Card Received
Y/N Table Edit
Default Value: N
|
| 10 |
GPDE_TX_YR_CLS_DT |
Date(10) |
DATE |
Tax Card Closed On
|
| 11 |
GPDE_TX_INC_TX_CLS |
Character(2) |
VARCHAR2(2) NOT NULL |
Tax Class
0=None
1=Tax Class I
2=Tax Class II
3=Tax Class III
4=Tax Class IV
5=Tax Class V
6=Tax Class VI
|
| 12 |
GPDE_TX_NUM_CHILD |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Number of Children
|
| 13 |
GPDE_TX_EXEMPT_MON |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Exemption Monthly
|
| 14 |
GPDE_TX_EXEMON_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
Monthly Exemption Currency
Default Value: DEM
Prompt Table:
CURRENCY_CD_TBL
|
| 15 |
GPDE_TX_EXEMPT_ANN |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Exemption Annually
|
| 16 |
GPDE_TX_EXEANN_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
Annual Exemption Currency
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 17 |
GPDE_TX_ADDGRS_ANN |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
Additional Taxgross for the Employee from another Employment for Bonus and Adjustment Taxcalculation
|
| 18 |
GPDE_TX_ADDGRS_MON |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
Additional Taxgross for the Employee from another Employment for Monthly Tax Calculation
|
| 19 |
GPDE_TX_HOME_CD |
Character(30) |
VARCHAR2(30) NOT NULL |
Locality
Prompt Table:
GPDE_TX_AGSC_VW
|
| 20 |
GPDE_TX_AGS_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Municipality Code for GP Germany.
Prompt Table:
GPDE_TX_AGSN_VW
|
| 21 |
GPDE_AL_FINANCE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Tax Office
Prompt Table:
GPDE_TX_FINOFC
|
| 22 |
GPDE_TX_SPCL_EXMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Status
1=Unlimited Tax Liability
2=Short-Term Employment
3=Casual Worker
4=Non Taxable
5=Swiss Border Worker
6=Limited Tax Liability
7=Unlimited Tax Liability (DBA)
8=Unlimitied Tax Liability (ATE)
9=Insig Emplymnt Lmpsm 2% ER
9=Insig Emplymnt Lmpsm 2% ER
A=Insig Emplymnt Lmpsm 2% EE
A=Insig Emplymnt Lmpsm 2% EE
B=Border Worker Belgium
G=Border Worker (non Taxable)
Default Value: 1
|
| 23 |
GPDE_TX_RELIGION |
Character(3) |
VARCHAR2(3) NOT NULL |
Religion
00=No confession
01=Roman Catholic
02=Old Catholic
03=Evangical Lutheran
04=Evangical Ref.
05=French Reform i.0.
06=Free Religion Baden
07=Israelite
08=Religion Tax Rheinland Pfalz
09=Free Religion Offenbach
10=Free Religion Mainz
11=Israelite Religion Baden
12=Israelite Religion Wurttemberg
13=Israelite Religion Frankfurt/M
14=Israelite Religion Country
15=Free Religion Pfalz
16=Free Religion Comunity Alzey
17=Jewish Culture Tax HH
18=Jewish Culture Tax SH
|
| 24 |
GPDE_TX_SPOUSE_REL |
Character(3) |
VARCHAR2(3) NOT NULL |
Religion Spouse
00=No confession
01=Roman Catholic
02=Old Catholic
03=Evangical Lutheran
04=Evangical Ref
05=French Reform i.O.
06=Free Religion Baden
07=Israelite
08=Religion Tax Rheinland Pfalz
09=Free Religion Offenbach
10=Free Religion Mainz
11=Israelite Religion Baden
12=Israelite Religion Wurttemberg
13=Israelite Religion Frankfurt/M
14=Israelite Religion Country
15=Free Religion Pfalz
16=Free Religion Comunity Alzey
17=Jewish Culture Tax HH
18=Jewish Culture Tax SH
|
| 25 |
GPDE_BL_START_DT |
Date(10) |
DATE NOT NULL |
Tax Card Start Date
Default Value: GPDE_TX_DATA.EFFDT
|
| 26 |
GPDE_KU_BEN_GRP |
Character(1) |
VARCHAR2(1) NOT NULL |
KUG Benefit Group
A=Tax Class I and IV
B=Tax Class II
C=Tax Class III
D=Tax Class V
E=Tax Class VI
Default Value: A
|
| 27 |
GPDE_KU_BEN_STP |
Character(1) |
VARCHAR2(1) NOT NULL |
KUG Benefit Step
1=With Children
2=Without Children
Default Value: 2
|
| 28 |
GPDE_TX_ACCM_TRANS |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Card Received
Y/N Table Edit
|
| 29 |
GPDE_TX_NOPRV_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Card Received
Y/N Table Edit
|
| 30 |
GPDE_TX_CO_CURR |
Character(3) |
VARCHAR2(3) NOT NULL |
Carryover Currency
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 31 |
GPDE_TX_NOI_CO |
Signed Number(14,4) |
DECIMAL(12,4) NOT NULL |
Number of Work Interruptions
|
| 32 |
GPDE_TX_GROSS_CO |
Signed Number(14,4) |
DECIMAL(12,4) NOT NULL |
Taxable Gross
|
| 33 |
GPDE_TX_GRSTX_CO |
Signed Number(14,4) |
DECIMAL(12,4) NOT NULL |
Income Tax
|
| 34 |
GPDE_TX_SOLZ_CO |
Signed Number(14,4) |
DECIMAL(12,4) NOT NULL |
Solidarity Tax
|
| 35 |
GPDE_TX_CHEE_CO |
Signed Number(14,4) |
DECIMAL(12,4) NOT NULL |
Church Tax Employee
|
| 36 |
GPDE_TX_CHSP_CO |
Signed Number(14,4) |
DECIMAL(12,4) NOT NULL |
Church Tax Spouse
|
| 37 |
GPDE_TX_PENS_CO |
Signed Number(14,4) |
DECIMAL(12,4) NOT NULL |
Pension Gross within Tax Gross
|
| 38 |
GPDE_TX_MYPENS_CO |
Signed Number(14,4) |
DECIMAL(12,4) NOT NULL |
Multiple Year Pension Gross
|
| 39 |
GPDE_TX_MYTX_CO |
Signed Number(14,4) |
DECIMAL(12,4) NOT NULL |
Multiple Year Taxable Gross
|
| 40 |
GPDE_TX_KUG_CO |
Signed Number(14,4) |
DECIMAL(12,4) NOT NULL |
KUG, SWG, Maternity Earnings
|
| 41 |
GPDE_TX_ATZ_CO |
Signed Number(14,4) |
DECIMAL(12,4) NOT NULL |
Old Age Part-Time Earnings
|
| 42 |
GPDE_TX_DBA_CO |
Signed Number(14,4) |
DECIMAL(12,4) NOT NULL |
DBA Earnings
|
| 43 |
GPDE_TX_ATE_CO |
Signed Number(14,4) |
DECIMAL(12,4) NOT NULL |
ATE Earnings
|
| 44 |
GPDE_ETIN_NUMBER |
Character(14) |
VARCHAR2(14) NOT NULL |
eTIN Number- a unique tax number for each employed person in Germany.
Loosely, the eTIN number is broken down into these sections:
4 characters representing the last name
4 characters representing the first name
2 numbers representing the birth year
1 character representing the birth month (A-L)
2 numbers representing the birth day
And the last digit is a generated letter (A-Z) based on all the other letters.
|
| 45 |
GPDE_ELSTER_TKT |
Character(20) |
VARCHAR2(20) NOT NULL |
Ticket number returned from ELSTER messaging process representing a particular group of tax statement data sent to ELSTER.
|
| 46 |
GPDE_XML_TAX_INFO |
Long Character |
CLOB |
This field represents a push button to view the XML tax data info for the Global Payroll Germany's new ELSTER tax process.
|
| 47 |
GPDE_TX_FACTOR |
Number(5,3) |
DECIMAL(4,3) NOT NULL |
Number of Children
|
| 48 |
GPDE_TX_PKPV |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Exemption Monthly
|
| 49 |
GPDE_TX_TAXID |
Character(11) |
VARCHAR2(11) NOT NULL |
eTIN Number- a unique tax number for each employed person in Germany.
Loosely, the eTIN number is broken down into these sections:
4 characters representing the last name
4 characters representing the first name
2 numbers representing the birth year
1 character representing the birth month (A-L)
2 numbers representing the birth day
And the last digit is a generated letter (A-Z) based on all the other letters.
|