WF_TRANS_DESCR

(SQL View)
 Index Back

8.3 Workflow Enhancement

Prompt table to combind WF_HR transactinos with EO_Transaction descriptions

SELECT A.TRANSACTION_NAME , B.DESCR FROM PS_WF_HR_TRANS A , PS_EO_TRANSACTIONS B WHERE A.TRANSACTION_NAME = B.TRANSACTION_NAME AND A.TRANSACTION_NAME <> 'EP_APPRAISAL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description