[Home] [Help]
View: EDW_BIM_IHRS_IH_RESULT_LCV
Product: | BIM - Marketing Intelligence |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT RSLT.RESULT_ID || '-' || INST.INSTANCE_CODE INTRCTN_RESULT_PK
, 'ALL' ALL_FK
, RSLT.SHORT_DESCRIPTION RESULT_DP
, RSLT.SHORT_DESCRIPTION NAME
, RSLT.RESULT_CODE RESULT_CODE
, RSLT.POSITIVE_RESPONSE_FLAG POSITIVE_RESPONSE_FLAG
, RSLT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, RSLT.LONG_DESCRIPTION LONG_DESCRIPTION
, INST.INSTANCE_CODE INSTANCE
, RSLT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RSLT.CREATION_DATE CREATION_DATE
FROM JTF_IH_RESULTS_VL RSLT
, EDW_LOCAL_INSTANCE INST WITH READ ONLY
Columns
Name |
INTRCTN_RESULT_PK |
ALL_FK |
RESULT_DP |
NAME |
RESULT_CODE |
POSITIVE_RESPONSE_FLAG |
SHORT_DESCRIPTION |
LONG_DESCRIPTION |
INSTANCE |
LAST_UPDATE_DATE |
CREATION_DATE |