Documentation/EHI_Export/docs/tables/benefit_eligibility.html
| 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 |
|
| eligibility_verification.verification_id | Defined in XML | R |
|
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
|