PL_RN_ENTER_REQ

(SQL Table)
Index Back

PL_RN_ENTER_REQ

PL_RN_ENTER_REQ

# 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 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

Prompt Table: SP_PRBINS_NONVW

4 LP_IGNORE_SAFETY Character(1) VARCHAR2(1) NOT NULL LP_IGNORE_SAFETY

Y/N Table Edit

Default Value: Y

5 LP_INCL_CAPACITY Character(1) VARCHAR2(1) NOT NULL LP_INCL_CAPACITY

Y/N Table Edit

Default Value: Y

6 LP_ITEM_SUBST Character(1) VARCHAR2(1) NOT NULL LP_ITEM_SUBST

Y/N Table Edit

Default Value: Y

7 LP_DMD_RUNOVER Number(3,0) SMALLINT NOT NULL Demand Runover

Default Value: 3

8 PL_LP_MWEEK_SIZE Number(3,0) SMALLINT NOT NULL PL_LP_MWEEK_SIZE

Default Value: 0

9 PL_LP_NUM_DAYS Number(3,0) SMALLINT NOT NULL PL_LP_NUM_DAYS

Default Value: 0

10 PL_LP_NUM_HOURS Number(3,0) SMALLINT NOT NULL PL_LP_NUM_HOURS

Default Value: 0

11 PL_LP_NUM_MWEEKS Number(3,0) SMALLINT NOT NULL PL_LP_NUM_MWEEKS

Default Value: 0

12 PL_LP_NUM_WEEKS Number(3,0) SMALLINT NOT NULL PL_LP_NUM_WEEKS

Default Value: 0

13 LP_TIMEOUT Number(5,0) INTEGER NOT NULL Enterprise Time Out

Default Value: 0

14 RESCHEDULE_DEMAND Character(1) VARCHAR2(1) NOT NULL Allow Rescheduling

Y/N Table Edit

Default Value: N

15 CALC_LLC Character(1) VARCHAR2(1) NOT NULL Calculate Low Level Codes

Y/N Table Edit

Default Value: Y

16 RUN_LATE_PHASE Character(1) VARCHAR2(1) NOT NULL Run Lateness Phase

Y/N Table Edit

Default Value: N

17 START_PLUGIN Character(1) VARCHAR2(1) NOT NULL START_PLUGIN

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

19 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)

Prompt Table: SPL_DOMN_URL_VW

20 COLLECT_FINISH_CNT Character(1) VARCHAR2(1) NOT NULL Post-Solver Violations

Y/N Table Edit

21 COLLECT_START_CNT Character(1) VARCHAR2(1) NOT NULL Pre-Solver Violations

Y/N Table Edit