CE_TOTVARS_VW(SQL View) |
Index Back |
|---|
| SELECT a.business_unit , a.production_id , a.prdn_area_code , b.inv_item_id , b.prdn_due_date , b.prdn_due_shift , b.prdn_start_date , b.prdn_start_shift , a.variance_type , SUM(a.variance_amount) FROM PS_SF_VARIANCES a , ps_sf_prdnid_headr b WHERE a.business_unit = b.business_unit AND a.production_id = b.production_id GROUP BY a.business_unit, a.production_id, a.prdn_area_code, b.inv_item_id, b.prdn_due_date, b.prdn_due_shift, b.prdn_start_date, b.prdn_start_shift, a.variance_type |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 3 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 4 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | PRDN_DUE_DATE | Date(10) | DATE | Prdn Due Date |
| 6 | PRDN_DUE_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL | Prdn Due Shift |
| 7 | PRDN_START_DATE | Date(10) | DATE | Prdn Start Date |
| 8 | PRDN_START_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL | Prdn Start Shift |
| 9 | VARIANCE_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
9/9/02 CRC: added variance type '15' for Yield Variance
01=Configuration Variance 02=Usage Variance 03=Component Yield Variance 04=Labor Lot Size Variance 05=Process Routing Variance 06=Efficiency Variance 07=Rate Variance 08=Material Lot Size Variance 09=Rework Expense 10=Rework Labor Expense 11=Outside Processing PPV 12=Mix Variance 13=Teardown Material Expense 14=Teardown Conversion Expense 15=Yield Variance 16=Co-Product Rate Var 17=Material Rate Variance |
| 10 | VARIANCE_AMOUNT | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Variance Amount |