AP_CLM_RX_DTL_2

Description:

This table contains information for a single NDC code on a pharmacy claim.

Primary Key

Column Name	Ordinal Position
TX_ID	1

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	The unique identifier for the transaction record
2	HAS_UNMAPPED_CODE_YN	VARCHAR	No
	Indicates whether a service line has an unmapped NDC code. 'Y' indicates that the service line has unmapped NDC code. 'N' or NULL indicates that the service line is linked to an NDC code. May contain organization-specific values: No Category Entries: No Yes
3	DTL_SVC_CLASS_C_NAME	VARCHAR	No
	Represents a detailed clinical classification of the billed service. May contain organization-specific values: No Category Entries: Emergency Durable Medical Equipment Radiology Anesthesia Pharmacy Medical/Surgical Supplies Surgery Observation Nursery Room and Board Behavioral Health Ambulatory Surgery Center Oncology Cardiology Pulmonary Gastrointestinal Nuclear Medicine Electrocardiogram Urgent Care Home Health Ambulance Skilled Nursing Dialysis Physical Therapy Occupational Therapy Speech Pathology Rehabilitation Transplant Pharmacy - High Cost Blood Diagnostic Services Evaluation and Management Immunizations and Vaccines Medicine Services and Procedures Pathology and Laboratory Procedures Hearing Services Physician-Administered Medications Telemedicine Laboratory Home Hospice Inpatient Hospice Not Classified