TL_RULE_PRD_VW

(SQL View)
 Index Back

TL Rule Period View

This view returns valid time periods when defining an OPA Rule

SELECT TP.PERIOD_ID , TP.DESCR , %DateDiff(TLC.START_DT, TLC.END_DT) + 1 FROM PS_TL_TIME_PERIODS TP , PS_TL_CALENDAR TLC WHERE TP.PERIOD_ID = TLC.PERIOD_ID AND TP.PERIOD_TYPE <> 'CO' AND TP.OFFSET_DAYS >= 0 AND TLC.PERIOD_SEQUENCE = 1

  • Related Language Record: TL_RULE_PRD_LV

    • # 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
    3 TL_DAYS_IN_PERIOD Number(4,0) SMALLINT NOT NULL Days in Period