NAV

Longitudinal Plan EDW Feed Type

Overview

The Longitudinal Plan enterprise data warehouse (EDW) bundle contains files that make up a patient’s Longitudinal Plan 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 Longitudinal Plan EDW (longitudinal-plan-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.