billing


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of billing.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Patient billing records for billing codes - Used for Claims Processing

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null

Surrogate id of the record used as the primary incrementing key
date DATETIME 19 √ null

Date associated with the billing record
code_type VARCHAR 15 √ null

Type of billing code
code VARCHAR 20 √ null

Billing code
pid BIGINT 19 √ null
patient_data.pid Defined in XML R

The internal patient identifier
provider_id INT 10 √ null
insurance_companies.id Defined in XML R

The insurance company being billed. If this is self-pay the id will be 0
user INT 10 √ null
users.id Defined in XML R

The user that created this billing record.
groupname VARCHAR 255 √ null
groups.name Defined in XML R

Group name associated with the billing record
authorized BIT 1 √ null

Authorization status (1 for authorized, 0 for unauthorized)
encounter INT 10 √ null
form_encounter.encounter Defined in XML R

The encounter that this billing record is connected to
code_text LONGTEXT 2147483647 √ null

Text associated with the billing code
billed BIT 1 √ null

Billing status (1 for billed, 0 for unbilled)
activity BIT 1 √ null

Activity status (1 for active, 0 for inactive)
payer_id INT 10 √ null
insurance_companies.id Defined in XML R

The insurance company being billed. If this is self-pay the id will be 0
bill_process TINYINT 3 0

Bill process code -1=leave unprocessed,0=open,1=in progress,2=billed
bill_date DATETIME 19 √ null

Date when billing moved into the billed status
process_date DATETIME 19 √ null

Date when the bill was moved into the processing state
process_file VARCHAR 255 √ null

File associated with billing process
modifier VARCHAR 12 √ null

Modifier for billing code
units INT 10 √ null

Number of units for billing
fee DECIMAL 12,2 √ null

Fee associated with billing
justify VARCHAR 255 √ null

Justification for billing code
target VARCHAR 30 √ null

Target associated with billing code
x12_partner_id INT 10 √ null

The X12 partner clearinghouse id. Empty On Export
ndc_info VARCHAR 255 √ null

NDC (National Drug Code) information
notecodes VARCHAR 25

Notecodes associated with billing
external_id VARCHAR 20 √ null

External identifier associated with billing
pricelevel VARCHAR 31 √

Price level associated with billing
revenue_code VARCHAR 6

Item revenue code
chargecat VARCHAR 31 √
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘chargecats’ and represents the charge category for certain insursers

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
pid Performance Asc pid

Relationships

Close relationships within degrees of separation