TI_GROUP_SEC_VW

(SQL View)
 Index Back

Group Build Security View

Group Build Security View

SELECT B.PNLGRPNAME ,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 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 EFF_STATUS = 'A')

  • Related Language Record: TI_GR_SEC_VW_LN

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