eligibility_verification


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of eligibility_verification.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Insurance Eligibility Verification Tracking

Columns

Column Type Size Nulls Auto Default Children Parents Comments
verification_id BIGINT 19 √ null
benefit_eligibility.verification_id Defined in XML R

Unique identifier for eligibility verification
response_id VARCHAR 32 √ NULL

Identifier for the response related to the eligibility verification
insurance_id BIGINT 19 √ NULL
insurance_data.id Defined in XML R

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

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc verification_id
insurance_id Performance Asc insurance_id

Relationships

Close relationships within degrees of separation