| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 HP_RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID for Panles where two run controls are required
|
| 2 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Operator to Update
|
| 3 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
|
| 4 |
PAY_DT |
Date(10) |
DATE |
Date of Pay
|
| 5 |
HP_TRANSACTION_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Distribution Transaction Source
B=Budget Changes
R=Direct Access Changes
|
| 6 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 7 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 8 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 9 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
Y/N Table Edit
|
| 10 |
PAGE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Page Nbr
|
| 11 |
LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Line Nbr
Prompt Table:
PAY_LINE
|
| 12 |
SEPCHK |
Number(2,0) |
SMALLINT NOT NULL |
Separate check number.
|
| 13 |
HP_RDIST_TRANS_NO |
Number(10,0) |
DECIMAL(10) NOT NULL |
Transaction Number
|
| 14 |
HP_RDIST_SUB_TRANS |
Number(5,0) |
INTEGER NOT NULL |
Secondary Transaction Number
|
| 15 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 16 |
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.
|
| 17 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table:
BENEF_PLAN_TBL
|
| 18 |
DEDCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Deduction Code
Prompt Table:
DEDUCTION_TBL
|
| 19 |
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
|
| 20 |
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
|
| 21 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 22 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Accounting Period
|
| 23 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table:
ACCT_CD_CA_VW
|
| 24 |
BUDGET_DATA |
Character(50) |
VARCHAR2(50) NOT NULL |
Budget Data
|
| 25 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 26 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 27 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
POSITION_DATA
|
| 28 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 29 |
POSITION_POOL_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Position Pool ID
|
| 30 |
DED_CUR |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
Current Deduction
|
| 31 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 32 |
EARNS_END_DT |
Date(10) |
DATE |
Earnings End Date
|
| 33 |
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
|
| 34 |
HP_DISTRIB_OVRRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Actuals Distribution overriden at the Actuals Distribution Panel
|
| 35 |
HP_NEW_FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
New Fiscal Year
|
| 36 |
HP_NEW_ACCT_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
New Accounting Period
|
| 37 |
HP_NEW_ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
New Account Code
Prompt Table:
ACCT_CD_CA_VW
|
| 38 |
HP_NEW_ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
New Account Retro Distribution
Prompt Table:
GL_ACCOUNT_TBL
|
| 39 |
NEW_DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
New Department
Prompt Table:
DEPT_TBL
|
| 40 |
NEW_POS_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
New Position
Prompt Table:
POSITION_DATA
|
| 41 |
HP_NEW_JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
New Job Code
Prompt Table:
JOBCODE_TBL
|
| 42 |
HP_NEW_POOL_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
New Position Pool ID
Prompt Table:
HP_NEW_POOL_VW
|
| 43 |
HP_NEW_DED_CUR |
Signed Number(12,2) |
DECIMAL(10,2) NOT NULL |
New Current Deduction
|
| 44 |
HP_ERROR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Distribution Error Occurence
0=OK
R=Rejected during Process
T=Rejected during Creation
|
| 45 |
HP_RETDIST_PAY_DT |
Date(10) |
DATE |
Retro Dist Pay End Date
|