HSP_BKT_CLAIM_STAT_DETAIL

Description:

Holds current status reason and additional detail.

Primary Key

Column Name	Ordinal Position
BUCKET_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	BUCKET_ID	NUMERIC	No
	The unique identifier (.1 item) for the bucket record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	CLAIM_STATUS_RSN_C_NAME	VARCHAR	No
	The current claim status reason associated with the claim status update for the accepted claim on the bucket. May contain organization-specific values: No Category Entries: Bundling Capitation Claim Error Coding Issue Contract/Benefit Related Coordination of Benefits Correspondence Coverage Issue Credentialing Duplicate Claim Medical Necessity Missing Claim Patient Responsibility Payer Review Payment Deferred Remittance Expected Pending Adjudication Referral/Authorization Issue Registration Issue Additional Documentation Request Submission Error Timely Filing Other Third Party Liability Non-Covered