AP_CLM_RX_DTL

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 | NDC_ID | VARCHAR | No |
National Drug Code (NDC)
3 | NDC_ID_NDC_CODE | VARCHAR | No |
The external code for the National Drug Code (NDC). An NDC represents packages of medications.
4 | PRESC_REF_NUM | VARCHAR | No |
Prescription reference number.
5 | NDC_UNIT_EXT_CODE_LST_ID | NUMERIC | No |
Units (ml, units, etc.). The unit code can be retrieved by joining this column to the EXT_COSE_LST_ID column in FCL_EXTRNL_CDE_LST table.
6 | NDC_UNIT_EXT_CODE_LST_ID_EXT_CODE_LST_NAME | VARCHAR | No |
The name of the list value.
7 | FILL_NUMBER | INTEGER | No |
Indicates whether the prescription is an original (0) or a refill (1,2,...).
8 | DAYS_SUPPLY | INTEGER | No |
Estimated number of days the prescription will last.
9 | DAW_CODE_EXT_CODE_LST_ID | NUMERIC | No |
Code indicating whether or not the prescriber's instructions regarding generic substitution were followed. The Dispense As Written (DAW) code can be retrieved by joining this column to the EXT_COSE_LST_ID column in FCL_EXTRNL_CDE_LST table.
10 | DAW_CODE_EXT_CODE_LST_ID_EXT_CODE_LST_NAME | VARCHAR | No |
The name of the list value.
11 | INGRED_COST_PAID | NUMERIC | No |
Drug ingredient cost paid.
12 | DISPENSING_FEE_PAID | NUMERIC | No |
Dispensing fee paid.
13 | REG_TAX_AMT_PAID | NUMERIC | No |
Flat sales tax amount paid.
14 | PCT_TAX_AMT_PAID | NUMERIC | No |
Percentage tax amount paid.
15 | INCENTIVE_AMT_PAID | NUMERIC | No |
Incentive amount paid.
16 | PROF_SVC_FEE_PAID | NUMERIC | No |
Professional service fee paid.
17 | OTHER_AMT_RECOGNIZED | NUMERIC | No |
Total amount recognized by the processor of any payment from another source.
18 | QUANTITY | NUMERIC | No |
Quantity dispensed
19 | FILL_DATE | DATETIME | No |
Identifies date the prescription was filled.
20 | OWNING_SAPBS_POS_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
21 | POS_TYPE_C_NAME | VARCHAR | No |
Place of service type
May contain organization-specific values: Yes
Category Entries:
Telehealth - Provided in Patient's Home
Office
Home
Assisted Living Facility
Group Home
Mobile Unit
Temporary Lodging
Walk-in Retail Health Clinic
Place of Employment - Worksite
Off Campus - Outpatient Hospital
Urgent Care Facility
Inpatient Hospital
On Campus - Outpatient Hospital
Emergency Room - Hospital
Ambulatory Surgical Center
Birthing Center
Military Treatment Facility
Outreach Site/Street
Skilled Nursing Facility
Nursing Facility
Custodial Care Facility
Hospice
Adult Living Care Facility
Ambulance - Land
Ambulance - Air or Water
Independent Clinic
Federally Qualified Health Center
Inpatient Psychiatric Facility
Psychiatric Facility - Partial Hospitalization
Community Mental Health Center
Intermediate Care Facility/ Individuals with Intellectual Disabilities
Residential Substance Abuse Treatment Facility
Psychiatric Residential Treatment Center
Non-residential Substance Abuse Treatment Facility
Non-residential Opioid Treatment Facility
Mass Immunization Center
Comprehensive Inpatient Rehabilitation Facility
Comprehensive Outpatient Rehabilitation Facility
End-Stage Renal Disease Treatment Facility
Programs of All-Inclusive Care for the Elderly (PACE) Center
Public Health Clinic
Rural Health Clinic
Independent Laboratory
Other Place of Service
Pharmacy
Telehealth - Provided Other than in Patient's Home
School
Homeless Shelter
Indian Health Service Free-standing Facility
Indian Health Service Provider-based Facility
Tribal 638 Free-standing Facility
Tribal 638 Provider-based Facility
Prison/Correctional Facility
22 | PRIM_INS_AMT | NUMERIC | No |
Sum of all the insurance amount paid by previous payers.
23 | BILLED_AMT | NUMERIC | No |
Billed amount
24 | ALLOWED_AMT | NUMERIC | No |
Allowed amount
25 | PRIM_PAT_DEDUCTIBLE | NUMERIC | No |
Store prior patient deductible
26 | PRIM_PAT_COPAY | NUMERIC | No |
Store prior patient copay
27 | PRIM_PAT_COINS | NUMERIC | No |
Store prior patient co-insurance
28 | DEDUCTIBLE | NUMERIC | No |
Deductible amount
29 | COPAY | NUMERIC | No |
Copay amount
30 | COINSURANCE | NUMERIC | No |
Coinsurance amount
31 | PAT_TOTAL | NUMERIC | No |
Patient total amount
32 | NET_PAYABLE | NUMERIC | No |
Net payable
33 | CLAIM_ID | NUMERIC | No |
The accounts payable claim to which this service line is associated.
34 | RX_POINTER_ID_MEDICATION_NAME | VARCHAR | No |
The name of this medication record.
35 | FILL_STATUS_C_NAME | VARCHAR | No |
Stores information on whether the prescription was completely or partially filled.
May contain organization-specific values: No
Category Entries:
Partially filled
Completely filled
36 | POS_TYPE_SRC_C_NAME | VARCHAR | No |
Source of the Place of Service type
May contain organization-specific values: No
Category Entries:
Profile
User
Batch Type Definition
37 | RECORD_STATUS_C_NAME | VARCHAR | No |
Chronicles special item. This is the soft-delete flag that will be set to the appropriate record status option when the record is soft-deleted.
May contain organization-specific values: No
Category Entries:
Active
Inactive
Deleted
Inactive and Deleted
Hidden
Inactive and Hidden
Deleted and Hidden
Inactive Deleted and Hidden
38 | PRESC_PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
39 | SERV_PHARMACY_ID | NUMERIC | No |
The unique ID associated with the service pharmacy record for this row. This column is frequently used to link to the RX_PHR table.
40 | SERV_PHARMACY_ID_PHARMACY_NAME | VARCHAR | No |
The name of the pharmacy.