| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| verification_id | BIGINT | 19 | √ | null |
|
|
Unique identifier for eligibility verification |
||||
| response_id | VARCHAR | 32 | √ | NULL |
|
|
Identifier for the response related to the eligibility verification |
||||
| insurance_id | BIGINT | 19 | √ | NULL |
|
|
The patient insurance that eligibility is being checked against |
||||
| eligibility_check_date | DATETIME | 19 | √ | NULL |
|
|
Date and time when the eligibility check was performed |
||||
| copay | INT | 10 | √ | NULL |
|
|
Patient copayment amount |
||||
| deductible | INT | 10 | √ | NULL |
|
|
Patient deductible amount |
||||
| deductiblemet | enum('Y', 'N') | 1 | √ | 'Y' |
|
|
Indicates whether the deductible has been met (‘Y’ or ‘N’) |
||||
| create_date | DATE | 10 | √ | NULL |
|
|
Date when the record was created |
Showing 1 to 8 of 8 entries