HRA_PS_EVT_EVALUATIONS

Details

Name
PERSON_ID ASSIGNMENT_ID EVENT_YEAR EVENT_DATE EVENT_DAYS EVENT_TITLE EVENT_DETAILS LINK_TEXT

Name

PERSON_ID

ASSIGNMENT_ID

EVENT_YEAR

EVENT_DATE

EVENT_DAYS

EVENT_TITLE

EVENT_DETAILS

LINK_TEXT

SQL_Statement
SELECT he.worker_id person_id, he.assignment_id assignment_id, EXTRACT(YEAR FROM trunc(he.evaluation_date)) event_year, he.evaluation_date event_date, 0 event_days, htp.customary_name event_title, hrp.review_period_name event_details, '?evaluationId=' \|\| he.evaluation_id \|\| '&loggedInPersonRole=WORKER&calledFrom=PERSON_SPOTLIGHT' link_text FROM hra_evaluations he, hra_eval_roles her, hra_tmpl_periods_vl htp, hrt_review_periods_vl hrp WHERE he.evaluation_id = her.evaluation_id AND he.business_group_id = her.business_group_id AND her.role_type_code = 'WORKER' AND he.tmpl_period_id = htp.tmpl_period_id AND he.business_group_id = htp.business_group_id AND he.review_period_id = hrp.review_period_id AND he.business_group_id = hrp.business_group_id AND he.status_code = 'COMP'

SQL_Statement

SELECT

he.worker_id person_id,

he.assignment_id assignment_id,

EXTRACT(YEAR FROM trunc(he.evaluation_date)) event_year,

he.evaluation_date event_date,

0 event_days,

htp.customary_name event_title,

hrp.review_period_name event_details,

'?evaluationId='

|| he.evaluation_id

|| '&loggedInPersonRole=WORKER&calledFrom=PERSON_SPOTLIGHT' link_text

FROM

hra_evaluations he,

hra_eval_roles her,

hra_tmpl_periods_vl htp,

hrt_review_periods_vl hrp

WHERE

he.evaluation_id = her.evaluation_id

AND he.business_group_id = her.business_group_id

AND her.role_type_code = 'WORKER'

AND he.tmpl_period_id = htp.tmpl_period_id

AND he.business_group_id = htp.business_group_id

AND he.review_period_id = hrp.review_period_id

AND he.business_group_id = hrp.business_group_id

AND he.status_code = 'COMP'