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

Prescriber File Valid Values

Prescriber Degree Description

  • ANP = Advance Nurse Practitioner (Nursing Board)
  • DDS = Dentist (Dental Board)
  • DO = Osteopath / Individual (Medical Board)
  • DP = Podiatrist / Individual (Podiatry Board)
  • DPM = Podiatrist / Medical (Podiatry Board)
  • MD = Medical Doctor (Medical Board)
  • OD = Optometrist / Therapeutic (Optometry Board)
  • OGD = Optometrist / Therapeutic & Glaucoma Specialist (Optometry Board)
  • PA = Physician Assistant (Medical Board)
  • PH = Prescribing Pharmacist (Pharmacy Board)

Prescriber Specialty Description

  • A = Allergy
  • ABS = Abdominal surgery
  • ADL = Adolescent medicine
  • ADM = Administrative medicine
  • AI = Allergy and immunology
  • AM = Aerospace medicine
  • AN = Anesthesiology
  • BLB = Blood banking
  • CD = Cardiovascular diseases
  • CDS = Cardiovascular surgery
  • CHN = Child neurology
  • CHP = Child psychiatry
  • CLP = Clinical pathology
  • CRS = Colon and rectal surgery
  • D = Dermatology
  • DIA = Diabetes
  • DMP = Dermopathology
  • DR = Diagnostic radiology
  • EM = Emergency medicine
  • END = Endocrinology
  • ETX = Medical toxicology (emergency medicine)
  • FOP = Forensic pathology
  • FP = Family practice
  • FSM = Sports medicine (family practice)
  • FX = Flexible
  • GE = Gastroenterology
  • GEN = Genetics
  • GER = Geriatrics
  • GP = General practice
  • GPM = General preventive medicine
  • GS = General surgery
  • GYN = Gynecology
  • HEM = Hematology
  • HNS = Head and neck surgery
  • HS = Hand surgery
  • ID = Infectious diseases
  • IG = Immunology
  • IM = Internal medicine
  • LM = Legal medicine
  • MGP = Molecular genetic pathology
  • MT = Manipulative therapy
  • N = Neurology
  • NA = Neuropathology
  • NEP = Nephrology
  • NM = Nuclear medicine
  • NPM = Neonatal-perinatal medicine
  • NR = Nuclear radiology
  • NS = Neurological surgery
  • NTR = Nutrition
  • OBG = Obstetrics and gynecology
  • OBS = Obstetrics
  • OM = Occupational medicine
  • OMF = Oral & maxillofacial surgery
  • ON = Oncology
  • OPH = Ophthalmology
  • ORS = Orthopedic surgery
  • OS = Other specialty
  • OTO = Otolaryngology
  • P = Psychiatry
  • PA = Pharmacology, clinical
  • PD = Pediatrics
  • PDA = Pediatrics, Allergy
  • PDC = Pediatrics, Cardiology
  • PDE = Pediatric endocrinology
  • PDR = Pediatric radiology
  • PDS = Pediatric surgery
  • PH = Public health
  • PHO = Pediatric hematology/oncology
  • PM = Physical med. & rehabilitation
  • PS = Plastic surgery
  • PTH = Pathology
  • PUD = Pulmonary diseases
  • PYA = Psychoanalysis
  • R = Radiology
  • REN = Reproductive endocrinology
  • RHI = Rhinology
  • RHU = Rheumatology
  • RO = Radiation oncology
  • TR = Therapeutic radiology
  • TRS = Traumatic surgery
  • TS = Thoracic surgery
  • U = Urology
  • US = Unspecified
  • VS = Vascular surgery