DFW_SF_VARNCES

(SQL View)

SELECT DISTINCT BUSINESS_UNIT , PRODUCTION_ID , VARIANCE_TYPE , COST_ELEMENT , VARIANCE_SOURCE , TRANS_TIME , VARIANCE_AMOUNT FROM PS_SF_VARIANCES

# 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
Prompt Table: CM_ELEMENT

5 VARIANCE_SOURCE Character(2) VARCHAR2(2) NOT NULL Variance Source
C=Close
O=Re-Open
R=Report

6 TRANS_TIME Time(15) TIMESTAMP NOT NULL Transaction Time

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

#	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 Prompt Table: CM_ELEMENT
5	VARIANCE_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Variance Source C=Close O=Re-Open R=Report
6	TRANS_TIME	Time(15)	TIMESTAMP NOT NULL	Transaction Time
7	VARIANCE_AMOUNT	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Variance Amount