-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               8.0.17 - MySQL Community Server - GPL
-- Server OS:                    Win64
-- HeidiSQL Version:             11.0.0.5919
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!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' */;


-- Dumping database structure for ehrmdemo
CREATE DATABASE IF NOT EXISTS `ehrmdemo` /*!40100 DEFAULT CHARACTER SET utf8 */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `ehrmdemo`;

-- Dumping structure for table ehrmdemo.auto_no
DROP TABLE IF EXISTS `auto_no`;
CREATE TABLE IF NOT EXISTS `auto_no` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `var` varchar(255) DEFAULT NULL,
  `sn_1` int(11) DEFAULT NULL,
  `sn_2` int(11) DEFAULT NULL,
  `sn_3` int(11) DEFAULT NULL,
  `sn_4` int(11) DEFAULT NULL,
  `sn_5` int(11) DEFAULT NULL,
  `sn_6` int(11) DEFAULT NULL,
  `sn_7` int(11) DEFAULT NULL,
  `sn_8` int(11) DEFAULT NULL,
  `sn_9` int(11) DEFAULT NULL,
  `remarks` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.bgt_detail
DROP TABLE IF EXISTS `bgt_detail`;
CREATE TABLE IF NOT EXISTS `bgt_detail` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `bgt_code` char(6) DEFAULT NULL,
  `bgt_year` year(4) DEFAULT NULL,
  `opex1` decimal(20,2) DEFAULT NULL,
  `opex2` decimal(20,2) DEFAULT NULL,
  `opex3` decimal(20,2) DEFAULT NULL,
  `opex4` decimal(20,2) DEFAULT NULL,
  `capex` decimal(20,2) DEFAULT NULL,
  `description` text,
  `submit_by` char(50) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  PRIMARY KEY (`auto_id`),
  UNIQUE KEY `Index 2` (`bgt_code`,`bgt_year`),
  CONSTRAINT `FK_bgt_detail_bgt_head` FOREIGN KEY (`bgt_code`) REFERENCES `bgt_head` (`bgt_code`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.bgt_group
DROP TABLE IF EXISTS `bgt_group`;
CREATE TABLE IF NOT EXISTS `bgt_group` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `grp_code` char(3) DEFAULT NULL,
  `grp_name` char(255) DEFAULT NULL,
  `access` text,
  `description` text,
  `submit_by` char(50) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  PRIMARY KEY (`auto_id`),
  UNIQUE KEY `Index 2` (`grp_code`),
  UNIQUE KEY `Index 3` (`grp_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.bgt_head
DROP TABLE IF EXISTS `bgt_head`;
CREATE TABLE IF NOT EXISTS `bgt_head` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `bgt_code` char(6) DEFAULT NULL,
  `bgt_name` char(255) DEFAULT NULL,
  `bgt_type` enum('OPEX','CAPEX') NOT NULL DEFAULT 'OPEX',
  `grp_code` char(3) DEFAULT NULL,
  `description` text,
  `submit_by` char(50) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  PRIMARY KEY (`auto_id`),
  UNIQUE KEY `Index 2` (`bgt_code`),
  UNIQUE KEY `Index 3` (`bgt_name`),
  KEY `FK_bgt_head_bgt_group` (`grp_code`),
  CONSTRAINT `FK_bgt_head_bgt_group` FOREIGN KEY (`grp_code`) REFERENCES `bgt_group` (`grp_code`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.bgt_trans
DROP TABLE IF EXISTS `bgt_trans`;
CREATE TABLE IF NOT EXISTS `bgt_trans` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `bgt_code` char(6) DEFAULT NULL,
  `trans_code` char(50) DEFAULT NULL,
  `trans_date` date DEFAULT NULL,
  `trans_detail` char(255) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `description` text,
  `submit_by` char(50) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  PRIMARY KEY (`auto_id`),
  UNIQUE KEY `Index 3` (`trans_code`),
  KEY `Index 2` (`bgt_code`),
  CONSTRAINT `FK_bgt_trans_bgt_head` FOREIGN KEY (`bgt_code`) REFERENCES `bgt_head` (`bgt_code`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_appraisal
DROP TABLE IF EXISTS `cod_appraisal`;
CREATE TABLE IF NOT EXISTS `cod_appraisal` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` char(20) NOT NULL,
  `username` varchar(100) NOT NULL,
  `directorate` varchar(100) DEFAULT NULL,
  `division` varchar(100) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `manager` varchar(255) DEFAULT NULL,
  `dept_head` varchar(255) DEFAULT NULL,
  `director` varchar(255) DEFAULT NULL,
  `job_grade` varchar(50) DEFAULT NULL,
  `job_step` varchar(2) DEFAULT NULL,
  `job_name` varchar(255) DEFAULT NULL,
  `job_category` varchar(50) DEFAULT NULL,
  `job_description` varchar(100) DEFAULT NULL,
  `remarks` mediumtext,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `title` varchar(15) DEFAULT NULL,
  `first_name` varchar(100) DEFAULT '',
  `middle_name` varchar(100) DEFAULT '',
  `last_name` varchar(100) DEFAULT '',
  `date_employment` date DEFAULT NULL,
  `date_confirm` date DEFAULT NULL,
  `date_pension` date DEFAULT NULL,
  `date_promotion` date DEFAULT NULL,
  `promotion_detail` varchar(255) DEFAULT NULL,
  `date_termination` date DEFAULT NULL,
  `appraisal` varchar(255) DEFAULT NULL,
  `appraisal_date` date DEFAULT NULL,
  `appraisal_status` int(2) DEFAULT '0',
  `manager_improve` mediumtext,
  `manager_improve_option` char(10) DEFAULT NULL,
  `manager_improve_action1` mediumtext,
  `manager_improve_action2` mediumtext,
  `manager_improve_action3` mediumtext,
  `manager_improve_action4` mediumtext,
  `manager_comment` mediumtext,
  `manager_comment_date` date DEFAULT NULL,
  `employee_comment` mediumtext,
  `employee_comment_date` date DEFAULT NULL,
  `manager_recommend` char(1) DEFAULT NULL,
  `manager_recommend_date` date DEFAULT NULL,
  `dept_head_recommend` char(1) DEFAULT NULL,
  `dept_head_recommend_date` date DEFAULT NULL,
  `dept_head_future` mediumtext,
  `dept_head_future_yes` mediumtext,
  `dept_head_future_no` mediumtext,
  `director_recommend` mediumtext,
  `director_recommend_date` date DEFAULT NULL,
  `hr_recommend` char(1) DEFAULT NULL,
  `hr_recommend_date` date DEFAULT NULL,
  `hr_comment` mediumtext,
  `hr_conduct` mediumtext,
  `hr_reason` mediumtext,
  `hr_username` varchar(50) DEFAULT NULL,
  `final_recommend` char(1) DEFAULT NULL,
  `final_recommend_date` date DEFAULT NULL,
  `final_comment` mediumtext,
  `final_username` varchar(50) DEFAULT NULL,
  `qualification1` varchar(255) DEFAULT NULL,
  `qualification2` varchar(255) DEFAULT NULL,
  `qualification3` varchar(255) DEFAULT NULL,
  `qualification4` varchar(255) DEFAULT NULL,
  `qualification5` varchar(255) DEFAULT NULL,
  `qualification6` varchar(255) DEFAULT NULL,
  `qualification7` varchar(255) DEFAULT NULL,
  `qualification8` varchar(255) DEFAULT NULL,
  `qualification9` varchar(255) DEFAULT NULL,
  `qualification10` varchar(255) DEFAULT NULL,
  `certification1` varchar(255) DEFAULT NULL,
  `certification2` varchar(255) DEFAULT NULL,
  `certification3` varchar(255) DEFAULT NULL,
  `certification4` varchar(255) DEFAULT NULL,
  `certification5` varchar(255) DEFAULT NULL,
  `certification6` varchar(255) DEFAULT NULL,
  `certification7` varchar(255) DEFAULT NULL,
  `certification8` varchar(255) DEFAULT NULL,
  `certification9` varchar(255) DEFAULT NULL,
  `certification10` varchar(255) DEFAULT NULL,
  `kpi1` mediumtext,
  `kpi2` mediumtext,
  `kpi3` mediumtext,
  `kpi4` mediumtext,
  `kpi5` mediumtext,
  `kpi6` mediumtext,
  `kpi7` mediumtext,
  `kpi8` mediumtext,
  `kpi9` mediumtext,
  `kpi10` mediumtext,
  `kpi11` mediumtext,
  `kpi12` mediumtext,
  `kpi13` mediumtext,
  `kpi14` mediumtext,
  `kpi15` mediumtext,
  `kpi16` mediumtext,
  `kpi17` mediumtext,
  `kpi18` mediumtext,
  `kpi19` mediumtext,
  `kpi20` mediumtext,
  `kpi21` mediumtext,
  `kpi22` mediumtext,
  `kpi23` mediumtext,
  `kpi24` mediumtext,
  `kpi25` mediumtext,
  `kpi26` mediumtext,
  `kpi27` mediumtext,
  `kpi28` mediumtext,
  `kpi29` mediumtext,
  `kpi30` mediumtext,
  `kpi31` mediumtext,
  `kpi32` mediumtext,
  `kpi33` mediumtext,
  `kpi34` mediumtext,
  `kpi35` mediumtext,
  `kpi36` mediumtext,
  `kpi37` mediumtext,
  `kpi38` mediumtext,
  `kpi39` mediumtext,
  `kpi40` mediumtext,
  `kpi41` mediumtext,
  `kpi42` mediumtext,
  `kpi43` mediumtext,
  `kpi44` mediumtext,
  `kpi45` mediumtext,
  `kpi46` mediumtext,
  `kpi47` mediumtext,
  `kpi48` mediumtext,
  `kpi49` mediumtext,
  `kpi50` mediumtext,
  `score1` mediumtext,
  `score2` mediumtext,
  `score3` mediumtext,
  `score4` mediumtext,
  `score5` mediumtext,
  `score6` mediumtext,
  `score7` mediumtext,
  `score8` mediumtext,
  `score9` mediumtext,
  `score10` mediumtext,
  `score11` mediumtext,
  `score12` mediumtext,
  `score13` mediumtext,
  `score14` mediumtext,
  `score15` mediumtext,
  `score16` mediumtext,
  `score17` mediumtext,
  `score18` mediumtext,
  `score19` mediumtext,
  `score20` mediumtext,
  `score21` mediumtext,
  `score22` mediumtext,
  `score23` mediumtext,
  `score24` mediumtext,
  `score25` mediumtext,
  `score26` mediumtext,
  `score27` mediumtext,
  `score28` mediumtext,
  `score29` mediumtext,
  `score30` mediumtext,
  `score31` mediumtext,
  `score32` mediumtext,
  `score33` mediumtext,
  `score34` mediumtext,
  `score35` mediumtext,
  `score36` mediumtext,
  `score37` mediumtext,
  `score38` mediumtext,
  `score39` mediumtext,
  `score40` mediumtext,
  `score41` mediumtext,
  `score42` mediumtext,
  `score43` mediumtext,
  `score44` mediumtext,
  `score45` mediumtext,
  `score46` mediumtext,
  `score47` mediumtext,
  `score48` mediumtext,
  `score49` mediumtext,
  `score50` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB AUTO_INCREMENT=188 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_bank
DROP TABLE IF EXISTS `cod_bank`;
CREATE TABLE IF NOT EXISTS `cod_bank` (
  `auto_id` int(10) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) DEFAULT NULL,
  `bank` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_category
DROP TABLE IF EXISTS `cod_category`;
CREATE TABLE IF NOT EXISTS `cod_category` (
  `auto_id` int(10) NOT NULL AUTO_INCREMENT,
  `code` char(10) DEFAULT NULL,
  `category` char(200) DEFAULT NULL,
  `def_annual_leave` tinyint(4) DEFAULT '0',
  `def_casual_leave` tinyint(4) DEFAULT '0',
  `def_maternity_leave` tinyint(4) DEFAULT '0',
  `def_sick_leave` tinyint(4) DEFAULT '0',
  `def_study_leave` tinyint(4) DEFAULT '0',
  `submit_by` char(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`),
  UNIQUE KEY `Index 2` (`code`),
  UNIQUE KEY `Index 3` (`category`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_coop
DROP TABLE IF EXISTS `cod_coop`;
CREATE TABLE IF NOT EXISTS `cod_coop` (
  `auto_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(20) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `division` varchar(100) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `job_grade` varchar(50) DEFAULT NULL,
  `job_name` varchar(255) DEFAULT NULL,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `title` varchar(15) DEFAULT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `middle_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `payroll_code` varchar(15) DEFAULT NULL,
  `payroll_name` varchar(100) DEFAULT NULL,
  `coop_code` varchar(20) DEFAULT NULL,
  `coop_date` datetime DEFAULT NULL,
  `coop_status` varchar(1) DEFAULT '1',
  `remarks` mediumtext,
  `coop_amount` decimal(19,4) DEFAULT NULL,
  `coop_deposit` decimal(19,4) DEFAULT NULL,
  `coop_interest` double DEFAULT '0',
  `coop_period` int(11) DEFAULT '0',
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_coop_log
DROP TABLE IF EXISTS `cod_coop_log`;
CREATE TABLE IF NOT EXISTS `cod_coop_log` (
  `auto_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(20) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `payroll_code` varchar(15) DEFAULT NULL,
  `payroll_name` varchar(100) DEFAULT NULL,
  `coop_code` varchar(20) DEFAULT NULL,
  `coop_trans_date` datetime DEFAULT NULL,
  `coop_monthly` decimal(19,4) DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_department
DROP TABLE IF EXISTS `cod_department`;
CREATE TABLE IF NOT EXISTS `cod_department` (
  `auto_id` int(10) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `directorate` varchar(100) DEFAULT NULL,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_directorate
DROP TABLE IF EXISTS `cod_directorate`;
CREATE TABLE IF NOT EXISTS `cod_directorate` (
  `auto_id` int(10) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) DEFAULT NULL,
  `directorate` varchar(100) DEFAULT NULL,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_discipline
DROP TABLE IF EXISTS `cod_discipline`;
CREATE TABLE IF NOT EXISTS `cod_discipline` (
  `auto_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(20) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `division` varchar(100) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `job_grade` varchar(50) DEFAULT NULL,
  `job_name` varchar(255) DEFAULT NULL,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `title` varchar(15) DEFAULT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `middle_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `payroll_code` varchar(15) DEFAULT NULL,
  `payroll_name` varchar(100) DEFAULT NULL,
  `discipline_code` varchar(20) DEFAULT NULL,
  `discipline_date` datetime DEFAULT NULL,
  `discipline_status` varchar(1) DEFAULT '1',
  `remarks` mediumtext,
  `discipline_amount` decimal(19,4) DEFAULT NULL,
  `discipline_deposit` decimal(19,4) DEFAULT NULL,
  `discipline_interest` double DEFAULT '0',
  `discipline_period` int(11) DEFAULT '0',
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_discipline_log
DROP TABLE IF EXISTS `cod_discipline_log`;
CREATE TABLE IF NOT EXISTS `cod_discipline_log` (
  `auto_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(20) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `payroll_code` varchar(15) DEFAULT NULL,
  `payroll_name` varchar(100) DEFAULT NULL,
  `discipline_code` varchar(20) DEFAULT NULL,
  `discipline_trans_date` datetime DEFAULT NULL,
  `discipline_monthly` decimal(19,4) DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_division
DROP TABLE IF EXISTS `cod_division`;
CREATE TABLE IF NOT EXISTS `cod_division` (
  `auto_id` int(10) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) DEFAULT NULL,
  `division` varchar(255) DEFAULT NULL,
  `account_code` varchar(10) DEFAULT NULL,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_flow
DROP TABLE IF EXISTS `cod_flow`;
CREATE TABLE IF NOT EXISTS `cod_flow` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` char(50) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `trans_date` datetime DEFAULT NULL,
  `msg_title` varchar(1000) DEFAULT NULL,
  `msg_id` int(11) DEFAULT NULL,
  `msg_type` varchar(10) DEFAULT NULL,
  `msg_status` varchar(10) DEFAULT NULL,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_flow_log
DROP TABLE IF EXISTS `cod_flow_log`;
CREATE TABLE IF NOT EXISTS `cod_flow_log` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` char(50) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `msg_id` bigint(20) DEFAULT NULL,
  `msg_sort` int(11) DEFAULT NULL,
  `trans_date` datetime DEFAULT NULL,
  `user_id_from` varchar(20) DEFAULT NULL,
  `username_from` varchar(100) DEFAULT NULL,
  `user_id_to` varchar(20) DEFAULT NULL,
  `username_to` varchar(100) DEFAULT NULL,
  `username_cc` varchar(1000) DEFAULT NULL,
  `msg_security` varchar(10) DEFAULT NULL,
  `msg_memo` longtext,
  `msg_attach_0` varchar(255) DEFAULT NULL,
  `msg_attach_1` varchar(255) DEFAULT NULL,
  `msg_attach_2` varchar(255) DEFAULT NULL,
  `msg_attach_3` varchar(255) DEFAULT NULL,
  `msg_attach_4` varchar(255) DEFAULT NULL,
  `msg_attach_5` varchar(255) DEFAULT NULL,
  `msg_attach_6` varchar(255) DEFAULT NULL,
  `msg_attach_7` varchar(255) DEFAULT NULL,
  `msg_attach_8` varchar(255) DEFAULT NULL,
  `msg_attach_9` varchar(255) DEFAULT NULL,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_leave
DROP TABLE IF EXISTS `cod_leave`;
CREATE TABLE IF NOT EXISTS `cod_leave` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` char(20) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `division` varchar(100) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `title` varchar(15) DEFAULT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `middle_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `max_leave` int(11) DEFAULT NULL,
  `leave_approval` mediumtext,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` mediumtext,
  `leave_year` char(4) DEFAULT NULL,
  `leave_year_id` varchar(100) NOT NULL,
  `leave_allowance` char(1) DEFAULT NULL,
  `leave_openbalance` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`auto_id`),
  UNIQUE KEY `Index 2` (`leave_year_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_leave_log
DROP TABLE IF EXISTS `cod_leave_log`;
CREATE TABLE IF NOT EXISTS `cod_leave_log` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` char(20) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `trans_date` datetime DEFAULT NULL,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` mediumtext,
  `leave_year` char(4) DEFAULT NULL,
  `leave_year_id` varchar(100) DEFAULT NULL,
  `leave_id` bigint(20) NOT NULL,
  `leave_type` char(50) DEFAULT NULL,
  `leave_title` varchar(255) DEFAULT NULL,
  `leave_start` datetime DEFAULT NULL,
  `leave_end` datetime DEFAULT NULL,
  `leave_status` char(50) DEFAULT NULL,
  PRIMARY KEY (`auto_id`),
  UNIQUE KEY `Index 2` (`leave_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_leave_memo
DROP TABLE IF EXISTS `cod_leave_memo`;
CREATE TABLE IF NOT EXISTS `cod_leave_memo` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` char(20) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `user_id_from` char(20) DEFAULT NULL,
  `username_from` varchar(100) DEFAULT NULL,
  `user_id_to` char(20) DEFAULT NULL,
  `username_to` varchar(100) DEFAULT NULL,
  `trans_date` datetime DEFAULT NULL,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` mediumtext,
  `leave_year` char(4) DEFAULT NULL,
  `leave_year_id` varchar(100) DEFAULT NULL,
  `leave_id` bigint(20) DEFAULT NULL,
  `leave_sort` int(11) DEFAULT NULL,
  `leave_memo` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_loan
DROP TABLE IF EXISTS `cod_loan`;
CREATE TABLE IF NOT EXISTS `cod_loan` (
  `auto_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(20) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `division` varchar(100) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `job_grade` varchar(50) DEFAULT NULL,
  `job_name` varchar(255) DEFAULT NULL,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `title` varchar(15) DEFAULT NULL,
  `first_name` varchar(100) DEFAULT NULL,
  `middle_name` varchar(100) DEFAULT NULL,
  `last_name` varchar(100) DEFAULT NULL,
  `payroll_code` varchar(15) DEFAULT NULL,
  `payroll_name` varchar(100) DEFAULT NULL,
  `loan_code` varchar(20) DEFAULT NULL,
  `loan_date` datetime DEFAULT NULL,
  `loan_status` varchar(1) DEFAULT '1',
  `remarks` mediumtext,
  `loan_amount` decimal(19,4) DEFAULT NULL,
  `loan_deposit` decimal(19,4) DEFAULT NULL,
  `loan_interest` double DEFAULT '0',
  `loan_period` int(11) DEFAULT '0',
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_loan_log
DROP TABLE IF EXISTS `cod_loan_log`;
CREATE TABLE IF NOT EXISTS `cod_loan_log` (
  `auto_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(20) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `payroll_code` varchar(15) DEFAULT NULL,
  `payroll_name` varchar(100) DEFAULT NULL,
  `loan_code` varchar(20) DEFAULT NULL,
  `loan_trans_date` datetime DEFAULT NULL,
  `loan_monthly` decimal(19,4) DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_nhf
DROP TABLE IF EXISTS `cod_nhf`;
CREATE TABLE IF NOT EXISTS `cod_nhf` (
  `auto_id` int(10) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) DEFAULT NULL,
  `nhf` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_payroll
DROP TABLE IF EXISTS `cod_payroll`;
CREATE TABLE IF NOT EXISTS `cod_payroll` (
  `auto_id` int(10) NOT NULL AUTO_INCREMENT,
  `job_grade` varchar(50) DEFAULT NULL,
  `job_name` varchar(255) DEFAULT NULL,
  `grade_type` varchar(10) DEFAULT '100%',
  `allowance1` decimal(19,4) DEFAULT '0.0000',
  `allowance2` decimal(19,4) DEFAULT '0.0000',
  `allowance3` decimal(19,4) DEFAULT '0.0000',
  `allowance4` decimal(19,4) DEFAULT '0.0000',
  `allowance5` decimal(19,4) DEFAULT '0.0000',
  `allowance6` decimal(19,4) DEFAULT '0.0000',
  `allowance7` decimal(19,4) DEFAULT '0.0000',
  `allowance8` decimal(19,4) DEFAULT '0.0000',
  `allowance9` decimal(19,4) DEFAULT '0.0000',
  `allowance10` decimal(19,4) DEFAULT '0.0000',
  `allowance11` decimal(19,4) DEFAULT '0.0000',
  `allowance12` decimal(19,4) DEFAULT '0.0000',
  `allowance13` decimal(19,4) DEFAULT '0.0000',
  `allowance14` decimal(19,4) DEFAULT '0.0000',
  `allowance15` decimal(19,4) DEFAULT '0.0000',
  `allowance16` decimal(19,4) DEFAULT '0.0000',
  `allowance17` decimal(19,4) DEFAULT '0.0000',
  `allowance18` decimal(19,4) DEFAULT '0.0000',
  `allowance19` decimal(19,4) DEFAULT '0.0000',
  `allowance20` decimal(19,4) DEFAULT '0.0000',
  `allowance21` decimal(19,4) DEFAULT '0.0000',
  `allowance22` decimal(19,4) DEFAULT '0.0000',
  `allowance23` decimal(19,4) DEFAULT '0.0000',
  `allowance24` decimal(19,4) DEFAULT '0.0000',
  `allowance25` decimal(19,4) DEFAULT '0.0000',
  `allowance26` decimal(19,4) DEFAULT '0.0000',
  `allowance27` decimal(19,4) DEFAULT '0.0000',
  `allowance28` decimal(19,4) DEFAULT '0.0000',
  `allowance29` decimal(19,4) DEFAULT '0.0000',
  `allowance30` decimal(19,4) DEFAULT '0.0000',
  `allowance31` decimal(19,4) DEFAULT '0.0000',
  `allowance32` decimal(19,4) DEFAULT '0.0000',
  `allowance33` decimal(19,4) DEFAULT '0.0000',
  `allowance34` decimal(19,4) DEFAULT '0.0000',
  `allowance35` decimal(19,4) DEFAULT '0.0000',
  `allowance36` decimal(19,4) DEFAULT '0.0000',
  `allowance37` decimal(19,4) DEFAULT '0.0000',
  `allowance38` decimal(19,4) DEFAULT '0.0000',
  `allowance39` decimal(19,4) DEFAULT '0.0000',
  `allowance40` decimal(19,4) DEFAULT '0.0000',
  `allowance41` decimal(19,4) DEFAULT '0.0000',
  `allowance42` decimal(19,4) DEFAULT '0.0000',
  `allowance43` decimal(19,4) DEFAULT '0.0000',
  `allowance44` decimal(19,4) DEFAULT '0.0000',
  `allowance45` decimal(19,4) DEFAULT '0.0000',
  `allowance46` decimal(19,4) DEFAULT '0.0000',
  `allowance47` decimal(19,4) DEFAULT '0.0000',
  `allowance48` decimal(19,4) DEFAULT '0.0000',
  `allowance49` decimal(19,4) DEFAULT '0.0000',
  `allowance50` decimal(19,4) DEFAULT '0.0000',
  `allowance51` decimal(19,4) DEFAULT '0.0000',
  `allowance52` decimal(19,4) DEFAULT '0.0000',
  `allowance53` decimal(19,4) DEFAULT '0.0000',
  `allowance54` decimal(19,4) DEFAULT '0.0000',
  `allowance55` decimal(19,4) DEFAULT '0.0000',
  `allowance56` decimal(19,4) DEFAULT '0.0000',
  `allowance57` decimal(19,4) DEFAULT '0.0000',
  `allowance58` decimal(19,4) DEFAULT '0.0000',
  `allowance59` decimal(19,4) DEFAULT '0.0000',
  `allowance60` decimal(19,4) DEFAULT '0.0000',
  `allowance61` decimal(19,4) DEFAULT '0.0000',
  `allowance62` decimal(19,4) DEFAULT '0.0000',
  `allowance63` decimal(19,4) DEFAULT '0.0000',
  `allowance64` decimal(19,4) DEFAULT '0.0000',
  `allowance65` decimal(19,4) DEFAULT '0.0000',
  `allowance66` decimal(19,4) DEFAULT '0.0000',
  `allowance67` decimal(19,4) DEFAULT '0.0000',
  `allowance68` decimal(19,4) DEFAULT '0.0000',
  `allowance69` decimal(19,4) DEFAULT '0.0000',
  `allowance70` decimal(19,4) DEFAULT '0.0000',
  `allowance71` decimal(19,4) DEFAULT '0.0000',
  `allowance72` decimal(19,4) DEFAULT '0.0000',
  `allowance73` decimal(19,4) DEFAULT '0.0000',
  `allowance74` decimal(19,4) DEFAULT '0.0000',
  `allowance75` decimal(19,4) DEFAULT '0.0000',
  `allowance76` decimal(19,4) DEFAULT '0.0000',
  `allowance77` decimal(19,4) DEFAULT '0.0000',
  `allowance78` decimal(19,4) DEFAULT '0.0000',
  `allowance79` decimal(19,4) DEFAULT '0.0000',
  `allowance80` decimal(19,4) DEFAULT '0.0000',
  `allowance81` decimal(19,4) DEFAULT '0.0000',
  `allowance82` decimal(19,4) DEFAULT '0.0000',
  `allowance83` decimal(19,4) DEFAULT '0.0000',
  `allowance84` decimal(19,4) DEFAULT '0.0000',
  `allowance85` decimal(19,4) DEFAULT '0.0000',
  `allowance86` decimal(19,4) DEFAULT '0.0000',
  `allowance87` decimal(19,4) DEFAULT '0.0000',
  `allowance88` decimal(19,4) DEFAULT '0.0000',
  `allowance89` decimal(19,4) DEFAULT '0.0000',
  `allowance90` decimal(19,4) DEFAULT '0.0000',
  `allowance91` decimal(19,4) DEFAULT '0.0000',
  `allowance92` decimal(19,4) DEFAULT '0.0000',
  `allowance93` decimal(19,4) DEFAULT '0.0000',
  `allowance94` decimal(19,4) DEFAULT '0.0000',
  `allowance95` decimal(19,4) DEFAULT '0.0000',
  `allowance96` decimal(19,4) DEFAULT '0.0000',
  `allowance97` decimal(19,4) DEFAULT '0.0000',
  `allowance98` decimal(19,4) DEFAULT '0.0000',
  `allowance99` decimal(19,4) DEFAULT '0.0000',
  `allowance100` decimal(19,4) DEFAULT '0.0000',
  `deduction1` decimal(19,4) DEFAULT '0.0000',
  `deduction2` decimal(19,4) DEFAULT '0.0000',
  `deduction3` decimal(19,4) DEFAULT '0.0000',
  `deduction4` decimal(19,4) DEFAULT '0.0000',
  `deduction5` decimal(19,4) DEFAULT '0.0000',
  `deduction6` decimal(19,4) DEFAULT '0.0000',
  `deduction7` decimal(19,4) DEFAULT '0.0000',
  `deduction8` decimal(19,4) DEFAULT '0.0000',
  `deduction9` decimal(19,4) DEFAULT '0.0000',
  `deduction10` decimal(19,4) DEFAULT '0.0000',
  `deduction11` decimal(19,4) DEFAULT '0.0000',
  `deduction12` decimal(19,4) DEFAULT '0.0000',
  `deduction13` decimal(19,4) DEFAULT '0.0000',
  `deduction14` decimal(19,4) DEFAULT '0.0000',
  `deduction15` decimal(19,4) DEFAULT '0.0000',
  `deduction16` decimal(19,4) DEFAULT '0.0000',
  `deduction17` decimal(19,4) DEFAULT '0.0000',
  `deduction18` decimal(19,4) DEFAULT '0.0000',
  `deduction19` decimal(19,4) DEFAULT '0.0000',
  `deduction20` decimal(19,4) DEFAULT '0.0000',
  `deduction21` decimal(19,4) DEFAULT '0.0000',
  `deduction22` decimal(19,4) DEFAULT '0.0000',
  `deduction23` decimal(19,4) DEFAULT '0.0000',
  `deduction24` decimal(19,4) DEFAULT '0.0000',
  `deduction25` decimal(19,4) DEFAULT '0.0000',
  `deduction26` decimal(19,4) DEFAULT '0.0000',
  `deduction27` decimal(19,4) DEFAULT '0.0000',
  `deduction28` decimal(19,4) DEFAULT '0.0000',
  `deduction29` decimal(19,4) DEFAULT '0.0000',
  `deduction30` decimal(19,4) DEFAULT '0.0000',
  `deduction31` decimal(19,4) DEFAULT '0.0000',
  `deduction32` decimal(19,4) DEFAULT '0.0000',
  `deduction33` decimal(19,4) DEFAULT '0.0000',
  `deduction34` decimal(19,4) DEFAULT '0.0000',
  `deduction35` decimal(19,4) DEFAULT '0.0000',
  `deduction36` decimal(19,4) DEFAULT '0.0000',
  `deduction37` decimal(19,4) DEFAULT '0.0000',
  `deduction38` decimal(19,4) DEFAULT '0.0000',
  `deduction39` decimal(19,4) DEFAULT '0.0000',
  `deduction40` decimal(19,4) DEFAULT '0.0000',
  `deduction41` decimal(19,4) DEFAULT '0.0000',
  `deduction42` decimal(19,4) DEFAULT '0.0000',
  `deduction43` decimal(19,4) DEFAULT '0.0000',
  `deduction44` decimal(19,4) DEFAULT '0.0000',
  `deduction45` decimal(19,4) DEFAULT '0.0000',
  `deduction46` decimal(19,4) DEFAULT '0.0000',
  `deduction47` decimal(19,4) DEFAULT '0.0000',
  `deduction48` decimal(19,4) DEFAULT '0.0000',
  `deduction49` decimal(19,4) DEFAULT '0.0000',
  `deduction50` decimal(19,4) DEFAULT '0.0000',
  `deduction51` decimal(19,4) DEFAULT '0.0000',
  `deduction52` decimal(19,4) DEFAULT '0.0000',
  `deduction53` decimal(19,4) DEFAULT '0.0000',
  `deduction54` decimal(19,4) DEFAULT '0.0000',
  `deduction55` decimal(19,4) DEFAULT '0.0000',
  `deduction56` decimal(19,4) DEFAULT '0.0000',
  `deduction57` decimal(19,4) DEFAULT '0.0000',
  `deduction58` decimal(19,4) DEFAULT '0.0000',
  `deduction59` decimal(19,4) DEFAULT '0.0000',
  `deduction60` decimal(19,4) DEFAULT '0.0000',
  `deduction61` decimal(19,4) DEFAULT '0.0000',
  `deduction62` decimal(19,4) DEFAULT '0.0000',
  `deduction63` decimal(19,4) DEFAULT '0.0000',
  `deduction64` decimal(19,4) DEFAULT '0.0000',
  `deduction65` decimal(19,4) DEFAULT '0.0000',
  `deduction66` decimal(19,4) DEFAULT '0.0000',
  `deduction67` decimal(19,4) DEFAULT '0.0000',
  `deduction68` decimal(19,4) DEFAULT '0.0000',
  `deduction69` decimal(19,4) DEFAULT '0.0000',
  `deduction70` decimal(19,4) DEFAULT '0.0000',
  `deduction71` decimal(19,4) DEFAULT '0.0000',
  `deduction72` decimal(19,4) DEFAULT '0.0000',
  `deduction73` decimal(19,4) DEFAULT '0.0000',
  `deduction74` decimal(19,4) DEFAULT '0.0000',
  `deduction75` decimal(19,4) DEFAULT '0.0000',
  `deduction76` decimal(19,4) DEFAULT '0.0000',
  `deduction77` decimal(19,4) DEFAULT '0.0000',
  `deduction78` decimal(19,4) DEFAULT '0.0000',
  `deduction79` decimal(19,4) DEFAULT '0.0000',
  `deduction80` decimal(19,4) DEFAULT '0.0000',
  `deduction81` decimal(19,4) DEFAULT '0.0000',
  `deduction82` decimal(19,4) DEFAULT '0.0000',
  `deduction83` decimal(19,4) DEFAULT '0.0000',
  `deduction84` decimal(19,4) DEFAULT '0.0000',
  `deduction85` decimal(19,4) DEFAULT '0.0000',
  `deduction86` decimal(19,4) DEFAULT '0.0000',
  `deduction87` decimal(19,4) DEFAULT '0.0000',
  `deduction88` decimal(19,4) DEFAULT '0.0000',
  `deduction89` decimal(19,4) DEFAULT '0.0000',
  `deduction90` decimal(19,4) DEFAULT '0.0000',
  `deduction91` decimal(19,4) DEFAULT '0.0000',
  `deduction92` decimal(19,4) DEFAULT '0.0000',
  `deduction93` decimal(19,4) DEFAULT '0.0000',
  `deduction94` decimal(19,4) DEFAULT '0.0000',
  `deduction95` decimal(19,4) DEFAULT '0.0000',
  `deduction96` decimal(19,4) DEFAULT '0.0000',
  `deduction97` decimal(19,4) DEFAULT '0.0000',
  `deduction98` decimal(19,4) DEFAULT '0.0000',
  `deduction99` decimal(19,4) DEFAULT '0.0000',
  `deduction100` decimal(19,4) DEFAULT '0.0000',
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_payroll_log
DROP TABLE IF EXISTS `cod_payroll_log`;
CREATE TABLE IF NOT EXISTS `cod_payroll_log` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` char(20) NOT NULL,
  `username` varchar(100) NOT NULL,
  `division` varchar(100) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `job_grade` varchar(50) DEFAULT NULL,
  `job_name` varchar(255) DEFAULT NULL,
  `grade_type` varchar(10) DEFAULT '100%',
  `remarks` mediumtext,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `title` varchar(15) DEFAULT NULL,
  `first_name` varchar(100) DEFAULT '',
  `middle_name` varchar(100) DEFAULT '',
  `last_name` varchar(100) DEFAULT '',
  `bank_name` varchar(255) DEFAULT NULL,
  `bank_address` varchar(255) DEFAULT NULL,
  `account_name` varchar(255) DEFAULT NULL,
  `account_number` varchar(50) DEFAULT NULL,
  `PFA` varchar(255) DEFAULT NULL,
  `NHF` varchar(255) DEFAULT NULL,
  `payroll_date` datetime DEFAULT NULL,
  `approved_by` char(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `approved_on` datetime DEFAULT NULL,
  `verified_by` char(100) DEFAULT NULL,
  `verified_on` datetime DEFAULT NULL,
  `allowance1` decimal(19,4) DEFAULT '0.0000',
  `allowance2` decimal(19,4) DEFAULT '0.0000',
  `allowance3` decimal(19,4) DEFAULT '0.0000',
  `allowance4` decimal(19,4) DEFAULT '0.0000',
  `allowance5` decimal(19,4) DEFAULT '0.0000',
  `allowance6` decimal(19,4) DEFAULT '0.0000',
  `allowance7` decimal(19,4) DEFAULT '0.0000',
  `allowance8` decimal(19,4) DEFAULT '0.0000',
  `allowance9` decimal(19,4) DEFAULT '0.0000',
  `allowance10` decimal(19,4) DEFAULT '0.0000',
  `allowance11` decimal(19,4) DEFAULT '0.0000',
  `allowance12` decimal(19,4) DEFAULT '0.0000',
  `allowance13` decimal(19,4) DEFAULT '0.0000',
  `allowance14` decimal(19,4) DEFAULT '0.0000',
  `allowance15` decimal(19,4) DEFAULT '0.0000',
  `allowance16` decimal(19,4) DEFAULT '0.0000',
  `allowance17` decimal(19,4) DEFAULT '0.0000',
  `allowance18` decimal(19,4) DEFAULT '0.0000',
  `allowance19` decimal(19,4) DEFAULT '0.0000',
  `allowance20` decimal(19,4) DEFAULT '0.0000',
  `allowance21` decimal(19,4) DEFAULT '0.0000',
  `allowance22` decimal(19,4) DEFAULT '0.0000',
  `allowance23` decimal(19,4) DEFAULT '0.0000',
  `allowance24` decimal(19,4) DEFAULT '0.0000',
  `allowance25` decimal(19,4) DEFAULT '0.0000',
  `allowance26` decimal(19,4) DEFAULT '0.0000',
  `allowance27` decimal(19,4) DEFAULT '0.0000',
  `allowance28` decimal(19,4) DEFAULT '0.0000',
  `allowance29` decimal(19,4) DEFAULT '0.0000',
  `allowance30` decimal(19,4) DEFAULT '0.0000',
  `allowance31` decimal(19,4) DEFAULT '0.0000',
  `allowance32` decimal(19,4) DEFAULT '0.0000',
  `allowance33` decimal(19,4) DEFAULT '0.0000',
  `allowance34` decimal(19,4) DEFAULT '0.0000',
  `allowance35` decimal(19,4) DEFAULT '0.0000',
  `allowance36` decimal(19,4) DEFAULT '0.0000',
  `allowance37` decimal(19,4) DEFAULT '0.0000',
  `allowance38` decimal(19,4) DEFAULT '0.0000',
  `allowance39` decimal(19,4) DEFAULT '0.0000',
  `allowance40` decimal(19,4) DEFAULT '0.0000',
  `allowance41` decimal(19,4) DEFAULT '0.0000',
  `allowance42` decimal(19,4) DEFAULT '0.0000',
  `allowance43` decimal(19,4) DEFAULT '0.0000',
  `allowance44` decimal(19,4) DEFAULT '0.0000',
  `allowance45` decimal(19,4) DEFAULT '0.0000',
  `allowance46` decimal(19,4) DEFAULT '0.0000',
  `allowance47` decimal(19,4) DEFAULT '0.0000',
  `allowance48` decimal(19,4) DEFAULT '0.0000',
  `allowance49` decimal(19,4) DEFAULT '0.0000',
  `allowance50` decimal(19,4) DEFAULT '0.0000',
  `allowance51` decimal(19,4) DEFAULT '0.0000',
  `allowance52` decimal(19,4) DEFAULT '0.0000',
  `allowance53` decimal(19,4) DEFAULT '0.0000',
  `allowance54` decimal(19,4) DEFAULT '0.0000',
  `allowance55` decimal(19,4) DEFAULT '0.0000',
  `allowance56` decimal(19,4) DEFAULT '0.0000',
  `allowance57` decimal(19,4) DEFAULT '0.0000',
  `allowance58` decimal(19,4) DEFAULT '0.0000',
  `allowance59` decimal(19,4) DEFAULT '0.0000',
  `allowance60` decimal(19,4) DEFAULT '0.0000',
  `allowance61` decimal(19,4) DEFAULT '0.0000',
  `allowance62` decimal(19,4) DEFAULT '0.0000',
  `allowance63` decimal(19,4) DEFAULT '0.0000',
  `allowance64` decimal(19,4) DEFAULT '0.0000',
  `allowance65` decimal(19,4) DEFAULT '0.0000',
  `allowance66` decimal(19,4) DEFAULT '0.0000',
  `allowance67` decimal(19,4) DEFAULT '0.0000',
  `allowance68` decimal(19,4) DEFAULT '0.0000',
  `allowance69` decimal(19,4) DEFAULT '0.0000',
  `allowance70` decimal(19,4) DEFAULT '0.0000',
  `allowance71` decimal(19,4) DEFAULT '0.0000',
  `allowance72` decimal(19,4) DEFAULT '0.0000',
  `allowance73` decimal(19,4) DEFAULT '0.0000',
  `allowance74` decimal(19,4) DEFAULT '0.0000',
  `allowance75` decimal(19,4) DEFAULT '0.0000',
  `allowance76` decimal(19,4) DEFAULT '0.0000',
  `allowance77` decimal(19,4) DEFAULT '0.0000',
  `allowance78` decimal(19,4) DEFAULT '0.0000',
  `allowance79` decimal(19,4) DEFAULT '0.0000',
  `allowance80` decimal(19,4) DEFAULT '0.0000',
  `allowance81` decimal(19,4) DEFAULT '0.0000',
  `allowance82` decimal(19,4) DEFAULT '0.0000',
  `allowance83` decimal(19,4) DEFAULT '0.0000',
  `allowance84` decimal(19,4) DEFAULT '0.0000',
  `allowance85` decimal(19,4) DEFAULT '0.0000',
  `allowance86` decimal(19,4) DEFAULT '0.0000',
  `allowance87` decimal(19,4) DEFAULT '0.0000',
  `allowance88` decimal(19,4) DEFAULT '0.0000',
  `allowance89` decimal(19,4) DEFAULT '0.0000',
  `allowance90` decimal(19,4) DEFAULT '0.0000',
  `allowance91` decimal(19,4) DEFAULT '0.0000',
  `allowance92` decimal(19,4) DEFAULT '0.0000',
  `allowance93` decimal(19,4) DEFAULT '0.0000',
  `allowance94` decimal(19,4) DEFAULT '0.0000',
  `allowance95` decimal(19,4) DEFAULT '0.0000',
  `allowance96` decimal(19,4) DEFAULT '0.0000',
  `allowance97` decimal(19,4) DEFAULT '0.0000',
  `allowance98` decimal(19,4) DEFAULT '0.0000',
  `allowance99` decimal(19,4) DEFAULT '0.0000',
  `allowance100` decimal(19,4) DEFAULT '0.0000',
  `deduction1` decimal(19,4) DEFAULT '0.0000',
  `deduction2` decimal(19,4) DEFAULT '0.0000',
  `deduction3` decimal(19,4) DEFAULT '0.0000',
  `deduction4` decimal(19,4) DEFAULT '0.0000',
  `deduction5` decimal(19,4) DEFAULT '0.0000',
  `deduction6` decimal(19,4) DEFAULT '0.0000',
  `deduction7` decimal(19,4) DEFAULT '0.0000',
  `deduction8` decimal(19,4) DEFAULT '0.0000',
  `deduction9` decimal(19,4) DEFAULT '0.0000',
  `deduction10` decimal(19,4) DEFAULT '0.0000',
  `deduction11` decimal(19,4) DEFAULT '0.0000',
  `deduction12` decimal(19,4) DEFAULT '0.0000',
  `deduction13` decimal(19,4) DEFAULT '0.0000',
  `deduction14` decimal(19,4) DEFAULT '0.0000',
  `deduction15` decimal(19,4) DEFAULT '0.0000',
  `deduction16` decimal(19,4) DEFAULT '0.0000',
  `deduction17` decimal(19,4) DEFAULT '0.0000',
  `deduction18` decimal(19,4) DEFAULT '0.0000',
  `deduction19` decimal(19,4) DEFAULT '0.0000',
  `deduction20` decimal(19,4) DEFAULT '0.0000',
  `deduction21` decimal(19,4) DEFAULT '0.0000',
  `deduction22` decimal(19,4) DEFAULT '0.0000',
  `deduction23` decimal(19,4) DEFAULT '0.0000',
  `deduction24` decimal(19,4) DEFAULT '0.0000',
  `deduction25` decimal(19,4) DEFAULT '0.0000',
  `deduction26` decimal(19,4) DEFAULT '0.0000',
  `deduction27` decimal(19,4) DEFAULT '0.0000',
  `deduction28` decimal(19,4) DEFAULT '0.0000',
  `deduction29` decimal(19,4) DEFAULT '0.0000',
  `deduction30` decimal(19,4) DEFAULT '0.0000',
  `deduction31` decimal(19,4) DEFAULT '0.0000',
  `deduction32` decimal(19,4) DEFAULT '0.0000',
  `deduction33` decimal(19,4) DEFAULT '0.0000',
  `deduction34` decimal(19,4) DEFAULT '0.0000',
  `deduction35` decimal(19,4) DEFAULT '0.0000',
  `deduction36` decimal(19,4) DEFAULT '0.0000',
  `deduction37` decimal(19,4) DEFAULT '0.0000',
  `deduction38` decimal(19,4) DEFAULT '0.0000',
  `deduction39` decimal(19,4) DEFAULT '0.0000',
  `deduction40` decimal(19,4) DEFAULT '0.0000',
  `deduction41` decimal(19,4) DEFAULT '0.0000',
  `deduction42` decimal(19,4) DEFAULT '0.0000',
  `deduction43` decimal(19,4) DEFAULT '0.0000',
  `deduction44` decimal(19,4) DEFAULT '0.0000',
  `deduction45` decimal(19,4) DEFAULT '0.0000',
  `deduction46` decimal(19,4) DEFAULT '0.0000',
  `deduction47` decimal(19,4) DEFAULT '0.0000',
  `deduction48` decimal(19,4) DEFAULT '0.0000',
  `deduction49` decimal(19,4) DEFAULT '0.0000',
  `deduction50` decimal(19,4) DEFAULT '0.0000',
  `deduction51` decimal(19,4) DEFAULT '0.0000',
  `deduction52` decimal(19,4) DEFAULT '0.0000',
  `deduction53` decimal(19,4) DEFAULT '0.0000',
  `deduction54` decimal(19,4) DEFAULT '0.0000',
  `deduction55` decimal(19,4) DEFAULT '0.0000',
  `deduction56` decimal(19,4) DEFAULT '0.0000',
  `deduction57` decimal(19,4) DEFAULT '0.0000',
  `deduction58` decimal(19,4) DEFAULT '0.0000',
  `deduction59` decimal(19,4) DEFAULT '0.0000',
  `deduction60` decimal(19,4) DEFAULT '0.0000',
  `deduction61` decimal(19,4) DEFAULT '0.0000',
  `deduction62` decimal(19,4) DEFAULT '0.0000',
  `deduction63` decimal(19,4) DEFAULT '0.0000',
  `deduction64` decimal(19,4) DEFAULT '0.0000',
  `deduction65` decimal(19,4) DEFAULT '0.0000',
  `deduction66` decimal(19,4) DEFAULT '0.0000',
  `deduction67` decimal(19,4) DEFAULT '0.0000',
  `deduction68` decimal(19,4) DEFAULT '0.0000',
  `deduction69` decimal(19,4) DEFAULT '0.0000',
  `deduction70` decimal(19,4) DEFAULT '0.0000',
  `deduction71` decimal(19,4) DEFAULT '0.0000',
  `deduction72` decimal(19,4) DEFAULT '0.0000',
  `deduction73` decimal(19,4) DEFAULT '0.0000',
  `deduction74` decimal(19,4) DEFAULT '0.0000',
  `deduction75` decimal(19,4) DEFAULT '0.0000',
  `deduction76` decimal(19,4) DEFAULT '0.0000',
  `deduction77` decimal(19,4) DEFAULT '0.0000',
  `deduction78` decimal(19,4) DEFAULT '0.0000',
  `deduction79` decimal(19,4) DEFAULT '0.0000',
  `deduction80` decimal(19,4) DEFAULT '0.0000',
  `deduction81` decimal(19,4) DEFAULT '0.0000',
  `deduction82` decimal(19,4) DEFAULT '0.0000',
  `deduction83` decimal(19,4) DEFAULT '0.0000',
  `deduction84` decimal(19,4) DEFAULT '0.0000',
  `deduction85` decimal(19,4) DEFAULT '0.0000',
  `deduction86` decimal(19,4) DEFAULT '0.0000',
  `deduction87` decimal(19,4) DEFAULT '0.0000',
  `deduction88` decimal(19,4) DEFAULT '0.0000',
  `deduction89` decimal(19,4) DEFAULT '0.0000',
  `deduction90` decimal(19,4) DEFAULT '0.0000',
  `deduction91` decimal(19,4) DEFAULT '0.0000',
  `deduction92` decimal(19,4) DEFAULT '0.0000',
  `deduction93` decimal(19,4) DEFAULT '0.0000',
  `deduction94` decimal(19,4) DEFAULT '0.0000',
  `deduction95` decimal(19,4) DEFAULT '0.0000',
  `deduction96` decimal(19,4) DEFAULT '0.0000',
  `deduction97` decimal(19,4) DEFAULT '0.0000',
  `deduction98` decimal(19,4) DEFAULT '0.0000',
  `deduction99` decimal(19,4) DEFAULT '0.0000',
  `deduction100` decimal(19,4) DEFAULT '0.0000',
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_payroll_option
DROP TABLE IF EXISTS `cod_payroll_option`;
CREATE TABLE IF NOT EXISTS `cod_payroll_option` (
  `auto_id` int(10) NOT NULL AUTO_INCREMENT,
  `payroll_code` varchar(15) DEFAULT NULL,
  `payroll_name` varchar(100) DEFAULT NULL,
  `payroll_type` int(11) DEFAULT '0',
  `account_code` varchar(10) DEFAULT NULL,
  `payroll_formula` longtext,
  `payroll_formula_1` longtext,
  `payroll_formula_2` longtext,
  `payroll_formula_3` longtext,
  `payroll_formula_4` longtext,
  `payroll_formula_5` longtext,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_pfa
DROP TABLE IF EXISTS `cod_pfa`;
CREATE TABLE IF NOT EXISTS `cod_pfa` (
  `auto_id` int(10) NOT NULL AUTO_INCREMENT,
  `code` varchar(10) DEFAULT NULL,
  `pfa` varchar(255) DEFAULT NULL,
  `pfa_acc` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_serial
DROP TABLE IF EXISTS `cod_serial`;
CREATE TABLE IF NOT EXISTS `cod_serial` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `serial` varchar(255) DEFAULT NULL,
  `value` int(11) DEFAULT NULL,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_setting
DROP TABLE IF EXISTS `cod_setting`;
CREATE TABLE IF NOT EXISTS `cod_setting` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `setting` char(100) DEFAULT NULL,
  `value` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_system
DROP TABLE IF EXISTS `cod_system`;
CREATE TABLE IF NOT EXISTS `cod_system` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) DEFAULT NULL,
  `log_time` datetime DEFAULT NULL,
  `category` varchar(100) DEFAULT NULL,
  `subcategory` varchar(100) DEFAULT NULL,
  `operation` varchar(100) DEFAULT NULL,
  `description` mediumtext,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_task
DROP TABLE IF EXISTS `cod_task`;
CREATE TABLE IF NOT EXISTS `cod_task` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `task_code` char(20) DEFAULT NULL,
  `type_code` char(20) DEFAULT NULL,
  `task_kind` char(20) DEFAULT NULL,
  `description` text,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `solve_date` date DEFAULT NULL,
  `priority` varchar(10) DEFAULT NULL,
  `progress` int(1) DEFAULT NULL,
  `rating` int(1) DEFAULT NULL,
  `cause` text,
  `impact` text,
  `mitigant` text,
  `status` char(10) DEFAULT NULL,
  `initiator` char(100) DEFAULT NULL,
  `assign_to` char(100) DEFAULT NULL,
  `submit_by` char(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` text,
  PRIMARY KEY (`auto_id`),
  UNIQUE KEY `Index 2` (`task_code`),
  KEY `FK_cod_task_cod_task_type` (`type_code`),
  CONSTRAINT `FK_cod_task_cod_task_type` FOREIGN KEY (`type_code`) REFERENCES `cod_task_type` (`type_code`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_task_category
DROP TABLE IF EXISTS `cod_task_category`;
CREATE TABLE IF NOT EXISTS `cod_task_category` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_code` char(20) DEFAULT NULL,
  `category_name` char(200) DEFAULT NULL,
  `group_code` enum('ADM','ALT','AUD','DIR','ERM','FIN','HRM','ICT','LGL','MCU','PMO','RET','TEC') NOT NULL,
  `staff` text,
  `owner` text,
  `admin` text,
  `moderator` text,
  `submit_by` char(50) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` text,
  PRIMARY KEY (`auto_id`),
  UNIQUE KEY `Index 2` (`category_code`),
  UNIQUE KEY `Index 3` (`category_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_task_log
DROP TABLE IF EXISTS `cod_task_log`;
CREATE TABLE IF NOT EXISTS `cod_task_log` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `task_code` char(20) DEFAULT NULL,
  `message` text,
  `submit_by` char(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` text,
  PRIMARY KEY (`auto_id`),
  KEY `FK_cod_task_log_cod_task` (`task_code`),
  CONSTRAINT `FK_cod_task_log_cod_task` FOREIGN KEY (`task_code`) REFERENCES `cod_task` (`task_code`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_task_type
DROP TABLE IF EXISTS `cod_task_type`;
CREATE TABLE IF NOT EXISTS `cod_task_type` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_code` char(20) DEFAULT NULL,
  `type_name` char(200) DEFAULT NULL,
  `category_code` char(20) DEFAULT NULL,
  `priority` char(20) DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `description` text,
  `cause` text,
  `impact` text,
  `mitigant` text,
  `submit_by` char(50) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` text,
  PRIMARY KEY (`auto_id`),
  UNIQUE KEY `Index 2` (`type_code`),
  UNIQUE KEY `Index 3` (`type_name`),
  KEY `FK_cod_task_type_cod_task_category` (`category_code`),
  CONSTRAINT `FK_cod_task_type_cod_task_category` FOREIGN KEY (`category_code`) REFERENCES `cod_task_category` (`category_code`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_user
DROP TABLE IF EXISTS `cod_user`;
CREATE TABLE IF NOT EXISTS `cod_user` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` char(20) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `password_reset` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `password_date` datetime DEFAULT NULL,
  `password_attempt` int(11) DEFAULT NULL,
  `password_wait` datetime DEFAULT NULL,
  `registered_date` datetime DEFAULT NULL,
  `user_log` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `user_period` int(11) DEFAULT NULL,
  `last_log` datetime DEFAULT NULL,
  `division_code` varchar(15) DEFAULT NULL,
  `division` varchar(100) DEFAULT NULL,
  `department_code` varchar(15) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `directorate` varchar(100) DEFAULT NULL,
  `manager` varchar(255) DEFAULT NULL,
  `dept_head` varchar(255) DEFAULT NULL,
  `director` varchar(255) DEFAULT NULL,
  `job_grade` varchar(50) DEFAULT NULL,
  `job_step` varchar(2) DEFAULT NULL,
  `job_name` varchar(255) DEFAULT NULL,
  `job_contract` varchar(20) DEFAULT NULL,
  `job_category_code` varchar(15) DEFAULT NULL,
  `job_category` varchar(50) DEFAULT NULL,
  `job_description` varchar(100) DEFAULT NULL,
  `grade_type` varchar(10) DEFAULT '100%',
  `status` varchar(1) DEFAULT NULL,
  `access` varchar(3000) DEFAULT NULL,
  `remarks` mediumtext,
  `approve` varchar(50) DEFAULT NULL,
  `alert` varchar(100) DEFAULT NULL,
  `leave_approval` mediumtext,
  `allowance_load` varchar(500) DEFAULT NULL,
  `deduction_load` varchar(500) DEFAULT NULL,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `title` varchar(15) DEFAULT NULL,
  `first_name` varchar(100) DEFAULT '',
  `middle_name` varchar(100) DEFAULT '',
  `last_name` varchar(100) DEFAULT '',
  `maiden_name` varchar(100) DEFAULT '',
  `address` varchar(200) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `phone` varchar(50) DEFAULT '',
  `mobile` varchar(50) DEFAULT '',
  `gender` varchar(10) DEFAULT NULL,
  `birth_date` date DEFAULT NULL,
  `marital_status` varchar(20) DEFAULT NULL,
  `state_origin` varchar(50) DEFAULT NULL,
  `nationality` varchar(50) DEFAULT NULL,
  `identification` varchar(100) DEFAULT NULL,
  `date_employment` date DEFAULT NULL,
  `date_confirm` date DEFAULT NULL,
  `date_pension` date DEFAULT NULL,
  `date_promotion` date DEFAULT NULL,
  `promotion_detail` varchar(255) DEFAULT NULL,
  `date_termination` date DEFAULT NULL,
  `max_leave` int(11) DEFAULT NULL,
  `appraisal` varchar(255) DEFAULT NULL,
  `spouse_name` varchar(255) DEFAULT NULL,
  `spouse_phone` varchar(30) DEFAULT NULL,
  `spouse_address` varchar(255) DEFAULT NULL,
  `child1` varchar(255) DEFAULT NULL,
  `child2` varchar(255) DEFAULT NULL,
  `child3` varchar(255) DEFAULT NULL,
  `child4` varchar(255) DEFAULT NULL,
  `kin_name` varchar(255) DEFAULT NULL,
  `kin_phone` varchar(30) DEFAULT NULL,
  `kin_address` varchar(255) DEFAULT NULL,
  `kin_relation` varchar(50) DEFAULT NULL,
  `bank_code` varchar(15) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `bank_address` varchar(255) DEFAULT NULL,
  `account_name` varchar(255) DEFAULT NULL,
  `account_number` varchar(50) DEFAULT NULL,
  `PFA_code` varchar(15) DEFAULT NULL,
  `PFA` varchar(255) DEFAULT NULL,
  `RSA_number` varchar(30) DEFAULT NULL,
  `NHF_code` varchar(15) DEFAULT NULL,
  `NHF` varchar(255) DEFAULT NULL,
  `reference1` varchar(255) DEFAULT NULL,
  `reference2` varchar(255) DEFAULT NULL,
  `reference3` varchar(255) DEFAULT NULL,
  `qualification1` varchar(255) DEFAULT NULL,
  `qualification2` varchar(255) DEFAULT NULL,
  `qualification3` varchar(255) DEFAULT NULL,
  `qualification4` varchar(255) DEFAULT NULL,
  `qualification5` varchar(255) DEFAULT NULL,
  `qualification6` varchar(255) DEFAULT NULL,
  `qualification7` varchar(255) DEFAULT NULL,
  `qualification8` varchar(255) DEFAULT NULL,
  `qualification9` varchar(255) DEFAULT NULL,
  `qualification10` varchar(255) DEFAULT NULL,
  `certification1` varchar(255) DEFAULT NULL,
  `certification2` varchar(255) DEFAULT NULL,
  `certification3` varchar(255) DEFAULT NULL,
  `certification4` varchar(255) DEFAULT NULL,
  `certification5` varchar(255) DEFAULT NULL,
  `certification6` varchar(255) DEFAULT NULL,
  `certification7` varchar(255) DEFAULT NULL,
  `certification8` varchar(255) DEFAULT NULL,
  `certification9` varchar(255) DEFAULT NULL,
  `certification10` varchar(255) DEFAULT NULL,
  `allowance1` decimal(19,4) DEFAULT '0.0000',
  `allowance2` decimal(19,4) DEFAULT '0.0000',
  `allowance3` decimal(19,4) DEFAULT '0.0000',
  `allowance4` decimal(19,4) DEFAULT '0.0000',
  `allowance5` decimal(19,4) DEFAULT '0.0000',
  `allowance6` decimal(19,4) DEFAULT '0.0000',
  `allowance7` decimal(19,4) DEFAULT '0.0000',
  `allowance8` decimal(19,4) DEFAULT '0.0000',
  `allowance9` decimal(19,4) DEFAULT '0.0000',
  `allowance10` decimal(19,4) DEFAULT '0.0000',
  `allowance11` decimal(19,4) DEFAULT '0.0000',
  `allowance12` decimal(19,4) DEFAULT '0.0000',
  `allowance13` decimal(19,4) DEFAULT '0.0000',
  `allowance14` decimal(19,4) DEFAULT '0.0000',
  `allowance15` decimal(19,4) DEFAULT '0.0000',
  `allowance16` decimal(19,4) DEFAULT '0.0000',
  `allowance17` decimal(19,4) DEFAULT '0.0000',
  `allowance18` decimal(19,4) DEFAULT '0.0000',
  `allowance19` decimal(19,4) DEFAULT '0.0000',
  `allowance20` decimal(19,4) DEFAULT '0.0000',
  `allowance21` decimal(19,4) DEFAULT '0.0000',
  `allowance22` decimal(19,4) DEFAULT '0.0000',
  `allowance23` decimal(19,4) DEFAULT '0.0000',
  `allowance24` decimal(19,4) DEFAULT '0.0000',
  `allowance25` decimal(19,4) DEFAULT '0.0000',
  `allowance26` decimal(19,4) DEFAULT '0.0000',
  `allowance27` decimal(19,4) DEFAULT '0.0000',
  `allowance28` decimal(19,4) DEFAULT '0.0000',
  `allowance29` decimal(19,4) DEFAULT '0.0000',
  `allowance30` decimal(19,4) DEFAULT '0.0000',
  `allowance31` decimal(19,4) DEFAULT '0.0000',
  `allowance32` decimal(19,4) DEFAULT '0.0000',
  `allowance33` decimal(19,4) DEFAULT '0.0000',
  `allowance34` decimal(19,4) DEFAULT '0.0000',
  `allowance35` decimal(19,4) DEFAULT '0.0000',
  `allowance36` decimal(19,4) DEFAULT '0.0000',
  `allowance37` decimal(19,4) DEFAULT '0.0000',
  `allowance38` decimal(19,4) DEFAULT '0.0000',
  `allowance39` decimal(19,4) DEFAULT '0.0000',
  `allowance40` decimal(19,4) DEFAULT '0.0000',
  `allowance41` decimal(19,4) DEFAULT '0.0000',
  `allowance42` decimal(19,4) DEFAULT '0.0000',
  `allowance43` decimal(19,4) DEFAULT '0.0000',
  `allowance44` decimal(19,4) DEFAULT '0.0000',
  `allowance45` decimal(19,4) DEFAULT '0.0000',
  `allowance46` decimal(19,4) DEFAULT '0.0000',
  `allowance47` decimal(19,4) DEFAULT '0.0000',
  `allowance48` decimal(19,4) DEFAULT '0.0000',
  `allowance49` decimal(19,4) DEFAULT '0.0000',
  `allowance50` decimal(19,4) DEFAULT '0.0000',
  `allowance51` decimal(19,4) DEFAULT '0.0000',
  `allowance52` decimal(19,4) DEFAULT '0.0000',
  `allowance53` decimal(19,4) DEFAULT '0.0000',
  `allowance54` decimal(19,4) DEFAULT '0.0000',
  `allowance55` decimal(19,4) DEFAULT '0.0000',
  `allowance56` decimal(19,4) DEFAULT '0.0000',
  `allowance57` decimal(19,4) DEFAULT '0.0000',
  `allowance58` decimal(19,4) DEFAULT '0.0000',
  `allowance59` decimal(19,4) DEFAULT '0.0000',
  `allowance60` decimal(19,4) DEFAULT '0.0000',
  `allowance61` decimal(19,4) DEFAULT '0.0000',
  `allowance62` decimal(19,4) DEFAULT '0.0000',
  `allowance63` decimal(19,4) DEFAULT '0.0000',
  `allowance64` decimal(19,4) DEFAULT '0.0000',
  `allowance65` decimal(19,4) DEFAULT '0.0000',
  `allowance66` decimal(19,4) DEFAULT '0.0000',
  `allowance67` decimal(19,4) DEFAULT '0.0000',
  `allowance68` decimal(19,4) DEFAULT '0.0000',
  `allowance69` decimal(19,4) DEFAULT '0.0000',
  `allowance70` decimal(19,4) DEFAULT '0.0000',
  `allowance71` decimal(19,4) DEFAULT '0.0000',
  `allowance72` decimal(19,4) DEFAULT '0.0000',
  `allowance73` decimal(19,4) DEFAULT '0.0000',
  `allowance74` decimal(19,4) DEFAULT '0.0000',
  `allowance75` decimal(19,4) DEFAULT '0.0000',
  `allowance76` decimal(19,4) DEFAULT '0.0000',
  `allowance77` decimal(19,4) DEFAULT '0.0000',
  `allowance78` decimal(19,4) DEFAULT '0.0000',
  `allowance79` decimal(19,4) DEFAULT '0.0000',
  `allowance80` decimal(19,4) DEFAULT '0.0000',
  `allowance81` decimal(19,4) DEFAULT '0.0000',
  `allowance82` decimal(19,4) DEFAULT '0.0000',
  `allowance83` decimal(19,4) DEFAULT '0.0000',
  `allowance84` decimal(19,4) DEFAULT '0.0000',
  `allowance85` decimal(19,4) DEFAULT '0.0000',
  `allowance86` decimal(19,4) DEFAULT '0.0000',
  `allowance87` decimal(19,4) DEFAULT '0.0000',
  `allowance88` decimal(19,4) DEFAULT '0.0000',
  `allowance89` decimal(19,4) DEFAULT '0.0000',
  `allowance90` decimal(19,4) DEFAULT '0.0000',
  `allowance91` decimal(19,4) DEFAULT '0.0000',
  `allowance92` decimal(19,4) DEFAULT '0.0000',
  `allowance93` decimal(19,4) DEFAULT '0.0000',
  `allowance94` decimal(19,4) DEFAULT '0.0000',
  `allowance95` decimal(19,4) DEFAULT '0.0000',
  `allowance96` decimal(19,4) DEFAULT '0.0000',
  `allowance97` decimal(19,4) DEFAULT '0.0000',
  `allowance98` decimal(19,4) DEFAULT '0.0000',
  `allowance99` decimal(19,4) DEFAULT '0.0000',
  `allowance100` decimal(19,4) DEFAULT '0.0000',
  `deduction1` decimal(19,4) DEFAULT '0.0000',
  `deduction2` decimal(19,4) DEFAULT '0.0000',
  `deduction3` decimal(19,4) DEFAULT '0.0000',
  `deduction4` decimal(19,4) DEFAULT '0.0000',
  `deduction5` decimal(19,4) DEFAULT '0.0000',
  `deduction6` decimal(19,4) DEFAULT '0.0000',
  `deduction7` decimal(19,4) DEFAULT '0.0000',
  `deduction8` decimal(19,4) DEFAULT '0.0000',
  `deduction9` decimal(19,4) DEFAULT '0.0000',
  `deduction10` decimal(19,4) DEFAULT '0.0000',
  `deduction11` decimal(19,4) DEFAULT '0.0000',
  `deduction12` decimal(19,4) DEFAULT '0.0000',
  `deduction13` decimal(19,4) DEFAULT '0.0000',
  `deduction14` decimal(19,4) DEFAULT '0.0000',
  `deduction15` decimal(19,4) DEFAULT '0.0000',
  `deduction16` decimal(19,4) DEFAULT '0.0000',
  `deduction17` decimal(19,4) DEFAULT '0.0000',
  `deduction18` decimal(19,4) DEFAULT '0.0000',
  `deduction19` decimal(19,4) DEFAULT '0.0000',
  `deduction20` decimal(19,4) DEFAULT '0.0000',
  `deduction21` decimal(19,4) DEFAULT '0.0000',
  `deduction22` decimal(19,4) DEFAULT '0.0000',
  `deduction23` decimal(19,4) DEFAULT '0.0000',
  `deduction24` decimal(19,4) DEFAULT '0.0000',
  `deduction25` decimal(19,4) DEFAULT '0.0000',
  `deduction26` decimal(19,4) DEFAULT '0.0000',
  `deduction27` decimal(19,4) DEFAULT '0.0000',
  `deduction28` decimal(19,4) DEFAULT '0.0000',
  `deduction29` decimal(19,4) DEFAULT '0.0000',
  `deduction30` decimal(19,4) DEFAULT '0.0000',
  `deduction31` decimal(19,4) DEFAULT '0.0000',
  `deduction32` decimal(19,4) DEFAULT '0.0000',
  `deduction33` decimal(19,4) DEFAULT '0.0000',
  `deduction34` decimal(19,4) DEFAULT '0.0000',
  `deduction35` decimal(19,4) DEFAULT '0.0000',
  `deduction36` decimal(19,4) DEFAULT '0.0000',
  `deduction37` decimal(19,4) DEFAULT '0.0000',
  `deduction38` decimal(19,4) DEFAULT '0.0000',
  `deduction39` decimal(19,4) DEFAULT '0.0000',
  `deduction40` decimal(19,4) DEFAULT '0.0000',
  `deduction41` decimal(19,4) DEFAULT '0.0000',
  `deduction42` decimal(19,4) DEFAULT '0.0000',
  `deduction43` decimal(19,4) DEFAULT '0.0000',
  `deduction44` decimal(19,4) DEFAULT '0.0000',
  `deduction45` decimal(19,4) DEFAULT '0.0000',
  `deduction46` decimal(19,4) DEFAULT '0.0000',
  `deduction47` decimal(19,4) DEFAULT '0.0000',
  `deduction48` decimal(19,4) DEFAULT '0.0000',
  `deduction49` decimal(19,4) DEFAULT '0.0000',
  `deduction50` decimal(19,4) DEFAULT '0.0000',
  `deduction51` decimal(19,4) DEFAULT '0.0000',
  `deduction52` decimal(19,4) DEFAULT '0.0000',
  `deduction53` decimal(19,4) DEFAULT '0.0000',
  `deduction54` decimal(19,4) DEFAULT '0.0000',
  `deduction55` decimal(19,4) DEFAULT '0.0000',
  `deduction56` decimal(19,4) DEFAULT '0.0000',
  `deduction57` decimal(19,4) DEFAULT '0.0000',
  `deduction58` decimal(19,4) DEFAULT '0.0000',
  `deduction59` decimal(19,4) DEFAULT '0.0000',
  `deduction60` decimal(19,4) DEFAULT '0.0000',
  `deduction61` decimal(19,4) DEFAULT '0.0000',
  `deduction62` decimal(19,4) DEFAULT '0.0000',
  `deduction63` decimal(19,4) DEFAULT '0.0000',
  `deduction64` decimal(19,4) DEFAULT '0.0000',
  `deduction65` decimal(19,4) DEFAULT '0.0000',
  `deduction66` decimal(19,4) DEFAULT '0.0000',
  `deduction67` decimal(19,4) DEFAULT '0.0000',
  `deduction68` decimal(19,4) DEFAULT '0.0000',
  `deduction69` decimal(19,4) DEFAULT '0.0000',
  `deduction70` decimal(19,4) DEFAULT '0.0000',
  `deduction71` decimal(19,4) DEFAULT '0.0000',
  `deduction72` decimal(19,4) DEFAULT '0.0000',
  `deduction73` decimal(19,4) DEFAULT '0.0000',
  `deduction74` decimal(19,4) DEFAULT '0.0000',
  `deduction75` decimal(19,4) DEFAULT '0.0000',
  `deduction76` decimal(19,4) DEFAULT '0.0000',
  `deduction77` decimal(19,4) DEFAULT '0.0000',
  `deduction78` decimal(19,4) DEFAULT '0.0000',
  `deduction79` decimal(19,4) DEFAULT '0.0000',
  `deduction80` decimal(19,4) DEFAULT '0.0000',
  `deduction81` decimal(19,4) DEFAULT '0.0000',
  `deduction82` decimal(19,4) DEFAULT '0.0000',
  `deduction83` decimal(19,4) DEFAULT '0.0000',
  `deduction84` decimal(19,4) DEFAULT '0.0000',
  `deduction85` decimal(19,4) DEFAULT '0.0000',
  `deduction86` decimal(19,4) DEFAULT '0.0000',
  `deduction87` decimal(19,4) DEFAULT '0.0000',
  `deduction88` decimal(19,4) DEFAULT '0.0000',
  `deduction89` decimal(19,4) DEFAULT '0.0000',
  `deduction90` decimal(19,4) DEFAULT '0.0000',
  `deduction91` decimal(19,4) DEFAULT '0.0000',
  `deduction92` decimal(19,4) DEFAULT '0.0000',
  `deduction93` decimal(19,4) DEFAULT '0.0000',
  `deduction94` decimal(19,4) DEFAULT '0.0000',
  `deduction95` decimal(19,4) DEFAULT '0.0000',
  `deduction96` decimal(19,4) DEFAULT '0.0000',
  `deduction97` decimal(19,4) DEFAULT '0.0000',
  `deduction98` decimal(19,4) DEFAULT '0.0000',
  `deduction99` decimal(19,4) DEFAULT '0.0000',
  `deduction100` decimal(19,4) DEFAULT '0.0000',
  PRIMARY KEY (`auto_id`),
  UNIQUE KEY `Index 2` (`user_id`),
  UNIQUE KEY `Index 3` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=714 DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_user_access
DROP TABLE IF EXISTS `cod_user_access`;
CREATE TABLE IF NOT EXISTS `cod_user_access` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` char(20) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `in_date` datetime DEFAULT NULL,
  `out_date` datetime DEFAULT NULL,
  `event_log` varchar(100) DEFAULT NULL,
  `event_id` char(5) DEFAULT NULL,
  `description1` mediumtext,
  `description2` mediumtext,
  `description3` mediumtext,
  `description4` mediumtext,
  `description5` mediumtext,
  `card_number` char(10) DEFAULT NULL,
  `submit_by` varchar(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.cod_user_log
DROP TABLE IF EXISTS `cod_user_log`;
CREATE TABLE IF NOT EXISTS `cod_user_log` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) DEFAULT NULL,
  `log_time` datetime DEFAULT NULL,
  `user_ip` varchar(32) DEFAULT NULL,
  `event_log` varchar(100) DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB AUTO_INCREMENT=153994 DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.frm_chat
DROP TABLE IF EXISTS `frm_chat`;
CREATE TABLE IF NOT EXISTS `frm_chat` (
  `auto_id` int(10) NOT NULL AUTO_INCREMENT,
  `chat_from` varchar(100) DEFAULT NULL,
  `chat_to` varchar(100) DEFAULT NULL,
  `chat_txt` varchar(1000) DEFAULT NULL,
  `chat_status` varchar(1) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.frm_thread
DROP TABLE IF EXISTS `frm_thread`;
CREATE TABLE IF NOT EXISTS `frm_thread` (
  `auto_id` int(10) NOT NULL AUTO_INCREMENT,
  `topic_id` varchar(10) DEFAULT NULL,
  `comment` mediumtext,
  `submit_by` varchar(50) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.frm_topic
DROP TABLE IF EXISTS `frm_topic`;
CREATE TABLE IF NOT EXISTS `frm_topic` (
  `auto_id` int(10) NOT NULL AUTO_INCREMENT,
  `topic_id` varchar(10) DEFAULT NULL,
  `topic_group` varchar(20) DEFAULT NULL,
  `moderator` varchar(50) DEFAULT NULL,
  `topic` varchar(100) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `status` varchar(1) DEFAULT NULL,
  `submit_by` varchar(50) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `remarks` mediumtext,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.rpt_1
DROP TABLE IF EXISTS `rpt_1`;
CREATE TABLE IF NOT EXISTS `rpt_1` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` char(20) NOT NULL,
  `username` char(100) NOT NULL,
  `username1` char(100) NOT NULL,
  `password` char(50) DEFAULT NULL,
  `registered_date` datetime DEFAULT NULL,
  `user_log` char(40) DEFAULT NULL,
  `user_period` int(11) DEFAULT NULL,
  `last_log` datetime DEFAULT NULL,
  `division_code` char(15) DEFAULT NULL,
  `division` char(100) DEFAULT NULL,
  `department_code` char(15) DEFAULT NULL,
  `department` char(255) DEFAULT NULL,
  `directorate` char(255) DEFAULT NULL,
  `manager` char(255) DEFAULT NULL,
  `dept_head` char(255) DEFAULT NULL,
  `director` char(255) DEFAULT NULL,
  `job_grade` char(50) DEFAULT NULL,
  `job_step` char(2) DEFAULT NULL,
  `job_name` char(50) DEFAULT NULL,
  `job_contract` char(50) DEFAULT NULL,
  `job_category_code` char(15) DEFAULT NULL,
  `job_category` char(50) DEFAULT NULL,
  `job_description` char(100) DEFAULT NULL,
  `grade_type` char(10) DEFAULT '100%',
  `status` char(10) DEFAULT NULL,
  `access` mediumtext,
  `remarks` mediumtext,
  `approve` char(50) DEFAULT NULL,
  `allowance_load` text,
  `deduction_load` text,
  `submit_by` char(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `title` char(15) DEFAULT NULL,
  `first_name` char(100) DEFAULT '',
  `middle_name` char(100) DEFAULT '',
  `last_name` char(100) DEFAULT '',
  `fullname` char(255) DEFAULT '',
  `maiden_name` char(100) DEFAULT '',
  `address` char(255) DEFAULT NULL,
  `email` char(100) DEFAULT NULL,
  `phone` char(50) DEFAULT '',
  `mobile` char(50) DEFAULT '',
  `gender` char(10) DEFAULT NULL,
  `birth_date` date DEFAULT NULL,
  `marital_status` char(20) DEFAULT NULL,
  `state_origin` char(50) DEFAULT NULL,
  `nationality` char(50) DEFAULT NULL,
  `identification` char(100) DEFAULT NULL,
  `date_employment` date DEFAULT NULL,
  `date_confirm` date DEFAULT NULL,
  `date_pension` date DEFAULT NULL,
  `date_promotion` date DEFAULT NULL,
  `promotion_detail` char(255) DEFAULT NULL,
  `date_termination` date DEFAULT NULL,
  `max_leave` int(11) DEFAULT NULL,
  `appraisal` char(255) DEFAULT NULL,
  `appraisal_date` datetime DEFAULT NULL,
  `spouse_name` char(255) DEFAULT NULL,
  `spouse_phone` char(30) DEFAULT NULL,
  `spouse_address` char(255) DEFAULT NULL,
  `child1` char(255) DEFAULT NULL,
  `child2` char(255) DEFAULT NULL,
  `child3` char(255) DEFAULT NULL,
  `child4` char(255) DEFAULT NULL,
  `kin_name` char(255) DEFAULT NULL,
  `kin_phone` char(30) DEFAULT NULL,
  `kin_address` char(255) DEFAULT NULL,
  `kin_relation` char(50) DEFAULT NULL,
  `bank_code` char(15) DEFAULT NULL,
  `bank_name` char(255) DEFAULT NULL,
  `bank_address` char(255) DEFAULT NULL,
  `account_name` char(255) DEFAULT NULL,
  `account_number` char(255) DEFAULT NULL,
  `PFA_code` char(15) DEFAULT NULL,
  `PFA` char(255) DEFAULT NULL,
  `RSA_number` char(30) DEFAULT NULL,
  `NHF_code` char(255) DEFAULT NULL,
  `NHF` char(255) DEFAULT NULL,
  `manager_recommend` char(255) DEFAULT NULL,
  `manager_improve` char(255) DEFAULT NULL,
  `manager_improve_option` char(255) DEFAULT NULL,
  `manager_improve_action` text,
  `dept_head_recommend` char(255) DEFAULT NULL,
  `director_recommend` mediumtext,
  `hr_recommend` char(255) DEFAULT NULL,
  `final_recommend` char(255) DEFAULT NULL,
  `final_comment` mediumtext,
  `reference1` char(255) DEFAULT NULL,
  `reference2` char(255) DEFAULT NULL,
  `reference3` char(255) DEFAULT NULL,
  `qualification` mediumtext,
  `qualification1` char(255) DEFAULT NULL,
  `qualification2` char(255) DEFAULT NULL,
  `qualification3` char(255) DEFAULT NULL,
  `qualification4` char(255) DEFAULT NULL,
  `qualification5` char(255) DEFAULT NULL,
  `qualification6` char(255) DEFAULT NULL,
  `qualification7` char(255) DEFAULT NULL,
  `qualification8` char(255) DEFAULT NULL,
  `qualification9` char(255) DEFAULT NULL,
  `qualification10` char(255) DEFAULT NULL,
  `certification` mediumtext,
  `certification1` char(255) DEFAULT NULL,
  `certification2` char(255) DEFAULT NULL,
  `certification3` char(255) DEFAULT NULL,
  `certification4` char(255) DEFAULT NULL,
  `certification5` char(255) DEFAULT NULL,
  `certification6` char(255) DEFAULT NULL,
  `certification7` char(255) DEFAULT NULL,
  `certification8` char(255) DEFAULT NULL,
  `certification9` char(255) DEFAULT NULL,
  `certification10` char(255) DEFAULT NULL,
  `payroll_date` datetime DEFAULT NULL,
  `payroll_slip` mediumtext,
  `allowance1` decimal(19,4) DEFAULT '0.0000',
  `allowance2` decimal(19,4) DEFAULT '0.0000',
  `allowance3` decimal(19,4) DEFAULT '0.0000',
  `allowance4` decimal(19,4) DEFAULT '0.0000',
  `allowance5` decimal(19,4) DEFAULT '0.0000',
  `allowance6` decimal(19,4) DEFAULT '0.0000',
  `allowance7` decimal(19,4) DEFAULT '0.0000',
  `allowance8` decimal(19,4) DEFAULT '0.0000',
  `allowance9` decimal(19,4) DEFAULT '0.0000',
  `allowance10` decimal(19,4) DEFAULT '0.0000',
  `allowance11` decimal(19,4) DEFAULT '0.0000',
  `allowance12` decimal(19,4) DEFAULT '0.0000',
  `allowance13` decimal(19,4) DEFAULT '0.0000',
  `allowance14` decimal(19,4) DEFAULT '0.0000',
  `allowance15` decimal(19,4) DEFAULT '0.0000',
  `allowance16` decimal(19,4) DEFAULT '0.0000',
  `allowance17` decimal(19,4) DEFAULT '0.0000',
  `allowance18` decimal(19,4) DEFAULT '0.0000',
  `allowance19` decimal(19,4) DEFAULT '0.0000',
  `allowance20` decimal(19,4) DEFAULT '0.0000',
  `allowance21` decimal(19,4) DEFAULT '0.0000',
  `allowance22` decimal(19,4) DEFAULT '0.0000',
  `allowance23` decimal(19,4) DEFAULT '0.0000',
  `allowance24` decimal(19,4) DEFAULT '0.0000',
  `allowance25` decimal(19,4) DEFAULT '0.0000',
  `allowance26` decimal(19,4) DEFAULT '0.0000',
  `allowance27` decimal(19,4) DEFAULT '0.0000',
  `allowance28` decimal(19,4) DEFAULT '0.0000',
  `allowance29` decimal(19,4) DEFAULT '0.0000',
  `allowance30` decimal(19,4) DEFAULT '0.0000',
  `allowance31` decimal(19,4) DEFAULT '0.0000',
  `allowance32` decimal(19,4) DEFAULT '0.0000',
  `allowance33` decimal(19,4) DEFAULT '0.0000',
  `allowance34` decimal(19,4) DEFAULT '0.0000',
  `allowance35` decimal(19,4) DEFAULT '0.0000',
  `allowance36` decimal(19,4) DEFAULT '0.0000',
  `allowance37` decimal(19,4) DEFAULT '0.0000',
  `allowance38` decimal(19,4) DEFAULT '0.0000',
  `allowance39` decimal(19,4) DEFAULT '0.0000',
  `allowance40` decimal(19,4) DEFAULT '0.0000',
  `allowance41` decimal(19,4) DEFAULT '0.0000',
  `allowance42` decimal(19,4) DEFAULT '0.0000',
  `allowance43` decimal(19,4) DEFAULT '0.0000',
  `allowance44` decimal(19,4) DEFAULT '0.0000',
  `allowance45` decimal(19,4) DEFAULT '0.0000',
  `allowance46` decimal(19,4) DEFAULT '0.0000',
  `allowance47` decimal(19,4) DEFAULT '0.0000',
  `allowance48` decimal(19,4) DEFAULT '0.0000',
  `allowance49` decimal(19,4) DEFAULT '0.0000',
  `allowance50` decimal(19,4) DEFAULT '0.0000',
  `allowance51` decimal(19,4) DEFAULT '0.0000',
  `allowance52` decimal(19,4) DEFAULT '0.0000',
  `allowance53` decimal(19,4) DEFAULT '0.0000',
  `allowance54` decimal(19,4) DEFAULT '0.0000',
  `allowance55` decimal(19,4) DEFAULT '0.0000',
  `allowance56` decimal(19,4) DEFAULT '0.0000',
  `allowance57` decimal(19,4) DEFAULT '0.0000',
  `allowance58` decimal(19,4) DEFAULT '0.0000',
  `allowance59` decimal(19,4) DEFAULT '0.0000',
  `allowance60` decimal(19,4) DEFAULT '0.0000',
  `allowance61` decimal(19,4) DEFAULT '0.0000',
  `allowance62` decimal(19,4) DEFAULT '0.0000',
  `allowance63` decimal(19,4) DEFAULT '0.0000',
  `allowance64` decimal(19,4) DEFAULT '0.0000',
  `allowance65` decimal(19,4) DEFAULT '0.0000',
  `allowance66` decimal(19,4) DEFAULT '0.0000',
  `allowance67` decimal(19,4) DEFAULT '0.0000',
  `allowance68` decimal(19,4) DEFAULT '0.0000',
  `allowance69` decimal(19,4) DEFAULT '0.0000',
  `allowance70` decimal(19,4) DEFAULT '0.0000',
  `allowance71` decimal(19,4) DEFAULT '0.0000',
  `allowance72` decimal(19,4) DEFAULT '0.0000',
  `allowance73` decimal(19,4) DEFAULT '0.0000',
  `allowance74` decimal(19,4) DEFAULT '0.0000',
  `allowance75` decimal(19,4) DEFAULT '0.0000',
  `allowance76` decimal(19,4) DEFAULT '0.0000',
  `allowance77` decimal(19,4) DEFAULT '0.0000',
  `allowance78` decimal(19,4) DEFAULT '0.0000',
  `allowance79` decimal(19,4) DEFAULT '0.0000',
  `allowance80` decimal(19,4) DEFAULT '0.0000',
  `allowance81` decimal(19,4) DEFAULT '0.0000',
  `allowance82` decimal(19,4) DEFAULT '0.0000',
  `allowance83` decimal(19,4) DEFAULT '0.0000',
  `allowance84` decimal(19,4) DEFAULT '0.0000',
  `allowance85` decimal(19,4) DEFAULT '0.0000',
  `allowance86` decimal(19,4) DEFAULT '0.0000',
  `allowance87` decimal(19,4) DEFAULT '0.0000',
  `allowance88` decimal(19,4) DEFAULT '0.0000',
  `allowance89` decimal(19,4) DEFAULT '0.0000',
  `allowance90` decimal(19,4) DEFAULT '0.0000',
  `allowance91` decimal(19,4) DEFAULT '0.0000',
  `allowance92` decimal(19,4) DEFAULT '0.0000',
  `allowance93` decimal(19,4) DEFAULT '0.0000',
  `allowance94` decimal(19,4) DEFAULT '0.0000',
  `allowance95` decimal(19,4) DEFAULT '0.0000',
  `allowance96` decimal(19,4) DEFAULT '0.0000',
  `allowance97` decimal(19,4) DEFAULT '0.0000',
  `allowance98` decimal(19,4) DEFAULT '0.0000',
  `allowance99` decimal(19,4) DEFAULT '0.0000',
  `allowance100` decimal(19,4) DEFAULT '0.0000',
  `other_allowance` decimal(19,4) DEFAULT '0.0000',
  `total_allowance` decimal(19,4) DEFAULT '0.0000',
  `deduction1` decimal(19,4) DEFAULT '0.0000',
  `deduction2` decimal(19,4) DEFAULT '0.0000',
  `deduction3` decimal(19,4) DEFAULT '0.0000',
  `deduction4` decimal(19,4) DEFAULT '0.0000',
  `deduction5` decimal(19,4) DEFAULT '0.0000',
  `deduction6` decimal(19,4) DEFAULT '0.0000',
  `deduction7` decimal(19,4) DEFAULT '0.0000',
  `deduction8` decimal(19,4) DEFAULT '0.0000',
  `deduction9` decimal(19,4) DEFAULT '0.0000',
  `deduction10` decimal(19,4) DEFAULT '0.0000',
  `deduction11` decimal(19,4) DEFAULT '0.0000',
  `deduction12` decimal(19,4) DEFAULT '0.0000',
  `deduction13` decimal(19,4) DEFAULT '0.0000',
  `deduction14` decimal(19,4) DEFAULT '0.0000',
  `deduction15` decimal(19,4) DEFAULT '0.0000',
  `deduction16` decimal(19,4) DEFAULT '0.0000',
  `deduction17` decimal(19,4) DEFAULT '0.0000',
  `deduction18` decimal(19,4) DEFAULT '0.0000',
  `deduction19` decimal(19,4) DEFAULT '0.0000',
  `deduction20` decimal(19,4) DEFAULT '0.0000',
  `deduction21` decimal(19,4) DEFAULT '0.0000',
  `deduction22` decimal(19,4) DEFAULT '0.0000',
  `deduction23` decimal(19,4) DEFAULT '0.0000',
  `deduction24` decimal(19,4) DEFAULT '0.0000',
  `deduction25` decimal(19,4) DEFAULT '0.0000',
  `deduction26` decimal(19,4) DEFAULT '0.0000',
  `deduction27` decimal(19,4) DEFAULT '0.0000',
  `deduction28` decimal(19,4) DEFAULT '0.0000',
  `deduction29` decimal(19,4) DEFAULT '0.0000',
  `deduction30` decimal(19,4) DEFAULT '0.0000',
  `deduction31` decimal(19,4) DEFAULT '0.0000',
  `deduction32` decimal(19,4) DEFAULT '0.0000',
  `deduction33` decimal(19,4) DEFAULT '0.0000',
  `deduction34` decimal(19,4) DEFAULT '0.0000',
  `deduction35` decimal(19,4) DEFAULT '0.0000',
  `deduction36` decimal(19,4) DEFAULT '0.0000',
  `deduction37` decimal(19,4) DEFAULT '0.0000',
  `deduction38` decimal(19,4) DEFAULT '0.0000',
  `deduction39` decimal(19,4) DEFAULT '0.0000',
  `deduction40` decimal(19,4) DEFAULT '0.0000',
  `deduction41` decimal(19,4) DEFAULT '0.0000',
  `deduction42` decimal(19,4) DEFAULT '0.0000',
  `deduction43` decimal(19,4) DEFAULT '0.0000',
  `deduction44` decimal(19,4) DEFAULT '0.0000',
  `deduction45` decimal(19,4) DEFAULT '0.0000',
  `deduction46` decimal(19,4) DEFAULT '0.0000',
  `deduction47` decimal(19,4) DEFAULT '0.0000',
  `deduction48` decimal(19,4) DEFAULT '0.0000',
  `deduction49` decimal(19,4) DEFAULT '0.0000',
  `deduction50` decimal(19,4) DEFAULT '0.0000',
  `deduction51` decimal(19,4) DEFAULT '0.0000',
  `deduction52` decimal(19,4) DEFAULT '0.0000',
  `deduction53` decimal(19,4) DEFAULT '0.0000',
  `deduction54` decimal(19,4) DEFAULT '0.0000',
  `deduction55` decimal(19,4) DEFAULT '0.0000',
  `deduction56` decimal(19,4) DEFAULT '0.0000',
  `deduction57` decimal(19,4) DEFAULT '0.0000',
  `deduction58` decimal(19,4) DEFAULT '0.0000',
  `deduction59` decimal(19,4) DEFAULT '0.0000',
  `deduction60` decimal(19,4) DEFAULT '0.0000',
  `deduction61` decimal(19,4) DEFAULT '0.0000',
  `deduction62` decimal(19,4) DEFAULT '0.0000',
  `deduction63` decimal(19,4) DEFAULT '0.0000',
  `deduction64` decimal(19,4) DEFAULT '0.0000',
  `deduction65` decimal(19,4) DEFAULT '0.0000',
  `deduction66` decimal(19,4) DEFAULT '0.0000',
  `deduction67` decimal(19,4) DEFAULT '0.0000',
  `deduction68` decimal(19,4) DEFAULT '0.0000',
  `deduction69` decimal(19,4) DEFAULT '0.0000',
  `deduction70` decimal(19,4) DEFAULT '0.0000',
  `deduction71` decimal(19,4) DEFAULT '0.0000',
  `deduction72` decimal(19,4) DEFAULT '0.0000',
  `deduction73` decimal(19,4) DEFAULT '0.0000',
  `deduction74` decimal(19,4) DEFAULT '0.0000',
  `deduction75` decimal(19,4) DEFAULT '0.0000',
  `deduction76` decimal(19,4) DEFAULT '0.0000',
  `deduction77` decimal(19,4) DEFAULT '0.0000',
  `deduction78` decimal(19,4) DEFAULT '0.0000',
  `deduction79` decimal(19,4) DEFAULT '0.0000',
  `deduction80` decimal(19,4) DEFAULT '0.0000',
  `deduction81` decimal(19,4) DEFAULT '0.0000',
  `deduction82` decimal(19,4) DEFAULT '0.0000',
  `deduction83` decimal(19,4) DEFAULT '0.0000',
  `deduction84` decimal(19,4) DEFAULT '0.0000',
  `deduction85` decimal(19,4) DEFAULT '0.0000',
  `deduction86` decimal(19,4) DEFAULT '0.0000',
  `deduction87` decimal(19,4) DEFAULT '0.0000',
  `deduction88` decimal(19,4) DEFAULT '0.0000',
  `deduction89` decimal(19,4) DEFAULT '0.0000',
  `deduction90` decimal(19,4) DEFAULT '0.0000',
  `deduction91` decimal(19,4) DEFAULT '0.0000',
  `deduction92` decimal(19,4) DEFAULT '0.0000',
  `deduction93` decimal(19,4) DEFAULT '0.0000',
  `deduction94` decimal(19,4) DEFAULT '0.0000',
  `deduction95` decimal(19,4) DEFAULT '0.0000',
  `deduction96` decimal(19,4) DEFAULT '0.0000',
  `deduction97` decimal(19,4) DEFAULT '0.0000',
  `deduction98` decimal(19,4) DEFAULT '0.0000',
  `deduction99` decimal(19,4) DEFAULT '0.0000',
  `deduction100` decimal(19,4) DEFAULT '0.0000',
  `other_deduction` decimal(19,4) DEFAULT '0.0000',
  `total_deduction` decimal(19,4) DEFAULT '0.0000',
  `net_pay` decimal(19,4) DEFAULT '0.0000',
  `kpi_score` float DEFAULT '0',
  `kpi1` mediumtext,
  `kpi2` mediumtext,
  `kpi3` mediumtext,
  `kpi4` mediumtext,
  `kpi5` mediumtext,
  `kpi6` mediumtext,
  `kpi7` mediumtext,
  `kpi8` mediumtext,
  `kpi9` mediumtext,
  `kpi10` mediumtext,
  `kpi11` mediumtext,
  `kpi12` mediumtext,
  `kpi13` mediumtext,
  `kpi14` mediumtext,
  `kpi15` mediumtext,
  `kpi16` mediumtext,
  `kpi17` mediumtext,
  `kpi18` mediumtext,
  `kpi19` mediumtext,
  `kpi20` mediumtext,
  `score_score` float DEFAULT '0',
  `score1` mediumtext,
  `score2` mediumtext,
  `score3` mediumtext,
  `score4` mediumtext,
  `score5` mediumtext,
  `score6` mediumtext,
  `score7` mediumtext,
  `score8` mediumtext,
  `score9` mediumtext,
  `score10` mediumtext,
  `score11` mediumtext,
  `score12` mediumtext,
  `score13` mediumtext,
  `score14` mediumtext,
  `score15` mediumtext,
  `score16` mediumtext,
  `score17` mediumtext,
  `score18` mediumtext,
  `score19` mediumtext,
  `score20` mediumtext,
  `score21` mediumtext,
  `score22` mediumtext,
  `score23` mediumtext,
  `score24` mediumtext,
  `score25` mediumtext,
  `score26` mediumtext,
  `score27` mediumtext,
  `score28` mediumtext,
  `score29` mediumtext,
  `score30` mediumtext,
  `score31` mediumtext,
  `score32` mediumtext,
  `score33` mediumtext,
  `score34` mediumtext,
  `score35` mediumtext,
  `score36` mediumtext,
  `score37` mediumtext,
  `score38` mediumtext,
  `score39` mediumtext,
  `score40` mediumtext,
  `score41` mediumtext,
  `score42` mediumtext,
  `score43` mediumtext,
  `score44` mediumtext,
  `score45` mediumtext,
  `score46` mediumtext,
  `score47` mediumtext,
  `score48` mediumtext,
  `score49` mediumtext,
  `score50` mediumtext,
  `total_score` float DEFAULT '0',
  `in_date` char(20) DEFAULT NULL,
  `date_4_8` char(20) DEFAULT NULL,
  `date_8_10` char(20) DEFAULT NULL,
  `date_10_18` char(20) DEFAULT NULL,
  `date_18_22` char(20) DEFAULT NULL,
  `out_date` char(20) DEFAULT NULL,
  `description1` char(255) DEFAULT NULL,
  `description2` char(255) DEFAULT NULL,
  `description3` char(255) DEFAULT NULL,
  `trans_date` datetime DEFAULT NULL,
  `grp_code` char(3) DEFAULT NULL,
  `grp_name` char(255) DEFAULT NULL,
  `bgt_code` char(6) DEFAULT NULL,
  `bgt_name` char(255) DEFAULT NULL,
  `bgt_type` char(10) DEFAULT NULL,
  `trans_code` char(50) DEFAULT NULL,
  `trans_detail` char(255) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `JAN` decimal(20,2) DEFAULT NULL,
  `FEB` decimal(20,2) DEFAULT NULL,
  `MAR` decimal(20,2) DEFAULT NULL,
  `APR` decimal(20,2) DEFAULT NULL,
  `MAY` decimal(20,2) DEFAULT NULL,
  `JUN` decimal(20,2) DEFAULT NULL,
  `JUL` decimal(20,2) DEFAULT NULL,
  `AUG` decimal(20,2) DEFAULT NULL,
  `SEP` decimal(20,2) DEFAULT NULL,
  `OCT` decimal(20,2) DEFAULT NULL,
  `NOV` decimal(20,2) DEFAULT NULL,
  `DEC` decimal(20,2) DEFAULT NULL,
  `initiator` char(100) DEFAULT NULL,
  `owner` char(100) DEFAULT NULL,
  `admin` char(100) DEFAULT NULL,
  `description` text,
  `type_code` char(20) DEFAULT NULL,
  `type_name` char(200) DEFAULT NULL,
  `category_code` char(20) DEFAULT NULL,
  `category_name` char(200) DEFAULT NULL,
  `group_code` char(10) DEFAULT NULL,
  `cause` text,
  `impact` text,
  `mitigant` text,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `solve_date` date DEFAULT NULL,
  `period` int(11) DEFAULT NULL,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.rpt_2
DROP TABLE IF EXISTS `rpt_2`;
CREATE TABLE IF NOT EXISTS `rpt_2` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` char(20) NOT NULL,
  `username` char(100) NOT NULL,
  `username1` char(100) NOT NULL,
  `password` char(50) DEFAULT NULL,
  `registered_date` datetime DEFAULT NULL,
  `user_log` char(40) DEFAULT NULL,
  `user_period` int(11) DEFAULT NULL,
  `last_log` datetime DEFAULT NULL,
  `division_code` char(15) DEFAULT NULL,
  `division` char(100) DEFAULT NULL,
  `department_code` char(15) DEFAULT NULL,
  `department` char(255) DEFAULT NULL,
  `directorate` char(255) DEFAULT NULL,
  `manager` char(255) DEFAULT NULL,
  `dept_head` char(255) DEFAULT NULL,
  `director` char(255) DEFAULT NULL,
  `job_grade` char(50) DEFAULT NULL,
  `job_step` char(2) DEFAULT NULL,
  `job_name` char(50) DEFAULT NULL,
  `job_contract` char(50) DEFAULT NULL,
  `job_category_code` char(15) DEFAULT NULL,
  `job_category` char(50) DEFAULT NULL,
  `job_description` char(100) DEFAULT NULL,
  `grade_type` char(10) DEFAULT '100%',
  `status` char(10) DEFAULT NULL,
  `access` mediumtext,
  `remarks` mediumtext,
  `approve` char(50) DEFAULT NULL,
  `allowance_load` text,
  `deduction_load` text,
  `submit_by` char(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `title` char(15) DEFAULT NULL,
  `first_name` char(100) DEFAULT '',
  `middle_name` char(100) DEFAULT '',
  `last_name` char(100) DEFAULT '',
  `fullname` char(255) DEFAULT '',
  `maiden_name` char(100) DEFAULT '',
  `address` char(255) DEFAULT NULL,
  `email` char(100) DEFAULT NULL,
  `phone` char(50) DEFAULT '',
  `mobile` char(50) DEFAULT '',
  `gender` char(10) DEFAULT NULL,
  `birth_date` date DEFAULT NULL,
  `marital_status` char(20) DEFAULT NULL,
  `state_origin` char(50) DEFAULT NULL,
  `nationality` char(50) DEFAULT NULL,
  `identification` char(100) DEFAULT NULL,
  `date_employment` date DEFAULT NULL,
  `date_confirm` date DEFAULT NULL,
  `date_pension` date DEFAULT NULL,
  `date_promotion` date DEFAULT NULL,
  `promotion_detail` char(255) DEFAULT NULL,
  `date_termination` date DEFAULT NULL,
  `max_leave` int(11) DEFAULT NULL,
  `appraisal` char(255) DEFAULT NULL,
  `appraisal_date` datetime DEFAULT NULL,
  `spouse_name` char(255) DEFAULT NULL,
  `spouse_phone` char(30) DEFAULT NULL,
  `spouse_address` char(255) DEFAULT NULL,
  `child1` char(255) DEFAULT NULL,
  `child2` char(255) DEFAULT NULL,
  `child3` char(255) DEFAULT NULL,
  `child4` char(255) DEFAULT NULL,
  `kin_name` char(255) DEFAULT NULL,
  `kin_phone` char(30) DEFAULT NULL,
  `kin_address` char(255) DEFAULT NULL,
  `kin_relation` char(50) DEFAULT NULL,
  `bank_code` char(15) DEFAULT NULL,
  `bank_name` char(255) DEFAULT NULL,
  `bank_address` char(255) DEFAULT NULL,
  `account_name` char(255) DEFAULT NULL,
  `account_number` char(255) DEFAULT NULL,
  `PFA_code` char(15) DEFAULT NULL,
  `PFA` char(255) DEFAULT NULL,
  `RSA_number` char(30) DEFAULT NULL,
  `NHF_code` char(255) DEFAULT NULL,
  `NHF` char(255) DEFAULT NULL,
  `manager_recommend` char(255) DEFAULT NULL,
  `manager_improve` char(255) DEFAULT NULL,
  `manager_improve_option` char(255) DEFAULT NULL,
  `manager_improve_action` text,
  `dept_head_recommend` char(255) DEFAULT NULL,
  `director_recommend` mediumtext,
  `hr_recommend` char(255) DEFAULT NULL,
  `final_recommend` char(255) DEFAULT NULL,
  `final_comment` mediumtext,
  `reference1` char(255) DEFAULT NULL,
  `reference2` char(255) DEFAULT NULL,
  `reference3` char(255) DEFAULT NULL,
  `qualification` mediumtext,
  `qualification1` char(255) DEFAULT NULL,
  `qualification2` char(255) DEFAULT NULL,
  `qualification3` char(255) DEFAULT NULL,
  `qualification4` char(255) DEFAULT NULL,
  `qualification5` char(255) DEFAULT NULL,
  `qualification6` char(255) DEFAULT NULL,
  `qualification7` char(255) DEFAULT NULL,
  `qualification8` char(255) DEFAULT NULL,
  `qualification9` char(255) DEFAULT NULL,
  `qualification10` char(255) DEFAULT NULL,
  `certification` mediumtext,
  `certification1` char(255) DEFAULT NULL,
  `certification2` char(255) DEFAULT NULL,
  `certification3` char(255) DEFAULT NULL,
  `certification4` char(255) DEFAULT NULL,
  `certification5` char(255) DEFAULT NULL,
  `certification6` char(255) DEFAULT NULL,
  `certification7` char(255) DEFAULT NULL,
  `certification8` char(255) DEFAULT NULL,
  `certification9` char(255) DEFAULT NULL,
  `certification10` char(255) DEFAULT NULL,
  `payroll_date` datetime DEFAULT NULL,
  `payroll_slip` mediumtext,
  `allowance1` decimal(19,4) DEFAULT '0.0000',
  `allowance2` decimal(19,4) DEFAULT '0.0000',
  `allowance3` decimal(19,4) DEFAULT '0.0000',
  `allowance4` decimal(19,4) DEFAULT '0.0000',
  `allowance5` decimal(19,4) DEFAULT '0.0000',
  `allowance6` decimal(19,4) DEFAULT '0.0000',
  `allowance7` decimal(19,4) DEFAULT '0.0000',
  `allowance8` decimal(19,4) DEFAULT '0.0000',
  `allowance9` decimal(19,4) DEFAULT '0.0000',
  `allowance10` decimal(19,4) DEFAULT '0.0000',
  `allowance11` decimal(19,4) DEFAULT '0.0000',
  `allowance12` decimal(19,4) DEFAULT '0.0000',
  `allowance13` decimal(19,4) DEFAULT '0.0000',
  `allowance14` decimal(19,4) DEFAULT '0.0000',
  `allowance15` decimal(19,4) DEFAULT '0.0000',
  `allowance16` decimal(19,4) DEFAULT '0.0000',
  `allowance17` decimal(19,4) DEFAULT '0.0000',
  `allowance18` decimal(19,4) DEFAULT '0.0000',
  `allowance19` decimal(19,4) DEFAULT '0.0000',
  `allowance20` decimal(19,4) DEFAULT '0.0000',
  `allowance21` decimal(19,4) DEFAULT '0.0000',
  `allowance22` decimal(19,4) DEFAULT '0.0000',
  `allowance23` decimal(19,4) DEFAULT '0.0000',
  `allowance24` decimal(19,4) DEFAULT '0.0000',
  `allowance25` decimal(19,4) DEFAULT '0.0000',
  `allowance26` decimal(19,4) DEFAULT '0.0000',
  `allowance27` decimal(19,4) DEFAULT '0.0000',
  `allowance28` decimal(19,4) DEFAULT '0.0000',
  `allowance29` decimal(19,4) DEFAULT '0.0000',
  `allowance30` decimal(19,4) DEFAULT '0.0000',
  `allowance31` decimal(19,4) DEFAULT '0.0000',
  `allowance32` decimal(19,4) DEFAULT '0.0000',
  `allowance33` decimal(19,4) DEFAULT '0.0000',
  `allowance34` decimal(19,4) DEFAULT '0.0000',
  `allowance35` decimal(19,4) DEFAULT '0.0000',
  `allowance36` decimal(19,4) DEFAULT '0.0000',
  `allowance37` decimal(19,4) DEFAULT '0.0000',
  `allowance38` decimal(19,4) DEFAULT '0.0000',
  `allowance39` decimal(19,4) DEFAULT '0.0000',
  `allowance40` decimal(19,4) DEFAULT '0.0000',
  `allowance41` decimal(19,4) DEFAULT '0.0000',
  `allowance42` decimal(19,4) DEFAULT '0.0000',
  `allowance43` decimal(19,4) DEFAULT '0.0000',
  `allowance44` decimal(19,4) DEFAULT '0.0000',
  `allowance45` decimal(19,4) DEFAULT '0.0000',
  `allowance46` decimal(19,4) DEFAULT '0.0000',
  `allowance47` decimal(19,4) DEFAULT '0.0000',
  `allowance48` decimal(19,4) DEFAULT '0.0000',
  `allowance49` decimal(19,4) DEFAULT '0.0000',
  `allowance50` decimal(19,4) DEFAULT '0.0000',
  `allowance51` decimal(19,4) DEFAULT '0.0000',
  `allowance52` decimal(19,4) DEFAULT '0.0000',
  `allowance53` decimal(19,4) DEFAULT '0.0000',
  `allowance54` decimal(19,4) DEFAULT '0.0000',
  `allowance55` decimal(19,4) DEFAULT '0.0000',
  `allowance56` decimal(19,4) DEFAULT '0.0000',
  `allowance57` decimal(19,4) DEFAULT '0.0000',
  `allowance58` decimal(19,4) DEFAULT '0.0000',
  `allowance59` decimal(19,4) DEFAULT '0.0000',
  `allowance60` decimal(19,4) DEFAULT '0.0000',
  `allowance61` decimal(19,4) DEFAULT '0.0000',
  `allowance62` decimal(19,4) DEFAULT '0.0000',
  `allowance63` decimal(19,4) DEFAULT '0.0000',
  `allowance64` decimal(19,4) DEFAULT '0.0000',
  `allowance65` decimal(19,4) DEFAULT '0.0000',
  `allowance66` decimal(19,4) DEFAULT '0.0000',
  `allowance67` decimal(19,4) DEFAULT '0.0000',
  `allowance68` decimal(19,4) DEFAULT '0.0000',
  `allowance69` decimal(19,4) DEFAULT '0.0000',
  `allowance70` decimal(19,4) DEFAULT '0.0000',
  `allowance71` decimal(19,4) DEFAULT '0.0000',
  `allowance72` decimal(19,4) DEFAULT '0.0000',
  `allowance73` decimal(19,4) DEFAULT '0.0000',
  `allowance74` decimal(19,4) DEFAULT '0.0000',
  `allowance75` decimal(19,4) DEFAULT '0.0000',
  `allowance76` decimal(19,4) DEFAULT '0.0000',
  `allowance77` decimal(19,4) DEFAULT '0.0000',
  `allowance78` decimal(19,4) DEFAULT '0.0000',
  `allowance79` decimal(19,4) DEFAULT '0.0000',
  `allowance80` decimal(19,4) DEFAULT '0.0000',
  `allowance81` decimal(19,4) DEFAULT '0.0000',
  `allowance82` decimal(19,4) DEFAULT '0.0000',
  `allowance83` decimal(19,4) DEFAULT '0.0000',
  `allowance84` decimal(19,4) DEFAULT '0.0000',
  `allowance85` decimal(19,4) DEFAULT '0.0000',
  `allowance86` decimal(19,4) DEFAULT '0.0000',
  `allowance87` decimal(19,4) DEFAULT '0.0000',
  `allowance88` decimal(19,4) DEFAULT '0.0000',
  `allowance89` decimal(19,4) DEFAULT '0.0000',
  `allowance90` decimal(19,4) DEFAULT '0.0000',
  `allowance91` decimal(19,4) DEFAULT '0.0000',
  `allowance92` decimal(19,4) DEFAULT '0.0000',
  `allowance93` decimal(19,4) DEFAULT '0.0000',
  `allowance94` decimal(19,4) DEFAULT '0.0000',
  `allowance95` decimal(19,4) DEFAULT '0.0000',
  `allowance96` decimal(19,4) DEFAULT '0.0000',
  `allowance97` decimal(19,4) DEFAULT '0.0000',
  `allowance98` decimal(19,4) DEFAULT '0.0000',
  `allowance99` decimal(19,4) DEFAULT '0.0000',
  `allowance100` decimal(19,4) DEFAULT '0.0000',
  `other_allowance` decimal(19,4) DEFAULT '0.0000',
  `total_allowance` decimal(19,4) DEFAULT '0.0000',
  `deduction1` decimal(19,4) DEFAULT '0.0000',
  `deduction2` decimal(19,4) DEFAULT '0.0000',
  `deduction3` decimal(19,4) DEFAULT '0.0000',
  `deduction4` decimal(19,4) DEFAULT '0.0000',
  `deduction5` decimal(19,4) DEFAULT '0.0000',
  `deduction6` decimal(19,4) DEFAULT '0.0000',
  `deduction7` decimal(19,4) DEFAULT '0.0000',
  `deduction8` decimal(19,4) DEFAULT '0.0000',
  `deduction9` decimal(19,4) DEFAULT '0.0000',
  `deduction10` decimal(19,4) DEFAULT '0.0000',
  `deduction11` decimal(19,4) DEFAULT '0.0000',
  `deduction12` decimal(19,4) DEFAULT '0.0000',
  `deduction13` decimal(19,4) DEFAULT '0.0000',
  `deduction14` decimal(19,4) DEFAULT '0.0000',
  `deduction15` decimal(19,4) DEFAULT '0.0000',
  `deduction16` decimal(19,4) DEFAULT '0.0000',
  `deduction17` decimal(19,4) DEFAULT '0.0000',
  `deduction18` decimal(19,4) DEFAULT '0.0000',
  `deduction19` decimal(19,4) DEFAULT '0.0000',
  `deduction20` decimal(19,4) DEFAULT '0.0000',
  `deduction21` decimal(19,4) DEFAULT '0.0000',
  `deduction22` decimal(19,4) DEFAULT '0.0000',
  `deduction23` decimal(19,4) DEFAULT '0.0000',
  `deduction24` decimal(19,4) DEFAULT '0.0000',
  `deduction25` decimal(19,4) DEFAULT '0.0000',
  `deduction26` decimal(19,4) DEFAULT '0.0000',
  `deduction27` decimal(19,4) DEFAULT '0.0000',
  `deduction28` decimal(19,4) DEFAULT '0.0000',
  `deduction29` decimal(19,4) DEFAULT '0.0000',
  `deduction30` decimal(19,4) DEFAULT '0.0000',
  `deduction31` decimal(19,4) DEFAULT '0.0000',
  `deduction32` decimal(19,4) DEFAULT '0.0000',
  `deduction33` decimal(19,4) DEFAULT '0.0000',
  `deduction34` decimal(19,4) DEFAULT '0.0000',
  `deduction35` decimal(19,4) DEFAULT '0.0000',
  `deduction36` decimal(19,4) DEFAULT '0.0000',
  `deduction37` decimal(19,4) DEFAULT '0.0000',
  `deduction38` decimal(19,4) DEFAULT '0.0000',
  `deduction39` decimal(19,4) DEFAULT '0.0000',
  `deduction40` decimal(19,4) DEFAULT '0.0000',
  `deduction41` decimal(19,4) DEFAULT '0.0000',
  `deduction42` decimal(19,4) DEFAULT '0.0000',
  `deduction43` decimal(19,4) DEFAULT '0.0000',
  `deduction44` decimal(19,4) DEFAULT '0.0000',
  `deduction45` decimal(19,4) DEFAULT '0.0000',
  `deduction46` decimal(19,4) DEFAULT '0.0000',
  `deduction47` decimal(19,4) DEFAULT '0.0000',
  `deduction48` decimal(19,4) DEFAULT '0.0000',
  `deduction49` decimal(19,4) DEFAULT '0.0000',
  `deduction50` decimal(19,4) DEFAULT '0.0000',
  `deduction51` decimal(19,4) DEFAULT '0.0000',
  `deduction52` decimal(19,4) DEFAULT '0.0000',
  `deduction53` decimal(19,4) DEFAULT '0.0000',
  `deduction54` decimal(19,4) DEFAULT '0.0000',
  `deduction55` decimal(19,4) DEFAULT '0.0000',
  `deduction56` decimal(19,4) DEFAULT '0.0000',
  `deduction57` decimal(19,4) DEFAULT '0.0000',
  `deduction58` decimal(19,4) DEFAULT '0.0000',
  `deduction59` decimal(19,4) DEFAULT '0.0000',
  `deduction60` decimal(19,4) DEFAULT '0.0000',
  `deduction61` decimal(19,4) DEFAULT '0.0000',
  `deduction62` decimal(19,4) DEFAULT '0.0000',
  `deduction63` decimal(19,4) DEFAULT '0.0000',
  `deduction64` decimal(19,4) DEFAULT '0.0000',
  `deduction65` decimal(19,4) DEFAULT '0.0000',
  `deduction66` decimal(19,4) DEFAULT '0.0000',
  `deduction67` decimal(19,4) DEFAULT '0.0000',
  `deduction68` decimal(19,4) DEFAULT '0.0000',
  `deduction69` decimal(19,4) DEFAULT '0.0000',
  `deduction70` decimal(19,4) DEFAULT '0.0000',
  `deduction71` decimal(19,4) DEFAULT '0.0000',
  `deduction72` decimal(19,4) DEFAULT '0.0000',
  `deduction73` decimal(19,4) DEFAULT '0.0000',
  `deduction74` decimal(19,4) DEFAULT '0.0000',
  `deduction75` decimal(19,4) DEFAULT '0.0000',
  `deduction76` decimal(19,4) DEFAULT '0.0000',
  `deduction77` decimal(19,4) DEFAULT '0.0000',
  `deduction78` decimal(19,4) DEFAULT '0.0000',
  `deduction79` decimal(19,4) DEFAULT '0.0000',
  `deduction80` decimal(19,4) DEFAULT '0.0000',
  `deduction81` decimal(19,4) DEFAULT '0.0000',
  `deduction82` decimal(19,4) DEFAULT '0.0000',
  `deduction83` decimal(19,4) DEFAULT '0.0000',
  `deduction84` decimal(19,4) DEFAULT '0.0000',
  `deduction85` decimal(19,4) DEFAULT '0.0000',
  `deduction86` decimal(19,4) DEFAULT '0.0000',
  `deduction87` decimal(19,4) DEFAULT '0.0000',
  `deduction88` decimal(19,4) DEFAULT '0.0000',
  `deduction89` decimal(19,4) DEFAULT '0.0000',
  `deduction90` decimal(19,4) DEFAULT '0.0000',
  `deduction91` decimal(19,4) DEFAULT '0.0000',
  `deduction92` decimal(19,4) DEFAULT '0.0000',
  `deduction93` decimal(19,4) DEFAULT '0.0000',
  `deduction94` decimal(19,4) DEFAULT '0.0000',
  `deduction95` decimal(19,4) DEFAULT '0.0000',
  `deduction96` decimal(19,4) DEFAULT '0.0000',
  `deduction97` decimal(19,4) DEFAULT '0.0000',
  `deduction98` decimal(19,4) DEFAULT '0.0000',
  `deduction99` decimal(19,4) DEFAULT '0.0000',
  `deduction100` decimal(19,4) DEFAULT '0.0000',
  `other_deduction` decimal(19,4) DEFAULT '0.0000',
  `total_deduction` decimal(19,4) DEFAULT '0.0000',
  `net_pay` decimal(19,4) DEFAULT '0.0000',
  `kpi_score` float DEFAULT '0',
  `kpi1` mediumtext,
  `kpi2` mediumtext,
  `kpi3` mediumtext,
  `kpi4` mediumtext,
  `kpi5` mediumtext,
  `kpi6` mediumtext,
  `kpi7` mediumtext,
  `kpi8` mediumtext,
  `kpi9` mediumtext,
  `kpi10` mediumtext,
  `kpi11` mediumtext,
  `kpi12` mediumtext,
  `kpi13` mediumtext,
  `kpi14` mediumtext,
  `kpi15` mediumtext,
  `kpi16` mediumtext,
  `kpi17` mediumtext,
  `kpi18` mediumtext,
  `kpi19` mediumtext,
  `kpi20` mediumtext,
  `score_score` float DEFAULT '0',
  `score1` mediumtext,
  `score2` mediumtext,
  `score3` mediumtext,
  `score4` mediumtext,
  `score5` mediumtext,
  `score6` mediumtext,
  `score7` mediumtext,
  `score8` mediumtext,
  `score9` mediumtext,
  `score10` mediumtext,
  `score11` mediumtext,
  `score12` mediumtext,
  `score13` mediumtext,
  `score14` mediumtext,
  `score15` mediumtext,
  `score16` mediumtext,
  `score17` mediumtext,
  `score18` mediumtext,
  `score19` mediumtext,
  `score20` mediumtext,
  `score21` mediumtext,
  `score22` mediumtext,
  `score23` mediumtext,
  `score24` mediumtext,
  `score25` mediumtext,
  `score26` mediumtext,
  `score27` mediumtext,
  `score28` mediumtext,
  `score29` mediumtext,
  `score30` mediumtext,
  `score31` mediumtext,
  `score32` mediumtext,
  `score33` mediumtext,
  `score34` mediumtext,
  `score35` mediumtext,
  `score36` mediumtext,
  `score37` mediumtext,
  `score38` mediumtext,
  `score39` mediumtext,
  `score40` mediumtext,
  `score41` mediumtext,
  `score42` mediumtext,
  `score43` mediumtext,
  `score44` mediumtext,
  `score45` mediumtext,
  `score46` mediumtext,
  `score47` mediumtext,
  `score48` mediumtext,
  `score49` mediumtext,
  `score50` mediumtext,
  `total_score` float DEFAULT '0',
  `in_date` char(20) DEFAULT NULL,
  `date_4_8` char(20) DEFAULT NULL,
  `date_8_10` char(20) DEFAULT NULL,
  `date_10_18` char(20) DEFAULT NULL,
  `date_18_22` char(20) DEFAULT NULL,
  `out_date` char(20) DEFAULT NULL,
  `description1` char(255) DEFAULT NULL,
  `description2` char(255) DEFAULT NULL,
  `description3` char(255) DEFAULT NULL,
  `trans_date` datetime DEFAULT NULL,
  `grp_code` char(3) DEFAULT NULL,
  `grp_name` char(255) DEFAULT NULL,
  `bgt_code` char(6) DEFAULT NULL,
  `bgt_name` char(255) DEFAULT NULL,
  `bgt_type` char(10) DEFAULT NULL,
  `trans_code` char(50) DEFAULT NULL,
  `trans_detail` char(255) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `JAN` decimal(20,2) DEFAULT NULL,
  `FEB` decimal(20,2) DEFAULT NULL,
  `MAR` decimal(20,2) DEFAULT NULL,
  `APR` decimal(20,2) DEFAULT NULL,
  `MAY` decimal(20,2) DEFAULT NULL,
  `JUN` decimal(20,2) DEFAULT NULL,
  `JUL` decimal(20,2) DEFAULT NULL,
  `AUG` decimal(20,2) DEFAULT NULL,
  `SEP` decimal(20,2) DEFAULT NULL,
  `OCT` decimal(20,2) DEFAULT NULL,
  `NOV` decimal(20,2) DEFAULT NULL,
  `DEC` decimal(20,2) DEFAULT NULL,
  `initiator` char(100) DEFAULT NULL,
  `owner` char(100) DEFAULT NULL,
  `admin` char(100) DEFAULT NULL,
  `description` text,
  `type_code` char(20) DEFAULT NULL,
  `type_name` char(200) DEFAULT NULL,
  `category_code` char(20) DEFAULT NULL,
  `category_name` char(200) DEFAULT NULL,
  `group_code` char(10) DEFAULT NULL,
  `cause` text,
  `impact` text,
  `mitigant` text,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `solve_date` date DEFAULT NULL,
  `period` int(11) DEFAULT NULL,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

-- Dumping structure for table ehrmdemo.rpt_3
DROP TABLE IF EXISTS `rpt_3`;
CREATE TABLE IF NOT EXISTS `rpt_3` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` char(20) NOT NULL,
  `username` char(100) NOT NULL,
  `username1` char(100) NOT NULL,
  `password` char(50) DEFAULT NULL,
  `registered_date` datetime DEFAULT NULL,
  `user_log` char(40) DEFAULT NULL,
  `user_period` int(11) DEFAULT NULL,
  `last_log` datetime DEFAULT NULL,
  `division_code` char(15) DEFAULT NULL,
  `division` char(100) DEFAULT NULL,
  `department_code` char(15) DEFAULT NULL,
  `department` char(255) DEFAULT NULL,
  `directorate` char(255) DEFAULT NULL,
  `manager` char(255) DEFAULT NULL,
  `dept_head` char(255) DEFAULT NULL,
  `director` char(255) DEFAULT NULL,
  `job_grade` char(50) DEFAULT NULL,
  `job_step` char(2) DEFAULT NULL,
  `job_name` char(50) DEFAULT NULL,
  `job_contract` char(50) DEFAULT NULL,
  `job_category_code` char(15) DEFAULT NULL,
  `job_category` char(50) DEFAULT NULL,
  `job_description` char(100) DEFAULT NULL,
  `grade_type` char(10) DEFAULT '100%',
  `status` char(10) DEFAULT NULL,
  `access` mediumtext,
  `remarks` mediumtext,
  `approve` char(50) DEFAULT NULL,
  `allowance_load` text,
  `deduction_load` text,
  `submit_by` char(100) DEFAULT NULL,
  `submit_on` datetime DEFAULT NULL,
  `title` char(15) DEFAULT NULL,
  `first_name` char(100) DEFAULT '',
  `middle_name` char(100) DEFAULT '',
  `last_name` char(100) DEFAULT '',
  `fullname` char(255) DEFAULT '',
  `maiden_name` char(100) DEFAULT '',
  `address` char(255) DEFAULT NULL,
  `email` char(100) DEFAULT NULL,
  `phone` char(50) DEFAULT '',
  `mobile` char(50) DEFAULT '',
  `gender` char(10) DEFAULT NULL,
  `birth_date` date DEFAULT NULL,
  `marital_status` char(20) DEFAULT NULL,
  `state_origin` char(50) DEFAULT NULL,
  `nationality` char(50) DEFAULT NULL,
  `identification` char(100) DEFAULT NULL,
  `date_employment` date DEFAULT NULL,
  `date_confirm` date DEFAULT NULL,
  `date_pension` date DEFAULT NULL,
  `date_promotion` date DEFAULT NULL,
  `promotion_detail` char(255) DEFAULT NULL,
  `date_termination` date DEFAULT NULL,
  `max_leave` int(11) DEFAULT NULL,
  `appraisal` char(255) DEFAULT NULL,
  `appraisal_date` datetime DEFAULT NULL,
  `spouse_name` char(255) DEFAULT NULL,
  `spouse_phone` char(30) DEFAULT NULL,
  `spouse_address` char(255) DEFAULT NULL,
  `child1` char(255) DEFAULT NULL,
  `child2` char(255) DEFAULT NULL,
  `child3` char(255) DEFAULT NULL,
  `child4` char(255) DEFAULT NULL,
  `kin_name` char(255) DEFAULT NULL,
  `kin_phone` char(30) DEFAULT NULL,
  `kin_address` char(255) DEFAULT NULL,
  `kin_relation` char(50) DEFAULT NULL,
  `bank_code` char(15) DEFAULT NULL,
  `bank_name` char(255) DEFAULT NULL,
  `bank_address` char(255) DEFAULT NULL,
  `account_name` char(255) DEFAULT NULL,
  `account_number` char(255) DEFAULT NULL,
  `PFA_code` char(15) DEFAULT NULL,
  `PFA` char(255) DEFAULT NULL,
  `RSA_number` char(30) DEFAULT NULL,
  `NHF_code` char(255) DEFAULT NULL,
  `NHF` char(255) DEFAULT NULL,
  `manager_recommend` char(255) DEFAULT NULL,
  `manager_improve` char(255) DEFAULT NULL,
  `manager_improve_option` char(255) DEFAULT NULL,
  `manager_improve_action` text,
  `dept_head_recommend` char(255) DEFAULT NULL,
  `director_recommend` mediumtext,
  `hr_recommend` char(255) DEFAULT NULL,
  `final_recommend` char(255) DEFAULT NULL,
  `final_comment` mediumtext,
  `reference1` char(255) DEFAULT NULL,
  `reference2` char(255) DEFAULT NULL,
  `reference3` char(255) DEFAULT NULL,
  `qualification` mediumtext,
  `qualification1` char(255) DEFAULT NULL,
  `qualification2` char(255) DEFAULT NULL,
  `qualification3` char(255) DEFAULT NULL,
  `qualification4` char(255) DEFAULT NULL,
  `qualification5` char(255) DEFAULT NULL,
  `qualification6` char(255) DEFAULT NULL,
  `qualification7` char(255) DEFAULT NULL,
  `qualification8` char(255) DEFAULT NULL,
  `qualification9` char(255) DEFAULT NULL,
  `qualification10` char(255) DEFAULT NULL,
  `certification` mediumtext,
  `certification1` char(255) DEFAULT NULL,
  `certification2` char(255) DEFAULT NULL,
  `certification3` char(255) DEFAULT NULL,
  `certification4` char(255) DEFAULT NULL,
  `certification5` char(255) DEFAULT NULL,
  `certification6` char(255) DEFAULT NULL,
  `certification7` char(255) DEFAULT NULL,
  `certification8` char(255) DEFAULT NULL,
  `certification9` char(255) DEFAULT NULL,
  `certification10` char(255) DEFAULT NULL,
  `payroll_date` datetime DEFAULT NULL,
  `payroll_slip` mediumtext,
  `allowance1` decimal(19,4) DEFAULT '0.0000',
  `allowance2` decimal(19,4) DEFAULT '0.0000',
  `allowance3` decimal(19,4) DEFAULT '0.0000',
  `allowance4` decimal(19,4) DEFAULT '0.0000',
  `allowance5` decimal(19,4) DEFAULT '0.0000',
  `allowance6` decimal(19,4) DEFAULT '0.0000',
  `allowance7` decimal(19,4) DEFAULT '0.0000',
  `allowance8` decimal(19,4) DEFAULT '0.0000',
  `allowance9` decimal(19,4) DEFAULT '0.0000',
  `allowance10` decimal(19,4) DEFAULT '0.0000',
  `allowance11` decimal(19,4) DEFAULT '0.0000',
  `allowance12` decimal(19,4) DEFAULT '0.0000',
  `allowance13` decimal(19,4) DEFAULT '0.0000',
  `allowance14` decimal(19,4) DEFAULT '0.0000',
  `allowance15` decimal(19,4) DEFAULT '0.0000',
  `allowance16` decimal(19,4) DEFAULT '0.0000',
  `allowance17` decimal(19,4) DEFAULT '0.0000',
  `allowance18` decimal(19,4) DEFAULT '0.0000',
  `allowance19` decimal(19,4) DEFAULT '0.0000',
  `allowance20` decimal(19,4) DEFAULT '0.0000',
  `allowance21` decimal(19,4) DEFAULT '0.0000',
  `allowance22` decimal(19,4) DEFAULT '0.0000',
  `allowance23` decimal(19,4) DEFAULT '0.0000',
  `allowance24` decimal(19,4) DEFAULT '0.0000',
  `allowance25` decimal(19,4) DEFAULT '0.0000',
  `allowance26` decimal(19,4) DEFAULT '0.0000',
  `allowance27` decimal(19,4) DEFAULT '0.0000',
  `allowance28` decimal(19,4) DEFAULT '0.0000',
  `allowance29` decimal(19,4) DEFAULT '0.0000',
  `allowance30` decimal(19,4) DEFAULT '0.0000',
  `allowance31` decimal(19,4) DEFAULT '0.0000',
  `allowance32` decimal(19,4) DEFAULT '0.0000',
  `allowance33` decimal(19,4) DEFAULT '0.0000',
  `allowance34` decimal(19,4) DEFAULT '0.0000',
  `allowance35` decimal(19,4) DEFAULT '0.0000',
  `allowance36` decimal(19,4) DEFAULT '0.0000',
  `allowance37` decimal(19,4) DEFAULT '0.0000',
  `allowance38` decimal(19,4) DEFAULT '0.0000',
  `allowance39` decimal(19,4) DEFAULT '0.0000',
  `allowance40` decimal(19,4) DEFAULT '0.0000',
  `allowance41` decimal(19,4) DEFAULT '0.0000',
  `allowance42` decimal(19,4) DEFAULT '0.0000',
  `allowance43` decimal(19,4) DEFAULT '0.0000',
  `allowance44` decimal(19,4) DEFAULT '0.0000',
  `allowance45` decimal(19,4) DEFAULT '0.0000',
  `allowance46` decimal(19,4) DEFAULT '0.0000',
  `allowance47` decimal(19,4) DEFAULT '0.0000',
  `allowance48` decimal(19,4) DEFAULT '0.0000',
  `allowance49` decimal(19,4) DEFAULT '0.0000',
  `allowance50` decimal(19,4) DEFAULT '0.0000',
  `allowance51` decimal(19,4) DEFAULT '0.0000',
  `allowance52` decimal(19,4) DEFAULT '0.0000',
  `allowance53` decimal(19,4) DEFAULT '0.0000',
  `allowance54` decimal(19,4) DEFAULT '0.0000',
  `allowance55` decimal(19,4) DEFAULT '0.0000',
  `allowance56` decimal(19,4) DEFAULT '0.0000',
  `allowance57` decimal(19,4) DEFAULT '0.0000',
  `allowance58` decimal(19,4) DEFAULT '0.0000',
  `allowance59` decimal(19,4) DEFAULT '0.0000',
  `allowance60` decimal(19,4) DEFAULT '0.0000',
  `allowance61` decimal(19,4) DEFAULT '0.0000',
  `allowance62` decimal(19,4) DEFAULT '0.0000',
  `allowance63` decimal(19,4) DEFAULT '0.0000',
  `allowance64` decimal(19,4) DEFAULT '0.0000',
  `allowance65` decimal(19,4) DEFAULT '0.0000',
  `allowance66` decimal(19,4) DEFAULT '0.0000',
  `allowance67` decimal(19,4) DEFAULT '0.0000',
  `allowance68` decimal(19,4) DEFAULT '0.0000',
  `allowance69` decimal(19,4) DEFAULT '0.0000',
  `allowance70` decimal(19,4) DEFAULT '0.0000',
  `allowance71` decimal(19,4) DEFAULT '0.0000',
  `allowance72` decimal(19,4) DEFAULT '0.0000',
  `allowance73` decimal(19,4) DEFAULT '0.0000',
  `allowance74` decimal(19,4) DEFAULT '0.0000',
  `allowance75` decimal(19,4) DEFAULT '0.0000',
  `allowance76` decimal(19,4) DEFAULT '0.0000',
  `allowance77` decimal(19,4) DEFAULT '0.0000',
  `allowance78` decimal(19,4) DEFAULT '0.0000',
  `allowance79` decimal(19,4) DEFAULT '0.0000',
  `allowance80` decimal(19,4) DEFAULT '0.0000',
  `allowance81` decimal(19,4) DEFAULT '0.0000',
  `allowance82` decimal(19,4) DEFAULT '0.0000',
  `allowance83` decimal(19,4) DEFAULT '0.0000',
  `allowance84` decimal(19,4) DEFAULT '0.0000',
  `allowance85` decimal(19,4) DEFAULT '0.0000',
  `allowance86` decimal(19,4) DEFAULT '0.0000',
  `allowance87` decimal(19,4) DEFAULT '0.0000',
  `allowance88` decimal(19,4) DEFAULT '0.0000',
  `allowance89` decimal(19,4) DEFAULT '0.0000',
  `allowance90` decimal(19,4) DEFAULT '0.0000',
  `allowance91` decimal(19,4) DEFAULT '0.0000',
  `allowance92` decimal(19,4) DEFAULT '0.0000',
  `allowance93` decimal(19,4) DEFAULT '0.0000',
  `allowance94` decimal(19,4) DEFAULT '0.0000',
  `allowance95` decimal(19,4) DEFAULT '0.0000',
  `allowance96` decimal(19,4) DEFAULT '0.0000',
  `allowance97` decimal(19,4) DEFAULT '0.0000',
  `allowance98` decimal(19,4) DEFAULT '0.0000',
  `allowance99` decimal(19,4) DEFAULT '0.0000',
  `allowance100` decimal(19,4) DEFAULT '0.0000',
  `other_allowance` decimal(19,4) DEFAULT '0.0000',
  `total_allowance` decimal(19,4) DEFAULT '0.0000',
  `deduction1` decimal(19,4) DEFAULT '0.0000',
  `deduction2` decimal(19,4) DEFAULT '0.0000',
  `deduction3` decimal(19,4) DEFAULT '0.0000',
  `deduction4` decimal(19,4) DEFAULT '0.0000',
  `deduction5` decimal(19,4) DEFAULT '0.0000',
  `deduction6` decimal(19,4) DEFAULT '0.0000',
  `deduction7` decimal(19,4) DEFAULT '0.0000',
  `deduction8` decimal(19,4) DEFAULT '0.0000',
  `deduction9` decimal(19,4) DEFAULT '0.0000',
  `deduction10` decimal(19,4) DEFAULT '0.0000',
  `deduction11` decimal(19,4) DEFAULT '0.0000',
  `deduction12` decimal(19,4) DEFAULT '0.0000',
  `deduction13` decimal(19,4) DEFAULT '0.0000',
  `deduction14` decimal(19,4) DEFAULT '0.0000',
  `deduction15` decimal(19,4) DEFAULT '0.0000',
  `deduction16` decimal(19,4) DEFAULT '0.0000',
  `deduction17` decimal(19,4) DEFAULT '0.0000',
  `deduction18` decimal(19,4) DEFAULT '0.0000',
  `deduction19` decimal(19,4) DEFAULT '0.0000',
  `deduction20` decimal(19,4) DEFAULT '0.0000',
  `deduction21` decimal(19,4) DEFAULT '0.0000',
  `deduction22` decimal(19,4) DEFAULT '0.0000',
  `deduction23` decimal(19,4) DEFAULT '0.0000',
  `deduction24` decimal(19,4) DEFAULT '0.0000',
  `deduction25` decimal(19,4) DEFAULT '0.0000',
  `deduction26` decimal(19,4) DEFAULT '0.0000',
  `deduction27` decimal(19,4) DEFAULT '0.0000',
  `deduction28` decimal(19,4) DEFAULT '0.0000',
  `deduction29` decimal(19,4) DEFAULT '0.0000',
  `deduction30` decimal(19,4) DEFAULT '0.0000',
  `deduction31` decimal(19,4) DEFAULT '0.0000',
  `deduction32` decimal(19,4) DEFAULT '0.0000',
  `deduction33` decimal(19,4) DEFAULT '0.0000',
  `deduction34` decimal(19,4) DEFAULT '0.0000',
  `deduction35` decimal(19,4) DEFAULT '0.0000',
  `deduction36` decimal(19,4) DEFAULT '0.0000',
  `deduction37` decimal(19,4) DEFAULT '0.0000',
  `deduction38` decimal(19,4) DEFAULT '0.0000',
  `deduction39` decimal(19,4) DEFAULT '0.0000',
  `deduction40` decimal(19,4) DEFAULT '0.0000',
  `deduction41` decimal(19,4) DEFAULT '0.0000',
  `deduction42` decimal(19,4) DEFAULT '0.0000',
  `deduction43` decimal(19,4) DEFAULT '0.0000',
  `deduction44` decimal(19,4) DEFAULT '0.0000',
  `deduction45` decimal(19,4) DEFAULT '0.0000',
  `deduction46` decimal(19,4) DEFAULT '0.0000',
  `deduction47` decimal(19,4) DEFAULT '0.0000',
  `deduction48` decimal(19,4) DEFAULT '0.0000',
  `deduction49` decimal(19,4) DEFAULT '0.0000',
  `deduction50` decimal(19,4) DEFAULT '0.0000',
  `deduction51` decimal(19,4) DEFAULT '0.0000',
  `deduction52` decimal(19,4) DEFAULT '0.0000',
  `deduction53` decimal(19,4) DEFAULT '0.0000',
  `deduction54` decimal(19,4) DEFAULT '0.0000',
  `deduction55` decimal(19,4) DEFAULT '0.0000',
  `deduction56` decimal(19,4) DEFAULT '0.0000',
  `deduction57` decimal(19,4) DEFAULT '0.0000',
  `deduction58` decimal(19,4) DEFAULT '0.0000',
  `deduction59` decimal(19,4) DEFAULT '0.0000',
  `deduction60` decimal(19,4) DEFAULT '0.0000',
  `deduction61` decimal(19,4) DEFAULT '0.0000',
  `deduction62` decimal(19,4) DEFAULT '0.0000',
  `deduction63` decimal(19,4) DEFAULT '0.0000',
  `deduction64` decimal(19,4) DEFAULT '0.0000',
  `deduction65` decimal(19,4) DEFAULT '0.0000',
  `deduction66` decimal(19,4) DEFAULT '0.0000',
  `deduction67` decimal(19,4) DEFAULT '0.0000',
  `deduction68` decimal(19,4) DEFAULT '0.0000',
  `deduction69` decimal(19,4) DEFAULT '0.0000',
  `deduction70` decimal(19,4) DEFAULT '0.0000',
  `deduction71` decimal(19,4) DEFAULT '0.0000',
  `deduction72` decimal(19,4) DEFAULT '0.0000',
  `deduction73` decimal(19,4) DEFAULT '0.0000',
  `deduction74` decimal(19,4) DEFAULT '0.0000',
  `deduction75` decimal(19,4) DEFAULT '0.0000',
  `deduction76` decimal(19,4) DEFAULT '0.0000',
  `deduction77` decimal(19,4) DEFAULT '0.0000',
  `deduction78` decimal(19,4) DEFAULT '0.0000',
  `deduction79` decimal(19,4) DEFAULT '0.0000',
  `deduction80` decimal(19,4) DEFAULT '0.0000',
  `deduction81` decimal(19,4) DEFAULT '0.0000',
  `deduction82` decimal(19,4) DEFAULT '0.0000',
  `deduction83` decimal(19,4) DEFAULT '0.0000',
  `deduction84` decimal(19,4) DEFAULT '0.0000',
  `deduction85` decimal(19,4) DEFAULT '0.0000',
  `deduction86` decimal(19,4) DEFAULT '0.0000',
  `deduction87` decimal(19,4) DEFAULT '0.0000',
  `deduction88` decimal(19,4) DEFAULT '0.0000',
  `deduction89` decimal(19,4) DEFAULT '0.0000',
  `deduction90` decimal(19,4) DEFAULT '0.0000',
  `deduction91` decimal(19,4) DEFAULT '0.0000',
  `deduction92` decimal(19,4) DEFAULT '0.0000',
  `deduction93` decimal(19,4) DEFAULT '0.0000',
  `deduction94` decimal(19,4) DEFAULT '0.0000',
  `deduction95` decimal(19,4) DEFAULT '0.0000',
  `deduction96` decimal(19,4) DEFAULT '0.0000',
  `deduction97` decimal(19,4) DEFAULT '0.0000',
  `deduction98` decimal(19,4) DEFAULT '0.0000',
  `deduction99` decimal(19,4) DEFAULT '0.0000',
  `deduction100` decimal(19,4) DEFAULT '0.0000',
  `other_deduction` decimal(19,4) DEFAULT '0.0000',
  `total_deduction` decimal(19,4) DEFAULT '0.0000',
  `net_pay` decimal(19,4) DEFAULT '0.0000',
  `kpi_score` float DEFAULT '0',
  `kpi1` mediumtext,
  `kpi2` mediumtext,
  `kpi3` mediumtext,
  `kpi4` mediumtext,
  `kpi5` mediumtext,
  `kpi6` mediumtext,
  `kpi7` mediumtext,
  `kpi8` mediumtext,
  `kpi9` mediumtext,
  `kpi10` mediumtext,
  `kpi11` mediumtext,
  `kpi12` mediumtext,
  `kpi13` mediumtext,
  `kpi14` mediumtext,
  `kpi15` mediumtext,
  `kpi16` mediumtext,
  `kpi17` mediumtext,
  `kpi18` mediumtext,
  `kpi19` mediumtext,
  `kpi20` mediumtext,
  `score_score` float DEFAULT '0',
  `score1` mediumtext,
  `score2` mediumtext,
  `score3` mediumtext,
  `score4` mediumtext,
  `score5` mediumtext,
  `score6` mediumtext,
  `score7` mediumtext,
  `score8` mediumtext,
  `score9` mediumtext,
  `score10` mediumtext,
  `score11` mediumtext,
  `score12` mediumtext,
  `score13` mediumtext,
  `score14` mediumtext,
  `score15` mediumtext,
  `score16` mediumtext,
  `score17` mediumtext,
  `score18` mediumtext,
  `score19` mediumtext,
  `score20` mediumtext,
  `score21` mediumtext,
  `score22` mediumtext,
  `score23` mediumtext,
  `score24` mediumtext,
  `score25` mediumtext,
  `score26` mediumtext,
  `score27` mediumtext,
  `score28` mediumtext,
  `score29` mediumtext,
  `score30` mediumtext,
  `score31` mediumtext,
  `score32` mediumtext,
  `score33` mediumtext,
  `score34` mediumtext,
  `score35` mediumtext,
  `score36` mediumtext,
  `score37` mediumtext,
  `score38` mediumtext,
  `score39` mediumtext,
  `score40` mediumtext,
  `score41` mediumtext,
  `score42` mediumtext,
  `score43` mediumtext,
  `score44` mediumtext,
  `score45` mediumtext,
  `score46` mediumtext,
  `score47` mediumtext,
  `score48` mediumtext,
  `score49` mediumtext,
  `score50` mediumtext,
  `total_score` float DEFAULT '0',
  `in_date` char(20) DEFAULT NULL,
  `date_4_8` char(20) DEFAULT NULL,
  `date_8_10` char(20) DEFAULT NULL,
  `date_10_18` char(20) DEFAULT NULL,
  `date_18_22` char(20) DEFAULT NULL,
  `out_date` char(20) DEFAULT NULL,
  `description1` char(255) DEFAULT NULL,
  `description2` char(255) DEFAULT NULL,
  `description3` char(255) DEFAULT NULL,
  `trans_date` datetime DEFAULT NULL,
  `grp_code` char(3) DEFAULT NULL,
  `grp_name` char(255) DEFAULT NULL,
  `bgt_code` char(6) DEFAULT NULL,
  `bgt_name` char(255) DEFAULT NULL,
  `bgt_type` char(10) DEFAULT NULL,
  `trans_code` char(50) DEFAULT NULL,
  `trans_detail` char(255) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `JAN` decimal(20,2) DEFAULT NULL,
  `FEB` decimal(20,2) DEFAULT NULL,
  `MAR` decimal(20,2) DEFAULT NULL,
  `APR` decimal(20,2) DEFAULT NULL,
  `MAY` decimal(20,2) DEFAULT NULL,
  `JUN` decimal(20,2) DEFAULT NULL,
  `JUL` decimal(20,2) DEFAULT NULL,
  `AUG` decimal(20,2) DEFAULT NULL,
  `SEP` decimal(20,2) DEFAULT NULL,
  `OCT` decimal(20,2) DEFAULT NULL,
  `NOV` decimal(20,2) DEFAULT NULL,
  `DEC` decimal(20,2) DEFAULT NULL,
  `initiator` char(100) DEFAULT NULL,
  `owner` char(100) DEFAULT NULL,
  `admin` char(100) DEFAULT NULL,
  `description` text,
  `type_code` char(20) DEFAULT NULL,
  `type_name` char(200) DEFAULT NULL,
  `category_code` char(20) DEFAULT NULL,
  `category_name` char(200) DEFAULT NULL,
  `group_code` char(10) DEFAULT NULL,
  `cause` text,
  `impact` text,
  `mitigant` text,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `solve_date` date DEFAULT NULL,
  `period` int(11) DEFAULT NULL,
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Data exporting was unselected.

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
