AP_CLAIM_COMP_CONTRACTS

Description:

This table contains information about contract comparisons performed for a claim. This includes the contract, prospective payment systems (PPS) pricer, and claim-level contractual allowed amount for each contract evaluated for the claim. Each row in the table represents one contract that was evaluated for a claim.

Primary Key

Column Name	Ordinal Position
CLAIM_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CLAIM_ID	NUMERIC	No
	The unique identifier for the claim info 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	CONTRACT_ID	NUMERIC	No
	Each contract that was evaluated for the claim for contract comparison.
4	CONTRACT_ID_CONTRACT_NAME	VARCHAR	No
	The name of the Vendor-Network contract.
5	CONTRACT_CONTACT_DATE	DATETIME	No
	The contact date used for each contract evaluated for the claim for contract comparison.
6	ALLOWED_AMT	NUMERIC	No
	The total claim allowed amount calculated using each contract for contract comparison.