-- https://www.phpmyadmin.net/
--

START TRANSACTION;

-- INSERT INTO `rsp_competency_description` (`id`, `item_id`, `description`, `type`) VALUES
-- (1, 40, 'Exemplifying Integrity and Professionalism - demonstrates high standards of professional behaviour, adhering to ethical as well as moral principles, values, and standards of public office', 'Staff'),
-- (2, 41, 'Delivering Service Excellence - Complies with VSU’s established  standards of service delivery  for customer satisfaction', 'Staff'),
-- (3, 42, 'Communication Savy - Effectively delivers messages that simply focus on facts or information', 'Staff'),
-- (4, 43, 'Interpersonal relationship management - Effectively communicates and interacts with colleagues, customers and clients, and work well in a team to achieve results', 'Staff'),
-- (5, 44, 'Change Adaptation - Works effectively with a variety of people and situations and adapts one’s thinking, behaviour and style appropriately in dealing with change', 'Staff'),
-- (6, 45, 'Gender-responsive management - Promotes gender equality and women empowerment to address gender-related problems and issues', 'Staff'),
-- (7, 87, 'Administrative Services Management - Develops programs and projects, and mobilizes and manages resources, both material and human, in order to fully achieve the set objectives and targets of the university in general and of the different offices/colleges/departments/centers in particular', 'Staff'),
-- (8, 88, 'Accounting Management - Manages the processing of financial transactions according to COA and DBM rules and regulations, maintaining the books of accounts, analyzing accounts and timely preparation and submission of required reports; manages the preparation of cheques and disbursements, replenishment, and liquidation of cash advances, petty cash, and other personnel cash emoluments, and receives collectibles/ payments in accordance with relevant rules and regulations', 'Staff'),
-- (9, 89, 'Budget Management - Packages and submits  responsive budgetary proposal to finance programmed projects and activities for the following year and applies the protocols required for effective budgetary utilization by ensuring decisions and operations are implemented in compliance with applicable laws, policies, procedures, standards, and regulations', 'Staff'),
-- (10, 90, 'Consultation and Advising - Addresses issues and concerns affecting students’ academic performance by strictly following the consultation time schedule, responds to queries and implements interventions which result to highly satisfied clients', 'Staff'),
-- (11, 91, 'Critical Thinking and Problem Solving - Analyzes, computes, and interprets results by applying appropriate strategies and methodology to arrive at sound decisions in a learning environment', 'Staff'),
-- (12, 92, 'Documents and Records Management - Applies and adapts records management standards related to the cycle of records in the university which are conducted to achieve adequate and proper documentation of government policies, transactions and effective management of the university operations', 'Staff'),
-- (13, 93, 'Facilitating Learner - Centered Environment - Explores the fundamental principles, processes and practices anchored on learner-centeredness.\r\nApplies educational theories and psychologies to facilitate various teaching-learning delivery modes to enhance learning', 'Staff'),
-- (14, 94, 'Facilitation - Guides the exchange of information and ideas in an interactive session designed to meet defined objectives', 'Staff'),
-- (15, 95, 'Filipino Values Restoration - Revitalizes desirable Filipino values that are pro-God, pro-people, and pro-nature', 'Staff'),
-- (16, 96, 'Fiscal Management - Applies the protocols required to safeguard and effectively utilize financial resources to attain university mandate and use said resources economically by ensuring decisions and operations are implemented in compliance with applicable laws, policies, procedures, standards, and regulations', 'Staff'),
-- (17, 97, 'Health and Wellness Management - Implements sustainable preventive health and wellness programs through information dissemination, preventive health measures and provision of therapeutic services resulting to healthy and productive employees', 'Staff'),
-- (18, 98, 'Recruitment, Selection and Placement - Searches, attracts and assesses job candidates and guides the appointing authority in choosing the best fit for the job at the right time, in accordance with legal requirements to achieve organisational goals.', 'Staff'),
-- (19, 98, 'Benefits, Compensation, and Welfare Management - Develops, implements, evaluates and enhances policies and programs on benefits, compensation, rewards, incentives, health and wellness to improve employee welfare.', 'Staff'),
-- (20, 98, 'Learning and Development Planning, Facilitation and Administration - Translates training/learning needs results into interventions and prioritizes and schedules them for implementation, stimulates process, sustains learning through facilitation, formative assessment, and use of various training/learning methodologies and activities, plans, executes and reports the implementation of training/learning interventions, courses and programs.', 'Staff'),
-- (21, 98, 'Performance Management - Collects, analyzes, reviews and reports performance data and establish scientific basis for performance targets and measures.', 'Staff'),
-- (22, 98, 'Rewards and Recognition - Identifies, develops and implements programs for the organization/bureaucracy to reward and recognize outstanding performance and behaviour.', 'Staff'),
-- (23, 99, 'Use of Information and Communications Technology (ICT) - Implements the effective identification, selection, acquisition, development, utilization, and protection of technologies. In accordance with the mandate of the unit, that will result to efficient and effective delivery of services by ensuring responsiveness to the needs of stakeholder.', 'Staff'),
-- (24, 100, 'Innovative Instructional Materials Development - Designs and creates learning lessons, teaching-learning experiences that utilize appropriate traditional and innovative technologies in various learning environment.', 'Staff'),
-- (25, 101, 'Innovative Teaching Strategies - Adopts principles and develops teaching strategies by retooling faculty through learning interventions and designing outcomes-based course syllabi to adapt to the changing educational landscape.', 'Staff'),
-- (26, 102, 'Maintenance Management - Develops maintenance planning and operation monitoring to effectively and efficiently deliver repair/maintenance services for buildings, facilities, equipment, machineries and vehicles.', 'Staff'),
-- (27, 103, 'Monitoring and Evaluation - Gathers and analyzes the detailed status of the program in order to determine if its ongoing activities are still aligned with the intended direction of achieving the set goals and objectives.', 'Staff'),
-- (28, 104, 'Peer Mentoring - Develops and equips junior faculty for higher level position through learning by observing and doing; collaborative teaching, research and extension activities; partnership in writing publications and participation in conferences and technical fora, so that VSU’s academic excellence will be sustained.', 'Staff'),
-- (29, 105, 'Process Management - Develops, formulates and reviews for enhancement processes, policies and procedures which	govern the execution of tasks, activities, or projects, in order to ensure work is accomplished and required results are delivered effectively and efficiently; adopt measures to drive compliance; be proactive in responding to opportunities for improving/streamlining based on experience, feedback, emerging technologies and new direction.', 'Staff'),
-- (30, 106, 'Procurement Management - Effectively undertakes procurement planning, programming, project management, and requirement specifications to facilitate achievement of organisational or agency program of work, goals and targets. Procurement should support plans, goals and targets such that acquisitions are undertaken within the specific acceptable timetable, budget and to appropriate specifications. The approved Annual Procurement Plan authorises and guides the procurement activities of the agency for the year.', 'Staff'),
-- (31, 107, 'Production and Entrepreneurship - Identifies issues, potentials and actual businesses by setting-up enterprises for creating products from the resources of the university with the view of making profit from these products.', 'Staff'),
-- (32, 108, 'Project Management - Facilitates smooth implementation of projects, work or activities through information collection from and provision to concerned parties, departments or individuals. Is keen and quick in understanding and dealing with a project situation in a manner that is likely to lead to a good outcome. Conceptualizes, develops, implements, and evaluates programs and projects whether routine, non-routine, ad hoc or task force assignments.', 'Staff'),
-- (33, 109, 'Supply and Property Management - Records and manages effectively and efficiently the resources involved and needed in the overall procurement process, and finds innovative solutions to improve supply and property management processes.', 'Staff'),
-- (34, 110, 'Publication Writing - Develops and produces scientific article for peer-reviewed journals by utilizing research outputs resulting to wide dissemination of information and technology.', 'Staff'),
-- (35, 111, 'Quality Assurance - Controls and improves, as necessary, the quality of audit/assessment/accreditation processes in accordance with prescribed quality control policies and procedures as mandated by the University and in compliance with audit and accrediting bodies.', 'Staff'),
-- (36, 112, 'Report Writing - Prepares and produces reports and other documents such as proposals, policies, guidelines or procedures and manuals in a clear, concise and coherent manner and in accordance with VSU standards that ensures proper documentation and presentation of information for an effective and efficient information utilization and management.', 'Staff'),
-- (37, 113, 'Research Management - Identifies issues and potentials for further studies and generation of new knowledge and technologies for the betterment of mankind, mother earth and the universe and conceptualizes proposals for funding and conducts studies to answer questions sought to be answered or maximizes technologies needed to improve the lives of mankind.', 'Staff'),
-- (38, 114, 'Extension Management - Identifies new knowledge and matured technologies due for adoption and implementation of target beneficiaries and conceptualizes programs, activities and projects and implements effective transfer mechanisms and strategies.', 'Staff'),
-- (39, 115, 'Resource Mobilization Management - Allocates limited resources in an effective manner through efficient utilization of funds, time, human and other resources to deliver respective tasks and generate solutions to challenges in the workplace.', 'Staff'),
-- (40, 116, 'Risk Management - Ensures implementation of effective identification of hazards in the workplace and develop plans on mitigation, prevention, risk preparedness and responding by conducting a periodic safety inspection, hazard analysis and emergency drills in accordance with RA 10121 to ensure safety of residents, faculty and staff of any risk.', 'Staff'),
-- (41, 117, 'Occupational Health and Safety Management - Ensures implementation of effective health and safety of workers in the workplace through creating VSU Safety Committee and conducting seminar workshops such that all faculty and staff will be made aware of the importance of the health and safety in the workplace to avoid job-related sickness/accidents.', 'Staff'),
-- (42, 118, 'Sharing Expertise and Linkaging - Shares technical expertise and links with other institutions through the conduct of trainings, seminar-workshops, lectures, conferences and consultancy services to increase knowledge, skills and expertise of clients based on pre and post evaluations.', 'Staff'),
-- (43, 119, 'Waste Management - Implements and ensures the effective waste segregation, collection, disposal through stakeholders’ awareness and empowerment in accordance with Republic Act 9003 that lead to cleaner and greener University adherence to national and international sanitation and pollution level standards.', 'Staff'),
-- (44, 120, 'Thinking Strategically and Creatively - Dreams and envisions what the future looks like for the university,  thinks dimensionally, crafts strategic goals and strategies to attain that future, identifies connections that are not obviously connected and comes up with new and creative ideas to enhance organizational effectiveness and responsiveness.', 'Staff'),
-- (45, 121, 'Creating and Nurturing a High Performance Organization - Creates a high performing organizational culture that is purpose driven, results-based, client focused and  team-oriented', 'Staff'),
-- (46, 122, 'Leading Change - Generates genuine enthusiasm and momentum for organizational development and change by engaging and involving groups and stakeholders to understand, support, commit and own the change agenda and to advance and sustain same for organizational effectiveness.', 'Staff'),
-- (47, 123, 'Building Collaborative and Inclusive Working Relationships - Builds a network of reciprocal, high trust and synergistic working relationship among employees  within the organization and across other government and non-government organizations to leverage and maximize  opportunities for strategic partnership with external stakeholders', 'Staff'),
-- (48, 124, 'Managing Performance and Coaching for Results - Creates an enabling environment which will nurture and sustains a performance based coaching culture for increased effectiveness of employees and a strong focus in developing people for current and future needs thru an active and continuing staff development program for organizational effectiveness.', 'Staff');

