[Home] [Help]
View: AR_CMGT_SCORABLE_DATA_POINTS_V
View Text
SELECT DATA_POINT_ID
, DATA_POINT_NAME
, DATA_POINT_CATEGORY
, APPLICATION_ID
, RETURN_DATA_TYPE
, RETURN_DATE_FORMAT
, DATA_POINT_CODE
FROM AR_CMGT_DATA_POINTS_VL
WHERE SCORABLE_FLAG = 'Y' UNION SELECT DATA_ELEMENT_ID
, DATA_ELEMENT_NAME
, 'DNB' DATA_POINT_CATEGORY
, APPLICATION_ID
, RETURN_DATA_TYPE
, RETURN_DATE_FORMAT
, NULL DATA_POINT_CODE
FROM AR_CMGT_DNB_ELEMENTS_VL
WHERE SCORABLE_FLAG = 'Y'
Columns
Name |
DATA_POINT_ID |
DATA_POINT_NAME |
DATA_POINT_CATEGORY |
APPLICATION_ID |
RETURN_DATA_TYPE |
RETURN_DATE_FORMAT |
DATA_POINT_CODE |