### snowflake cursor doesn't support string sseparation, thus this var is adjusted

pg_check_1 = """select
	distinct
	uow.report_date "REPORT_DATE",
	string_agg(distinct concat(r.report_name||' ('||l.licensor_name||')'), ',') "MISSING_REPORTS"
from content_status
    join unit_of_work uow on uow.unit_of_work_id = content_status.unit_of_work_id
    join report r on r.report_id = uow.report_id
    join licensor l on l.licensor_id = uow.licensor_id
    join data_source ds ON ds.data_source_id = r.data_source_id
where ds.data_source_id = 9
    and (
		uow.completeness_status not in ('COMPLETE', 'MIN_COMPLETE', 'CANCELLED')
		or
		content_status.content_status in ('MISSING', 'FAILED')
	)
    and uow.report_date > current_date-14
	and uow.report_date < current_date-1
group by uow.report_date
order by uow.report_date DESC;"""

sf_check_2 = """select max(DATE_ENABLED) = DATEADD(day,-1, current_date()) as result \
from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" \
where dsp = 'GRAS' and REPORT_NAME = 'ALL'; """

sf_check_3 = """select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_BUSINESS_UNIT" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_COMPANY" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_CONFIGURATION" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_CONFIGURATION_CATEGORY" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_COUNTRY" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_GENRE" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_LABEL" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_LANGUAGE" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_MEDIA_TYPE" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_PARTICIPANT" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_PARTICIPANT_MEMBER" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_PRODUCT" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_PRODUCT_CLASS" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_PRODUCT_TRACK" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_PRODUCT_VERSION" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_PROJECT_ARTIST" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_PROJECT_TYPE" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_RECORDING_PROJECT" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_REC_PROJECT_PRODUCT_VERSION" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_REPERTOIRE_OWNER_HIERARCHY" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_TRACK" \
union all \
select max(report_date) = DATEADD(day,-1,  current_date()) as result from "DELPHI_EXPLORATION"."RAW"."GRAS_TRACK_PARTICIPANT";"""

sf_check_4 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_BUSINESS_UNIT" \
union \
select count(distinct(BUSINESS_UNIT_KEY)), 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_BUSINESS_UNIT" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_BUSINESS_UNIT");"""

sf_check_5 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_COMPANY" \
union \
select count(distinct(COMPANY_KEY)), 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_COMPANY" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_COMPANY");"""

sf_check_6 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_CONFIGURATION" \
union \
select count(distinct(CONFIG_KEY)), 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_CONFIGURATION" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_CONFIGURATION");"""

sf_check_7 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_CONFIGURATION_CATEGORY" \
union \
select count(distinct(CONFIG_CAT_KEY)), 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_CONFIGURATION_CATEGORY" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_CONFIGURATION_CATEGORY");"""

sf_check_8 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_COUNTRY" \
union \
select count(distinct(COUNTRY_KEY)), 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_COUNTRY" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_COUNTRY"); """

sf_check_9 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_GENRE" \
union \
select count(distinct(GENRE_KEY)), 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_GENRE" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_GENRE"); """

sf_check_10 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_LABEL" \
union \
select count(distinct LABEL_KEY, LABEL_EXT) as count, 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_LABEL" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_LABEL");"""

sf_check_11 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_LANGUAGE" \
union \
select count(distinct(LANGUAGE_KEY)) as count, 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_LANGUAGE" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_LANGUAGE"); """

sf_check_12 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_MEDIA_TYPE" \
union \
select count(distinct(MEDIA_TYPE_KEY)) as count, 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_MEDIA_TYPE" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_MEDIA_TYPE");"""

sf_check_13 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_PARTICIPANT" \
where mod_flag != 'D' \
union \
select count(distinct(PARTICIP_NO)) as count, 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_PARTICIPANT" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_PARTICIPANT"); """

sf_check_14 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_PARTICIPANT_MEMBER" \
where mod_flag != 'D' \
union \
select count(distinct PARTICIP_NO, MEMBER_PARTICIP_NO) as count, 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_PARTICIPANT_MEMBER" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_PARTICIPANT_MEMBER"); """

sf_check_15 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_PRODUCT" \
where mod_flag != 'D' \
union \
select count(distinct(PROD_NO)) as count, 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_PRODUCT" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_PRODUCT"); """

sf_check_16 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_PRODUCT_CLASS" \
union \
select count(distinct(PRODUCT_CLASS_KEY)) as count, 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_PRODUCT_CLASS" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_PRODUCT_CLASS"); """

sf_check_17 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_PRODUCT_TRACK" \
where mod_flag != 'D' \
union \
select count(distinct PROD_NO, TRACK_NO, TRACK_EXT, ID_NO, ifnull(GRID_NO, 'null_grid_no')) as count, 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_PRODUCT_TRACK" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_PRODUCT_TRACK") \
and mod_flag != 'D'; """

sf_check_18 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_PRODUCT_VERSION" \
where mod_flag != 'D' \
union \
select count(distinct(PROD_VERS_NO)) as count, 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_PRODUCT_VERSION" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_PRODUCT_VERSION"); """

sf_check_19 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_PROJECT_ARTIST" \
where mod_flag != 'D' \
union \
select count(distinct REC_PROJECT_ID, PARTICIP_NO, ID_NO) as count, 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_PROJECT_ARTIST" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_PROJECT_ARTIST"); """

