| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON
|
| 4 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 5 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 6 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 7 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 8 |
ORIG_CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Original Calendar Group ID
|
| 9 |
RSLT_SEG_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Result Segment Number
|
| 10 |
SEG_END_DT |
Date(10) |
DATE |
Payee Process Segment's End Date
|
| 11 |
SEG_BGN_DT |
Date(10) |
DATE |
Payee Process Segment's Begin Date
|
| 12 |
PRD_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 13 |
PRD_BGN_DT |
Date(10) |
DATE |
Period Begin Date
|
| 14 |
PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
|
| 15 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 16 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 17 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 18 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL
|
| 19 |
REASON |
Character(30) |
VARCHAR2(30) NOT NULL |
Reason
|
| 20 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
|
| 21 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
|
| 22 |
STEP |
Number(2,0) |
SMALLINT NOT NULL |
Step
|
| 23 |
STD_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours
|
| 24 |
EMPL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration
|
| 25 |
EMPL_CTG |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Category
|
| 26 |
EMPL_CTG_L1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory
|
| 27 |
PERFORM_GROUP_GER |
Character(2) |
VARCHAR2(2) NOT NULL |
Performance Group
A1=Blue Collar Performance Grp. 1
A2=Blue Collar Performance Grp. 2
A3=Blue Collar Performance Grp. 3
K1=Commercial White Collar Grp. 1
K2=Commercial White Collar Grp. 2
K3=Commercial White Collar Grp. 3
K4=Commercial White Collar Grp. 4
K5=Commerical White Collar Grp. 5
T1=Technical White Collar Grp. 1
T2=Technical White Collar Grp. 2
T3=Technical White Collar Grp. 3
T4=Technical White Collar Grp. 4
T5=Technical White Collar Grp. 5
|
| 28 |
JOB_ENTRY_DT |
Date(10) |
DATE |
Job Entry Date
|
| 29 |
HIRE_DT |
Date(10) |
DATE |
First Start Date
|
| 30 |
TERMINATION_DT |
Date(10) |
DATE |
Termination Date
|
| 31 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 32 |
MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
|
| 33 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
|
| 34 |
GPDE_AL_CPAY_ENDDT |
Date(10) |
DATE |
Current Pay End Date
|
| 35 |
GPDE_TX_PAY_EFFDT |
Date(10) |
DATE |
Pay Date
|
| 36 |
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)
|
| 37 |
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
|
| 38 |
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)
|
| 39 |
GPDE_TX_NUM_CHILD |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Number of Children
|
| 40 |
GPDE_TX_EXEMPT_ANN |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Exemption Annually
|
| 41 |
GPDE_TX_EXEMPT_MON |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Exemption Monthly
|
| 42 |
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
|
| 43 |
GPDE_TX_ADDGRS_MON |
Number(13,2) |
DECIMAL(12,2) NOT NULL |
Additional Taxgross for the Employee from another Employment for Monthly Tax Calculation
|
| 44 |
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
|
| 45 |
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
|
| 46 |
GPDE_TX_CHRCHSTATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Church State
01=Schleswig-Holstein
02=Hamburg
03=Niedersachsen 9 %
04=Bremen
05=Nordrhein-Westfalen
06=Hessen
07=Rheinland-Pfalz
08=Baden-Wurtemberg
09=Bayern
10=Saarland
11=Berlin
12=Brandenburg
13=Mecklenburg-Vorpommern
14=Sachsen
15=Sachsen-Anhalt
16=Thuringen
17=Stadt Bremerhaven
18=Oberfinanzdirektion Kiel
93=Niedersachsen 8 %
|
| 47 |
GPDE_TX_CHAMBSTATE |
Character(2) |
VARCHAR2(2) NOT NULL |
Chamber State
00=none
01=Bremen
02=Saarland
03=Bremen BC
|
| 48 |
GPDE_TX_ACCM_TRANS |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Card Received
|
| 49 |
GPDE_TX_NOPRV_EMPL |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Card Received
|
| 50 |
GPDE_TX_RECALC_OVD |
Character(1) |
VARCHAR2(1) NOT NULL |
Annual Adjustment
|
| 51 |
GPDE_TX_METHOD_OVD |
Character(1) |
VARCHAR2(1) NOT NULL |
Monthly Adjustment
|
| 52 |
GPDE_TX_CHRCH_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Church Annual
|
| 53 |
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
|
| 54 |
GPDE_KU_BEN_STP |
Character(1) |
VARCHAR2(1) NOT NULL |
KUG Benefit Step
1=With Children
2=Without Children
|
| 55 |
GPDE_TX_UNIT |
Character(6) |
VARCHAR2(6) NOT NULL |
Tax Unit
Prompt Table:
GPDE_TX_UNIT
|
| 56 |
GPDE_TX_CHAMBER_BR |
Character(6) |
VARCHAR2(6) NOT NULL |
Tax Chamber Bremen
Prompt Table:
GPDE_TX_UNIT
|
| 57 |
GPDE_TX_CHAMBER_SA |
Character(6) |
VARCHAR2(6) NOT NULL |
Tax Chamber Saarland
Prompt Table:
GPDE_TX_UNIT
|
| 58 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 59 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 60 |
GPDE_ASOF_DT_EX_RT |
Date(10) |
DATE |
Exchange Rate Date
|
| 61 |
FTE |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
This field represent Full Time Equivalence
|
| 62 |
GPDE_TX_HOME_CD |
Character(30) |
VARCHAR2(30) NOT NULL |
Locality
|
| 63 |
GPDE_TX_AGS_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Municipality Code for GP Germany.
|
| 64 |
GPDE_AL_FINANCE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Tax Office
Prompt Table:
GPDE_TX_FINOFC
|
| 65 |
NATIONALITY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Nationality Code
|
| 66 |
NATIONALITY |
Character(30) |
VARCHAR2(30) NOT NULL |
Nationality
|
| 67 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department SetID
|
| 68 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location SetID
|
| 69 |
WC_COUNCIL_ID |
Character(9) |
VARCHAR2(9) NOT NULL |
Works Council ID
|
| 70 |
GPDE_TX_VBEZ_DT |
Date(10) |
DATE |
Begin Date
|
| 71 |
GPDE_TX_VBEZM |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Exemption Monthly
|
| 72 |
GPDE_TX_VBEZS |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Exemption Monthly
|
| 73 |
GPDE_TX_VBEZB |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Exemption Monthly
|
| 74 |
GPDE_TX_ZMVB |
Number(2,0) |
SMALLINT NOT NULL |
Exemption Monthly
|