input_layer__pharmacy_claim

Pharmacy claim lines as received from the source, before normalization.

At a glance

Schema	dax_input_layer
Table	input_layer__pharmacy_claim
Layer	Input Layer
Object type	view
Columns	25
Grain	claim_id, claim_line_number, data_source
Tags	input_layer

Columns

Column	Type	Key	Constraints	Description
claim_id	varchar	PK	—	—
claim_line_number	integer	PK	—	—
person_id	varchar		—	—
member_id	varchar		—	—
payer	varchar		—	—
plan	varchar		—	—
prescribing_provider_npi	varchar		—	—
dispensing_provider_npi	varchar		—	—
dispensing_date	date		—	—
ndc_code	varchar		—	—
quantity	integer		—	—
days_supply	integer		—	—
refills	integer		—	—
paid_date	date		—	—
paid_amount	float		—	—
allowed_amount	float		—	—
charge_amount	float		—	—
coinsurance_amount	float		—	—
copayment_amount	float		—	—
deductible_amount	float		—	—
in_network_flag	integer		—	—
file_name	varchar		—	—
file_date	date		—	—
ingest_datetime	timestamp		—	—
data_source	varchar	PK	—	—

Querying

select *
from dax_input_layer.input_layer__pharmacy_claim
limit 100;