Documentation/EHI_Export/docs/tables/billing.html
| 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 | BOOLEAN | 3 | √ | | 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 | BOOLEAN | 3 | √ | | NULL |
|
|
Billing status (1 for billed, 0 for unbilled)
| | activity | BOOLEAN | 3 | √ | | 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
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| pid | Performance | Asc | pid |