| # |
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_DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Secondary Department Id when Dept more than once on one record.
|
| 12 |
HP_FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year when there is more than one occurence on a record
|
| 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 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code SetID
|
| 16 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 17 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 18 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 19 |
HP_NEXT_EFFDT |
Date(10) |
DATE |
Next Effective Date
|
| 20 |
BUDGET_LEVEL_INDC |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Level
A=Appointment
D=Department
J=Jobcode
O=Position Pool
P=Position
|
| 21 |
HP_PRIOR_ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Previous Account Code before Change
|
| 22 |
HP_PREV_EFFDT |
Date(10) |
DATE |
Previous Effective Date
|
| 23 |
HP_PREV_EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Previous Effective Sequence
|
| 24 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
|
| 25 |
PRIOR_EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Prior Effective Status
|
| 26 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 27 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 28 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 29 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit
|
| 30 |
PAGE_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Page #
|
| 31 |
LINE_NUM |
Number(2,0) |
SMALLINT NOT NULL |
Line #
Prompt Table:
PAY_LINE
|
| 32 |
SEPCHK |
Number(1,0) |
SMALLINT NOT NULL |
Separate check number.
|
| 33 |
HP_RDIST_TRANS_NO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Transaction Number
|
| 34 |
HP_RDIST_SUB_TRANS |
Number(5,0) |
INTEGER NOT NULL |
Secondary Transaction Number
|
| 35 |
ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Earnings Code
|
| 36 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 37 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Accounting Period
|
| 38 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table:
ACCT_CD_CA_VW
|
| 39 |
BUDGET_DATA |
Character(50) |
VARCHAR2(50) NOT NULL |
Budget Data
|
| 40 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 41 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
BUD_DEPT_EFF_VW
|
| 42 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
POSITION_DATA
|
| 43 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 44 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 45 |
POSITION_POOL_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Position Pool ID
|
| 46 |
EARNINGS |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Earnings
|
| 47 |
EARNS_END_DT |
Date(10) |
DATE |
Earnings End Date
|
| 48 |
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
|
| 49 |
HP_DISTRIB_OVRRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Actuals Distribution overriden at the Actuals Distribution Panel
|
| 50 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 51 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 52 |
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.
|
| 53 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table:
BENEF_PLAN_TBL
|
| 54 |
DEDCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Deduction Code
Prompt Table:
DEDUCTION_TBL
|
| 55 |
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
|
| 56 |
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
|
| 57 |
DED_CUR |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Current Deduction
|
| 58 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TAX_TBL
|
| 59 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
Prompt Table:
LOCAL_TAX_TBL
|
| 60 |
TAX_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Balance Class
|
| 61 |
TAX_CUR |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Current Tax
|
| 62 |
PROVINCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Province
Prompt Table:
CAN_TAX_PROV
|
| 63 |
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
|
| 64 |
HP_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used to indicated wors exist in App Engine
|