CE_OP_TIME_VW

(SQL View)
 Index Back

Calc rtg hours consumed


SELECT A.BUSINESS_UNIT ,A.PRODUCTION_ID ,A.OP_SEQUENCE ,A.WORK_CENTER_CODE ,A.CONVERSION_CODE ,C.DAILY_CAPACITY ,A.CREWSIZE ,A.MACH_RESOURCES ,B.TIME_TYPE ,B.OP_TIME ,B.OP_RATE ,B.OP_TIME_UNIT ,B.OP_RATE_UNIT ,( %DecMult(%DecDiv(B.OP_TIME,60),D.CE_MIN) + %DecMult(B.OP_TIME, %DecMult(C.DAILY_CAPACITY, D.CE_DAY)) + %DecMult(B.OP_TIME,D.CE_HR) + %DecDiv(D.CE_INV_MIN,(%DecMult((B.OP_TIME + B.OP_RATE),60))) + %DecDiv(D.CE_INV_HR,(B.OP_TIME +B.OP_RATE)) + %DecMult(%DecDiv(C.DAILY_CAPACITY,(B.OP_TIME+B.OP_RATE)),D.CE_INV_DY) ) FROM PS_SF_OP_LIST A , PS_SF_OP_TIME B , PS_EN_WORK_CENTER C , PS_CE_HR_CONV D , PS_CE_HR_CONV F WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PRODUCTION_ID = B.PRODUCTION_ID AND A.OP_SEQUENCE = B.OP_SEQUENCE AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.WORK_CENTER_CODE = C.WORK_CENTER_CODE AND B.OP_TIME_UNIT = D.OP_TIME_UNIT AND B.OP_RATE_UNIT = D.OP_RATE_UNIT AND D.CE_SOURCE = 'HOURS' AND F.CE_SOURCE = 'CREW' AND B.TIME_TYPE = F.CONVERSION_CODE

# 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 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
4 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center
5 CONVERSION_CODE Character(4) VARCHAR2(4) NOT NULL Conversion Code
6 DAILY_CAPACITY Number(5,2) DECIMAL(4,2) NOT NULL Average Daily Hours
7 CREWSIZE Number(7,2) DECIMAL(6,2) NOT NULL Crew Size
8 MACH_RESOURCES Number(7,2) DECIMAL(6,2) NOT NULL Machine Resources
9 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
10 OP_TIME Number(9,2) DECIMAL(8,2) NOT NULL Op Time
11 OP_RATE Number(9,2) DECIMAL(8,2) NOT NULL Op Rate
12 OP_TIME_UNIT Character(2) VARCHAR2(2) NOT NULL Time Unit
DY=Days
HR=Hours
MN=Minutes
13 OP_RATE_UNIT Character(2) VARCHAR2(2) NOT NULL Op Rate Unit
UD=Units/Day
UH=Units/Hour
UM=Units/Min
14 CE_HOURS_SPENT Signed Number(33,15) DECIMAL(31,15) NOT NULL Hours Spent