TL_CONS_PER_LV

(SQL View)
 Index Back

Contig Non-Day Periods

Language view for TL_CONS_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 A.START_DT<>A.END_DT AND B.START_DT = %DateAdd(A.END_DT, 1))

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