RS_AGG_TRC_VW

(SQL View)
 Index Back

TRC codes based on GL BU


SELECT SETID , TRC , DESCR FROM %Table(EX_TRC_MAP_TBL) m1 WHERE EXISTS ( SELECT 'X' FROM %Table(TL_TRC_TBL) WHERE TRC=m1.TRC) AND BUS_HOL_FLG = 'N'

  • Related Language Record: RS_AGG_TRC_VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description