claimproblems

The claimproblems table manages all coded diagnoses that are associated with the specified claim.

Table Schema

Name Type Description
id VARCHAR

Surrogate key. Primary key for the claimproblems table.

date VARCHAR

The date the diagnosis was recorded.

sequence INTEGER

The sequence which the diagnosis appears on the specified claim.

term_id INTEGER

Surrogate key. Foreign key reference to terms.id. A term that specified the coded diagnosis. Commonly a term in the ICD-10-CM namespace.

typeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id A term that indicates the context of the diagnosis, common examples are Pimary/Secondary/Admitting

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.

tenant_id SMALLINT

Surrogate key. Foreign key reference to tenants.id

onadmissionterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

claimrevision INTEGER

Indicates the latest claim version number as it’s updated though adjustments, available only when reported by source.


Back to Tables