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 DISTINCT CMP.GB_GROUP_ID , GRPOPR.GB_OPRID , GRP.DESCR FROM PS_GB_SECGRPOPR_TB GRPOPR , PS_GB_SECPNLG_TBL CMP , PS_GB_GROUP_TBL GRP , PSTREESTRCT TS WHERE GRPOPR.GB_GROUP_ID = CMP.GB_GROUP_ID AND GRPOPR.GB_GROUP_ID = GRP.GB_GROUP_ID AND GRPOPR.GB_OPRID = CMP.GB_OPRID AND GRPOPR.EFFDT = CMP.EFFDT AND GRPOPR.EFFDT = ( SELECT MAX(ED1.EFFDT) FROM PS_GB_SECGRPOPR_TB ED1 WHERE GRPOPR.GB_GROUP_ID = ED1.GB_GROUP_ID AND GRPOPR.GB_OPRID = ED1.GB_OPRID AND ED1.EFFDT <= %CurrentDateIn) AND GRPOPR.EFF_STATUS = 'A' AND GRP.EFFDT = ( SELECT MAX(ED2.EFFDT) FROM PS_GB_GROUP_TBL ED2 WHERE GRPOPR.GB_GROUP_ID = ED2.GB_GROUP_ID AND ED2.EFFDT <= %CurrentDateIn) AND TS.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