HP_RDISTTRX_VW (SQL View)	Index Back
Retro Distribution Transaction This is the parent table of all transactions created for a retro distribution process

HP_RDISTTRX_VW

(SQL View)

Retro Distribution Transaction

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

SELECT B.HP_RUN_CNTL_ID , B.OPRID_LAST_UPDT , B.CREATION_DT , B.PAY_DT , B.HP_TRANSACTION_SRC , B.HP_PROCESS_STATE , B.PROCESS_DT FROM PS_HP_RDIST_TRANS B

# 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 NOT NULL Creation Date

4 PAY_DT Date(10) DATE NOT NULL 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

#	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 NOT NULL	Creation Date
4	PAY_DT	Date(10)	DATE NOT NULL	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