SP_SETBNK_CLSVW

(SQL View)
 Index Back

AP Security View for Bnk Set


SELECT DISTINCT D.OPRCLASS , A.SETID , B.DESCR FROM PS_BANK_ACCT_TBL A , PS_SETID_TBL B , PS_SET_CNTRL_GROUP C , PS_SEC_SETID_CLS D WHERE A.SETID = B.SETID AND B.SETID = C.SETID AND D.SETID = C.SETCNTRLVALUE AND C.REC_GROUP_ID = 'FS_39'

  • Related Language Record: SP_SETB_CLSVWLG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    2 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description