SF_MIXVARS_VW (SQL View)	Index Back
Mix Variance

SF_MIXVARS_VW

(SQL View)

Mix Variance

SELECT BUSINESS_UNIT ,PRODUCTION_ID ,VARIANCE_TYPE ,COST_ELEMENT ,MG_OUTPUT_ITEM ,MG_OUTPUT_TYPE ,OP_SEQUENCE ,QTY_CODE ,MG_OUTPUT_SCHD_QTY ,COMPLETED_QTY ,SUM(TL_COST) ,SUM(LL_COST) ,SUM(VARIANCE_AMOUNT) ,SUM(VARIANCE_AMOUNT3) FROM PS_SF_VARS_DETAIL GROUP BY BUSINESS_UNIT ,PRODUCTION_ID ,VARIANCE_TYPE ,MG_OUTPUT_ITEM ,MG_OUTPUT_TYPE ,OP_SEQUENCE ,QTY_CODE ,COST_ELEMENT ,MG_OUTPUT_SCHD_QTY ,COMPLETED_QTY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

3 VARIANCE_TYPE Character(2) VARCHAR2(2) NOT NULL 9/9/02 CRC: added variance type '15' for Yield Variance
01=Configuration Variance
02=Usage Variance
03=Component Yield Variance
04=Labor Lot Size Variance
05=Process Routing Variance
06=Efficiency Variance
07=Rate Variance
08=Material Lot Size Variance
09=Rework Expense
10=Rework Labor Expense
11=Outside Processing PPV
12=Mix Variance
13=Teardown Material Expense
14=Teardown Conversion Expense
15=Yield Variance
16=Co-Product Rate Var
17=Material Rate Variance

4 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element

5 MG_OUTPUT_ITEM Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id. 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item number on a Bill of Materials. This item may be either a co-product or a by-product on the BOM. The output type field determines which one it represents. There should always be at least one output item on the BOM at all times; this output item is the same as the BOMs item id.

6 MG_OUTPUT_TYPE Character(2) VARCHAR2(2) NOT NULL 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle). 11/23/98 (CN#SF800-13) JNW added teardown xlat
CP=Primary
CS=Co-Product
RB=Recycle
TD=Teardown
WB=Waste

7 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

8 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order

9 MG_OUTPUT_SCHD_QTY Number(12,4) DECIMAL(11,4) NOT NULL Schedule qty

10 COMPLETED_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Completed Qty

11 TL_COST Number(15,4) DECIMAL(14,4) NOT NULL This Level Cost

12 LL_COST Number(15,4) DECIMAL(14,4) NOT NULL Lower Level Cost

13 VARIANCE_AMOUNT Signed Number(16,4) DECIMAL(14,4) NOT NULL Variance Amount

14 VARIANCE_AMOUNT3 Signed Number(18,6) DECIMAL(16,6) NOT NULL Variance Amount with decimal precision of 6 used by Variance Drilldown.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
3	VARIANCE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	9/9/02 CRC: added variance type '15' for Yield Variance 01=Configuration Variance 02=Usage Variance 03=Component Yield Variance 04=Labor Lot Size Variance 05=Process Routing Variance 06=Efficiency Variance 07=Rate Variance 08=Material Lot Size Variance 09=Rework Expense 10=Rework Labor Expense 11=Outside Processing PPV 12=Mix Variance 13=Teardown Material Expense 14=Teardown Conversion Expense 15=Yield Variance 16=Co-Product Rate Var 17=Material Rate Variance
4	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
5	MG_OUTPUT_ITEM	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 (Internet Architecture) SCC: Uppercase label Id. 10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item number on a Bill of Materials. This item may be either a co-product or a by-product on the BOM. The output type field determines which one it represents. There should always be at least one output item on the BOM at all times; this output item is the same as the BOMs item id.
6	MG_OUTPUT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	10/22/98 (CN#EN800-6.0) LAJ...Created Stores the output item type on a Bill of Materials. The type could represent either a co-product (primary or secondary) or a by-product (waste or recycle). 11/23/98 (CN#SF800-13) JNW added teardown xlat CP=Primary CS=Co-Product RB=Recycle TD=Teardown WB=Waste
7	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
8	QTY_CODE	Character(3)	VARCHAR2(3) NOT NULL	Per ASY=Assembly ORD=Order
9	MG_OUTPUT_SCHD_QTY	Number(12,4)	DECIMAL(11,4) NOT NULL	Schedule qty
10	COMPLETED_QTY	Signed Number(13,4)	DECIMAL(11,4) NOT NULL	Completed Qty
11	TL_COST	Number(15,4)	DECIMAL(14,4) NOT NULL	This Level Cost
12	LL_COST	Number(15,4)	DECIMAL(14,4) NOT NULL	Lower Level Cost
13	VARIANCE_AMOUNT	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Variance Amount
14	VARIANCE_AMOUNT3	Signed Number(18,6)	DECIMAL(16,6) NOT NULL	Variance Amount with decimal precision of 6 used by Variance Drilldown.