RUN_HP_RETDIST(SQL Table) |
Index Back |
---|---|
Retro Distribution TransactionThis is the parent table of all transactions created for a retro distribution process |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
3 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID for Panles where two run controls are required | |
4 | Character(30) | VARCHAR2(30) NOT NULL | Last Operator to Update | |
5 | Date(10) | DATE | Creation Date | |
6 | Date(10) | DATE | Date of pay | |
7 | 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 |