RUN_CNTL_PL4011

(SQL Table)
 Index Back

Run Control Record for PLS4001

04/29/99 ST CN# EN800-1.0 Created new Run Control Record for PLS4001 02/22/01 JNW APRD R-ENOWAK-BE8E5 06/22/02 JNW added to_date_sr, from_date_sr, bu_group

# 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_RELEASED Character(1) VARCHAR2(1) NOT NULL Released

Y/N Table Edit

4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: %EDITTABLE5

6 BU_GROUP Character(6) VARCHAR2(6) NOT NULL 08/16/01 EGS (CN#PL880-1.0): Added

Prompt Table: PL_GROUP_IN_VW

7 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit

Prompt Table: SP_BUIN_NONVW

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

Prompt Table: PLANNER_TBL

9 DEST_PLAN_CD Character(12) VARCHAR2(12) NOT NULL Destination Planner Code

Prompt Table: PLANNER_TBL

10 UNAPPROVED_FLG Character(1) VARCHAR2(1) NOT NULL Unapproved Flag

Y/N Table Edit

Default Value: Y

11 APPROVED_FLG Character(1) VARCHAR2(1) NOT NULL Approved by Auditor
D=Denied
N=Not Approved
Y=Approved

Y/N Table Edit

Default Value: N

12 EXPEDITE_FLG Character(1) VARCHAR2(1) NOT NULL 08/24/98 SCC APRD-R-SCHEW-8L1TB: Selection criteria for Expedirte Orders.

Y/N Table Edit

Default Value: Y

13 ACCEPTED_FLG Character(1) VARCHAR2(1) NOT NULL Accepted Flag

Y/N Table Edit

Default Value: Y

14 CUTOFF_FLG Character(1) VARCHAR2(1) NOT NULL Cutoff Flag

Y/N Table Edit

Default Value: Y

15 TOLERANCE_FLG Character(1) VARCHAR2(1) NOT NULL jnw changed long description for planning phoenix - commit plan 10/18/02 JC (CN#PL880-1): Added TOLERANCE label

Y/N Table Edit

Default Value: N

16 PEGGED_FLG Character(1) VARCHAR2(1) NOT NULL Open Pegs

Y/N Table Edit

Default Value: N

17 UNPEGGED_FLG Character(1) VARCHAR2(1) NOT NULL 11/18/2004 NRA : Defined

Y/N Table Edit

Default Value: N

18 PROCESSED_CD Character(1) VARCHAR2(1) NOT NULL Processed Code
E=Processed with Error
I=In Process
N=Not Processed
Y=Processed

Default Value: N

19 PRODUCTION_CLASS Character(1) VARCHAR2(1) NOT NULL 07/27/98 SCC PL800-DI-KMENGE-57: Add Both to translate.
B=Both
I=Production ID
S=Production Schedule

Default Value: B

20 CANCEL_CHNG_FLG Character(1) VARCHAR2(1) NOT NULL Planning Canceled

Y/N Table Edit

21 NEW_CHNG_FLG Character(1) VARCHAR2(1) NOT NULL New Planning Message

Y/N Table Edit

22 ROUTE_CHNG_FLG Character(1) VARCHAR2(1) NOT NULL Planning Routing Changed

Y/N Table Edit

23 SCHED_CHNG_FLG Character(1) VARCHAR2(1) NOT NULL Planning Schedule Change

Y/N Table Edit

24 PL_SUB_APP_FLG Character(1) VARCHAR2(1) NOT NULL Sub Approval Flg

Y/N Table Edit

25 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE

26 FROM_DATE_SO Date(10) DATE 06/20/02 JNW (CN#PL900-1): Added.
27 TO_DATE_SO Date(10) DATE 06/20/02 JNW (CN#PL900-1): Added.
28 FROM_DT Date(10) DATE From Date
29 FROM_DT1 Date(10) DATE From Date
30 SCHD_FROM_DT DateTime(26) TIMESTAMP 05/03/99 ST Created new field for RUN_CNTL_PL4001
31 SCHD_TO_DT DateTime(26) TIMESTAMP 05/03/99 ST Created new field for RUN_CNTL_PL4001
32 TO_DATE_SR Date(10) DATE 03/20/02 EGS (CN#PL900-1): Added.
33 FROM_DATE_SR Date(10) DATE 03/20/02 EGS (CN#PL900-1): Added.
34 FROM_DATE_PR Date(10) DATE 04/16/02 EGS (CN#PL900-1): Added.
35 TO_DATE_PR Date(10) DATE 04/16/02 EGS (CN#PL900-1): Added.
36 FROM_DATE_PO Date(10) DATE 04/02/02 PCL (CN#PL900-1): Added.
37 TO_DATE_PO Date(10) DATE 04/02/02 EGS (CN#PL900-1): Added.
38 FROM_DATE_TR Date(10) DATE 03/20/02 EGS (CN#PL900-1): Added.
39 TO_DATE_TR Date(10) DATE 03/20/02 EGS (CN#PL900-1): Added.
40 FROM_DATE_BA Date(10) DATE 08/30/02 EGS (CN#PL880-1): Added.
41 TO_DATE_BA Date(10) DATE 08/30/02 EGS (CN#PL880-1): Added.
42 PL_EXISTING_ORDER Character(1) VARCHAR2(1) NOT NULL Existing Order

Y/N Table Edit

Default Value: Y

43 PL_NEW_ORDER Character(1) VARCHAR2(1) NOT NULL Planned

Y/N Table Edit

Default Value: Y

44 PL_PO_MSGS_FLG Character(1) VARCHAR2(1) NOT NULL 04/30/99 ST CN# EN800-1.0 Created new flag for Review Planning Messages Report.

Y/N Table Edit

Default Value: Y

45 PL_SO_MSGS_FLG Character(1) VARCHAR2(1) NOT NULL 06/30/02 JNW CN# PL900-1.0 Created new flag for Review Planning Messages Report.

Y/N Table Edit

Default Value: Y

46 PL_QO_MSGS_FLG Character(1) VARCHAR2(1) NOT NULL 06/30/02 JNW CN# PL900-1.0 Created new flag for Review Planning Messages Report.

Y/N Table Edit

Default Value: Y

47 PL_BA_MSGS_FLG Character(1) VARCHAR2(1) NOT NULL 06/30/02 JNW CN# PL900-1.0 Created new flag for Review Planning Messages Report.

Y/N Table Edit

Default Value: Y

48 PL_PRDN_MSGS_FLG Character(1) VARCHAR2(1) NOT NULL 04/30/99 ST CN# EN800-1.0 Created new flag for Review Planning Messages Report.

Y/N Table Edit

Default Value: Y

49 PL_STOCK_MSGS_FLG Character(1) VARCHAR2(1) NOT NULL 06/10/02 JNW PL900 Created field

Y/N Table Edit

Default Value: Y

50 PL_TR_MSGS_FLG Character(1) VARCHAR2(1) NOT NULL 04/30/99 ST CN# EN800-1.0 Created new flag for Review Planning Messages Report.

Y/N Table Edit

Default Value: Y

51 PL_ENTERED Character(1) VARCHAR2(1) NOT NULL Entered

Y/N Table Edit

52 PL_FIRMED Character(1) VARCHAR2(1) NOT NULL Firmed

Y/N Table Edit

53 PL_INPROC Character(1) VARCHAR2(1) NOT NULL In Process

Y/N Table Edit

54 TO_DT Date(10) DATE To Date
55 TO_DT1 Date(10) DATE To Date
56 INCL_PRDN_SCHED Character(1) VARCHAR2(1) NOT NULL 05/09/02 EGS (CN#PL900-1): Added.

Y/N Table Edit

Default Value: Y

57 INCL_PRDN_ID Character(1) VARCHAR2(1) NOT NULL 05/09/02 EGS (CN#PL900-1): Added.

Y/N Table Edit

Default Value: Y

58 QTY_CHNG_FLG Character(1) VARCHAR2(1) NOT NULL Quantity Change Flag for Supply Planning Post Records

Y/N Table Edit

Default Value: N