-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Mar 23, 2018 at 10:51 AM
-- Server version: 5.6.17
-- PHP Version: 5.5.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


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

--
-- Database: `vidyalkh_demo`
--

-- --------------------------------------------------------

--
-- Table structure for table `fin_salary_component`
--

CREATE TABLE IF NOT EXISTS `fin_salary_component` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `ay_id` char(7) COLLATE utf8_unicode_ci NOT NULL,
  `inst_id` smallint(5) NOT NULL,
  `component_id` mediumint(8) NOT NULL,
  `component_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `component_type` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `tax_deduction` tinyint(1) NOT NULL,
  `tax_per_month` bigint(50) NOT NULL,
  `tax_per_year` bigint(50) NOT NULL,
  `provident_fund` tinyint(1) NOT NULL,
  `is_ESIC` tinyint(1) NOT NULL,
  `is_system_def` tinyint(1) NOT NULL DEFAULT '1',
  `comments` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `valid_from` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `valid_to` timestamp NOT NULL DEFAULT '2037-12-30 10:59:59',
  `created_by` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'SYSTEM',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'SYSTEM',
  `updated_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18 ;

--
-- Dumping data for table `fin_salary_component`
--

INSERT INTO `fin_salary_component` (`id`, `ay_id`, `inst_id`, `component_id`, `component_name`, `component_type`, `tax_deduction`, `tax_per_month`, `tax_per_year`, `provident_fund`, `is_ESIC`, `is_system_def`, `comments`, `valid_from`, `valid_to`, `created_by`, `created_on`, `updated_by`, `updated_on`, `is_active`, `is_deleted`) VALUES
(1, '2016-17', 0, 1, 'Basic', 'Allowance', 1, 0, 0, 1, 1, 1, 'Basic', '2018-03-23 06:39:13', '2037-12-30 10:59:59', 'SYSTEM', '2018-03-23 06:39:13', 'SYSTEM', '2018-03-23 06:39:13', 1, 0),
(2, '2016-17', 0, 1, 'DA', 'Allowance', 1, 0, 0, 1, 1, 1, 'DA', '2018-03-23 01:04:04', '2037-12-30 10:59:59', 'SYSTEM', '2018-03-23 01:04:04', 'SYSTEM', '2018-03-23 01:04:04', 1, 0),
(3, '2016-17', 0, 1, 'Medical', 'Allowance', 1, 0, 0, 1, 1, 1, 'Medical', '2018-03-23 01:04:04', '2037-12-30 10:59:59', 'SYSTEM', '2018-03-23 01:04:04', 'SYSTEM', '2018-03-23 01:04:04', 1, 0),
(4, '2016-17', 0, 1, 'Conveyance', 'Allowance', 1, 0, 0, 1, 1, 1, 'Conveyance', '2018-03-23 01:04:04', '2037-12-30 10:59:59', 'SYSTEM', '2018-03-23 01:04:04', 'SYSTEM', '2018-03-23 01:04:04', 1, 0),
(5, '2016-17', 0, 1, 'HRA', 'Allowance', 1, 0, 0, 1, 1, 1, 'HRA', '2018-03-23 01:04:04', '2037-12-30 10:59:59', 'SYSTEM', '2018-03-23 01:04:04', 'SYSTEM', '2018-03-23 01:04:04', 1, 0),
(6, '2016-17', 0, 1, 'LTA', 'Allowance', 1, 0, 0, 1, 1, 1, 'LTA', '2018-03-23 01:04:04', '2037-12-30 10:59:59', 'SYSTEM', '2018-03-23 01:04:04', 'SYSTEM', '2018-03-23 01:04:04', 1, 0),
(7, '2016-17', 0, 1, 'Children Education Allowance', 'Allowance', 1, 0, 0, 1, 1, 1, 'Children Education Allowance', '2018-03-23 01:04:04', '2037-12-30 10:59:59', 'SYSTEM', '2018-03-23 01:04:04', 'SYSTEM', '2018-03-23 01:04:04', 1, 0),
(8, '2016-17', 0, 1, 'Children Hostel Allowance', 'Allowance', 1, 0, 0, 1, 1, 1, 'Children Hostel Allowance', '2018-03-23 01:04:04', '2037-12-30 10:59:59', 'SYSTEM', '2018-03-23 01:04:04', 'SYSTEM', '2018-03-23 01:04:04', 1, 0),
(9, '2016-17', 0, 1, 'Mobile & Telephone Reimbursement', 'Allowance', 1, 0, 0, 1, 1, 1, 'Mobile & Telephone Reimbursement', '2018-03-23 01:04:04', '2037-12-30 10:59:59', 'SYSTEM', '2018-03-23 01:04:04', 'SYSTEM', '2018-03-23 01:04:04', 1, 0),
(10, '2016-17', 0, 1, 'Car Maintenance', 'Allowance', 1, 0, 0, 1, 1, 1, 'Car Maintenance', '2018-03-23 01:04:04', '2037-12-30 10:59:59', 'SYSTEM', '2018-03-23 01:04:04', 'SYSTEM', '2018-03-23 01:04:04', 1, 0),
(11, '2016-17', 0, 1, 'Driver Salary', 'Allowance', 1, 0, 0, 1, 1, 1, 'Driver Salary', '2018-03-23 01:04:04', '2037-12-30 10:59:59', 'SYSTEM', '2018-03-23 01:04:04', 'SYSTEM', '2018-03-23 01:04:04', 1, 0),
(12, '2016-17', 0, 1, 'Books & Periodicals', 'Allowance', 1, 0, 0, 1, 1, 1, 'Books & Periodicals', '2018-03-23 01:04:04', '2037-12-30 10:59:59', 'SYSTEM', '2018-03-23 01:04:04', 'SYSTEM', '2018-03-23 01:04:04', 1, 0),
(13, '2016-17', 0, 1, 'Special', 'Allowance', 1, 0, 0, 1, 1, 1, 'Special', '2018-03-23 01:04:04', '2037-12-30 10:59:59', 'SYSTEM', '2018-03-23 01:04:04', 'SYSTEM', '2018-03-23 01:04:04', 1, 0),
(14, '2016-17', 0, 2, 'Provident Fund', 'Deduction', 1, 0, 0, 1, 1, 1, 'Provident Fund', '2018-03-23 01:04:04', '2037-12-30 10:59:59', 'SYSTEM', '2018-03-23 01:04:04', 'SYSTEM', '2018-03-23 01:04:04', 1, 0),
(15, '2016-17', 0, 2, 'ESIC', 'Deduction', 1, 0, 0, 1, 1, 1, 'ESIC', '2018-03-23 01:04:04', '2037-12-30 10:59:59', 'SYSTEM', '2018-03-23 01:04:04', 'SYSTEM', '2018-03-23 01:04:04', 1, 0),
(16, '2016-17', 0, 2, 'Professional Tax', 'Deduction', 1, 0, 0, 1, 1, 1, 'Professional Tax', '2018-03-23 01:04:04', '2037-12-30 10:59:59', 'SYSTEM', '2018-03-23 01:04:04', 'SYSTEM', '2018-03-23 01:04:04', 1, 0),
(17, '2016-17', 0, 2, 'Labour Welfare Fund', 'Deduction', 1, 0, 0, 1, 1, 1, 'Labour Welfare Fund', '2018-03-23 01:04:04', '2037-12-30 10:59:59', 'SYSTEM', '2018-03-23 01:04:04', 'SYSTEM', '2018-03-23 01:04:04', 1, 0);

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