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	NUMERIC	No
	Business segment ID that owns the claim record.
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 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	NUMERIC	No
	The medication of this transaction.
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	VARCHAR	No
	The unique ID associated with the prescribing provider record for this row. This column is frequently used to link to 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.