-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: mysql
-- Generation Time: Feb 14, 2019 at 01:43 AM
-- Server version: 5.7.25
-- PHP Version: 7.2.14

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


INSERT INTO `rsp_assesscategories` (`id`, `name`, `description`, `type_id`, `max_value`, `committee_type`, `summary_id`) VALUES
(1, 'Academic Background', 'Academic Background : Doctorate, Masteral and Undergraduate', 4, '25.00', 'APB', 1),
(2, 'General Point Average', 'General Point Average', 4, '5.00', 'APB', 1),
(3, 'Additional graduate units', 'Additional graduate units:    For every 3 units earned ', 3, '5.00', 'APB', 1),
(4, 'Background Investigation', 'Background Investigation', 1, '5.00', NULL, NULL),
(5, 'Work experience ', 'Work experience : For every year of full-time service', 3, '10.00', 'APB', 2),
(6, 'Honors and Awards', 'Honors & Awards', 2, '2.50', 'APB', 3),
(7, 'Training/seminar workshops ', 'Training/seminar workshops ', 3, '2.50', 'APB', 3),
(8, 'Expert services', 'Expert services as lecturer/resource person or guest speaker in conferences, workshops, and/or training courses', 3, '2.50', 'APB', 3),
(9, 'Publication', 'Publication (for every scholarly research/monograph/educational technical articles in a technical/scientific/professional journal)', 3, '2.50', 'APB', 3),
(10, 'Interview  ', 'Interview  (based on Competency Assessment)', 5, '10.00', 'APB', 4),
(11, 'Teaching Demonstration', 'Teaching Demonstration (rated individually)', 6, '20.00', 'APB', 5),
(12, 'License/eligibility', 'License/eligibility', 2, '5.00', 'APB', 6),
(13, 'Other Qualifications', 'Other Qualifications: Writing skills, computer literacy, drawing, statistical analysis, etc.  ', 3, '5.00', 'APB', 7),
(14, 'Performance Rating', 'Performance Rating', 8, '10.00', 'NAPB', 10),
(15, 'Punctuality', 'Punctuality : Perfect Attendance and Zero Tardiness/Under Time', 9, '10.00', 'NAPB', 10),
(16, 'Potential', 'Potential : Supervisor and Non-Academic Personnel Board', 16, '10.00', 'NAPB', 11),
(17, 'Interview', 'Interview (based on Non-Academic Personnel Board)', 7, '15.00', 'NAPB', 15),
(18, 'Experience', 'Experience', 3, '15.00', 'NAPB', 9),
(19, 'Skills (15%)', 'Skills (15%) : Salary grade 8 and above and clerical positions', 16, '15.00', 'NAPB', 17),
(20, 'Skills (10%)', 'Skills (10%) : Salary grade below 8 and except clerk', 16, '10.00', 'NAPB', 16),
(21, 'Education', 'Education', 12, '15.00', 'NAPB', 8),
(22, 'Training', 'Training', 13, '5.00', 'NAPB', 12),
(23, 'Awards (5%)', 'Awards (5%) : Salary grade 8 and above and all clerical positions ', 14, '5.00', 'NAPB', 13),
(24, 'Awards (10%)', 'Awards (10%) : Salary grade below 8', 15, '10.00', 'NAPB', 14);


ALTER TABLE `rsp_assesscategories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rsp_assesscategories_type_id_foreign` (`type_id`);
  ADD KEY `rsp_assesscategories_summary_id_foreign` (`summary_id`);


