-- MySQL dump 10.13  Distrib 8.0.38, for Win64 (x86_64)
--
-- Host: 192.168.45.64    Database: db_iemr
-- ------------------------------------------------------
-- Server version	8.0.34

/*!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 */;
/*!50503 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 `m_incentive_activity`
--

DROP TABLE IF EXISTS `m_incentive_activity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `m_incentive_activity` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `created_by` varchar(255) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `activity_description` varchar(255) DEFAULT NULL,
  `district_code` int DEFAULT NULL,
  `group_name` varchar(255) DEFAULT NULL,
  `is_deleted` bit(1) DEFAULT NULL,
  `activity_name` varchar(255) DEFAULT NULL,
  `payment_parameter` varchar(255) DEFAULT NULL,
  `rate_per_activity` int DEFAULT NULL,
  `state_code` int DEFAULT NULL,
  `updated_by` varchar(255) DEFAULT NULL,
  `updated_date` datetime DEFAULT NULL,
  `fmr_code` varchar(255) DEFAULT NULL,
  `fmr_code_old` varchar(255) DEFAULT NULL,
  `location` varchar(200) DEFAULT (_utf8mb4'Both'),
  `state_activity_code` varchar(100) DEFAULT NULL,
  `role_id` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=182 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `m_incentive_activity`
--

LOCK TABLES `m_incentive_activity` WRITE;
/*!40000 ALTER TABLE `m_incentive_activity` DISABLE KEYS */;
INSERT INTO `m_incentive_activity` VALUES (1,'admin','2025-09-16 10:24:41','Providing HBNC up to 42 days after birth / discharge from SNCU',0,'CHILD HEALTH',_binary '\0','HBNC_0_42_DAYS','PER_CASE',250,5,'admin','2025-09-16 10:24:41',NULL,NULL,'Both',NULL,NULL),(2,'admin','2025-09-16 10:24:41','Incentive to ASHA for quarterly visits of HBYC',0,'CHILD HEALTH',_binary '\0','HBYC_QUARTERLY_VISITS','PER_CASE',250,5,'admin','2025-09-16 10:24:41',NULL,NULL,'Both',NULL,NULL),(3,'admin','2025-09-16 10:24:41','Incentive to ASHA for follow up of SNCU discharge babies and for follow up of LBW babies',0,'CHILD HEALTH',_binary '\0','SNCU_LBW_FOLLOWUP','PER_CASE',200,5,'admin','2025-09-16 10:24:41',NULL,NULL,'Both',NULL,NULL),(4,'admin','2025-09-16 10:24:41','Referring severely malnourished children to NRC and follow-up home visits',0,'CHILD HEALTH',_binary '\0','SAM_REFERRAL_NRC','PER_CASE',150,5,'admin','2025-09-16 10:24:41',NULL,NULL,'Both',NULL,NULL),(5,'admin','2025-09-16 10:24:41','Child death reporting',0,'CHILD HEALTH',_binary '\0','CHILD_DEATH_REPORTING','PER_CASE',100,5,'admin','2025-09-16 10:24:41',NULL,NULL,'Both',NULL,NULL),(6,'admin','2025-09-16 10:24:41','Incentive for E-HBNC (only for Cachar)',0,'CHILD HEALTH',_binary '\0','E_HBNC_CACHAR','PER_CASE',150,5,'admin','2025-09-16 10:24:41',NULL,NULL,'Both',NULL,NULL),(7,'admin','2025-09-16 10:24:41','Incentive for quarterly mothers meeting under MAA',0,'CHILD HEALTH',_binary '\0','MAA_QUARTERLY_MEETING','PER_CASE',100,5,'admin','2025-09-16 10:24:41',NULL,NULL,'Both',NULL,NULL),(8,'admin','2025-09-16 10:24:41','Incentive for National Deworming Day for mobilising out of school children',0,'CHILD HEALTH',_binary '\0','NATIONAL_DEWORMING_DAY','PER_CASE',100,5,'admin','2025-09-16 10:24:41',NULL,NULL,'Both',NULL,NULL),(9,'admin','2025-09-16 10:24:41','Incentive for prophylactic ORS distribution to families with under-5 children during Diarrhea Control Fortnight',0,'CHILD HEALTH',_binary '\0','ORS_DISTRIBUTION','PER_CASE',1,5,'admin','2025-09-16 10:24:41',NULL,NULL,'Both',NULL,NULL),(10,'admin','2025-09-16 10:24:41','Motivating 70% of targeted WRA (20-49 yrs, non-pregnant/non-lactating) to take iron tablets',0,'CHILD HEALTH',_binary '\0','NATIONAL_IRON_PLUS','PER_CASE',50,5,'admin','2025-09-16 10:24:41',NULL,NULL,'Both',NULL,NULL),(11,'admin','2025-09-16 10:24:41','Providing nutrition advice and iron supplementation to children 6-59 months after 10 monthly visits',0,'CHILD HEALTH',_binary '\0','NIPI_CHILDREN','PER_CASE',100,5,'admin','2025-09-16 10:24:41',NULL,NULL,'Both',NULL,NULL),(12,'admin','2025-09-16 10:26:51','ASHA incentive for ensuring for full immunization (0-1 year)',0,'IMMUNIZATION',_binary '\0','FULL_IMMUNIZATION_0_1','PER_CHILD',100,5,'admin','2025-09-16 10:26:51',NULL,NULL,'Both',NULL,NULL),(13,'admin','2025-09-16 10:26:51','Ensuring for complete immunization (1 - 2 years)',0,'IMMUNIZATION',_binary '\0','COMPLETE_IMMUNIZATION_1_2','PER_CHILD',75,5,'admin','2025-09-16 10:26:51',NULL,NULL,'Both',NULL,NULL),(14,'admin','2025-09-16 10:26:51','Ensuring for DPT immunization (5 years)',0,'IMMUNIZATION',_binary '\0','DPT_IMMUNIZATION_5_YEARS','PER_CHILD',50,5,'admin','2025-09-16 10:26:51',NULL,NULL,'Both',NULL,NULL),(15,'admin','2025-09-16 10:26:51','Mobilization of children in every session site',0,'IMMUNIZATION',_binary '\0','CHILD_MOBILIZATION_SESSIONS','PER_MEETING',150,5,'admin','2025-09-16 10:26:51',NULL,NULL,'Both',NULL,NULL),(20,'admin','2025-09-16 10:28:32','ASHA incentive for ANC registration within 1st Trimester',0,'MATERNAL HEALTH',_binary '\0','ANC_REGISTRATION_1ST_TRIM','PER_CASE',50,5,'admin','2025-09-16 10:28:32',NULL,NULL,'Both',NULL,NULL),(21,'admin','2025-09-16 10:28:32','ASHA incentive for ensuring Full ANC',0,'MATERNAL HEALTH',_binary '\0','FULL_ANC','PER_CASE',100,5,'admin','2025-09-16 10:28:32',NULL,NULL,'Both',NULL,NULL),(22,'admin','2025-09-16 10:28:32','ASHA incentive for Comprehensive Abortion Care',0,'MATERNAL HEALTH',_binary '\0','COMPREHENSIVE_ABORTION_CARE','PER_CASE',150,5,'admin','2025-09-16 10:28:32',NULL,NULL,'Both',NULL,NULL),(23,'admin','2025-09-16 10:28:32','ASHA incentive for ensuring Institutional delivery of identified HRP',0,'MATERNAL HEALTH',_binary '\0','INST_DELIVERY_HRP','PER_CASE',100,5,'admin','2025-09-16 10:28:32',NULL,NULL,'Both',NULL,NULL),(24,'admin','2025-09-16 10:28:32','EPMSMA - instt delivery',0,'MATERNAL HEALTH',_binary '\0','EPMSMA_INST_DELIVERY','PER_CASE',500,5,'admin','2025-09-16 10:28:32',NULL,NULL,'Both',NULL,NULL),(25,'admin','2025-09-16 10:28:32','Assisting high-risk pregnant women for antenatal check-up under PMSMA.',0,'MATERNAL HEALTH',_binary '\0','EPMSMA_HRP_IDENTIFIED','PER_CASE',100,5,'admin','2025-09-16 10:28:32',NULL,NULL,'Both',NULL,NULL),(26,'admin','2025-09-16 10:28:32','ASHA Incentive for maternal death reporting',0,'MATERNAL HEALTH',_binary '\0','MATERNAL_DEATH_REPORT','PER_CASE',200,5,'admin','2025-09-16 10:28:32',NULL,NULL,'Both',NULL,NULL),(27,'admin','2025-09-16 10:29:29','JSY incentive for ASHA for 1st Delivery (Rural) for Antenatal Component',0,'JSY',_binary '\0','JSY_1ST_DEL_ANC_RURAL','PER_CASE',300,5,'admin','2025-09-16 10:29:29',NULL,NULL,'Rular',NULL,NULL),(28,'admin','2025-09-16 10:29:29','JSY incentive for ASHA for 1st Delivery (Rural) for facilitating Institutional Delivery',0,'JSY',_binary '\0','JSY_1ST_DEL_INST_RURAL','PER_CASE',300,5,'admin','2025-09-16 10:29:29',NULL,NULL,'Rular',NULL,NULL),(29,'admin','2025-09-16 10:29:29','JSY incentive for ASHA for 2nd Delivery (Rural) for Antenatal Component',0,'JSY',_binary '\0','JSY_2ND_DEL_ANC_RURAL','PER_CASE',300,5,'admin','2025-09-16 10:29:29',NULL,NULL,'Rular',NULL,NULL),(30,'admin','2025-09-16 10:29:29','JSY incentive for ASHA for 2nd Delivery (Rural) for facilitating Institutional Delivery',0,'JSY',_binary '\0','JSY_2ND_DEL_INST_RURAL','PER_CASE',300,5,'admin','2025-09-16 10:29:29',NULL,NULL,'Rular',NULL,NULL),(31,'admin','2025-09-16 10:29:29','JSY incentive for ASHA for 3rd Delivery (Rural) for Antenatal Component',0,'JSY',_binary '\0','JSY_3RD_DEL_ANC_RURAL','PER_CASE',200,5,'admin','2025-09-16 10:29:29',NULL,NULL,'Rular',NULL,NULL),(32,'admin','2025-09-16 10:29:29','JSY incentive for ASHA for 3rd Delivery (Rural) for facilitating Institutional Delivery',0,'JSY',_binary '\0','JSY_3RD_DEL_INST_RURAL','PER_CASE',200,5,'admin','2025-09-16 10:29:29',NULL,NULL,'Rular',NULL,NULL),(33,'admin','2025-09-16 10:29:29','JSY incentive for ASHA for 4th Delivery (Rural) for Antenatal Component',0,'JSY',_binary '\0','JSY_4TH_DEL_ANC_RURAL','PER_CASE',100,5,'admin','2025-09-16 10:29:29',NULL,NULL,'Rular',NULL,NULL),(34,'admin','2025-09-16 10:29:29','JSY incentive for ASHA for 4th Delivery (Rural) for facilitating Institutional Delivery',0,'JSY',_binary '\0','JSY_4TH_DEL_INST_RURAL','PER_CASE',100,5,'admin','2025-09-16 10:29:29',NULL,NULL,'Rular',NULL,NULL),(35,'admin','2025-09-16 10:29:29','JSY incentive (Urban) for Antenatal Component',0,'JSY',_binary '\0','JSY_ANC_URBAN','PER_CASE',200,5,'admin','2025-09-16 10:29:29',NULL,NULL,'Urban',NULL,NULL),(36,'admin','2025-09-16 10:29:29','JSY incentive (Urban) for facilitating Institutional Delivery',0,'JSY',_binary '\0','JSY_INST_URBAN','PER_CASE',200,5,'admin','2025-09-16 10:29:29',NULL,NULL,'Urban',NULL,NULL),(37,'admin','2025-09-16 10:30:52','ASHA incentive for accompanying the client for Injectable MPA (Antara Prog) administration for 1st dose',0,'FAMILY PLANNING',_binary '\0','FP_ANC_MPA1','PER_CASE',100,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(38,'admin','2025-09-16 10:30:52','ASHA incentive for accompanying the client for Injectable MPA (Antara Prog) administration for 2nd dose',0,'FAMILY PLANNING',_binary '\0','FP_ANC_MPA2','PER_CASE',100,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(39,'admin','2025-09-16 10:30:52','ASHA incentive for accompanying the client for Injectable MPA (Antara Prog) administration for 3rd dose',0,'FAMILY PLANNING',_binary '\0','FP_ANC_MPA3','PER_CASE',100,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(40,'admin','2025-09-16 10:30:52','ASHA incentive for accompanying the client for Injectable MPA (Antara Prog) administration for 4th dose',0,'FAMILY PLANNING',_binary '\0','FP_ANC_MPA4','PER_CASE',100,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(41,'admin','2025-09-16 10:30:52','ASHA incentive for accompanying the client for Injectable MPA (Antara Prog) administration for more than 4th dose',0,'FAMILY PLANNING',_binary '\0','FP_ANC_MPA5','PER_CASE',100,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(42,'admin','2025-09-16 10:30:52','ASHA incentive for ensuring 3 years gap between 1st and 2nd child birth',0,'FAMILY PLANNING',_binary '\0','1st_2nd_CHILD_GAP','PER_CASE',500,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(43,'admin','2025-09-16 10:30:52','ASHA incentive for ensuring delaying 2 years for first child birth after marriage',0,'FAMILY PLANNING',_binary '\0','FP_DELAY_2Y','PER_CASE',500,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(44,'admin','2025-09-16 10:30:52','ASHA incentive for ensuring limiting after 2 child',0,'FAMILY PLANNING',_binary '\0','FP_LIMIT_2CHILD','PER_CASE',1000,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(45,'admin','2025-09-16 10:30:52','ASHA incentive for motivating a woman for PPIUCD insertion',0,'FAMILY PLANNING',_binary '\0','FP_PPIUCD','PER_CASE',150,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(46,'admin','2025-09-16 10:30:52','ASHA incentive for motivating PAIUCD',0,'FAMILY PLANNING',_binary '\0','FP_PAIUCD','PER_CASE',150,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(47,'admin','2025-09-16 10:30:52','ASHA incentive for Home Delivery Contraceptive - Condom',0,'FAMILY PLANNING',_binary '\0','FP_CONDOM','PER_CASE',1,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(48,'admin','2025-09-16 10:30:52','ASHA incentive for Home Delivery Contraceptive - Oral Pills',0,'FAMILY PLANNING',_binary '\0','FP_ORALPILLS','PER_CASE',1,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(49,'admin','2025-09-16 10:30:52','ASHA incentive for Home Delivery Contraceptive - EC',0,'FAMILY PLANNING',_binary '\0','FP_EC','PER_CASE',2,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(50,'admin','2025-09-16 10:30:52','ASHA incentive for motivating Female sterilization',0,'FAMILY PLANNING',_binary '\0','FP_FEMALE_STER','PER_CASE',300,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(51,'admin','2025-09-16 10:30:52','ASHA incentive for motivating a woman for PPS',0,'FAMILY PLANNING',_binary '\0','FP_PPS','PER_CASE',400,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(52,'admin','2025-09-16 10:30:52','ASHA incentive for motivating Minilap',0,'FAMILY PLANNING',_binary '\0','FP_MINILAP','PER_CASE',300,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(53,'admin','2025-09-16 10:30:52','ASHA incentive for motivating Male sterilization',0,'FAMILY PLANNING',_binary '\0','FP_MALE_STER','PER_CASE',400,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(54,'admin','2025-09-16 10:30:52','ASHA incentive for updation of EC survey before each MPV campaign',0,'FAMILY PLANNING',_binary '\0','FP_EC_SURVEY','PER_CASE',150,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(55,'admin','2025-09-16 10:30:52','ASHA incentive to mobilize Saas Bahu Sammelan',0,'FAMILY PLANNING',_binary '\0','FP_SAAS_BAHU','PER_CASE',100,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(56,'admin','2025-09-16 10:30:52','ASHA incentive for distributing Naye Pahel Kit',0,'FAMILY PLANNING',_binary '\0','FP_NP_KIT','PER_CASE',100,5,'admin','2025-09-16 10:30:52',NULL,NULL,'Both',NULL,NULL),(57,'admin','2025-09-16 10:32:43','Menstrual Hygiene – For selling sanitary napkin.',0,'ADOLESCENT HEALTH',_binary '\0','AH_SANITARY','PER_CASE',1,5,'admin','2025-09-16 10:32:43',NULL,NULL,'Both',NULL,NULL),(58,'admin','2025-09-16 10:32:43','Incentive for selection and support of Peer Educator',0,'ADOLESCENT HEALTH',_binary '\0','AH_PEER_ED','PER_CASE',100,5,'admin','2025-09-16 10:32:43',NULL,NULL,'Both',NULL,NULL),(59,'admin','2025-09-16 10:32:43','Incentive for mobilizing adolescents and community for AHD',0,'ADOLESCENT HEALTH',_binary '\0','AH_MOBILIZE','PER_CASE',100,5,'admin','2025-09-16 10:32:43',NULL,NULL,'Both',NULL,NULL),(60,'admin','2025-09-16 10:33:58','ASHA Monthly Routine Activities (Rs. 2000/- per month).',0,'ASHA MONTHLY ROUTINE',_binary '\0','ASHA_MONTHLY_ROUTINE','PER_MONTH',2000,5,'admin','2025-09-16 10:33:58',NULL,'PER_MONTH','Both',NULL,NULL),(61,'admin','2025-09-16 10:35:10','NPCB - For ensuring Treatment of Cataract surgery in Govt. Facility.',0,'UMBRELLA PROGRAMMES',_binary '\0','NPCB_GOVT_CATARACT','PER_CASE',250,5,'admin','2025-09-16 10:35:10',NULL,NULL,'Both',NULL,NULL),(62,'admin','2025-09-16 10:35:10','NPCB - For ensuring Treatment of Cataract surgery in Private facility.',0,'UMBRELLA PROGRAMMES',_binary '\0','NPCB_PRIVATE_CATARACT','PER_CASE',350,5,'admin','2025-09-16 10:35:10',NULL,NULL,'Both',NULL,NULL),(63,'admin','2025-09-16 10:35:10','Incentive for completion of 6 month treatment of DSTB.',0,'UMBRELLA PROGRAMMES',_binary '\0','DSTB_TREATMENT','PER_CASE',1000,5,'admin','2025-09-16 10:35:10',NULL,NULL,'Both',NULL,NULL),(64,'admin','2025-09-16 10:35:10','Incentive for completion of treatment of DRTB.',0,'UMBRELLA PROGRAMMES',_binary '\0','DRTB_TREATMENT','PER_CASE',5000,5,'admin','2025-09-16 10:35:10',NULL,NULL,'Both',NULL,NULL),(65,'admin','2025-09-16 10:35:10','Informant incentive.',0,'UMBRELLA PROGRAMMES',_binary '\0','INFORMANT_INCENTIVE','PER_CASE',500,5,'admin','2025-09-16 10:35:10',NULL,NULL,'Both',NULL,NULL),(66,'admin','2025-09-16 10:35:10','Incentive for Providing TPT.',0,'UMBRELLA PROGRAMMES',_binary '\0','TPT_PROVIDING','PER_CASE',250,5,'admin','2025-09-16 10:35:10',NULL,NULL,'Both',NULL,NULL),(67,'admin','2025-09-16 10:35:10','Incentive for facilitating Bank Account Seeding of Patients for NPY.',0,'UMBRELLA PROGRAMMES',_binary '\0','BANK_ACCOUNT_NPY','PER_CASE',50,5,'admin','2025-09-16 10:35:10',NULL,NULL,'Both',NULL,NULL),(68,'admin','2025-09-16 10:35:10','Incentive for House to House Survey (Active Case Finding).',0,'UMBRELLA PROGRAMMES',_binary '\0','HOUSE_TO_HOUSE_SURVEY','PER_CASE',10,5,'admin','2025-09-16 10:35:10',NULL,NULL,'Both',NULL,NULL),(69,'admin','2025-09-16 10:35:10','NLEP – Sensitization ASHA Incentive for training on Leprosy.',0,'UMBRELLA PROGRAMMES',_binary '\0','NLEP_TRAINING','PER_CASE',100,5,'admin','2025-09-16 10:35:10',NULL,NULL,'Both',NULL,NULL),(70,'admin','2025-09-16 10:35:10','NLEP - Incentive for case detection.',0,'UMBRELLA PROGRAMMES',_binary '\0','NLEP_CASE_DETECTION','PER_CASE',250,5,'admin','2025-09-16 10:35:10',NULL,NULL,'Both',NULL,NULL),(71,'admin','2025-09-16 10:35:10','NLEP - for ensuring complete treatment of PB cases.',0,'UMBRELLA PROGRAMMES',_binary '\0','NLEP_PB_TREATMENT','PER_CASE',400,5,'admin','2025-09-16 10:35:10',NULL,NULL,'Both',NULL,NULL),(72,'admin','2025-09-16 10:35:10','NLEP - for ensuring complete treatment of MB cases.',0,'UMBRELLA PROGRAMMES',_binary '\0','NLEP_MB_TREATMENT','PER_CASE',600,5,'admin','2025-09-16 10:35:10',NULL,NULL,'Both',NULL,NULL),(73,'admin','2025-09-16 10:35:10','Partial Incentives to the ASHAs for Leprosy suspects.',0,'UMBRELLA PROGRAMMES',_binary '\0','LEPROSY_PARTIAL_ASHA','PER_CASE',50,5,'admin','2025-09-16 10:35:10',NULL,NULL,'Both',NULL,NULL),(74,'admin','2025-09-16 10:35:10','NVBDCP - For malaria slide collection.',0,'UMBRELLA PROGRAMMES',_binary '\0','NVBDCP_SLIDE_COLLECTION','PER_CASE',15,5,'admin','2025-09-16 10:35:10',NULL,NULL,'Both',NULL,NULL),(75,'admin','2025-09-16 10:35:10','NVBDCP - For ensuring treatment of Malaria positive cases.',0,'UMBRELLA PROGRAMMES',_binary '\0','NVBDCP_MALARIA_TREATMENT','PER_CASE',200,5,'admin','2025-09-16 10:35:10',NULL,NULL,'Both',NULL,NULL),(76,'admin','2025-09-16 10:35:10','ASHA incentive for referral of AES/JE cases to the nearest CHC/DH/Medical College.',0,'UMBRELLA PROGRAMMES',_binary '\0','AES_JE_REFERRAL','PER_CASE',300,5,'admin','2025-09-16 10:35:10',NULL,NULL,'Both',NULL,NULL),(77,'admin','2025-09-16 10:35:10','ASHA Incentive for Dengue and Chikungunya.',0,'UMBRELLA PROGRAMMES',_binary '\0','DENGUE_CHIKUNGUNYA','PER_CASE',200,5,'admin','2025-09-16 10:35:10',NULL,NULL,'Urban',NULL,NULL),(78,'admin','2025-09-16 10:35:10','NIDDCP – For testing 50 salt samples per month.',0,'UMBRELLA PROGRAMMES',_binary '\0','NIDDCP_SALT_TEST','PER_CASE',25,5,'admin','2025-09-16 10:35:10',NULL,NULL,'Both',NULL,NULL),(79,'admin','2025-09-16 10:36:33','Incentive for population enumeration, CBAC filling and mobilizing for NCD screening',0,'NCD',_binary '\0','NCD_POP_ENUMERATION','PER_CASE',10,5,'admin','2025-09-16 10:36:33',NULL,NULL,'Both',NULL,NULL),(80,'admin','2025-09-16 10:36:33','Incentive for follow up and treatment compliance for 6 months for patients diagnosed with Hypertension,Diabetes,Mellitus & 3 common cancers(Oral, Breast,Carvical)',0,'NCD',_binary '\0','NCD_FOLLOWUP_TREATMENT','PER_CASE',50,5,'admin','2025-09-16 10:36:33',NULL,NULL,'Both',NULL,NULL),(81,'admin','2025-09-16 10:36:47','Additional Rs. 1000/- incentive to ASHA under State Govt. Budget.',0,'ADDITIONAL INCENTIVE',_binary '\0','ADDITIONAL_ASHA_INCENTIVE','PER_CASE',1000,5,'admin','2025-09-16 10:36:47',NULL,'PER_MONTH','Both',NULL,NULL),(82,'admin','2025-09-16 10:37:41','ASHA incentive Rs.10 per case for ABHA ID Creation.',0,'OTHER INCENTIVES',_binary '\0','ABHA_ID_CREATION','PER_CASE',10,5,'admin','2025-09-16 10:37:41',NULL,NULL,'Both',NULL,NULL),(83,'admin','2025-09-16 10:37:41','Mobile bill reimbursement of ASHA',0,'OTHER INCENTIVES',_binary '\0','MOBILE_BILL_REIMB','PER_CASE',100,5,'admin','2025-09-16 10:37:41',NULL,'PER_MONTH','Both',NULL,NULL),(84,'admin','2025-09-16 10:46:51',' ASHA incentive for Community Based Distribution of Misoprostol',0,'MATERNAL HEALTH',_binary '\0','MH_MISOPROSTOL','PER_CASE',150,5,'admin','2025-09-16 10:46:51',NULL,NULL,'Both',NULL,NULL),(85,'admin','2025-09-16 10:46:51','For ensuring early registration of pregnancy and opening of bank account of beneficiary',0,'MATERNAL HEALTH',_binary '\0','MH_EARLY_REG_BANK','PER_CASE',50,5,'admin','2025-09-16 10:46:51',NULL,NULL,'Both',NULL,NULL),(86,'admin','2025-09-16 10:46:51','ASHA incentive Rs.100 per case for ensuring one ANC by MO in the third trimester.',0,'MATERNAL HEALTH',_binary '\0','MH_ANC_3RD_TRIM','PER_CASE',100,5,'admin','2025-09-16 10:46:51',NULL,NULL,'Both',NULL,NULL),(87,'admin','2025-09-16 10:46:51','For motivating Institutional delivery of the beneficiary',0,'MATERNAL HEALTH',_binary '\0','MH_MOTIVATE_INST_DEL','PER_CASE',50,5,'admin','2025-09-16 10:46:51',NULL,NULL,'Both',NULL,NULL),(88,'admin','2025-09-16 10:46:51','ASHA incentive for identification for High Risk cases in the post natal period',0,'MATERNAL HEALTH',_binary '\0','MH_HR_POSTNATAL','PER_CASE',250,5,'admin','2025-09-16 10:46:51',NULL,NULL,'Both',NULL,NULL),(89,'admin','2025-09-30 10:46:51','Assisting in conducting four antenatal check-ups for pregnant women',0,'ACTIVITY',_binary '\0','ANC_FOUR_CHECKUPS_SUPPORT','PER_CASE',300,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','1',NULL),(90,'admin','2025-09-30 10:46:51','Escorting for institutional delivery (Government Hospital)',0,'ACTIVITY',_binary '\0','INST_DELIVERY_ESCORT','PER_CASE',300,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','2',NULL),(91,'admin','2025-09-30 10:46:51','Conducting seven scheduled home visits within the first 42 days of a newborn\'s life',0,'ACTIVITY',_binary '\0','HBNC_0_42_DAYS','PER_CASE',250,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','3',NULL),(92,'admin','2025-09-30 10:46:51','Referring severely malnourished children to Nutrition Rehabilitation Centre (NRC) and follow-up home visits',0,'ACTIVITY',_binary '\0','SAM_REFERRAL_NRC','PER_CASE',300,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','72',NULL),(93,'admin','2025-09-30 10:46:51','Providing nutrition advice and iron supplementation to children aged 6 months to 5 years (after 10 monthly visits)',0,'ACTIVITY',_binary '\0','NIPI_CHILDREN','PER_CASE',50,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','61',NULL),(94,'admin','2025-09-30 10:46:51','Ensuring completion of first-year immunization (from BCG to measles)',0,'ACTIVITY',_binary '\0','FULL_IMMUNIZATION_0_1','PER_CHILD',100,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','9',NULL),(95,'admin','2025-09-30 10:46:51','Ensuring completion of second-year booster immunization',0,'ACTIVITY',_binary '\0','COMPLETE_IMMUNIZATION_1_2','PER_CHILD',75,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','56',NULL),(96,'admin','2025-09-30 10:46:51','Assisting in Pulse Polio campaign',0,'ACTIVITY',_binary '\0','CHILD_MOBILIZATION_SESSIONS','PER_CASE',100,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','11',NULL),(97,'admin','2025-09-30 10:46:51','Successfully motivating couples to maintain at least a two-year gap after marriage before first child',0,'ACTIVITY',_binary '\0','FP_DELAY_2Y','PER_CASE',500,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','12',NULL),(98,'admin','2025-09-30 10:46:51','Successfully motivating couples to maintain at least a three-year gap after the birth of the first child',0,'ACTIVITY',_binary '\0','1st_2nd_CHILD_GAP','PER_CASE',1000,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','13',NULL),(99,'admin','2025-09-30 10:46:51','Successfully motivating couples with 1–2 living children for sterilization (Government Hospital)',0,'ACTIVITY',_binary '\0','FP_LIMIT_2CHILD','PER_CASE',150,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','14',NULL),(100,'admin','2025-09-30 10:46:51','Motivating for postnatal family planning using temporary method (PPIUCD) (Government Hospital)',0,'ACTIVITY',_binary '\0','FP_PPIUCD','PER_CASE',200,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','15',NULL),(101,'admin','2025-09-30 10:46:51','Referring beneficiaries for cataract surgery (Government Hospital)',0,'ACTIVITY',_binary '\0','NPCB_GOVT_CATARACT','PER_CASE',100,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','16',NULL),(102,'admin','2025-09-30 10:46:51','Preparing malaria slide/RDT test',0,'ACTIVITY',_binary '\0','NVBDCP_SLIDE_COLLECTION','PER_CASE',15,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','18',NULL),(103,'admin','2025-09-30 10:46:51','Completing treatment of PF and PV malaria cases',0,'ACTIVITY',_binary '\0','NVBDCP_MALARIA_TREATMENT','PER_CASE',200,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','73',NULL),(104,'admin','2025-09-30 10:46:51','Identification of new leprosy patients',0,'ACTIVITY',_binary '\0','NLEP_CASE_DETECTION','PER_CASE',250,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','20',NULL),(105,'admin','2025-09-30 10:46:51','Completing treatment of PB (Paucibacillary) leprosy patients',0,'ACTIVITY',_binary '\0','NLEP_PB_TREATMENT','PER_CASE',400,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','21',NULL),(106,'admin','2025-09-30 10:46:51','Completing treatment of MB (Multibacillary) leprosy patients',0,'ACTIVITY',_binary '\0','NLEP_MB_TREATMENT','PER_CASE',600,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','22',NULL),(107,'admin','2025-09-30 10:46:51','Completion of TB treatment with Mitanin’s support',0,'ACTIVITY',_binary '\0','DSTB_TREATMENT','PER_CASE',1000,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','23',NULL),(108,'admin','2025-09-30 10:46:51','Supporting complete treatment of drug-resistant TB patients',0,'ACTIVITY',_binary '\0','DRTB_TREATMENT','PER_CASE',5000,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','25',NULL),(109,'admin','2025-09-30 10:46:51','Distribution of filariasis medicine for 3 days (to at least 50 families or 250 individuals)',0,'ACTIVITY',_binary '\0','FILARIASIS_MEDICINE_DISTRIBUTION','PER_YEAR',600,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','26',NULL),(110,'admin','2025-09-30 10:46:51','Participation in Village Health and Nutrition Day (VHND)',0,'ACTIVITY',_binary '\0','VHND_PARTICIPATION','PER_CASE',200,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','29',NULL),(111,'admin','2025-09-30 10:46:51','Attending monthly cluster meetings of Mitanins',0,'ACTIVITY',_binary '\0','CLUSTER_MEETING','PER_CASE',150,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','30',NULL),(112,'admin','2025-09-30 10:46:51','Organizing and attending monthly meetings of Village Health, Sanitation, and Nutrition Committee (VHSNC)',0,'ACTIVITY',_binary '\0','VHSNC_MEETING','PER_MEETING',150,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','31',NULL),(113,'admin','2025-09-30 10:46:51','Filling prescribed information in the Mitanin register',0,'ACTIVITY',_binary '\0','MITANIN_REGISTER','PER_MONTH',500,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','32',NULL),(114,'admin','2025-09-30 10:46:51','Referring 10 or more cases monthly to Health and Wellness Centre',0,'ACTIVITY',_binary '\0','HWC_REFERRAL_10_CASES','PER_CASE',400,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','39',NULL),(115,'admin','2025-09-30 10:46:51','Motivating 70% of targeted women (aged 20–49, excluding pregnant and lactating) to take iron tablets (Kawardha, Sarguja)',0,'ACTIVITY',_binary '\0','NATIONAL_IRON_PLUS','PER_CASE',50,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','40',NULL),(116,'admin','2025-09-30 10:46:51','Incentive under the Nayi Pahal Kit initiative',0,'ACTIVITY',_binary '\0','FP_NP_KIT','PER_CASE',100,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','60',NULL),(117,'admin','2025-09-30 10:46:51','Quarterly meetings to counsel mothers on breastfeeding under the MAA program',0,'ACTIVITY',_binary '\0','MAA_QUARTERLY_MEETING','PER_CASE',100,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','33',NULL),(118,'admin','2025-09-30 10:46:51','Sending out-of-school children to Anganwadi for deworming during National Deworming Day (biannual campaign)',0,'ACTIVITY',_binary '\0','NATIONAL_DEWORMING_DAY','PER_CASE',100,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','34',NULL),(119,'admin','2025-09-30 10:46:51','ORS distribution and support during Diarrhea Control Fortnight',0,'ACTIVITY',_binary '\0','ORS_DISTRIBUTION','PER_CASE',100,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','35',NULL),(120,'admin','2025-09-30 10:46:51','Motivating for Antara contraceptive injection',0,'ACTIVITY',_binary '\0','FP_ANC_MPA1','PER_CASE',100,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','59',NULL),(121,'admin','2025-09-30 10:46:51','Motivating for IUCD (Copper-T) insertion post-abortion',0,'ACTIVITY',_binary '\0','FP_PAIUCD','PER_CASE',300,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','37',NULL),(122,'admin','2025-09-30 10:46:51','Conducting assessment surveys for non-communicable diseases',0,'ACTIVITY',_binary '\0','NCD_POP_ENUMERATION','PER_CASE',10,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','38',NULL),(123,'admin','2025-09-30 10:46:51','Home visits to lactating mothers (with children up to 6 months) for iron and nutrition advice',0,'ACTIVITY',_binary '\0','LACTATING_MOTHERS_HOME_VISIT','PER_CASE',50,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','55',NULL),(124,'admin','2025-09-30 10:46:51','Assisting in DPT booster vaccination for children aged 5–6 years',0,'ACTIVITY',_binary '\0','DPT_IMMUNIZATION_5_YEARS','PER_CASE',50,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','54',NULL),(125,'admin','2025-09-30 10:46:51','Visits under HBYC (Home-Based Young Child Care) at 3, 6, 9, 12, and 15 months for advice',0,'ACTIVITY',_binary '\0','HBYC_QUARTERLY_VISITS','PER_CASE',500,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','57',NULL),(126,'admin','2025-09-30 10:46:51','Confirming new TB cases',0,'ACTIVITY',_binary '\0','INFORMANT_INCENTIVE','PER_CASE',500,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','52',NULL),(127,'admin','2025-09-30 10:46:51','Motivating participation in quarterly Adolescent Health Day meetings (Korba, Mahasamund, Bilaspur, GPM, Sarguja, Jashpur)',0,'ACTIVITY',_binary '\0','AH_MOBILIZE','PER_CASE',100,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','62',NULL),(128,'admin','2025-09-30 10:46:51','Filling 5 prescribed types of information in the Mitanin register',0,'ACTIVITY',_binary '\0','MITANIN_REGISTER_5_INFO_FILL','PER_MONTH',1000,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','44',NULL),(129,'admin','2025-09-30 10:46:51','Assisting new patients with BP, diabetes, and cancer to start medication',0,'ACTIVITY',_binary '\0','NCD_NEW_PATIENT_MEDICATION_SUPPORT','PER_CASE',50,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','63',NULL),(130,'admin','2025-09-30 10:46:51','Follow-up of BP, diabetes, and cancer patients every 6 months',0,'ACTIVITY',_binary '\0','NCD_FOLLOWUP_TREATMENT','PER_CASE',50,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','64',NULL),(131,'admin','2025-09-30 10:46:51','Motivating women for sterilization 1.5 months after delivery (no limit on number of children)',0,'ACTIVITY',_binary '\0','FP_FEMALE_STER','PER_CASE',300,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','65',NULL),(133,'admin','2025-09-30 10:46:51','Motivating women for postpartum sterilization within 7 days of delivery (no limit on number of children)',0,'ACTIVITY',_binary '\0','FP_PPS','PER_CASE',400,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','67',NULL),(134,'admin','2025-09-30 10:46:51','Motivating men for sterilization (no limit on number of children)',0,'ACTIVITY',_binary '\0','FP_MALE_STER','PER_CASE',400,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','68',NULL),(135,'admin','2025-09-30 10:46:51','Assisting high-risk pregnant women for antenatal check-up under PMSMA visits to a government hospital (maximum 3 visits)',0,'ACTIVITY',_binary '\0','EPMSMA_HRP_IDENTIFIED','PER_VISIT',100,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','69',NULL),(136,'admin','2025-09-30 10:46:51','Ensuring mother and child are healthy up to 45 days postpartum in high-risk pregnancy cases',0,'ACTIVITY',_binary '\0','HIGH_RISK_POSTPARTUM_HEALTH_CHECK','PER_VISIT',500,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','70',NULL),(137,'admin','2025-09-30 10:46:51','Mobilizing community during distribution of medicated mosquito nets',0,'ACTIVITY',_binary '\0','MOSQUITO_NET_DISTRIBUTION_MOBILIZATION','PER_NET',5,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','71',NULL),(138,'admin','2025-09-30 10:46:51','Postpartum care in high-risk cases and ensuring mother and child are healthy up to 45 days',0,'ACTIVITY',_binary '\0','HIGH_RISK_POSTPARTUM_CARE','PER_CASE',250,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','74',NULL),(139,'admin','2025-09-30 10:46:51','Completion of TB preventive treatment',0,'ACTIVITY',_binary '\0','TPT_PROVIDING','PER_CASE',250,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both','75',NULL),(140,'admin','2025-09-30 10:46:51','Monthly honorarium',0,'ACTIVITY',_binary '\0','MONTHLY_HONORARIUM','PER_MONTH',2200,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Both',NULL,NULL),(141,'admin','2025-09-30 10:46:51','Assisting in conducting four antenatal check-ups for pregnant women',0,'ACTIVITY',_binary '\0','FULL_ANC_45','PER_CASE',300,8,'admin','2025-09-16 10:46:51',NULL,NULL,'Urban','45',NULL),(142,'admin','2025-09-16 10:46:51','ASHA incentive Rs.50 per case for motivating Institutional delivery of the beneficiary.',0,'ACTIVITY',_binary '\0','MH_MOTIVATE_INST_DEL_46','PER_CASE',300,5,'admin','2025-09-16 10:46:51',NULL,NULL,'Urban','46',NULL);
/*!40000 ALTER TABLE `m_incentive_activity` ENABLE KEYS */;
UNLOCK TABLES;
/*!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-01-05 16:02:07
