TL_NOTIFY_USRVW

(SQL View)
 Index Back

Alert-ready User Lists

Selection of user list definitions that are supported by the Alert generation process.

SELECT EOAWUSER_LIST_ID ,DESCR , EOAWUSER_SOURCE FROM PS_EOAWUSER_LIST A WHERE EOAWUSER_SOURCE IN ('R','S') OR (EOAWUSER_SOURCE = 'C' AND EOAWUSER_LIST_ID LIKE 'TL%' AND EOAWUSER_LIST_ID NOT IN ('TLByGroup1','TLByGroup2', 'TLAdhocGroup'))

  • Related Language Record: TL_NOTIFY_USRLV

  • Parent Record Of TL_NOTIFY_USRLV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOAWUSER_LIST_ID Character(30) VARCHAR2(30) NOT NULL Identifies the user list to be used when creating the approval process.
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 EOAWUSER_SOURCE Character(1) VARCHAR2(1) NOT NULL User List Source
    C=Application Class
    Q=Query
    R=Role
    S=SQL Definition