EX_APR_SETID_VW

(SQL View)
 Index Back

Aprvl Setid View

Prompt view that shows the current setid's setup for Approvals

SELECT A.SETID , A.DESCR , A.DESCRSHORT , A.DESCRLONG FROM PS_SETID_TBL A WHERE EXISTS ( SELECT 'X' FROM PS_EX_APPRVR_TYPE B WHERE A.SETID = B.SETID)

  • Related Language Record: SETID_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 DESCRLONG Long Character CLOB Long Description