TL_GRP_S_SRCH

(SQL View)
 Index Back

Search Record For Static Grp

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

SELECT G.CLASSID , D.TL_GROUP_ID , D.DESCR FROM PS_TL_GROUP_TBL D , PS_TL_GRP_PARM_TBL T , PSCLASSDEFN G WHERE (D.TL_GROUP_ID = T.TL_GROUP_ID OR NOT EXISTS ( SELECT 'X' FROM PS_TL_GRP_PARM_TBL T1 WHERE T1.TL_GROUP_ID = D.TL_GROUP_ID)) AND D.GROUP_TYPE_IND = 'S' GROUP BY G.CLASSID, D.TL_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.TL_GROUP_ID = D.TL_GROUP_ID AND A.RECNAME = B.RECNAME AND A.FIELDNAME = B.FIELDNAME AND B.ACCESSIBLE = 'Y') OR 0 = ( SELECT COUNT(*) FROM PS_TL_GRP_PARM_TBL C WHERE C.TL_GROUP_ID = D.TL_GROUP_ID)

  • 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 TL_GROUP_ID Character(7) VARCHAR2(7) NOT NULL Time and Labor Groups
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description