[Home] [Help]
View: CSS_DEF_PROD_SUMMARY_V
Product: | CSS - Support (obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DATA_TYPE
, DATA_VALUE
, 'NEW'
, PERIOD_TYPE
, PERIOD_DATE
, NEW_COUNT
, NEW_PERCENT_CHANGE
FROM CSS_DEF_IR_PROD_SUMMARY UNION ALL SELECT DATA_TYPE
, DATA_VALUE
, 'OPEN'
, PERIOD_TYPE
, PERIOD_DATE
, OPEN_COUNT
, OPEN_PERCENT_CHANGE
FROM CSS_DEF_IR_PROD_SUMMARY UNION ALL SELECT DATA_TYPE
, DATA_VALUE
, 'AVERAGE_AGE'
, PERIOD_TYPE
, PERIOD_DATE
, AVERAGE_AGE
, AVG_AGE_PERCENT_CHANGE
FROM CSS_DEF_IR_PROD_SUMMARY UNION ALL SELECT DATA_TYPE
, DATA_VALUE
, 'DAYS_TO_RESOLUTION'
, PERIOD_TYPE
, PERIOD_DATE
, DAYS_TO_RESOLUTION
, DAYS_TO_RES_PERCENT_CHANGE
FROM CSS_DEF_IR_PROD_SUMMARY
Columns
Name |
DATA_TYPE |
DATA_VALUE |
COUNT_TYPE |
PERIOD_TYPE |
PERIOD_DATE |
COUNT_VALUE |
PERCENT_CHANGE |