Clinician-administered Drug File Layout

This layout document describes the fields in the clinician-administered drug search data file.

Field Name	Description	Length	Format	Note
CAD_NDC	Identifies the 11-digit National Drug Code (NDC) number	11
CAD_NDC_MOD	Identifies the 2-digit NDC modifier	2
CAD_HCPCS_CODE	Identifies the Healthcare Common Procedure Coding System code	6
CAD_HCPCS_MOD_CODE	Identifies the 2-digit HCPCS code modifier	2
CAD_RELATION_START_DATE	Identifies the NDC relationship start date	10	MM/DD/YYYY
CAD_RELATION_END_DATE	Identifies the NDC relationship termination date	10	MM/DD/YYYY	Open-ended date = 12/31/3999
CAD_HCPCS_DESCRIPTION	Identifies the HCPCS description	100
CAD_NDC_LABEL	Identifies the First Databank (FDB) label name of the drug	100
CAD_NDC_PKG_SIZE_QTY	Identifies the NDC package size quantity	13	ZZZZZZ.99999
CAD_NDC_PKG_SIZE_MEASURE	Identifies the NDC package size measurement	2		F2 (International unit) GR (Gram) ML (Milliliter) UN (Unit)
CAD_NDC_PKG_TYPE_MEASURE	Identifies the NDC package type measurement	2
CAD_ROUTE_OF_ADMINISTRATION	Identifies the NDC route of administration	2
CAD_BILLING_UNITS	Identifies the NDC billing units	2
CAD_CONVERSION_FACTOR	Identifies the NDC conversion factor	13
CAD_EFFECTIVE_DATE	Identifies the NDC effective date	10	MM/DD/YYYY
CAD_END_DATE	Identifies the NDC termination date	10	MM/DD/YYYY	Open-ended date = 12/31/3999
CAD_NDC_PRIOR_EFF_DATE_2	Identifies the #2 prior NDC effective date	10	MM/DD/YYYY
CAD_NDC_PRIOR_END_DATE_2	Identifies the #2 prior NDC termination date	10	MM/DD/YYYY
CAD_PRIOR_CF_2	Identifies the #2 prior NDC conversion factor	13
CAD_NDC_PRIOR_EFF_DATE_3	Identifies the #3 prior NDC effective date	10	MM/DD/YYYY
CAD_NDC_PRIOR_END_DATE_3	Identifies the #3 prior NDC termination date	10	MM/DD/YYYY
CAD_PRIOR_CF_3	Identifies the #3 prior NDC conversion factor	13