OP_SEQUENCEWORK_CENTER_CODEBUSINESS_UNITPRDN_AREA_CODEINV_ITEM_IDPRODUCTION_TYPEPR=Production
RW=Rework
SV=Service
TD=Teardown
PRODUCTION_IDSF_ENTRY_DATESF_ACTHRS_L1_VW(SQL View) |
Index Back |
|---|---|
Actual Hours Inq - Level 19711?? anna ( CN# SF750-5.0) : used to summarize all data, and display directly - this is at level 1. 971127 cam (CN# DI-TSMITH-2) : Renamed view. 971210 anna replaced prdn_date to sf_entry_date - makes more meaning !! |
| select distinct OP_SEQUENCE, WORK_CENTER_CODE, BUSINESS_UNIT, PRDN_AREA_CODE, INV_ITEM_ID, PRODUCTION_TYPE, PRODUCTION_ID, SF_ENTRY_DATE, sum(LAB_SETUP) + sum(LAB_RUN) + sum(LAB_FIXED_RUN) + sum(LAB_POSTPROD) + sum(LAB_SCHED_HRS), sum(MACH_SETUP) + sum(MACH_RUN) + sum(MACH_FIXED_RUN) + sum(MACH_POSTPROD) + sum(MACH_SCHED_HRS), sum(LAB_SETUP) , sum(MACH_SETUP), sum(LAB_RUN) , sum(MACH_RUN), sum(LAB_FIXED_RUN), sum(MACH_FIXED_RUN), sum(LAB_POSTPROD) , sum(MACH_POSTPROD), sum(LAB_SCHED_HRS) ,sum(MACH_SCHED_HRS) from PS_SF_ACTHRS group by BUSINESS_UNIT, PRDN_AREA_CODE, INV_ITEM_ID, PRODUCTION_TYPE, PRODUCTION_ID, OP_SEQUENCE, WORK_CENTER_CODE, SF_ENTRY_DATE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 2 | WORK_CENTER_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Work Center |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | PRDN_AREA_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 5 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | 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 |
| 7 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 8 | SF_ENTRY_DATE |
Date(10) | DATE | Entry Date |
| 9 | TOTAL_LABOR_HOURS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Total Labor Hours |
| 10 | TOTAL_MACH_HRS | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Total Machine Hours |
| 11 | TOTAL_LAB_SETUPHRS | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Total Lab Setup hrs |
| 12 | TOTAL_MAC_SETUPHRS | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Total Machine Setup Hrs |
| 13 | TOTAL_LAB_RUNHRS | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Total Lab Run Hrs |
| 14 | TOTAL_MAC_RUNHRS | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Total Machine Run Hrs |
| 15 | TOTAL_LAB_FIXHRS | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Total Lab Fixed Run Hours |
| 16 | TOTAL_MAC_FIXHRS | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Total Machine Fixed Run Hours |
| 17 | TOTAL_LAB_POSHRS | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Total Lab Post Prod Hours |
| 18 | TOTAL_MAC_POSHRS | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Total Machine Post Prod Hours |
| 19 | TOTAL_LAB_SCHHRS | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Total Lab Scheduled Hours |
| 20 | TOTAL_MAC_SCHHRS | Signed Number(10,2) | DECIMAL(8,2) NOT NULL | Total Machine Scheduled Hours |