| # |
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 Record
|
| 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 |
SLICE_END_DT |
Date(10) |
DATE |
Element Slice End Date
|
| 12 |
SLICE_BGN_DT |
Date(10) |
DATE |
Element Slice Begin Date
|
| 13 |
SEG_BGN_DT |
Date(10) |
DATE |
Payee Process Segment's Begin Date
|
| 14 |
PRD_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 15 |
PRD_BGN_DT |
Date(10) |
DATE |
Period Begin Date
|
| 16 |
BA_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
BA Code
|
| 17 |
GPDE_SI_L_INC_ERN |
Character(1) |
VARCHAR2(1) NOT NULL |
Low Income Earner
0=No
1=Yes
C=Clergy
D=Disabled
F=voluntary social year
K=volutary ecological year
M=Miner
N=No
O=Normal
|
| 18 |
GPDE_SI_MINER |
Character(1) |
VARCHAR2(1) NOT NULL |
Miners' Social Insurance
G=Not Applicable
N=No
Y=Yes
|
| 19 |
GPDE_SI_PROV_MAND |
Character(8) |
VARCHAR2(8) NOT NULL |
SI Provider Compulsory
|
| 20 |
GPDE_DV_SV_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
DEUEV Contribution Group Code
|
| 21 |
GPDE_DV_EMPL_CAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Category
101=Regular SI Taxable
102=Apprentice
103=Old-Age Part Time
104=Consultant
105=Trainee
106=Student Trainee
107=Disabled
108=Early Retirement
109=Low Income Earner
110=Short-Term Employment
111=EE in Rehabilitation
112=Family member in agriculture
113=Part-time Farmer
114=PT Farmer, seasonal
116=FEI Compensation Receiver
118=Casual Worker
119=Old Age Pensioner
120=Pretended Freelancer
190=Insured only for Accident Ins
900=Public Servant
901=Managing Partner
903=Health Insured Pensioner
910=SI free Employee
|
| 22 |
GPDE_SI_POS_IN_JOB |
Character(1) |
VARCHAR2(1) NOT NULL |
Position
0=0 Apprentice
1=1 Blue Collar, non prof
2=2 Blue Collar Prof
3=3 BC Foreman
4=4 White Collar
5=5 Disabled
6=6 Rehabilitation
7=7 Homeworker;domestic business
8=8 Part Time < 18 Hrs.
9=9 Part Time >= 18 Hrs.
|
| 23 |
GPDE_SI_EDUCATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Education
0=0 unknown
1=1General Secondary w/o Prof
2=2 General Secondary with Prof
3=3 Gen Univ Entr no Prof Train
4=4 Gen Univ Entr w/Prof Train
5=5 Technical College Degree
6=6 University Degree
7=7 unknown degree
|
| 24 |
GPDE_BA_SCHL_DGR |
Character(1) |
VARCHAR2(1) NOT NULL |
SCHOOL DEGREE
1=Without School Leave certifict
2=certi of Secondary Education
3=secondary school levelI certi
4=gen qual - univ entr/Voc dipl
9=Certificate not known
|
| 25 |
GPDE_BA_PRF_DGR |
Character(1) |
VARCHAR2(1) NOT NULL |
PROFESSIONAL DEGREE
1=without professional educatio
2=Certificate of accepted profn
3=Master Craftsman, technican
4=Bachelor
5=Mast of Arts/ Dipl/State Exam
6=Conferal of a Doctorate
9=Profesionl Education not known
|
| 26 |
GPDE_BA_EMPL_TMP |
Character(1) |
VARCHAR2(1) NOT NULL |
TEMP EMPLOYMENT
1=No
2=Yes
|
| 27 |
GPDE_BA_CNTRCT_WRK |
Character(1) |
VARCHAR2(1) NOT NULL |
BA CONTRACT WORK
1=FullTmEmpl-Unlimited Empl Cont
2=PartTmEmpl-Unlimited Empl Cont
3=FullTmEmpl-Limited Empl Contrt
4=PartTmEmpl-Limited Empl Contrt
|
| 28 |
GPDE_SI_PENS_APPLI |
Character(1) |
VARCHAR2(1) NOT NULL |
Pension Type
0=No Pension Applic'n/Payments
1=Pension Application
2=Partial Disability Pension
3=General Disability Pension
4=Retirement Pension
5=Old Age Part Time Pension
6=Widow/Orphan Pension
7=Educational Pension
8=Miners' Pension
9=Farmers' Retirement Pension
|
| 29 |
GPDE_SI_EMPL_MULT |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Employment Records
0=No
1=Yes
|
| 30 |
GPDE_SI_EMPL_INSIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Insignificant Employment
0=Not Insignificant
1=Insignificant Employment
2=Short Term Employment
|
| 31 |
GPDE_SI_PROV_KV |
Character(8) |
VARCHAR2(8) NOT NULL |
Health Insurance Provider
|
| 32 |
GPDE_SI_PROV_PV |
Character(8) |
VARCHAR2(8) NOT NULL |
Home Care Insurance Provider
|
| 33 |
GPDE_SI_PROV_RV |
Character(8) |
VARCHAR2(8) NOT NULL |
Pension Insurance Provider
|
| 34 |
GPDE_SI_PROV_AV |
Character(8) |
VARCHAR2(8) NOT NULL |
Unemployment Insur Provider
|
| 35 |
GPDE_SI_PROV_UM |
Character(8) |
VARCHAR2(8) NOT NULL |
Unemployment Insur Provider
|
| 36 |
GPDE_RI_PCT1 |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Percent
|
| 37 |
GPDE_RI_PCT2 |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Percent
|
| 38 |
GPDE_SI_STATUS_KV |
Character(1) |
VARCHAR2(1) NOT NULL |
Contribution Group
|
| 39 |
GPDE_SI_STATUS_RV |
Character(1) |
VARCHAR2(1) NOT NULL |
Contribution Group
|
| 40 |
GPDE_SI_STATUS_AV |
Character(1) |
VARCHAR2(1) NOT NULL |
Contribution Group
|
| 41 |
GPDE_SI_STATUS_PV |
Character(1) |
VARCHAR2(1) NOT NULL |
Contribution Group
|
| 42 |
GPDE_SIC_REGION |
Character(1) |
VARCHAR2(1) NOT NULL |
Home Care Insurance Region
|
| 43 |
GPDE_SIH_REGION |
Character(1) |
VARCHAR2(1) NOT NULL |
Health Insurance Region
|
| 44 |
GPDE_SIP_REGION |
Character(1) |
VARCHAR2(1) NOT NULL |
Pension Insurance Region
|
| 45 |
GPDE_SIU_REGION |
Character(1) |
VARCHAR2(1) NOT NULL |
Unemployment Insurance Region
|
| 46 |
GPDE_SI_CMPINS_1 |
Character(3) |
VARCHAR2(3) NOT NULL |
U1 for Sickness
00=None
10=Regular
11=Increased
12=Reduced
|
| 47 |
GPDE_SI_CMPINS_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
U2 for Maternity
00=None
20=Regular
21=Increased
22=Reduced
|
| 48 |
GPDE_DV_SV_CODE_M |
Character(4) |
VARCHAR2(4) NOT NULL |
DEUEV Contr Group March Clause
|
| 49 |
GPDE_SI_PROV_AV_M |
Character(8) |
VARCHAR2(8) NOT NULL |
UI Provider for March Clause
|
| 50 |
GPDE_SI_PROV_KV_M |
Character(8) |
VARCHAR2(8) NOT NULL |
HI Provider for March Clause
|
| 51 |
GPDE_SI_PROV_PV_M |
Character(8) |
VARCHAR2(8) NOT NULL |
HCI Provider for March Clause
|
| 52 |
GPDE_SI_PROV_RV_M |
Character(8) |
VARCHAR2(8) NOT NULL |
PI Provider for March Clause
|
| 53 |
GPDE_SI_PROV_UM_M |
Character(8) |
VARCHAR2(8) NOT NULL |
Unemployment Insur Provider
|
| 54 |
GPDE_RI_PCT1_MC |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Percent
|
| 55 |
GPDE_RI_PCT2_MC |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Percent
|
| 56 |
GPDE_RP_MAR_MON |
Date(10) |
DATE |
March Month
|
| 57 |
GPDE_SI_CARD_PRES |
Date(10) |
DATE |
SI Card Date Presented
|
| 58 |
GPDE_SI_EMPL_TYPE |
Character(20) |
VARCHAR2(20) NOT NULL |
Employment Type
Default Value: JOBCODE_TBL.DESCR
|
| 59 |
GPDE_DV_RVNR |
Character(12) |
VARCHAR2(12) NOT NULL |
Pension Insurance Number
|
| 60 |
GPDE_RP_MARCH_CLS |
Number(2,0) |
SMALLINT NOT NULL |
March Clause
|
| 61 |
GPDE_SI_UPROV_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Provider ID of Refund Insurance Provider (Umlagekassenbetriebsnummer)
|
| 62 |
GPDE_SI_IS_KVDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Health Insurance for Pensioners Flag
Y/N Table Edit
|
| 63 |
GPDE_SI_REG_MAND |
Character(1) |
VARCHAR2(1) NOT NULL |
Region of mandatory provider
|
| 64 |
GPDE_RP_RV_GZ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag Glidezone Calculation Pension Insurance
0=No Glidezone calculation in RV
1=GZ RV btwn 400 and 800 Eur
2=GZ RV under 400 Eur
Default Value: 0
|
| 65 |
GPDE_SI_BAEGV |
Character(1) |
VARCHAR2(1) NOT NULL |
DEUEV Employment Status
0=Regular Employment
1=Employed Family Member
2=Owning Manager
|
| 66 |
GPDE_SI_PV_CHILD |
Character(1) |
VARCHAR2(1) NOT NULL |
Children for PV Calculation
|
| 67 |
GPDE_RP_VW_ELIG |
Number(2,0) |
SMALLINT NOT NULL |
March Clause
|
| 68 |
GPDE_RP_VW_ELIG_MC |
Number(2,0) |
SMALLINT NOT NULL |
March Clause
|
| 69 |
GPDE_VW_MNRBV |
Character(17) |
VARCHAR2(17) NOT NULL |
Employee's Member ship number for Pension Fund for specific profess
ions
|