FC_CTRL_TBL (SQL Table)	Index Back
Forecast Horizon Control This record is used for tracking forecast period breakdown, period number along with period start and end date, for each horizon by GL business units. The information is derived and saved in this table once to avoid recalculating the dates for the time slices for each forecast row for every employee.

FC_CTRL_TBL

(SQL Table)

Forecast Horizon Control

This record is used for tracking forecast period breakdown, period number along with period start and end date, for each horizon by GL business units. The information is derived and saved in this table once to avoid recalculating the dates for the time slices for each forecast row for every employee.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

2 BEGIN_DT Date(10) DATE NOT NULL Begin Date

3 PERIOD Number(3,0) SMALLINT NOT NULL Period

4 PERIOD_START_DT Date(10) DATE NOT NULL Represents the date commencement point for a given time set utilized in cash worksheet processing.

5 PERIOD_END_DT Date(10) DATE NOT NULL Represents the date termination point for a given time set utilized in cash worksheet processing.

6 END_DT Date(10) DATE NOT NULL End Date

7 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	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
2	BEGIN_DT	Date(10)	DATE NOT NULL	Begin Date
3	PERIOD	Number(3,0)	SMALLINT NOT NULL	Period
4	PERIOD_START_DT	Date(10)	DATE NOT NULL	Represents the date commencement point for a given time set utilized in cash worksheet processing.
5	PERIOD_END_DT	Date(10)	DATE NOT NULL	Represents the date termination point for a given time set utilized in cash worksheet processing.
6	END_DT	Date(10)	DATE NOT NULL	End Date
7	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A