APS_OP_TIME_VW(SQL View) |
Index Back |
|---|---|
APS Integ Operation Time View |
| SELECT O.BUSINESS_UNIT , O.INV_ITEM_ID , O.RTG_TYPE , O.RTG_CODE , O.RTG_STATE , O.OP_SEQUENCE , O.TASK_INTENSITY , O.OP_OVERLAP , O.SEND_AHEAD_QTY , T.TIME_TYPE , T.OP_TIME , T.OP_TIME_UNIT , T.OP_RATE , T.OP_RATE_UNIT , T.INCLUDE_SETUP FROM PS_EN_RTG_OPS O , PS_EN_RTG_TIME T WHERE O.BUSINESS_UNIT = T.BUSINESS_UNIT AND O.INV_ITEM_ID = T.INV_ITEM_ID AND O.RTG_CODE = T.RTG_CODE AND O.RTG_STATE = T.RTG_STATE AND O.RTG_TYPE = T.RTG_TYPE AND O.RTG_STATE = 'PR' AND O.RTG_TYPE = 'PR' AND O.OP_SEQUENCE = T.OP_SEQUENCE |
| # | 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_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Routing Type
PR=Production RW=Rework TD=Teardown |
| 4 | RTG_CODE | Number(2,0) | SMALLINT NOT NULL | Routing Code |
| 5 | RTG_STATE | Character(2) | VARCHAR2(2) NOT NULL |
Routing State
EN=Engineering PR=Manufacturing |
| 6 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 7 | TASK_INTENSITY | Character(1) | VARCHAR2(1) NOT NULL |
Intensity
0=Labor Time 1=Mach Time 2=Longest 3=Cumulative |
| 8 | OP_OVERLAP | Number(5,1) | DECIMAL(4,1) NOT NULL | CN#PL800-20.0 MACN 06/14/99- Changed the short name |
| 9 | SEND_AHEAD_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Send Ahead Quantity |
| 10 | 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 |
| 11 | OP_TIME | Number(9,2) | DECIMAL(8,2) NOT NULL | Op Time |
| 12 | OP_TIME_UNIT | Character(2) | VARCHAR2(2) NOT NULL |
Time Unit
DY=Days HR=Hours MN=Minutes |
| 13 | OP_RATE | Number(9,2) | DECIMAL(8,2) NOT NULL | Op Rate |
| 14 | OP_RATE_UNIT | Character(2) | VARCHAR2(2) NOT NULL |
Op Rate Unit
UD=Units/Day UH=Units/Hour UM=Units/Min |
| 15 | INCLUDE_SETUP | Character(1) | VARCHAR2(1) NOT NULL |
Include Setup in Lead Time
N=No Y=Yes |