NAV

Risk Assessment EDW Feed Type

Overview

The Risk Assessment enterprise data warehouse (EDW) bundle contains files that make up a patient’s risk assessments in HealtheEDW.

Processing Instructions

Each table is represented by a <table_name>.csv file. The <table_name>.csv files represent the full data set that contains the rows that should be inserted.

Complete the following steps to process the data:

  1. Delete all the rows in the data set.
  2. Insert the rows into the <table_name> file.

Schema

Version Notes
V1 Initial version

Understand

The Risk Assessment EDW (risk-assessment-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.