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 | 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 |