claimsupportinginformations

The claimsupportinginformations table

Table Schema

Name Type Description
id VARCHAR

Surrogate key. Primary key for the claimsupportinginformations table.

sequence INTEGER

A ordered sequence for the supporting information.

startdate VARCHAR

Begin date for the supporting information.

enddate VARCHAR

End date for the supporting information.

value VARCHAR

A text value to describe the supporting information.

term_id INTEGER

Surrogate key. Foreign key reference to terms.id

typeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

reasonterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

tenant_id SMALLINT

Surrogate key. Foreign key reference to tenants.id

claim_id VARCHAR

Surrogate key. Foreign key reference to claims.id

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.


Back to Tables