| # |
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 |
HP_RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID for Panles where two run controls are required
Prompt Table:
HP_BUD020_VW1
|
| 4 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Operator to Update
Prompt Table:
HP_BUD020_VW2
|
| 5 |
HP_APPROVER_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Approval User Id
|
| 6 |
HP_ERROR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Distribution Error Occurence
0=OK
R=Rejected during Process
T=Rejected during Creation
|
| 7 |
HP_PROCESS_STATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Retro Distribution Process State
A=Approved
C=Complete
D=Delete
E=Editing
I=Initiated
P=Pending
W=Reviewing
|
| 8 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
|
| 9 |
HP_END_CREATE_DT |
Date(10) |
DATE |
End of Creation Date Range request
|
| 10 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 11 |
END_DT |
Date(10) |
DATE |
end date
|
| 12 |
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
|