Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| response_id | BIGINT | 19 | null |
|
|
Surrogate ID of the benefit eligibility record used as the primary incrementing key |
|||||
| verification_id | BIGINT | 19 | null |
|
|
The eligibility verification record that these benefits are retrieved from |
|||||
| type | VARCHAR | 4 | √ | NULL |
|
|
Type of benefit |
||||
| benefit_type | VARCHAR | 255 | √ | NULL |
|
|
Type of the benefit, if applicable |
||||
| start_date | DATE | 10 | √ | NULL |
|
|
Start date for the benefit coverage |
||||
| end_date | DATE | 10 | √ | NULL |
|
|
End date for the benefit coverage |
||||
| coverage_level | VARCHAR | 255 | √ | NULL |
|
|
Coverage level, if specified |
||||
| coverage_type | VARCHAR | 512 | √ | NULL |
|
|
Type of coverage |
||||
| plan_type | VARCHAR | 255 | √ | NULL |
|
|
Type of insurance plan |
||||
| plan_description | VARCHAR | 255 | √ | NULL |
|
|
Description of the insurance plan |
||||
| coverage_period | VARCHAR | 255 | √ | NULL |
|
|
Period of coverage |
||||
| amount | DECIMAL | 5,2 | √ | NULL |
|
|
Benefit amount, if applicable |
||||
| percent | DECIMAL | 3,2 | √ | NULL |
|
|
Benefit percentage, if applicable |
||||
| network_ind | VARCHAR | 2 | √ | NULL |
|
|
Network indicator |
||||
| message | VARCHAR | 512 | √ | NULL |
|
|
Additional message or information |
||||
| response_status | enum('A', 'D') | 1 | √ | 'A' |
|
|
Status of the response (Active ‘A’ or Denied ‘D’) |
||||
| response_create_date | DATE | 10 | √ | NULL |
|
|
Date when the benefit response was created |
||||
| response_modify_date | DATE | 10 | √ | NULL |
|
|
Date when the benefit response was last modified |