TL_WEEKPLUS_VW

(SQL View)
 Index Back

Week or Longer Period Calendar

View created for Template Rules where the rule require periods to be one week or longer (TEMPLATE111 being an example).

SELECT PERIOD_ID , DESCR FROM PS_TL_TIME_PERIODS WHERE PERIOD_ID NOT IN ( SELECT PERIOD_ID FROM PS_TL_CALENDAR WHERE %DateAdd(START_DT, 6) > END_DT) AND PERIOD_ID <> 'NONE'

  • Related Language Record: TL_WEEKPLUS_LV

  • Parent record: 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description