TL_TIME_PER_LAN

(SQL Table)
Index Back

Time Periods Table

This object represents the definition of Periods. This enhances the ability of the user to create different types of Time Periods. Panels look similar to current system for fixed and Repeating Periods. While converting all the periods will be treated as 'Fixed' type periods.

  • Related Language Record for FO_TIME_PERIODS TL_TIME_PERIODS
  • # 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

    Default Value: TL_TIME_PER_LAN.DESCR