The Revenue Cycle Analytics bundle contains data that is used in HealtheAnalytics: Revenue Cycle.
See the Revenue Cycle Analytics Feed Types page for more information about how to process the feed type and how the feed type is designed.
| Property | Value |
|---|---|
| Header Record | Yes |
| Field Delimiter | Comma |
| Record Delimiter | CR/LF |
| Character Encoding | UTF-8 |
Each file in the Revenue Cycle Analytics bundle has its own feed type, and the system processes each feed type separately. See the linked Reference Pages in the File Name and Schema column below for more information about the schema for each file and its associated feed type.
| File Name and Schema | Description | Feed Type Mnemonic |
|---|---|---|
| RC_D_CLAIM_EDIT | This table stores data about claim edits made to claims in the integrated scrubber. | rc-claim-edit |
| RC_D_LANGUAGE | This table stores language information associated with a person. | rc-encounter-language |
| RC_D_PAYMENT_METHOD | This table stores the methods used for payments in an organization. | rc-cash-payment-method |
| RC_D_RACE | This table stores data about a person’s race. | rc-encounter-race |
| RC_F_ADJUSTMENT | This table stores transactional data related to your adjustments. | rc-adjustment |
| RC_F_AVERAGE_DAILY_REVENUE | This table stores daily revenue averages by facility. | rc-average-daily-revenue |
| RC_F_AVERAGE_GROSS_REVENUE | This table stores daily gross revenue averages by facility. | rc-revenue-detail-avg-gross |
| RC_F_AVERAGE_NET_REVENUE | This table stores daily net revenue averages by facility. | rc-net-revenue |
| RC_F_CASH | This table stores the transaction data related to charges. | rc-cash |
| RC_F_CHARGE_AR | This table stores charges for active patient accounts. | rc-charge-ar |
| RC_F_CLAIM | This table stores data associated with claims. | rc-claim |
| RC_F_CLIENT_AR_BALANCE | This table stores daily balances for active client accounts. The attributes are as of the balance date. | rc-client-accounts-receivable |
| RC_F_COST_REIMBURSEMENT | This table stores transaction data related to bad debt and charity care adjustments. | rc-cost-reimbursement |
| RC_F_COST_REIMBURSEMENT_DSH | This table stores the methods used for Disproportionate Shared Hospital (DSH) reporting. | rc-dsh |
| RC_F_DAILY_ENCOUNTER | This table stores clinical encounters of each day from the actual arrival date through the discharge date. | rc-daily-encounter |
| RC_F_DENIAL | This table stores information about denials written to the CPA Denial Detail table. | rc-denial |
| RC_F_ENCOUNTER | This table stores clinical encounters. | rc-encounter |
| RC_F_ENCOUNTER_HEALTH_PLAN | This table stores details about a clinical encounter’s health plan. | rc-encounter-health-plan |
| RC_F_GENERAL_AR_BALANCE | This table stores the methods used for information associated with general accounts receivable (AR) reporting. | rc-general-accounts-receivable |
| RC_F_GENERAL_AR_BALANCE_TRANSACTION | This table stores transaction data associated with the general AR accounts. The attributes are in effect as of the transaction date. | rc-general-accounts-receivable-transactions |
| RC_F_GL_ADJUSTMENT | This table stores the original adjustments and the reclassification of adjustments. | rc-gl-adjustment |
| RC_F_GL_CASH | This table stores transaction data related to payments. | rc-general-ledger-cash |
| RC_F_GL_REVENUE | This table stores original charges and their reclassifications. | rc-gl-revenue |
| RC_F_GL_TRANSACTION_LOG | This table stores general ledger (GL) transaction data. | rc-gl-transaction |
| RC_F_NON_AR_BALANCE | This table stores summary data for non-AR accounts. | rc-non-ar-gl-only |
| RC_F_NON_AR_BALANCE_TRANSACTION | This table stores transactional data related to non-AR accounts. | rc-non-ar-gl-only-transaction |
| RC_F_PATIENT_AR_BALANCE | This table stores daily balances for active patient accounts at the encounter level. | rc-accounts-receivable |
| RC_F_REVENUE | This table stores the transaction data associated with charges. | rc-revenue-detail |
| RC_D_GL_TRANSACTION_QUALIFIER_DETAIL | This table stores the general ledger transaction qualifier data at the time general aliasing occurred. | rc-gl-transaction-qualifier-detail |