| 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 |
|
|
The internal patient identifier |
||||
| provider_id | INT | 10 | √ | NULL |
|
|
The insurance company being billed. If this is self-pay the id will be 0 |
||||
| user | INT | 10 | √ | NULL |
|
|
The user that created this billing record. |
||||
| groupname | VARCHAR | 255 | √ | NULL |
|
|
Group name associated with the billing record |
||||
| authorized | BOOLEAN | 3 | √ | NULL |
|
|
Authorization status (1 for authorized, 0 for unauthorized) |
||||
| encounter | INT | 10 | √ | NULL |
|
|
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 |
|
|
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 | √ | '' |
|
|
Comes from the list_options.list_id=‘chargecats’ and represents the charge category for certain insursers |