eligibilityperiods

Table Schema

Name Type Description
id VARCHAR

Surrogate key. Primary key for the eligibilityperiods table.

patient_id VARCHAR

Surrogate key. Foreign key reference to patients.id

startdate TIMESTAMP
enddate TIMESTAMP
iseligible VARCHAR
paymentcategoryterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

qualifyingcategoryterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

ambulatoryvisits INTEGER
thirdparty_policytypeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

thirdparty_policynumber VARCHAR
thirdparty_carriername VARCHAR
thirdparty_ismaternitycoverage VARCHAR
thirdparty_startdate TIMESTAMP
thirdparty_enddate TIMESTAMP
specialprogram_organization_id VARCHAR

Surrogate key. Foreign key reference to specialprogram_organizations.id

specialprogram_typeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

specialprogram_startdate TIMESTAMP
specialprogram_enddate TIMESTAMP
inserteddate TIMESTAMP

Timestamp (UTC) indicating the date the row was first inserted into HIEBus.

insertedbyapplication_id SMALLINT

The application that first inserted the row into HIEBus. Foreign key reference to applications.id.

insertedbyuser_id VARCHAR

The user associated with the process that first inserted the row into HIEBus. Foreign key reference to users.id.

modifieddate TIMESTAMP

Timestamp (UTC) indicating the date the row was last modified.

modifiedbyapplication_id SMALLINT

The application that last modified the row. Foreign key reference to applications.id.

modifiedbyuser_id VARCHAR

The user associated with the process that last modified the row. Foreign key reference to users.id.

tenant_id SMALLINT

Surrogate key. Foreign key reference to tenants.id


Back to Tables