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' AND A.TRANSACTION_NAME <> 'HR_SALCHANGE'

  • Related Language Record: EO_TRANS_LNG

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