cms_ncd_spreadsheet_database.sql

-- MySQL dump 10.13  Distrib 5.7.44, for Win64 (x86_64)
--
-- Host: localhost    Database: cms_ncd_spreadsheet_database
-- ------------------------------------------------------
-- Server version	5.7.44-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `carc_rarc_ncd`
--

DROP TABLE IF EXISTS `carc_rarc_ncd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `carc_rarc_ncd` (
  `ID` int(11) NOT NULL,
  `CARC` varchar(10) DEFAULT NULL,
  `CARC_Description` text,
  `RARC` varchar(10) DEFAULT NULL,
  `RARC_Description` text,
  `ASC_X12_CAGC` varchar(20) DEFAULT NULL,
  `CORE_Business_Scenario` varchar(255) DEFAULT NULL,
  `NCD_No` varchar(20) DEFAULT NULL,
  `CARC_plus_RARC` varchar(255) GENERATED ALWAYS AS (concat(`CARC`,if(((`RARC` is not null) and (`RARC` <> '')),concat(' + ',`RARC`),''))) STORED,
  PRIMARY KEY (`ID`),
  KEY `idx_carc_rarc_ncdno` (`NCD_No`),
  KEY `idx_carc_plus_rarc` (`CARC_plus_RARC`),
  KEY `idx_carc` (`CARC`),
  KEY `idx_rarc` (`RARC`),
  CONSTRAINT `carc_rarc_ncd_ibfk_1` FOREIGN KEY (`NCD_No`) REFERENCES `ncd` (`NCD_No`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `carc_rarc_ncd`
--

LOCK TABLES `carc_rarc_ncd` WRITE;
/*!40000 ALTER TABLE `carc_rarc_ncd` DISABLE KEYS */;
INSERT INTO `carc_rarc_ncd` (`ID`, `CARC`, `CARC_Description`, `RARC`, `RARC_Description`, `ASC_X12_CAGC`, `CORE_Business_Scenario`, `NCD_No`) VALUES (1,'171','\"Payment is denied when performed/billed by this type of provider in this type of facility. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N428','Not covered when performed in this place of service.','\"CO, PI or PR\"','3','20.4'),(2,'11','\"The diagnosis is inconsistent with the procedure. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N386','This decision was based on a National Coverage Determination (NCD). An NCD provides a coverage determination as to whether a particular item or service is covered. A copy of this policy is available at www.cms.gov/mcd/search.asp. If you do not have web ac','\"CO, PI or PR\"','3','20.4'),(3,'50','\"These are non-covered services because this is not deemed a \'medical necessity\' by the payer. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N386','This decision was based on a National Coverage Determination (NCD). An NCD provides a coverage determination as to whether a particular item or service is covered. A copy of this policy is available at www.cms.gov/mcd/search.asp. If you do not have web ac','\"CO, PI or PR\"','3','20.9.1'),(4,'50','\"These are non-covered services because this is not deemed a \'medical necessity\' by the payer. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','M76','Missing/incomplete/invalid diagnosis or condition.','\"CO, PI or PR\"','3','20.16'),(5,'167','\"This (these) diagnosis(es) is (are) not covered. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','','','\"CO, PI or PR\"','3','20.16'),(6,'11','\"The diagnosis is inconsistent with the procedure. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','M76','Missing/incomplete/invalid diagnosis or condition.','\"CO, PI or PR\"','3','20.20'),(7,'50','\"These are non-covered services because this is not deemed a \'medical necessity\' by the payer. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N386','This decision was based on a National Coverage Determination (NCD). An NCD provides a coverage determination as to whether a particular item or service is covered. A copy of this policy is available at www.cms.gov/mcd/search.asp. If you do not have web ac','\"CO, PI or PR\"','3','20.20'),(8,'8','\"The procedure code is inconsistent with the provider type/specialty (taxonomy). Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','','','\"CO, PI or PR\"','3','20.31'),(9,'50','\"These are non-covered services because this is not deemed a \'medical necessity\' by the payer. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N362','The number of Days or Units of Service exceeds our acceptable maximum.','\"CO, PI or PR\"','3','20.31'),(10,'58','\"Treatment was deemed by the payer to have been rendered in an inappropriate or invalid place of service. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N386','This decision was based on a National Coverage Determination (NCD). An NCD provides a coverage determination as to whether a particular item or service is covered. A copy of this policy is available at www.cms.gov/mcd/search.asp. If you do not have web ac','\"CO, PI or PR\"','3','20.31'),(11,'119','Benefit maximum for this time period or occurrence has been reached.','N435','Exceeds number/frequency approved /allowed within time period without support documentation.','\"CO, PI or PR\"','3','20.31'),(12,'167','\"This (these) diagnosis(es) is (are) not covered. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N428','Not covered when performed in this place of service.','\"CO, PI or PR\"','3','20.31'),(13,'8','\"The procedure code is inconsistent with the provider type/specialty (taxonomy). Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','','','\"CO, PI or PR\"','3','20.31.1'),(14,'50','\"These are non-covered services because this is not deemed a \'medical necessity\' by the payer. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N362','The number of Days or Units of Service exceeds our acceptable maximum.','\"CO, PI or PR\"','3','20.31.1'),(15,'58','\"Treatment was deemed by the payer to have been rendered in an inappropriate or invalid place of service. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N386','This decision was based on a National Coverage Determination (NCD). An NCD provides a coverage determination as to whether a particular item or service is covered. A copy of this policy is available at www.cms.gov/mcd/search.asp. If you do not have web ac','\"CO, PI or PR\"','3','20.31.1'),(16,'119','Benefit maximum for this time period or occurrence has been reached.','N435','Exceeds number/frequency approved /allowed within time period without support documentation.','\"CO, PI or PR\"','3','20.31.1'),(17,'167','\"This (these) diagnosis(es) is (are) not covered. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N428','Not covered when performed in this place of service.','\"CO, PI or PR\"','3','20.31.1'),(18,'8','\"The procedure code is inconsistent with the provider type/specialty (taxonomy). Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','','','\"CO, PI or PR\"','3','20.31.2'),(19,'50','\"These are non-covered services because this is not deemed a \'medical necessity\' by the payer. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N362','The number of Days or Units of Service exceeds our acceptable maximum.','\"CO, PI or PR\"','3','20.31.2'),(20,'58','\"Treatment was deemed by the payer to have been rendered in an inappropriate or invalid place of service. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N386','This decision was based on a National Coverage Determination (NCD). An NCD provides a coverage determination as to whether a particular item or service is covered. A copy of this policy is available at www.cms.gov/mcd/search.asp. If you do not have web ac','\"CO, PI or PR\"','3','20.31.2'),(21,'119','Benefit maximum for this time period or occurrence has been reached.','N435','Exceeds number/frequency approved /allowed within time period without support documentation.','\"CO, PI or PR\"','3','20.31.2'),(22,'167','\"This (these) diagnosis(es) is (are) not covered. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N428','Not covered when performed in this place of service.','\"CO, PI or PR\"','3','20.31.2'),(23,'8','\"The procedure code is inconsistent with the provider type/specialty (taxonomy). Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','','','\"CO, PI or PR\"','3','20.31.3'),(24,'50','\"These are non-covered services because this is not deemed a \'medical necessity\' by the payer. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N362','The number of Days or Units of Service exceeds our acceptable maximum.','\"CO, PI or PR\"','3','20.31.3'),(25,'58','\"Treatment was deemed by the payer to have been rendered in an inappropriate or invalid place of service. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N386','This decision was based on a National Coverage Determination (NCD). An NCD provides a coverage determination as to whether a particular item or service is covered. A copy of this policy is available at www.cms.gov/mcd/search.asp. If you do not have web ac','\"CO, PI or PR\"','3','20.31.3'),(26,'119','Benefit maximum for this time period or occurrence has been reached.','N435','Exceeds number/frequency approved /allowed within time period without support documentation.','\"CO, PI or PR\"','3','20.31.3'),(27,'167','\"This (these) diagnosis(es) is (are) not covered. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N428','Not covered when performed in this place of service.','\"CO, PI or PR\"','3','20.31.3'),(28,'4','\"The procedure code is inconsistent with the modifier used. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','MA130','\"Your claim contains incomplete and/or invalid information, and no appeal rights are afforded because the claim is unprocessable.  Please submit a new claim with the complete/correct information.\"','CO or PI','2','110.4'),(29,'16','\"Claim/service lacks information or has submission/billing error(s). Usage: Do not use this code for claims attachment(s)/other documentation. At least one Remark Code must be provided (may be comprised of either the NCPDP Reject Reason Code, or Remittance Advice Remark Code that is not an ALERT.) Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','MA30','Missing/incomplete/invalid type of bill.','CO or PI','2','110.4'),(30,'50','\"These are non-covered services because this is not deemed a \'medical necessity\' by the payer. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N386','This decision was based on a National Coverage Determination (NCD). An NCD provides a coverage determination as to whether a particular item or service is covered. A copy of this policy is available at www.cms.gov/mcd/search.asp. If you do not have web ac','\"CO, PI or PR\"','3','110.4'),(31,'171','\"Payment is denied when performed/billed by this type of provider in this type of facility. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N428','Not covered when performed in this place of service.','\"CO, PI or PR\"','3','110.4'),(32,'50','\"These are non-covered services because this is not deemed a \'medical necessity\' by the payer. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N129','Not eligible due to the patient\'s age.','\"CO, PI or PR\"','3','150.10'),(33,'50','\"These are non-covered services because this is not deemed a \'medical necessity\' by the payer. Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N386','This decision was based on a National Coverage Determination (NCD). An NCD provides a coverage determination as to whether a particular item or service is covered. A copy of this policy is available at www.cms.gov/mcd/search.asp. If you do not have web ac','\"CO, PI or PR\"','3','150.10'),(34,'96','\"Non-covered charge(s). At least one Remark Code must be provided (may be comprised of either the NCPDP Reject Reason Code, or Remittance Advice Remark Code that is not an ALERT.) Usage: Refer to the 835 Healthcare Policy Identification Segment (loop 2110 Service Payment Information REF), if present.\"','N386','This decision was based on a National Coverage Determination (NCD). An NCD provides a coverage determination as to whether a particular item or service is covered. A copy of this policy is available at www.cms.gov/mcd/search.asp. If you do not have web ac','\"CO, PI or PR\"','3','150.10');
/*!40000 ALTER TABLE `carc_rarc_ncd` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `carc_rarc_ncd_view`
--

DROP TABLE IF EXISTS `carc_rarc_ncd_view`;
/*!50001 DROP VIEW IF EXISTS `carc_rarc_ncd_view`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `carc_rarc_ncd_view` AS SELECT 
 1 AS `ID`,
 1 AS `CARC`,
 1 AS `CARC_Description_Shortened`,
 1 AS `RARC`,
 1 AS `RARC_Description_Shortened`,
 1 AS `ASC_X12_CAGC`,
 1 AS `CORE_Business_Scenario`,
 1 AS `NCD_No`,
 1 AS `CARC_plus_RARC`*/;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `cpt_ncd`
--

DROP TABLE IF EXISTS `cpt_ncd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cpt_ncd` (
  `ID` int(11) NOT NULL,
  `CPT_HCPCS_Code` varchar(20) NOT NULL,
  `CPT_HCPCS_Description` text NOT NULL,
  `Eff_Date` date DEFAULT NULL,
  `Trmn_Date` date DEFAULT NULL,
  `NCD_No` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `idx_cpt_ncd_ncdno` (`NCD_No`),
  KEY `idx_cpt_hcpcs_code` (`CPT_HCPCS_Code`),
  CONSTRAINT `cpt_ncd_ibfk_1` FOREIGN KEY (`NCD_No`) REFERENCES `ncd` (`NCD_No`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cpt_ncd`
