TL_TR_PRDS_LV

(SQL View)
 Index Back

Lang for TL_TR_PRDS_VW

View of Time Reporting Time Periods, which include the following types of Time Periods: Day, Week, and Month.

SELECT L.PERIOD_ID ,L.LANGUAGE_CD ,L.DESCR ,L.DESCRSHORT FROM PS_TL_TIME_PERIODS A , PS_TL_TIME_PER_LAN L WHERE A.PERIOD_TYPE IN ('FW','FM') OR (A.PERIOD_TYPE = 'FD' AND A.OFFSET_DAYS = 1) AND A.PERIOD_ID=L.PERIOD_ID

  • Related Language Record for TL_TR_PRDS_VW

  • Parent record: TL_ROL_PRDS_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Time Period ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description