HP_RUN_CNTL_IDOPRID_LAST_UPDTCREATION_DTPAY_DTHP_TRANSACTION_SRCB=Budget Changes
R=Direct Access Changes
A=Approved
C=Complete
D=Delete
E=Editing
I=Initiated
P=Pending
W=Reviewing
HP_RDIST_TRANS(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 | HP_RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID for Panles where two run controls are required |
| 2 | OPRID_LAST_UPDT |
Character(30) | VARCHAR2(30) NOT NULL | Last Operator to Update |
| 3 | CREATION_DT |
Date(10) | DATE | Creation Date |
| 4 | PAY_DT |
Date(10) | DATE | Date of pay |
| 5 | HP_TRANSACTION_SRC |
Character(1) | VARCHAR2(1) NOT NULL |
Retro Distribution Transaction Source
B=Budget Changes R=Direct Access Changes |
| 6 | 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 |
| 7 | PROCESS_DT | Date(10) | DATE | Process Date |
| 8 | APPROVED | Character(1) | VARCHAR2(1) NOT NULL | Approved |
| 9 | HP_APPROVER_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval User Id |
| 10 | APPROVE_DATE | Date(10) | DATE | This field is used to store the current approval date throughout batch processes. |