TL_GROUP_R_LANG

(SQL View)
 Index Back

Rel Lang Rec for Grp Sec

Rel Lang Rec for Grp Sec

SELECT DISTINCT A.ROWSECCLASS , B.TL_GROUP_ID , B.LANGUAGE_CD , B.DESCR FROM PS_TL_GROUP_VW A , PS_TL_GROUP_LANG B WHERE A.TL_GROUP_ID = B.TL_GROUP_ID

  • Related Language Record for SRCH_EXCEPT_VW1 TL_GROUP_SEC_VW TL_GROUP_VW TL_GRP_D_SEC_VW TL_GRP_D_SRCH TL_GRP_S_SRCH TL_MASS_GRP_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description