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