Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
||
| code_text | MEDIUMTEXT | 16777215 | √ | NULL |
|
|
||
| code_text_short | MEDIUMTEXT | 16777215 | √ | NULL |
|
|
||
| code | VARCHAR | 25 | '' |
|
|
|||
| code_type | SMALLINT | 5 | √ | NULL |
|
|
||
| modifier | VARCHAR | 12 | '' |
|
|
|||
| units | INT | 10 | √ | NULL |
|
|
||
| fee | DECIMAL | 12,2 | √ | NULL |
|
|
||
| superbill | VARCHAR | 31 | '' |
|
|
|||
| VARCHAR | 255 | '' |
|
|
||||
| taxrates | VARCHAR | 255 | '' |
|
|
|||
| cyp_factor | FLOAT | 12 | 0 |
|
|
quantity representing a years supply |
||
| active | BOOLEAN | 3 | √ | 1 |
|
|
0 = inactive, 1 = active |
|
| reportable | BOOLEAN | 3 | √ | 0 |
|
|
0 = non-reportable, 1 = reportable |
|
| financial_reporting | BOOLEAN | 3 | √ | 0 |
|
|
0 = negative, 1 = considered important code in financial reporting |
|
| revenue_code | VARCHAR | 6 | '' |
|
|
Item revenue code |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| code | Performance | Asc | code |
| code_type | Performance | Asc | code_type |