PL_CYCLE_DTL_RQ

(SQL Table)
Index Back

PL_CYCLE_DTL_RQ

PL_CYCLE_DTL_RQ

# 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 PL_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL 01/09/02 EGS (CN#PL900-1): Added
4 STEP Number(2,0) SMALLINT NOT NULL Step
5 PLAN_PROCESS_TYPE Character(2) VARCHAR2(2) NOT NULL PLAN_PROCESS_TYPE
1=Start Planning Engine
10=Load Planning Instance
11=Shutdown Planning Engine
15=Mass Maintenance
20=Initiate Material Solver
30=Extract Demand Violations
35=Post Updates
40=Initiate Feasible Solver
45=Initiate Forecast Consumption
50=Extract Pegging Information
55=Planning Report
60=Excess Stock Report
65=Capacity Report
70=Detail Resources Report
75=PO Auto Sourcing Option
80=Slow Moving Inventory Report
85=Projected Stock Out Report
90=Planning Reschedule Report
92=Planning Updates Report
94=Planning Useup Report
96=Apply Inventory Updates
98=Apply Production Updates
6 RUN_CNTL_ID2 Character(30) VARCHAR2(30) NOT NULL Run Control ID

Prompt Table: %EDITTABLE

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

Prompt Table: SPL_DOMN_URL_VW

8 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
N=No
Y=Yes