ATK_ACTIVITY_FREQ_V

Details

• Schema: FUSION

• Object owner: ATK

• Object type: VIEW

Columns

Name
ACTIVITY_CODE ACTIVITY_NAME ACTIVITY_DESCRIPTION FREQUENCY

Query

SQL_Statement
SELECT activity_code, activity_name, activity_description, COUNT(activity_CODE) frequency FROM atk_usage_logs_v usagelog GROUP BY activity_code,activity_name, activity_description