TL_CONT_PER_LV

(SQL View)
 Index Back

Contiguous Period Calendars

Language view for TL_CONT_PER_VW

SELECT L.PERIOD_ID , L.LANGUAGE_CD , L.DESCR FROM PS_TL_TIME_PERIODS P , PS_TL_TIME_PER_LAN L WHERE P.PERIOD_ID=L.PERIOD_ID AND (P.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 P.PERIOD_TYPE = 'CO' OR (P.PERIOD_TYPE = 'RE' AND EXISTS ( SELECT 1 FROM PS_TL_CALENDAR WHERE PERIOD_TYPE = 'RE' AND PERIOD_ID = P.PERIOD_ID)))

  • Related Language Record for TL_CONT_PER_VW

  • Parent record: TL_CONS_PER_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Time Period ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description