--

LOCK TABLES `cpt_ncd` WRITE;
/*!40000 ALTER TABLE `cpt_ncd` DISABLE KEYS */;
INSERT INTO `cpt_ncd` VALUES (1,'33223','Relocation of skin pocket for implantable defibrillator','2015-10-01',NULL,'20.4'),(2,'33230','Insertion of implantable defibrillator pulse generator only; with existing dual leads','2015-10-01',NULL,'20.4'),(3,'33231','Insertion of implantable defibrillator pulse generator only; with existing multiple leads','2015-10-01',NULL,'20.4'),(4,'33240','Insertion of implantable defibrillator pulse generator only; with existing single lead','2015-10-01',NULL,'20.4'),(5,'33241','Removal of implantable defibrillator pulse generator only','2015-10-01',NULL,'20.4'),(6,'33243','Removal of single or dual chamber implantable defibrillator electrode(s); by thoracotomy','2015-10-01',NULL,'20.4'),(7,'33244','Removal of single or dual chamber implantable defibrillator electrode(s); by transvenous extraction','2015-10-01',NULL,'20.4'),(8,'33249','Insertion or replacement of permanent implantable defibrillator system, with transvenous lead(s), single or dual chamber','2015-10-01',NULL,'20.4'),(9,'33262','Removal of implantable defibrillator pulse generator with replacement of implantable defibrillator pulse generator; single lead system','2015-10-01',NULL,'20.4'),(10,'33263','Removal of implantable defibrillator pulse generator with replacement of implantable defibrillator pulse generator; dual lead system','2015-10-01',NULL,'20.4'),(11,'93701','Bioimpedance derived physiologic cardiovascular analysis','2015-10-01',NULL,'20.16'),(12,'33979','Insertion of ventricular assist device, implantable intracorporeal, single ventricle','2015-10-01',NULL,'20.9.1'),(13,'33980','Removal of ventricular assist device, implantable intracorporeal, single ventricle','2015-10-01',NULL,'20.9.1'),(14,'33982','Replacement of ventricular assist device pump(s); implantable intracorporeal, single ventricle, without cardiopulmonary bypass','2015-10-01',NULL,'20.9.1'),(15,'33983','Replacement of ventricular assist device pump(s); implantable intracorporeal, single ventricle, with cardiopulmonary bypass','2015-10-01',NULL,'20.9.1'),(16,'Q0480','Driver for use with pneumatic ventricular assist device, replacement only','2015-10-01',NULL,'20.9.1'),(17,'Q0508','Miscellaneous supply or accessory for use with an implanted ventricular assist device','2015-10-01',NULL,'20.9.1'),(18,'Q0509','Miscellaneous supply or accessory for use with any implanted ventricular assist device for which payment was not made under medicare part a','2015-10-01',NULL,'20.9.1'),(19,'G0166','External counterpulsation, per treatment session','2015-10-01',NULL,'20.20'),(20,'92971','Cardioassist-method of circulatory assist; external','2015-10-01',NULL,'20.20'),(21,'93040','Rhythm ECG, 1-3 leads; with interpretation and report','2015-10-01',NULL,'20.20'),(22,'93041','Rhythm ECG, 1-3 leads; tracing only without interpretation and report','2015-10-01',NULL,'20.20'),(23,'94760','Noninvasive ear or pulse oximetry for oxygen saturation; single determination','2015-10-01',NULL,'20.20'),(24,'94761','Noninvasive ear or pulse oximetry for oxygen saturation; multiple determinations (eg, during exercise)','2015-10-01',NULL,'20.20'),(25,'93922','Limited bilateral noninvasive physiologic studies of upper or lower extremity arteries, (eg, for lower extremity: ankle/brachial indices at distal posterior tibial and anterior tibial/dorsalis pedis arteries plus bidirectional, Doppler waveform recording and analysis at 1-2 levels, or ankle/brachial indices at distal posterior tibial and anterior tibial/dorsalis pedis arteries plus volume plethysmography at 1-2 levels, or ankle/brachial indices at distal posterior tibial and anterior tibial/dorsalis pedis arteries with, transcutaneous oxygen tension measurement at 1-2 leve','2015-10-01',NULL,'20.20'),(26,'93923','Complete bilateral noninvasive physiologic studies of upper or lower extremity arteries, 3 or more levels (eg, for lower extremity: ankle/brachial indices at distal posterior tibial and anterior tibial/dorsalis pedis arteries plus segmental blood pressure measurements with bidirectional Doppler waveform recording and analysis, at 3 or more levels, or ankle/brachial indices at distal posterior tibial and anterior tibial/dorsalis pedis arteries plus segmental volume plethysmography at 3 or more levels, or ankle/brachial indices at distal posterior tibial and anterior tibial/dorsalis pedis arteries plus segmental transcutaneous oxygen tension measurements at 3 or more levels), or single level study with provocative functional maneuvers (eg, measurements with postural provocative tests, or measurements with reactive hyperemia)','2015-10-01',NULL,'20.20'),(27,'G0463','Hospital outpatient clinic visit for assessment and management of a patient','2015-10-01',NULL,'20.20'),(29,'G0422','Intensive cardiac rehabilitation; with or without continuous ecg monitoring with exercise, per session','2015-10-01',NULL,'20.31'),(30,'G0423','Intensive cardiac rehabilitation; with or without continuous ecg monitoring; without exercise, per session','2015-10-01',NULL,'20.31'),(31,'G0422','Intensive cardiac rehabilitation; with or without continuous ecg monitoring with exercise, per session','2015-10-01',NULL,'20.31.1'),(32,'G0423','Intensive cardiac rehabilitation; with or without continuous ecg monitoring; without exercise, per session','2015-10-01',NULL,'20.31.1'),(33,'G0422','Intensive cardiac rehabilitation; with or without continuous ecg monitoring with exercise, per session','2015-10-01',NULL,'20.31.2'),(34,'G0423','Intensive cardiac rehabilitation; with or without continuous ecg monitoring; without exercise, per session','2015-10-01',NULL,'20.31.2'),(35,'G0422','Intensive cardiac rehabilitation; with or without continuous ecg monitoring with exercise, per session','2015-10-01',NULL,'20.31.3'),(36,'G0423','Intensive cardiac rehabilitation; with or without continuous ecg monitoring; without exercise, per session','2015-10-01',NULL,'20.31.3'),(37,'36522','Photopheresis, extracorporeal','2015-10-01',NULL,'110.4'),(38,'22857','Total disc arthroplasty (artificial disc), anterior approach, including discectomy to prepare interspace (other than for decompression); single interspace, lumbar','2015-10-01',NULL,'150.10'),(39,'22860','Total disc arthroplasty (artificial disc), anterior approach, including discectomy to prepare interspace (other than for decompression); second interspace, lumbar (List separately in addition to code for primary procedure)','2015-10-01',NULL,'150.10');
/*!40000 ALTER TABLE `cpt_ncd` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `cpt_ncd_short_view`
--

DROP TABLE IF EXISTS `cpt_ncd_short_view`;
/*!50001 DROP VIEW IF EXISTS `cpt_ncd_short_view`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `cpt_ncd_short_view` AS SELECT 
 1 AS `ID`,
 1 AS `CPT_HCPCS_Code`,
 1 AS `CPT_HCPCS_Description`,
 1 AS `Eff_Date`,
 1 AS `Trmn_Date`,
 1 AS `NCD_No`*/;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `icd10cm_ncd`
--

