| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RUN_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Updated by Application Engine program - UPGCONVDRVR as follows:
"Y" = program complete.
"N" = program not complete.
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 5 |
JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 6 |
PI_STATUS |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
11/11/02 EGS (CN#PL880-1): Added
|
| 7 |
PROBINST |
Character(20) |
VARCHAR2(20) NOT NULL |
Optimization Problem Instance
|
| 8 |
DT_TIMESTAMP |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 9 |
MESSAGE_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Message Parameter Text
|
| 10 |
CK_PROC_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 11 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 12 |
DUMMY_FIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dummy Field for Hiding Groups
|
| 13 |
CAPACITY_FEASIBLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Make Plan Capacity Feasible
Y/N Table Edit
Default Value: Y
|
| 14 |
MATRL_REALLOCATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Material Reallocation
Y/N Table Edit
Default Value: N
|
| 15 |
ALTERNATE_ROUTING |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Alternate Routing
Y/N Table Edit
Default Value: N
|
| 16 |
ITEM_SUBSTITUTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Item Substitution
Y/N Table Edit
Default Value: N
|
| 17 |
RUN_LATE_PHASE |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Lateness Phase
Y/N Table Edit
Default Value: N
|
| 18 |
RUN_EXCESS_PHASE |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Excess Inventory Phase
Y/N Table Edit
Default Value: N
|
| 19 |
FP_IGNORE_SAFETY |
Character(1) |
VARCHAR2(1) NOT NULL |
FP_IGNORE_SAFETY
1=Ignore Prior to First Demand
2=Ignore
3=Fulfill
Default Value: 3
|
| 20 |
FP_PLANNING_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
FP_PLANNING_MODE
N=Net Change
R=Regenerative
Default Value: R
|
| 21 |
RESCHEDULE_DEMAND |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Rescheduling
Y/N Table Edit
Default Value: N
|
| 22 |
START_PLUGIN |
Character(1) |
VARCHAR2(1) NOT NULL |
START_PLUGIN
Y/N Table Edit
Default Value: N
|
| 23 |
FP_CALC_LLC |
Character(1) |
VARCHAR2(1) NOT NULL |
FP_CALC_LLC
|
| 24 |
REGEN_FORECAST |
Character(1) |
VARCHAR2(1) NOT NULL |
07/17/02 EGS (CN#PL880-1): Added
Y/N Table Edit
Default Value: N
|
| 25 |
USE_XFER_QOH |
Character(1) |
VARCHAR2(1) NOT NULL |
The field is used for feasible solver run control.
Y/N Table Edit
Default Value: N
|
| 26 |
CANCEL_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Status field
Y/N Table Edit
Default Value: Y
|
| 27 |
CANCEL_ENTERED_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Entered Production
|
| 28 |
CANCEL_FIRMED_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Firmed Production
|
| 29 |
CANCEL_INPRCS_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel In-Process Production
|
| 30 |
CANCEL_RELEASED_PR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Released Production
|
| 31 |
CANCEL_TRANSFER |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Order
Y/N Table Edit
Default Value: Y
|
| 32 |
CANCEL_FIRM_PLPR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Firmed Planned Production
Y/N Table Edit
Default Value: Y
|
| 33 |
CANCEL_FIRM_PLPO |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Firmed Planned Purchase Order
Y/N Table Edit
Default Value: Y
|
| 34 |
CANCEL_FIRM_PLTR |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancel Firmed Planned Transfer
Y/N Table Edit
Default Value: Y
|
| 35 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
Prompt Table:
SPL_DOMAIN_LIST
|
| 36 |
COLLECT_START_CNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Pre-Solver Violations
|
| 37 |
COLLECT_FINISH_CNT |
Character(1) |
VARCHAR2(1) NOT NULL |
Post-Solver Violations
|