CE_RWLABEXP_VW (SQL View)	Index Back
Rework Labor Expense This is the Cost Manager's view for Rework Labor Expense Variance for Variance type 10

CE_RWLABEXP_VW

(SQL View)

Rework Labor Expense

This is the Cost Manager's view for Rework Labor Expense Variance for Variance type 10

SELECT A.BUSINESS_UNIT ,A.PRODUCTION_ID ,A.VARIANCE_TYPE ,A.COMPONENT_ID ,A.ISSUE_QTY ,A.YIELD_QTY ,A.TL_COST ,A.LL_COST ,A.COST_ELEMENT ,B.DESCR ,A.VAR_PRDN_QTY ,A.AOQ ,A.OP_SEQUENCE ,A.WORK_CENTER_CODE ,A.DAILY_CAPACITY ,A.OP_TIME ,A.OP_TIME_UNIT ,A.TIME_TYPE ,A.QTY_ISS_TO_OP ,A.RATE_AMOUNT ,A.RATE_TYPE ,A.OVHD_RATE_CODE ,A.OVERHEAD_PERCENT ,A.OVERHEAD_RATE ,SUM(A.VARIANCE_AMOUNT) ,SUM(A.VARIANCE_AMOUNT3) FROM PS_SF_VARS_DETAIL A , PS_IN_NONATC_VW B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.COST_ELEMENT = B.COST_ELEMENT GROUP BY A.BUSINESS_UNIT ,A.PRODUCTION_ID ,A.VARIANCE_TYPE ,A.COMPONENT_ID ,A.ISSUE_QTY ,A.YIELD_QTY ,A.TL_COST ,A.LL_COST ,A.COST_ELEMENT ,B.DESCR ,A.VAR_PRDN_QTY ,A.AOQ ,A.OP_SEQUENCE ,A.WORK_CENTER_CODE ,A.DAILY_CAPACITY ,A.OP_TIME ,A.OP_TIME_UNIT ,A.TIME_TYPE ,A.QTY_ISS_TO_OP ,A.RATE_AMOUNT ,A.RATE_TYPE ,A.OVHD_RATE_CODE ,A.OVERHEAD_PERCENT ,A.OVERHEAD_RATE

# 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 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.

5 ISSUE_QTY Number(12,4) DECIMAL(11,4) NOT NULL 07/28/99 SCC CN#SF800-9.0: Added label id TO_ISSUE_QTY

