DP_CALCLIB_RC

#	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	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
4	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.
5	OPRID2	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
6	RUN_CNTL_ID2	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
7	DP_CONFIGVIEW	Character(20)	VARCHAR2(20) NOT NULL	DP_CONFIGVIEW
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
10	CALC_OPT	Character(2)	VARCHAR2(2) NOT NULL	Used during Change Order batch processing BA=Basic PR=Price Change VC=VAT Other Change VS=VAT Shipto Change
11	ROWS_RETRIEVED	Number(9,0)	DECIMAL(9) NOT NULL	Number of Rows Retrieved
12	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
13	MAX_ROW	Number(9,0)	DECIMAL(9) NOT NULL	Max Number of Rows
14	PERIOD_OFFSET	Signed Number(4,0)	DECIMAL(3) NOT NULL	Override Period
15	DP_FCVIEWLOCK	Character(4)	VARCHAR2(4) NOT NULL	DP_FCVIEWLOCK 0=Not Locked 1=Update Lock 2=View Locked
16	DP_ADJHIST_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	DP_ADJHIST_SEQ
17	DP_WRKQUE_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	DP_WRKQUE_SEQ
18	DP_FCSTARTPERIOD	Number(3,0)	SMALLINT NOT NULL	DP_FCSTARTPERIOD
19	DP_FCSTARTYEAR	Number(4,0)	SMALLINT NOT NULL	DP_FCSTARTYEAR
20	DP_PDSPERYEAR	Number(2,0)	SMALLINT NOT NULL	DP_PDSPERYEAR Default Value: 0
21	DP_CONFIGHISTPDS	Number(3,0)	SMALLINT NOT NULL	DP_CONFIGHISTPDS Default Value: 36
22	DP_CONFIGFUTUREPDS	Number(3,0)	SMALLINT NOT NULL	DP_CONFIGFUTUREPDS Default Value: 24
23	DP_PRICEPERIODS	Number(2,0)	SMALLINT NOT NULL	DP_PRICEPERIODS Default Value: 3
24	DP_PECALCULATIONCD	Character(20)	VARCHAR2(20) NOT NULL	DP_PECALCULATIONCD
25	DP_CALCCODE	Character(20)	VARCHAR2(20) NOT NULL	DP_CALCCODE
26	DP_CALENDARID	Character(20)	VARCHAR2(20) NOT NULL	DP_CALENDARID
27	DP_TIMEPERIODCODE	Character(10)	VARCHAR2(10) NOT NULL	DP_TIMEPERIODCODE
28	DP_UPDATEPCSTATIC	Character(1)	VARCHAR2(1) NOT NULL	DP_UPDATEPCSTATIC Y/N Table Edit Default Value: N
29	DP_VARIANCELAWPDS	Number(3,0)	SMALLINT NOT NULL	DP_VARIANCELAWPDS Default Value: 2
30	DP_CONFIGEVALPDS	Number(3,0)	SMALLINT NOT NULL	DP_CONFIGEVALPDS Default Value: 2
31	DP_SUPPRESSFCCALCS	Character(1)	VARCHAR2(1) NOT NULL	DP_SUPPRESSFCCALCS Y/N Table Edit Default Value: N
32	DP_MAPEADJUPDREQ	Character(1)	VARCHAR2(1) NOT NULL	DP_MAPEADJUPDREQ Y/N Table Edit Default Value: N
33	DP_MAPEEVADJUPDREQ	Character(1)	VARCHAR2(1) NOT NULL	DP_MAPEEVADJUPDREQ Y/N Table Edit Default Value: N
34	DP_MAPEEVPROUPDREQ	Character(1)	VARCHAR2(1) NOT NULL	DP_MAPEEVPROUPDREQ Y/N Table Edit Default Value: N
35	DP_MAPEEVSTAUPDREQ	Character(1)	VARCHAR2(1) NOT NULL	DP_MAPEEVSTAUPDREQ Y/N Table Edit Default Value: N
36	DP_MAPEPROUPDREQ	Character(1)	VARCHAR2(1) NOT NULL	DP_MAPEPROUPDREQ Y/N Table Edit Default Value: N
37	DP_MAPESTATUPDREQ	Character(1)	VARCHAR2(1) NOT NULL	DP_MAPESTATUPDREQ Y/N Table Edit Default Value: N
38	DP_MAPEPERIODS	Number(2,0)	SMALLINT NOT NULL	DP_MAPEPERIODS Default Value: 6