HP_RDIST_TRNMSG

(SQL View)
 Index Back

Retro Distribution Transaction

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

SELECT A.HP_RUN_CNTL_ID , A.OPRID_LAST_UPDT , A.CREATION_DT , A.PAY_DT , A.HP_TRANSACTION_SRC , A.HP_PROCESS_STATE , A.PROCESS_DT , A.APPROVED , A.HP_APPROVER_ID , A.APPROVE_DATE FROM PS_HP_RDIST_TRANS A WHERE EXISTS ( SELECT MSGSET FROM PS_HP_RDIST_ERNMSG B WHERE A.HP_RUN_CNTL_ID = B.HP_RUN_CNTL_ID AND A.OPRID_LAST_UPDT = B.OPRID_LAST_UPDT AND A.CREATION_DT = B.CREATION_DT AND A.PAY_DT = B.PAY_DT AND A.HP_TRANSACTION_SRC = B.HP_TRANSACTION_SRC) OR EXISTS ( SELECT MSGSET FROM PS_HP_RDIST_DEDMSG C WHERE A.HP_RUN_CNTL_ID = C.HP_RUN_CNTL_ID AND A.OPRID_LAST_UPDT = C.OPRID_LAST_UPDT AND A.CREATION_DT = C.CREATION_DT AND A.PAY_DT = C.PAY_DT AND A.HP_TRANSACTION_SRC = C.HP_TRANSACTION_SRC) OR EXISTS ( SELECT MSGSET FROM PS_HP_RDIST_TAXMSG D WHERE A.HP_RUN_CNTL_ID = D.HP_RUN_CNTL_ID AND A.OPRID_LAST_UPDT = D.OPRID_LAST_UPDT AND A.CREATION_DT = D.CREATION_DT AND A.PAY_DT = D.PAY_DT AND A.HP_TRANSACTION_SRC = D.HP_TRANSACTION_SRC)

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