TL_GRP_D_SEC_VW

(SQL View)
 Index Back

Dynamic Group Security View

Dynamic Group Security View

SELECT A.ROWSECCLASS , A.GROUP_ID , B.DESCR FROM PS_TL_GRP_SECURITY A , PS_TL_GROUP_TBL B WHERE B.GROUP_ID = A.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 GROUP_ID Character(5) VARCHAR2(5) NOT NULL Group ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description