EP_CAL_PERIOD (SQL Table)	Index Back
EP Period ePerformance table used to store Period information of Performance Calendar.

EP_CAL_PERIOD

(SQL Table)

EP Period

ePerformance table used to store Period information of Performance Calendar.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EP_CALENDAR_ID Character(8) VARCHAR2(8) NOT NULL Calendar id

2 EP_PERIOD_ID Character(8) VARCHAR2(8) NOT NULL This field stores the Period specified for a Calendar ID.

3 PERIOD_BEGIN_DT Date(10) DATE NOT NULL Period Begin Date

4 PERIOD_END_DT Date(10) DATE NOT NULL Period End Date

5 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
Default Value: A

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EP_CALENDAR_ID	Character(8)	VARCHAR2(8) NOT NULL	Calendar id
2	EP_PERIOD_ID	Character(8)	VARCHAR2(8) NOT NULL	This field stores the Period specified for a Calendar ID.
3	PERIOD_BEGIN_DT	Date(10)	DATE NOT NULL	Period Begin Date
4	PERIOD_END_DT	Date(10)	DATE NOT NULL	Period End Date
5	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A