RUN_HP_RETDIST

(SQL Table)
Index Back

Retro Distribution Transaction

This is the parent table of all transactions created for a retro distribution process

# 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
4 OPRID_LAST_UPDT Character(30) VARCHAR2(30) NOT NULL Last Operator to Update
5 CREATION_DT Date(10) DATE Creation Date
6 PAY_DT Date(10) DATE Date of Pay
7 HP_TRANSACTION_SRC Character(1) VARCHAR2(1) NOT NULL Retro Distribution Transaction Source
B=Budget Changes
R=Direct Access Changes
8 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

9 HP_SELECTED Character(1) VARCHAR2(1) NOT NULL Transaction Selected

Y/N Table Edit

Default Value: N

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