DP_RUN_CNTL_FC

(SQL Table)
Index Back

Forecast Calculate Run Control

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW

Prompt Table: DP_CFGVWUSER_VW

4 DP_CURRENTFCSTART Character(7) VARCHAR2(7) NOT NULL DP_CURRENTFCSTART
5 DP_NEWFCSTART Character(7) VARCHAR2(7) NOT NULL DP_NEWFCSTART
6 DP_SUPPRESSEDVIEW Character(1) VARCHAR2(1) NOT NULL DP_SUPPRESSEDVIEW

Y/N Table Edit

7 DP_PROCEED_BTN Character(1) VARCHAR2(1) NOT NULL Proceed
8 DP_ROLLPRICECOST Character(1) VARCHAR2(1) NOT NULL Roll Forward Period Price/Cost

Y/N Table Edit

Default Value: N

9 DP_PARALLEL_PRCS Number(3,0) SMALLINT NOT NULL Date Initials Reference # Description 03/01/07 RCW ICE-1506124000 Created for performance enhancements in Forecast Calculation routines

Default Value: 1

10 DP_JOBS_IN_PRCS Number(3,0) SMALLINT NOT NULL Date Initials Reference # Description 03/01/07 RCW ICE-1506124000 Created for performance enhancements in Forecast Calculation routines