CE_RTG_HRS_VW2

(SQL View)
 Index Back

RTG hrs by mach/labor size


SELECT A.BUSINESS_UNIT ,A.INV_ITEM_ID ,A.RTG_CODE ,A.OP_SEQUENCE ,A.RTG_TYPE ,A.RTG_STATE ,A.WORK_CENTER_CODE ,A.CONVERSION_CODE ,A.DAILY_CAPACITY ,A.CREWSIZE ,A.MACH_RESOURCES ,A.AOQ ,A.TIME_TYPE ,A.OP_TIME ,A.OP_RATE ,A.OP_TIME_UNIT ,A.OP_RATE_UNIT ,A.CE_HOURS_SPENT ,%DecMult(A.CE_HOURS_SPENT,%DecMult(A.CREWSIZE,B.CE_CREW))+%DecMult(A.CE_HOURS_SPENT,%DecMult(A.MACH_RESOURCES,B.CE_MACH))+%DecMult(A.CE_HOURS_SPENT,B.CE_NOCALC_CREWMACH) FROM PS_CE_RTG_HRS_VW A , PS_CE_HR_CONV B WHERE B.CE_SOURCE = 'CREW' AND A.TIME_TYPE = B.CONVERSION_CODE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
4 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
5 RTG_TYPE Character(2) VARCHAR2(2) NOT NULL Routing Type
PR=Production
RW=Rework
TD=Teardown
6 RTG_STATE Character(2) VARCHAR2(2) NOT NULL Routing State
EN=Engineering
PR=Manufacturing
7 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center
8 CONVERSION_CODE Character(4) VARCHAR2(4) NOT NULL Conversion Code
9 DAILY_CAPACITY Number(5,2) DECIMAL(4,2) NOT NULL Average Daily Hours
10 CREWSIZE Number(7,2) DECIMAL(6,2) NOT NULL Crew Size
11 MACH_RESOURCES Number(7,2) DECIMAL(6,2) NOT NULL Machine Resources
12 AOQ Signed Number(17,4) DECIMAL(15,4) NOT NULL Average Order Qty
13 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
14 OP_TIME Number(9,2) DECIMAL(8,2) NOT NULL Op Time
15 OP_RATE Number(9,2) DECIMAL(8,2) NOT NULL Op Rate
16 OP_TIME_UNIT Character(2) VARCHAR2(2) NOT NULL Time Unit
DY=Days
HR=Hours
MN=Minutes
17 OP_RATE_UNIT Character(2) VARCHAR2(2) NOT NULL Op Rate Unit
UD=Units/Day
UH=Units/Hour
UM=Units/Min
18 CE_HOURS_SPENT Signed Number(33,15) DECIMAL(31,15) NOT NULL Hours Spent
19 CE_TOTAL_HOURS Signed Number(33,15) DECIMAL(31,15) NOT NULL Total Hours