The Longitudinal Record enterprise data warehouse (EDW) bundle contains files that make up the patient’s longitudinal record in HealtheEDW.
Each table is represented with potentially two files: a <table_name>.csv file and a <table_name>_temp.csv file. The <table_name>_temp.csv files contain a hash_value column, and a corresponding hash_value column is on the <table_name> table to identify that the row needs to be deleted. The <table_name>.csv files contain the rows that should be inserted. An update to a record is represented by a delete of the old record then an insert.
Complete the following steps to process the data: