-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Apr 09, 2020 at 03:16 AM
-- Server version: 5.7.25
-- PHP Version: 7.2.21

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`
--

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

--
-- Table structure for table `ref_old_positions`
--
--
-- Dumping data for table `ref_old_positions`
--

INSERT INTO `ref_old_positions` (`id`, `name`, `type`, `salary_grade`) VALUES
(1, 'Accounting Clerk I', 'Staff', NULL),
(2, 'Accounting Clerk II', 'Staff', NULL),
(3, 'Accounting Clerk III', 'Staff', NULL),
(4, 'Administrative Service Aide', 'Staff', NULL),
(5, 'Agricultural Economist', 'Staff', NULL),
(6, 'Agricultural Center Chief I', 'Staff', NULL),
(7, 'Agricultural Center Chief II', 'Staff', NULL),
(8, 'Agricultural Center Chief III', 'Staff', NULL),
(9, 'Agricultural Center Chief IV', 'Staff', NULL),
(10, 'Agricultural Technician III', 'Staff', NULL),
(11, 'Amusement Tax Checker', 'Staff', NULL),
(12, 'Architectional Drafstman', 'Staff', NULL),
(13, 'Assistant Foreman', 'Staff', NULL),
(14, 'Assistant Guidance Counselor', 'Staff', NULL),
(15, 'Assistant Leadman', 'Staff', NULL),
(16, 'Auditing Aide', 'Staff', NULL),
(17, 'Auto Mech Helper', 'Staff', NULL),
(18, 'Board Secretary I', 'Staff', NULL),
(19, 'Board Secretary II', 'Staff', NULL),
(20, 'Board Secretary III', 'Staff', NULL),
(21, 'Board Secretary IV', 'Staff', NULL),
(22, 'Budgeting Aide', 'Staff', NULL),
(23, 'Budget Officer I', 'Staff', NULL),
(24, 'Budget Officer II', 'Staff', NULL),
(25, 'Budget Officer III', 'Staff', NULL),
(26, 'Budgeting Assistant', 'Staff', NULL),
(27, 'Carpenter I', 'Staff', NULL),
(28, 'Carpenter II', 'Staff', NULL),
(29, 'Carpenter III', 'Staff', NULL),
(30, 'Cash Clerk I', 'Staff', NULL),
(31, 'Cash Clerk II', 'Staff', NULL),
(32, 'Cash Clerk III', 'Staff', NULL),
(33, 'Civil Engineer', 'Staff', NULL),
(34, 'Clerk I', 'Staff', NULL),
(35, 'Clerk II', 'Staff', NULL),
(36, 'Clerk III', 'Staff', NULL),
(37, 'Clerk IV', 'Staff', NULL),
(38, 'Clerk Typist', 'Staff', NULL),
(39, 'Clerical Aide', 'Staff', NULL),
(40, 'Chem Lab Technician', 'Staff', NULL),
(41, 'Communication Equipment Operator', 'Staff', NULL),
(42, 'Community Affairs Officer I', 'Staff', NULL),
(43, 'Communicty Affairs Officer II', 'Staff', NULL),
(44, 'Community Organizer', 'Staff', NULL),
(45, 'Computer Programmer III', 'Staff', NULL),
(46, 'Computer Programmer IV', 'Staff', NULL),
(47, 'Computer Operator I', 'Staff', NULL),
(48, 'Computer Operator II', 'Staff', NULL),
(49, 'Computer Operator III', 'Staff', NULL),
(50, 'Construction and Maintenance Capataz', 'Staff', NULL),
(51, 'Crafts and Trade Helper', 'Staff', NULL),
(52, 'Custodial Worker', 'Staff', NULL),
(53, 'Data Entry Machine Operator I', 'Staff', NULL),
(54, 'Data Entry Machine Operator II', 'Staff', NULL),
(55, 'Data Enry machine Operator III', 'Staff', NULL),
(56, 'Disb Officer I', 'Staff', NULL),
(57, 'Disb Officer II', 'Staff', NULL),
(58, 'Disb Officer III', 'Staff', NULL),
(59, 'Drafstman I', 'Staff', NULL),
(60, 'Drafstman II', 'Staff', NULL),
(61, 'Driver', 'Staff', NULL),
(62, 'Driver I', 'Staff', NULL),
(63, 'Driver II', 'Staff', NULL),
(64, 'Driver III', 'Staff', NULL),
(65, 'Dup Equipment Operator I', 'Staff', NULL),
(66, 'Dup Equipment Operator II', 'Staff', NULL),
(67, 'Economist', 'Staff', NULL),
(68, 'Education Program Specialist I', 'Staff', NULL),
(69, 'Education Program Specialist III', 'Staff', NULL),
(70, 'Education Research Assistant I', 'Staff', NULL),
(71, 'Education Research Assistant II', 'Staff', NULL),
(72, 'Education Research Assistant III', 'Staff', NULL),
(73, 'Educational Researcher', 'Staff', NULL),
(74, 'Electrician I', 'Staff', NULL),
(75, 'Electrician II', 'Staff', NULL),
(76, 'Electrician III', 'Staff', NULL),
(77, 'Electrician Aide', 'Staff', NULL),
(78, 'Elec and Comm Tech ', 'Staff', NULL),
(79, 'Elementary Grade Teacher', 'Staff', NULL),
(80, 'Farm Foreman', 'Staff', NULL),
(81, 'Field Electrician', 'Staff', NULL),
(82, 'Field Interviewer', 'Staff', NULL),
(83, 'Gardener', 'Staff', NULL),
(84, 'Gen TimeKeeper', 'Staff', NULL),
(85, 'Groundsman Gardener', 'Staff', NULL),
(86, 'Houseparent I', 'Staff', NULL),
(87, 'Houseparent II', 'Staff', NULL),
(88, 'Houseparent III', 'Staff', NULL),
(89, 'HRMA', 'Staff', NULL),
(90, 'HRMO I', 'Staff', NULL),
(91, 'HRMO II', 'Staff', NULL),
(92, 'HRMO III', 'Staff', NULL),
(93, 'Illustrator I', 'Staff', NULL),
(94, 'Illustrator II', 'Staff', NULL),
(95, 'Illustrator III', 'Staff', NULL),
(96, 'Information Officer I', 'Staff', NULL),
(97, 'Information Officer II', 'Staff', NULL),
(98, 'Information Officer III', 'Staff', NULL),
(99, 'Input Machine Operator', 'Staff', NULL),
(100, 'Janitor', 'Staff', NULL),
(101, 'Junior Librarian', 'Staff', NULL),
(102, 'Laborer', 'Staff', NULL),
(103, 'Laborer I', 'Staff', NULL),
(104, 'Laborer II', 'Staff', NULL),
(105, 'Laboratory Aide I', 'Staff', NULL),
(106, 'Laboratory Aide III', 'Staff', NULL),
(107, 'Library Aide', 'Staff', NULL),
(108, 'Library Assistant', 'Staff', NULL),
(109, 'Machinist', 'Staff', NULL),
(110, 'Mechanic I', 'Staff', NULL),
(111, 'Mechanic II', 'Staff', NULL),
(112, 'Mechanic III', 'Staff', NULL),
(113, 'Mechanical Plant Operator I', 'Staff', NULL),
(114, 'Mechanical Plant Operator II', 'Staff', NULL),
(115, 'Mechanical Plant Operator III', 'Staff', NULL),
(116, 'Mechanical Plant Operator Helper', 'Staff', NULL),
(117, 'Media Program Specialist I', 'Staff', NULL),
(118, 'Medical Officer I', 'Staff', NULL),
(119, 'Medical Officer II', 'Staff', NULL),
(120, 'Medical Technologist I', 'Staff', NULL),
(121, 'Medical Technologist III', 'Staff', NULL),
(122, 'Messenger', 'Staff', NULL),
(123, 'Mimeo Operator', 'Staff', NULL),
(124, 'Municipal Development Staff', 'Staff', NULL),
(125, 'Museum Technician', 'Staff', NULL),
(126, 'Nurse I', 'Staff', NULL),
(127, 'Painter I', 'Staff', NULL),
(128, 'Painter II', 'Staff', NULL),
(129, 'Painter III', 'Staff', NULL),
(130, 'Personnel Aide', 'Staff', NULL),
(131, 'Plant Propagator', 'Staff', NULL),
(132, 'Platen Press Operator', 'Staff', NULL),
(133, 'Plumber', 'Staff', NULL),
(134, 'Plumber Helper', 'Staff', NULL),
(135, 'Power Plant Operator I', 'Staff', NULL),
(136, 'Power Plant Operator II', 'Staff', NULL),
(137, 'Power Plant Operator III', 'Staff', NULL),
(138, 'Power Plant Operator Aide', 'Staff', NULL),
(139, 'Printing Machine Operator I', 'Staff', NULL),
(140, 'Printing Machine Operator II', 'Staff', NULL),
(141, 'Property Custodian', 'Staff', NULL),
(142, 'Proofreader', 'Staff', NULL),
(143, 'Prov Evaluation fficer', 'Staff', NULL),
(144, 'Public Health Nurse I', 'Staff', NULL),
(145, 'Public Health Nurse II', 'Staff', NULL),
(146, 'Public Health Nurse III', 'Staff', NULL),
(147, 'Public Relations Officer I', 'Staff', NULL),
(148, 'Public Relations Officer II', 'Staff', NULL),
(149, 'Public Relations Officer III', 'Staff', NULL),
(150, 'Public Relations Offficer IV', 'Staff', NULL),
(151, 'Radio Operator', 'Staff', NULL),
(152, 'Radio Technician', 'Staff', NULL),
(153, 'Registrar I', 'Staff', NULL),
(154, 'Rep Machine Operator I', 'Staff', NULL),
(155, 'Rep Machine Operator II', 'Staff', NULL),
(156, 'Research Assistant', 'Staff', NULL),
(157, 'Research Assistant I', 'Staff', NULL),
(158, 'Research Assistant II', 'Staff', NULL),
(159, 'Research Assistant III', 'Staff', NULL),
(160, 'Research Assistant IV', 'Staff', NULL),
(161, 'Research Assistant V', 'Staff', NULL),
(162, 'Research Assistant VI', 'Staff', NULL),
(163, 'Research Associate', 'Staff', NULL),
(164, 'Requisitions Clerk', 'Staff', NULL),
(165, 'School Credits Evaluator', 'Staff', NULL),
(166, 'Secondary School Teacher', 'Staff', NULL),
(167, 'Senior Project Eval Officer', 'Staff', NULL),
(168, 'Shop Aide', 'Staff', NULL),
(169, 'Shop Electrician', 'Staff', NULL),
(170, 'SSB Operator', 'Staff', NULL),
(171, 'State Auditor I', 'Staff', NULL),
(172, 'State Auditor II', 'Staff', NULL),
(173, 'State Auditor III', 'Staff', NULL),
(174, 'Statistician Aide', 'Staff', NULL),
(175, 'Stockman/Timekeeper', 'Staff', NULL),
(176, 'Storekeeper I', 'Staff', NULL),
(177, 'Storekeeper II', 'Staff', NULL),
(178, 'Storekeeper III', 'Staff', NULL),
(179, 'Supervisor Librarian', 'Staff', NULL),
(180, 'Supplies Checker', 'Staff', NULL),
(181, 'Supply Officer I', 'Staff', NULL),
(182, 'Supply Officer II', 'Staff', NULL),
(183, 'Supply Officer III', 'Staff', NULL),
(184, 'Survey Enumerator', 'Staff', NULL),
(185, 'Tapeman', 'Staff', NULL),
(186, 'Teacher', 'Staff', NULL),
(187, 'Training Specialist', 'Staff', NULL),
(188, 'Tractor Operator', 'Staff', NULL),
(189, 'Utility Worker I', 'Staff', NULL),
(190, 'Utility Worker II', 'Staff', NULL),
(191, 'Utilityman', 'Staff', NULL),
(192, 'Instructor VI', 'Faculty', NULL),
(193, 'Assistant Professor VI', 'Faculty', NULL),
(194, 'Assistant Instructor I', 'Faculty', NULL),
(195, 'Associate Professor VI', 'Faculty', NULL),
(196, 'Agricultural Engineer', 'Staff', NULL),
(197, 'Agriculturist I', 'Staff', NULL),
(198, 'Agriculturist II', 'Staff', NULL),
(199, 'Animal Scientist', 'Staff', NULL),
(200, 'Assistant Instructor II', 'Faculty', NULL),
(201, 'Assistant Instructor III', 'Faculty', NULL),
(202, 'Assistant Power Plant Operator', 'Staff', NULL),
(203, 'Assistant Professor V', 'Staff', NULL),
(204, 'Assistant Supervisor', 'Staff', NULL),
(205, 'Agricultural Technologist', 'Staff', NULL),
(206, 'Animal Caretaker', 'Staff', NULL),
(207, 'Audio Visual Aid Tech', 'Staff', NULL),
(208, 'Auto Servicemen', 'Staff', NULL),
(209, 'Instructor IV', 'Staff', NULL),
(210, 'ECET I', 'Staff', NULL),
(211, 'ECET II', 'Staff', NULL),
(212, 'ECET III', 'Staff', NULL),
(213, 'Electrical Engineer', 'Staff', NULL),
(214, 'College Professor', 'Faculty', NULL),
(215, 'Human Resource Management Assistant', 'Staff', NULL),
(216, 'Research Assistant Instructor', 'Staff', NULL),
(217, 'Instructor V', 'Faculty', NULL),
(218, 'Farm Management Tech', 'Staff', NULL),
(219, 'Draftsman', 'Staff', NULL),
(220, 'Draftsman II', 'Staff', NULL),
(221, 'Buyer I', 'Staff', NULL),
(222, 'Buyer II', 'Staff', NULL),
(223, 'Junior Statistician', 'Staff', NULL),
(224, 'Equipment Tech', 'Staff', NULL),
(225, 'Farm Supervisor', 'Staff', NULL),
(226, 'Science Research Assistant II', 'Staff', NULL),
(227, 'Farm Assistant', 'Staff', NULL),
(228, 'Student Assistant', 'Staff', NULL),
(229, 'Professor Emeritus', 'Staff', NULL),
(230, 'SUC President III', 'Staff', NULL),
(231, 'Graduate Assistant', 'Staff', NULL),
(232, 'Research Aide', 'Staff', NULL),
(233, 'Mason', 'Staff', NULL),
(234, 'Copra Processor', 'Staff', NULL),
(235, 'Tractor Operator', 'Staff', NULL),
(236, 'Project Aide', 'Staff', NULL),
(237, 'Production Tech', 'Staff', NULL),
(238, 'Research Aide III', 'Staff', NULL),
(239, 'Cassava Pollinator', 'Staff', NULL),
(240, 'Painter Aide', 'Staff', NULL),
(241, 'Science Research Specialist III', 'Staff', NULL),
(242, 'Research Chemist II', 'Staff', NULL),
(243, 'Science Research Specialist IV', 'Staff', NULL),
(244, 'Research Associate II', 'Staff', NULL),
(245, 'Mechanic Aide', 'Staff', NULL),
(246, 'Payroll Clerk', 'Staff', NULL),
(247, 'Dev Researcher', 'Staff', NULL),
(248, 'Motorpool Dispatcher', 'Staff', NULL),
(249, 'Trans Dispatcher', 'Staff', NULL),
(250, 'Job Programmer', 'Staff', NULL),
(251, 'Supervising Clerk I', 'Staff', NULL),
(252, 'Budget Examiner I', 'Staff', NULL),
(253, 'Statistical Aide II', 'Staff', NULL),
(254, 'Media Researcher', 'Staff', NULL),
(255, 'Radio Production Announcer', 'Staff', NULL),
(256, 'Private Secretary', 'Staff', NULL),
(257, 'Warehouse Man', 'Staff', NULL),
(258, 'Records Clerk', 'Staff', NULL),
(259, 'Senior Bookkeeper', 'Staff', NULL),
(260, 'Mechanic Helper', 'Staff', NULL),
(261, 'Senior Carpenter', 'Staff', NULL),
(262, 'Office Equipment Technician', 'Staff', NULL),
(263, 'FMT', 'Staff', NULL),
(264, 'Student Examiner', 'Staff', NULL),
(265, 'Machinist Helper', 'Staff', NULL),
(266, 'Research Aide V', 'Staff', NULL),
(267, 'Cashier IV', 'Staff', NULL),
(268, 'HMT', 'Staff', NULL),
(269, 'HRMO IV', 'Staff', NULL),
(270, 'Research Aide VI', 'Staff', NULL),
(271, 'College Guidance Coordinator', 'Staff', NULL),
(272, 'Research Aide IV', 'Staff', NULL),
(273, 'Records Officer III', 'Staff', NULL),
(274, 'Records Officer IV', 'Staff', NULL),
(275, 'Welfare Aide', 'Staff', NULL),
(276, 'Court Steno I', 'Staff', NULL),
(277, 'Property Custodian II', 'Staff', NULL),
(278, 'Medical Officer V', 'Staff', NULL),
(279, 'Senior Agriculturist', 'Staff', NULL),
(280, 'Ticket Checker', 'Staff', NULL),
(281, 'Researcher III', 'Staff', NULL),
(282, 'Trainer Food processing', 'Staff', NULL),
(283, 'Field Aide', 'Staff', NULL),
(284, 'Power Gen Foreman', 'Staff', NULL),
(285, 'Auto Shop Foreman', 'Staff', NULL),
(286, 'Plowman', 'Staff', NULL),
(287, 'As Ext Specialist', 'Staff', NULL),
(288, 'Laboratory Technician', 'Staff', NULL),
(289, 'Watchman', 'Staff', NULL),
(290, 'Security Guard', 'Staff', NULL),
(291, 'Clerk', 'Staff', NULL),
(292, 'Assistant Instructor', 'Faculty', NULL),
(293, 'Training Assistant', 'Staff', NULL),
(294, 'Associate Professor', 'Faculty', NULL),
(295, 'Printing Inspector I', 'Staff', NULL),
(296, 'Printing Quality ', 'Staff', NULL),
(297, 'Research Aide I', 'Staff', NULL),
(298, 'Mason Aide', 'Staff', NULL),
(299, 'Museum Technician I', 'Staff', NULL),
(300, 'Assistant Professor', 'Faculty', NULL),
(301, 'Science Research Associate III', 'Staff', NULL),
(302, 'Research Aide ', 'Staff', NULL),
(303, 'Audio Visual Aids Tech', 'Staff', NULL),
(304, 'Clerk Aide', 'Staff', NULL),
(305, 'Econ  Dev Analyst', 'Staff', NULL),
(306, 'Researcher', 'Staff', NULL),
(307, 'Cashier I', 'Staff', NULL),
(308, 'Machinist I', 'Staff', NULL),
(309, 'Machinist Aide', 'Staff', NULL),
(310, 'Input Machine Operator', 'Staff', NULL),
(311, 'Research Enumerator', 'Staff', NULL),
(312, 'Messenger I', 'Staff', NULL),
(313, 'Teacher I', 'Faculty', NULL),
(314, 'Carpenter Maintenance', 'Staff', NULL),
(315, 'Guidance Counselor', 'Staff', NULL),
(316, 'Utility ', 'Staff', NULL),
(317, 'Teacher III', 'Faculty', NULL),
(318, 'Information Systems Analyst I', 'Staff', NULL),
(319, 'Property Custodian I', 'Staff', NULL),
(320, 'Science Research Associate I', 'Staff', NULL),
(321, 'Research Associate  I', 'Staff', NULL),
(322, 'Crtclerkstenol', 'Staff', NULL),
(323, 'Supplies Checker I', 'Staff', NULL),
(324, 'Auditing Aide I', 'Staff', NULL),
(325, 'Caretaker', 'Staff', NULL),
(326, 'Data Entry Machine Operator', 'Staff', NULL),
(327, 'Plummer I', 'Staff', NULL),
(328, 'Plummer Aide', 'Staff', NULL),
(329, 'Admin Aide', 'Staff', NULL),
(330, 'Information Systems Analyst I', 'Staff', NULL),
(331, 'Accounting Clerk', 'Staff', NULL),
(332, 'Ecet ', 'Staff', NULL),
(333, 'Mason I', 'Staff', NULL),
(334, 'Carpenter ', 'Staff', NULL),
(335, 'Painter Aide', 'Staff', NULL),
(336, 'Welder', 'Staff', NULL),
(337, 'Utility Man II', 'Staff', NULL),
(338, 'Utility Man I', 'Staff', NULL);

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ref_old_positions`
--
ALTER TABLE `ref_old_positions`
  MODIFY `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=339;
COMMIT;

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