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.
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.
| Version | Notes |
|---|---|
| V1 | Initial version |
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. |