SCRIPT_DETAIL_TABLE

This table provides ingredient, company, and categorical detail for all FDA National Drug Codes (NDCs).

Queries that source from SCRIPT_DETAIL_TABLE table

• scriptDetail

What is in the SCRIPT_DETAIL_TABLE table?

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

feature	description	example
ndc	FDA standardized National Drug Code 11 for a dispensed drug	00002021301
labeler	A company or organization that is a manufacturer, repackager, relabeler, or distributor of drugs	eli lilly and company
product_type	A classification of a drug product based on its intended use and how it is regulated by the FDA	human otc drug
substance	A substance is the active ingredient in a drug product	insulin
substance_unit	The unit of measurement for the active ingredient in a drug product	[iU]/mL
dosage_form	The type of pharmaceutical formulation, such as a tablet, capsule, liquid, or injection, that a drug product is available in	injection, solution
route	Method by which a drug product is administered to the body	parenteral
marketing_category	A classification of a drug product based on its regulatory status and how it is marketed	bla
application_number	A unique identifier for an NDC labeler's request to obtain an NDC labeler code	BLA018780
pharm_classes	A list of classifications of a drug product based on its therapeutic action, or how it works in the body	insulin [cs], insulin [epc]

Glossary Helper Function

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

Python

# 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_DETAIL_TABLE'))