claimservices

The claimservices table manages all services that are associated with the specified claim.

Table Schema

Name Type Description
id VARCHAR

Surrogate key. Primary key for the claimservices table.

startdate VARCHAR

The start date for the claim service.

enddate VARCHAR

The end date for the claim service.

sequence INTEGER

The sequence which the service is listed on the specified claim.

units INTEGER

If applicable, the number of times the service was rendered during this claim service instance.

amountclaimed NUMERIC

The amount charge for this service.

amountpaid NUMERIC

The amount paid for this service.

patientpaid NUMERIC

The amount that was paid by the patient for this service.

comment VARCHAR

An uncoded, human readable text field to provide additional information about the claim service.

servicecodeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id. A term that describes the service that was performed.

locationtypeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id. Claim line place of service (POS) code

statusterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

problem1term_id INTEGER

Surrogate key. Foreign key reference to terms.id

problem2term_id INTEGER

Surrogate key. Foreign key reference to terms.id

problem3term_id INTEGER

Surrogate key. Foreign key reference to terms.id

problem4term_id INTEGER

Surrogate key. Foreign key reference to terms.id

modifier1term_id INTEGER

Surrogate key. Foreign key reference to terms.id

modifier2term_id INTEGER

Surrogate key. Foreign key reference to terms.id

modifier3term_id INTEGER

Surrogate key. Foreign key reference to terms.id

modifier4term_id INTEGER

Surrogate key. Foreign key reference to terms.id

revenuecodeterm_id INTEGER

Surrogate key. Foreign key reference to terms.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.

tenant_id SMALLINT

Surrogate key. Foreign key reference to tenants.id

modifier5term_id INTEGER

Surrogate key. Foreign key reference to terms.id

allowedamount NUMERIC

Payment information for this claim service instance.

coinsuranceamount NUMERIC

Payment information for this claim service instance.

deductibleamount NUMERIC

Payment information for this claim service instance.

copayamount NUMERIC

Payment information for this claim service instance.

notcoveredamount NUMERIC

Payment information for this claim service instance.

hsapaidamount NUMERIC

Payment information for this claim service instance.

patientresponsibleamount NUMERIC

Payment information for this claim service instance.

claimrevision INTEGER

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


Back to Tables