CE_ACTHRS_VW

(SQL View)
 Index Back

Actual Hrs Transaction View


SELECT A.BUSINESS_UNIT , A.PRDN_AREA_CODE , A.INV_ITEM_ID , A.PRODUCTION_TYPE , A.PRODUCTION_ID , A.OP_SEQUENCE , A.WORK_CENTER_CODE ,A.CREW_CODE ,A.MACHINE_CODE , A.SF_ENTRY_DATE , A.SEQ_NBR , A.DT_TIMESTAMP , A.CREW_RPT_FLAG , A.MACH_RPT_FLAG , A.CREWSIZE , A.MACH_RESOURCES , A.MG_SHIFT , B.CE_SOURCE , B.TIME_TYPE , %Round((%DecMult(A.LAB_SETUP,B.LAB_SETUP) + %DecMult(A.LAB_RUN,B.LAB_RUN) + %DecMult(A.LAB_FIXED_RUN, B.LAB_FIXED_RUN) + %DecMult(A.LAB_POSTPROD, B.LAB_POSTPROD) + %DecMult(A.MACH_RUN, B.MACH_RUN) + %DecMult(A.MACH_FIXED_RUN, B.MACH_FIXED_RUN) + %DecMult(A.MACH_POSTPROD, B.MACH_POSTPROD) + %DecMult(A.MACH_SETUP, B.MACH_SETUP)),2) , A.CE_POSTED_FLAG FROM PS_SF_ACTHRS A , PS_CE_ACT_HRS_CONV B , PS_CE_HR_CONV C WHERE C.CE_SOURCE = 'CREW' AND B.TIME_TYPE = C.CONVERSION_CODE AND %Round((%DecMult(A.LAB_SETUP,B.LAB_SETUP) + %DecMult(A.LAB_RUN,B.LAB_RUN) + %DecMult(A.LAB_FIXED_RUN, B.LAB_FIXED_RUN) + %DecMult(A.LAB_POSTPROD, B.LAB_POSTPROD) + %DecMult(A.MACH_RUN, B.MACH_RUN) + %DecMult(A.MACH_FIXED_RUN, B.MACH_FIXED_RUN) + %DecMult(A.MACH_POSTPROD, B.MACH_POSTPROD) + %DecMult(A.MACH_SETUP, B.MACH_SETUP)),2) <> 0

# 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 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area

Prompt Table: SF_PRDN_AREA

3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: SF_PA_NOID_VW

4 PRODUCTION_TYPE Character(2) VARCHAR2(2) NOT NULL JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production
RW=Rework
SV=Service
TD=Teardown
5 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
6 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

Prompt Table: %EDITTABLE

7 WORK_CENTER_CODE Character(10) VARCHAR2(10) NOT NULL Work Center

Prompt Table: EN_WORK_CENTER

8 CREW_CODE Character(10) VARCHAR2(10) NOT NULL Crew Name
9 MACHINE_CODE Character(10) VARCHAR2(10) NOT NULL Machine Code
10 SF_ENTRY_DATE Date(10) DATE Entry Date
11 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
12 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp

Default Value: %DateTime

13 CREW_RPT_FLAG Character(1) VARCHAR2(1) NOT NULL Crew Reporting

Y/N Table Edit

Default Value: N

14 MACH_RPT_FLAG Character(1) VARCHAR2(1) NOT NULL Machine Reporting

Y/N Table Edit

Default Value: N

15 CREWSIZE Number(7,2) DECIMAL(6,2) NOT NULL Crew Size
16 MACH_RESOURCES Number(7,2) DECIMAL(6,2) NOT NULL Machine Resources
17 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
18 CE_SOURCE Character(15) VARCHAR2(15) NOT NULL source
19 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
20 CE_ACT_HRS Signed Number(12,5) DECIMAL(10,5) NOT NULL Actual Hours
21 CE_POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL Posted
6=Cost for 661
N=Cost Pending Calculation
Y=Cost Calculated