Date	2017-08-14
Authors	Russell Steel (Unlicensed)
Status	Complete
Summary	Hicom's DR refresh failed so the TIS ETLs only had access to the previous day's data.
Impact	Revalidation nationally had stale data.

Root Cause

Hicom have a changed the following column datatypes;

Location VC50 > VC100

Subject VC(max) > Text

Notes VC(max) > Text

Trigger

Their nightly scheduled update.

Updated Mirror table definations

Ran daily row count checks between DR and Mirror and noted the following differences;

owner	tab_name	rc	distinc_rc	Vlookup Mirror RC	RC Diff	Duplicates exist in DR
HEELIVE	vwTeachingSession	323336	323336	323315	-21	No

Action Items

Action Item	Type	Owner	Issue
	mitigate/prevent

e.g. monitoring dashboards