Prescriber File Layout

Last Updated

This layout document describes the fields in the prescriber search data file.

Field Name Description Length Format Note
Prescriber_VendorNumber License number 15    
Prescriber_NPI 10-digit National Provider Identifier (NPI) 10    
Prescriber_LastName Prescriber’s last name 22    
Prescriber_FirstName Prescriber’s first name 22    
prescriber_EffDate The effective date of prescriber’s license 10 MM/DD/CCYY  
Prescriber_TermDate The termination date of prescriber’s license 10 MM/DD/CCYY Open-ended date appears as null
Prescriber_Title 2-3–character degree code 3   Refer to the valid values for prescriber degree description
Prescriber_TitleDesc Degree description 50   Refer to the valid values for prescriber degree description
Prescriber_specialty 1-3–character specialty code 3   Refer to the valid values for prescriber specialty description
Prescriber_SpecialtyDesc Specialty description 50   Refer to the valid values for prescriber specialty description
Prescriber_Address The physical address of the prescriber (line #1) 30    
Prescriber_Address2 The physical address of the prescriber (line #2) 50    
Prescriber_City Physical address city 20    
Prescriber_State Physical address state (two-character abbreviation) 2    
Prescriber_Zip Prescriber address ZIP code 5    
Prescriber_certification_required Identifies whether the prescriber is required to certify to prescribe for HTW clients 3    
Prescriber_HTW_Certified Identifies whether the prescriber is certified to prescribe for HTW clients 3    
Prescriber_HTW_EffDate Identifies the effective date of the prescriber’s HTW certification 10 MM/DD/CCYY  
Prescriber_HTW_TermDate Identifies the termination date of the prescriber’s HTW certification 10 MM/DD/CCYY Open-ended date appears as null