HRT_MS_ANA_SKILLS_ACHIEVED_V
Details
-
Schema: FUSION
-
Object owner: HRT
-
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 pr.person_id, asg.assignment_id, '{"strKey":"HdrSCoreskillsachieved"}' text_title, '{"strKey":"FdHIAttainedSKILLSNUM", "tokens":{"SKILLS_NUM":"' || nvl(skill.developed, 0) || '"}}' text_metric, '{"strKey":"FdHIDevelopingSKILLSNUM", "tokens":{"SKILLS_NUM":"' || nvl(skill.developing, 0) || '"}}' 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, '?pPersonId=' || asg.person_id || '&pAssignmentId=' || asg.assignment_id || '&personId=' || asg.person_id || '&personName=' || pn.display_name link_text FROM hrt_profiles_vl pr, per_all_assignments_f asg, per_person_names_f_v pn, ( SELECT profile_id, SUM(decode(skill.skill_group, 'ORA_DEVELOPED', 1, 0)) developed, SUM(decode(skill.skill_group, 'ORA_DEVELOPING', 1, 0)) developing FROM hrt_skills_items_v skill, hrt_content_source_rlats csrc WHERE csrc.source_id = 120 AND csrc.content_type_id = 134 AND skill.section_id = csrc.section_id AND skill.business_group_id = csrc.business_group_id GROUP BY profile_id ) skill WHERE asg.person_id = pr.person_id AND trunc(sysdate) BETWEEN asg.effective_start_date AND asg.effective_end_date AND skill.profile_id (+) = pr.profile_id AND asg.person_id = pn.person_id AND trunc(sysdate) BETWEEN pn.effective_start_date AND pn.effective_end_date |