TL_TR_PRDS_VW

(SQL View)
 Index Back

Time Periods of Day/Week/Month

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

SELECT DISTINCT A.PERIOD_ID , A.PERIOD_TYPE ,A.DESCR ,A.DESCRSHORT ,A.START_DAY_OF_WEEK ,A.PERIOD_LENGTH FROM PS_TL_TIME_PERIODS A WHERE A.PERIOD_TYPE IN ('FW','FM') OR (A.PERIOD_TYPE = 'FD' AND A.OFFSET_DAYS = 1)

  • 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
    5 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
    6 PERIOD_LENGTH Number(3,0) SMALLINT NOT NULL Period Length in Days