Requirement:
R_ID_EVENT4 MISSING ANNUAL EVENTS If current date is July 31, query TIS_EVENT focus on records where ANNUAL_EVENT_FLG = ‘Y’. Identify records that have not been associated to any date but dates are available in TIS_DT table for next year. Use TIS_EVENT_DT_RLTSHP to derive this list.
Report on the EVENT_ID, EVENT_DESC and Year that the Event has not been tagged for.
Output like:
R_ID_EVENT4 MISSING ANNUAL EVENTS EVENT_ID: 123 - EVENT_DESC: AFL Grand Final Day - Year: 2013