TL_GRP_D_SRCH

(SQL View)
 Index Back

Search Record For Dynamic Grp

Search Record For Dynamic Group. This view only shows Dynamic groups.

SELECT G.CLASSID , D.GROUP_ID , D.DESCR FROM PS_TL_GROUP_TBL D , PS_TL_GRP_PARM_TBL T , PSCLASSDEFN G WHERE D.GROUP_ID = T.GROUP_ID AND D.GROUP_TYPE_IND = 'D' GROUP BY G.CLASSID, D.GROUP_ID, D.DESCR HAVING COUNT(*) = ( SELECT COUNT(*) FROM PS_TL_GRP_PARM_TBL A , PS_TL_GRP_FLD_SEC B WHERE B.ROWSECCLASS = G.CLASSID AND A.GROUP_ID = D.GROUP_ID AND A.RECNAME = B.RECNAME AND A.FIELDNAME = B.FIELDNAME AND B.ACCESSIBLE = 'Y')

  • Related Language Record: TL_GROUP_R_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
    2 GROUP_ID Character(5) VARCHAR2(5) NOT NULL Group ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description