TL_CALENDAR (SQL Table)	Index Back
Calendar Table This table is used to define time period calendar. At the time of conversion, customer has to identify the records of non-dynamic periods and only those records shall be moved in to this table.

TL_CALENDAR

(SQL Table)

Calendar Table

This table is used to define time period calendar. At the time of conversion, customer has to identify the records of non-dynamic periods and only those records shall be moved in to this table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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
Default Value: CO

2 PERIOD_ID Character(12) VARCHAR2(12) NOT NULL Time Period ID

3 START_DT Date(10) DATE NOT NULL Start Date

4 END_DT Date(10) DATE end date

5 PERIOD_SEQUENCE Number(10,0) DECIMAL(10) NOT NULL Sequence Number of Period ID
Default Value: 1

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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 Default Value: CO
2	PERIOD_ID	Character(12)	VARCHAR2(12) NOT NULL	Time Period ID
3	START_DT	Date(10)	DATE NOT NULL	Start Date
4	END_DT	Date(10)	DATE	end date
5	PERIOD_SEQUENCE	Number(10,0)	DECIMAL(10) NOT NULL	Sequence Number of Period ID Default Value: 1