DP_FCITEMSDRV (SQL Table)	Index Back
Forecast Driver Date Initials Reference # Description 03/01/07 RCW ICE-1506124000 Created for performance enhancements in Forecast Calculation routines

DP_FCITEMSDRV

(SQL Table)

Forecast Driver

Date Initials Reference # Description 03/01/07 RCW ICE-1506124000 Created for performance enhancements in Forecast Calculation routines

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
Prompt Table: DP_VIEW1USER_VW

3 DP_CONFIGLEVEL Number(2,0) SMALLINT NOT NULL DP_CONFIGLEVEL
Prompt Table: DP_CONFIGLEVELS

4 DP_FORECASTITEM Character(120) VARCHAR2(120) NOT NULL DP_FORECASTITEM

5 PROCESSING_GROUP Number(10,0) DECIMAL(10) NOT NULL A group of data to be processed which may be smaller than the group of data identified by the run request. When processing, if the Pass-through Level is greater than the specified Processing Level, the Processing Group should be expanded to include all data at the Pass-through Level.

6 DP_CONTROLGROUP Character(20) VARCHAR2(20) NOT NULL DP_CONTROLGROUP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	DP_CONFIGVIEW	Character(20)	VARCHAR2(20) NOT NULL	DP_CONFIGVIEW Prompt Table: DP_VIEW1USER_VW
3	DP_CONFIGLEVEL	Number(2,0)	SMALLINT NOT NULL	DP_CONFIGLEVEL Prompt Table: DP_CONFIGLEVELS
4	DP_FORECASTITEM	Character(120)	VARCHAR2(120) NOT NULL	DP_FORECASTITEM
5	PROCESSING_GROUP	Number(10,0)	DECIMAL(10) NOT NULL	A group of data to be processed which may be smaller than the group of data identified by the run request. When processing, if the Pass-through Level is greater than the specified Processing Level, the Processing Group should be expanded to include all data at the Pass-through Level.
6	DP_CONTROLGROUP	Character(20)	VARCHAR2(20) NOT NULL	DP_CONTROLGROUP