GB_GROUP_SRCH1

(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 A.GB_OPRID , B.GB_GROUP_ID , B.PNLGRPNAME , C.DESCR FROM PS_GB_SECGRPOPR_TB A , PS_GB_SECPNLG_TBL B , PS_GB_GROUP_TBL C WHERE B.PNLGRPNAME = 'GB_GRP_DEFN_TABLE' AND 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'

  • Related Language Record: GB_GRP_SRH1_LNG

    • # 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 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
    3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description