CLM_PX

Description:

All values associated with a claim are stored in the Claim External Value record. The CLM_PX table holds the ICD procedures that document surgical procedures on inpatient claims.

Primary Key

Column Name	Ordinal Position
RECORD_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	RECORD_ID	NUMERIC	No
	The unique ID for the claim record.
2	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3	CLM_PX_QUAL	VARCHAR	No
	The qualifier identifying the code set for the International Classification of Diseases (ICD) procedures.
4	CLM_PX	VARCHAR	No
	The International Classification of Diseases (ICD) procedures for the claim. The principal procedure is stored on the first line and the other procedures are on subsequent lines.
5	CLM_PX_DT	DATETIME	No
	The date of the International Classification of Diseases (ICD) procedure.
6	CLM_PX_DESC	VARCHAR	No
	The text description for an International Classification of Diseases (ICD) procedure.
7	CLM_PX_RANK	INTEGER	No
	The rank of this International Classification of Diseases (ICD) procedure compared to the other ICD procedures on the claim.