PL_MM_PR_RPT

(SQL Table)
 Index Back

Mass Maint Prod Report

01/15/03 NRA (CN#PL880-1.0): Added to maintain reporting information for Production affected by Mass Maintenance

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 STEP Number(2,0) SMALLINT NOT NULL Step
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: PL_PI_BU_IN_VW

4 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: SPL_OPTITM_VW

6 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code

Prompt Table: PL_PROD_RTG_VW

7 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database

Prompt Table: PL_PROD_BOM_VW

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 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
10 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_PRD_STAT_VW

11 EXPECTED_PRDN_QTY Number(12,4) DECIMAL(11,4) NOT NULL Production End Qty
12 PLAN_START_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
13 PLAN_END_DTTM DateTime(26) TIMESTAMP 08/29/01 EGS (CN#PL900-1): Added.
14 PLAN_FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL 11/01/01 PCL (CN#PL900-1): Updated
N=No
Y=Yes
15 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged
16 FROZEN_SUBSTITUTES Character(1) VARCHAR2(1) NOT NULL Frozen Substitutes
B=Both
N=No
Y=Yes
17 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
18 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

Prompt Table: PRCSRUNCNTL