AP_CLM_PX_CVTY_DSG

Description:

This table contains the oral cavity designation(s) associated with AP claim service lines. To link this table’s service line information back to a claim header, join this table to AP_CLAIM_PROC_IDS on the TX_ID column. If you need to report on claim service lines specific to Cost Sharing Reduction (CSR), join this table instead to AP_CLAIM_PROC_IDS_CSR on the TX_ID column.

Primary Key

Column Name	Ordinal Position
TX_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	The unique ID of the AP Claim procedure transaction.
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	ORAL_CVTY_DSGN_C_NAME	VARCHAR	No
	Stores the oral cavity designation category identifier for the service line. May contain organization-specific values: No Category Entries: 00 - Entire Oral Cavity 01 - Maxillary Area 02 - Mandibular Area 03 - Upper Right Sextant 04 - Upper Anterior Sextant 05 - Upper Left Sextant 06 - Lower Left Sextant 07 - Lower Anterior Sextant 08 - Lower Right Sextant 09 - Other Area of Oral Cavity 10 - Upper Right Quadrant 20 - Upper Left Quadrant 30 - Lower Left Quadrant 40 - Lower Right Quadrant L - Left R - Right