| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 2 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
|
| 3 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 4 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
|
| 5 |
PAGE_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Page #
|
| 6 |
LINE_NUM |
Number(2,0) |
SMALLINT NOT NULL |
Line #
|
| 7 |
SEPCHK |
Number(1,0) |
SMALLINT NOT NULL |
Separate check number.
|
| 8 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 9 |
HP_GROSS |
Character(1) |
VARCHAR2(1) NOT NULL |
This field identifies if the report column is for Gross wages or Fringe Benefits (taxes).
E=Gross
F=Fringe
|
| 10 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 11 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 12 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 13 |
PAYCHECK_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Paycheck number.
|
| 14 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 15 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Accounting Period
|
| 16 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 17 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department SetID
|
| 18 |
HP_DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Secondary Department Id when Dept more than once on one record.
|
| 19 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 20 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 21 |
POSITION_POOL_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Position Pool ID
|
| 22 |
ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Earnings Code
|
| 23 |
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.
|
| 24 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
|
| 25 |
DEDCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Deduction Code
|
| 26 |
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
|
| 27 |
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
|
| 28 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 29 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
|
| 30 |
TAX_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Balance Class
|
| 31 |
PROVINCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Province
|
| 32 |
TAX_CLASS_CAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Canadian Tax Class
ALL=Total Gross
CBT=Canadian Bonus Tax
CIT=Canadian Income Tax (T4)
CPA=Pension Adjustment
CPP=Canada Pension Plan Employee
CPR=Canada Pension Plan 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)
QPP=Quebec Pension Plan Employee
QPR=Quebec Pension Plan Employer
RV2=Quebec Income Tax (RL-2)
T4A=Canadian Income Tax (T4A)
TRV=True RL
TT4=True T4
|
| 33 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
|
| 34 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 35 |
DEPTID_CF |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 36 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project/Grant
|
| 37 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product
|
| 38 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
|
| 39 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code
|
| 40 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Public Sector Financials Chart Field.
|
| 41 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Public Sector Financials Chart Field
|
| 42 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit
|
| 43 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 44 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference Chartfield
|
| 45 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield number 1
|
| 46 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
|
| 47 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
|
| 48 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
|
| 49 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
|
| 50 |
AMOUNT |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
Commuting Allowance Paid Per Cycle.
|
| 51 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 52 |
REVERSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Reversed
|
| 53 |
HP_RETDIST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates the status of retro distribution on the current distribution record
0=Not changed
D=Reversing Entry
R=Redistributed
|
| 54 |
HP_RETDIST_PAY_DT |
Date(10) |
DATE |
Retro Dist Pay End Date
|
| 55 |
HP_RETRODIST_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
Retroactive Distribution Change mad to Budgets
|