| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 4 |
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
Default Value: A
|
| 5 |
TO_DATE |
Date(10) |
DATE |
Latest Date to be sent to PYR
|
| 6 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table:
%EDITTABLE4
|
| 7 |
HP_TRANSACTION_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Distribution Transaction Source
B=Budget Changes
R=Direct Access Changes
|
| 8 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 9 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
|
| 10 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 11 |
END_DT |
Date(10) |
DATE |
end date
|
| 12 |
HP_BEGIN_FISCAL_YR |
Character(4) |
VARCHAR2(4) NOT NULL |
Beginning of Fiscal year, requied for searches
|
| 13 |
HP_BEG_ACCTNG_PER |
Number(3,0) |
SMALLINT NOT NULL |
Beginning of Accounting Period (period only)
|
| 14 |
HP_END_FISCAL_YR |
Character(4) |
VARCHAR2(4) NOT NULL |
End of Fiscal year (required for searches)
|
| 15 |
HP_END_ACCTNG_PER |
Number(3,0) |
SMALLINT NOT NULL |
End of Accounting Period (period only).
|
| 16 |
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
|
| 17 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table:
HP_RDST_CALIDVW
|
| 18 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
HP_RDST_TRIGVW1
|
| 19 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
Prompt Table:
HP_RDST_TRIGVW2
|
| 20 |
HP_IGNOREOFFCYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Option for Ignoring Off cycle pay runs when determining next payroll for posting retroactive distribution
Default Value: Y
|
| 21 |
HP_PRIORDAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days Prior Pay End Date
|