| # |
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 |
HP_RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID for Panles where two run controls are required
|
| 5 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Operator to Update
|
| 6 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
|
| 7 |
PAY_DT |
Date(10) |
DATE |
Date of pay
|
| 8 |
HP_TRANSACTION_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Distribution Transaction Source
B=Budget Changes
R=Direct Access Changes
|
| 9 |
HP_RDIST_ERR_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Distribution Error Processing Option. What to do when errors found in data while processing retro distributions to database
E=Stop on Error
S=Use Suspense Account
Default Value: S
|
| 10 |
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
|
| 11 |
HP_ERROR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag for AE program to allow further processing but stop updates
|
| 12 |
HP_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used to indicated wors exist in App Engine
|
| 13 |
HP_MIN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Minimum Row
|
| 14 |
HP_WARNING_PRODUCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Field used to indicate warnings have been produced and some action needs to be taken as a result.
|
| 15 |
HP_ACCT_CD_SUSPNS |
Character(25) |
VARCHAR2(25) NOT NULL |
Suspense Account Code
|
| 16 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 17 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 18 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 19 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit
|
| 20 |
PAGE_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Page #
|
| 21 |
LINE_NUM |
Number(2,0) |
SMALLINT NOT NULL |
Line #
Prompt Table:
PAY_LINE
|
| 22 |
SEPCHK |
Number(1,0) |
SMALLINT NOT NULL |
Separate check number.
|
| 23 |
HP_RDIST_TRANS_NO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Transaction Number
|
| 24 |
HP_RDIST_SUB_TRANS |
Number(5,0) |
INTEGER NOT NULL |
Secondary Transaction Number
|
| 25 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 26 |
ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Earnings Code
|
| 27 |
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.
|
| 28 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
|
| 29 |
DEDCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Deduction Code
|
| 30 |
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
|
| 31 |
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
|
| 32 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 33 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
|
| 34 |
TAX_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Balance Class
|
| 35 |
PROVINCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Province
|
| 36 |
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
|
| 37 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 38 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Accounting Period
|
| 39 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
|
| 40 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 41 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 42 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 43 |
POSITION_POOL_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Position Pool ID
|
| 44 |
EARNINGS |
Signed Number(15,2) |
DECIMAL(13,2) NOT NULL |
Earnings
|
| 45 |
DED_CUR |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Current Deduction
|
| 46 |
TAX_CUR |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Current Tax
|
| 47 |
HP_NEW_FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
New Fiscal Year
|
| 48 |
HP_NEW_ACCT_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
New Accounting Period
|
| 49 |
HP_NEW_ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
New Account Code
Prompt Table:
ACCT_CD_CA_VW
|
| 50 |
HP_NEW_ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
New Account Retro Distribution
|
| 51 |
NEW_DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
New Department
Prompt Table:
DEPT_TBL
|
| 52 |
NEW_POS_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
New Position
Prompt Table:
POSITION_DATA
|
| 53 |
HP_NEW_JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
New Job Code
Prompt Table:
JOBCODE_TBL
|
| 54 |
HP_NEW_POOL_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
New Position Pool Id
Prompt Table:
HP_NEW_POOL_VW
|
| 55 |
NEW_EARNS_AMT |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
New Earnings Amount
|
| 56 |
HP_NEW_DED_CUR |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
New Current Deduction
|
| 57 |
HP_NEW_TAX_CUR |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
New Current Tax Amount
|
| 58 |
HP_ERROR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Distribution Error Occurence
0=OK
R=Rejected during Process
T=Rejected during Creation
|
| 59 |
HP_RETDIST_PAY_DT |
Date(10) |
DATE |
Retro Dist Pay End Date
|
| 60 |
SETID_DEPT |
Character(5) |
VARCHAR2(5) NOT NULL |
Department SetID
|
| 61 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code SetID
|
| 62 |
HP_RETDIST_SEQ_NO |
Number(5,0) |
INTEGER NOT NULL |
Retro Distrubution process sequence number
|
| 63 |
LAST_SEQ_REC_ADJ |
Number(8,0) |
INTEGER NOT NULL |
Last Seq number for Record Adj
|
| 64 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 65 |
HP_SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 66 |
XREF_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
T&L Xref Num
|
| 67 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 68 |
EARNS_END_DT |
Date(10) |
DATE |
Earnings End Date
|
| 69 |
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
|
| 70 |
HP_DISTRIB_OVRRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Actuals Distribution overriden at the Actuals Distribution Panel
|
| 71 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 72 |
HP_TL_RECS_ADJ |
Character(1) |
VARCHAR2(1) NOT NULL |
TIME LABOR RECORDS ADJUSTED
|
| 73 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 74 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
General Ledger Unit
|
| 75 |
BUDGET_DATA |
Character(50) |
VARCHAR2(50) NOT NULL |
Budget Data
|