TL_CONS_PER_VW

(SQL View)
 Index Back

Contiguous NonDay Calendars

View created for Template Rules where the rule require periods to be longer than a day and 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 WHERE 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 A.START_DT<>A.END_DT AND B.START_DT = %DateAdd(A.END_DT, 1))

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