MSC_AGGR_MEASURE_DATA_SRC_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 SRC_LVL_MEMBER_ID PRD_LEVEL_ID ORG_LEVEL_ID SRC_LEVEL_ID SOR_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, CLG_LVL_MEMBER_ID SRC_LVL_MEMBER_ID, PRD_LVL_ID PRD_LEVEL_ID, ORG_LVL_ID ORG_LEVEL_ID, CLG_LVL_ID SRC_LEVEL_ID, SOR_LVL_ID SOR_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