TL_CONT_PER_VW

(SQL View)
 Index Back

Contiguous Period Calendars

View created for Template Rules where the rule require periods to be contiguous (meaning there is no overlap and no gap between the end day of one period and the start of the next.

SELECT PERIOD_ID , DESCR FROM PS_TL_TIME_PERIODS C WHERE C.PERIOD_ID IN ( SELECT A.PERIOD_ID FROM PS_TL_CALENDAR A , PS_TL_CALENDAR B WHERE A.PERIOD_TYPE=B.PERIOD_TYPE AND A.PERIOD_ID=B.PERIOD_ID AND A.PERIOD_SEQUENCE = (B.PERIOD_SEQUENCE - 1) AND B.START_DT = %DateAdd(A.END_DT, 1)) OR C.PERIOD_TYPE = 'CO' OR (C.PERIOD_TYPE = 'RE' AND EXISTS ( SELECT 1 FROM PS_TL_CALENDAR WHERE PERIOD_TYPE = 'RE' AND PERIOD_ID = C.PERIOD_ID))

  • Related Language Record: TL_CONT_PER_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