SF_VARS_SCHD_VW(SQL View) |
Index Back |
|---|---|
Variances & Schedules View |
| SELECT DISTINCT a.business_unit , b.prdn_area_code , b.inv_item_id , a.variance_type , b.prdn_due_date , b.prdn_due_shift , b.prdn_start_date , b.prdn_start_shift , a.production_id 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 | PRDN_AREA_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | 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 |
| 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 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |