Clinician-administered Drug File Layout

Last Updated

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