TL_CALSPAN_VW (SQL View)	Index Back
TL Calendar Span This view returns the MIN(START_DT) and MAX(END_DT) of all the calendars in the TL_CALENDAR table. It aims to serve as a quick checkpoint / verification for the timely creation of calendars to cover necessary past and future processing.

TL_CALSPAN_VW

(SQL View)

TL Calendar Span

This view returns the MIN(START_DT) and MAX(END_DT) of all the calendars in the TL_CALENDAR table. It aims to serve as a quick checkpoint / verification for the timely creation of calendars to cover necessary past and future processing.

SELECT PERIOD_ID , PERIOD_TYPE , MIN(START_DT) , MAX(END_DT) FROM PS_TL_CALENDAR GROUP BY PERIOD_ID , PERIOD_TYPE

# 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 START_DT Date(10) DATE Start Date

4 END_DT Date(10) DATE end date

#	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	START_DT	Date(10)	DATE	Start Date
4	END_DT	Date(10)	DATE	end date