PER_MT_ANA_WORKERS_V

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name
PERSON_ID ASSIGNMENT_ID TEXT_TITLE TEXT_METRIC TEXT_META BADGE_TEXT BADGE_STATUS PERIOD_CHN_IND_VAL PERIOD_CHN_IND_CMP CHART_TYPE CHART_COLOR CHART_DATA LINK_TEXT

Query

SQL_Statement

SELECT sup.manager_id person_id, sup.manager_assignment_id assignment_id, '{"strKey":"HdrSWorkers"}' text_title, '{"strKey":"OLabelDIRECTSDirectsTOTALTotal", "tokens":{"DIRECTS":"' || nvl(SUM(decode(sup.manager_level, 1, 1, 0)),0) || '","TOTAL":"' || COUNT(1) || '"}}' text_metric, NULL text_meta, NULL badge_text, NULL badge_status, NULL period_chn_ind_val, NULL period_chn_ind_cmp, NULL chart_type, NULL chart_color, NULL chart_data, NULL link_text FROM per_manager_hrchy_dn sup WHERE trunc(sysdate) BETWEEN sup.effective_start_date AND sup.effective_end_date GROUP BY sup.manager_id, sup.manager_assignment_id