SF_VARS_PID_VW(SQL View) |
Index Back |
|---|---|
Variances & Production ID View |
| SELECT DISTINCT a.business_unit , a.production_id , a.variance_type FROM PS_SF_VARIANCES a , ps_sf_prdnid_headr b WHERE a.business_unit = b.business_unit AND a.production_id = b.production_id |
| # | 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 | 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 |