NAV

Revenue Cycle Analytics Feed Types

Overview

The Revenue Cycle Analytics bundle contains data that is used in HealtheAnalytics: Revenue Cycle. Each file in the Revenue Cycle Analytics bundle has its own feed type, and the system processes each feed type separately.

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.

If the bundle load type is Complete, 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.

If the bundle load type is Incremental Load or Reprocess, complete the following steps to process the data: 1. If the <table_name_temp>.csv file exists and is not empty, delete the rows using the IDs in the <table_name_temp>.csv file. 2. Insert the rows into the <table name> file.

Schema

Version Notes
V1 Initial version

Understand

The Revenue Cycle Analytics feed types are designed in the ways below. Ensure that you wrap text in double quotes to avoid line breaks per Request for Comments (RFC) guidelines.

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 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.