| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Calendar Run Id
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 4 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 5 |
CAL_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
calendar id
|
| 6 |
ORIG_CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Original Calendar Group ID
|
| 7 |
RSLT_SEG_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Result Segment Number
|
| 8 |
SEG_END_DT |
Date(10) |
DATE |
Payee Process Segment's End Date
|
| 9 |
GPDE_AL_LINE_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
GPDE_AL_LINE_ID
|
| 10 |
PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
|
| 11 |
PRD_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 12 |
GPDE_AL_CPAY_ENDDT |
Date(10) |
DATE |
Current Pay End Date
|
| 13 |
GPDE_BV_EE_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
BVV Membership Number
|
| 14 |
GPDE_BV_PRVDR_NBR |
Number(4,0) |
SMALLINT NOT NULL |
BVV Provider Number
|
| 15 |
GPDE_BV_HIRE_DT |
Date(10) |
DATE |
BVV Hire Date
|
| 16 |
GPDE_BV_SNRTY_DT |
Date(10) |
DATE |
BVV Seniority Date
|
| 17 |
GPDE_BV_TRMNTN_DT |
Date(10) |
DATE |
Termination Date
|
| 18 |
GPDE_BV_PRMNNT_CLM |
Date(10) |
DATE |
Permanent Claim
|
| 19 |
GPDE_BV_PRCS_TYP |
Character(2) |
VARCHAR2(2) NOT NULL |
BVV Verarbeitungsmerkmal
01=01 Maternity Leave
02=02 Rehire Commitment
03=03 Temporary Soldier
04=04 Unpaid Leave
05=05 End of Sick Pay
06=06 Suspension without Senority
07=07 Change to Part Time
08=08 Accepted Pre-Senority
11=11 Death
12=12 Disability Retirement
13=13 Old Age Retirement
14=14 End of Company Seniority
15=15 Transfer to Group
16=16 Cancelled from Start
17=17 Change to Part Time
18=18 Termination
|
| 20 |
GPDE_BV_TARIFF |
Character(2) |
VARCHAR2(2) NOT NULL |
BVV Tariff
DA=Pension Fund/Old Tariff (DA)
DN=Pension Fund/New Tariff (DN)
RA=Relief Fund/Old Tariff (RA)
RN=Relief Fund/New Tariff (RN)
|
| 21 |
GPDE_BV_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Fund Type (Pension/Relief Fund)
P=Pension Fund
U=Support Fund
|
| 22 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 23 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 24 |
GPDE_ASOF_DT_EX_RT |
Date(10) |
DATE |
Exchange Rate Date
|
| 25 |
GPDE_BV_SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
|
| 26 |
GPDE_BV_MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
M=Married
S=Single
U=Unknown
W=Widowed
|
| 27 |
GPDE_BV_CLASS |
Number(2,0) |
SMALLINT NOT NULL |
BVV Contribution Class
|
| 28 |
GPDE_BV_INSTYPE_00 |
Character(1) |
VARCHAR2(1) NOT NULL |
Insurance Type BVV00
|
| 29 |
GPDE_BV_INSTYPE_30 |
Character(1) |
VARCHAR2(1) NOT NULL |
Insurance Type BVV30
|
| 30 |
GPDE_BV_INSTYPE_40 |
Character(1) |
VARCHAR2(1) NOT NULL |
Insurance Type BVV40
|
| 31 |
GPDE_BV_INSTYPE_50 |
Character(1) |
VARCHAR2(1) NOT NULL |
Insurance Type BVV50
|
| 32 |
GPDE_BV_INSTYPE_60 |
Character(1) |
VARCHAR2(1) NOT NULL |
Insurance Type BVV60
|
| 33 |
GPDE_BV_SORT_KEY |
Character(36) |
VARCHAR2(36) NOT NULL |
BVV Sort Key
|
| 34 |
GPDE_BV_SORT_LEN |
Character(4) |
VARCHAR2(4) NOT NULL |
BVV Sort Key Length
|
| 35 |
GPDE_BV_SORTV_KEY |
Character(36) |
VARCHAR2(36) NOT NULL |
BVV Insurance Sort Key
|
| 36 |
GPDE_BV_SORTV_LEN |
Character(4) |
VARCHAR2(4) NOT NULL |
BVV Sort Key Length
|
| 37 |
GPDE_BV_SORTV_ROW1 |
Character(30) |
VARCHAR2(30) NOT NULL |
BVV Sort Key Z1
|
| 38 |
GPDE_BV_SORTV_ROW2 |
Character(30) |
VARCHAR2(30) NOT NULL |
BVV Sort Key Z2
|
| 39 |
GPDE_BV_SORTV_ROW3 |
Character(30) |
VARCHAR2(30) NOT NULL |
BVV Sort Key Z3
|
| 40 |
GPDE_BV_SORTV_ROW4 |
Character(30) |
VARCHAR2(30) NOT NULL |
BVV Sort Key Z4
|
| 41 |
GPDE_DD_BVV00_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV Total Contribution
|
| 42 |
GPDE_DD_BVV10_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV Contribution ER
|
| 43 |
GPDE_DD_BVV20_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV Contribution EE
|
| 44 |
GPDE_DD_BVV30_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV Contribution Voluntary
|
| 45 |
GPDE_DD_BVV40_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV Voluntary Contribution
|
| 46 |
GPDE_DD_BVV50_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV Contribution AZV
|
| 47 |
GPDE_DD_BVV60_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV Difference Amount
|
| 48 |
GPDE_DD_BVV70_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV Contribution Civil Service
|
| 49 |
GPDE_DD_BVV80_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV Difference Amount
|
| 50 |
GPDE_DD_BVV90_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV Difference Amount
|
| 51 |
GPDE_DD_BVV100_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV Difference Amount
|
| 52 |
GPDE_DD_BVV110_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV Difference Amount
|
| 53 |
GPDE_DD_BVV120_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV Difference Amount
|
| 54 |
GPDE_DD_BVV130_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV Difference Amount
|
| 55 |
GPDE_DD_BVV140_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Suppl. Insurance - Death Fund
|
| 56 |
GPDE_DD_BVV150_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Voluntary/Suppl. Pension
|
| 57 |
GPDE_DD_NBV00_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV Total Contribution
|
| 58 |
GPDE_DD_NBV10_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV Contribution ER
|
| 59 |
GPDE_DD_NBV20_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV Contribution EE
|
| 60 |
GPDE_VR_BVV12_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Taxfree Pension Amt EE
|
| 61 |
GPDE_VR_BVV13_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
LmpSum Tx Pension Amt EE
|
| 62 |
GPDE_VR_BVV21_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Unlimited Tx On BVV Cont
|
| 63 |
GPDE_VR_BVV22_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Unlimited Tx On BVV Cont
|
| 64 |
GPDE_VR_BVV28_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Taxfree Pension Amt ER
|
| 65 |
GPDE_BV_EETXS_AMT |
Number(18,2) |
DECIMAL(17,2) NOT NULL |
EE Contribution Taxable Supported
|
| 66 |
GPDE_BV_EETXNS_AMT |
Number(18,2) |
DECIMAL(17,2) NOT NULL |
EE Contribution Taxable Non Supported
|
| 67 |
GPDE_BV_TYPE_DZ |
Character(2) |
VARCHAR2(2) NOT NULL |
BVV Tariff DZ
00=No Supplementary Cntb
DZ=DZ - Pens near Suppl.Cntrbtn
|
| 68 |
GPDE_DD_BVV00_DZ |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV Total Contribution DZ
|
| 69 |
GPDE_DD_BVV10_DZ |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV EE Contribution DZ
|
| 70 |
GPDE_DD_BVV20_DZ |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
BVV ER Contribution DZ
|
| 71 |
GPDE_BV_EETXNS_DZ |
Number(18,2) |
DECIMAL(17,2) NOT NULL |
EE Contribution Taxable Non Supported DZ
|
| 72 |
GPDE_VR_BV12DZ_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Taxfree Pension Amt EE
|
| 73 |
GPDE_VR_BV13DZ_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Taxfree Pension Amt EE
|
| 74 |
GPDE_VR_BV21DZ_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Unlimited Tx On BVV Cont
|
| 75 |
GPDE_VR_BV22DZ_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Unlimited Tx On BVV Cont
|
| 76 |
GPDE_VR_BV28DZ_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Taxfree Pension Amt ER
|