-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jan 27, 2020 at 07:37 PM
-- Server version: 5.7.28-0ubuntu0.18.04.4
-- PHP Version: 7.2.24-0ubuntu0.18.04.2

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `hris`
--

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

--
-- Dumping data for table `ref_positions`
--

INSERT INTO `ref_positions` (`id`, `name`, `type`, `default`, `salary_grade`, `created_by`, `updated_by`, `created_at`, `updated_at`, `status`) VALUES
(1, 'Accountant I', 'Staff', 1, 11, NULL, NULL, NULL, NULL, 'APPROVED'),
(2, 'Accountant II', 'Staff', 1, 16, NULL, NULL, NULL, NULL, 'APPROVED'),
(3, 'Accountant III', 'Staff', 1, 16, NULL, NULL, NULL, NULL, 'APPROVED'),
(4, 'Accountant IV', 'Staff', 1, 22, NULL, NULL, NULL, NULL, 'APPROVED'),
(5, 'Administrative Aide I', 'Staff', 1, 1, NULL, NULL, NULL, NULL, 'APPROVED'),
(6, 'Administrative Aide II', 'Staff', 1, 2, NULL, NULL, NULL, NULL, 'APPROVED'),
(7, 'Administrative Aide III', 'Staff', 1, 3, NULL, NULL, NULL, NULL, 'APPROVED'),
(8, 'Administrative Aide IV', 'Staff', 1, 4, NULL, NULL, NULL, NULL, 'APPROVED'),
(9, 'Administrative Aide V', 'Staff', 1, 5, NULL, NULL, NULL, NULL, 'APPROVED'),
(10, 'Administrative Aide VI', 'Staff', 1, 6, NULL, NULL, NULL, NULL, 'APPROVED'),
(11, 'Administrative Assistant I', 'Staff', 1, 7, NULL, NULL, NULL, NULL, 'APPROVED'),
(12, 'Administrative Assistant II', 'Staff', 1, 8, NULL, NULL, NULL, NULL, 'APPROVED'),
(13, 'Administrative Assistant III', 'Staff', 1, 9, NULL, NULL, NULL, NULL, 'APPROVED'),
(14, 'Administrative Assistant V', 'Staff', 1, 11, NULL, NULL, NULL, NULL, 'APPROVED'),
(15, 'Administrative Assistant VI', 'Staff', 1, 12, NULL, NULL, NULL, NULL, 'APPROVED'),
(16, 'Administrative Officer I', 'Staff', 1, 10, NULL, NULL, NULL, NULL, 'APPROVED'),
(17, 'Administrative Officer II', 'Staff', 1, 11, NULL, NULL, NULL, NULL, 'APPROVED'),
(18, 'Administrative Officer III', 'Staff', 1, 14, NULL, NULL, NULL, NULL, 'APPROVED'),
(19, 'Administrative Officer IV', 'Staff', 1, 15, NULL, NULL, NULL, NULL, 'APPROVED'),
(20, 'Administrative Officer V', 'Staff', 1, 18, NULL, NULL, NULL, NULL, 'APPROVED'),
(21, 'Agricultural Technician I', 'Staff', 1, 6, NULL, NULL, NULL, NULL, 'APPROVED'),
(22, 'Agricultural Technician II', 'Staff', 1, 8, NULL, NULL, NULL, NULL, 'APPROVED'),
(23, 'Assistant Professor I', 'Faculty', 1, 15, NULL, NULL, NULL, NULL, 'APPROVED'),
(24, 'Assistant Professor II', 'Faculty', 1, 16, NULL, NULL, NULL, NULL, 'APPROVED'),
(25, 'Assistant Professor III', 'Faculty', 1, 17, NULL, NULL, NULL, NULL, 'APPROVED'),
(26, 'Assistant Professor IV', 'Faculty', 1, 18, NULL, NULL, NULL, NULL, 'APPROVED'),
(27, 'Associate Professor I', 'Faculty', 1, 19, NULL, NULL, NULL, NULL, 'APPROVED'),
(28, 'Associate Professor II', 'Faculty', 1, 20, NULL, NULL, NULL, NULL, 'APPROVED'),
(29, 'Associate Professor III', 'Faculty', 1, 21, NULL, NULL, NULL, NULL, 'APPROVED'),
(30, 'Computer Programmer II', 'Staff', 1, 12, NULL, NULL, NULL, NULL, 'APPROVED'),
(31, 'Associate Professor IV', 'Faculty', 1, 22, NULL, NULL, NULL, NULL, 'APPROVED'),
(32, 'Associate Professor V', 'Faculty', 1, 23, NULL, NULL, NULL, NULL, 'APPROVED'),
(33, 'Attorney IV', 'Staff', 1, 23, NULL, NULL, NULL, NULL, 'APPROVED'),
(34, 'Board Secretary V', 'Staff', 1, 24, NULL, NULL, NULL, NULL, 'APPROVED'),
(35, 'Broadcast Production Supervisor', 'Staff', 1, 19, NULL, NULL, NULL, NULL, 'APPROVED'),
(36, 'Broadcast Program Production Announcer', 'Staff', 1, 15, NULL, NULL, NULL, NULL, 'APPROVED'),
(37, 'Broadcast Program Production Announcer II', 'Staff', 1, 16, NULL, NULL, NULL, NULL, 'APPROVED'),
(38, 'Chief Administrative Officer', 'Staff', 1, 24, NULL, NULL, NULL, NULL, 'APPROVED'),
(39, 'Chief of Hospital I', 'Staff', 1, 24, NULL, NULL, NULL, NULL, 'APPROVED'),
(40, 'College Librarian I', 'Staff', 1, 13, NULL, NULL, NULL, NULL, 'APPROVED'),
(41, 'College Librarian II', 'Staff', 1, 15, NULL, NULL, NULL, NULL, 'APPROVED'),
(42, 'College Librarian IV', 'Staff', 1, 22, NULL, NULL, NULL, NULL, 'APPROVED'),
(43, 'Computer Programmer I', 'Staff', 1, 12, NULL, NULL, NULL, NULL, 'APPROVED'),
(44, 'Construction & Maintenance Foreman', 'Staff', 1, 8, NULL, NULL, NULL, NULL, 'APPROVED'),
(45, 'Dental Aide', 'Staff', 1, 4, NULL, NULL, NULL, NULL, 'APPROVED'),
(46, 'Dentist I', 'Staff', 1, 16, NULL, NULL, NULL, NULL, 'APPROVED'),
(47, 'Dentist II', 'Staff', 1, 17, NULL, NULL, NULL, NULL, 'APPROVED'),
(48, 'Draftsman III', 'Staff', 1, 11, NULL, NULL, NULL, NULL, 'APPROVED'),
(49, 'Education Program Specialist II', 'Staff', 1, 16, NULL, NULL, NULL, NULL, 'APPROVED'),
(50, 'Education Research Assistant I', 'Staff', 1, 9, NULL, NULL, NULL, NULL, 'APPROVED'),
(51, 'Engineer I', 'Staff', 1, 13, NULL, NULL, NULL, NULL, 'APPROVED'),
(52, 'Engineer II', 'Staff', 1, 16, NULL, NULL, NULL, NULL, 'APPROVED'),
(53, 'Engineer III', 'Staff', 1, 19, NULL, NULL, NULL, NULL, 'APPROVED'),
(54, 'Farm Worker I', 'Staff', 1, 2, NULL, NULL, NULL, NULL, 'APPROVED'),
(55, 'Farm Worker II', 'Staff', 1, 4, NULL, NULL, NULL, NULL, 'APPROVED'),
(56, 'Food Service Supervisor I', 'Staff', 1, 9, NULL, NULL, NULL, NULL, 'APPROVED'),
(57, 'Forest Ranger', 'Staff', 1, 4, NULL, NULL, NULL, NULL, 'APPROVED'),
(58, 'Guesthouse Caretaker', 'Staff', 1, 2, NULL, NULL, NULL, NULL, 'APPROVED'),
(59, 'Guidance Coordinator III', 'Staff', 1, 16, NULL, NULL, NULL, NULL, 'APPROVED'),
(60, 'Guidance Counselor I', 'Staff', 1, 11, NULL, NULL, NULL, NULL, 'APPROVED'),
(61, 'Guidance Counselor II', 'Staff', 1, 12, NULL, NULL, NULL, NULL, 'APPROVED'),
(62, 'Guidance Counselor III', 'Staff', 1, 13, NULL, NULL, NULL, NULL, 'APPROVED'),
(63, 'Heavy Equipment Operator I', 'Staff', 1, 4, NULL, NULL, NULL, NULL, 'APPROVED'),
(64, 'Heavy Equipment Operator II', 'Staff', 1, 6, NULL, NULL, NULL, NULL, 'APPROVED'),
(65, 'Household Attendant I', 'Staff', 1, 3, NULL, NULL, NULL, NULL, 'APPROVED'),
(66, 'Information Systems Analyst', 'Staff', 1, 12, NULL, NULL, NULL, NULL, 'APPROVED'),
(67, 'Instructor', 'Faculty', 1, 12, NULL, NULL, NULL, NULL, 'APPROVED'),
(68, 'Instructor I', 'Faculty', 1, 12, NULL, NULL, NULL, NULL, 'APPROVED'),
(69, 'Instructor II', 'Faculty', 1, 13, NULL, NULL, NULL, NULL, 'APPROVED'),
(70, 'Instructor III', 'Faculty', 1, 14, NULL, NULL, NULL, NULL, 'APPROVED'),
(71, 'Internal Auditor IV', 'Staff', 1, 22, NULL, NULL, NULL, NULL, 'APPROVED'),
(72, 'Labor General Foreman', 'Staff', 1, 8, NULL, NULL, NULL, NULL, 'APPROVED'),
(73, 'Laboratory Aide II', 'Staff', 1, 4, NULL, NULL, NULL, NULL, 'APPROVED'),
(74, 'Laboratory Technician I', 'Staff', 1, 6, NULL, NULL, NULL, NULL, 'APPROVED'),
(75, 'Laboratory Technician II', 'Staff', 1, 8, NULL, NULL, NULL, NULL, 'APPROVED'),
(76, 'Machinist II', 'Staff', 1, 6, NULL, NULL, NULL, NULL, 'APPROVED'),
(77, 'Media Production Specialist II', 'Staff', 1, 15, NULL, NULL, NULL, NULL, 'APPROVED'),
(78, 'Medical Officer III', 'Staff', 1, 21, NULL, NULL, NULL, NULL, 'APPROVED'),
(79, 'Medical Technologist II', 'Staff', 1, 15, NULL, NULL, NULL, NULL, 'APPROVED'),
(80, 'Nurse II', 'Staff', 1, 15, NULL, NULL, NULL, NULL, 'APPROVED'),
(81, 'Nurse III', 'Staff', 1, 17, NULL, NULL, NULL, NULL, 'APPROVED'),
(82, 'Nursing Attendant I', 'Staff', 1, 5, NULL, NULL, NULL, NULL, 'APPROVED'),
(83, 'Nursing Attendant II', 'Staff', 1, 6, NULL, NULL, NULL, NULL, 'APPROVED'),
(84, 'Permanente', 'Staff', 1, 6, NULL, NULL, NULL, NULL, 'APPROVED'),
(85, 'Plumber Foreman', 'Staff', 1, 6, NULL, NULL, NULL, NULL, 'APPROVED'),
(86, 'Professor I', 'Faculty', 1, 24, NULL, NULL, NULL, NULL, 'APPROVED'),
(87, 'Professor II', 'Faculty', 1, 25, NULL, NULL, NULL, NULL, 'APPROVED'),
(88, 'Professor III', 'Faculty', 1, 26, NULL, NULL, NULL, NULL, 'APPROVED'),
(89, 'Professor IV', 'Faculty', 1, 27, NULL, NULL, NULL, NULL, 'APPROVED'),
(90, 'Professor V', 'Faculty', 1, 28, NULL, NULL, NULL, NULL, 'APPROVED'),
(91, 'Professor VI', 'Faculty', 1, 29, NULL, NULL, NULL, NULL, 'APPROVED'),
(92, 'Registrar II', 'Staff', 1, 15, NULL, NULL, NULL, NULL, 'APPROVED'),
(93, 'Registrar III', 'Staff', 1, 19, NULL, NULL, NULL, NULL, 'APPROVED'),
(94, 'Registrar IV', 'Staff', 1, 22, NULL, NULL, NULL, NULL, 'APPROVED'),
(95, 'School Credits Evaluator', 'Staff', 1, 11, NULL, NULL, NULL, NULL, 'APPROVED'),
(96, 'School Farm Demonstrator', 'Staff', 1, 10, NULL, NULL, NULL, NULL, 'APPROVED'),
(97, 'Science Aide', 'Staff', 1, 4, NULL, NULL, NULL, NULL, 'APPROVED'),
(98, 'Science Research Assistant', 'Staff', 1, 9, NULL, NULL, NULL, NULL, 'APPROVED'),
(99, 'Science Research Specialist', 'Staff', 1, 13, NULL, NULL, NULL, NULL, 'APPROVED'),
(100, 'Science Research Specialist I', 'Staff', 1, 13, NULL, NULL, NULL, NULL, 'APPROVED'),
(101, 'Science Research Specialist II', 'Staff', 1, 16, NULL, NULL, NULL, NULL, 'APPROVED'),
(102, 'Security Guard I', 'Staff', 1, 3, NULL, NULL, NULL, NULL, 'APPROVED'),
(103, 'Security Guard II', 'Staff', 1, 5, NULL, NULL, NULL, NULL, 'APPROVED'),
(104, 'Security Guard III', 'Staff', 1, 8, NULL, NULL, NULL, NULL, 'APPROVED'),
(105, 'Security Officer I', 'Staff', 1, 11, NULL, NULL, NULL, NULL, 'APPROVED'),
(106, 'Senior Agriculturist', 'Staff', 1, 18, NULL, NULL, NULL, NULL, 'APPROVED'),
(107, 'SUC President IV', 'Faculty', 1, 11, NULL, NULL, NULL, NULL, 'APPROVED'),
(108, 'Supervising Administrative Officer', 'Staff', 1, 22, NULL, NULL, NULL, NULL, 'APPROVED'),
(109, 'University Professor', 'Faculty', 1, 22, NULL, NULL, NULL, NULL, 'APPROVED'),
(110, 'Welder I', 'Staff', 1, 4, NULL, NULL, NULL, NULL, 'APPROVED'),
(111, 'Welder II', 'Staff', 1, 6, NULL, NULL, NULL, NULL, 'APPROVED'),
(112, 'Administrative Assistant IV', 'Staff', 1, 10, NULL, NULL, NULL, NULL, 'APPROVED'),
(113, 'College Librarian III', 'Staff', 1, 19, NULL, NULL, NULL, NULL, 'APPROVED'),
(114, 'Medical Officer IV', 'Staff', 1, 23, NULL, NULL, NULL, NULL, 'APPROVED'),
(115, 'Registrar I', 'Staff', 1, 11, NULL, NULL, NULL, NULL, 'APPROVED'),
(116, 'School Librarian I', 'Staff', 1, 11, NULL, NULL, NULL, NULL, 'APPROVED'),
(117, 'School Librarian II', 'Staff', 1, 12, NULL, NULL, NULL, NULL, 'APPROVED'),
(118, 'School Librarian III', 'Staff', 1, 13, NULL, NULL, NULL, NULL, 'APPROVED'),
(119, 'Faculty', 'Faculty', 1, 12, NULL, NULL, NULL, NULL, 'APPROVED'),
(120, 'Watchman I', 'Staff', 1, 9, NULL, NULL, NULL, NULL, 'APPROVED'),
(121, 'Research Aide', 'Staff', 0, NULL, 923, NULL, '2019-11-27 09:36:42', '2019-11-27 09:36:42', 'PENDING'),
(122, 'Regular Substitute Teacher', 'Staff', 0, NULL, 923, NULL, '2019-11-27 09:39:12', '2019-11-27 09:39:12', 'PENDING'),
(123, 'Part Time Instructor', 'Staff', 0, NULL, 923, NULL, '2019-11-27 09:42:29', '2019-11-27 09:42:29', 'PENDING'),
(124, 'Substitute Instructor', 'Staff', 0, NULL, 923, NULL, '2019-11-27 09:44:13', '2019-11-27 09:44:13', 'PENDING'),
(125, 'Instructor 1', 'Staff', 0, NULL, 923, NULL, '2019-11-27 09:45:12', '2019-11-27 09:45:12', 'PENDING'),
(126, 'Production Associate', 'Staff', 0, NULL, 850, NULL, '2019-12-04 05:02:39', '2019-12-04 05:02:39', 'PENDING'),
(127, 'System Administrator', 'Staff', 0, NULL, 850, NULL, '2019-12-04 05:03:54', '2019-12-04 05:03:54', 'PENDING'),
(128, 'Advance Programming Specialist', 'Staff', 0, NULL, 951, NULL, '2019-12-06 02:45:51', '2019-12-06 02:45:51', 'PENDING'),
(129, 'Community Organizer', 'Staff', 0, NULL, 658, NULL, '2019-12-10 02:13:51', '2019-12-10 02:13:51', 'PENDING'),
(130, 'Computer Maintenance Technician', 'Staff', 0, NULL, 889, NULL, '2020-01-02 05:11:13', '2020-01-02 05:11:13', 'PENDING'),
(131, 'Science Research Aide', 'Staff', 0, NULL, 889, NULL, '2020-01-03 08:38:18', '2020-01-03 08:38:18', 'PENDING'),
(132, 'Electrical Engineer II', 'Staff', 1, 16, 1, NULL, '2020-01-08 08:29:56', '2020-01-08 08:29:56', 'APPROVED'),
(133, 'Customer Service Representative', 'Staff', 0, NULL, 900, NULL, '2020-01-08 08:45:05', '2020-01-08 08:45:05', 'PENDING'),
(134, 'Clerk', 'Staff', 0, NULL, 900, NULL, '2020-01-08 08:46:58', '2020-01-08 08:46:58', 'PENDING'),
(135, 'Adminstrative Aide IV', 'Staff', 0, NULL, 900, NULL, '2020-01-08 08:55:18', '2020-01-08 08:55:18', 'PENDING'),
(136, 'Architect II', 'Staff', 1, 16, 1, NULL, '2020-01-08 23:34:46', '2020-01-08 23:34:46', 'APPROVED'),
(137, 'In-House Animal Nutritionist', 'Staff', 0, NULL, 1099, NULL, '2020-01-09 01:05:25', '2020-01-09 01:05:25', 'PENDING'),
(138, 'Jr. In-House Animal Nutritionist', 'Staff', 0, NULL, 1099, NULL, '2020-01-09 01:21:58', '2020-01-09 01:21:58', 'PENDING'),
(139, 'Teacher', 'Staff', 0, NULL, 1104, NULL, '2020-01-09 11:53:16', '2020-01-09 11:53:16', 'PENDING'),
(140, 'Trainer/Team Leader', 'Staff', 0, NULL, 1104, NULL, '2020-01-09 11:56:48', '2020-01-09 11:56:48', 'PENDING'),
(141, 'Job Order', 'Staff', 1, NULL, 1, NULL, '2020-01-10 06:24:06', '2020-01-10 06:24:06', 'APPROVED'),
(142, 'Volunteer', 'Staff', 0, NULL, 754, NULL, '2020-01-14 00:23:31', '2020-01-14 00:23:31', 'PENDING'),
(143, 'Production Engineer', 'Staff', 0, NULL, 1114, NULL, '2020-01-14 01:35:57', '2020-01-14 01:35:57', 'PENDING'),
(144, 'Student Assistant', 'Staff', 0, NULL, 1132, NULL, '2020-01-15 03:23:17', '2020-01-15 03:23:17', 'PENDING'),
(145, 'MSAN', 'Staff', 0, NULL, 1151, NULL, '2020-01-16 07:41:00', '2020-01-16 07:41:00', 'PENDING'),
(146, 'Field Operation Engineer', 'Staff', 0, NULL, 1151, NULL, '2020-01-16 07:54:31', '2020-01-16 07:54:31', 'PENDING'),
(147, 'Project Engineer', 'Staff', 0, NULL, 1168, NULL, '2020-01-19 22:10:22', '2020-01-19 22:10:22', 'PENDING'),
(148, 'Cadet Engineer', 'Staff', 0, NULL, 1168, NULL, '2020-01-19 22:12:57', '2020-01-19 22:12:57', 'PENDING'),
(149, 'Admin/HR Manager', 'Staff', 0, NULL, 1170, NULL, '2020-01-20 03:46:01', '2020-01-20 03:46:01', 'PENDING'),
(150, 'Project Electrical Engineer', 'Staff', 0, NULL, 1173, NULL, '2020-01-20 05:24:53', '2020-01-20 05:24:53', 'PENDING'),
(151, 'QA/QC', 'Staff', 0, NULL, 1182, NULL, '2020-01-20 18:24:50', '2020-01-20 18:24:50', 'PENDING'),
(152, 'Architectural', 'Staff', 0, NULL, 1182, NULL, '2020-01-20 18:33:28', '2020-01-20 18:33:28', 'PENDING');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ref_positions`
--
ALTER TABLE `ref_positions`
  ADD PRIMARY KEY (`id`);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
