| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
CREATION_DT |
Date(10) |
DATE NOT NULL |
Creation Date
|
| 3 |
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
PL=Lifetime Balance Payout USF
RP=Rapid Paysheets
SP=Stock Admin - ESPP Refunds
ST=Stock Admin - Options & ESPP
VC=Variable Compensation
VF=Bonus from Fusion
WI=What-If
|
| 4 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 5 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
|
| 6 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 7 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
|
| 8 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 9 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 10 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 11 |
PU_TXN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Paysheet transaction type.
C=Canada Tax Override
D=Deduction Override
E=Earnings
G=Total Gross
N=Net Pay
O=Override
S=Garnishment Override
T=US Tax Override
|
| 12 |
PU_TXN_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Paysheet transaction status.
A=Active
E=Exclude
I=Inactive
I=Loaded
M=Manually Paid
R=Rejected
X=In Progress
|
| 13 |
PAGE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Page Nbr
|
| 14 |
LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Line Nbr
|
| 15 |
ADDL_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Additional Pay Line Nbr
|
| 16 |
SEPCHK |
Number(2,0) |
SMALLINT NOT NULL |
Separate check number.
|
| 17 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 18 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 19 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 20 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
|
| 21 |
GL_PAY_TYPE |
Character(6) |
VARCHAR2(6) NOT NULL |
General Ledger Pay Type
|
| 22 |
PU_DISTRIBUTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Paysheet Update Distribution
|
| 23 |
ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Earnings Code
|
| 24 |
EARNS_BEGIN_DT |
Date(10) |
DATE |
Earnings Begin Date
|
| 25 |
EARNS_END_DT |
Date(10) |
DATE |
Earnings End Date
|
| 26 |
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
|
| 27 |
ADDL_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Additional Pay Sequence Number
|
| 28 |
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
|
| 29 |
OTH_HRS |
Signed Number(8,2) |
DECIMAL(6,2) NOT NULL |
Other hours.
|
| 30 |
HOURLY_RT |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Hourly Rate
|
| 31 |
OK_TO_PAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Okay to pay indicator.
|
| 32 |
DISABLE_DIR_DEP |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable Direct Deposit
|
| 33 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 34 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
|
| 35 |
TAX_PERIODS |
Number(2,0) |
SMALLINT NOT NULL |
Tax Periods
|
| 36 |
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
|
| 37 |
DED_TAKEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Deductions Taken
D=Deduction Table Governs
N=None
R=No Override
S=Deduction Table Subset Governs
|
| 38 |
DED_SUBSET_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Deduction Subset ID
|
| 39 |
DED_TAKEN_GENL |
Character(1) |
VARCHAR2(1) NOT NULL |
Specify how general deduction is to be taken.
D=Deduction Table Governs
N=None
R=No Override
S=Deduction Table Subset Governs
|
| 40 |
DED_SUBSET_GENL |
Character(3) |
VARCHAR2(3) NOT NULL |
Subset ID for general deductions.
|
| 41 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 42 |
COMP_RATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Comp Rate Code
|
| 43 |
TAX_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Tax Balance Class
|
| 44 |
ONE_TIME_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Paysheet one-time code.
A=Addition
O=Override
P=Arrears Payback
R=Refund
|
| 45 |
CTX_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Canadian Tax Class.
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
L=CPP Second Addition EE
M=CPP Second Addition ER
N=Quebec Bonus Tax
P=Canada Pension Plan
Q=Quebec Pension Plan
R=Employer EI Premium
S=QPP Second Addition EE
T=Payroll Tax
U=QPP Second Addition ER
V=Quebec Income Tax (RL-2)
X=Take No CPP/QPP Exemption
Y=Canadian Pension Plan - ER
Z=Quebec Pension Plan - ER
|
| 46 |
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.
|
| 47 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
|
| 48 |
DEDCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Deduction Code
|
| 49 |
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
|
| 50 |
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
|
| 51 |
DED_RATE_PCT |
Number(8,3) |
DECIMAL(7,3) NOT NULL |
Deduction Rate/Percent
|
| 52 |
AMT |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Dollar Amount
|
| 53 |
MANUAL_CHECK |
Character(1) |
VARCHAR2(1) NOT NULL |
Manual Check indicator.
N=No
R=Reversal
Y=Yes
|
| 54 |
PAYCHECK_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Paycheck number.
|
| 55 |
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
|
| 56 |
EX_DOC_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Expense Doc ID
|
| 57 |
EX_DOC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Expense Doc Type
|
| 58 |
EX_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Expense Line #
|
| 59 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 60 |
OVERRIDE_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Only
|
| 61 |
GROSSUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Gross-Up
|
| 62 |
VC_PLAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
VC Plan ID
|
| 63 |
VC_PAYOUT_PRD_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Payout Period ID
|
| 64 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
|
| 65 |
STOCK_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Company's Stock Identification Symbol
|
| 66 |
GRANT_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
System assigned grant number used to uniquely identify the grant record.
|
| 67 |
EXERCISE_NBR |
Number(8,0) |
INTEGER NOT NULL |
System assigned exercise number used to uniquely identify the exercise record.
|
| 68 |
RELEASE_NBR |
Number(8,0) |
INTEGER NOT NULL |
System assigned release number used to uniquely identify the release record.
|
| 69 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 70 |
ST_DEFAULT_PERCENT |
Number(8,4) |
DECIMAL(7,4) NOT NULL |
Default Percentage
|
| 71 |
ST_TAX_OVERRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Amount Override
M=Manual Override
N=No Override
S=Stock System Override
|
| 72 |
SQL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
TL
|
| 73 |
APPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Job Applicant ID
|
| 74 |
AWARD_DATE |
Date(10) |
DATE |
Award Date
|
| 75 |
EIM_KEY |
Character(20) |
VARCHAR2(20) NOT NULL |
SIM Sequence Number
|
| 76 |
PAYOUT_DT |
Date(10) |
DATE |
Payout Date
|
| 77 |
WORK_PSD_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Locality
|
| 78 |
RES_PSD_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Locality
|