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:
| Version | Notes |
|---|---|
| V1 | Initial version |
The Dimensions EDW (dimensions-edw) feed type is designed in the following ways:
| Topic | Description |
|---|---|
| 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. |