HR_RW_AWEDFN_VW (SQL View)	Index Back
RW AWE Processes Get the list of available HR process IDs.

HR_RW_AWEDFN_VW

(SQL View)

RW AWE Processes

Get the list of available HR process IDs.

SELECT TXN.EOAWPRCS_ID , PRCS.EOAWDEFN_ID FROM PS_EOAW_TXN TXN , PS_EOAW_PRCS PRCS WHERE TXN.EOAWPRCS_ID = PRCS.EOAWPRCS_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID

2 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
2	EOAWDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Framework Definition ID