HRR_PS_EVT_RATING_REVIEW

Details

Name
PERSON_ID ASSIGNMENT_ID EVENT_YEAR EVENT_DAYS EVENT_TITLE EVENT_DETAILS EVENT_DATE LINK_TEXT

Name

PERSON_ID

ASSIGNMENT_ID

EVENT_YEAR

EVENT_DAYS

EVENT_TITLE

EVENT_DETAILS

EVENT_DATE

LINK_TEXT

SQL_Statement
SELECT a.person_id person_id, a.assignment_id assignment_id, to_char(b.data_submit_date, 'yyyy') event_year, 0 event_days, '{"strKey":"HdrSRatingreviewdate"}' event_title, b.meeting_title event_details, b.data_submit_date event_date, '?meetingId=' \|\| b.meeting_id \|\| '&' \|\| 'sort=nameAsc' link_text FROM per_all_assignments_m a, hrr_meetings b, hrr_meeting_participants c WHERE a.person_id = c.participant_person_id AND b.meeting_id = c.meeting_id AND a.assignment_type IN ( 'E', 'C', 'N' ) AND a.primary_flag = 'Y' AND a.effective_latest_change = 'Y' AND trunc(sysdate) BETWEEN a.effective_start_date AND a.effective_end_date AND a.assignment_status_type IN ( 'ACTIVE', 'SUSPENDED' ) AND c.participant_type_code IN ( 'BUSINESS_LEADER', 'REVIEWER', 'DELEGATED_REVIEWER' ) AND b.data_submit_date IS NOT NULL

SQL_Statement

SELECT

a.person_id person_id,

a.assignment_id assignment_id,

to_char(b.data_submit_date, 'yyyy') event_year,

0 event_days,

'{"strKey":"HdrSRatingreviewdate"}' event_title,

b.meeting_title event_details,

b.data_submit_date event_date,

'?meetingId='

|| b.meeting_id

|| '&'

|| 'sort=nameAsc' link_text

FROM

per_all_assignments_m a,

hrr_meetings b,

hrr_meeting_participants c

WHERE

a.person_id = c.participant_person_id

AND b.meeting_id = c.meeting_id

AND a.assignment_type IN ( 'E', 'C', 'N' )

AND a.primary_flag = 'Y'

AND a.effective_latest_change = 'Y'

AND trunc(sysdate) BETWEEN a.effective_start_date AND a.effective_end_date

AND a.assignment_status_type IN ( 'ACTIVE', 'SUSPENDED' )

AND c.participant_type_code IN ( 'BUSINESS_LEADER', 'REVIEWER', 'DELEGATED_REVIEWER' )

AND b.data_submit_date IS NOT NULL