| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PU_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Paysheet Update Source
AM=Absence Management
ER=Recruiting Interface
EX=Expense Interface
IM=SIM Interface
OT=Other Sources
RP=Rapid Paysheets
SP=Stock Admin - ESPP Refunds
ST=Stock Admin - Options & ESPP
VC=Variable Compensation
WI=What-If
|
| 2 |
CREATION_DT |
Date(10) |
DATE NOT NULL |
Creation Date
|
| 3 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 4 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
|
| 5 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 6 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
|
| 7 |
EARNS_BEGIN_DT |
Date(10) |
DATE |
Earnings Begin Date
|
| 8 |
EARNS_END_DT |
Date(10) |
DATE |
Earnings End Date
|
| 9 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 10 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 11 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 12 |
PU_TXN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Paysheet Update Tax Type
C=Canada Tax Override
D=Deduction Override
E=Earnings
G=Total Gross
N=Net Pay
O=Override
T=US Tax Override
|
| 13 |
PU_TXN_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Paysheet Update Tax Status
A=Active
I=Inactive
|
| 14 |
PAGE_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Page #
|
| 15 |
LINE_NUM |
Number(2,0) |
SMALLINT NOT NULL |
Line #
|
| 16 |
ADDL_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Additional Pay Line #
|
| 17 |
SEPCHK |
Number(1,0) |
SMALLINT NOT NULL |
Separate check number.
|
| 18 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 19 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 20 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 21 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
|
| 22 |
GL_PAY_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
General Ledger Pay Type
|
| 23 |
PU_DISTRIBUTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Paysheet Update Distribution
Y/N Table Edit
Default Value: Y
|
| 24 |
ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Earnings Code
|
| 25 |
ADDL_PAY_SHIFT |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Pay Shift
1=1
2=2
3=3
J=Use Job Shift
N=Not Applicable
|
| 26 |
ADDL_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Additional Pay Sequence Number
|
| 27 |
ADDLPAY_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason for Additional Pay
A=Anniversary Award
AWD=Award Data
BAS=Benefits Administration Credit
C=Contract Pay
JOB=Job Other Pay
N=Not Specified
O=Outstanding Contribution
P=Performance Award
Q=President's Award
S=Productivity Award
Default Value: N
|
| 28 |
OTH_HRS |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Other Hours
|
| 29 |
HOURLY_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Hourly Rate
|
| 30 |
OK_TO_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
OK to Pay
|
| 31 |
DISABLE_DIR_DEP |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable Direct Deposit
|
| 32 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 33 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
|
| 34 |
TAX_PERIODS |
Number(2,0) |
SMALLINT NOT NULL |
Tax Periods
|
| 35 |
TAX_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax method.
A=Annualized
B=Bonus
C=Cumulative
G=Aggregate
L=Lump Sum
M=Commission
P=Specified on Paysheet
S=Supplemental
X=Special Supplemental
|
| 36 |
DED_TAKEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Deductions Taken
D=Deduction Table Governs
N=None
R=No Override
S=Deduction Table Subset Governs
|
| 37 |
DED_SUBSET_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Deduction Subset ID
|
| 38 |
DED_TAKEN_GENL |
Character(1) |
VARCHAR2(1) NOT NULL |
General Deductions Taken
D=Deduction Table Governs
N=None
R=No Override
S=Deduction Table Subset Governs
|
| 39 |
DED_SUBSET_GENL |
Character(3) |
VARCHAR2(3) NOT NULL |
General Ded Subset ID
|
| 40 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 41 |
COMP_RATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Comp Rate Code
|
| 42 |
TAX_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Balance Class
|
| 43 |
ONE_TIME_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
PaySheet One-Time Code
A=Addition
O=Override
P=Arrears Payback
R=Refund
|
| 44 |
CTX_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Canadian Tax Type
A=Canadian Income Tax (T4A)
B=Canadian Bonus Tax
C=Canadian Income Tax (T4)
E=Employee EI Premium
H=Health Tax
I=Quebec Income Tax
J=Quebec Parental Insurance - EE
K=Quebec Parental Insurance - ER
N=Quebec Bonus Tax
P=Canada Pension Plan
Q=Quebec Pension Plan
R=Employer EI Premium
T=Payroll Tax
V=Quebec Income Tax (RL-2)
X=Take No CPP/QPP Exemption
Y=Canadian Pension Plan - ER
Z=Quebec Pension Plan - ER
|
| 45 |
PLAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
|
| 46 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
|
| 47 |
DEDCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Deduction Code
|
| 48 |
DED_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Deduction Classification
A=After-Tax
B=Before-Tax
L=QC Taxable Benefit
N=Nontaxable Benefit
P=Nontaxable Btax Benefit
T=Taxable Benefit
|
| 49 |
DED_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Deduction Calculation Routine
A=Flat Amount
B=Percentage
C=Calculated by Salary System
D=Default to Deduction Table
E=Percent of Special Earnings
F=Percent of Federal Gross
G=Percent of Total Gross
H=Rate x Total Hours
N=Percent of Net Pay
P=Rate x Special Hours
S=Special Deduction Calculation
W=Rate x Hours Worked
|
| 50 |
DED_RATE_PCT |
Number(8,3) |
DECIMAL(7,3) NOT NULL |
Deduction Rate/Percent
|
| 51 |
AMT |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Dollar Amount
|
| 52 |
MANUAL_CHECK |
Character(1) |
VARCHAR2(1) NOT NULL |
Manual Check
N=No
R=Reversal
Y=Yes
Default Value: N
|
| 53 |
PAYCHECK_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Paycheck number.
|
| 54 |
DED_SLSTX_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Tax Type
B=None
G=Goods and Services Tax
H=Harmonized Sales Tax
I=Provincial Sales Tax Insurance
P=Provincial Sales Tax
Q=QC Prov Sales Tax Insurance
S=QC Provincial Sales Tax
T=Provincial Premium Tax
U=QC Provincial Premium Tax
|
| 55 |
EX_DOC_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Expense Doc ID
|
| 56 |
EX_DOC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Expense Doc Type
|
| 57 |
EX_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Expense Line #
|
| 58 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 59 |
OVERRIDE_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Only
|
| 60 |
GROSSUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Gross-Up
|
| 61 |
VC_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
VC Plan ID
|
| 62 |
VC_PAYOUT_PRD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payout Period ID
|
| 63 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
|
| 64 |
APPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Job Applicant ID
|
| 65 |
AWARD_DATE |
Date(10) |
DATE |
Award Date
|
| 66 |
EIM_KEY |
Character(20) |
VARCHAR2(20) NOT NULL |
SIM Sequence Number
|
| 67 |
PAYOUT_DT |
Date(10) |
DATE |
Payout Date
|
| 68 |
WORK_PSD_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Locality
|
| 69 |
RES_PSD_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Locality
|