1. Tables and Views for HCM
  2. HRE_PS_ANA_CELEBRATION_V

HRE_PS_ANA_CELEBRATION_V

Details

  • Schema: FUSION

  • Object owner: HRE

  • 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

noteseo.object_id person_id,

NULL assignment_id,

'{"strKey":"HdrSCelebrationcards"}' text_title,

'{"strKey":"PgHIReceivedCARDSNUMlastmonth", "tokens":{"CARDS_NUM":"'

|| notedet.cnt

|| '"}}' text_metric,

'{"strKey":"FdHILastreceivedonDATE", "tokens":{"DATE":"'

|| hrl_df_util.date_to_char(notedet.last_rcv_date)

|| '"}}' text_meta,

decode(sign(last_days - 7), - 1, '{"strKey":"BdgNew3"}', NULL) badge_text,

decode(sign(last_days - 7), - 1, 'info', NULL) badge_status,

NULL period_chn_ind_val,

NULL period_chn_ind_cmp,

NULL chart_type,

NULL chart_color,

NULL chart_data,

'' link_text

FROM

hrt_notes_for_person_sec_v noteseo,

(

SELECT

object_id,

COUNT(note_id) cnt,

MAX(creation_date) last_rcv_date,

ceil(sysdate - CAST(MAX(creation_date) AS DATE)) last_days

FROM

hrt_notes_for_person_sec_v

WHERE

context_type = 'ORA_CELEBRATION_TYPE'

AND creation_date >= add_months(sysdate, - 1)

GROUP BY

object_id

) notedet

WHERE

noteseo.context_type = 'ORA_CELEBRATION_TYPE'

AND noteseo.creation_date >= add_months(sysdate, - 1)

AND noteseo.object_id = notedet.object_id

AND noteseo.creation_date = notedet.last_rcv_date