TL_TIME_PERIODS

(SQL Table)
 Index Back

Time Periods Table

This object maintains the definition of Time Periods including all attributes necessary to create Calendars based on a range of Time Period types and durations.

  • Related Language Record: TL_TIME_PER_LAN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Time Period ID
    2 PERIOD_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies the type of time period, which impacts the parameters used to define the time period as well as the logic used to generate the resulting calendar.
    CO=Complex
    FD=Daily
    FM=Monthly
    FW=Weekly
    RE=Repeating
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: TL_TIME_PERIODS.DESCR

    5 SUBTYPE_IND Character(2) VARCHAR2(2) NOT NULL Field defines the valid sub-types available for Time & Labor period types.
    M=Month
    Q=Quarter
    SM=Semi-month
    SY=Semi-year
    X=User Defined
    Y=Year

    Default Value: M

    6 START_DAY_OF_WEEK Character(1) VARCHAR2(1) NOT NULL Start Day of Week
    1=1 - Monday
    2=2 - Tuesday
    3=3 - Wednesday
    4=4 - Thursday
    5=5 - Friday
    6=6 - Saturday
    7=7 - Sunday

    Default Value: 1

    7 PERIOD_LENGTH Number(3,0) SMALLINT NOT NULL Period Length in Days

    Default Value: 1

    8 OFFSET_DAYS Signed Number(4,0) DECIMAL(3) NOT NULL Days Offset from Period End
    9 START_IDX Character(4) VARCHAR2(4) NOT NULL Period starts on
    10 START_UNIT Character(3) VARCHAR2(3) NOT NULL Indicates starting point of a repeating calendar period. Can be expressed as day or day (10 day of every month)
    DAY=Day
    FRI=5-Friday
    MON=1-Monday
    SAT=6-Saturday
    SUN=7-Sunday
    THU=4-Thursday
    TUE=2-Tuesday
    WED=3-Wednesday
    11 BREAK_IDX Character(3) VARCHAR2(3) NOT NULL Break Index for complex Period
    EO=Every Other
    EVE=Every
    12 BREAK_UNIT Character(3) VARCHAR2(3) NOT NULL Break Unit for Complex Period
    MTH=Month
    WEE=Week