VC_TM_GRP_SRCH

(SQL View)
 Index Back

Group Search Rec in Tree Mgr

GB definition Search Record within Tree Manager. The user can see the groups depending on the security of the group. The group security is set up by components. This view applies the security setup for the component that is defined on the tree structure VC_GROUP_STRUCT

SELECT B.GB_GROUP_ID , A.GB_OPRID , C.DESCR FROM PS_GB_SECGRPOPR_TB A , PS_GB_SECPNLG_TBL B , PS_GB_GROUP_TBL C , PSTREESTRCT D WHERE A.GB_GROUP_ID = B.GB_GROUP_ID AND A.GB_GROUP_ID = C.GB_GROUP_ID AND A.GB_OPRID = B.GB_OPRID AND A.EFFDT = B.EFFDT AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GB_SECGRPOPR_TB WHERE A.GB_GROUP_ID = GB_GROUP_ID AND A.GB_OPRID = GB_OPRID AND EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GB_GROUP_TBL WHERE A.GB_GROUP_ID = GB_GROUP_ID AND EFFDT <= %CurrentDateIn) AND B.PNLGRPNAME = D.NODE_PNLGRPNAME AND D.TREE_STRCT_ID = 'VC_GROUP_STRUCT'

  • Related Language Record: VC_TM_GRP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description