PL_PROBINSTDEL

(SQL Table)
Index Back

PL Problem Instance Del

10/29/01 EGS (CN#PL900-1): Added, delete table for PL_PROBINST.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 BU_GROUP Character(6) VARCHAR2(6) NOT NULL 08/16/01 EGS (CN#PL880-1.0): Added

Prompt Table: PL_GROUP_IN_VW

3 PROBINST_STATUS Character(2) VARCHAR2(2) NOT NULL 05/13/02 EGS (CN#PL900-1): Added 10/30/02 NRA Added Status of 'Deleted'
10=Defined
20=Regenerated
30=Net Change
40=Loaded
50=Posted
60=Deleted

Default Value: 10

4 STATUS_DTTM DateTime(26) TIMESTAMP 05/13/02 EGS (CN#PL900-1): Added
5 DBR_RUN_TYPE Character(1) VARCHAR2(1) NOT NULL Run Type
N=Net Change
R=Regenerative
S=Regenerative Select

Default Value: R

6 REGEN_DTTM DateTime(26) TIMESTAMP 09/07/01 EGS (CN#PL900-1): Added.
7 UPDATE_DTTM DateTime(26) TIMESTAMP 02/28/02 EGS (CN#PL900-1): Added
8 PROCESS_DTTM DateTime(26) TIMESTAMP Process Date Time
9 TRANSACTION_LOCKED Character(1) VARCHAR2(1) NOT NULL "An internal work field that

Y/N Table Edit

Default Value: N

10 CURRENT_DTTM DateTime(26) TIMESTAMP 08/27/01 EGS (CN#PL900-1.0): Added
11 PL_LOADED_FLG Character(1) VARCHAR2(1) NOT NULL 03/14/02 EGS (CN#PL900-1): Added

Y/N Table Edit

Default Value: N

12 START_DATE Date(10) DATE Start Date for Gen Standing PO
13 END_DATE Date(10) DATE End Date
14 EARLY_DATE Date(10) DATE 08/31/01 EGS (CN#PL900-1): Added.
15 LATE_DATE Date(10) DATE 08/31/01 EGS (CN#PL900-1): Added.
16 CAPACITY_DATE Date(10) DATE 08/31/01 EGS (CN#PL900-1): Added.
17 FCST_FULFILL_DATE Date(10) DATE 08/31/01 EGS (CN#PL900-1): Added.
18 PLAN_ITEM_TYPE Character(1) VARCHAR2(1) NOT NULL 08/28/01 EGS (CN#PL900-1): Added.
1=Distribution and Master
2=Master and Material
3=All
4=Distribution Only
5=Master Only
6=Material Only

Default Value: 3

19 SPL_FREEZE_PEGGED Character(1) VARCHAR2(1) NOT NULL 11/02/2004 NRA: Added

Y/N Table Edit

Default Value: N

20 INCL_SALES_ORDERS Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: N

21 INCL_QUOTES Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: N

22 INCL_BUYING_AGREE Character(1) VARCHAR2(1) NOT NULL 05/02/02 JNW (CN#PL900-1): Added

Y/N Table Edit

Default Value: N

23 INCL_STOCK_REQUEST Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: N

24 INCL_TFR_DEMAND Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: N

25 INCL_TFR_PL_DEMAND Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: N

26 INCL_FORECAST Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: N

27 INCL_PURCH_ORDERS Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: N

28 INCL_PROD_ORDERS Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr. 08/28/01 EGS (CN#PL900-1): Removed Y/N translates
0=off
1=on

Y/N Table Edit

Default Value: N

29 INCL_TFR_SUPPLY Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: N

30 INCL_PL_PURCH_ORD Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: N

31 INCL_PL_PROD_ORD Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: N

32 INCL_TFR_PL_SUPPLY Character(1) VARCHAR2(1) NOT NULL 03/10/98 SCC CN# PL750-SCHEW-JV26Y: Changed long/short descr.

Y/N Table Edit

Default Value: N

33 INCL_QOH Character(1) VARCHAR2(1) NOT NULL 09/03/01 EGS (CN#PL900-1): Added.

Y/N Table Edit

Default Value: N

34 FIRM_PLAN_ONLY Character(1) VARCHAR2(1) NOT NULL 09/23/02 EGS (CN#PL880-1): Added.

Y/N Table Edit

Default Value: Y

35 NET_CHANGE_QOH Character(1) VARCHAR2(1) NOT NULL 02/11/02 EGS (CN#PL900-1): Added.

Y/N Table Edit

Default Value: N

36 DEL_EXTRA_DMD Character(1) VARCHAR2(1) NOT NULL 02/28/02 EGS (CN#PL900-1): Added

Y/N Table Edit

Default Value: N

37 INCL_PRIORITIES Character(1) VARCHAR2(1) NOT NULL Apply Demand Priorities

Y/N Table Edit

Default Value: N

38 AUTO_MASS_MAINT Character(1) VARCHAR2(1) NOT NULL Auto Mass Maintenance

Y/N Table Edit

Default Value: N

39 POST_LOAD_SOLVER Character(1) VARCHAR2(1) NOT NULL Run Solver after Load
1=Material Solver
2=Feasible Solver
3=Enterprise Feasible Solver

Default Value: 1

40 QUOTE_PERCENT Number(3,0) SMALLINT NOT NULL Acceptance Percentage

Default Value: 100

41 PL_FORECAST_SOURCE Character(1) VARCHAR2(1) NOT NULL PL_FORECAST_SOURCE
N=No Forecast
P=Published Forecasts
S=Forecast Sets
42 FORECAST_SOURCE Character(1) VARCHAR2(1) NOT NULL 08/28/01 EGS (CN#PL900-1): Added
1=Inventory
2=Demand Planning

Default Value: 1

43 FORECAST_SET Character(20) VARCHAR2(20) NOT NULL Forecast Set
44 PL_CONS_METHOD Character(1) VARCHAR2(1) NOT NULL jnw 10/1/99 cn# mg800-12 created field jaa 10/20/00 (cn# v080-Planning Phoenix). The consumption method is used in both the forecast consumption and within the solvers. Added the label Sales Order Demand Date for the PL_GENERATE_PLAN project.
P=Schedule Date
R=Request Date

Default Value: P

45 PLAN_BUCKET Character(1) VARCHAR2(1) NOT NULL 08/03/99 MACN (CN#PL800-33.0) Changed the translate values from D, W, M to 0, 1, 2
0=Daily
1=Weekly
2=Monthly

Default Value: 1

46 FORECAST_LOAD Character(1) VARCHAR2(1) NOT NULL Forecast Load
B=Back Load
F=Front Load

Default Value: F

47 ALLOW_FCST_CONSUME Character(1) VARCHAR2(1) NOT NULL Allow Forecast Consumption

Y/N Table Edit

Default Value: Y

48 FCST_CONS_SEQ Character(1) VARCHAR2(1) NOT NULL 08/28/01 EGS (CN#PL900-1.0): Added
1=Before Proration
2=After Proration

Default Value: 1

49 PL_DDD_FCST_CNSMP Character(1) VARCHAR2(1) NOT NULL Explode Demand for Consumption

Y/N Table Edit

Default Value: N

50 INCL_SO_SHIP Character(1) VARCHAR2(1) NOT NULL jnw 10/01/99 (cn#mg800-12) added field

Y/N Table Edit

Default Value: Y

51 INCL_MSR_SHIP Character(1) VARCHAR2(1) NOT NULL jnw 10/01/99 (cn# mg800-12) added field

Y/N Table Edit

Default Value: Y

52 INCL_TFR_SHIP Character(1) VARCHAR2(1) NOT NULL jnw 10/01/99 (cn# mg800-12) added field

Y/N Table Edit

Default Value: Y

53 PL_NET_CHG_FCST Character(1) VARCHAR2(1) NOT NULL Net Change Forecast

Y/N Table Edit

Default Value: Y

54 REGEN_FORECAST Character(1) VARCHAR2(1) NOT NULL 07/17/02 EGS (CN#PL880-1): Added

Y/N Table Edit

Default Value: N

55 PLANNING_MODE Character(1) VARCHAR2(1) NOT NULL Planning Mode
N=Net Change
R=Regenerative

Default Value: R

56 SOLVER_ITEM_TYPE Character(1) VARCHAR2(1) NOT NULL 08/28/01 EGS (CN#PL900-1): Added
1=Distribution
2=Master
3=Material
4=All

Default Value: 4

57 SOLVER_LEVEL_FLG Character(1) VARCHAR2(1) NOT NULL 08/28/01 EGS (CN#PL900-1): Added.

Y/N Table Edit

Default Value: N

58 LOW_LEVEL_CD Number(3,0) SMALLINT NOT NULL 08/16/01 EGS (CN#PL900-1.0): Added
59 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family

Prompt Table: INV_ITEM_FAM

60 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group

Prompt Table: INV_ITEM_GROUP

61 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code

Prompt Table: PLANNER_TBL

62 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
63 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
64 UTILIZ_CD Character(4) VARCHAR2(4) NOT NULL Utilization Type

Prompt Table: UTILIZ_TYPE_INV

65 SOLVER_LOWER_FLG Character(1) VARCHAR2(1) NOT NULL 08/28/01 EGS (CN#PL900-1): Added.

Y/N Table Edit

Default Value: N

66 LP_DMD_RUNOVER Number(3,0) SMALLINT NOT NULL Demand Runover
67 LP_LTSHIPPENALTY Number(12,2) DECIMAL(11,2) NOT NULL Late Ship Penalty
68 LP_NEGINVPENALTY Number(12,2) DECIMAL(11,2) NOT NULL Negative Invetory Penalty
69 LP_PRIMSRCPENALTY Number(12,2) DECIMAL(11,2) NOT NULL Primary Sourcing Incentive
70 LP_SUBSTPENALTY Number(12,2) DECIMAL(11,2) NOT NULL Substitution Penalty
71 LP_UNSFSTKPENALTY Number(12,2) DECIMAL(11,2) NOT NULL Unsafe Stock Penalty
72 LP_DEMANDTHRESH Number(6,2) DECIMAL(5,2) NOT NULL Enterprise Solver Demand
73 LP_RESOLVETHRESH Number(6,2) DECIMAL(5,2) NOT NULL Enterprise Solver Resolve
74 LP_INVCARRYPENALTY Number(12,2) DECIMAL(11,2) NOT NULL Inventory Carry Over Penalty
75 LP_INVHOLDPENALTY Number(12,2) DECIMAL(11,2) NOT NULL Inventory Holding Penalty
76 REGEN_TEMPLATES Character(1) VARCHAR2(1) NOT NULL Regenerate Sourcing Templates

Y/N Table Edit

Default Value: N

77 PL_SEARCH_DEPTH Number(2,0) SMALLINT NOT NULL Search Depth

Default Value: 1

78 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
79 PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Plan Processed Flag
C=Complete
E=Errors
N=Initialize
P=In Process

Y/N Table Edit

Default Value: N

80 PL_COMP_PREC Number(3,0) SMALLINT NOT NULL 10/08/01 EGS (CN#PL900-1): Added.

Default Value: 10

81 LOCK_FCST Character(1) VARCHAR2(1) NOT NULL 12/24/01 EGS (CN#PL900-1): Merry Christmas

Y/N Table Edit

Default Value: N

82 LOCK_PRDN Character(1) VARCHAR2(1) NOT NULL 12/24/01 EGS (CN#PL900-1): Merry Christmas

Y/N Table Edit

Default Value: N

83 LOCK_PURCH Character(1) VARCHAR2(1) NOT NULL 12/24/01 EGS (CN#PL900-1): Merry Christmas

Y/N Table Edit

Default Value: N

84 LOCK_XFER Character(1) VARCHAR2(1) NOT NULL 12/24/01 EGS (CN#PL900-1): Merry Christmas

Y/N Table Edit

Default Value: N

85 LOCK_MSR Character(1) VARCHAR2(1) NOT NULL 12/24/01 EGS (CN#PL900-1): Merry Christmas

Y/N Table Edit

Default Value: N

86 LOCK_PLNPRDN Character(1) VARCHAR2(1) NOT NULL 12/24/01 EGS (CN#PL900-1): Merry Christmas

Y/N Table Edit

Default Value: N

87 LOCK_PLNPUR Character(1) VARCHAR2(1) NOT NULL 12/24/01 EGS (CN#PL900-1): Merry Christmas

Y/N Table Edit

Default Value: N

88 LOCK_PLNXFER Character(1) VARCHAR2(1) NOT NULL 12/24/01 EGS (CN#PL900-1): Merry Christmas

Y/N Table Edit

Default Value: N

89 LOCK_QOH Character(1) VARCHAR2(1) NOT NULL 12/26/01 EGS (CN#PL900-1): Added

Y/N Table Edit

Default Value: N

90 LOCK_SO Character(1) VARCHAR2(1) NOT NULL 01/02/02 EGS (CN#PL900-1): Added

Y/N Table Edit

Default Value: N

91 LOCK_BA Character(1) VARCHAR2(1) NOT NULL 05/02/02 JNW (CN#PL900-1): Added

Y/N Table Edit

Default Value: N

92 LOCK_QUO Character(1) VARCHAR2(1) NOT NULL 02/25/02 EGS (CN#PL900-1): Added

Y/N Table Edit

Default Value: N

93 LOCK_USEUP Character(1) VARCHAR2(1) NOT NULL 10/29/02 EGS (CN#PL880-1): Added

Y/N Table Edit

Default Value: N

94 PL_SEQ_NBR_PO Number(9,0) DECIMAL(9) NOT NULL 01/10/02 EGS (CN#PL900-1): Added
95 PL_SEQ_NBR_PRDN Number(9,0) DECIMAL(9) NOT NULL 01/10/02 EGS (CN#PL900-1): Added
96 PL_SEQ_NBR_TR Number(9,0) DECIMAL(9) NOT NULL 01/10/02 EGS (CN#PL900-1): Added
97 PL_SEQ_NBR_EXTDMD Number(9,0) DECIMAL(9) NOT NULL 05/09/02 EGS (CN#PL900-1): Added

Default Value: 1

98 PL_USE_FC_SETS Character(1) VARCHAR2(1) NOT NULL Use Forecast Sets

Y/N Table Edit

Default Value: Y

99 PL_USE_PUB_FC Character(1) VARCHAR2(1) NOT NULL Use Published Forecasts

Y/N Table Edit

Default Value: N

100 DP_PUBLISH_DATE Date(10) DATE DP_PUBLISH_DATE
101 DP_PUB_DATE_LAST Character(1) VARCHAR2(1) NOT NULL 03/27/02 PCL (CN#PL900-1.0): Added

Y/N Table Edit

Default Value: N

102 DP_WEIGHTPROFILE Character(20) VARCHAR2(20) NOT NULL DP_WEIGHTPROFILE
103 DP_PUBLISHNAME Character(20) VARCHAR2(20) NOT NULL Publish Name
104 PL_DP_ARRAY_FLD Character(24) VARCHAR2(24) NOT NULL Array Name
105 PL_DP_BU_FLD Character(24) VARCHAR2(24) NOT NULL Business Unit Field

Default Value: DP_LOCATION

106 PL_DP_FCST_TYPE Character(1) VARCHAR2(1) NOT NULL Forecast Type
I=Item Based
P=Product Based
107 PL_DP_ITEM_FLD Character(24) VARCHAR2(24) NOT NULL Item/Product Field

Default Value: DP_ITEMCODE

108 INV_POLICY Character(1) VARCHAR2(1) NOT NULL 11/25/02 EGS (CN#PL880-1): Added
1=Standard
2=Published
3=Published Override Standard

Default Value: 1

109 PL_IP_PUBLISHNAME Character(20) VARCHAR2(20) NOT NULL 11/25/02 EGS (CN#PL880-1): Added
110 PL_IP_PUBLISH_DATE Date(10) DATE 11/25/02 EGS (CN#PL880-1): Added
111 PL_IP_BU_FLD Character(24) VARCHAR2(24) NOT NULL 01/07/03 EGS (CN#PL880-1): Added
112 PL_IP_ITEM_FLD Character(24) VARCHAR2(24) NOT NULL 01/07/03 EGS (CN#PL880-1): Added
113 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
114 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
115 PL_SOLVER_INT1 Number(5,0) INTEGER NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers. 1/13/2011 JWOO: Use PL_SOLVER_INT1 for Ignore Safety Stock option (IGNORE_SAFETY), in show demand transaction.
116 PL_SOLVER_INT2 Number(5,0) INTEGER NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers.
117 PL_SOLVER_INT3 Number(5,0) INTEGER NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers.
118 PL_SOLVER_INT4 Number(5,0) INTEGER NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers.
119 PL_SOLVER_INT5 Number(5,0) INTEGER NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers.
120 PL_SOLVER_INT6 Number(5,0) INTEGER NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers.
121 PL_SOLVER_INT7 Number(5,0) INTEGER NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers.
122 PL_SOLVER_INT8 Number(5,0) INTEGER NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers.
123 PL_SOLVER_INT9 Number(5,0) INTEGER NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers.
124 PL_SOLVER_INT10 Number(5,0) INTEGER NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic problem instance values for solvers.
125 PL_SOLVER_FLG1 Character(1) VARCHAR2(1) NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.

Y/N Table Edit

Default Value: N

126 PL_SOLVER_FLG2 Character(1) VARCHAR2(1) NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.

Y/N Table Edit

Default Value: N

127 PL_SOLVER_FLG3 Character(1) VARCHAR2(1) NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.

Y/N Table Edit

Default Value: N

128 PL_SOLVER_FLG4 Character(1) VARCHAR2(1) NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.

Y/N Table Edit

Default Value: N

129 PL_SOLVER_FLG5 Character(1) VARCHAR2(1) NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.

Y/N Table Edit

Default Value: N

130 PL_SOLVER_FLG6 Character(1) VARCHAR2(1) NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.

Y/N Table Edit

Default Value: N

131 PL_SOLVER_FLG7 Character(1) VARCHAR2(1) NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.

Y/N Table Edit

Default Value: N

132 PL_SOLVER_FLG8 Character(1) VARCHAR2(1) NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.

Y/N Table Edit

Default Value: N

133 PL_SOLVER_FLG9 Character(1) VARCHAR2(1) NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.

Y/N Table Edit

Default Value: N

134 PL_SOLVER_FLG10 Character(1) VARCHAR2(1) NOT NULL 11/11/02 EGS (CN#PL880-1): Added...generic solver parameter.

Y/N Table Edit

Default Value: N

135 DESCR Character(30) VARCHAR2(30) NOT NULL Description
136 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text
137 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference