The Dimensions enterprise data warehouse (EDW) bundle contains files that make up shared reference models in HealtheEDW such as providers.
Each table is represented with potentially two files: a <table_name> file and a <table_name>_delete file. The <table_name>_delete 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> 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:
The Dimensions EDW (
dimensions-edw) feed type is designed in the following ways:
|Data Types||Cerner recommends that you use the data types in the documentation when you load the files into a relational database.|
|Dates||Date fields are syndicated using the International Organization for Standardization (ISO) 8601 format with a Coordinated Universal Time (UTC) offset.|
|File Format||.CSV files are created using the Request for Comments (RFC) 4180 standard. See the RFC 4180 page on the Internet Engineering Task Force (IETF) website for more information.|
|Files With No Data||When no data is present in a file, a file with a zero length is syndicated.|
|Quoting and Escaping||Fields that contain line breaks (CRLF), double quotes, and commas are enclosed in double quotation marks.
Double quotation marks in a string are escaped by preceding them with another set of double quotation marks.