CA_PROD_GRP_VW(SQL View) |
Index Back |
|---|---|
View for Analytic Prod MetricView for Analytic Product Metric |
| SELECT CD.PRODUCT_GROUP , 0 , 0 , 0 , ' ' FROM PS_CA_DETAIL CD , PS_CA_CONTR_HDR HDR , PS_SET_CNTRL_GROUP SCG WHERE HDR.CONTRACT_NUM = CD.CONTRACT_NUM AND HDR.BUSINESS_UNIT = SCG.SETCNTRLVALUE AND SCG.REC_GROUP_ID = 'OM_56' GROUP BY CD.PRODUCT_GROUP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Product Group |
| 2 | NUM_RECORDS | Number(15,0) | DECIMAL(15) NOT NULL | Number of Records |
| 3 | CONTRACT_TOTAL_BIL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Contracts total billing amount |
| 4 | CONTRACT_TOTAL_REV | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Revenue Amount |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |