BUSINESS_UNITPrompt Table: SP_BUMGOP_NONVW
CM_BOOKPrompt Table: CM_BU_BOOK_TBL
Prompt Table: SF_PRID_H_VW
CE_PID_PROAC_VW(SQL View) |
Index Back |
|---|---|
Latest proactive costs3/21/03 lee: Initial create. Used in the PID Progress Inquiry. |
| SELECT A.BUSINESS_UNIT , A.CM_BOOK , A.PRODUCTION_ID , A.DT_TIMESTAMP , %Round(SUM(A.CE_EXTENDED_COST),2) FROM PS_CE_PRDNID_COST A WHERE A.DT_TIMESTAMP = ( SELECT MAX(A1.DT_TIMESTAMP) FROM PS_CE_PRDNID_COST A1 WHERE A.BUSINESS_UNIT = A1.BUSINESS_UNIT AND A.PRODUCTION_ID = A1.PRODUCTION_ID AND A.CM_BOOK = A1.CM_BOOK) GROUP BY A.BUSINESS_UNIT, A.CM_BOOK, A.PRODUCTION_ID, A.DT_TIMESTAMP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUMGOP_NONVW |
| 2 | CM_BOOK |
Character(10) | VARCHAR2(10) NOT NULL |
Cost Book
Prompt Table: CM_BU_BOOK_TBL |
| 3 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL |
Production ID
Prompt Table: SF_PRID_H_VW |
| 4 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |
| 5 | EXTENDED_COST_TOT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Latest Cost Measure |