SP_BUBDTR_CLSVW

(SQL View)
Index Back

Sec Vw Class/BD Business Units

Used in the BD_TREE_NODE panel as a prompt for Business Unit on record BD_CENTER when invoking Operator Class Security

SELECT C.OPRCLASS , A.SETID , B.BUSINESS_UNIT FROM PS_SET_CNTRL_REC A , PS_BUS_UNIT_TBL_FS B , PS_SEC_BU_CLS C WHERE A.RECNAME='TREE_NODE_TBL' AND A.SETCNTRLVALUE = B.BUSINESS_UNIT AND B.BUSINESS_UNIT = C.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description