Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ID | NUMBER | 38 |
|
|
||||||
| START | DATE | 0 | √ |
|
|
|||||
| STOP | DATE | 0 | √ |
|
|
|||||
| PATIENT | VARCHAR | 255 |
|
|
||||||
| PAYER | VARCHAR | 255 | √ |
|
|
|||||
| ENCOUNTER | VARCHAR | 255 |
|
|
||||||
| CODE | VARCHAR | 255 |
|
|
||||||
| DESCRIPTION | VARCHAR | 255 | √ |
|
|
|||||
| BASE_COST | DOUBLE | 0 | √ |
|
|
|||||
| PAYER_COVERAGE | DOUBLE | 0 | √ |
|
|
|||||
| DISPENSES | NUMBER | 38 | √ |
|
|
|||||
| TOTALCOST | DOUBLE | 0 | √ |
|
|
|||||
| REASONCODE | VARCHAR | 255 | √ |
|
|
|||||
| REASONDESCRIPTION | VARCHAR | 255 | √ |
|
|
Relationships
Close relationships within degrees of separation
