| # |
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 |
RSLT_SEG_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Result Segment Number
|
| 9 |
SLICE_END_DT |
Date(10) |
DATE |
Element Slice End Date
|
| 10 |
SLICE_BGN_DT |
Date(10) |
DATE |
Element Slice Begin Date
|
| 11 |
SEG_BGN_DT |
Date(10) |
DATE |
Payee Process Segment's Begin Date
|
| 12 |
SEG_END_DT |
Date(10) |
DATE |
Payee Process Segment's End Date
|
| 13 |
PRD_BGN_DT |
Date(10) |
DATE |
Period Begin Date
|
| 14 |
PRD_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 15 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 16 |
END_DT |
Date(10) |
DATE |
end date
|
| 17 |
GPCH_AL_CPAY_ENDDT |
Date(10) |
DATE NOT NULL |
Current Pay End Date
|
| 18 |
GPCH_RP_YEAR |
Date(10) |
DATE |
Report Year
|
| 19 |
PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
|
| 20 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 21 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 22 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 23 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
|
| 24 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 25 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 26 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Set ID
|
| 27 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code Set ID
|
| 28 |
SETID_LOCATION |
Character(5) |
VARCHAR2(5) NOT NULL |
Location Set ID
|
| 29 |
SETID_SALARY |
Character(5) |
VARCHAR2(5) NOT NULL |
Salary Set ID
|
| 30 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 31 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 32 |
LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Location Code
|
| 33 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
|
| 34 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL
|
| 35 |
ORIG_CAL_RUN_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Original Calendar Group ID
|
| 36 |
REASON |
Character(30) |
VARCHAR2(30) NOT NULL |
Reason
|
| 37 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
|
| 38 |
STEP |
Number(2,0) |
SMALLINT NOT NULL |
Step
|
| 39 |
STD_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours
|
| 40 |
FTE |
Number(8,6) |
DECIMAL(7,6) NOT NULL |
This field represent Full Time Equivalence
|
| 41 |
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
|
| 42 |
EMPL_CTG |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Category
|
| 43 |
EMPL_CTG_L1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Employee Subcategory
|
| 44 |
JOB_ENTRY_DT |
Date(10) |
DATE |
Job Entry Date
|
| 45 |
HIRE_DT |
Date(10) |
DATE |
First Start Date
|
| 46 |
TERMINATION_DT |
Date(10) |
DATE |
Termination Date
|
| 47 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 48 |
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
|
| 49 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
|
| 50 |
GPCH_SI_AHV_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
AHV Status
0=0 None
1=1 Employer/Employee
2=2 Employer
|
| 51 |
GPCH_SI_ALV_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
ALV Status
0=0 None
1=1 Employer/Employee
2=2 Employer
|
| 52 |
GPCH_SI_COV_UV |
Character(1) |
VARCHAR2(1) NOT NULL |
Risk Group
A=Risk Group A
B=Risk Group B
C=Risk Group C
D=Risk Group D
E=Risk Group E
F=Risk Group F
G=Risk Group G
H=Risk Group H
I=Risk Group I
J=Risk Group J
K=Risk Group K
L=Risk Group L
M=Risk Group M
N=Risk Group N
O=Risk Group O
P=Risk Group P
Q=Risk Group Q
R=Risk Group R
S=Risk Group S
T=Risk Group T
U=Risk Group U
V=Risk Group V
W=Risk Group W
X=Risk Group X
Y=Risk Group Y
Z=Risk Group Z
|
| 53 |
GPCH_TX_UV_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Accident Insurance Status
0=0 None
1=1 NBU Employee
2=2 NBU Employer
3=3 BU only
|
| 54 |
GPCH_UV_ELIG |
Character(1) |
VARCHAR2(1) NOT NULL |
UV Status as of DB
|
| 55 |
GPCH_TX_KTG_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Health Insurance Status
0=0 None
1=1 Employer/Employee
2=2 Employer
|
| 56 |
GPCH_PK_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
PK Status
0=Yes
1=No
2=Default
|
| 57 |
GPCH_TX_UV_PROV_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Accident Insurance Provider
|
| 58 |
GPCH_TX_FAK_SUBJC |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject to FAK
0=No
1=Yes
|
| 59 |
GPCH_TX_FAK_CANTON |
Character(2) |
VARCHAR2(2) NOT NULL |
FAK Canton
|
| 60 |
GPCH_TX_VILLAGE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Municipality Code
|
| 61 |
GPCH_TX_VILLAGE_L |
Character(4) |
VARCHAR2(4) NOT NULL |
Village Code
|
| 62 |
GPCH_TX_SETTLE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Residence Status
1=Switzerland
2=Transport
9=Illegal
A=A Seasonal Worker
B=B One Year Permit
C=C Residence Permit
F=F Temporary Permit
G=G Frontier Worker
L=L Short-Term Permit
N=N Employed Asylum Seeker
|
| 63 |
GPCH_TX_EXEMPT_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Exempt from Withholding Tax
|
| 64 |
GPCH_TX_TRF_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Withholding Tax Tariff
|
| 65 |
GPCH_TX_CANTON |
Character(2) |
VARCHAR2(2) NOT NULL |
Canton
|
| 66 |
GPCH_TX_OVRD_AMT |
Number(11,4) |
DECIMAL(10,4) NOT NULL |
Override Tax Amount
|
| 67 |
GPCH_TX_OVRD_PCT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Override Percent
|
| 68 |
GPCH_TX_STAXB_PCT |
Number(7,4) |
DECIMAL(6,4) NOT NULL |
Withholding Tax on Commission
|
| 69 |
GPCH_TX_LAW_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Law
|
| 70 |
GPCH_RP_AMOUNT1 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Rate Result Value
|
| 71 |
GPCH_RP_AMOUNT2 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Rate Result Value
|
| 72 |
GPCH_RP_AMOUNT3 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Rate Result Value
|
| 73 |
GPCH_RP_AMOUNT4 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Rate Result Value
|
| 74 |
GPCH_RP_AMOUNT5 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Rate Result Value
|
| 75 |
GPCH_RP_AMOUNT9 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount 9
|
| 76 |
GPCH_RP_AMOUNT10 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount 10
|
| 77 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 78 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 79 |
EXPIRATN_DT |
Date(10) |
DATE |
Expiration Date
|
| 80 |
LANG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese
|
| 81 |
COST_UNIT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Cost Unit
|
| 82 |
CONTRACT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Contract Type
|
| 83 |
CONTRACT_END_DT |
Date(10) |
DATE |
Contract End Date
|
| 84 |
COUNTRY_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
From Country
|
| 85 |
GPCH_RP_AMOUNT11 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount 11
|
| 86 |
GPCH_RP_AMOUNT12 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount 12
|
| 87 |
GPCH_RP_AMOUNT13 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount 13
|
| 88 |
GPCH_RP_AMOUNT14 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount 14
|
| 89 |
GPCH_RP_AMOUNT15 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount 15
|
| 90 |
GPCH_RP_AMOUNT19 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount 19
|
| 91 |
GPCH_RP_AMOUNT20 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount 20
|
| 92 |
GPCH_RP_AMOUNT21 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount 21
|
| 93 |
GPCH_RP_AMOUNT23 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount 23
|
| 94 |
GPCH_RP_AMOUNT22 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount 22
|
| 95 |
GPCH_RP_AMOUNT24 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount 24
|
| 96 |
GPCH_RP_AMOUNT25 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount 25
|
| 97 |
GPCH_RP_AMOUNT26 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount 23
|
| 98 |
GPCH_RP_AMOUNT27 |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Amount 27
|
| 99 |
GPCH_RP_CHAR02 |
Character(8) |
VARCHAR2(8) NOT NULL |
Character 02
|
| 100 |
GPCH_RP_CHAR01 |
Character(6) |
VARCHAR2(6) NOT NULL |
Character 01
|
| 101 |
GPCH_SI_HPROV |
Character(15) |
VARCHAR2(15) NOT NULL |
Health Provider
|
| 102 |
GPCH_RP_LSEYOS |
Number(2,0) |
SMALLINT NOT NULL |
Years of Service
|
| 103 |
GPCH_RP_LSELOCZIP |
Character(12) |
VARCHAR2(12) NOT NULL |
ZipCode of Location
|
| 104 |
GPCH_RP_LSEWT |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Weekly work time
|
| 105 |
GPCH_RP_LSEST |
Number(2,0) |
SMALLINT NOT NULL |
Short-time work
|
| 106 |
GPCH_RP_LSEHRS |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Hourly wages
|
| 107 |
GPCH_RP_LSEGROSS |
Number(5,0) |
INTEGER NOT NULL |
Gross wage
|
| 108 |
GPCH_RP_LSESI |
Number(5,0) |
INTEGER NOT NULL |
Social contribution
|
| 109 |
GPCH_RP_LSESHIFT |
Number(4,0) |
SMALLINT NOT NULL |
Shift premium
|
| 110 |
GPCH_RP_LSEOVT |
Number(5,0) |
INTEGER NOT NULL |
Overtime
|
| 111 |
GPCH_RP_LSE13TH |
Number(5,0) |
INTEGER NOT NULL |
13th monthly salary
|
| 112 |
GPCH_RP_LSESPEC |
Number(6,0) |
INTEGER NOT NULL |
Special salary payment
|
| 113 |
EMPL_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Employee Classification
|
| 114 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 115 |
GPCH_AH_NNSS |
Character(20) |
VARCHAR2(20) NOT NULL |
New Social Insurance ID
|
| 116 |
BIRTHPLACE |
Character(30) |
VARCHAR2(30) NOT NULL |
Birth Location
|
| 117 |
ORIGIN_CHE |
Character(40) |
VARCHAR2(40) NOT NULL |
This field represents a person's place of origin. This is the place of origin of a person's father or husband. It is a free format field.
|
| 118 |
VISA_PERMIT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Visa/Permit Type
|
| 119 |
ORIG_HIRE_DT |
Date(10) |
DATE |
Original Start Date
|
| 120 |
GRADE_ENTRY_DT |
Date(10) |
DATE |
Grade Entry Date
|
| 121 |
COMP_FREQUENCY |
Character(5) |
VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly
|
| 122 |
GPCH_RP_FTE_DT |
Date(10) |
DATE |
Fte Date
|
| 123 |
GPCH_TX_CHRCH |
Character(1) |
VARCHAR2(1) NOT NULL |
Church Tax
1=Including Church Tax
2=Excluding Church Tax
|
| 124 |
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
|
| 125 |
SPOUSE_NAME |
Character(40) |
VARCHAR2(40) NOT NULL |
Spouse Name
|
| 126 |
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
Y/N Table Edit
|
| 127 |
GPCH_SI_YEAR |
Character(1) |
VARCHAR2(1) NOT NULL |
Control yearly limits
|
| 128 |
GPCH_RP_CHAR03 |
Character(8) |
VARCHAR2(8) NOT NULL |
Character 03
|
| 129 |
GPCH_RP_FROMDT1 |
Date(10) |
DATE |
From Date 1
|
| 130 |
REG_TEMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Regular/Temporary
R=Regular
T=Temporary
|
| 131 |
GPCH_MC_LEGAL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Legal Record Number
|