MSC_AGGR_MEASURE_DATA_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name

PLAN_ID PROFILE_ID MEASURE_ID PRD_LVL_MEMBER_ID ORG_LVL_MEMBER_ID CUS_LVL_MEMBER_ID SUP_LVL_MEMBER_ID DCS_LVL_MEMBER_ID ORD_LVL_MEMBER_ID EXP_LVL_MEMBER_ID TIM_LVL_MEMBER_ID CTO_LVL_MEMBER_ID FCM_LVL_MEMBER_ID CLG_LVL_MEMBER_ID SOR_LVL_MEMBER_ID RES_LVL_MEMBER_ID PRD_LEVEL_ID ORG_LEVEL_ID CUS_LEVEL_ID SUP_LEVEL_ID DCS_LEVEL_ID ORD_LEVEL_ID EXP_LEVEL_ID TIM_LEVEL_ID CTO_LEVEL_ID FCM_LEVEL_ID CLG_LEVEL_ID SOR_LEVEL_ID RES_LEVEL_ID UOM VALUE_NUMBER VALUE_DATE VALUE_TEXT CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REFRESH_NUMBER

Query

SQL_Statement

SELECT PLAN_ID, PROFILE_ID, MEASURE_ID, PRD_LVL_MEMBER_ID, ORG_LVL_MEMBER_ID, CUS_LVL_MEMBER_ID, SUP_LVL_MEMBER_ID, DCS_LVL_MEMBER_ID, ORD_LVL_MEMBER_ID, EXP_LVL_MEMBER_ID, TIM_LVL_MEMBER_ID, CTO_LVL_MEMBER_ID, FCM_LVL_MEMBER_ID, CLG_LVL_MEMBER_ID, SOR_LVL_MEMBER_ID, RES_LVL_MEMBER_ID, PRD_LVL_ID PRD_LEVEL_ID , ORG_LVL_ID ORG_LEVEL_ID , CUS_LVL_ID CUS_LEVEL_ID , SUP_LVL_ID SUP_LEVEL_ID , DCS_LVL_ID DCS_LEVEL_ID , ORD_LVL_ID ORD_LEVEL_ID , EXP_LVL_ID EXP_LEVEL_ID , TIM_LVL_ID TIM_LEVEL_ID , 95 CTO_LEVEL_ID , FCM_LVL_ID FCM_LEVEL_ID , CLG_LVL_ID CLG_LEVEL_ID , SOR_LVL_ID SOR_LEVEL_ID , RES_LVL_ID RES_LEVEL_ID, UOM, VALUE_NUMBER, VALUE_DATE, VALUE_TEXT, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REFRESH_NUMBER FROM MSC_AGGR_MEASURE_DATA