LicenseList_DPS.xls
XLS spreadsheet 45 KB Posted
- Attached to
- E-Licensing
- Solicitation number
- S116333-vCurrent
- Issued by
- Middlesex County, Suffolk County, Boston City, Chelsea City, Massachusetts
About this file
This document appears to be an excel spreadsheet that outlines the various licensing and inspection programs administered by the Department of Public Safety (DPS) and Department of Fire Services (DFS) for the state. It details the master license types, associated business units, database platforms, and key metrics such as the number of active licenses and inspections performed.
The spreadsheet covers a wide range of regulated activities including building operations, elevators, engineering, regulatory activities, amusement devices, concrete technicians, blasting/explosives, fireworks, fire equipment, marine fueling, above-ground storage tanks, duct cleaning, and fire-safe cigarettes. For each license type, the document specifies the exam requirements, inspection criteria, CORI restrictions, and database platforms used to track the activity. The data suggests the DPS and DFS oversee a significant volume of regulated activities, with over 158,000 active licenses and 136,000 inspections performed annually across their jurisdictions.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| LicensingRFR_DPS.doc | DOC document | |
| w9.doc | DOC document | |
| Questions_Answers_Forum.xls | XLS spreadsheet | |
| ampplanform.doc | DOC document | |
| consig.doc | DOC document | |
| consltfm.doc | DOC document | |
| ctc.doc | DOC document | |
| 2009_05_12_DPSELICENSEFY09RFR_EvaluationCriteria_AwardInfo.docx | DOCX document | |
| CostWorksheet_DPS.xls | XLS spreadsheet | |
| S116333-vCurrent_OD.xlsx | XLSX spreadsheet | |
| eft_form.doc | DOC document | |
| ProcurementCalendar_DPS.doc | DOC document | |
| po.doc | DOC document | |
| standard_contract_frm.doc | DOC document |
Show all 14
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Licensing & Inspection
| Department of Public Safety / Department of Fire Services - Licensing and Inspection | |||||||||||||
| Order | Agency | Business Unit | Master License Type | Count by dept | License / Inspection Type /Class | Exam require-ment | Inspection | CORI | Restri-ction(s) | Database Platform | Database Name | Number Active Licenses | Approximate Number Inspections |
| 1 | DPS | Building | Individual | 4 | Motion Picture Operator License | x | Foxpro | General License | 296 | ||||
| 2 | Inspection | Building Plan Exam & Permit | x | MS Access | Building Permits | 408 | |||||||
| 3 | Inspection | Building Permit Electrical Work | x | MS Access | Building Permits | 13 | |||||||
| 4 | Inspection | Building Inspection Certificate - State Buildings | x | Foxpro | Inspection Database | 1336 | |||||||
| 5 | Inspection | Building Inspection Certificate - Hospitals / Clinics | Foxpro | Inspection Database | 800 | 2057 | |||||||
| 6 | DPS | Elevator | Individual | 5 | Elevator Mechanic License | x | Foxpro | General License | 1058 | ||||
| 7 | Individual | Elevator Operator License | x | Foxpro | General License | 703 | |||||||
| 8 | Elevator Inspection | x | Foxpro | Inspection Database | 37410 | ||||||||
| 9 | Inspection | Installation Permit | |||||||||||
| 10 | Inspection | Repair Permit | |||||||||||
| 11 | Inspection | Annual Inspection | |||||||||||
| Inspection | Modernization | ||||||||||||
| 12 | DPS | Engineer | Individual | 28 | Oil Burner Apprentice | Foxpro | General License | 11796 | |||||
| 13 | Individual | Inspector of Boilers and Pressure Vessel for Ins.Co | x | Foxpro | General License | 120 | |||||||
| 14 | Individual | Oil Burner Certificate of Competency | x | 4 | Foxpro | General License | 11796 | ||||||
| 15 | Engineer License | Foxpro | General License | ||||||||||
| 16 | Individual | 1st Class License | x | 440 | |||||||||
| 17 | Individual | 2nd Class License | x | 805 | |||||||||
| 18 | Individual | 3rd Class License | x | 1354 | |||||||||
| 19 | Individual | Special to Have Charge | x | 361 | |||||||||
| 20 | Individual | Special to Operate License | x | 552 | |||||||||
| 21 | Fireman | Foxpro | General License | ||||||||||
| 22 | Individual | 1st Class License | x | 489 | |||||||||
| 23 | Individual | 2nd Class License | x | 2189 | |||||||||
| 24 | Individual | Hoisting Engineer License | x | 14 | Foxpro | General License | 43805 | ||||||
| 25 | Nuclear Power Plant License | Foxpro | General License | ||||||||||
| 26 | Individual | Assistant | x | 37 | |||||||||
| 27 | Individual | Operator | x | 55 | |||||||||
| 28 | Individual | Senior Engineer | x | 10 | |||||||||
| 29 | Pipe Fitter License | Foxpro | General License | ||||||||||
| 30 | Company/Individual | Apprentice | 421 | ||||||||||
| 31 | Company/Individual | Journeyman | x | 3484 | |||||||||
| 32 | Company/Individual | Master | x | 2232 | |||||||||
| 33 | Refrigeration License | Foxpro | General License | ||||||||||
| 34 | Company/Individual | Trainee | 796 | ||||||||||
| 35 | Company/Individual | Contractor | x | 799 | |||||||||
| 36 | Company/Individual | Technician | x | 4389 | |||||||||
| 37 | Sprinkler License | Foxpro | General License | ||||||||||
| 38 | Company/Individual | Apprentice | 853 | ||||||||||
| 39 | Company/Individual | Contractor | x | 956 | |||||||||
| 40 | Company/Individual | Journeyman | x | 2425 | |||||||||
| 41 | Carriage Horse License | Foxpro | General License | ||||||||||
| 42 | Company/Individual | Company / Operator | 15 | ||||||||||
| 43 | Company/Individual | Carriage Horse Driver | 43 | ||||||||||
| 44 | Inspection | Boiler Inspection Certificate | x | DPS JO | Jourisdiction On-line | 47886 | |||||||
| 45 | Inspection | Pressure Vessel Inspection Certificate | x | DPS JO | Jourisdiction On-line | 37090 | |||||||
| 46 | Inspection | Refrigeration Inspection Certificate | x | DPS JO | Jourisdiction On-line | ? | |||||||
| 47 | Registration | State Trench Permit | Web Site PDF form | new | |||||||||
| 48 | Registration | Trench Violations | Web Site PDF form | new | |||||||||
| 49 | DPS | Reg. Activities | Individual | 9 | Assumed Name Registration | Foxpro | General License | 0 | |||||
| 50 | Security Systems License | Foxpro | General License | ||||||||||
| 51 | Company/Individual | Certificate of Clearance | x | 3166 | |||||||||
| 52 | Company/Individual | S-License - Contractor | x | 590 | |||||||||
| 53 | Company/Individual | Ticket Resellers | x | MS Access | 137 | ||||||||
| 54 | Company/Individual | Theatrical Booking Agency | x | MS Access | 66 | ||||||||
| 55 | Company/Individual | Sunday Entertainment Permit | MS Access | 1675 | |||||||||
| 56 | Company/Individual | Public Warehousemen | MS Access | 18 | |||||||||
| 57 | Inspection | Tramway Certificate | x | MS Access | 20 | ||||||||
| 58 | Company/Individual | Inspector of Amusement Devices for Ins.Co | Foxpro | General License | 18 | ||||||||
| 59 | Amusment Inspections | Company/Individual | 3 | Amusement Company License | MS Access | Amusement | 230 | ||||||
| 60 | Location/Event | Amusement Device Inspection | x | MS Access | Amusement | 2665 | |||||||
| 61 | Company/Individual | Amusement - Certified Maintenance Mechanic | x | Foxpro | General License | 94 | |||||||
| 62 | DPS | BBRS | Individual | 9 | Local Building Officials Certification / ID | x | Filemaker Pro | 26 | |||||
| 63 | Company/Individual | Native Lumber Producers | MS Access | 12 | |||||||||
| 64 | Individual | Construction Supervisor License | x | 6 | Foxpro | General License | 52766 | ||||||
| 65 | Individual | Concrete Technician License | Foxpro | General License | 764 | ||||||||
| 66 | Company/Individual | Concrete Testing Laboratories | MS Access | 28 | |||||||||
| 67 | Manufactured Building | MS Access | |||||||||||
| 68 | Company/Individual | Company Certification | 116 | ||||||||||
| 69 | Inspection | Plan review and acceptance | 200 | ||||||||||
| 70 | Inspection | Third Party Home Inspection / Buildings Labels | 963 | ||||||||||
| 71 | Company | Third Party Inspection Agency | 9 | ||||||||||
| 72 | DFS | Code Compliance Unit | 7 | Blasting/Explosives | |||||||||
| 73 | Company | Black or Smokeless Powder License | x | MS Access | DFS Licensing Db | 25 | |||||||
| 74 | Company | Explosives User Certificate | x | 1 | MS Access | DFS Licensing Db | 71 | ||||||
| 75 | Company | License to Sell Explosives | x | MS Access | DFS Licensing Db | 7 | |||||||
| 76 | Individual | Blasting Certificate of Competency | x | x | 2 | MS Access | DFS Licensing Db | 598 | |||||
| 77 | Individual | Cannon/Mortar Certificate of Competency | x | x | MS Access | DFS Licensing Db | 191 | ||||||
| 78 | Location/Event | Explosives Storage Magazine Permit | MS Access | DFS Licensing Db | 392 | ||||||||
| 79 | Inspection | Blasting Complaint/Inspection | x | Lotus Notes | Code Compliance Db | 533 | |||||||
| 80 | 8 | Fireworks | |||||||||||
| 81 | Company | Fireworks/Special Effects User Permit | x | MS Access | DFS Licensing Db | 16 | |||||||
| 82 | Individual | Fireworks Certificate of Competency | x | x | MS Access | DFS Licensing Db | 116 | ||||||
| 83 | Individual | Special Effects Certificate of Competency | x | x | MS Access | DFS Licensing Db | 30 | ||||||
| 84 | Location/Event | Permit to Transport Fireworks | x | MS Access | DFS Licensing Db | 20 | |||||||
| 85 | Location/Event | Portable Firing Trailer Certificate | x | MS Access | DFS Licensing Db | 31 | |||||||
| 86 | Location/Event | Remote Electrical Firing Systems | x | MS Access | DFS Licensing Db | 1 | |||||||
| 87 | Inspection | Fireworks Inspections | x | Lotus Notes | Code Compliance Db | 181 | |||||||
| 88 | 3 | Fire Equipment | |||||||||||
| 89 | Company | Fire Equipment Certificate of Registration | 5 | MS Access | DFS Licensing Db | 131 | |||||||
| 90 | Individual | Fire Equiment Certificate of Competency | x | 5 | MS Access | DFS Licensing Db | 752 | ||||||
| 91 | Inspection | Fire Equipment Inspection | x | Lotus Notes | Code Compliance Db | 56 | |||||||
| 92 | 1 | Duct Cleaning | |||||||||||
| 93 | Individual | Duct Cleaning Inspectors Certificate | x | New Regulation | |||||||||
| 94 | 2 | Marine Fueling | |||||||||||
| 95 | Company/Individual | MF Permit | x | MS Access | DFS Licensing Db | 135 | |||||||
| 96 | Inspection | MF Inspection | x | 117 | |||||||||
| 97 | 5 | Regulatory Activity/Assistance | |||||||||||
| 98 | General Inspections | x | Lotus Notes | Code Compliance db | 339 | ||||||||
| 99 | Complaints | Excel | Log | 2090 | |||||||||
| 100 | Technical Assistance | Excel | Log | 3246 | |||||||||
| 101 | Company | Quarterly Innholder (Fire Dept Login) | |||||||||||
| 102 | Company/Individual | Complaint Tracking | |||||||||||
| 103 | FIOA Request Tracking | ||||||||||||
| 104 | DFS | Cigarette Compliance Unit | 2 | Fire Sage Cigarette Program | |||||||||
| 105 | Location/Event | FSC Permit | x | MS Excel | Safe Cigarette | 720 | |||||||
| 106 | Inspection | FSC Inspection | x | Lotus Notes | Code Compliance Db | ||||||||
| 107 | DFS | Fire Protection Engineering | 2 | Fire Protection Engineering | |||||||||
| 108 | Location/Event | Plan Reviews (SS/CNG) | x | Lotus Notes | Code Compliance Db | 284 | 76 | ||||||
| 109 | Inspection | Site Inspections (SS/CNG/AST) | x | Lotus Notes | Code Compliance Db | 350 | |||||||
| 110 | 3 | Above-Ground Storage Tank | |||||||||||
| 111 | Location/Event | AST Tank Registration | x | MS Access | AST Database | 552 | |||||||
| 112 | Inspections | 3rd Party AST Inspections | x | MS Access | AST Database | 552 | |||||||
| 113 | Inspections | DFS Inspections | x | Lotus Notes | Code Compliance Db | 196 | |||||||
| 114 | 91 | 158029 | 136621 |
Master License Type
| DPS Business Unit | DPS Database | Master License Type |
| Building Licensing | General License | |
| Building Inspections | Inspection Db | |
| Building | MS Access | |
| Elevator Licensing | General License | |
| Elevator Inspections | Inspection Db | |
| Engineering | General License | |
| Engineering - Boiler/Pressure/Refri | Insurance Co Application | |
| Regulatory Activities | General License | |
| Regulatory Activities | MS Access | |
| Amusement Mechanic & Inspector | General License | |
| Amusement License & Inspection | MS Access | |
| BBRS Concrete | General License | |
| BBRS | MS Access | |
| DFS Business Unit | DFS Database | Master License Type |
| Blasting/Explosives/Fireworks | DFS Licensing | Company/Individual |
| B/E/F Inspections | Lotus Notes | Inspection |
| Fire Equipment | DFS Licensing | Company/Individual |
| Fire Equipment Inspections | Lotus Notes | Inspection |
| Marine Fueling Registration | DFS Licensing | Location/Event |
| Marine Fueling Inspection | Lotus Notes | Inspection |
| Tank Registration | AST/UST | Location/Event |
| Tank Inspections | Lotus Notes | Inspection |
| Duct Cleaning | DFS Licensing | Company/Individual |
| Plan Reviews | Lotus Notes | Location/Event |
| Plan Inspections | Lotus Notes | Inspection |
| Fire Safe Cigarettes | Excel | Location/Event |
| Fire Safe Cigarettes | Lotus Notes | Inspection |
Sheet2
File details come from the government source that posted it. Updated .