PER_MT_ANA_RETENTION_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":"HdrSRetention1"}' text_title, ( 1 - round(( SELECT nvl(COUNT(*), 0) FROM per_assignment_supervisors_f x, per_all_assignments_f y WHERE x.person_id = y.person_id AND x.assignment_id = y.assignment_id AND x.effective_start_date BETWEEN sysdate - 4000 AND sysdate AND x.effective_start_date BETWEEN y.effective_start_date AND y.effective_end_date AND y.assignment_status_type NOT IN('ACTIVE') ) / COUNT(1), 2) ) * 100 || '%' 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