sf_check_20 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_PROJECT_TYPE" \
union \
select count(distinct(REC_PROJECT_TYPE)) as count, 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_PROJECT_TYPE" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_PROJECT_TYPE"); """

sf_check_21 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_RECORDING_PROJECT" \
where mod_flag != 'D' \
union \
select count(distinct(REC_PROJECT_ID)) as count, 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_RECORDING_PROJECT" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_RECORDING_PROJECT"); """

sf_check_22 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_REC_PROJECT_PRODUCT_VERSION" \
where mod_flag != 'D' \
union \
select count(distinct REC_PROJECT_ID, PROD_VERS_NO) as count, 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_REC_PROJECT_PRODUCT_VERSION" rppv \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_REC_PROJECT_PRODUCT_VERSION") \
and (exists(select * from "DELPHI_EXPLORATION"."EXP"."GRAS_RECORDING_PROJECT" where REC_PROJECT_ID = rppv.REC_PROJECT_ID)) \
and (exists(select * from "DELPHI_EXPLORATION"."EXP"."GRAS_PRODUCT_VERSION" where PROD_VERS_NO = rppv.PROD_VERS_NO)); """

sf_check_23 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_REPERTOIRE_OWNER_HIERARCHY" \
where PROFIT_CENTER_MOD_FLAG != 'D' and PARENT_REP_OWNER_MOD_FLAG != 'D' and REP_OWNER_MOD_FLAG != 'D' \
union \
select count(*) as count, 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_REPERTOIRE_OWNER_HIERARCHY" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_REPERTOIRE_OWNER_HIERARCHY"); """

sf_check_24 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_TRACK" \
where mod_flag != 'D' \
union \
select count(distinct TRACK_NO, TRACK_EXT) as count, 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_TRACK" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_TRACK"); """

sf_check_25 = """select count(*) "count", 'dest; SF exp' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_TRACK_PARTICIPANT" \
where mod_flag != 'D' \
union \
select count(distinct TRACK_NO, TRACK_EXT, PARTICIP_NO, ID_NO) as count, 'dest; SF raw' \
from "DELPHI_EXPLORATION"."RAW"."GRAS_TRACK_PARTICIPANT" \
where report_date = (select max(report_date) from "DELPHI_EXPLORATION"."RAW"."GRAS_TRACK_PARTICIPANT");"""

sf_check_26 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_BUSINESS_UNIT" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
and MOD_FLAG != 'D' \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_BUSINESS_UNIT";"""

sf_check_27 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_COMPANY" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_COMPANY";"""

sf_check_28 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_CONFIGURATION" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
and MOD_FLAG != 'D' \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_CONFIGURATION";"""

sf_check_29 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_CONFIGURATION_CATEGORY" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
and MOD_FLAG != 'D' \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_CONFIGURATION_CATEGORY";"""

sf_check_30 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_COUNTRY" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_COUNTRY";"""

sf_check_31 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_GENRE" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_GENRE";"""

sf_check_32 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_LABEL" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_LABEL";"""

sf_check_33 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_LANGUAGE" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_LANGUAGE";"""

sf_check_34 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_MEDIA_TYPE" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
and MOD_FLAG != 'D' \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_MEDIA_TYPE";"""

sf_check_35 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_PARTICIPANT" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
and MOD_FLAG != 'D' \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_PARTICIPANT";"""

sf_check_36 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_PARTICIPANT_MEMBER" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
and MOD_FLAG != 'D' \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_PARTICIPANT_MEMBER";"""

sf_check_37 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_PRODUCT" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
and MOD_FLAG != 'D' \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_PRODUCT";"""

sf_check_38 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_PRODUCT_CLASS" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
and MOD_FLAG != 'D' \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_PRODUCT_CLASS";"""

sf_check_39 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_PRODUCT_TRACK" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
and MOD_FLAG != 'D' \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_PRODUCT_TRACK";"""

sf_check_40 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_PRODUCT_VERSION" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
and MOD_FLAG != 'D' \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_PRODUCT_VERSION";"""

sf_check_41 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_PROJECT_ARTIST" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
and MOD_FLAG != 'D' \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_PROJECT_ARTIST";"""

sf_check_42 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_PROJECT_TYPE" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
and MOD_FLAG != 'D' \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_PROJECT_TYPE";"""

sf_check_43 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_REC_PROJECT_PRODUCT_VERSION" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
and MOD_FLAG != 'D' \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_REC_PROJECT_PRODUCT_VERSION";"""

sf_check_44 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_RECORDING_PROJECT" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
and MOD_FLAG != 'D' \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_RECORDING_PROJECT";"""

sf_check_45 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_REPERTOIRE_OWNER_HIERARCHY" \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_REPERTOIRE_OWNER_HIERARCHY";"""

sf_check_46 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_TRACK" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
and MOD_FLAG != 'D' \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_TRACK";"""

sf_check_47 = """select count(*) "count", 'dest; SF exp table' \
from "DELPHI_EXPLORATION"."EXP"."GRAS_TRACK_PARTICIPANT" \
where (MOD_STAMP < dateadd(day, 1, (select max(DATE_ENABLED) from "DELPHI_EXPLORATION"."SYS"."DATA_ENABLEMENT_CONTROL" where DSP = 'GRAS')) or MOD_FLAG != 'I') \
and MOD_FLAG != 'D' \
union \
select count(*), 'dest; SF exp view' \
from "DELPHI_EXPLORATION"."EXP"."V_GRAS_TRACK_PARTICIPANT";"""

if __name__ == '__main__':
    pass