claim_status

Results of a pricing request

Primary Key:

• claim_id
• updated_at

Foreign Keys:

• claim_id => claim.claim_id
• claim_repricing_id => claim_repricing.claim_repricing_id
• claim_status_id => claim_status_lookup.claim_status_id
• updated_by => login.login_id

Indexes:

• claim_status_claim_id_idx - claim_id
• claim_status_claim_repricing_id_idx - claim_repricing_id
• claim_status_claim_status_id_idx - claim_status_id
• claim_status_updated_by_idx - updated_by

Column	Data Type	Nullable	Indexed	Description
claim_id	bigint	No	Yes	-
updated_at	timestamp without time zone	No	Yes	The time when the claim status was updated
updated_by	bigint	No	Yes	The ID of the person or automation user which updated claim status.
claim_status_id	bigint	No	Yes	Points to the claim status record.
claim_repricing_id	bigint	Yes	Yes	Points to the claim repricing record.