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