HS_AWE_DEFN_VW (SQL View)	Index Back
HS AWE Processes Get the list of available Health and Safety process IDs.

HS_AWE_DEFN_VW

(SQL View)

HS AWE Processes

Get the list of available Health and Safety 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 AND TXN.OBJECTOWNERID = 'HHS'

# 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