ACTIVE LICENSE HOLDER FILE DESCRIPTION -------------------------------------- The Active License Holder file contains a list of active license holder records which meet the criteria specified by the web user. The file is a comma-separated file, meaning each value is separated by a comma. Additionally, each value is enclosed by quotation marks. The first row in this file contains the field names. The rest of the rows contain data. The first row in the file will look something like this: "LicNum","DateIssued","DateExpired", etc... The data will look something like this: "MHDRET00000123","01/01/1990","01/01/1991", etc... Below is a table of field names included in this file as well as the maximum number of characters that the field could have and a short description of the field. FIELD MAXIMUM NAME CHARACTERS DESCRIPTION ---------- ---------- ------------------------------------------------------- LicNum 14 License number DateIssued 10 Date license was issued in MM/DD/YYYY format DateExpired 10 Date license expires in MM/DD/YYYY format Status 10 Status of license Retailer 1 This field value is 1 if licensed as a retailer Broker 1 This field value is 1 if licensed as a broker Installer 1 This field value is 1 if licensed as a installer Manufacturer 1 This field value is 1 if licensed as a manufacturer Salesperson 1 This field value is 1 if licensed as a salesperson SalvageRebuilder 1 This field value is 1 if licensed as a salvage rebuilder Name 40 Name of license holder MailAddr1 30 Mailing address of license holder Mail_Addr2 30 Second line of mailing address of license holder Mail_City_State 30 Mailing address city, state, and zip of license holder LocAddr1 30 Location address of license holder LocAddr2 30 Second line of Location address of license holder LocCityState 30 Location address city, state, and zip of license holder Phone 14 Phone number of license holder County 15 County of license holder This file Last Revised 12/30/2013