| # |
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 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 5 |
HP_BUDGET_DATATYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Budget Data Type for specifying if Earnings, Deductions, or Taxes
A=All
D=Deductions
DT=Deductions and Taxes
E=Earnings
ED=Earnings and Deductions
ET=Earnings and Taxes
T=Tax
|
| 6 |
TO_DATE |
Date(10) |
DATE |
Latest Date to be sent to PYR
|
| 7 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SETID_TBL
|
| 8 |
HP_TRANSACTION_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Distribution Transaction Source
B=Budget Changes
R=Direct Access Changes
|
| 9 |
PAY_DT |
Date(10) |
DATE |
Date of Pay
|
| 10 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
|
| 11 |
HP_MIN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Minimum Row
|
| 12 |
HP_MAX_NBR |
Number(5,0) |
INTEGER NOT NULL |
Maximum Row
|
| 13 |
BUDGET_AMT |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Budget Amount
|
| 14 |
HP_MARKET |
Character(3) |
VARCHAR2(3) NOT NULL |
Market
ARG=Argentina
AUS=Australia
BEL=Belgium
BRA=Brazil
CAN=Canada
CHE=Switzerland
DEU=Germany
ESP=Spain
FIN=Financial Services
FRA=France
GBL=Global
GBR=Great Britain
HC=Health Care
HED=Higher Education
IDN=Indonesia
ITA=Italy
JPN=Japan
LCL=Local
MYS=Malaysia
NA=North America
NLD=Netherlands
NZL=New Zealand
PS=Public Sector
RTL=Retail
SGP=Singapore
USA=United States
USF=U.S. Federal Govt
|
| 15 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 16 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 17 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 18 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit
|
| 19 |
PAGE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Page Nbr
|
| 20 |
LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Line Nbr
Prompt Table:
PAY_LINE
|
| 21 |
SEPCHK |
Number(2,0) |
SMALLINT NOT NULL |
Separate check number.
|
| 22 |
HP_RDIST_TRANS_NO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Transaction Number
|
| 23 |
HP_RDIST_SUB_TRANS |
Number(5,0) |
INTEGER NOT NULL |
Secondary Transaction Number
|
| 24 |
ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Earnings Code
|
| 25 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 26 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Accounting Period
|
| 27 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table:
ACCT_CD_CA_VW
|
| 28 |
BUDGET_DATA |
Character(50) |
VARCHAR2(50) NOT NULL |
Budget Data
|
| 29 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 30 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
BUD_DEPT_EFF_VW
|
| 31 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
POSITION_DATA
|
| 32 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 33 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 34 |
POSITION_POOL_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Position Pool ID
|
| 35 |
EARNINGS |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Earnings
|
| 36 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 37 |
EARNS_END_DT |
Date(10) |
DATE |
Earnings End Date
|
| 38 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 39 |
DEFAULT_FUND_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Funding Source Option
A=Distrib over Actual Earnings
E=Earnings Funding Source
N=No Defaults
S=Specified Defaults
|
| 40 |
HP_DISTRIB_OVRRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Actuals Distribution overriden at the Actuals Distribution Panel
|
| 41 |
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.
|
| 42 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table:
BENEF_PLAN_TBL
|
| 43 |
DEDCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Deduction Code
Prompt Table:
DEDUCTION_TBL
|
| 44 |
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
Prompt Table:
DED_CLASS_VW
|
| 45 |
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
|
| 46 |
DED_CUR |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Current Deduction
|
| 47 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TAX_TBL
|
| 48 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
Prompt Table:
LOCAL_TAX_TBL
|
| 49 |
TAX_CLASS |
Character(3) |
VARCHAR2(3) NOT NULL |
Tax Balance Class
|
| 50 |
TAX_CUR |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Current Tax
|
| 51 |
PROVINCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Province
Prompt Table:
CAN_TAX_PROV
|
| 52 |
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
|
| 53 |
HP_FIELD_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Description for use by Retro Distribution query
|
| 54 |
HP_FIELD_VALUE |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Value used for generic field search where the field name is not known
|
| 55 |
HP_REMAINDER_AMT |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
Remainder for AE Calculations
|
| 56 |
HP_USE_SPACES |
Character(1) |
VARCHAR2(1) NOT NULL |
Allowed to search and uodate with spaces. IE Field on database actually can contain space, not required.
|
| 57 |
HP_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used to indicated wors exist in App Engine
|