CMP_MS_EVT_SALARY_V

Details

• Schema: FUSION

• Object owner: CMP

• Object type: VIEW

Columns

Name
PERSON_ID ASSIGNMENT_ID EVENT_YEAR EVENT_DATE EVENT_DAYS EVENT_TITLE EVENT_DETAILS LINK_TEXT

Query

SQL_Statement

SELECT b.person_id person_id, b.assignment_id assignment_id, EXTRACT(YEAR FROM trunc(a.date_from)) event_year, a.date_from event_date, 0 event_days, a.action_name event_title, decode(sign(nvl(a.last_change_percent, 0)), 0, '', decode(sign(nvl(a.last_change_amount, 0)), 1, '{"strKey":"FdHISALCHNGincrease", "tokens":{"SAL_CHNG":"' || a.last_change_percent || '%"}}', '{"strKey":"FdHISALCHNGdecrease", "tokens":{"SAL_CHNG":"' || a.last_change_percent * - 1 || '%"}}')) event_details, '?pPersonId=' || b.person_id || '&pAssignmentId=' || b.assignment_id || '&pAssignmentNumber=' || b.assignment_number || '&pBusinessTitle=' || b.assignment_name || '&pDisplayName=' || c.display_name || '&pPersonNumber=' || d.person_number || '&pEffectiveDate=' || to_char(sysdate, 'YYYY-MM-DD') link_text FROM cmp_asg_salary_v a, per_all_assignments_f b, per_person_names_f_v c, per_all_people_f d WHERE 1 = 1 AND a.assignment_id = b.assignment_id AND trunc(sysdate) BETWEEN b.effective_start_date AND b.effective_end_date AND b.person_id = c.person_id AND trunc(sysdate) BETWEEN c.effective_start_date AND c.effective_end_date AND b.person_id = d.person_id AND trunc(sysdate) BETWEEN d.effective_start_date AND d.effective_end_date AND a.last_change_percent IS NOT NULL