| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 5 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 6 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 7 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit
|
| 8 |
PAGE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Page Nbr
|
| 9 |
LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Line Nbr
Prompt Table:
PAY_LINE
|
| 10 |
SEPCHK |
Number(2,0) |
SMALLINT NOT NULL |
Separate check number.
|
| 11 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 12 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Accounting Period
|
| 13 |
HP_RETDIST_PAY_DT |
Date(10) |
DATE |
Retro Dist Pay End Date
|
| 14 |
ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Earnings Code
|
| 15 |
HP_RDIST_TRANS_NO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Transaction Number
|
| 16 |
HP_PREVRDIST_TRANS |
Number(10,0) |
DECIMAL(10) NOT NULL |
Previous Retro Transaction
|
| 17 |
HP_RDIST_SUB_TRANS |
Number(5,0) |
INTEGER NOT NULL |
Secondary Transaction Number
|
| 18 |
HP_PREVRDIST_SUB_X |
Number(5,0) |
INTEGER NOT NULL |
Previous Retro Distr Sub Transaction
|
| 19 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 20 |
PROVINCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Province
|
| 21 |
TAX_CLASS_CAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Canadian Tax Class
ALL=Total Gross
CBT=Canadian Bonus Tax
CIT=Canadian Income Tax (T4)
CP2=CPP Second Additional Employee
CPA=Pension Adjustment
CPP=Canada Pension Plan Employee
CPR=Canada Pension Plan Employer
CR2=CPP Second Additional Employer
EIE=Employment Insurance Employee
EIR=Employment Insurance Employer
HTX=Provincial Health Tax
PYT=Payroll Tax
QBT=Quebec Bonus Tax
QCD=Quebec Tax Deduction
QIE=Quebec Parental Plan Employee
QIR=Quebec Parental Plan Employer
QIT=Quebec Income Tax (RL-1)
QP2=QPP Second Additional Employee
QPP=Quebec Pension Plan Employee
QPR=Quebec Pension Plan Employer
QR2=QPP Second Additional Employer
RV2=Quebec Income Tax (RL-2)
T4A=Canadian Income Tax (T4A)
TRV=True RL
TT4=True T4
|
| 22 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
|
| 23 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 24 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 25 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 26 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 27 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 28 |
HP_RETDIST_SEQ_NO |
Number(5,0) |
INTEGER NOT NULL |
Retro Distrubution process sequence number
|
| 29 |
POSITION_POOL_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Position Pool ID
|
| 30 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code Set ID
|
| 31 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 32 |
TAX_CUR |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Current Tax
|
| 33 |
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.
|
| 34 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
|
| 35 |
DEDCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Deduction Code
|
| 36 |
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
|
| 37 |
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
|
| 38 |
DED_CUR |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Current Deduction
|
| 39 |
EARNINGS |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Earnings
|
| 40 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 41 |
TAX_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Tax Balance Class
|
| 42 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
|
| 43 |
BUDGET_DATA |
Character(50) |
VARCHAR2(50) NOT NULL |
Budget Data
|
| 44 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 45 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 46 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
|
| 47 |
HP_NEXT_EFFDT |
Date(10) |
DATE |
Next Effective Date
|
| 48 |
HP_PRIOR_ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Previous Account Code before Change
|
| 49 |
PRIOR_EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Prior Effective Status
|
| 50 |
HP_PREV_EFFDT |
Date(10) |
DATE |
Previous Effective Date
|
| 51 |
HP_PREV_EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Previous Effective Sequence
|
| 52 |
BUDGET_LEVEL_INDC |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Level
A=Appointment
D=Department
J=Jobcode
O=Position Pool
P=Position
|
| 53 |
PAY_DT |
Date(10) |
DATE |
Date of Pay
|
| 54 |
BUDGET_SEQ |
Number(2,0) |
SMALLINT NOT NULL |
Budget Sequence
|
| 55 |
HP_IGNOREOFFCYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Option for Ignoring Off cycle pay runs when determining next payroll for posting retroactive distribution
|
| 56 |
HP_PRIORDAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days Prior Pay End Date
|
| 57 |
HP_KK_DOC_ID |
Number(31,0) |
DECIMAL(31) NOT NULL |
Commitment Control Document ID
|