[Home] [Help]
View: EDW_BIM_IHOT_IH_OUTCOME_LCV
Product: | BIM - Marketing Intelligence |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT OTC.OUTCOME_ID || '-' || INST.INSTANCE_CODE INTRCTN_OUTCOME_PK
, 'ALL' ALL_FK
, OTC.SHORT_DESCRIPTION OUTCOME_DP
, OTC.SHORT_DESCRIPTION NAME
, OTC.OUTCOME_CODE OUTCOME_CODE
, OTC.POSITIVE_OUTCOME_FLAG POSITIVE_OUTCOME_FLAG
, OTC.SHORT_DESCRIPTION SHORT_DESCRIPTION
, OTC.LONG_DESCRIPTION LONG_DESCRIPTION
, INST.INSTANCE_CODE INSTANCE
, OTC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, OTC.CREATION_DATE CREATION_DATE
FROM JTF_IH_OUTCOMES_VL OTC
, EDW_LOCAL_INSTANCE INST WITH READ ONLY
Columns
Name |
INTRCTN_OUTCOME_PK |
ALL_FK |
OUTCOME_DP |
NAME |
OUTCOME_CODE |
POSITIVE_OUTCOME_FLAG |
SHORT_DESCRIPTION |
LONG_DESCRIPTION |
INSTANCE |
LAST_UPDATE_DATE |
CREATION_DATE |