INSERT INTO `rsp_competency_description` (`id`, `item_id`, `description`, `type`, `title`) VALUES
(1, 40, 'Demonstrates high standards of professional behaviour, adhering to ethical as well as moral principles, values, and standards of public office', 'Staff', 'Exemplifying Integrity and Professionalism'),
(2, 41, 'Complies with VSU''s established  standards of service delivery  for customer satisfaction', 'Staff', 'Delivering Service Excellence'),
(3, 42, 'Effectively delivers messages that simply focus on facts or information', 'Staff', 'Communication Savy'),
(4, 43, 'Effectively communicates and interacts with colleagues, customers and clients, and work well in a team to achieve results', 'Staff', 'Interpersonal relationship management'),
(5, 44, 'Works effectively with a variety of people and situations and adapts one''s thinking, behaviour and style appropriately in dealing with change', 'Staff', 'Change Adaptation'),
(6, 45, 'Promotes gender equality and women empowerment to address gender-related problems and issues', 'Staff', 'Gender-responsive management'),
(7, 87, 'Develops programs and projects, and mobilizes and manages resources, both material and human, in order to fully achieve the set objectives and targets of the university in general and of the different offices/colleges/departments/centers in particular', 'Staff', 'Administrative Services Management'),
(8, 88, 'Manages the processing of financial transactions according to COA and DBM rules and regulations, maintaining the books of accounts, analyzing accounts and timely preparation and submission of required reports; manages the preparation of cheques and disbursements, replenishment, and liquidation of cash advances, petty cash, and other personnel cash emoluments, and receives collectibles/ payments in accordance with relevant rules and regulations', 'Staff', 'Accounting Management'),
(9, 89, 'Packages and submits  responsive budgetary proposal to finance programmed projects and activities for the following year and applies the protocols required for effective budgetary utilization by ensuring decisions and operations are implemented in compliance with applicable laws, policies, procedures, standards, and regulations', 'Staff', 'Budget Management'),
(10, 90, 'Addresses issues and concerns affecting students'' academic performance by strictly following the consultation time schedule, responds to queries and implements interventions which result to highly satisfied clients', 'Staff', 'Consultation and Advising'),
(11, 91, 'Analyzes, computes, and interprets results by applying appropriate strategies and methodology to arrive at sound decisions in a learning environment', 'Staff', 'Critical Thinking and Problem Solving'),
(12, 92, 'Applies and adapts records management standards related to the cycle of records in the university which are conducted to achieve adequate and proper documentation of government policies, transactions and effective management of the university operations', 'Staff', 'Documents and Records Management'),
(13, 93, 'Applies educational theories and psychologies to facilitate various teaching-learning delivery modes to enhance learning', 'Staff', 'Facilitating Learner - Centered Environment'),
(14, 94, 'Guides the exchange of information and ideas in an interactive session designed to meet defined objectives', 'Staff', 'Facilitation'),
(15, 95, 'Revitalizes desirable Filipino values that are pro-God, pro-people, and pro-nature', 'Staff', 'Filipino Values Restoration'),
(16, 96, 'Applies the protocols required to safeguard and effectively utilize financial resources to attain university mandate and use said resources economically by ensuring decisions and operations are implemented in compliance with applicable laws, policies, procedures, standards, and regulations', 'Staff', 'Fiscal Management'),
(17, 97, 'Implements sustainable preventive health and wellness programs through information dissemination, preventive health measures and provision of therapeutic services resulting to healthy and productive employees', 'Staff', 'Health and Wellness Management'),
(18, 98, 'Searches, attracts and assesses job candidates and guides the appointing authority in choosing the best fit for the job at the right time, in accordance with legal requirements to achieve organisational goals.', 'Staff', 'Recruitment, Selection and Placement'),
(19, 98, 'Develops, implements, evaluates and enhances policies and programs on benefits, compensation, rewards, incentives, health and wellness to improve employee welfare.', 'Staff', 'Benefits, Compensation, and Welfare Management'),
(20, 98, 'Translates training/learning needs results into interventions and prioritizes and schedules them for implementation, stimulates process, sustains learning through facilitation, formative assessment, and use of various training/learning methodologies and activities, plans, executes and reports the implementation of training/learning interventions, courses and programs.', 'Staff', 'Learning and Development Planning, Facilitation and Administration'),
(21, 98, 'Collects, analyzes, reviews and reports performance data and establish scientific basis for performance targets and measures.', 'Staff', 'Performance Management'),
(22, 98, 'Identifies, develops and implements programs for the organization/bureaucracy to reward and recognize outstanding performance and behaviour.', 'Staff', 'Rewards and Recognition'),
(23, 99, 'Implements the effective identification, selection, acquisition, development, utilization, and protection of technologies. In accordance with the mandate of the unit, that will result to efficient and effective delivery of services by ensuring responsiveness to the needs of stakeholder.', 'Staff', 'Use of Information and Communications Technology (ICT)'),
(24, 100, 'Designs and creates learning lessons, teaching-learning experiences that utilize appropriate traditional and innovative technologies in various learning environment.', 'Staff', 'Innovative Instructional Materials Development'),
(25, 101, 'Adopts principles and develops teaching strategies by retooling faculty through learning interventions and designing outcomes-based course syllabi to adapt to the changing educational landscape.', 'Staff', 'Innovative Teaching Strategies'),
(26, 102, 'Develops maintenance planning and operation monitoring to effectively and efficiently deliver repair/maintenance services for buildings, facilities, equipment, machineries and vehicles.', 'Staff', 'Maintenance Management'),
(27, 103, 'Gathers and analyzes the detailed status of the program in order to determine if its ongoing activities are still aligned with the intended direction of achieving the set goals and objectives.', 'Staff', 'Monitoring and Evaluation'),
(28, 104, 'Develops and equips junior faculty for higher level position through learning by observing and doing; collaborative teaching, research and extension activities; partnership in writing publications and participation in conferences and technical fora, so that VSU''s academic excellence will be sustained.', 'Staff', 'Peer Mentoring'),
(29, 105, 'Develops, formulates and reviews for enhancement processes, policies and procedures which govern the execution of tasks, activities, or projects, in order to ensure work is accomplished and required results are delivered effectively and efficiently; adopt measures to drive compliance; be proactive in responding to opportunities for improving/streamlining based on experience, feedback, emerging technologies and new direction.', 'Staff', 'Process Management'),
(30, 106, 'Effectively undertakes procurement planning, programming, project management, and requirement specifications to facilitate achievement of organisational or agency program of work, goals and targets. Procurement should support plans, goals and targets such that acquisitions are undertaken within the specific acceptable timetable, budget and to appropriate specifications. The approved Annual Procurement Plan authorises and guides the procurement activities of the agency for the year.', 'Staff', 'Procurement Management'),
(31, 107, 'Identifies issues, potentials and actual businesses by setting-up enterprises for creating products from the resources of the university with the view of making profit from these products.', 'Staff', 'Production and Entrepreneurship'),
(32, 108, 'Facilitates smooth implementation of projects, work or activities through information collection from and provision to concerned parties, departments or individuals. Is keen and quick in understanding and dealing with a project situation in a manner that is likely to lead to a good outcome. Conceptualizes, develops, implements, and evaluates programs and projects whether routine, non-routine, ad hoc or task force assignments.', 'Staff', 'Project Management'),
(33, 109, 'Records and manages effectively and efficiently the resources involved and needed in the overall procurement process, and finds innovative solutions to improve supply and property management processes.', 'Staff', 'Supply and Property Management'),
(34, 110, 'Develops and produces scientific article for peer-reviewed journals by utilizing research outputs resulting to wide dissemination of information and technology.', 'Staff', 'Publication Writing'),
(35, 111, 'Controls and improves, as necessary, the quality of audit/assessment/accreditation processes in accordance with prescribed quality control policies and procedures as mandated by the University and in compliance with audit and accrediting bodies.', 'Staff', 'Quality Assurance'),
(36, 112, 'Prepares and produces reports and other documents such as proposals, policies, guidelines or procedures and manuals in a clear, concise and coherent manner and in accordance with VSU standards that ensures proper documentation and presentation of information for an effective and efficient information utilization and management.', 'Staff', 'Report Writing'),
(37, 113, 'Identifies issues and potentials for further studies and generation of new knowledge and technologies for the betterment of mankind, mother earth and the universe and conceptualizes proposals for funding and conducts studies to answer questions sought to be answered or maximizes technologies needed to improve the lives of mankind.', 'Staff', 'Research Management'),
(38, 114, 'Identifies new knowledge and matured technologies due for adoption and implementation of target beneficiaries and conceptualizes programs, activities and projects and implements effective transfer mechanisms and strategies.', 'Staff', 'Extension Management'),
(39, 115, 'Allocates limited resources in an effective manner through efficient utilization of funds, time, human and other resources to deliver respective tasks and generate solutions to challenges in the workplace.', 'Staff', 'Resource Mobilization Management'),
(40, 116, 'Ensures implementation of effective identification of hazards in the workplace and develop plans on mitigation, prevention, risk preparedness and responding by conducting a periodic safety inspection, hazard analysis and emergency drills in accordance with RA 10121 to ensure safety of residents, faculty and staff of any risk.', 'Staff', 'Risk Management'),
(41, 117, 'Ensures implementation of effective health and safety of workers in the workplace through creating VSU Safety Committee and conducting seminar workshops such that all faculty and staff will be made aware of the importance of the health and safety in the workplace to avoid job-related sickness/accidents.', 'Staff', 'Occupational Health and Safety Management'),
(42, 118, 'Shares technical expertise and links with other institutions through the conduct of trainings, seminar-workshops, lectures, conferences and consultancy services to increase knowledge, skills and expertise of clients based on pre and post evaluations.', 'Staff', 'Sharing Expertise and Linkaging'),
(43, 119, 'Implements and ensures the effective waste segregation, collection, disposal through stakeholders'' awareness and empowerment in accordance with Republic Act 9003 that lead to cleaner and greener University adherence to national and international sanitation and pollution level standards.', 'Staff', 'Waste Management'),
(44, 120, 'Dreams and envisions what the future looks like for the university,  thinks dimensionally, crafts strategic goals and strategies to attain that future, identifies connections that are not obviously connected and comes up with new and creative ideas to enhance organizational effectiveness and responsiveness.', 'Staff', 'Thinking Strategically and Creatively'),
(45, 121, 'Creates a high performing organizational culture that is purpose driven, results-based, client focused and  team-oriented', 'Staff', 'Creating and Nurturing a High Performance Organization'),
(46, 122, 'Generates genuine enthusiasm and momentum for organizational development and change by engaging and involving groups and stakeholders to understand, support, commit and own the change agenda and to advance and sustain same for organizational effectiveness.', 'Staff', 'Leading Change'),
(47, 123, 'Builds a network of reciprocal, high trust and synergistic working relationship among employees  within the organization and across other government and non-government organizations to leverage and maximize  opportunities for strategic partnership with external stakeholders', 'Staff', 'Building Collaborative and Inclusive Working Relationships'),
(48, 124, 'Creates an enabling environment which will nurture and sustains a performance based coaching culture for increased effectiveness of employees and a strong focus in developing people for current and future needs thru an active and continuing staff development program for organizational effectiveness.', 'Staff', 'Managing Performance and Coaching for Results');

ALTER TABLE `rsp_competency_description`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rsp_competency_description_item_id_index` (`item_id`);
