PL_SF_OP_HEADER

(SQL Table)
 Index Back

PL/Prd Integration Header

This is the Planning/Production Integration Header Record. It is the parent to the Operation List and Operation Resource records. This record is created by the Interface from the Red Pepper Planning system. Each record is keyed to identify who the planner was for the this planning cycle and the date, time and version of the export from Red Pepper. This record is reviewed and approved prior to loading it into the manufacturing system. CN#PL-601-3.06 jjo added detail_count, ep_group_code, pass_number, priority_order 01/07/97 SCC (CN# PL601-5.7): Added index C for selection criteria. Added new field PL_CHUNK_SORT. 10/7/97 ebn CN#EN750-1.0 : Added Reference Routing Item for Master Routing Enhancement 03/16/98 SCC CN#PL750-JOLVERA-0F6D8: Remove pl_valid_bu_vw as prompt table for bu. 02/03/99 ST CN# PL800-10.0 Added Prod Status to record. 2/9/99 jnw CN#SF800-13.0 Added trdn_orig_pid field

  • Parent Record Of PL_SF_OP_LIST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    3 EP_GROUP_CODE Character(6) VARCHAR2(6) NOT NULL Group Code
    4 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
    5 PL_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL 01/09/02 EGS (CN#PL900-1): Added
    6 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
    7 PRODUCTION_TASK Character(254) VARCHAR2(254) NOT NULL Production ID from Red Pepper
    8 PRODUCTION_TYPE Character(2) VARCHAR2(2) NOT NULL JNW 11/1/98 (CN#SF800-13) activated teardown xlat
    PR=Production
    RW=Rework
    SV=Service
    TD=Teardown
    9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    10 TOTAL_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Quantity
    11 NEW_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production Start Qty
    12 EXPECTED_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production End Qty
    13 NEW_START_DATE Date(10) DATE Start Date
    14 NEW_START_TIME Time(15) TIMESTAMP Start Time
    15 NEW_START_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Start Shift
    16 NEW_END_DATE Date(10) DATE Due Date
    17 NEW_END_TIME Time(15) TIMESTAMP Due Time
    18 NEW_END_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Due Shift
    19 PRDN_START_DATE Date(10) DATE Prdn Start Date
    20 PRDN_START_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Prdn Start Shift
    21 PRDN_DUE_DATE Date(10) DATE Prdn Due Date
    22 PRDN_DUE_SHIFT Signed Number(2,0) DECIMAL(1) NOT NULL Prdn Due Shift
    23 ORIG_START_DATE Date(10) DATE Original Start Date
    24 ORIG_START_TIME Time(15) TIMESTAMP Original Start Time
    25 ORIG_END_DATE Date(10) DATE Original Due Date
    26 ORIG_END_TIME Time(15) TIMESTAMP Original DueTime
    27 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
    28 REF_ROUTING_ITEM Character(18) VARCHAR2(18) NOT NULL Reference Routing Item
    29 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
    30 MA_PRDN_ID_FLG Character(1) VARCHAR2(1) NOT NULL 10/18/99 SCC CN#IC800: Add label MAINTAIN_PID
    N=No
    Y=Yes
    31 FROZEN_CD Character(1) VARCHAR2(1) NOT NULL Frozen code
    1=Change from unfrozen to frozen
    2=Change from frozen to unfrozen
    3=No Change
    32 PLAN_FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL 11/01/01 PCL (CN#PL900-1): Updated
    N=No
    Y=Yes
    33 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
    10=Open
    20=Completed
    30=Canceled
    40=Not Pegged
    34 PLAN_NEW_FLG Character(1) VARCHAR2(1) NOT NULL New Order / Schedule

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    38 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

    39 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

    40 RESPONSE_AGENT Character(3) VARCHAR2(3) NOT NULL Planning System
    ERA=Enterprise Planning
    PRA=Production Planning
    41 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

    42 PL_STATUS_CD Character(2) VARCHAR2(2) NOT NULL 08/07/98 SCC CN#APRD-R-SCHEW-8L1TB: Change description for value 10 'Before Planning Time Fence' to 'Expedite'
    10=Expedite
    20=Accepted Horizon
    30=After Cutoff Fence
    40=No Time Fence Defined
    99=Error/Exception
    43 PLANNER_CD Character(12) VARCHAR2(12) NOT NULL Planner Code
    44 USE_RTG_RESOURCES Character(1) VARCHAR2(1) NOT NULL Using Routing Resources

    Y/N Table Edit

    45 PLANNING_TIMESTAMP DateTime(26) TIMESTAMP Planning Date and Time
    46 PASS_NUMBER Character(1) VARCHAR2(1) NOT NULL Pass Number
    47 DETAIL_COUNT Number(3,0) SMALLINT NOT NULL Detail Row Count
    48 PRIORITY_ORDER Number(5,0) INTEGER NOT NULL Priority Order for Schedules
    49 PL_CHUNK_SORT Character(43) VARCHAR2(43) NOT NULL Sort Sequence for Chunking
    50 PLANNING_VERSION Character(20) VARCHAR2(20) NOT NULL Planning Version
    51 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    52 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
    53 PL_SUB_APP_FLG Character(1) VARCHAR2(1) NOT NULL Sub Approval Flg

    Y/N Table Edit

    Default Value: N

    54 FROZEN_SUBSTITUTES Character(1) VARCHAR2(1) NOT NULL Frozen Substitutes
    B=Both
    N=No
    Y=Yes

    Y/N Table Edit

    55 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
    56 TRDN_ORIG_PID Character(10) VARCHAR2(10) NOT NULL 1/1/99 jnw (CN#SF800-13) added field
    57 PL_PLAN_STATUS Character(2) VARCHAR2(2) NOT NULL 11/01/01 PCL (CN#PL900-1): Added
    05=Planned
    15=Firmed
    90=Canceled
    58 PROD_STATUS Character(2) VARCHAR2(2) NOT NULL Production Status
    10=Entered
    15=Firmed
    20=Released
    30=In Process
    40=Pend Cmpl
    50=Completed
    60=Clsd/Labor
    70=Clsd/Acctg
    90=Canceled

    Prompt Table: PL_PLN_STAT_VW

    59 CUM_YIELD Number(8,4) DECIMAL(7,4) NOT NULL Expected Yield %
    60 ORIG_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Original Production Qty
    61 ORIG_EXPECTED_QTY Number(12,4) DECIMAL(11,4) NOT NULL 12/12/2007 JAA 9.1 Apply Planning Updates. Field used to store original PID end quantity
    62 QTY_CHNG_FLG Character(1) VARCHAR2(1) NOT NULL Quantity Change Flag for Supply Planning Post Records

    Y/N Table Edit

    Default Value: N