-- MySQL dump 10.13  Distrib 5.5.62, for linux-glibc2.12 (x86_64)
--
-- Host: localhost    Database: waqfdb
-- ------------------------------------------------------
-- Server version	5.5.62

/*!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 `wmr_epf_loan`
--

DROP TABLE IF EXISTS `wmr_epf_loan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wmr_epf_loan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `months` varchar(33) NOT NULL,
  `year` int(33) NOT NULL,
  `date` varchar(33) NOT NULL,
  `code_loan` varchar(33) NOT NULL,
  `type` varchar(33) NOT NULL,
  `employee` varchar(33) NOT NULL,
  `designation` varchar(33) NOT NULL,
  `code` varchar(33) NOT NULL,
  `uan_number` varchar(33) NOT NULL,
  `contribution_employee` varchar(33) NOT NULL,
  `employer_contribution` varchar(33) NOT NULL,
  `amount` varchar(33) NOT NULL,
  `remarks` longtext NOT NULL,
  `session_username` varchar(33) NOT NULL,
  `timestamp` varchar(33) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wmr_epf_loan`
--

LOCK TABLES `wmr_epf_loan` WRITE;
/*!40000 ALTER TABLE `wmr_epf_loan` DISABLE KEYS */;
INSERT INTO `wmr_epf_loan` VALUES (10,'January',2019,'03-01-2019','','waqf','77','Telangana State','29171','Waqf Fund','4,13,117','4,40,771','8,53,888','Monthly contribution of Employees and Employer with admin. charges for the month of Dec. 2018','doulath','1546496343'),(11,'January',2019,'11-01-2019','','institution','153','all categories','seven','153','257578','257578','540018','Total EPF amount is Rs. 5,40,018/- including Employees Contribution Rs. 2,57,578\nEmployer Contribution Rs. 2,57,578\nAdministration Charges Rs. 24,862/- of (7) various EPF codes.','ilyas','1547188179'),(12,'January',2019,'04-02-2019','AP/HYD/29171','waqf','78','All Ministerial','AP/HYD/29171','All Ministerial Staff','4,00,766','4,27,662.00','8,28,428.00  Plus 14,926.00 (Reco','Monthly EPF Employees','doulath','1549284680'),(13,'January',2019,'05-02-2019','(7)','institution','138','all catogories','(7) Seven various EPF code No.s','138','220373','220373','the total EPF amount employees an','EPF amount  for the month of January payable to RPF commissioner employees and employer with admin charges(21373)  are Rs. 462117/- of seven various epf code no.','ilyas','1549345567'),(14,'February',2019,'02-03-2019','AP/HYD/29171','waqf','76','All categories','AP/HYD/29171','aall','3,81,512','4,07,189','7,88,701','EPF monthly contribution of both shares i.e. Employees','doulath','1551505223'),(15,'February',2019,'07-03-2019','7','institution','140','all staff members','7','','217580','217580','457222','EPF amount for the month of Feb-19 including admin charges @ 21580','ilyas','1551947158'),(16,'March',2019,'03-04-2019','7','institution','142','all caders','','142','281403','281403','586223','EPF for the month of March-2019 of Institution A/c staff payable to EPF Office along with administrative charges @ Rs. 23417','ilyas','1554272715'),(17,'July',2019,'02-08-2019','AP/HYD/29171','waqf','76','Ministerial/Class-IV/Contingent e','AP/HYD/29171','','4,89,749','5,21,708','10,11,457','Employer and Employees both contribution for the month July 2019 along with admin. charges','doulath','1564741113'),(18,'September',2019,'03-10-2019','AP/HYD/29171','waqf','74','ALL CATEGORIES','AP/HYD/29171','','3,95,626','4,22,222','8,17,848','EPF monthly contribution of both i.e. Employees and Employer alongwith administrative charges for the month of September 2019','doulath','1570082872'),(19,'March',2020,'31-03-2020','AP/HYD/29171','waqf','74','All categories','AP/HYD/29171','','3,94,108','4,15,373 (including admin. charge','8,09,481','EPF monthly contribution of Employer and Employees along with admin.charges','doulath','1585630412'),(20,'April',2021,'01-09-2021','AP/hyd/29171','waqf','76','All categories','AP/HYD/29171','','73,42,766','77,29,983','1,50,72,749','EPF monthly contribution of Employees and Employer for the period from 1-3-2020 to 1-7-2021 has been paid to the EPF Dept.','doulath','1630500482'),(21,'August',2021,'03-09-2021','AP/hyd/29171','waqf','70','All categories','AP/HYD/29171','AP/HYD/29171','4,29,626','4,52,181 (including Admin. ch','8,81,807','Both the contribution of Employer and Employees for the month of August 2021','doulath','1630667458'),(22,'August',2021,'04-09-2021','8 institutions','institution','166','All Staff members','8 institutions','','288329','308922','597251','for EPF payment of 8 various EPF codes including admin charges of Rs. 20593','ilyas','1630743804'),(23,'August',2021,'16-09-2021','AP/hyd/29171','waqf','70','All categories','AP/HYD/29171','AP/HYD/29171','4,29,626','4,52,181 (including Admn. Charges','8,81,807','both shares of employee and employer (including admin. charges) contribution for the month of August 2021','doulath','1631775154'),(24,'September',2021,'04-10-2021','8 institutions','institution','162','All Staff members','Eight codes','','2,87,725/-','3,08,336/-','5,96,061/-','Total EPF amount of Rs. 5,96,061/-  including admin charges for the month of Sep-2021','ilyas','1633351111'),(25,'September',2021,'05-10-2021','AP/hyd/29171','waqf','69','All categories','AP/HYD/29171','AP/HYD/29171','3,87,140','4,07,867','7,95,007','Both the contribution of Employer and Employees including admin. charges for the month of Sept.21','doulath','1633437567'),(26,'October',2021,'01-11-2021','AP/hyd/29171','waqf','70','All categories','AP/HYD/29171','AP/HYD/29171','3,83,688','4,04,217 including Admin. charges','7,87,905','EPF amount both the contribution of Employees and Employer for the month of October 2021','doulath','1635750328'),(27,'October',2021,'02-11-2021','8 institutions','institution','163','All Staff members','29171 52013 52014 47247 58760 618','163','285929','285929','592322','EPF both share with admin charges @ 20464 of Total Rs. 592322 for the month of Oct-2021','ilyas','1635835767'),(28,'November',2021,'06-12-2021','AP/hyd/29171','waqf','71','All categories','AP/HYD/29171','AP/HYD/29171','Rs.6,85,689','Rs. 7,19,170 (Including Admin cha','Rs. 14,04,859','Both shares of Employer and employees of EPF amount for the month of November 2021','doulath','1638785438'),(29,'November',2021,'06-12-2021','22','institution','163','All Staff members','8 institutions','','3,26,881','3,26,881','6,75,684','epf employees and employers share alongwith admin charges of Rs. 21,922','ilyas','1638786595'),(30,'December',2021,'24-12-2021','22','institution','162','All Staff members','8','','314718','314718','651001','Total EPF amt of Rs. 651001 including admin charges of Rs. 21565','ilyas','1640329779'),(31,'December',2021,'31-12-2021','AP/hyd/29171','waqf','70','All categories','AP/HYD/29171','AP/HYD/29171','Rs. 5,34,617.00','Rs. 5,61,658.00','Rs. 10,96,275.00','EPF monthly both contribution of Employee and Employer for the month of December 2021.','doulath','1640933118'),(32,'January',2022,'01-02-2022','AP/hyd/29171','waqf','70','All categories','AP/HYD/29171','AP/HYD/29171','Rs. 8,43,054','Rs. 8,83,317','Rs. 17,26,371','Both contribution of Employees and Employer for the month of January 2022 for Rs. 17,26,371/-','doulath','1643726269'),(33,'February',2022,'25-02-2022','AP/hyd/29171','waqf','70','All categories','AP/HYD/29171','AP/HYD/29171','Rs. 5,20,745/-','Rs. 5,47,212/- (Including Admin C','Rs. 10,67,957/-','Both contribution of Employees and Employer including Admin charges for the month of February 2022.','doulath','1645797796'),(34,'March',2022,'03-04-2022','AP/hyd/29171','waqf','69','All categories','AP/HYD/29171','AP/HYD/29171','Rs. 5,39,663','Rs. 5,67,143 (including Admin cha','Rs. 11,06,806/-','Both the share of Employee and Employer for the month of March 2022.','doulath','1648976829'),(35,'December',2022,'03-12-2022','22','institution','120','All Staff members','8 institutions','120','295474','295474','611777','Total EPF amount of Rs. 611777 including admin charges','ilyas','1670056190'),(36,'March',2024,'04-05-2024','22','institution','121','all staff','8 various institutions','121','328614','328614','679292','Admin charges 22064 for the month of Mar-2023','ilyas','1714816991'),(37,'April',2024,'04-05-2024','22','institution','121','all staff','8 various institutions','121','357211','357211','728710','admin charges 22167 for the month of Apr-2023','ilyas','1714817189'),(38,'May',2024,'04-05-2024','22','institution','123','all staff','8 various institutions','123','338675','338675','700046','admin charges 22696 for the month of may-23','ilyas','1714817592'),(39,'June',2024,'04-05-2024','22','institution','123','all staff','8 various institutions','123','541572','541572','1114307','admin charges 31163 for the month june-23 including PRC - 2020 arrears','ilyas','1714817691'),(40,'July',2024,'04-05-2024','22','institution','123','all staff','8 various institutions','123','439879','439879','906640','admin charges for the month of July-23 including supply bill arrears','ilyas','1714817847'),(41,'August',2024,'04-05-2024','22','institution','123','all staff','8 various institutions','123','371748','371748','784220','admin charges 40724 for the month of Aug-23 including supply bills arrears','ilyas','1714817956'),(42,'September',2024,'04-05-2024','22','institution','123','all staff','8 various institutions','123','344221','344221','711118','admin charges Rs. 22676 for the month of Sep-23','ilyas','1714818026'),(43,'October',2024,'04-05-2024','22','institution','123','all staff','8 various institutions','123','332435','332435','687018','admin charges 22148 for the month of Oct-23','ilyas','1714818085'),(44,'November',2024,'04-05-2024','22','institution','128','all staff','8 various institutions','128','478381','478381','1078312','admin charges Rs. 23804 for the month of Nov-23','ilyas','1714818194'),(45,'December',2024,'04-05-2024','22','institution','123','all staff','8 various institutions','123','389446','389446','805203','admin charges 24217 for the month of Dec-2023','ilyas','1714818465'),(46,'January',2024,'04-05-2024','22','institution','128','all staff','8 various institutions','128','372316','372316','768730','admin charges Rs. 24098 for the month of Jan-2024','ilyas','1714818704'),(47,'February',2024,'04-05-2024','22','institution','125','all staff','8 various institutions','125','374759','374759','773745','admin charges Rs. 24227 for the month of Feb-2024','ilyas','1714818785'),(48,'March',2024,'04-05-2024','22','institution','121','all staff','8 various institutions','121','369404','369404','762657','admin charges 23849 for the month of Mar-2024','ilyas','1714818954');
/*!40000 ALTER TABLE `wmr_epf_loan` 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-08-12 22:00:25
