View created for TEMPLATE 30 and 31 to list only Daily Periods

TL_DLY_RULE_VW

(SQL View)
 Index Back

SELECT PERIOD_ID , DESCR FROM PS_TL_TIME_PERIODS WHERE PERIOD_TYPE='FD'

# 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