TL_COMP_VW_LNG

(SQL View)
Index Back

Complex Time Periods Table Vw


SELECT L.PERIOD_ID , C.PERIOD_TYPE ,L.LANGUAGE_CD , L.DESCR FROM PS_TL_TIME_PER_LAN L ,PS_TL_TIME_PERIODS C WHERE L.PERIOD_ID =C.PERIOD_ID AND C.PERIOD_TYPE = 'CO'

  • Related Language Record for TL_COMP_TYPE_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Time Period ID
    2 PERIOD_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies the type of time period, which impacts the parameters used to define the time period as well as the logic used to generate the resulting calendar.
    CO=Complex
    FD=Daily
    FM=Monthly
    FW=Weekly
    RE=Repeating
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description