DROP TABLE IF EXISTS `icd10cm_ncd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `icd10cm_ncd` (
  `ID` int(11) NOT NULL,
  `ICD10CM_Code` varchar(10) NOT NULL,
  `ICD10CM_Description` text NOT NULL,
  `Eff_Date` date DEFAULT NULL,
  `Trmn_Date` date DEFAULT NULL,
  `NCD_No` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `idx_icd10cm_ncd_ncdno` (`NCD_No`),
  KEY `idx_icd10cm_code` (`ICD10CM_Code`),
  CONSTRAINT `icd10cm_ncd_ibfk_1` FOREIGN KEY (`NCD_No`) REFERENCES `ncd` (`NCD_No`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `icd10cm_ncd`
--

LOCK TABLES `icd10cm_ncd` WRITE;
/*!40000 ALTER TABLE `icd10cm_ncd` DISABLE KEYS */;
INSERT INTO `icd10cm_ncd` VALUES (1,'I42.1','Obstructive hypertrophic cardiomyopathy','2015-10-01',NULL,'20.4'),(2,'I42.2','Other hypertrophic cardiomyopathy','2015-10-01',NULL,'20.4'),(3,'I45.6','Pre-excitation syndrome','2015-10-01',NULL,'20.4'),(4,'I45.81','Long QT syndrome','2015-10-01',NULL,'20.4'),(5,'I45.89','Other specified conduction disorders','2015-10-01',NULL,'20.4'),(6,'I46.2','Cardiac arrest due to underlying cardiac condition','2015-10-01',NULL,'20.4'),(7,'I46.9','\"Cardiac arrest, cause unspecified\"','2015-10-01',NULL,'20.4'),(8,'I47.20','\"Ventricular tachycardia, unspecified\"','2015-10-01',NULL,'20.4'),(9,'I47.21','Torsades de pointes','2015-10-01',NULL,'20.4'),(10,'I47.29','Other ventricular tachycardia','2015-10-01',NULL,'20.4'),(11,'I09.81','Rheumatic heart failure','2015-10-01',NULL,'20.9.1'),(12,'I11.0','Hypertensive heart disease with heart failure','2015-10-01',NULL,'20.16'),(13,'I13.0','\"Hypertensive heart and chronic kidney disease with heart failure and stage 1 through stage 4 chronic kidney disease, or unspecified chronic kidney disease\"','2015-10-01',NULL,'20.16'),(14,'I11.0','Hypertensive heart disease with heart failure','2015-10-01',NULL,'20.9.1'),(15,'I13.0','\"Hypertensive heart and chronic kidney disease with heart failure and stage 1 through stage 4 chronic kidney disease, or unspecified chronic kidney disease\"','2015-10-01',NULL,'20.9.1'),(16,'I13.2','\"Hypertensive heart and chronic kidney disease with heart failure and with stage 5 chronic kidney disease, or end stage renal disease\"','2015-10-01',NULL,'20.4'),(17,'I13.2','\"Hypertensive heart and chronic kidney disease with heart failure and with stage 5 chronic kidney disease, or end stage renal disease\"','2015-10-01',NULL,'20.9.1'),(18,'I20.0','Unstable angina','2015-10-01',NULL,'20.9.1'),(19,'I20.2','Refractory angina pectoris','2015-10-01',NULL,'20.9.1'),(20,'I21.01','ST elevation (STEMI) myocardial infarction involving left main coronary artery','2015-10-01',NULL,'20.9.1'),(21,'I21.02','ST elevation (STEMI) myocardial infarction involving left anterior descending coronary artery','2015-10-01',NULL,'20.9.1'),(22,'I21.09','ST elevation (STEMI) myocardial infarction involving other coronary artery of anterior wall','2015-10-01',NULL,'20.9.1'),(23,'I21.11','ST elevation (STEMI) myocardial infarction involving right coronary artery','2015-10-01',NULL,'20.9.1'),(24,'I10','Essential (primary) hypertension','2015-10-01',NULL,'20.16'),(25,'I11.9','Hypertensive heart disease without heart failure','2015-10-01',NULL,'20.16'),(26,'I12.0','Hypertensive chronic kidney disease with stage 5 chronic kidney disease or end stage renal disease','2015-10-01',NULL,'20.16'),(27,'I12.9','\"Hypertensive chronic kidney disease with stage 1 through stage 4 chronic kidney disease, or unspecified chronic kidney disease\"','2015-10-01',NULL,'20.16'),(28,'I13.10','\"Hypertensive heart and chronic kidney disease without heart failure, with stage 1 through stage 4 chronic kidney disease, or unspecified chronic kidney disease\"','2015-10-01',NULL,'20.16'),(29,'I13.11','\"Hypertensive heart and chronic kidney disease without heart failure, with stage 5 chronic kidney disease, or end stage renal disease\"','2015-10-01',NULL,'20.16'),(30,'I15.0','Renovascular hypertension','2015-10-01',NULL,'20.16'),(31,'I15.1','Hypertension secondary to other renal disorders','2015-10-01',NULL,'20.16'),(32,'I15.8','Other secondary hypertension','2015-10-01',NULL,'20.16'),(33,'I15.9','\"Secondary hypertension, unspecified\"','2015-10-01',NULL,'20.16'),(34,'I1A.0','Resistant hypertension','2015-10-01',NULL,'20.16'),(35,'I25.112','Atherosclerotic heart disease of native coronary artery with refractory angina pectoris','2015-10-01',NULL,'20.20'),(36,'I25.118','Atherosclerotic heart disease of native coronary artery with other forms of angina pectoris','2015-10-01',NULL,'20.20'),(37,'I25.702','\"Atherosclerosis of coronary artery bypass graft(s), unspecified, with refractory angina pectoris\"','2015-10-01',NULL,'20.20'),(38,'C84.01','\"Mycosis fungoides, lymph nodes of head, face, and neck\"','2015-10-01',NULL,'110.4'),(39,'C84.02','\"Mycosis fungoides, intrathoracic lymph nodes\"','2015-10-01',NULL,'110.4'),(40,'C84.03','\"Mycosis fungoides, intra-abdominal lymph nodes\"','2015-10-01',NULL,'110.4'),(41,'C84.04','\"Mycosis fungoides, lymph nodes of axilla and upper limb\"','2015-10-01',NULL,'110.4'),(42,'C84.05','\"Mycosis fungoides, lymph nodes of inguinal region and lower limb\"','2015-10-01',NULL,'110.4'),(43,'C84.06','\"Mycosis fungoides, intrapelvic lymph nodes\"','2015-10-01',NULL,'110.4'),(44,'C84.07','\"Mycosis fungoides, spleen\"','2015-10-01',NULL,'110.4'),(45,'C84.08','\"Mycosis fungoides, lymph nodes of multiple sites\"','2015-10-01',NULL,'110.4'),(46,'C84.09','\"Mycosis fungoides, extranodal and solid organ sites\"','2015-10-01',NULL,'110.4'),(47,'C84.11','\"Sézary disease, lymph nodes of head, face, and neck\"','2015-10-01',NULL,'110.4'),(48,'C84.12','\"Sézary disease, intrathoracic lymph nodes\"','2015-10-01',NULL,'110.4'),(49,'C84.13','\"Sézary disease, intra-abdominal lymph nodes\"','2015-10-01',NULL,'110.4');
/*!40000 ALTER TABLE `icd10cm_ncd` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `icd10pcs_ncd`
--

DROP TABLE IF EXISTS `icd10pcs_ncd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `icd10pcs_ncd` (
  `ID` int(11) NOT NULL,
  `ICD10_PCS` varchar(10) NOT NULL,
  `ICD10PCS_Desc` text NOT NULL,
  `Effective_Date` date DEFAULT NULL,
  `Trmn_Date` date DEFAULT NULL,
  `NCD_No` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `idx_icd10pcs_ncd_ncdno` (`NCD_No`),
  KEY `idx_icd10pcs_code` (`ICD10_PCS`),
  CONSTRAINT `icd10pcs_ncd_ibfk_1` FOREIGN KEY (`NCD_No`) REFERENCES `ncd` (`NCD_No`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `icd10pcs_ncd`
--

LOCK TABLES `icd10pcs_ncd` WRITE;
/*!40000 ALTER TABLE `icd10pcs_ncd` DISABLE KEYS */;
INSERT INTO `icd10pcs_ncd` VALUES (1,'0JH638Z','Insertion of Defibrillator Generator into Chest Subcutaneous Tissue and Fascia, Percutaneous Approach','2015-10-01',NULL,'20.4'),(2,'0JH639Z','Insertion of Cardiac Resynchronization Defibrillator Pulse Generator into Chest Subcutaneous Tissue and Fascia, Percutaneous Approach','2015-10-01',NULL,'20.4'),(3,'0JH808Z','Insertion of Defibrillator Generator into Abdomen Subcutaneous Tissue and Fascia, Open Approach','2015-10-01',NULL,'20.4'),(4,'0JH809Z','Insertion of Cardiac Resynchronization Defibrillator Pulse Generator into Abdomen Subcutaneous Tissue and Fascia, Open Approach','2015-10-01',NULL,'20.4'),(5,'0JH838Z','Insertion of Defibrillator Generator into Abdomen Subcutaneous Tissue and Fascia, Percutaneous Approach','2015-10-01',NULL,'20.4'),(6,'0JH839Z','Insertion of Cardiac Resynchronization Defibrillator Pulse Generator into Abdomen Subcutaneous Tissue and Fascia, Percutaneous Approach','2015-10-01',NULL,'20.4'),(7,'02H43KZ','Insertion of Defibrillator Lead into Coronary Vein, Percutaneous Approach','2015-10-01',NULL,'20.4'),(8,'02H60KZ','Insertion of Defibrillator Lead into Right Atrium, Open Approach','2015-10-01',NULL,'20.4'),(9,'02H63KZ','Insertion of Defibrillator Lead into Right Atrium, Percutaneous Approach','2015-10-01',NULL,'20.4'),(10,'02H64KZ','Insertion of Defibrillator Lead into Right Atrium, Percutaneous Endoscopic Approach','2015-10-01',NULL,'20.4'),(11,'02HA0QZ','Insertion of Implantable Heart Assist System into Heart, Open Approach','2015-10-01',NULL,'20.9.1'),(12,'02PA0QZ','Removal of Implantable Heart Assist System from Heart, Open Approach','2015-10-01',NULL,'20.9.1'),(13,'02WA0QZ','Revision of Implantable Heart Assist System in Heart, Open Approach','2015-10-01',NULL,'20.9.1'),(14,'02WA3QZ','Revision of Implant Heart Assist in Heart, Perc Approach','2015-10-01',NULL,'20.9.1'),(15,'02WA4QZ','Revise of Implant Heart Assist in Heart, Perc Endo Approach','2015-10-01',NULL,'20.9.1'),(16,'6A650ZZ','Phototherapy, Circulatory, Single','2015-10-01',NULL,'110.4'),(17,'6A651ZZ','Phototherapy, Circulatory, Multiple','2015-10-01',NULL,'110.4'),(18,'0SR20JZ','Replacement of Lumbar Vertebral Disc with Synthetic Substitute, Open Approach','2015-10-01',NULL,'150.10'),(19,'0SR40JZ','Replacement of Lumbosacral Disc with Synthetic Substitute, Open Approach','2015-10-01',NULL,'150.10');
/*!40000 ALTER TABLE `icd10pcs_ncd` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `icd10pcs_ncd_short_view`
--

DROP TABLE IF EXISTS `icd10pcs_ncd_short_view`;
/*!50001 DROP VIEW IF EXISTS `icd10pcs_ncd_short_view`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `icd10pcs_ncd_short_view` AS SELECT 
 1 AS `ID`,
 1 AS `ICD10_PCS`,
 1 AS `ICD10PCS_Desc_Short`,
 1 AS `Effective_Date`,
 1 AS `Trmn_Date`,
 1 AS `NCD_No`*/;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `modifier_ncd`
--

DROP TABLE IF EXISTS `modifier_ncd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `modifier_ncd` (
  `ID` int(11) NOT NULL,
  `Modifier` varchar(10) DEFAULT NULL,
  `Description` text,
  `NCD_No` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `idx_modifier_ncdno` (`NCD_No`),
  KEY `idx_modifier_code` (`Modifier`),
  CONSTRAINT `modifier_ncd_ibfk_1` FOREIGN KEY (`NCD_No`) REFERENCES `ncd` (`NCD_No`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `modifier_ncd`
--

LOCK TABLES `modifier_ncd` WRITE;
/*!40000 ALTER TABLE `modifier_ncd` DISABLE KEYS */;
INSERT INTO `modifier_ncd` VALUES (1,'22','Unusual procedural services ','20.16'),(3,'24','Unrelated evaluation and management service by the same physician during a postoperative period','20.31'),(4,'25','\"Significant, separately identifiable E&M service by the same physician on the same day of the procedure or  service \"','20.31.1'),(5,'26','Professional component ','20.31.2'),(6,'27','Multiple outpatient hospital E&M encounters on the same date ','20.31.3'),(7,'32','Mandated services ','20.4'),(8,'Q0',' Investigational clinical service provided in a clinical research study that is in an approved clinical research study.','20.9.1'),(9,'Q1','Routine clinical service provided in a clinical research study that is in an approved clinical research study. ','110.4'),(11,'Q0',' Investigational clinical service provided in a clinical research study that is in an approved clinical research study.','20.31'),(12,'Q0',' Investigational clinical service provided in a clinical research study that is in an approved clinical research study.','20.31.1'),(13,'Q0',' Investigational clinical service provided in a clinical research study that is in an approved clinical research study.','20.31.2'),(14,'Q0',' Investigational clinical service provided in a clinical research study that is in an approved clinical research study.','20.31.3'),(15,'Q1','Routine clinical service provided in a clinical research study that is in an approved clinical research study. ','110.4'),(16,'Q1','Routine clinical service provided in a clinical research study that is in an approved clinical research study. ','110.4'),(17,'26','Professional component ','20.31.1'),(18,'27','Professional component ','20.31.2'),(19,'28','Professional component ','20.31.3');
/*!40000 ALTER TABLE `modifier_ncd` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `msn_ncd`
--

DROP TABLE IF EXISTS `msn_ncd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `msn_ncd` (
  `ID` int(11) NOT NULL,
  `MSN_Cat` varchar(255) DEFAULT NULL,
  `MSN_Message` varchar(20) DEFAULT NULL,
  `English_Message` text,
  `NCD_Multi` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `NCD_Multi` (`NCD_Multi`),
  CONSTRAINT `msn_ncd_ibfk_1` FOREIGN KEY (`NCD_Multi`) REFERENCES `ncd` (`NCD_No`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `msn_ncd`
--

LOCK TABLES `msn_ncd` WRITE;
/*!40000 ALTER TABLE `msn_ncd` DISABLE KEYS */;
INSERT INTO `msn_ncd` VALUES (1,'15 Medical Necessity','15.20','The following policies were used when we made this decision: _____','20.20'),(2,'15 Medical Necessity','15.21','The information provided does not support the need for this many services or items in this period of time but you do not have to pay this amount.','20.20'),(3,'15 Medical Necessity','15.4','The information provided does not support the need for this service or item.','20.20'),(4,'15 Medical Necessity','15.20','The following policies were used when we made this decision: _____','20.31'),(5,'15 Medical Necessity','15.20','The following policies were used when we made this decision: _____','20.31.1'),(6,'15 Medical Necessity','15.20','The following policies were used when we made this decision: _____','20.31.2'),(7,'15 Medical Necessity','15.20','The following policies were used when we made this decision: _____','20.31.3'),(8,'20 Benefit Limits','20.5','These services cannot be paid because your benefits are exhausted at this time.','20.31'),(9,'20 Benefit Limits','20.5','These services cannot be paid because your benefits are exhausted at this time.','20.31.1'),(10,'20 Benefit Limits','20.5','These services cannot be paid because your benefits are exhausted at this time.','20.31.2'),(11,'20 Benefit Limits','20.5','These services cannot be paid because your benefits are exhausted at this time.','20.31.3'),(12,'21 Restrictions to Coverage','21.21','This service was denied because Medicare only covers this service under certain circumstances.','20.31'),(13,'21 Restrictions to Coverage','21.21','This service was denied because Medicare only covers this service under certain circumstances.','20.31.1'),(14,'21 Restrictions to Coverage','21.21','This service was denied because Medicare only covers this service under certain circumstances.','20.31.2'),(15,'21 Restrictions to Coverage','21.21','This service was denied because Medicare only covers this service under certain circumstances.','20.31.3'),(16,'21 Restrictions to Coverage',' 21.25','This service was denied because Medicare only covers this service in certain settings.','20.31.3'),(17,'21 Restrictions to Coverage',' 21.25','This service was denied because Medicare only covers this service in certain settings.','20.31'),(18,'21 Restrictions to Coverage',' 21.25','This service was denied because Medicare only covers this service in certain settings.','20.31.1'),(19,'21 Restrictions to Coverage',' 21.25','This service was denied because Medicare only covers this service in certain settings.','20.31.2'),(20,'15 Medical Necessity','15.20','The following policies were used when we made this decision: _____','110.4'),(21,'15 Medical Necessity','15.4','The information provided does not support the need for this service or item.','110.4'),(22,'21 Restrictions to Coverage','21.21','This service was denied because Medicare only covers this service under certain circumstances.','110.4'),(23,'15 Medical Necessity','15.20','The following policies were used when we made this decision: _____','150.10'),(24,'16 Miscellaneous','16.10','Medicare does not pay for this item or service.','150.10'),(25,'21 Restrictions to Coverage','21.24','This service is not covered for patients over age 60.','150.10');
/*!40000 ALTER TABLE `msn_ncd` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ncd`
--

DROP TABLE IF EXISTS `ncd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ncd` (
  `NCD_ID` int(11) NOT NULL,
  `NCD_No` varchar(255) DEFAULT NULL,
  `IOM_Link` text,
  `NCD_Title` text NOT NULL,
  `NCD_Link` text,
  `NCD_Effective_Date` date DEFAULT NULL,
  `NCD_Termination_dt` date DEFAULT NULL,
  PRIMARY KEY (`NCD_ID`),
  UNIQUE KEY `NCD_No` (`NCD_No`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ncd`
--

LOCK TABLES `ncd` WRITE;
/*!40000 ALTER TABLE `ncd` DISABLE KEYS */;
INSERT INTO `ncd` VALUES (1,'20.16','http://www.cms.gov/Regulations-and-Guidance/Guidance/Manuals/Downloads/ncd103c1_Part1.pdf','Cardiac Output Monitoring by Thoracic Electrical Bioimpedance','https://www.cms.gov/medicare-coverage-database/view/ncd.aspx?NCDId=267&ncdver=3','1999-07-01',NULL),(2,'20.20','http://www.cms.gov/Regulations-and-Guidance/Guidance/Transmittals/downloads/R898CP.pdf','External Counterpulsation (ECP) Therapy for Severe Angina','https://www.cms.gov/medicare-coverage-database/view/ncd.aspx?NCDId=97&ncdver=2','1999-07-01',NULL),(3,'20.31','https://www.cms.gov/Regulations-and-Guidance/Guidance/Manuals/downloads/ncd103c1_Part1.pdf','Intensive Cardiac Rehabilitation (ICR) Programs','https://www.cms.gov/medicare-coverage-database/view/ncd.aspx?NCDId=339','2010-08-12',NULL),(4,'20.31.1','https://www.cms.gov/Regulations-and-Guidance/Guidance/Manuals/downloads/ncd103c1_Part1.pdf','The Pritikin Program','https://www.cms.gov/medicare-coverage-database/view/ncd.aspx?ncdid=340&ncdver=1','2010-08-12',NULL),(5,'20.31.2','https://www.cms.gov/Regulations-and-Guidance/Guidance/Manuals/downloads/ncd103c1_Part1.pdf','Ornish Program for Reversing Heart Disease','https://www.cms.gov/medicare-coverage-database/view/ncd.aspx?ncdid=341&ncdver=1','2010-08-12',NULL),(6,'20.31.3','https://www.cms.gov/Regulations-and-Guidance/Guidance/Manuals/downloads/ncd103c1_Part1.pdf','Benson-Henry Institute Cardiac Wellness Program','https://www.cms.gov/medicare-coverage-database/view/ncd.aspx?ncdid=362&ncdver=1','2014-05-06',NULL),(7,'20.4','http://www.cms.gov/Regulations-and-Guidance/Guidance/Manuals/Downloads/ncd103c1_Part1.pdf','Implantable Cardioverter Defibrillators (ICDs)','https://www.cms.gov/medicare-coverage-database/view/ncd.aspx?NCDId=110','2018-02-15',NULL),(8,'20.9.1','https://www.cms.gov/Regulations-and-Guidance/Guidance/Manuals/downloads/ncd103c1_Part1.pdf','Ventricular Assist Devices','https://www.cms.gov/medicare-coverage-database/view/ncd.aspx?NCDId=360','2020-12-01',NULL),(9,'110.4','https://www.cms.gov/Regulations-and-Guidance/Guidance/Manuals/downloads/ncd103c1_Part2.pdf','Extracorporeal Photopheresis','https://www.cms.gov/medicare-coverage-database/view/ncd.aspx?ncdid=113','2012-04-30',NULL),(10,'150.10','https://www.cms.gov/Regulations-and-Guidance/Guidance/Manuals/downloads/ncd103c1_Part2.pdf','Lumbar Artificial Disc Replacement (LADR)','https://www.cms.gov/medicare-coverage-database/view/ncd.aspx?ncdid=313','2007-08-14',NULL);
/*!40000 ALTER TABLE `ncd` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `ncd_full_info`
--

DROP TABLE IF EXISTS `ncd_full_info`;
/*!50001 DROP VIEW IF EXISTS `ncd_full_info`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `ncd_full_info` AS SELECT 
 1 AS `NCD_No`,
 1 AS `NCD_Title`,
 1 AS `IOM_Link`,
 1 AS `NCD_Link`,
 1 AS `CPT_HCPCS_Code`,
 1 AS `CPT_HCPCS_Description`,
 1 AS `ICD10CM_Code`,
 1 AS `ICD10CM_Description`,
 1 AS `ICD10_PCS`,
 1 AS `ICD10PCS_Desc`,
 1 AS `CR_No`,
 1 AS `Revision_History_Details`,
 1 AS `CARC_plus_RARC`,
 1 AS `Type_of_Bill`,
 1 AS `Modifier`,
 1 AS `Responsibility`,
 1 AS `Rule_Description`*/;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `responsibility_ncd`
--

DROP TABLE IF EXISTS `responsibility_ncd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `responsibility_ncd` (
  `ID` int(11) NOT NULL,
  `Category` varchar(50) DEFAULT NULL,
  `Responsibility` varchar(50) DEFAULT NULL,
  `NCD_No` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `idx_resp_ncdno` (`NCD_No`),
  KEY `idx_resp_category` (`Category`),
  CONSTRAINT `responsibility_ncd_ibfk_1` FOREIGN KEY (`NCD_No`) REFERENCES `ncd` (`NCD_No`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `responsibility_ncd`
--

LOCK TABLES `responsibility_ncd` WRITE;
/*!40000 ALTER TABLE `responsibility_ncd` DISABLE KEYS */;
INSERT INTO `responsibility_ncd` VALUES (1,'A/B MAC','MAC A','20.16'),(3,'A/B MAC','HHH','20.31'),(4,'MAC','DME','20.31.1'),(5,'Shared-System Maintainers ','FISS','20.31.2'),(6,'Shared-System Maintainers ','MCS','20.31.3'),(7,'Shared-System Maintainers ','VMS','20.4'),(8,'Shared-System Maintainers ','CWF','20.9.1'),(9,'Others ','Others ','110.4'),(10,'A/B MAC','MAC B','20.16'),(12,'MAC','DME','20.31'),(13,'Shared-System Maintainers ','FISS','20.31.1'),(14,'Shared-System Maintainers ','MCS','20.31.2'),(15,'Shared-System Maintainers ','VMS','20.31.3'),(16,'Shared-System Maintainers ','CWF','20.4'),(17,'Others ','Others ','20.9.1'),(18,'A/B MAC','MAC A','110.4');
/*!40000 ALTER TABLE `responsibility_ncd` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `revision_history_ncd_cr`
--

DROP TABLE IF EXISTS `revision_history_ncd_cr`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `revision_history_ncd_cr` (
  `ID` int(11) NOT NULL,
  `NCD_No` varchar(20) DEFAULT NULL,
  `CR_No` varchar(20) DEFAULT NULL,
  `Revision_History_Details` text,
  PRIMARY KEY (`ID`),
  KEY `idx_revision_ncdno` (`NCD_No`),
  KEY `idx_revision_crno` (`CR_No`),
  CONSTRAINT `revision_history_ncd_cr_ibfk_1` FOREIGN KEY (`NCD_No`) REFERENCES `ncd` (`NCD_No`),
  CONSTRAINT `revision_history_ncd_cr_ibfk_2` FOREIGN KEY (`CR_No`) REFERENCES `transmittals_ncd` (`CR_No`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `revision_history_ncd_cr`
--

LOCK TABLES `revision_history_ncd_cr` WRITE;
/*!40000 ALTER TABLE `revision_history_ncd_cr` DISABLE KEYS */;
INSERT INTO `revision_history_ncd_cr` VALUES (1,'20.9.1','13390','\"CR13390: End date ICD-10 dx effective 9/30/2023: I24.8 and I47.1.\nAdd ICD-10 dx effective 10/1/2023: I24.81, I24.89, I47.10, I47.11, I47.19.\nRevise descriptor for ICD-10 dx I25.112 effective 10/1/23.\"'),(2,'20.9.1','12822','\"CR12822: End date ICD-10 dx effective 9/30/2022: I34.8, I47.2\nAdd ICD-10 dx effective 10/1/2022: I20.2, I25.112, I25.702, I25.712, I25.722, I25.732, I25.752, I25.762, I25.792, I34.81, I34.89, I47.20, I47.21, I47.29.\"'),(3,'20.31','13390','\"CR13390: End date ICD-10 dx I20.8 effective 9/30/2023. \nAdd ICD-10 dx I20.81, I20.89 effective 10/1/2023. \nRevise descriptor for ICD-10 dx I25.112 effective 10/1/2023. \nDelete ICD-10 dx I25.702 effective 9/30/2023.\"'),(4,'20.31','12822','\"CR12822: Add ICD-10 dx effective 10/1/2022:  I20.2, I25.112, I25.702, I25.712, I25.722, I25.732, I25.752, I25.762, I25.792. MCS 035L, FISS 59124/59125.\nFor CORE combination requirement re-sequenced RARC in rows 9, 12, 14, 15, 20, 21. Deleted RARC N386.\"'),(5,'20.31.1','13390','\"CR13390: End date ICD-10 dx I20.8 effective 9/30/2023. \nAdd ICD-10 dx I20.81, I20.89 effective 10/1/2023. \nRevise descriptor for ICD-10 dx I25.112 effective 10/1/2023. \nDelete ICD-10 dx I25.702 effective 9/30/2023. \nReformat Rule Description tab to align.\"'),(6,'20.31.1','12822','\"CR12822: Add ICD-10 dx effective 10/1/2022:  I20.2, I25.112, I25.702, I25.712, I25.722, I25.732, I25.752, I25.762, I25.792. MCS 035L, FISS 59124/59125.\nFor CORE combination requirement re-sequenced RARC in rows 9, 12, 14, 15, 20, 21.\"'),(7,'20.31.2','13390','\"CR13390: End date ICD-10 dx I20.8 effective 9/30/2023. \nAdd ICD-10 dx I20.81, I20.89 effective 10/1/2023. \nRevise descriptor for ICD-10 dx I25.112 effective 10/1/2023. \nDelete ICD-10 dx I25.702 effective 9/30/2023.\"'),(8,'20.31.2','12822','\"CR12822: Add ICD-10 dx effective 10/1/2022:  I20.2, I25.112, I25.702, I25.712, I25.722, I25.732, I25.752, I25.762, I25.792. MCS 035L, FISS 59124/59125.\nFor CORE combination requirement re-sequenced RARC in rows 9, 12, 14, 15, 20, 21.\"'),(9,'20.31.3','13390','\"CR13390: End date ICD-10 dx I20.8 effective 9/30/2023. \nAdd ICD-10 dx I20.81, I20.89 effective 10/1/2023. \nRevise descriptor for ICD-10 dx I25.112 effective 10/1/2023. \nDelete ICD-10 dx I25.702 effective 9/30/2023.\"'),(10,'20.31.3','12822','\"CR12822: Add ICD-10 dx effective 10/1/2022:  I20.2, I25.112, I25.702, I25.712, I25.722, I25.732, I25.752, I25.762, I25.792. MCS 035L, FISS 59124/59125.\nFor CORE combination requirement re-sequenced RARC in rows 9, 12, 14, 15, 20, 21.\"'),(11,'110.4','13390','CR13390: Add ICD-10 dx J44.81 effective 10/1/2023.'),(20,'150.10','13070','\"CR13070: Delete CPT code 0163T effective 12/31/2022. \nAdd CPT code 22860 effective 1/1/2023. \nRemove ICD-9 procedure related columns.\"'),(21,'20.4','13390','\"CR13390: End date ICD-10 dx I47.1 from Group 2 effective 9/30/2023. \nAdd ICD-10 dx I47.10, I47.11, I47.19 to Group 2 effective 10/1/2023. \nAdd ICD-10 PCS 0WHC0GZ, 0WHC3GZ, 0WHC4GZ, 0WPC0GZ, 0WPC3GZ, 0WPC4GZ, 0WPCXGZ, 0WWC0GZ, 0WWC3GZ, 0WWC4GZ, 0WWCXGZ .\"'),(22,'20.4','13070','\"CR13070: Add 4 HCPCS codes C7537, C7538, C7539, C7540 as payable under Group 2 only in the ASC setting, effective 1/1/23. (MCS 118L)\nAdd -Q0 modifier to rows C7 and C14 for Category B IDE trials retroactive to 2/15/2018 policy erroneously omitted.\"'),(23,'20.16','10318','\"CR13390: Effective 10/1/2023, add ICD-10 dx I1A.0 to the discretionary list for Drug-Resistant Hypertension. FISS 59120/59121. \"'),(24,'20.16','10318','CR10318: End-date ICD-10 dx I27.2 effective 9/30/17.'),(25,'20.20','13390','\"CR13390: Effective 10/1/2023, revise descriptor for ICD-10 dx I25.112.\"'),(26,'20.20','13070','\"CR13070: For E&M Service codes in C9 and C14: End-date 99217, 99218, 99219, 99220, & 99241 effective 12/31/2022. \nDescriptor changes for 99242, 99243, 99244, & 99245 effective 1/1/2023.\"'),(27,'20.20','12822','\"CR12822: Add ICD-10 dx: I25.112, I25.702, I25.712, I25.722, I25.732, I25.752, I25.762, I25.792 effective 10/1/2022. MCS 020L. FISS RC 59083/59084.\"');
/*!40000 ALTER TABLE `revision_history_ncd_cr` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rule_desc_ncd`
--

DROP TABLE IF EXISTS `rule_desc_ncd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rule_desc_ncd` (
  `ID` int(11) NOT NULL,
  `Responsibility` varchar(50) DEFAULT NULL,
  `Rule_Description` text,
  `Frequency` varchar(100) DEFAULT NULL,
  `NCD_No` varchar(20) DEFAULT NULL,
  `Reference_BR` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `idx_rule_ncdno` (`NCD_No`),
  KEY `idx_rule_resp` (`Responsibility`),
  CONSTRAINT `rule_desc_ncd_ibfk_1` FOREIGN KEY (`NCD_No`) REFERENCES `ncd` (`NCD_No`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rule_desc_ncd`
--

LOCK TABLES `rule_desc_ncd` WRITE;
/*!40000 ALTER TABLE `rule_desc_ncd` DISABLE KEYS */;
INSERT INTO `rule_desc_ncd` VALUES (1,'Part A','\"Effective DOS 2/15/18, coverage policy is no longer contingent on participation in a trial/study/registry. Therefore, claims with DOS on an after 2/15/18, no longer require trial related coding unless they are associated with a Category B IDE trial, in which case ICD-10 dx Z00.6 must be appended to the claim.\"','twice in one year','20.4','13070.1'),(2,'Part B','\"Effective DOS 2/15/18, coverage policy is no longer contingent on participation in a trial/study/registry. Therefore, claims with DOS on an after 2/15/18, no longer require trialrelated coding unless they are associated with a Category B IDE trial, in which case ICD-10 dx Z00.6 must be appended to the claim.\"','twice in one year','20.4','13070.2'),(3,'MAC A','\"A/MACs: Effective DOS 12/1/20, VADs was reconsidered. CMS updated coverage criteria for tx of advanced heart failure. Therapeutic intent was removed. Patient selection criteria was revised. Facility criteria remains unchanged. No changes to claims processing edits.\"','Once in a life time','20.9.1','13390.1'),(4,'MAC B','\"B/MACs: Effective DOS 12/1/20, VADs was reconsidered. CMS updated coverage criteria for tx of advanced heart failure. Therapeutic intent was removed. Patient selection criteria was revised. Facility criteria remains unchanged. No changes to claims processing edits.\"','Once in a life time','20.9.1','13390.2'),(5,'MAC A','\"A/MACs & FISS: Effective 7/1/99, TEB is covered for the \"\"\"\"noninvasive diagnosis or monitoring of hemodynamics in patients with suspected or known cardiovascular disease. A/MACs: Effective 1/23/04, CMS concluded that this use was neither sufficiently defined nor supported by available clinical literature to offer the guidance necessary for practitioners to determine when TEB would be covered for patient management and gave MACs discretion to determine whether the use of TEB for the management of drug-resistant hypertension is R&N. Effective 11/24/06, CMS continues current Medicare policy for TEB.\"','4 times in 1 year','20.16','13390.3'),(6,'FISS','\"A/MACs & FISS: Effective 7/1/99, TEB is covered for the \"\"\"\"noninvasive diagnosis or monitoring of hemodynamics in patients with suspected or known cardiovascular disease. A/MACs: Effective 1/23/04, CMS concluded that this use was neither sufficiently defined nor supported by available clinical literature to offer the guidance necessary for practitioners to determine when TEB would be covered for patient management and gave MACs discretion to determine whether the use of TEB for the management of drug-resistant hypertension is R&N. Effective 11/24/06, CMS continues current Medicare policy for TEB.\"','4 times in 1 year','20.16','13390.4'),(7,'MAC B','\"B/MACs & MCS: Effective 7/1/99, TEB is covered for the \"\"\"\"noninvasive diagnosis or monitoring of hemodynamics in patients with suspected or known cardiovascular disease. MCS edit 033L. B/MACs: Effective 1/23/04, CMS concluded that this use was neither sufficiently defined nor supported by available clinical literature to offer the guidance necessary for practitioners to determine when TEB would be covered for patient management and gave MACs discretion to determine whether the use of TEB for the management of drug-resistant hypertension is R&N. Effective 11/24/06, CMS continues current Medicare policy for TEB.\"','4 times in 1 year','20.16','13390.5'),(8,'MCS','\"B/MACs & MCS: Effective 7/1/99, TEB is covered for the \"\"\"\"noninvasive diagnosis or monitoring of hemodynamics in patients with suspected or known cardiovascular disease. MCS edit 033L. B/MACs: Effective 1/23/04, CMS concluded that this use was neither sufficiently defined nor supported by available clinical literature to offer the guidance necessary for practitioners to determine when TEB would be covered for patient management and gave MACs discretion to determine whether the use of TEB for the management of drug-resistant hypertension is R&N. Effective 11/24/06, CMS continues current Medicare policy for TEB.\"','','20.16','13390.6'),(9,'MAC A','\"A/MACs: Effective 7/1/99, coverage is provided for the use of ECP for patients diagnosed with disabling angina (Class III or Class IV, Canadian Cardiovascular Society Classification or equivalent classification) who, in the opinion of a cardiologist or cardiothoracic surgeon, are not readily amenable to surgical intervention, such as PTCA or cardiac bypass. A full course of therapy usually consists of 35 1-hour treatments, which may be offered once or twice daily, usually 5 days per week.\"','n/a','20.20','13390.7'),(10,'MAC A','\"A/MACs: Codes for external cardiac assist, ECG rhythm strip and report, pulse oximetry and plethysmography or other monitoring tests for examining the effects of this treatment are not clinically necessary with this service and should not be paid on the same DOS, unless they occur in a clinical setting not connected with the delivery of the ECP.  Use appropriate modifier.\"','n/a','20.20','13390.8'),(11,'MAC B','\"B/MACs & MCS: Effective 7/1/99, coverage is provided for the use of ECP for patients diagnosed with disabling angina (Class III or Class IV, Canadian Cardiovascular Society Classification or equivalent classification) who, in the opinion of a cardiologist or cardiothoracic surgeon, are not readily amenable to surgical intervention, such as PTCA or cardiac bypass. A full course of therapy usually consists of 35 1-hour treatments, which may be offered once or twice daily, usually 5 days per week. MCS audit 020L.\"','n/a','20.20','13390.9'),(12,'MCS','\"B/MACs & MCS: Effective 7/1/99, coverage is provided for the use of ECP for patients diagnosed with disabling angina (Class III or Class IV, Canadian Cardiovascular Society Classification or equivalent classification) who, in the opinion of a cardiologist or cardiothoracic surgeon, are not readily amenable to surgical intervention, such as PTCA or cardiac bypass. A full course of therapy usually consists of 35 1-hour treatments, which may be offered once or twice daily, usually 5 days per week. MCS audit 020L.\"','n/a','20.20','13391'),(13,'MAC B','\"B/MACs & MCS: Codes for external cardiac assist, ECG rhythm strip and report, pulse oximetry and plethysmography or other monitoring tests for examining the effects of this treatment are not clinically necessary with this service and should not be paid on the same DOS, unless they occur in a clinical setting not connected with the delivery of the ECP.  Use appropriate modifier. MCS audit 234A.\"','n/a','20.20','13391.1'),(14,'MCS','\"B/MACs & MCS: Codes for external cardiac assist, ECG rhythm strip and report, pulse oximetry and plethysmography or other monitoring tests for examining the effects of this treatment are not clinically necessary with this service and should not be paid on the same DOS, unless they occur in a clinical setting not connected with the delivery of the ECP.  Use appropriate modifier. MCS audit 234A.\"','n/a','20.20','13391.2'),(15,'MAC A','\"Effective 1/1/10, Medicare Part B covers ICR program services for beneficiaries who have experienced one or more of the following:   \n- An acute myocardial infarction within the preceding 12 months;\n- A coronary artery bypass surgery;\n- Current stable angina pectoris;\n- Heart valve repair or replacement;\n- Percutaneous transluminal coronary angioplasty or coronary stenting;\n- A heart or heart-lung transplant.\nEffective 2/9/18, section 51004 of BBA 2018, Pub. L. 115-123 (2018), amended section 1861(eee)(4)(B) of the Social Security Act to expand coverage in an ICR to the following additional conditions: \n- Stable, chronic heart failure defined as patients with left ventricular ejection fraction of 35% or less and New York Heart Association (NYHA) Class II to IV symptoms despite being on optimal heart failure therapy for at least 6 weeks.\"\"\"','1 times every 3 months','20.31','13391.3'),(16,'MAC A','\"Effective 1/1/10, Medicare Part B covers ICR program services for beneficiaries who have experienced one or more of the following:   \n- An acute myocardial infarction within the preceding 12 months;\n- A coronary artery bypass surgery;\n- Current stable angina pectoris;\n- Heart valve repair or replacement;\n- Percutaneous transluminal coronary angioplasty or coronary stenting;\n- A heart or heart-lung transplant.\nEffective 2/9/18, section 51004 of BBA 2018, Pub. L. 115-123 (2018), amended section 1861(eee)(4)(B) of the Social Security Act to expand coverage in an ICR to the following additional conditions: \n- Stable, chronic heart failure defined as patients with left ventricular ejection fraction of 35% or less and New York Heart Association (NYHA) Class II to IV symptoms despite being on optimal heart failure therapy for at least 6 weeks.\"\"\"','1 times every 3 months','20.31.1','13391.4'),(17,'MAC A','\"\"\"Effective 1/1/10, Medicare Part B covers ICR program services for beneficiaries who have experienced one or more of the following:   \n- An acute myocardial infarction within the preceding 12 months;\n- A coronary artery bypass surgery;\n- Current stable angina pectoris;\n- Heart valve repair or replacement;\n- Percutaneous transluminal coronary angioplasty or coronary stenting;\n- A heart or heart-lung transplant.\nEffective 2/9/18, section 51004 of BBA 2018, Pub. L. 115-123 (2018), amended section 1861(eee)(4)(B) of the Social Security Act to expand coverage in an ICR to the following additional conditions: \n- Stable, chronic heart failure defined as patients with left ventricular ejection fraction of 35% or less and New York Heart Association (NYHA) Class II to IV symptoms despite being on optimal heart failure therapy for at least 6 weeks.\"','1 times every 3 months','20.31.2','13391.5'),(18,'MAC A','\"Effective 1/1/10, Medicare Part B covers ICR program services for beneficiaries who have experienced one or more of the following:   \n- An acute myocardial infarction within the preceding 12 months;\n- A coronary artery bypass surgery;\n- Current stable angina pectoris;\n- Heart valve repair or replacement;\n- Percutaneous transluminal coronary angioplasty or coronary stenting;\n- A heart or heart-lung transplant.\nEffective 2/9/18, section 51004 of BBA 2018, Pub. L. 115-123 (2018), amended section 1861(eee)(4)(B) of the Social Security Act to expand coverage in an ICR to the following additional conditions: \n- Stable, chronic heart failure defined as patients with left ventricular ejection fraction of 35% or less and New York Heart Association (NYHA) Class II to IV symptoms despite being on optimal heart failure therapy for at least 6 weeks.\"','1 times every 3 months','20.31.3','13391.6'),(19,'MAC B','\"Under § 410.49(b), Effective 1/1/10, Medicare Part B covers ICR program services for beneficiaries who have experienced one or more of the following:   \n- An acute myocardial infarction within the preceding 12 months;\n- A coronary artery bypass surgery;\n- Current stable angina pectoris;\n- Heart valve repair or replacement;\n- Percutaneous transluminal coronary angioplasty or coronary stenting;\n- A heart or heart-lung transplant.\nEffective 2/9/18, section 51004 of BBA 2018, Pub. L. 115-123 (2018), amended section 1861(eee)(4)(B) of the Social Security Act to expand coverage in an ICR to the following additional conditions: \n- Stable, chronic heart failure defined as patients with left ventricular ejection fraction of 35% or less and New York Heart Association (NYHA) Class II to IV symptoms despite being on optimal heart failure therapy for at least 6 weeks.\"','1 times every 3 months','20.31','13391.7'),(20,'MAC B','\"Under § 410.49(b), Effective 1/1/10, Medicare Part B covers ICR program services for beneficiaries who have experienced one or more of the following:   \n- An acute myocardial infarction within the preceding 12 months;\n- A coronary artery bypass surgery;\n- Current stable angina pectoris;\n- Heart valve repair or replacement;\n- Percutaneous transluminal coronary angioplasty or coronary stenting;\n- A heart or heart-lung transplant.\nEffective 2/9/18, section 51004 of BBA 2018, Pub. L. 115-123 (2018), amended section 1861(eee)(4)(B) of the Social Security Act to expand coverage in an ICR to the following additional conditions: \n- Stable, chronic heart failure defined as patients with left ventricular ejection fraction of 35% or less and New York Heart Association (NYHA) Class II to IV symptoms despite being on optimal heart failure therapy for at least 6 weeks.\"','1 times every 3 months','20.31.1','13391.8'),(21,'MAC B','\"Under § 410.49(b), Effective 1/1/10, Medicare Part B covers ICR program services for beneficiaries who have experienced one or more of the following:   \n- An acute myocardial infarction within the preceding 12 months;\n- A coronary artery bypass surgery;\n- Current stable angina pectoris;\n- Heart valve repair or replacement;\n- Percutaneous transluminal coronary angioplasty or coronary stenting;\n- A heart or heart-lung transplant.\nEffective 2/9/18, section 51004 of BBA 2018, Pub. L. 115-123 (2018), amended section 1861(eee)(4)(B) of the Social Security Act to expand coverage in an ICR to the following additional conditions: \n- Stable, chronic heart failure defined as patients with left ventricular ejection fraction of 35% or less and New York Heart Association (NYHA) Class II to IV symptoms despite being on optimal heart failure therapy for at least 6 weeks.\"','1 times every 3 months','20.31.2','13391.9'),(22,'MAC B','\"Under § 410.49(b), Effective 1/1/10, Medicare Part B covers ICR program services for beneficiaries who have experienced one or more of the following:   \n- An acute myocardial infarction within the preceding 12 months;\n- A coronary artery bypass surgery;\n- Current stable angina pectoris;\n- Heart valve repair or replacement;\n- Percutaneous transluminal coronary angioplasty or coronary stenting;\n- A heart or heart-lung transplant.\nEffective 2/9/18, section 51004 of BBA 2018, Pub. L. 115-123 (2018), amended section 1861(eee)(4)(B) of the Social Security Act to expand coverage in an ICR to the following additional conditions: \n- Stable, chronic heart failure defined as patients with left ventricular ejection fraction of 35% or less and New York Heart Association (NYHA) Class II to IV symptoms despite being on optimal heart failure therapy for at least 6 weeks.\"','1 times every 3 months','20.31.3','13392'),(23,'FISS','\"FISS & A/MACs: Shall accept CPT 36522 along with dx for CTCL. Formerly, Medicare only covered extracorporeal photopheresis when used in palliative treatment of skin manifestations of cutaneous T-cell lymphoma not responding to other therapy. (See CR5464/TR1206).\"','n/a','110.4','13392.1'),(24,'MAC A','\"FISS & A/MACs: Shall accept CPT 36522 along with dx for CTCL. Formerly, Medicare only covered extracorporeal photopheresis when used in palliative treatment of skin manifestations of cutaneous T-cell lymphoma not responding to other therapy. (See CR5464/TR1206).\"','n/a','110.4','13392.2'),(25,'MAC B','\"MCS & B/MACs: Shall accept CPT 36522 along with dx for CTCL. Formerly, Medicare only covered extracorporeal photopheresis when used in palliative tx of skin manifestations of cutaneous T-cell lymphoma not responding to other therapy. (CR5464/TR1206, CR7818).\"','n/a','110.4','13392.3'),(26,'MCS','\"MCS & B/MACs: Shall accept CPT 36522 along with dx for CTCL. Formerly, Medicare only covered extracorporeal photopheresis when used in palliative tx of skin manifestations of cutaneous T-cell lymphoma not responding to other therapy. (CR5464/TR1206, CR7818).\"','n/a','110.4','13392.4'),(27,'CWF','\"LADR is non-covered for Medicare beneficiaries over 60 years of age. For Medicare beneficiaries 60 years of age and younger, there is no national coverage determination for LADR, leaving such determinations to continue to be made by the local contractors. \nContractors shall deny claims submitted with ICD-10-PCS codes 0SR20JZ, or 0SR40JZ for Medicare beneficiaries over 60 years of age.\"','n/a','150.10','13392.5'),(28,'CWF','\"LADR is non-covered for Medicare beneficiaries over 60 years of age. For Medicare beneficiaries 60 years of age and younger, there is no national coverage determination for LADR, leaving such determinations to continue to be made by the local contractors. \nContractors shall deny claims submitted with LADR services for Medicare beneficiaries over 60 years of age, (i.e. on or after a beneficiary’s 61st birthday).\"','n/a','150.10','13392.6');
/*!40000 ALTER TABLE `rule_desc_ncd` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tob_ncd`
--

DROP TABLE IF EXISTS `tob_ncd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tob_ncd` (
  `ID` int(11) NOT NULL,
  `Type_of_Bill` varchar(10) DEFAULT NULL,
  `Facility_Type` varchar(255) DEFAULT NULL,
  `NCD_No` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `idx_tob_ncdno` (`NCD_No`),
  KEY `idx_type_of_bill` (`Type_of_Bill`),
  CONSTRAINT `tob_ncd_ibfk_1` FOREIGN KEY (`NCD_No`) REFERENCES `ncd` (`NCD_No`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tob_ncd`
--

LOCK TABLES `tob_ncd` WRITE;
/*!40000 ALTER TABLE `tob_ncd` DISABLE KEYS */;
INSERT INTO `tob_ncd` VALUES (1,'011X','Hospital Inpatient (Including Medicare Part A)','20.16'),(3,'013X','Hospital Outpatient','20.31'),(4,'014X','Hospital - Laboratory Services Provided to Non-Patients','20.31.1'),(5,'018X','Hospital - Swing Beds','20.31.2'),(6,'021X','Skilled Nursing - Inpatient (Including Medicare Part A)','20.31.3'),(7,'022X','Skilled Nursing - Inpatient (Medicare Part B Only)','20.4'),(8,'023X','Skilled Nursing - Outpatient','20.9.1'),(9,'028X','Skilled Nursing - Swing Beds','110.4'),(11,'034X','Home Health Services Not Under A Plan of Treatment (Effective 10/1/13)','20.16'),(13,'043X','Religious Non-Medical Health Care Institutions - Outpatient Services','20.31'),(14,'071X','Clinic - Rural Health (RHC)','20.31.1'),(15,'072X','Clinic - Hospital Based or Independent Renal Dialysis Center (ESRD)','20.31.2'),(16,'074X','Clinic - Outpatient Rehabilitation Facility (ORF)','20.31.3'),(17,'075X','Clinic - Comprehensive Outpatient Rehabilitation Facility (CORF)','20.4'),(18,'076X','Clinic - Community Mental Health Center (CMHC)','20.9.1'),(19,'077X','Clinic - Federally Qualified Health Center (FQHC)','110.4'),(21,'082X','Hospice (Hospital Based)','110.4');
/*!40000 ALTER TABLE `tob_ncd` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transmittals_ncd`
--

DROP TABLE IF EXISTS `transmittals_ncd`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transmittals_ncd` (
  `ID` int(11) NOT NULL,
  `Transmittal_Link` text,
  `Issue_Date` date DEFAULT NULL,
  `Rescinded_DateIfAny` date DEFAULT NULL,
  `Subject` text,
  `CR_No` varchar(20) DEFAULT NULL,
  `NCD_No` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `idx_cr_no` (`CR_No`),
  KEY `idx_transmittals_ncdno` (`NCD_No`),
  CONSTRAINT `transmittals_ncd_ibfk_1` FOREIGN KEY (`NCD_No`) REFERENCES `ncd` (`NCD_No`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transmittals_ncd`
--

LOCK TABLES `transmittals_ncd` WRITE;
/*!40000 ALTER TABLE `transmittals_ncd` DISABLE KEYS */;
INSERT INTO `transmittals_ncd` VALUES (1,'https://www.cms.gov/medicare/regulations-guidance/transmittals/2024-transmittals/r12441otn ','2024-01-03',NULL,'International Classification of Diseases, 10th Revision (ICD-10) and Other Coding Revisions to National Coverage Determinations (NCDs)--April 2024 Update--CR 1 of 2 [Rescinds and replaces Transmittal 12318 issued October 19, 2023]','13390','110.4'),(2,'https://www.cms.gov/medicare/regulations-guidance/transmittals/2024-transmittals/r12441otn ','2024-01-03',NULL,'International Classification of Diseases, 10th Revision (ICD-10) and Other Coding Revisions to National Coverage Determinations (NCDs)--April 2024 Update--CR 1 of 2 [Rescinds and replaces Transmittal 12318 issued October 19, 2023]','13390','20.16'),(4,'https://www.cms.gov/medicare/regulations-guidance/transmittals/2024-transmittals/r12441otn ','2024-01-03',NULL,'International Classification of Diseases, 10th Revision (ICD-10) and Other Coding Revisions to National Coverage Determinations (NCDs)--April 2024 Update--CR 1 of 2 [Rescinds and replaces Transmittal 12318 issued October 19, 2023]','13390','20.31'),(5,'https://www.cms.gov/medicare/regulations-guidance/transmittals/2024-transmittals/r12441otn ','2024-01-03',NULL,'International Classification of Diseases, 10th Revision (ICD-10) and Other Coding Revisions to National Coverage Determinations (NCDs)--April 2024 Update--CR 1 of 2 [Rescinds and replaces Transmittal 12318 issued October 19, 2023]','13390','20.31.1'),(6,'https://www.cms.gov/medicare/regulations-guidance/transmittals/2024-transmittals/r12441otn ','2024-01-03',NULL,'International Classification of Diseases, 10th Revision (ICD-10) and Other Coding Revisions to National Coverage Determinations (NCDs)--April 2024 Update--CR 1 of 2 [Rescinds and replaces Transmittal 12318 issued October 19, 2023]','13390','20.31.2'),(7,'https://www.cms.gov/medicare/regulations-guidance/transmittals/2024-transmittals/r12441otn ','2024-01-03',NULL,'International Classification of Diseases, 10th Revision (ICD-10) and Other Coding Revisions to National Coverage Determinations (NCDs)--April 2024 Update--CR 1 of 2 [Rescinds and replaces Transmittal 12318 issued October 19, 2023]','13390','20.31.3'),(8,'https://www.cms.gov/medicare/regulations-guidance/transmittals/2024-transmittals/r12441otn ','2024-01-03',NULL,'International Classification of Diseases, 10th Revision (ICD-10) and Other Coding Revisions to National Coverage Determinations (NCDs)--April 2024 Update--CR 1 of 2 [Rescinds and replaces Transmittal 12318 issued October 19, 2023]','13390','20.4'),(9,'https://www.cms.gov/medicare/regulations-guidance/transmittals/2024-transmittals/r12441otn ','2024-01-03',NULL,'International Classification of Diseases, 10th Revision (ICD-10) and Other Coding Revisions to National Coverage Determinations (NCDs)--April 2024 Update--CR 1 of 2 [Rescinds and replaces Transmittal 12318 issued October 19, 2023]','13390','20.9.1'),(12,'https://www.cms.gov/Regulations-and-Guidance/Guidance/Transmittals/Transmittals/r11952otn ','2023-04-12',NULL,'International Classification of Diseases, 10th Revision (ICD-10) and Other Coding Revisions to National Coverage Determinations (NCDs)--July 2023 Update [Rescinds and replaces Transmittal 11884 issued March 01, 2023, and Transmittal 11832 issued February 02, 2023]','13070','20.4'),(13,'https://www.cms.gov/Regulations-and-Guidance/Guidance/Transmittals/Transmittals/r11584otn','2022-10-05',NULL,'International Classification of Diseases, 10th Revision (ICD-10) and Other Coding Revisions to National Coverage Determination (NCDs)--January 2023 Update [Rescinds and replaces Transmittal 11545 dated August 5, 2022]','12822','20.31'),(14,'https://www.cms.gov/Regulations-and-Guidance/Guidance/Transmittals/Transmittals/r11584otn','2022-10-05',NULL,'International Classification of Diseases, 10th Revision (ICD-10) and Other Coding Revisions to National Coverage Determination (NCDs)--January 2023 Update [Rescinds and replaces Transmittal 11545 dated August 5, 2022]','12822','20.31.1'),(15,'https://www.cms.gov/Regulations-and-Guidance/Guidance/Transmittals/Transmittals/r11584otn','2022-10-05',NULL,'International Classification of Diseases, 10th Revision (ICD-10) and Other Coding Revisions to National Coverage Determination (NCDs)--January 2023 Update [Rescinds and replaces Transmittal 11545 dated August 5, 2022]','12822','20.31.2'),(16,'https://www.cms.gov/Regulations-and-Guidance/Guidance/Transmittals/Transmittals/r11584otn','2022-10-05',NULL,'International Classification of Diseases, 10th Revision (ICD-10) and Other Coding Revisions to National Coverage Determination (NCDs)--January 2023 Update [Rescinds and replaces Transmittal 11545 dated August 5, 2022]','12822','20.31.3'),(17,'https://www.cms.gov/Regulations-and-Guidance/Guidance/Transmittals/Transmittals/r11584otn','2022-10-05',NULL,'International Classification of Diseases, 10th Revision (ICD-10) and Other Coding Revisions to National Coverage Determination (NCDs)--January 2023 Update [Rescinds and replaces Transmittal 11545 dated August 5, 2022]','12822','20.9.1'),(20,'https://www.cms.gov/Regulations-and-Guidance/Guidance/Transmittals/Transmittals/r11884otn ','2023-03-01',NULL,'International Classification of Diseases, 10th Revision (ICD-10) and Other Coding Revisions to National Coverage Determinations (NCDs)--July 2023 Update [Rescinds and replaces Transmittal 11832 issued February 02, 2023]','13070','20.4'),(21,'https://www.cms.gov/Regulations-and-Guidance/Guidance/Transmittals/2018-Transmittals-Items/R2005OTN ','2018-01-18',NULL,'ICD-10 and Other Coding Revisions to National Coverage Determinations (NCDs)','10318','20.16');
/*!40000 ALTER TABLE `transmittals_ncd` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `transmittals_ncd_short_view`
--

DROP TABLE IF EXISTS `transmittals_ncd_short_view`;
/*!50001 DROP VIEW IF EXISTS `transmittals_ncd_short_view`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE VIEW `transmittals_ncd_short_view` AS SELECT 
 1 AS `ID`,
 1 AS `Transmittal_Link`,
 1 AS `Issue_Date`,
 1 AS `Rescinded_DateIfAny`,
 1 AS `Short_Subject`,
 1 AS `CR_No`,
 1 AS `NCD_No`*/;
SET character_set_client = @saved_cs_client;

--
-- Final view structure for view `carc_rarc_ncd_view`
--

/*!50001 DROP VIEW IF EXISTS `carc_rarc_ncd_view`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = cp850 */;
/*!50001 SET character_set_results     = cp850 */;
/*!50001 SET collation_connection      = cp850_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `carc_rarc_ncd_view` AS select `carc_rarc_ncd`.`ID` AS `ID`,`carc_rarc_ncd`.`CARC` AS `CARC`,substr(`carc_rarc_ncd`.`CARC_Description`,1,50) AS `CARC_Description_Shortened`,`carc_rarc_ncd`.`RARC` AS `RARC`,substr(`carc_rarc_ncd`.`RARC_Description`,1,50) AS `RARC_Description_Shortened`,`carc_rarc_ncd`.`ASC_X12_CAGC` AS `ASC_X12_CAGC`,`carc_rarc_ncd`.`CORE_Business_Scenario` AS `CORE_Business_Scenario`,`carc_rarc_ncd`.`NCD_No` AS `NCD_No`,`carc_rarc_ncd`.`CARC_plus_RARC` AS `CARC_plus_RARC` from `carc_rarc_ncd` */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `cpt_ncd_short_view`
--

/*!50001 DROP VIEW IF EXISTS `cpt_ncd_short_view`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = cp850 */;
/*!50001 SET character_set_results     = cp850 */;
/*!50001 SET collation_connection      = cp850_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `cpt_ncd_short_view` AS select `cpt_ncd`.`ID` AS `ID`,`cpt_ncd`.`CPT_HCPCS_Code` AS `CPT_HCPCS_Code`,left(`cpt_ncd`.`CPT_HCPCS_Description`,75) AS `CPT_HCPCS_Description`,`cpt_ncd`.`Eff_Date` AS `Eff_Date`,`cpt_ncd`.`Trmn_Date` AS `Trmn_Date`,`cpt_ncd`.`NCD_No` AS `NCD_No` from `cpt_ncd` */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `icd10pcs_ncd_short_view`
--

/*!50001 DROP VIEW IF EXISTS `icd10pcs_ncd_short_view`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = cp850 */;
/*!50001 SET character_set_results     = cp850 */;
/*!50001 SET collation_connection      = cp850_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `icd10pcs_ncd_short_view` AS select `icd10pcs_ncd`.`ID` AS `ID`,`icd10pcs_ncd`.`ICD10_PCS` AS `ICD10_PCS`,left(`icd10pcs_ncd`.`ICD10PCS_Desc`,75) AS `ICD10PCS_Desc_Short`,`icd10pcs_ncd`.`Effective_Date` AS `Effective_Date`,`icd10pcs_ncd`.`Trmn_Date` AS `Trmn_Date`,`icd10pcs_ncd`.`NCD_No` AS `NCD_No` from `icd10pcs_ncd` */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `ncd_full_info`
--

/*!50001 DROP VIEW IF EXISTS `ncd_full_info`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = cp850 */;
/*!50001 SET character_set_results     = cp850 */;
/*!50001 SET collation_connection      = cp850_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `ncd_full_info` AS select `n`.`NCD_No` AS `NCD_No`,`n`.`NCD_Title` AS `NCD_Title`,`n`.`IOM_Link` AS `IOM_Link`,`n`.`NCD_Link` AS `NCD_Link`,`c`.`CPT_HCPCS_Code` AS `CPT_HCPCS_Code`,`c`.`CPT_HCPCS_Description` AS `CPT_HCPCS_Description`,`ic`.`ICD10CM_Code` AS `ICD10CM_Code`,`ic`.`ICD10CM_Description` AS `ICD10CM_Description`,`ip`.`ICD10_PCS` AS `ICD10_PCS`,`ip`.`ICD10PCS_Desc` AS `ICD10PCS_Desc`,`t`.`CR_No` AS `CR_No`,`r`.`Revision_History_Details` AS `Revision_History_Details`,`carc`.`CARC_plus_RARC` AS `CARC_plus_RARC`,`tob`.`Type_of_Bill` AS `Type_of_Bill`,`m`.`Modifier` AS `Modifier`,`resp`.`Responsibility` AS `Responsibility`,`rule`.`Rule_Description` AS `Rule_Description` from ((((((((((`ncd` `n` left join `cpt_ncd` `c` on((`n`.`NCD_No` = `c`.`NCD_No`))) left join `icd10cm_ncd` `ic` on((`n`.`NCD_No` = `ic`.`NCD_No`))) left join `icd10pcs_ncd` `ip` on((`n`.`NCD_No` = `ip`.`NCD_No`))) left join `transmittals_ncd` `t` on((`n`.`NCD_No` = `t`.`NCD_No`))) left join `revision_history_ncd_cr` `r` on((`n`.`NCD_No` = `r`.`NCD_No`))) left join `carc_rarc_ncd` `carc` on((`n`.`NCD_No` = `carc`.`NCD_No`))) left join `tob_ncd` `tob` on((`n`.`NCD_No` = `tob`.`NCD_No`))) left join `modifier_ncd` `m` on((`n`.`NCD_No` = `m`.`NCD_No`))) left join `responsibility_ncd` `resp` on((`n`.`NCD_No` = `resp`.`NCD_No`))) left join `rule_desc_ncd` `rule` on((`n`.`NCD_No` = `rule`.`NCD_No`))) */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `transmittals_ncd_short_view`
--

/*!50001 DROP VIEW IF EXISTS `transmittals_ncd_short_view`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = cp850 */;
/*!50001 SET character_set_results     = cp850 */;
/*!50001 SET collation_connection      = cp850_general_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `transmittals_ncd_short_view` AS select `transmittals_ncd`.`ID` AS `ID`,`transmittals_ncd`.`Transmittal_Link` AS `Transmittal_Link`,`transmittals_ncd`.`Issue_Date` AS `Issue_Date`,`transmittals_ncd`.`Rescinded_DateIfAny` AS `Rescinded_DateIfAny`,left(`transmittals_ncd`.`Subject`,150) AS `Short_Subject`,`transmittals_ncd`.`CR_No` AS `CR_No`,`transmittals_ncd`.`NCD_No` AS `NCD_No` from `transmittals_ncd` */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-05-24 17:10:58