NAV Navbar
Logo cerner

Dimensions EDW Feed Type

Overview

The Dimensions enterprise data warehouse (EDW) bundle contains files that make up shared reference models in HealtheEDW such as providers.

Processing Instructions

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:

  1. Delete the rows identified by the keys in the <table_name>_delete file.
  2. Insert the rows into the <table_name> file.

Schema

Version Notes
V1 Initial version

Understand

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.