SCRIPT_TABLE

Queries that source from SCRIPT_TABLE table

What is in the SCRIPT_TABLE table?

Results are returned as a json, pySpark DataFrame, or pandas DataFrame (default).

feature	description	example
journey_id	Randomly generated identifier unique to each longitudinal patient journey.	355ed5199ebed017821c7faa62965a61
script_id	Randomly generated identifier unique to each prescription claim.	9318831e2ce3f30a83b1317b4d02ebfd
group_id	Randomly generated identifier unique to each payor plan corresponding to the prescription written.	315cb4170e73bed429a86e3dbb4e95a
script_date	Date the prescription was written	2022-01-21
service_date	Date that the prescription was filled, services rendered, or the payer began coverage following Part A expiration in a long-term care setting	2019-02-25
patient_state	US State residence of the patient on each encounter	AZ
patient_short_zip	First three digits of the patient's zip code	801
patient_age	Age (within 5 years) of the patient at the moment of each encounter.	62
patient_gender	Gender/Sex of the patient	M
hcp_npi	National Provider Identifier (NPI) of the individual that wrote the prescription for the patient.	1003878000
hcp_taxonomy	Primary taxonomy code of the individual provider who wrote the prescription.	207Q00000X
hcp_specialty	Primary specialty of the individual provider provider wrote the prescription.	family medicine - general
hco_npi	National Provider Identifier (NPI) of the organization that fulfilled the prescription	1063001238
ndc	FDA National Drug Code version 11 standardized code for a dispensed drug	68645054154
proprietary_name	Unique brand name of a drug product as assigned by the drug manufacturer	glimepiride
refills	Maximum number of refills authorized	1
quantity_prescribed	Quantity of drug units prescribed	0
quantity_dispensed	Quantity of drug units dispensed	30
fill_number	Refill number for the current SCRIPT_ID	1
days_supply	Estimated number of days the dispensed drugs will last	30
unit_of_measure	Units of measure for the quantity_dispensed	EA
submitted_cost	Pharmacy submitted cost of the claim	$46.00
patient_pay	Patient cost responsibility as determined by payor	$5.90
copay_insurance	Patient cost responsibility as copay or coinsurance	$0.00
plan_pay	Payor cost responsibility	$1.50

Glossary Helper Function

CareQuery API Glossary helps users understand the underlying SCRIPT_TABLE dataset within the python SDK.

# import package
from care_query.care_query import CareQuery

# instantiate and connect
cq = CareQuery(email = "your-email", 
               token = "your-api-token")

# return details 
print(cq.glossary.table_detail('SCRIPT_TABLE'))