SP_SIBBL_OPRVW

(SQL View)
Index Back

Bank Bal Setid


SELECT DISTINCT c.OPRID , a.setid ,b.descr FROM ps_bnk_bal_aaa_vw a ,ps_setid_tbl b ,PS_SEC_SETID_OPR c WHERE a.setid = b.setid AND a.setid = c.setid

  • Related Language Record: SETID_VW_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description