Changed Data Capture

When the Staging ETL processes are run, they rely on a lastwritten timestamp column on all source tables, this ensures that only changed data is extracted. It is important to understand that the reporting module requires that each table that it extracts data from must have a column of type timestamp and have a name of lastwritten, and that any application must update this column whenever a row is created or modified in the source database.