GB_GROUP_SRCH

(SQL View)
 Index Back

GB definition Search Record

GB definition Search Record. The user can see the groups depending on the security of the group

SELECT B.GB_GROUP_ID , A.GB_OPRID , B.PNLGRPNAME , C.DESCR FROM PS_GB_SECGRPOPR_TB A , PS_GB_SECPNLG_TBL B , PS_GB_GROUP_TBL C 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)

  • Related Language Record: GB_GRP_SRCH_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 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description