Documentation/EHI_Export/docs/tables/codes.html
| 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 | | | '' |
|
| | | related_code | 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
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| code | Performance | Asc | code |
| code_type | Performance | Asc | code_type |