CE_PID_LAB_VW

(SQL View)
Index Back

Costed Prdn Labor Hours

Actual 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