-- phpMyAdmin SQL Dump
-- version 4.6.6deb5
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 03, 2019 at 10:10 PM
-- Server version: 5.7.27-0ubuntu0.18.04.1
-- PHP Version: 7.2.19-0ubuntu0.18.04.2

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

--
-- Database: `hris_payroll`
--

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

--
-- Table structure for table `ref_deduction`
--
--
-- CREATE TABLE `ref_deduction` (
--   `id` int(10,1) UNSIGNED NOT NULL,
--   `code` varchar(30,1) COLLATE utf8mb4_unicode_ci NOT NULL,
--   `desc` varchar(50,1) COLLATE utf8mb4_unicode_ci NOT NULL,
--   `agency_id` int(10,1) UNSIGNED NOT NULL
-- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ref_deduction`
--

INSERT INTO `ref_deduction` (`id`, `code`, `desc`, `agency_id`, `default` , `percentage`,`deduction_type`) VALUES
/*GSIS DEDUCTION
 */
(23, '20201020-01', 'LIFE & RETIREMENT PREMIUM', 4, true,0,1),
(3, '20201020-01', 'GSIS CONSOLIDATED LOAN', 4,false,0,1),
(6, '20201020-03.2', 'GSIS EDUCATIONAL ASSISTANCE LOAN', 4,false,0,1),
(13, '20201020-04', 'GSIS POLICY LOAN', 4,false,0,1),
(51, '20201020-50', 'UNLIMITED OPTIONAL LIFE INSURANCE POLICY LOAN', 4,false,0,1),
(9, '20201020-07', 'GSIS EMERGENCY LOAN PAYMENT', 4,false,0,1),
(10, '20201020-08', 'Home Emergency Loan Program (HELP)', 4,false,0,1),
(34, '20201030-01', 'PAG-IBIG PREMIUMS', 6,true,0,1),
(8, '20201030-02.1', 'GSIS CALAMITY LOAN', 4,false,0,1),
(32, '20201030-02', 'PAG-IBIG MULTI-PURPOSE LOAN', 6,false,0,1),
(31, '20201030-03', 'PAG-IBIG HOUSING LOAN', 6,false,0,1),
(56, '20201010', 'REMITTANCE OF WITHHOLDING TAX ON COMPENSATION', 1,true,0,1),

(1, 'CAD-413-3.3', 'CASH ADVANCE', 4,false,0,1),
(2, 'CEAP-84-311', 'COLLEGE EDUCATION ASSURANCE PLAN', 4,false,0,1),
(4, 'DBP-PR-439-2', 'DBP PREMIUMS', 2,false,0,1),
(5, 'DBP-PRL-84-312-A', 'NHMFC PNB S/A # 265-508638-5', 10,false,0,1),
(7, 'ESL-', 'Emergence Salary Loan (guessing)', 4,false,0,1),

(11, 'PAG-ML-411-06', 'PAG-IBIG HOUSING LOAN', 4,false,0,1),
(12, 'GLOBE-', 'Globe subscription', 3,false,0,1),
(14, 'GREAPA-439-3', 'GREAPA LIFE PREMIUM', 5,false,0,1),
(15, 'GREP-900-1.18', 'GREAT PACIFIC LIFE ASSURANCE CORPORATION', 12,false,0,1),
(16, 'GSL-413-03', 'GSIS SALARY LOAN', 4,false,0,1),
(17, 'GSLG-84-304', 'GSIS SALARY LOAN', 4,false,0,1),
(18, 'GSL-R-', 'HELP', 4,false,0,1),
(19, 'ILAC-439-4', 'INSULAR LIFE ASSURANCE COMPANY LTD.', 13,false,0,1),
(20, 'LBP-439-5', 'DEPOSIT', 7,false,0,1),
(21, 'LBP-RL-450-5', 'LBP REAL ESTATE LOAN', 7,false,0,1),
(22, 'LBP-SAL-439-6', 'REMITTANCE TO LBP', 7,false,0,1),

(24, 'LRP-BKPR-436', 'LIFE & RETIREMENT BACK PREMIUMS', 4,false,0,1),
(25, 'LSU-ADPA-439-1O-A', 'LSU-ADMIN PERSONNEL ASSOCIATION', 16,false,0,1),
(26, 'LSU-FA-439-10', 'LSU FACULTY ASSOCIATION', 18,false,0,1),
(27, 'LWOP-84-', 'LEAVE WITHOUT PAY', 16,false,0,1),
(28, 'MISC-439-11', 'HOUSING DEDUCTION', 16,false,0,3),
(29, 'MISC-E-439-25.5', 'REMITTANCE TO ELECTRIC BILL', 16,false,0,3),
(30, 'OPT-INS-84-303', 'OPTIONAL INSURANCE PREMIUM', 4,false,0,1),

(33, 'PAG-PL-84-309', 'PAG-IBIG PROVIDENT LOAN', 6,false,0,1),
(35, 'PHILAM-439-7', 'PHIL-AMERICAN LIFE INSURANCE PREMIUM', 8,false,0,1),
(36, 'PH-PR-413', 'MEDICARE', 9,true,0,1),
(37, 'PNB-SAL-84-314', 'PNB-SALARY LOAN', 10,false,0,1),
(38, 'PNP-ED-413-09.1', 'GSIS EDUC PLAN', 4,false,0,1),
(39, 'PNP-ED.-84-309-3', 'GSIS Pree-NEED PLAN(s)- EDUCATION PLAN', 4,false,0,1),
(40, 'PNP-EDC.-84-309-3', 'GSIS-Pre-Need Plans -EDUCATION PLAN', 4,false,0,1),
(41, 'PNP-M-413-09.2', 'GSIS Pre-NEED PLAN -Genesis Flexi', 4,false,0,1),
(42, 'REM-413-09.3', 'REAL ESTATE MORTGAGE LOAN', 4,false,0,1),
(43, 'REFUND-', 'Refund of something', 16,false,0,1),
(44, 'RF-161-84-113.2.1', 'REVOLVING FUND 161', 16,false,0,1),
(45, 'SAL-REF-439-12.19', 'REFUND OF SALARY', 16,false,0,1),
(46, 'SOS-413-8', 'SUMMER ONE MONTH SALARY LOAN', 4,false,0,1),
(47, 'SVLF-84-310', 'SVLF (SA # 010-531881-2/010-541609-1)', 10,false,0,1),
(48, 'TERM-84-309-1', 'TERM INSURANCE', 4,false,0,1),
(49, 'TERM-R-84-301', 'TERM INSURANCE PREMIUM', 4,false,0,1),
(50, 'TUITION-439-12.17', 'TUITION FEES', 16,false,0,1),

(52, 'UOLI-PR-413-02', 'UNLIMITED OPTIONAL LIFE INSURANCE PREMIUM', 4,false,0,1),
(53, 'UPLB-FEE-450-10', 'Payment of fees to UPLB', 14,false,0,1),
(54, 'VSUCDC-439-9', 'REMITTANCE TO VSUCC', 17,false,0,1),
(55, 'ViFARD-', 'ViFARD account', 15,false,0,1),

(57, 'WTAXREF-', 'REFUND OF EXCESS REMITTANCE OF TAXES WITHHELD', 1,false,0,1),
(58, 'VSU-BAK-', 'VSU BAKERY', 16,false,0,3);

--
-- Indexes for dumped tables
--
--
-- --
-- -- Indexes for table `ref_deduction`
-- --
-- ALTER TABLE `ref_deduction`
--   ADD PRIMARY KEY (`id`,false,0,1),
--   ADD KEY `ref_deduction_agency_id_foreign` (`agency_id`);
--
-- --
-- -- AUTO_INCREMENT for dumped tables
-- --
--
-- --
-- -- AUTO_INCREMENT for table `ref_deduction`
-- --
-- ALTER TABLE `ref_deduction`
--   MODIFY `id` int(10,1) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59;
-- --
-- -- Constraints for dumped tables
-- --
--
-- --
-- -- Constraints for table `ref_deduction`
-- --
-- ALTER TABLE `ref_deduction`
--   ADD CONSTRAINT `ref_deduction_agency_id_foreign` FOREIGN KEY (`agency_id`) REFERENCES `agencies` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
--
-- /*!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 */;
