TL_GRP_D_SEC_VW

(SQL View)
 Index Back

Dynamic Group Security View

Dynamic Group Security View

SELECT A.ROWSECCLASS , A.TL_GROUP_ID , B.DESCR FROM PS_TL_GRP_SECURITY A , PS_TL_GROUP_TBL B WHERE B.TL_GROUP_ID = A.TL_GROUP_ID AND B.GROUP_TYPE_IND = 'D'

  • 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