CE_PID_LAB_VW(SQL View) |
Index Back |
---|---|
Costed Prdn Labor HoursActual Cost Enhancement 10/02 |
SELECT A.BUSINESS_UNIT ,A.PRODUCTION_ID ,A.OP_SEQUENCE ,A.CREW_CODE ,B.SEQ_NBR ,D.MG_SHIFT ,A.TIME_TYPE ,A.CE_ACT_HRS ,B.CE_CREW_RATE ,D.CE_SHIFT_PREMIUM ,%Round(%DecMult(A.CE_ACT_HRS , %DecMult(D.CE_SHIFT_PREMIUM , B.CE_CREW_RATE)), 6) ,A.SF_ENTRY_DATE ,A.DT_TIMESTAMP FROM PS_CE_ACTHRS_VW A , PS_CE_CREW_COST B , PS_CE_HR_CONV C , PS_MG_SHIFTS D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.CREW_CODE = B.CREW_CODE AND B.DATE_IN_EFFECT = ( SELECT MAX(DATE_IN_EFFECT) FROM PS_CE_CREW_COST C WHERE C.DATE_IN_EFFECT <= A.SF_ENTRY_DATE AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.CREW_CODE = A.CREW_CODE AND C.ACTIVE_FLAG = 'A' ) AND %DecMult(A.CE_ACT_HRS , %DecMult(D.CE_SHIFT_PREMIUM , B.CE_CREW_RATE)) <> 0 AND C.CE_SOURCE = 'CREW' AND A.TIME_TYPE = C.CONVERSION_CODE AND C.CE_LAB_OH = 1 AND %Join(COMMON_FIELDS, CE_ACTHRS_VW A, MG_SHIFTS D) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
2 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
3 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
4 | CREW_CODE | Character(10) | VARCHAR2(10) NOT NULL | Crew Name |
5 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
6 | MG_SHIFT | Number(2,0) | SMALLINT NOT NULL |
MG_SHIFT represents the shift code (i.e., 1, 2, 3, etc) for a manufacturing shift.
07/23/98 TKI CN#MG800-5.0
Created to replace SHIFT for the database reconcilation project (8.0)
1=1 2=2 3=3 C=Compressed N=Not Applicable R=Rotating |
7 | 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 |
8 | CE_ACT_HRS | Signed Number(12,5) | DECIMAL(10,5) NOT NULL | Actual Hours |
9 | CE_CREW_RATE | Signed Number(32,15) | DECIMAL(30,15) NOT NULL | Crew Rate |
10 | CE_SHIFT_PREMIUM | Signed Number(32,15) | DECIMAL(30,15) NOT NULL | Shift Premium |
11 | CE_EXTENDED_COST | Signed Number(32,15) | DECIMAL(30,15) NOT NULL | Extended Cost |
12 | DATE_IN_EFFECT | Date(10) | DATE | 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label |
13 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |