SELECT sm.scheme_name, ma.application_type AS scheme_type, COUNT(ml.app_pk_id) AS total_application FROM mscd_licenses ml INNER JOIN mscd_applications_new ma ON ma.app_pk_id = ml.app_pk_id INNER JOIN mscd_scheme_master sm ON sm.scheme_code = ma.application_type LEFT JOIN mscd_region_master rm ON rm.region_id = ma.region_id WHERE ma.status != '-1' AND ml.status NOT IN ('-1', '0') AND ma.status!='-1' AND ml.status!='-1' AND ml.status!='0' AND ml.is_expire='0' GROUP BY ma.application_type ORDER BY sm.scheme_name DESC Scheme Wise Operative Licenses
brand

Management System Certification

A tool for Good Governance

Scheme Wise Operative Licenses

Region Wise
S.No Scheme No. of Licenses
1 Social Accountability Management System (SAMS) as per IS 16001 2
2 Service Quality Management System (SQM) as per IS 15700 129
3 Ready Mixed Concrete Certification Scheme (RMC) as per ISO 9001 and IS 4926 20
4 Ready Mix Concrete Process Certification as per IS 4926 10
5 Quality Management System (QMS) as per IS/ISO 9001 907
6 PIPED DRINKING WATER SUPPLY MANAGEMENT SYSTEM (PDWSMS) as per IS 17482 1
7 Occupational Health & Safety Management System (OHSMS) 189
8 Medical Devices Quality Management System Requirements and Essential principles of Safety and performance as per IS 23485 2
9 Medical Device Management System (MDMS) as per IS/ISO 13485 and IS 23485 16
10 Information Security Management Systems (ISMS) as per IS/ISO 27001 9
11 Hazard Analysis and Critical Control Points (HACCP) as per IS 15000 2
12 Food Safety Management System (FSMS) as per IS/ISO 22000 42
13 Environmental Management System (EMS) as per IS/ISO 14001 237
14 Energy Management System (EnMS) as per IS/ISO 50001 50
15 Educational Organizations Management System 14
16 CAS for Milk and Milk Products 5
17 Anti-Bribery Management system (ABMS) as per IS/ISO 37001 14
18 Adventure Tourism Safety Management System (ATSMS) as per IS / ISO 21101 1
Total 1650