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

START TRANSACTION;



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

--
-- Table structure for table `ref_com_secretariat`
--

CREATE TABLE `ref_com_secretariat` (
  `id` int(11) NOT NULL,
  `top_title_id` varchar(10) NOT NULL COMMENT 'Specifies the position at \r\nCOMESA Secretariat',
  `top_title_position` varchar(100) NOT NULL,
  `top_title_work_description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `ref_com_secretariat`
--

INSERT INTO `ref_com_secretariat` (`id`, `top_title_id`, `top_title_position`, `top_title_work_description`) VALUES
(1, 'SG', 'OFFICE OF THE SECRETARY GENERAL', 'The Secretary General (SG) is the Chief Executive Officer of the Common Market. The SG represents the Common Market in the exercise of its legal personality and acts as the secretary to the Authority and the Council. This office ensures that the objectives set out in this COMESA Treaty are attained'),
(2, 'ASG-P', 'OFFICE OF THE ASSISTANT SECRETARY GENERAL- PROGRAMMES', 'The office is in charge of five technical Divisions. These are Trade and Customs, Agriculture and Industry, Gender and Social Affairs, Infrastructure and Logistics and Information Technology.'),
(3, 'ASG-AF', 'OFFICE OF THE ASSISTANT SECRETARY GENERAL- ADMINISTRATION & FINANCE', 'This office is responsible for Administrative, Finance and Budgetary matters. It is responsible for two divisions; Administration and Finance.');

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

--
-- Table structure for table `ref_com_secretariat_divisions`
--

CREATE TABLE `ref_com_secretariat_divisions` (
  `id` int(11) NOT NULL,
  `division_id` int(11) UNSIGNED NOT NULL,
  `top_title_id` int(11) NOT NULL,
  `divison_name` varchar(25) NOT NULL,
  `divison_work_description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `ref_com_secretariat_divisions`
--

INSERT INTO `ref_com_secretariat_divisions` (`id`, `division_id`, `top_title_id`, `divison_name`, `divison_work_description`) VALUES
(1, 1, 0, 'Legal & Coorporate Affai', 'The Legal and Corporate Affairs Division of the COMESA Secretariat is headed by the Director of Legal and Corporate Affairs, supported by the Legal Affairs Officer and Intellectual Property Coordinator and the Senior Legal Assistant. The Division is the legal advisory arm of the Common Market for Eastern and Southern Africa (COMESA) and serves as the Office of the Legal Counsel of the Organization. The function of the Division is to provide legal advisory services to the policy organs of the organization as well as the Secretariat on the operations of the organization in terms of programmes and administrative matters .'),
(2, 2, 0, 'Trade and Customs', 'The main function of the division is to implement programmes to enhance cooperation in Trade, Customs and Monetary Affairs in order to achieve a fully integrated, internationally competitive and unified single economic space within which goods, services, capital and labour are able to move freely across national frontiers. The cooperation programmes aim to achieve the removal of all physical, technical, fiscal and monetary barriers to intra-regional trade and commercial exchanges through the following stages of integration'),
(3, 3, 0, 'Infrastructure & Logistic', 'COMESA has recognized infrastructure development as a priority and strategic focus area that requires special attention. The Strategic Objective to be pursued is, therefore, to effectively address constraints related to the improvement of infrastructure and services in the region in order to reduce the cost of doing business and also and to enhance competitiveness, through fostering physical regional connectivity and deepening infrastructure integration. '),
(4, 4, 0, 'Gender & Social Affairs', 'The Gender and Social Affairs Division in the COMESA Secretariat exists to promote and provide leadership, direction and oversight towards the achievement of Gender Equality and Women Empowerment (GEWE), Youth Empowerment, and Social and Cultural Development in the Member States, at the Secretariat and in COMESA Institutions.\r\n\r\nThe Division sets out to achieve this purpose through promotion of the implementation of the COMESA Gender Policy, Gender Mainstreaming, Advocacy and Capacity Building, implementation of the COMESA Health Framework, HIV and AIDS Policy, COMESA Youth Programme, COMESA Social Charter, Council Decisions, and targeted initiatives to advance women and youth.\r\n\r\nThe Division champions Gender Equality, Women Empowerment, Youth Empowerment, Health, Employment, Social Development, Drug Control, Sport and Cultural agenda to ensure the inclusion of women, youth and social development in the COMESA regional development agenda.\r\n\r\nThe work on Gender Equality, Women Empowerment, Youth Empowerment and Social Affairs is founded on the COMESA Treaty, and guided by the COMESA Gender Policy, continental and global frameworks and commitments.'),
(5, 5, 0, 'Information &  Networking', 'The Information and Networking Division is responsible for implementation and maintenance of Common Market’s Information systems, IT infrastructure and IT system support services. (Chapter 20, Article 139 of the treaty).\r\nThe Division of Information and Networking of the COMESA Secretariat acts as service support for the Secretariat. It is responsible for the entire end-user computing infrastructure comprising desktops, notebooks, printers, scanners and UPS’s.\r\nIt is also responsible for the network which allows the staff of the Secretariat to use the end-user computing infrastructure with other centralized organization resources such as email, printing, Internet and various information systems, using IT Supported hardware and software.\r\nTogether, these elements allow the staff to accomplish the critical business tasks of the organization.\r\nThe Division is also responsible for assisting COMESA to attain it’s main pillars by using ICT as a tool to enhance regional and continental integration and trade within the context of establishing the African economic community.\r\n'),
(6, 6, 0, 'Human Resources & Admin', 'The Division of Administration offers a key support service to the COMESA Secretariat. The mandate of the division is to provide Member States, Executive Management, Secretariat and other stakeholders with the Administrative services and advice they need. The Division is there to provide a high level of service and support on issues related to Human Resources, Conferencing, Procurement and General Services which will allow other Divisions and Units to efficiently and effectively execute their programmes and deliver on their mandates. The Division also ensures that all the resources, i.e. both budgetary and extra budgetary funds and human and physical assets, are properly accounted for in an efficient, secure and appropriately controlled Administrative environment.\r\n'),
(7, 7, 0, 'Budget & Finance', 'The Budget and Finance Division’s role is to provide Member States, Management, Secretariat and other stakeholders with financial services and advice they need and ensure that all the resources both budgetary and extra budgetary are properly accounted for in an efficient, secure and appropriately controlled financial environment.');

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

--
-- Table structure for table `ref_com_secretariat_funding`
--

CREATE TABLE `ref_com_secretariat_funding` (
  `id` int(11) NOT NULL,
  `funding_id` int(11) NOT NULL,
  `funding_name` varchar(50) NOT NULL,
  `funding_description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `ref_com_secretariat_grades`
--

CREATE TABLE `ref_com_secretariat_grades` (
  `id` int(11) NOT NULL,
  `grade_id` varchar(2) NOT NULL,
  `grade_name` varchar(100) NOT NULL,
  `grade_description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `ref_com_secretariat_grades`
--

INSERT INTO `ref_com_secretariat_grades` (`id`, `grade_id`, `grade_name`, `grade_description`) VALUES
(1, 'P1', 'Professional (P1)', ''),
(2, 'P2', 'Professional (P2)', ''),
(3, 'P3', 'Professional (P3)', ''),
(4, 'P4', 'Professional (P4)', '');

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

--
-- Table structure for table `ref_com_secretariat_projects`
--

CREATE TABLE `ref_com_secretariat_projects` (
  `id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `division_id` int(11) NOT NULL,
  `top_title_id` int(11) NOT NULL,
  `unit_id` int(11) NOT NULL,
  `funding_id` int(11) NOT NULL,
  `project_name` varchar(30) NOT NULL,
  `project_description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `ref_com_secretariat_units`
--

CREATE TABLE `ref_com_secretariat_units` (
  `id` int(11) NOT NULL,
  `unit_id` int(11) UNSIGNED NOT NULL,
  `division_id` int(11) NOT NULL,
  `top_title_id` int(11) NOT NULL,
  `unit_name` varchar(25) NOT NULL,
  `unit_work_description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `ref_com_secretariat_units`
--

INSERT INTO `ref_com_secretariat_units` (`id`, `unit_id`, `division_id`, `top_title_id`, `unit_name`, `unit_work_description`) VALUES
(1, 0, 0, 0, 'Corporate Communications ', 'Corporate Communications Unit backstops all communication activities that COMESA undertakes, both within and outside the'),
(2, 0, 0, 0, 'Executive Support', 'Executive Assistants perform a variety of administrative tasks—such as calendaring and corporate travel planning—while also tackling mission-driven company projects'),
(3, 0, 0, 0, 'Strategic Planning Resear', 'The Strategic Planning, Research and Policy Harmonisation Unit of COMESA Secretariat takes the lead in developing and formulating strategic plans and work programmes.'),
(4, 0, 0, 0, 'COMESA Statistics', 'Statistical Regulations define the work flow from statistical compilation and harmonization to data transmission and dissemination.\r\nRead More'),
(5, 0, 0, 0, 'Resource Mobilisation', 'The objective of the unit is to contribute to the impact, efficiency and effectiveness of COMESA Member States trade reforms and regional integration initiatives so that they can fully benefit from regional and international trade opportunities, reduce poverty and achieve their (MDG) development'),
(6, 0, 0, 0, ' Internal Audit', 'The role of Internal Audit is to provide independent, objective assurance and advisory services designed to add value and improve the Secretariat’s operations at strategic, tactical and operational levels.'),
(7, 0, 0, 0, 'Governance, Peace & Secur', '\r\n\r\nThe COMESA Governance Peace and Security (GPS) Programme derives its mandate from Article 3(d) of the COMESA Treaty. The programme was established by the Fourth Summit of the COMESA Authority, which was held in Nairobi, Kenya in May 1999. The COMESA Authority of Heads of State and Government endorsed a decision for the establishment of a formal structure for engagement on matters of peace and security and mandated COMESA Ministers of Foreign Affairs to meet at least once a year to discuss modalities for addressing issues of peace and security. The programme has a short three tier decision making structure comprising the Committee on Peace and Security, the Ministers of Foreign Affairs and the Authority.');

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

--
-- Table structure for table `ref_jobapplicant_status`
--

CREATE TABLE `ref_jobapplicant_status` (
  `id` int(11) NOT NULL,
  `jobapplicant_status_name` varchar(50) NOT NULL,
  `jobapplicant_status_description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `ref_jobapplicant_status`
--

INSERT INTO `ref_jobapplicant_status` (`id`, `jobapplicant_status_name`, `jobapplicant_status_description`) VALUES
(2, 'Still Waiting ', 'COMESA has NOT  responded to the applicant'),
(3, 'Short Listed', 'COMESA Secretariat has short listed the applicant');

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

--
-- Table structure for table `ref_titles`
--

CREATE TABLE `ref_titles` (
  `title_id` int(11) NOT NULL,
  `title_name` varchar(50) NOT NULL,
  `title_description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `ref_titles`
--

INSERT INTO `ref_titles` (`title_id`, `title_name`, `title_description`) VALUES
(1, 'Mr', ''),
(2, 'Ms', ''),
(3, 'Doctor', ''),
(4, 'Professor', '');

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

--
-- Table structure for table `transxn_com_vacancy_adverts`
--

CREATE TABLE `transxn_com_vacancy_adverts` (
  `id` int(11) NOT NULL,
  `advert_title` varchar(100) NOT NULL,
  `advert_introduction` text NOT NULL,
  `project_implementation_unit` varchar(100) NOT NULL,
  `vacancy_id` varchar(20) NOT NULL,
  `job_title` varchar(100) NOT NULL,
  `grade_id` varchar(11) DEFAULT NULL,
  `programe` varchar(100) NOT NULL,
  `duty_station` varchar(100) NOT NULL,
  `contract_duration` text NOT NULL,
  `reporting_to` varchar(50) NOT NULL,
  `scope_of_work` text NOT NULL,
  `key_responsibility_tasks` text NOT NULL,
  `education_qualifications` text NOT NULL,
  `skill_requirement_experience` text NOT NULL,
  `vacancy_advert_status` varchar(50) NOT NULL,
  `eligability_for_application` text NOT NULL,
  `final_date_for_applications` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `transxn_com_vacancy_adverts`
--

INSERT INTO `transxn_com_vacancy_adverts` (`id`, `advert_title`, `advert_introduction`, `project_implementation_unit`, `vacancy_id`, `job_title`, `grade_id`, `programe`, `duty_station`, `contract_duration`, `reporting_to`, `scope_of_work`, `key_responsibility_tasks`, `education_qualifications`, `skill_requirement_experience`, `vacancy_advert_status`, `eligability_for_application`, `final_date_for_applications`) VALUES
(1, '1. JOB DESCRIPTION POST ONE', 'The RIFF project is an Investment  Financing Project with funding from the World Bankto the  Common  Market  for  Eastern  and  Southern  Africa  (COMESA)  and  the  Trade  and Development Bank (TDB) . The TDB component will focus on provision of long-term credit to infrastructure projects in the region while the COMESA component is a grant component which  will support the enabling environment for private infrastructure finance  with  a  focus  on  building  a  regional  off-grid  energy  market.  It  will  allow  the  COMESA Secretariat to support: (i) the harmonization of policies and regulations for cross-border infrastructure trade and investment; (ii) regional integration activities on the off-grid energy sector and (iii) market development activities in the off-grid energy sector in Fragile, Conflict and Violence (FCV) countries. The  activities  in  support  of  the  enabling  environment  for  infrastructure  finance  are  expected to include: (i) issuance of guidance notes and model documents for PPP in infrastructure   sectors   other   than   energy,   such   as   transport   and   water;   (ii)   customization  and  dissemination  of  PPP  screening  tools  to  help  countries  improve  their screening of projects that may be suited to be structured as PPP; (iii) policies, guidance  and  platforms  to  facilitate  digital  infrastructure  and  digital  trading  in  the  COMESA region.To   implement   the   project,   the   COMESA   secretariat   will   set   up a   Project   Implementation Unit to be based in the Infrastructure and Logistics Division.', '', '2021-02-04 09:12:09', 'Project Manager', NULL, 'Regional Infrastructure Finance Facility (RIFF)', 'Infrastructure     and     Logistics     Division,     COMESA Secretariat, Lusaka, Zambia', 'Two  (2)  years  with  a  possibility  of  extensi', 'Director  Infrastructure  and  Logistics  Divisio', 'The  Project Manager will be responsible for planning and execution of the project, in terms of daily practical management of the project and coordination of the activities of the project. The Project Manager will work closely with the Energy Economist. He will provide technical  support  to  accelerate progress  on  enabling  environment  for  renewable energy with special focus on off grid energy.', 'The Project Manager will be based at the Infrastructure and Logistics Division, at the COMESA Secretariat in Lusaka, Zambia and will perform the following main functions in order to ensure overall delivery of the project:\r\n\r\na)  responsible for planning and execution of the project;\r\nb)  daily practical management of the project; \r\nc)  Supervision of the project team;\r\nd)  elaboration   of   Terms   of   Reference   (ToR)   of  Individual  and  Framework consultants; \r\ne)  Supervision of Consultants; \r\nf)   provision of technical support to accelerate progress on enabling environment through facilitating the following: \r\ni. development of model national electrification strategies \r\nii. Assessment of renewable energy landscape in the region to identify the actors,  potential  actors,  opportunities,  barriers,  ongoing  and  potential  projects; \r\niii. development of regional solar equipment standards and framework for standardization of tariffs for the COMESA region and;\r\n\r\niv.    development of a communication strategy to sensitize policy makers and private investors about the RIFF project; \r\ng)  review  renewable  energy  guidelines  on  regulatory  frameworks  for  Off-Grid Electrification    and    support    countries    to    domesticate/internalize    these    guidelines; \r\nh)  Facilitate capacity building in renewable energy finance, policy, regulation and project preparation;\r\ni)   Ensure that monitoring of the project is done and project progress reports are produced timely;\r\nj)   Provide and facilitate provision of Technical assistance for domestication of the COMESA policies and regulations in the energy sector; \r\nk)  In  collaboration  with  the  respective  sector  officers  within  the  secretariat, Develop  PPP  Model  framework  for  Infrastructure covering Energy,  Transportand  ICT  including  facilitation  of  capacity  building  for  COMESA/TDB  member  states; and \r\nl)   Perform any other duties as requested by supervisor required for the successful implementation of the project. ', 'The candidates must possess:\r\na)  Bachelors Degree in Engineering or Energy related disciplines and \r\nb)   Master’s    degree    in    renewable    energy,    energy    planning/economics,    engineering, business administration,  or  equivalent  areas  relevant  for  energy  sector  development.  A Ph.D. in any discipline  related  to  energy  would  be  an  added advantage. \r\nc)   A  professional  qualification  in  Public Private Partnerships  will  be  an added advantage.', 'a)  At least 10 Years working experience in the energy sector with at least 5 Years in the policy and regulation environment\r\nb)  Experience of project management and coordination experience (with project leader/manager/coordinator capacity) in the energy sector.\r\nc)  Experience with working at regional level\r\nd)  Experience in facilitating seminars and workshops.\r\ne)   Experience with implementation of projects using the PPP model is desirable.\r\nf)    Strong  management,  organizational  and  people  skills  and  ability  to  run  a  technical team.\r\ng)  Strong writing and presentation skills.  \r\nh)  Experience with vendor relationships and strategic partnerships as a number of the activities are set to be outsourced. \r\ni)   Financial management and fiscal responsibility.\r\nj)   Work experience of projects involving energy sector policy reforms, increasing access  to  modern  and  sustainable  energy  services  in  developing  countries  would be an advantage.\r\nk)  Work   experience   with   the   World Bank   rules   and   procedures   or   other   international development organisations and regional organisations  would  be  an advantage.', 'Vacancy st', 'Applicants must meet the eligibility requirements for selections and contracts funded by  proceeds  from  a  World  Bank  funded  project.  Citizens  of  a  COMESA  Member  country are encouraged to apply.', '2021-03-13'),
(2, '2. JOB DESCRIPTION POST TWO', 'The RIFF project is an Investment  Financing Project with funding from the World Bankto the  Common  Market  for  Eastern  and  Southern  Africa  (COMESA)  and  the  Trade  and Development Bank (TDB) . The TDB component will focus on provision of long-term credit to infrastructure projects in the region while the COMESA component is a grant component which  will support the enabling environment for private infrastructure finance  with  a  focus  on  building  a  regional  off-grid  energy  market.  It  will  allow  the  COMESA Secretariat to support: (i) the harmonization of policies and regulations for cross-border infrastructure trade and investment; (ii) regional integration activities on the off-grid energy sector and (iii) market development activities in the off-grid energy sector in Fragile, Conflict and Violence (FCV) countries. The  activities  in  support  of  the  enabling  environment  for  infrastructure  finance  are  expected to include: (i) issuance of guidance notes and model documents for PPP in infrastructure   sectors   other   than   energy,   such   as   transport   and   water;   (ii)   customization  and  dissemination  of  PPP  screening  tools  to  help  countries  improve  their screening of projects that may be suited to be structured as PPP; (iii) policies, guidance  and  platforms  to  facilitate  digital  infrastructure  and  digital  trading  in  the  COMESA region.To   implement   the   project,   the   COMESA   secretariat   will   set   up a   Project   Implementation Unit to be based in the Infrastructure and Logistics Division.', '', '2021-02-05 09:22:21', ' Renewable Energy Policy and Regulatory Expert', NULL, 'Regional Infrastructure Finance Facility (RIFF)  ', 'Infrastructure     and     Logistics     Division,     COMESA     Secretariat, Lusaka, Zambia', 'Two (2)  years  with  a  possibility  of  extensio', ' Project Manager  and  under  the  overall  guidan', 'The  role  of  the  Renewable  Energy  Policy  and  Regulatpry  Expert  will  be  to  provide  technical assistance to accelerate progress on implementation of regional renewable energy policies, plans and programmes . The coverage of the Expert shall include all the  renewable  energy  policy  and  regulatory  issues  covering  renewable  energy  in  general  with  specific  focus  on    off  grid  energy,  private  sector  investment  to  be  implemented for the benefit of COMESA/TDB member states. The Project Officer will be based within the Infrastructure and Logistics Division , Lusaka, Zambia.', 'The Renewable  Energy  Expert  will  be  based  at  the  Infrastructure  and  Logistics  Division, Lusaka, Zambia and will perform the following main functions:a) Support the Team Leadership in developing work-plans, schedules and activity budgets;\r\nb) provision of technical assistance to accelerate progress on implementation of regional renewable energy policies, regulations, plans and programmes of the stakeholders;\r\nc) provision   of   technical   assistance   to   review   renewable   energy   policies, strategies, action plans, regulatory frameworks and standards to establish best practices;\r\nd) Development of model rural electrification strategies;e) Elaboration  of  Terms  of  Reference  for  consultancy  services  in  renewable  energy;f)  Coordinate the recruitment of consultants and short term experts;\r\ng) Provision  of  capacity  building  to  Member  States  and  private  companies  on  renewable energy policies,regulations financing and project preparation;\r\nh) Development of content on project activities for visibility purposes;\r\ni)  Development of database for renewable energy companies, ongoing projects, proposed projects in the region\r\nj)  Schedule and organize meetings/events and maintain agenda/programme;\r\nk) Keep updated records and create reports for the project and its activities;\r\nl)  Supports   other   project   objectives   related   to   transport,   PPP   and   Digital   Infrastructure;\r\nm) performs other functions as may be required by the Project Manager  from to time.', 'The candidates must possess:\r\na)  Bachelors Degree in Engineering/Environment/Energy/Economics, and  \r\nb)  Master’s   degree   in   Engineering,   Energy   Planning/Economics,   Business   Administration, or equivalent areas relevant for energy sector development.', 'a)  At least eight (8) years of working experience in energy sector, five (5) of which must be in an energy policy environment;\r\nb)  Solid understanding of energy policies, strategies, institutions, and regulations;\r\nc)  Experience of working with financing or facilitating dissemination of renewable energy off grid systems; \r\nd)  Experience of working with public private partnership (PPP) and independent power producer (IPP) is desirable;\r\ne)  Project Management – Demonstrated ability to originate, plan, execute, control and complete a given task to achieve specific goals with a team on time and on budget.\r\nf)   Experience of working at regional level will be added advantage;\r\ng)  Strong    team    working,    communication    (including    report    writing)    and    interpersonal skills; \r\nh)  Strong  facilitation,  training  and  presentation  skills  as  well  as  experience  in  organizing seminars and workshops;  \r\ni)   Experience of working in a multi-cultural environment; \r\nj)   Proficiency in MS Office (word, excel, outlook and power point); \r\nk)  Proven communication skills (oral and written);  \r\nl)   Work experience with the WB rules and procedures  or other International Development organisations and regional organisations would be an advantage.', 'Vacancy still Open ', 'Applicants must meet the eligibility requirements for selections and contracts funded by  proceeds  from  a  World  Bank  funded  project.  Citizens  of  a  COMESA  Member  country are encouraged to apply.', '2021-03-20'),
(3, '3. JOB DESCRIPTION POST THREE', 'The RIFF project is an Investment  Financing Project with funding from the World Bankto the  Common  Market  for  Eastern  and  Southern  Africa  (COMESA)  and  the  Trade  and Development Bank (TDB) . The TDB component will focus on provision of long-term credit to infrastructure projects in the region while the COMESA component is a grant component which  will support the enabling environment for private infrastructure finance  with  a  focus  on  building  a  regional  off-grid  energy  market.  It  will  allow  the  COMESA Secretariat to support: (i) the harmonization of policies and regulations for cross-border infrastructure trade and investment; (ii) regional integration activities on the off-grid energy sector and (iii) market development activities in the off-grid energy sector in Fragile, Conflict and Violence (FCV) countries. The  activities  in  support  of  the  enabling  environment  for  infrastructure  finance  are  expected to include: (i) issuance of guidance notes and model documents for PPP in infrastructure   sectors   other   than   energy,   such   as   transport   and   water;   (ii)   customization  and  dissemination  of  PPP  screening  tools  to  help  countries  improve  their screening of projects that may be suited to be structured as PPP; (iii) policies, guidance  and  platforms  to  facilitate  digital  infrastructure  and  digital  trading  in  the  COMESA region.To   implement   the   project,   the   COMESA   secretariat   will   set   up a   Project   Implementation Unit to be based in the Infrastructure and Logistics Division.', '', '2021-02-04 10:05:39', ' Finance Expert', NULL, 'Project on Regional Infrastructure Finance Facility (RIFF)', 'Budget and FinanceDivision-COMESA Secretariat, Lusaka, Zambia', 'Two (2)  years  with  a  possibility  of  extensio', 'Finance Officer under the overall direction of the', 'The Project Finance Expert will be expected to provide support for the financial aspects  of  the  project  PIU  through  the  support  of  the  other  Project  team  members to ensure implementation, efficient performance and delivery of the expected  results.  He/she  will work  closely  with  the  Division  of  Budget  and  Finance,  in  the  development  of  annual  budgets  in  consultation  with  other  Stakeholders  for  the  the  benefit  of  all  Member  States  and  the  Secretariat.  He/She will coordinate and implement the project financial issues, in the sense that he/she will prepare financial reports for the project and will attend to day-to-day activities relating to the finance and ensure the following outputs:\r\na) Approved Work Plan and budgets \r\nb) Approved decisions on Approved project action plans\r\nc) Approved updated project Accounts;\r\nd) An up to date accounts data management system;\r\ne) Completed      accounts      services      provided      in      the      World      Bank  formats; and\r\nf) Standard periodical Accounts reports.\r\ne)  Monthly, quarterly and annual management reports including the IFRs and annual financial statements in form and agreed form and content.', 'The  Finance  Expert  will  be  based  at  the  COMESA  Budget  and  Finance  Division, Lusaka, Zambia and will perform the following main functions in order to ensure overall delivery of the project: \r\na)  Ensure  adequate  FM  arrangements  for  the  project  including  budgeting,  funds  flows,  accounting,  internal  controls,  financial  reporting  and  audit  arrangements as per the Finance Manual\r\nb)  Ensure  compliance  with  all  project  FM  documents  including  the  Financial  Agreement  (FA),  Disbursement  and  Financial  Information  Letter  (DFIL),  Financial  Management  Procedures Manual  (FMPM),  Project  Appraisal Document (PAD) and Project Operations Manual (POM).\r\nc)  Be  the  focal  point  for  project  staff  in  the  interpretation,  operation  and  implementation of the project’s financial management matters;\r\nd)  Maintenance of credible books of accounts; requisitions and justifications of project funds as per World Bank’s guidelines;\r\ne)  Preparation of the Annual Project Work Plans and Budgets;\r\nf)   Ensure proper coding of the project budget and posting of transactions in line COMESA’s chart of accounts;\r\ng)  Ensure   adequate   annual   budgetary   allocation   with   proper   budget   classification in all budgetary periods;\r\nh)  Ensure  proper  management  of  the  budget  and  prepare  monthly  and  quarterly reports to meet deadlines;\r\ni)   Prepare  payment  vouchers  after  careful  verification  of  the  supporting  documents\r\nj)   Effect timely payments and resolve accounting related issues;\r\nk)  Ensure COMESA’s internal control procedures are adhered with;\r\nl)   Continuously monitor and analyse the cash flow requirements of the project;\r\nm) Timely  preparation  and  submission  of  the  quarterly Interim  Financial Reports (IFR) and annual audited financial statements to the World Bank.  \r\nn)  Processes  accurately  and  promptly  all  accounting  transactions,  including  payroll, operating expenses, travel, consultant payments vendor payments, charge backs and other office running expenses.\r\no)  Maintain reconciled accounts at any given point in the project and regularly reviews the open item accounts and resolves any outstanding items;\r\np)  Keep  relevant  documents  and  invoices  systematically  to  fully  support  the  accounts;\r\nq)  Maintain proper files and records of the project;\r\nr)   Preparation  of  requisite  annual  financial  reports  in  time  for  submission  to  external audit;\r\ns)  Facilitate the audit of the project accounts and other financial reports;\r\nt)   Follow up and promptly resolve all FM and audit issues on the project;\r\nu)  Facilitate  the  submission  of  the  RIFF’s  audited  annual  project  specific  financial statements to the World Bank within the required timelines.\r\nv)  Perform other duties as may be assigned by the immediate supervisor.', 'The candidates must posses:a)  At least a Bachelor’s degree in any of the relevant disciplines, including commerce,   accounting,   finance,   or   business   from   a   recognized   university; and \r\nb)  Certified  Public  Accountant  (CPA)  or  equivalent  and  the  successful  candidate should be a member of a professional accountancy body.\r\nc)  A  Master’s  Degree  in  Business  Administration  (MBA),  or  any  other  equivalent degree would be a plus.', 'a)  A  minimum  of  Five  (5)  years’  of  continuous  work  experience  in  finance  and  accounting,  minimum  3  years  of  which  must  have  working  responsibilities  in  audit or financial management environment.\r\nb)  Specific work experience in projects funded by World Bank Group and or similar International Cooperating Partner would be required; \r\nc)  High level of personal and professional integrity with strong analytical skills and ability to function well in a multi-cultural environment \r\nd)  Strong interpersonal skills and orientation as a team member;  \r\ne)  Ability to deal sensitively and build effective working relations with clients and colleagues;\r\nf)   Strong communication skill with ability to prepare, present and discuss findings in written and oral formg)  Innovation and networking; \r\nh)  Self-motivated and able to work with minimum supervision;\r\ni)    Results-oriented;\r\nj)    Ability to mobilize and coordinate a wide range of partners is critical;  \r\nk)  Good knowledge of computer applications; \r\nl)    Ability to prepare concise, timely, analytical and informative documentation.\r\nm) Ability to work in teams.  ', 'Advert Closed', 'Applicants must meet the eligibility requirements for selections and contracts funded by  proceeds  from  a  World  Bank  funded  project.  Citizens  of  a  COMESA  Member  country are encouraged to apply.', '2021-02-03');

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

--
-- Table structure for table `transxn_com_vac_app_computer_literacy`
--

CREATE TABLE `transxn_com_vac_app_computer_literacy` (
  `id` int(11) NOT NULL,
  `user_id` varchar(100) DEFAULT NULL,
  `prof_review` varchar(100) DEFAULT NULL,
  `software` varchar(50) DEFAULT NULL,
  `Knowledge Level` varchar(20) DEFAULT NULL,
  `good` tinyint(1) DEFAULT NULL,
  `average` tinyint(1) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transxn_com_vac_app_computer_literacy`
--

INSERT INTO `transxn_com_vac_app_computer_literacy` (`id`, `user_id`, `prof_review`, `software`, `Knowledge Level`, `good`, `average`, `updated_at`, `created_at`) VALUES
(11, 'daisymondchiboora@gmail.com', 'daisymondchiboora@gmail.com', 'JAVA ', 'Excellent', NULL, NULL, NULL, NULL),
(13, 'fbesa@comesa.int', 'daisymondchiboora@gmail.com', 'java', 'Excellent', NULL, NULL, NULL, NULL),
(14, 'sndlovu@comesa.int', 'daisymondchiboora@gmail.com', 'Ms Excel ', 'Excellent', NULL, NULL, NULL, NULL),
(15, 'sndlovu@comesa.int', 'daisymondchiboora@gmail.com', 'Ms word', 'Excellent', NULL, NULL, NULL, NULL),
(16, 'sndlovu@comesa.int', 'daisymondchiboora@gmail.com', 'ERP Systems software', 'Excellent', NULL, NULL, NULL, NULL),
(17, 'munashechiboora@gmail.com', 'daisymondchiboora@gmail.com', 'GO', 'Excellent', NULL, NULL, NULL, NULL),
(18, 'chongoB@gmail.com', 'Guest', 'PHP', 'Excellent', NULL, NULL, NULL, NULL),
(19, 'oliver@gmail.com', 'Guest', 'Pyhton', 'Excellent', NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `transxn_com_vac_app_dependent_children`
--

CREATE TABLE `transxn_com_vac_app_dependent_children` (
  `id` int(11) NOT NULL,
  `user_id` varchar(100) DEFAULT NULL,
  `prof_review` varchar(100) DEFAULT NULL,
  `dependent_children` varchar(100) DEFAULT NULL,
  `names_of_children` varchar(50) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `place_of_birth` varchar(50) DEFAULT NULL,
  `nationality` varchar(50) DEFAULT NULL,
  `applicantChildGender` varchar(50) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transxn_com_vac_app_dependent_children`
--

INSERT INTO `transxn_com_vac_app_dependent_children` (`id`, `user_id`, `prof_review`, `dependent_children`, `names_of_children`, `dob`, `place_of_birth`, `nationality`, `applicantChildGender`, `updated_at`, `created_at`) VALUES
(24, 'daisymondchiboora@gmail.com', 'daisymondchiboora@gmail.com', NULL, 'Ash', '1999-08-22', 'Chirumanzu', 'Zimbabwe', 'Male', NULL, NULL),
(25, 'daisymondchiboora@gmail.com', 'daisymondchiboora@gmail.com', NULL, 'kelly', '2015-02-04', 'Gweru', 'Zimbabwean', 'Female', NULL, NULL),
(26, 'fbesa@comesa.int', 'daisymondchiboora@gmail.com', NULL, 'trey', '2021-02-25', 'us', 'us', 'Male', NULL, NULL),
(27, 'fbesa@comesa.int', 'daisymondchiboora@gmail.com', NULL, 'cash', '2021-02-26', 'zw', 'zim', 'Female', NULL, NULL),
(28, 'sndlovu@comesa.int', 'daisymondchiboora@gmail.com', NULL, 'Sawtee', '2021-03-01', 'Barbuda', 'Zambian', 'Male', NULL, NULL),
(29, 'sndlovu@comesa.int', 'daisymondchiboora@gmail.com', NULL, 'Nikki', '2021-03-11', 'US', 'US', 'Female', NULL, NULL),
(30, 'munashechiboora@gmail.com', 'daisymondchiboora@gmail.com', NULL, 'Amy', '2021-02-28', 'SA', 'SA', 'Female', NULL, NULL),
(31, 'chongoB@gmail.com', 'Guest', NULL, 'Chongo jr', '2021-03-01', 'Zambia', 'Zambian', 'Male', NULL, NULL),
(32, 'chongoB@gmail.com', 'Guest', NULL, 'Gyna', '2021-03-01', 'Zambia', 'American', 'Female', NULL, NULL),
(33, 'chongoB@gmail.com', 'Guest', NULL, 'Ketty', '2020-10-14', 'Guinea', 'American', 'Female', NULL, NULL),
(34, 'oliver@gmail.com', 'Guest', NULL, 'Damian', '2021-02-28', 'Beijing', 'Namibian', 'Male', NULL, NULL);

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

--
-- Table structure for table `transxn_com_vac_app_employment_profile`
--

CREATE TABLE `transxn_com_vac_app_employment_profile` (
  `id` int(11) NOT NULL,
  `user_id` varchar(100) DEFAULT NULL,
  `prof_review` varchar(100) DEFAULT NULL,
  `title_of_post` varchar(50) DEFAULT NULL,
  `name_of_employer` varchar(50) DEFAULT NULL,
  `employment_start_date` date DEFAULT NULL,
  `employment_end_date` date DEFAULT NULL,
  `address_of_employer` varchar(50) DEFAULT NULL,
  `type_organization` varchar(50) DEFAULT NULL,
  `no_of_superiors_reported_to` varchar(11) DEFAULT NULL,
  `no_of_employees_supervised` varchar(11) DEFAULT NULL,
  `description_of_duties` text DEFAULT NULL,
  `job_problems` text DEFAULT NULL,
  `ways_of_handling_them` text DEFAULT NULL,
  `salary` varchar(50) DEFAULT NULL,
  `reasons_of_leaving` varchar(500) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transxn_com_vac_app_employment_profile`
--

INSERT INTO `transxn_com_vac_app_employment_profile` (`id`, `user_id`, `prof_review`, `title_of_post`, `name_of_employer`, `employment_start_date`, `employment_end_date`, `address_of_employer`, `type_organization`, `no_of_superiors_reported_to`, `no_of_employees_supervised`, `description_of_duties`, `job_problems`, `ways_of_handling_them`, `salary`, `reasons_of_leaving`, `updated_at`, `created_at`) VALUES
(10, 'daisymondchiboora@gmail.com', 'daisymondchiboora@gmail.com', 'Software developer', 'Econet', '2019-04-21', '2021-03-13', '45th ave, harare', 'private', '4', '2', '- Software design, implementation, testing', 'none', 'none', '20', 'none', NULL, NULL),
(11, 'fbesa@comesa.int', 'daisymondchiboora@gmail.com', 'ceo', 'COMESA', '2021-02-25', '2021-02-28', 'Ben Bellar rd', 'org', '0', '1', 'VD', 'none', 'none', '4', 'none', '2021-02-24 22:00:00', '2021-02-24 22:00:00'),
(12, 'sndlovu@comesa.int', 'daisymondchiboora@gmail.com', 'Accountant', 'COMESA', '2021-02-28', '2021-03-01', 'Ben Bella rd', 'Int', '1', '5', '- Accounting', 'none', 'none', '10', 'none', NULL, NULL),
(13, 'munashechiboora@gmail.com', 'daisymondchiboora@gmail.com', 'Project Manager', 'Google', '2021-02-28', '2021-03-01', 'Califonia', 'pvt', '0', '10', 'project management', 'none', 'none', '10000', 'none', NULL, NULL),
(14, 'chongoB@gmail.com', 'Guest', 'Finance Expert', 'Barclays Bank', '2021-02-28', '2021-03-01', '576 Cross road', 'pvt', '0', '15', 'none', 'none', 'none', '10000000', 'none', NULL, NULL),
(15, 'oliver@gmail.com', 'Guest', 'Energy Resources Manager', 'Solr Energies Africa', '2021-02-28', '2021-03-01', 'Plot 29574', 'pvt', '0', '18', 'none', 'none', 'none', '7000000', 'none', NULL, NULL);

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

--
-- Table structure for table `transxn_com_vac_app_general_info`
--

CREATE TABLE `transxn_com_vac_app_general_info` (
  `id` int(11) NOT NULL,
  `user_id` varchar(100) DEFAULT NULL,
  `prof_review` varchar(100) DEFAULT NULL,
  `title_id` int(11) DEFAULT NULL,
  `post_applied_for` varchar(50) DEFAULT NULL,
  `date_of_advertisement` date DEFAULT NULL,
  `family_name` varchar(50) NOT NULL,
  `first_name` varchar(50) NOT NULL,
  `middle_name` varchar(50) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `place_of_birth` varchar(50) DEFAULT NULL,
  `nationality_at_birth` varchar(50) DEFAULT NULL,
  `present_nationality` varchar(50) DEFAULT NULL,
  `national_id_passport_numb` varchar(50) DEFAULT NULL,
  `gender` varchar(50) NOT NULL,
  `permanent_address` varchar(50) NOT NULL,
  `present_address` varchar(100) NOT NULL,
  `office_phone_number` varchar(50) DEFAULT NULL,
  `office_fax_number` varchar(50) DEFAULT NULL,
  `residence_phone_number` varchar(50) DEFAULT NULL,
  `relevant_years_of_exp` int(20) DEFAULT NULL,
  `job_aplication_status` int(11) NOT NULL DEFAULT 2,
  `hr_comment` text DEFAULT NULL,
  `application_status_edited_by` varchar(20) DEFAULT NULL,
  `date_edited` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transxn_com_vac_app_general_info`
--

INSERT INTO `transxn_com_vac_app_general_info` (`id`, `user_id`, `prof_review`, `title_id`, `post_applied_for`, `date_of_advertisement`, `family_name`, `first_name`, `middle_name`, `dob`, `place_of_birth`, `nationality_at_birth`, `present_nationality`, `national_id_passport_numb`, `gender`, `permanent_address`, `present_address`, `office_phone_number`, `office_fax_number`, `residence_phone_number`, `relevant_years_of_exp`, `job_aplication_status`, `hr_comment`, `application_status_edited_by`, `date_edited`) VALUES
(31, 'daisymondchiboora@gmail.com', 'daisymondchiboora@gmail.com', 1, 'Project Manager', '2021-02-15', 'Chiboora', 'Daisymond', 'Munashe', '1996-04-16', 'Chirumanzu', 'Zimbabwean', 'Zimbabwean', 'BN004562', 'Male', '598 dz ext', '598 dz ext', '78934843984', '83589384', '853957934', 10, 3, 'Applicant Short listed', NULL, NULL),
(32, 'fbesa@comesa.int', 'daisymondchiboora@gmail.com', 1, ' Renewable Energy Policy and Regulatory Expert', '2021-02-23', 'Besa', 'Freddo', '', '1965-02-23', 'Zambia', 'Zambian', 'Zambia', 'AH8723692', 'Male', '12132 high end', '12132 high end', '345678567', '345678', '358908766', NULL, 2, NULL, NULL, NULL),
(33, 'sndlovu@comesa.int', 'daisymondchiboora@gmail.com', 1, ' Finance Expert', '2021-02-17', 'Ndlovu', 'Sandi', '', '1970-02-24', 'zim', 'zim', 'Zambian', 'BN438792', 'Male', '764 Cornway street', '764  Cornway street', '2673782792', '662457827', '625432735', NULL, 2, NULL, NULL, NULL),
(34, 'munashechiboora@gmail.com', 'daisymondchiboora@gmail.com', 1, 'Project Manager', '2021-03-01', 'Chiboora', 'Munashe', '', '1996-01-28', 'Egypt', 'Egyptian', 'Zimbabwean', 'BN394833', 'Male', '8873 Green row gardens', '8873 Green row gardens', '8934702', '9482034', '02488043', NULL, 2, NULL, NULL, NULL),
(35, 'chongoB@gmail.com', 'Guest', 1, ' Finance Expert', '2021-03-01', 'Besa', 'Chongo', 'Chongo', '1997-02-28', 'Zambia', 'Zambia', 'Zambian', 'CB6283973', 'Male', 'Plot 29574', 'Chalala', '0977750005', '45669778', '465798787', NULL, 2, NULL, NULL, NULL),
(36, 'oliver@gmail.com', 'Guest', 1, ' Renewable Energy Policy and Regulatory Expert', '2021-02-28', 'Carter', 'Oliver', '', '1998-02-28', 'Namibia', 'Namibia', 'Namibian', 'NB542736', 'Male', 'Plot 29574', 'Chalala', '0977750005', '57689877', '78785687', NULL, 2, NULL, NULL, NULL);

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

--
-- Table structure for table `transxn_com_vac_app_job_character_questions`
--

CREATE TABLE `transxn_com_vac_app_job_character_questions` (
  `id` int(11) NOT NULL,
  `user_id` varchar(100) DEFAULT NULL,
  `prof_review` varchar(100) DEFAULT NULL,
  `most_enjoyed_organization` text DEFAULT NULL,
  `skills_owing_to_post_applied` text DEFAULT NULL,
  `archievements_justifying_skills` text DEFAULT NULL,
  `expectations_for_applied_post` text DEFAULT NULL,
  `other_comments` text DEFAULT NULL,
  `truth_certification` varchar(500) DEFAULT NULL,
  `application_date` date DEFAULT NULL,
  `signature` varchar(50) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transxn_com_vac_app_job_character_questions`
--

INSERT INTO `transxn_com_vac_app_job_character_questions` (`id`, `user_id`, `prof_review`, `most_enjoyed_organization`, `skills_owing_to_post_applied`, `archievements_justifying_skills`, `expectations_for_applied_post`, `other_comments`, `truth_certification`, `application_date`, `signature`, `updated_at`, `created_at`) VALUES
(5, 'fbesa@comesa.int', 'daisymondchiboora@gmail.com', 'COMESA', 'Software analysis', 'Best dev', 'none', 'none', 'no', '2021-02-25', NULL, NULL, NULL),
(6, 'sndlovu@comesa.int', 'daisymondchiboora@gmail.com', 'COMESA', '- Math', 'none', 'More experience', 'none', 'no', '2021-03-01', NULL, NULL, NULL),
(7, 'munashechiboora@gmail.com', 'daisymondchiboora@gmail.com', 'Google', 'pjmnt', 'none', 'none', 'none', 'not true', '2021-03-01', NULL, NULL, NULL),
(8, 'chongoB@gmail.com', 'Guest', 'Barclays Bank', 'none', 'none', 'none', 'none', 'no', '2021-03-01', NULL, NULL, NULL),
(9, 'oliver@gmail.com', 'Guest', 'Solr Energies Africa', 'none', 'none', 'none', 'none', 'no', '2021-03-01', NULL, NULL, NULL);

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

--
-- Table structure for table `transxn_com_vac_app_other_languages`
--

CREATE TABLE `transxn_com_vac_app_other_languages` (
  `id` int(11) NOT NULL,
  `user_id` varchar(100) DEFAULT NULL,
  `prof_review` varchar(100) DEFAULT NULL,
  `language` varchar(50) DEFAULT NULL,
  `other_language` varchar(50) DEFAULT NULL,
  `Langauge Level` varchar(20) DEFAULT NULL,
  `langGood` tinyint(1) DEFAULT NULL,
  `langBasic` tinyint(1) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transxn_com_vac_app_other_languages`
--

INSERT INTO `transxn_com_vac_app_other_languages` (`id`, `user_id`, `prof_review`, `language`, `other_language`, `Langauge Level`, `langGood`, `langBasic`, `updated_at`, `created_at`) VALUES
(8, 'daisymondchiboora@gmail.com', 'daisymondchiboora@gmail.com', 'English', 'Tonga', 'Basic', NULL, NULL, NULL, NULL),
(9, 'fbesa@comesa.int', 'daisymondchiboora@gmail.com', 'eng', '', 'Good', NULL, NULL, NULL, NULL),
(10, 'sndlovu@comesa.int', 'daisymondchiboora@gmail.com', 'English', 'Ndebele', 'Good', NULL, NULL, NULL, NULL),
(11, 'munashechiboora@gmail.com', 'daisymondchiboora@gmail.com', 'English', 'none', 'Good', NULL, NULL, NULL, NULL),
(12, 'chongoB@gmail.com', 'Guest', 'English', '', 'Good', NULL, NULL, NULL, NULL),
(13, 'oliver@gmail.com', 'Guest', 'English', 'none', 'Good', NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `transxn_com_vac_app_other_qualifications`
--

CREATE TABLE `transxn_com_vac_app_other_qualifications` (
  `id` int(50) NOT NULL,
  `user_id` varchar(100) DEFAULT NULL,
  `prof_review` varchar(100) DEFAULT NULL,
  `name_of_institution` varchar(50) DEFAULT NULL,
  `city_of_study` varchar(50) DEFAULT NULL,
  `applicantCountryOfInstitution` varchar(50) DEFAULT NULL,
  `study_start_date` date DEFAULT NULL,
  `study_end_date` date DEFAULT NULL,
  `applicantInstitutionMainCourseofStudy` varchar(100) DEFAULT NULL,
  `InstitutionMainCourseofStudyFilesPath` varchar(1000) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transxn_com_vac_app_other_qualifications`
--

INSERT INTO `transxn_com_vac_app_other_qualifications` (`id`, `user_id`, `prof_review`, `name_of_institution`, `city_of_study`, `applicantCountryOfInstitution`, `study_start_date`, `study_end_date`, `applicantInstitutionMainCourseofStudy`, `InstitutionMainCourseofStudyFilesPath`, `updated_at`, `created_at`) VALUES
(15, 'daisymondchiboora@gmail.com', 'daisymondchiboora@gmail.com', 'Harare Poly-technique', 'Harare', 'Zimbabwe', '2011-02-22', '2015-07-15', 'Computer Engineering', '[{\"name\":\"files\\/AMMENDED VERSION  COMWARN SVAs Primer V 2020 with red highlights_7ngyy1mc.doc\",\"usrName\":\"AMMENDED VERSION  COMWARN SVAs Primer V 2020 with red highlights.doc\",\"size\":722432,\"type\":\"application\\/msword\",\"searchStr\":\"AMMENDED VERSION  COMWARN SVAs Primer V 2020 with red highlights.doc,!:sStrEnd\"}]', NULL, NULL),
(16, 'fbesa@comesa.int', 'daisymondchiboora@gmail.com', 'zjut', 'zj', 'cn', '2021-02-25', '2021-02-25', 'Comp Scie', '[{\"name\":\"files\\/YASSMINE-CONTRACT- Agreculture- 2_c6oln7t1.docx\",\"usrName\":\"YASSMINE-CONTRACT- Agreculture- 2.docx\",\"size\":67674,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"YASSMINE-CONTRACT- Agreculture- 2.docx,!:sStrEnd\"}]', NULL, NULL),
(17, 'sndlovu@comesa.int', 'daisymondchiboora@gmail.com', 'ACA', 'Capital City', 'Cambodia', '2021-03-02', '2021-04-05', 'MBA', '[{\"name\":\"files\\/Pro_C5200_Series_ukck5ncn.pdf\",\"usrName\":\"Pro_C5200_Series.pdf\",\"size\":3287894,\"type\":\"application\\/pdf\",\"searchStr\":\"Pro_C5200_Series.pdf,!:sStrEnd\"}]', NULL, NULL),
(18, 'munashechiboora@gmail.com', 'daisymondchiboora@gmail.com', 'PJMI', 'Lusaka', 'Zambia', '2021-02-28', '2021-03-01', 'Project Management', '[{\"name\":\"files\\/Tasheni Muluwe Information_y8ngreqw.docx\",\"usrName\":\"Tasheni Muluwe Information.docx\",\"size\":15048,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"Tasheni Muluwe Information.docx,!:sStrEnd\"}]', NULL, NULL),
(19, 'chongoB@gmail.com', 'Guest', 'Financial Studies', 'Lusaka', 'Zambia', '2021-03-01', '2021-04-08', 'Finance', '[{\"name\":\"files\\/Tasheni Muluwe Information_8pqbgfex.docx\",\"usrName\":\"Tasheni Muluwe Information.docx\",\"size\":15048,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"Tasheni Muluwe Information.docx,!:sStrEnd\"}]', NULL, NULL),
(20, 'oliver@gmail.com', 'Guest', 'ENGPWR', 'Lusaka', 'Zambia', '2020-10-13', '2021-04-02', 'Renewable Energy', '[{\"name\":\"files\\/~$sheni Muluwe Information_5feo7y35.docx\",\"usrName\":\"~$sheni Muluwe Information.docx\",\"size\":162,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"~$sheni Muluwe Information.docx,!:sStrEnd\"}]', NULL, NULL);

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

--
-- Table structure for table `transxn_com_vac_app_referees`
--

CREATE TABLE `transxn_com_vac_app_referees` (
  `id` int(11) NOT NULL,
  `user_id` varchar(100) DEFAULT NULL,
  `prof_review` varchar(100) DEFAULT NULL,
  `ref_full_name` varchar(50) DEFAULT NULL,
  `ref_full_address` varchar(100) DEFAULT NULL,
  `ref_business_occupation` varchar(50) DEFAULT NULL,
  `ref_phone_number` varchar(50) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transxn_com_vac_app_referees`
--

INSERT INTO `transxn_com_vac_app_referees` (`id`, `user_id`, `prof_review`, `ref_full_name`, `ref_full_address`, `ref_business_occupation`, `ref_phone_number`, `updated_at`, `created_at`) VALUES
(7, 'daisymondchiboora@gmail.com', 'daisymondchiboora@gmail.com', 'Fredrick Besa', 'COMESA HQ', 'CVTFS Cordinatot', '+260978840', NULL, NULL),
(8, 'fbesa@comesa.int', 'daisymondchiboora@gmail.com', 'ref', 'ref add', 'ceo', '3456789', NULL, NULL),
(9, 'sndlovu@comesa.int', 'daisymondchiboora@gmail.com', 'Vince Carter', '35 Gold ave', 'CEO', '34543', NULL, NULL),
(10, 'munashechiboora@gmail.com', 'daisymondchiboora@gmail.com', 'Tim Cook', '1 apple dr', 'CEO', '+1 45678907', NULL, NULL),
(11, 'chongoB@gmail.com', 'Guest', 'George Grey', '7236 cash lane', 'CEO', '24356789', NULL, NULL),
(12, 'oliver@gmail.com', 'Guest', 'August Alsina', '2374 cat road', 'CEO', '5678903434', NULL, NULL);

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

--
-- Table structure for table `transxn_com_vac_app_scholary_publications`
--

CREATE TABLE `transxn_com_vac_app_scholary_publications` (
  `id` int(11) NOT NULL,
  `user_id` varchar(100) DEFAULT NULL,
  `prof_review` varchar(100) DEFAULT NULL,
  `publication_name` varchar(50) DEFAULT NULL,
  `publication_File_Path` varchar(1000) DEFAULT NULL,
  `date_of_publication` date DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transxn_com_vac_app_scholary_publications`
--

INSERT INTO `transxn_com_vac_app_scholary_publications` (`id`, `user_id`, `prof_review`, `publication_name`, `publication_File_Path`, `date_of_publication`, `updated_at`, `created_at`) VALUES
(14, 'daisymondchiboora@gmail.com', 'daisymondchiboora@gmail.com', 'Information Security', '[{\"name\":\"files\\/Alfateh Ahmed  Mahmoud-TRANSLATION INVOICE - Copy (2)_l4u9ziqa.docx\",\"usrName\":\"Alfateh Ahmed  Mahmoud-TRANSLATION INVOICE - Copy (2).docx\",\"size\":26654,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"Alfateh Ahmed  Mahmoud-TRANSLATION INVOICE - Copy (2).docx,!:sStrEnd\"}]', '2018-01-06', NULL, NULL),
(15, 'fbesa@comesa.int', 'daisymondchiboora@gmail.com', 'info sec ', '[{\"name\":\"files\\/Doc 1B-(CS-CM-BUR-XXXII-1B).Organisation of Work_e7p72qu0.docx\",\"usrName\":\"Doc 1B-(CS-CM-BUR-XXXII-1B).Organisation of Work.docx\",\"size\":124387,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"Doc 1B-(CS-CM-BUR-XXXII-1B).Organisation of Work.docx,!:sStrEnd\"}]', NULL, NULL, NULL),
(16, 'sndlovu@comesa.int', 'daisymondchiboora@gmail.com', 'FinTech', '[{\"name\":\"files\\/~$sheni Muluwe Information_pctve1df.docx\",\"usrName\":\"~$sheni Muluwe Information.docx\",\"size\":162,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"~$sheni Muluwe Information.docx,!:sStrEnd\"}]', '2021-03-02', NULL, NULL),
(17, 'munashechiboora@gmail.com', 'daisymondchiboora@gmail.com', 'Project Management', '[{\"name\":\"files\\/~$sheni Muluwe Information_iz0drvxj.docx\",\"usrName\":\"~$sheni Muluwe Information.docx\",\"size\":162,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"~$sheni Muluwe Information.docx,!:sStrEnd\"}]', '2021-03-01', NULL, NULL),
(18, 'chongoB@gmail.com', 'Guest', 'Finance Ways', '[{\"name\":\"files\\/~$sheni Muluwe Information_na2ax4lr.docx\",\"usrName\":\"~$sheni Muluwe Information.docx\",\"size\":162,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"~$sheni Muluwe Information.docx,!:sStrEnd\"}]', NULL, NULL, NULL),
(19, 'oliver@gmail.com', 'Guest', 'Renewable Energy', '[{\"name\":\"files\\/~$sheni Muluwe Information_kk9tzv19.docx\",\"usrName\":\"~$sheni Muluwe Information.docx\",\"size\":162,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"~$sheni Muluwe Information.docx,!:sStrEnd\"}]', '2021-02-28', NULL, NULL);

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

--
-- Table structure for table `transxn_com_vac_app_university_qualifications`
--

CREATE TABLE `transxn_com_vac_app_university_qualifications` (
  `id` int(11) NOT NULL,
  `user_id` varchar(100) DEFAULT NULL,
  `prof_review` varchar(100) DEFAULT NULL,
  `name_of_university` varchar(50) DEFAULT NULL,
  `city_of_university` varchar(50) DEFAULT NULL,
  `applicantCountryOfUniversity` varchar(50) DEFAULT NULL,
  `university_start_date` date DEFAULT NULL,
  `university_end_date` date DEFAULT NULL,
  `main_course_of_study` varchar(50) DEFAULT NULL,
  `universityFilesPath` varchar(1000) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `transxn_com_vac_app_university_qualifications`
--

INSERT INTO `transxn_com_vac_app_university_qualifications` (`id`, `user_id`, `prof_review`, `name_of_university`, `city_of_university`, `applicantCountryOfUniversity`, `university_start_date`, `university_end_date`, `main_course_of_study`, `universityFilesPath`, `updated_at`, `created_at`) VALUES
(21, 'daisymondchiboora@gmail.com', 'daisymondchiboora@gmail.com', 'Zhejiang University of Technology', 'Hangzhou', 'China', '2015-09-15', '2019-06-26', 'Software Engineering', '[{\"name\":\"SCB_eStatement3251982_67k870tx.pdf\",\"usrName\":\"SCB_eStatement3251982.pdf\",\"size\":165342,\"type\":\"application\\/pdf\",\"searchStr\":\"SCB_eStatement3251982.pdf,!:sStrEnd\"}]', NULL, NULL),
(22, 'fbesa@comesa.int', 'daisymondchiboora@gmail.com', 'zjut', 'zj', 'uk', '2021-02-25', '2021-02-25', 'software', '[{\"name\":\"Memo OUTSOURCE 275- TRADE docs COVID19_xmeqtqo3.doc\",\"usrName\":\"Memo OUTSOURCE 275- TRADE docs COVID19.doc\",\"size\":474112,\"type\":\"application\\/msword\",\"searchStr\":\"Memo OUTSOURCE 275- TRADE docs COVID19.doc,!:sStrEnd\"}]', NULL, NULL),
(23, 'sndlovu@comesa.int', 'daisymondchiboora@gmail.com', 'University of Oxford', 'Oxford', 'UK', '2021-03-01', '2021-04-08', 'Accounting', '[{\"name\":\"Tasheni Muluwe Information_wlt082ld.docx\",\"usrName\":\"Tasheni Muluwe Information.docx\",\"size\":15048,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"Tasheni Muluwe Information.docx,!:sStrEnd\"}]', NULL, NULL),
(24, 'munashechiboora@gmail.com', 'daisymondchiboora@gmail.com', 'University of Zambia', 'Lusaka', 'Zambia', '2021-02-28', '2021-03-01', 'Project Management', '[{\"name\":\"Pro_C5200_Series_xitv35hd.pdf\",\"usrName\":\"Pro_C5200_Series.pdf\",\"size\":3287894,\"type\":\"application\\/pdf\",\"searchStr\":\"Pro_C5200_Series.pdf,!:sStrEnd\"}]', NULL, NULL),
(25, 'chongoB@gmail.com', 'Guest', 'University of Texas', 'Texas', 'USA', '2021-02-28', '2021-03-02', 'Finance', '[{\"name\":\"Pro_C5200_Series_9y7sxiak.pdf\",\"usrName\":\"Pro_C5200_Series.pdf\",\"size\":3287894,\"type\":\"application\\/pdf\",\"searchStr\":\"Pro_C5200_Series.pdf,!:sStrEnd\"}]', NULL, NULL),
(26, 'oliver@gmail.com', 'Guest', 'Otawa University of Energy', 'Otawa', 'Canada', '2021-02-28', '2021-04-07', 'Renewable Energy Resources', '[{\"name\":\"Pro_C5200_Series_spr6l2xq.pdf\",\"usrName\":\"Pro_C5200_Series.pdf\",\"size\":3287894,\"type\":\"application\\/pdf\",\"searchStr\":\"Pro_C5200_Series.pdf,!:sStrEnd\"}]', NULL, NULL);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `ref_com_secretariat`
--
ALTER TABLE `ref_com_secretariat`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `ref_com_secretariat_divisions`
--
ALTER TABLE `ref_com_secretariat_divisions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `ref_com_secretariat_grades`
--
ALTER TABLE `ref_com_secretariat_grades`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `ref_com_secretariat_units`
--
ALTER TABLE `ref_com_secretariat_units`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `ref_jobapplicant_status`
--
ALTER TABLE `ref_jobapplicant_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `transxn_com_vacancy_adverts`
--
ALTER TABLE `transxn_com_vacancy_adverts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `transxn_com_vac_app_computer_literacy`
--
ALTER TABLE `transxn_com_vac_app_computer_literacy`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `transxn_com_vac_app_dependent_children`
--
ALTER TABLE `transxn_com_vac_app_dependent_children`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `transxn_com_vac_app_employment_profile`
--
ALTER TABLE `transxn_com_vac_app_employment_profile`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `transxn_com_vac_app_general_info`
--
ALTER TABLE `transxn_com_vac_app_general_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `transxn_com_vac_app_job_character_questions`
--
ALTER TABLE `transxn_com_vac_app_job_character_questions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `transxn_com_vac_app_other_languages`
--
ALTER TABLE `transxn_com_vac_app_other_languages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `transxn_com_vac_app_other_qualifications`
--
ALTER TABLE `transxn_com_vac_app_other_qualifications`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `transxn_com_vac_app_referees`
--
ALTER TABLE `transxn_com_vac_app_referees`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `transxn_com_vac_app_scholary_publications`
--
ALTER TABLE `transxn_com_vac_app_scholary_publications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `transxn_com_vac_app_university_qualifications`
--
ALTER TABLE `transxn_com_vac_app_university_qualifications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;
COMMIT;

