pharmacy_claim

One row per pharmacy claim line: prescriptions as dispensed, with the drug code, quantity, days supply and cost split. Pair days_supply with dispensing_date to build adherence and persistence measures.

At a glance

Schema	dax_core
Table	pharmacy_claim
Layer	Core Data Model
Object type	table
Columns	32
Grain	pharmacy_claim_id
Tags	core

Columns

Column	Type	Key	Terminology	Constraints	Description
pharmacy_claim_id	varchar	PK	—	unique, not null	Dax identifier for the pharmacy claim line.
claim_id	varchar		—	not null	Source claim identifier.
claim_line_number	integer		—	not null	—
person_id	varchar		—	not null	The individual the prescription was dispensed to.
member_id	varchar		—	—	—
payer	varchar		—	—	—
plan	varchar		—	—	—
prescribing_provider_id	varchar		Provider	—	Practitioner who wrote the prescription.
prescribing_provider_name	varchar		—	—	—
dispensing_provider_id	varchar		Provider	—	Pharmacy that filled the prescription.
dispensing_provider_name	varchar		—	—	—
dispensing_date	date		—	—	Date the prescription was filled.
ndc_code	varchar		National drug code directory	—	National Drug Code for the dispensed product.
ndc_description	varchar		—	—	—
quantity	integer		—	—	Quantity dispensed.
days_supply	integer		—	—	Days of therapy the fill covers. The basis of adherence measures.
refills	integer		—	—	Number of refills authorized or dispensed.
paid_date	date		—	—	—
paid_amount	number		—	—	Amount the payer paid for the fill.
allowed_amount	number		—	—	Contractually allowed amount for the fill.
charge_amount	number		—	—	—
coinsurance_amount	number		—	—	—
copayment_amount	number		—	—	—
deductible_amount	number		—	—	—
in_network_flag	integer		—	—	—
enrollment_flag	integer		—	—	—
member_month_id	varchar		—	—	—
file_date	date		—	—	—
ingest_datetime	timestamp		—	—	—
file_name	varchar		—	—	—
dax_last_run	varchar		—	—	Timestamp of the warehouse build that produced this row.
data_source	varchar		—	not null	Label for the contributing system.

Querying

select *
from dax_core.pharmacy_claim
limit 100;