CE_CONV_ECC_VW (SQL View)	Index Back
Cost Hours Conversion Converts days, minutes, units/day, units/hour, units/minute into hours/unit for caluclating labor and machine costs

CE_CONV_ECC_VW

(SQL View)

Cost Hours Conversion

Converts days, minutes, units/day, units/hour, units/minute into hours/unit for caluclating labor and machine costs

SELECT B.MG_PROC_INSTANCE , B.BUSINESS_UNIT , B.PRODUCTION_ID , B.OP_SEQUENCE , B.COST_ELEMENT , B.TRANS_DATE , B.TRANS_TIME , B.SEQ_NBR , B.CONVERSION_TYPE , B.REVALUE_FLAG ,(%DecMult(A.CE_MIN,%DecDiv(B.OP_TIME_RATE,60)) + %DecMult(A.CE_HR,B.OP_TIME_RATE) + %DecMult(CE_DAY,%DecMult(B.OP_TIME_RATE ,B.DAILY_CAPACITY)) + %DecDiv(A.CE_INV_MIN,%DecMult(B.OP_TIME_RATE,60)) + %DecDiv( A.CE_INV_HR,B.OP_TIME_RATE) + %DecMult(A.CE_INV_DY,%DecDiv(%DecDiv(B.DAILY_CAPACITY,B.OP_TIME_RATE),1))) FROM PS_CE_HR_CONV A , PS_SF_EARNCONCOST B WHERE A.CE_SOURCE = 'HOURS' AND ( A.OP_RATE_UNIT = B.OP_TIME_RATE_UNIT OR A.OP_TIME_UNIT = B.OP_TIME_RATE_UNIT ) AND B.CONVERSION_TYPE < '2000' AND B.OP_TIME_RATE <> 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MG_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

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

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

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

6 TRANS_DATE Date(10) DATE NOT NULL Transaction Date

7 TRANS_TIME Time(15) TIMESTAMP NOT NULL Transaction Time

8 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

9 CONVERSION_TYPE Character(4) VARCHAR2(4) NOT NULL Conversion Type
1100=Lab Setup
1200=Lab Fixed
1300=Labor Run
1400=Lab PostPr
1500=Mach Setup
1600=Mach Fixed
1700=Mach Run
1800=MC PostPrd
2100=Ovhd 1
2200=Ovhd 2
2300=Ovhd 3
2400=Ovhd 4

10 REVALUE_FLAG Character(1) VARCHAR2(1) NOT NULL Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated.
Y/N Table Edit
Default Value: N

11 CE_TOTAL_HOURS Signed Number(33,15) DECIMAL(31,15) NOT NULL Total Hours

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MG_PROC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
4	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
5	COST_ELEMENT	Character(4)	VARCHAR2(4) NOT NULL	Cost Element
6	TRANS_DATE	Date(10)	DATE NOT NULL	Transaction Date
7	TRANS_TIME	Time(15)	TIMESTAMP NOT NULL	Transaction Time
8	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
9	CONVERSION_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Conversion Type 1100=Lab Setup 1200=Lab Fixed 1300=Labor Run 1400=Lab PostPr 1500=Mach Setup 1600=Mach Fixed 1700=Mach Run 1800=MC PostPrd 2100=Ovhd 1 2200=Ovhd 2 2300=Ovhd 3 2400=Ovhd 4
10	REVALUE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Can be either 'Y' or 'N'. This field is located on the ITEM Table and signifies whether or not an item will be considered by the Revaluation Process to be revaluated. Y/N Table Edit Default Value: N
11	CE_TOTAL_HOURS	Signed Number(33,15)	DECIMAL(31,15) NOT NULL	Total Hours