6 YIELD_QTY Number(12,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_YIELD_QTY

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

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

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

10 DESCR Character(30) VARCHAR2(30) NOT NULL Description

11 VAR_PRDN_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL Variance Production Quantity This field was created on 05/06/2010 and will be used by the Variance Drilldown inquiry to show how Configuration variance and Material Lot Size variance are calculated during the Production Close. If the user has selected to close Production with remaining assemblies, then this field will be the sum of SF_PRDNID_HEADR.COMPLETED_QTY & SCRAP_QTY. Otherwise, it will be set to the value of SF_PRDNID_HEADR.NEW_PRDN_QTY.

12 AOQ Signed Number(17,4) DECIMAL(15,4) NOT NULL Average Order Qty

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

14 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center

15 DAILY_CAPACITY Number(5,2) DECIMAL(4,2) NOT NULL Average Daily Hours

16 OP_TIME Number(9,2) DECIMAL(8,2) NOT NULL Op Time

17 OP_TIME_UNIT Character(2) VARCHAR2(2) NOT NULL Time Unit
DY=Days
HR=Hours
MN=Minutes

18 TIME_TYPE Character(4) VARCHAR2(4) NOT NULL Time / Resource Type
0100=Planning Labor Setup
0200=Planning Labor Fixed Run
0300=Planning Labor Run
0400=Planning Labor Post Prod
0500=Planning Machine Setup
0600=Planning Machine Fixed Run
0700=Planning Machine Run
0800=Planning Machine Post Prod
1100=Costing Labor Setup
1200=Costing Labor Fixed Run
1300=Costing Labor Run
1400=Costing Labor Post Prod
1500=Costing Machine Setup
1600=Costing Machine Fixed Run
1700=Costing Machine Run
1800=Costing Machine Post Prod
2000=Queue Time
3000=Intransit Time

19 QTY_ISS_TO_OP Number(12,4) DECIMAL(11,4) NOT NULL Quantity Issued to Operation

20 RATE_AMOUNT Number(11,4) DECIMAL(10,4) NOT NULL Rate Amount

21 RATE_TYPE Character(2) VARCHAR2(2) NOT NULL Rate Per
HR=Hourly
UN=Per Unit

22 OVHD_RATE_CODE Character(4) VARCHAR2(4) NOT NULL Conversion Ovhd Rate Code

23 OVERHEAD_PERCENT Number(5,1) DECIMAL(4,1) NOT NULL Conversion Overhead %

24 OVERHEAD_RATE Number(11,4) DECIMAL(10,4) NOT NULL Conversion Overhead Rate

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

26 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	COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 (Internet Architecture) SCC: Uppercase label Id.
5	ISSUE_QTY	Number(12,4)	DECIMAL(11,4) NOT NULL	07/28/99 SCC CN#SF800-9.0: Added label id TO_ISSUE_QTY
6	YIELD_QTY	Number(12,4)	DECIMAL(11,4) NOT NULL	10/12/99 SCC CN#SF800-9.0: Added label id TO_YIELD_QTY
7	TL_COST	Number(15,4)	DECIMAL(14,4) NOT NULL	This Level Cost
8	LL_COST	Number(15,4)	DECIMAL(14,4) NOT NULL	Lower Level Cost
9	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
10	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
11	VAR_PRDN_QTY	Signed Number(13,4)	DECIMAL(11,4) NOT NULL	Variance Production Quantity This field was created on 05/06/2010 and will be used by the Variance Drilldown inquiry to show how Configuration variance and Material Lot Size variance are calculated during the Production Close. If the user has selected to close Production with remaining assemblies, then this field will be the sum of SF_PRDNID_HEADR.COMPLETED_QTY & SCRAP_QTY. Otherwise, it will be set to the value of SF_PRDNID_HEADR.NEW_PRDN_QTY.
12	AOQ	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Average Order Qty
13	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
14	WORK_CENTER_CODE	Character(10)	VARCHAR2(10) NOT NULL	Work Center
15	DAILY_CAPACITY	Number(5,2)	DECIMAL(4,2) NOT NULL	Average Daily Hours
16	OP_TIME	Number(9,2)	DECIMAL(8,2) NOT NULL	Op Time
17	OP_TIME_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Time Unit DY=Days HR=Hours MN=Minutes
18	TIME_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Time / Resource Type 0100=Planning Labor Setup 0200=Planning Labor Fixed Run 0300=Planning Labor Run 0400=Planning Labor Post Prod 0500=Planning Machine Setup 0600=Planning Machine Fixed Run 0700=Planning Machine Run 0800=Planning Machine Post Prod 1100=Costing Labor Setup 1200=Costing Labor Fixed Run 1300=Costing Labor Run 1400=Costing Labor Post Prod 1500=Costing Machine Setup 1600=Costing Machine Fixed Run 1700=Costing Machine Run 1800=Costing Machine Post Prod 2000=Queue Time 3000=Intransit Time
19	QTY_ISS_TO_OP	Number(12,4)	DECIMAL(11,4) NOT NULL	Quantity Issued to Operation
20	RATE_AMOUNT	Number(11,4)	DECIMAL(10,4) NOT NULL	Rate Amount
21	RATE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Rate Per HR=Hourly UN=Per Unit
22	OVHD_RATE_CODE	Character(4)	VARCHAR2(4) NOT NULL	Conversion Ovhd Rate Code
23	OVERHEAD_PERCENT	Number(5,1)	DECIMAL(4,1) NOT NULL	Conversion Overhead %
24	OVERHEAD_RATE	Number(11,4)	DECIMAL(10,4) NOT NULL	Conversion Overhead Rate
25	VARIANCE_AMOUNT	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Variance Amount
26	VARIANCE_AMOUNT3	Signed Number(18,6)	DECIMAL(16,6) NOT NULL	Variance Amount with decimal precision of 6 used by Variance Drilldown.