CREATE TABLE filelists( function VARCHAR(33) NOT NULL PRIMARY KEY ,activity VARCHAR(33) NOT NULL ,transaction VARCHAR(61) ,reference VARCHAR(15) ,created_at DATETIME ,updated_at DATETIME ); INSERT INTO filelists(`function`,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','ACCOMMODATION /OFFICE','ADA.01/10/01/01',NOW(),NOW()); INSERT INTO filelists(`function`,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','ACCOMMODATION /STAFF','ADA.01/10/01/02',NULL,NULL); INSERT INTO filelists(`function`,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','ANGLOGOLD ASHANTI','ADA.01/10/02',NULL,NULL); INSERT INTO filelists(`function`,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','ANNUAL NEW YEAR SCHOOL','ADA.01/10/03',NULL,NULL); INSERT INTO filelists(`function`,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','QUARTERLY /ANNUAL ADMINISTRATIVE REPORT','ADA.01/10/04',NULL,NULL); INSERT INTO filelists(`function`,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','TRADITIONAL COUNCIL/ CHIEFTAINCY','ADA.01/10/05',NULL,NULL); INSERT INTO filelists(`function`,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','ANNUAL PERFORMANCE REPORT','ADA.01/10/06',NULL,NULL); INSERT INTO filelists(`function`,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','BOARD OF SURVEY','ADA.01/10/07',NULL,NULL); INSERT INTO filelists(`function`,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','CIRCULAR (LOCAL GOV�T)','ADA.01/10/08/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','CIRCULAR (RCC)','ADA.01/10/08/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','CIRCULAR (ADA)','ADA.01/10/08/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','CLIENT SERVICE','ADA.01/10/09',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','COMPLAINS AND PETITION','ADA.01/10/10',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','CONFERENCE / WORKSHOP � FOREIGN','ADA.01/10/11/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','CONFERENCE / WORKSHOP LOCAL','ADA.01/10/11/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','QUERY','ADA.01/10/12',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','DEPT MONTHLY REPORT','ADA.01/10/13',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','ELECTORAL COMMISSION','ADA.01/10/14',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','GHANA AIDS COMMISSION','ADA.01/10/15',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','HANDING OVER NOTE','ADA.01/10/16',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','INFORMATION','ADA.01/10/17',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','INVITATION','ADA.01/10/18',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','INTRODUCTORY LETTER','ADA.01/10/19',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','NATIONAL CELEBRATIONS','ADA.01/10/20',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','LOCAL GOV�T SERVICE','ADA.01/10/21',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','MEMOS/INTERNAL CIRCULAR','ADA.01/10/22',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','MANAGEMENT MEETING','ADA.01/10/23',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','MINISTRY OF LOCAL GOV�T DECEN. AND RURAL DEVT','ADA.01/10/24',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','NOTICE / ANNOCEMENT','ADA.01/10/25',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','OFFICE OF THE HEAD OF THE LOCAL GOV�T SERVICE','ADA.01/10/26',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','PRESS RELEASE/FM','ADA.01/10/27',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','RADIO /WIRELESS MESSAGE','ADA.01/10/28',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','RIGHT TO INFORMATION','ADA.01/10/29',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','TOUR AND VISIT','ADA.01/10/30',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','REGIONAL CO- ORD COUNCIL','ADA.01/10/31',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','SPONSORSHIP','ADA.01/10/32',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','DCD PERFORMANCE CONTRACT','ADA.01/10/33',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','PERMISSION TO TRAVEL','ADA.01/10/34',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ADMINISTRATION','LETTER OF APPRECIATION','ADA.01/10/34',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','PLANNING','ANNUAL PROGRESS REPORT','ADA.01/20/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','PLANNING','DEPARTMENTAL ACTION PLAN','ADA.01/20/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','PLANNING','DEVELOPMENTAL PROJECT','ADA.01/20/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','PLANNING','DISTRICT PERFORMANCE ASSESMENT TOOL (DPAT)','ADA.01/20/04',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','PLANNING','LOCAL ECONOMICS DEV�T','ADA.01/20/05',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','PLANNING','MONITORING AND EVALUATION REPORT/PLAN','ADA.01/20/06',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','PLANNING','MEDIUM TERM DEVELOPMENT PLAN','ADA.01/20/07',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','PLANNING','DPCU','ADA.01/20/08',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','PROCUREMENT & STORES (30)','ASSETS REGISTER','ADA.01/30/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','PROCUREMENT & STORES (30)','AWARD OF CONTRACT','ADA.01/30/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','PROCUREMENT & STORES (30)','PROCUREMENT PLANNING','ADA.01/30/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','PROCUREMENT & STORES (30)','REQUEST FOR QUOTATION- GOODS','ADA.01/30/04/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','PROCUREMENT & STORES (30)','REQUEST FOR QUOTATION �WORKS','ADA.01/30/04/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','PROCUREMENT & STORES (30)','TENDER','ADA.01/30/05/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','PROCUREMENT & STORES (30)','TENDER COMMITTEE','ADA.01/30/05/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','PROCUREMENT & STORES (30)','UNSUCCESFUL TENDERY','ADA.01/30/06',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','RECORDS MGT','R M U','ADA.01/40/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','MIS','COMMUNICATION NETWORK','ADA.01/50/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','MIS','NIA','ADA.01/50/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ESTATE / TRANSPORT MGT. (60)','ALLOCATION OF STORES','ADA.01/60/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ESTATE / TRANSPORT MGT. (60)','TENANCY AGREEMENT','ADA.01/60/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','LOGISTICES & SECURITY MGT (70)','GHANA POLICE','ADA.01/70/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','LOGISTICES & SECURITY MGT (70)','GHANA NATIONAL FIRE SERVICE','ADA.01/70/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','LOGISTICES & SECURITY MGT (70)','DISEC','ADA.01/70/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','LOGISTICES & SECURITY MGT (70)','N.I.B/FRAUD OFFICE','ADA.01/70/04',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','LOGISTICES & SECURITY MGT (70)','PRISONS','ADA.01/70/05',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ASSEMBLY AFFAIRS','ASSEMBLY MATTERS','ADA.01/80/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ASSEMBLY AFFAIRS','SUMMONS TO GENERAL ASSEMBLY MEETING','ADA.01/80/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ASSEMBLY AFFAIRS','EXECUTIVE COMMITTEE','ADA.01/80/03/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ASSEMBLY AFFAIRS','PUBLIC RELATION & COMPLAINS','ADA.01/80/03/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ASSEMBLY AFFAIRS','JUST & SEC SUB-COMMITTEE','ADA.01/80/03/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ASSEMBLY AFFAIRS','DEV�T PLANNING SUB- COMMITTEE','ADA.01/80/03/04',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ASSEMBLY AFFAIRS','MINING AND ANTI GALAMSEY. SUB COMMITTEE','ADA.01/80/03/05',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ASSEMBLY AFFAIRS','FINANCE & ADMI SUB-COMMTY','ADA.01/80/03/06',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ASSEMBLY AFFAIRS','WORKS SUB-COMMITTEE','ADA.01/80/03/07',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ASSEMBLY AFFAIRS','SOCIAL SERVICE SUB-COMMTY','ADA.01/80/03/08',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ASSEMBLY AFFAIRS',NULL,'ADA.01/80/03/09',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('CENTRAL ADMINISTRATION','ASSEMBLY AFFAIRS','NALAG','ADA.01/80/04',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONEL MGT','APPLICATION FOR EMPLOYMENT','ADA.02/10/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONEL MGT','STAFF PERFORMANCE APPRAISAL','ADA.02/10/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONEL MGT','APPLICATION TO STUDY','ADA.02/10/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONEL MGT','HUMAN RESOUCE DEV�T','ADA.02/10/04',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONEL MGT','INDUSTRIAL ATTACHMENT','ADA.02/10/05',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONEL MGT','NATIONAL SERVICE','ADA.02/10/06',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONEL MGT','APPLICATION FOR LEAVE','ADA.02/10/07',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONEL MGT','STAFF POSTING / TRANSFER','ADA.02/10/08',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONEL MGT','STAFF PROMOTION /INTERVIEW UPGRADING','ADA.02/10/09',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONEL MGT','STAFF DURBAR/MEETING','ADA.02/10/10',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONEL MGT','HRMIS','ADA.02/10/11',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONNEL WELFARE','WORKES UNIONS','ADA.02/20/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONNEL WELFARE','OBITUARY','ADA.02/20/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONNEL WELFARE','PENSION/ RETAIRMENT/ SSNIT.','ADA.02/20/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONNEL WELFARE','STAFF LIST','ADA.02/20/04',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONNEL WELFARE','STAFF MATTERS','ADA.02/20/05',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONNEL WELFARE','SALARY AND WAGES , ALLOWANCES','ADA.02/20/06',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONNEL WELFARE','SSNIT','ADA.02/20/07',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','PERSONNEL WELFARE','QUERY','ADA.02/20/08',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','TRAINING AND DEVT','EXAMINATION & COURSES','ADA.02/30/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HUMAN RESOURCE MGT','TRAINING AND DEVT','STAFF TRAINING / SCHEME OF SERVICE LOCAL','ADA.02/30/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('FINANCIAL MANAGEMENT','TREASURE','ANNUAL ACCOUNT','ADA.03/10/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('FINANCIAL MANAGEMENT','TREASURE','BANK OF GHANA','ADA.03/10/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('FINANCIAL MANAGEMENT','TREASURE','CONTROLLER AND ACCOUNTANT GEN.','ADA.03/10/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('FINANCIAL MANAGEMENT','TREASURE','DISTRICT ASSEMBLY COMMON FUND (DACF)/IGF','ADA.03/10/04',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('FINANCIAL MANAGEMENT','TREASURE','FINANCIAL RETURN','ADA.03/10/05',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('FINANCIAL MANAGEMENT','TREASURE','MONTHLY TRIAL BALANCE','ADA.03/10/06',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('FINANCIAL MANAGEMENT','TREASURE','MINISTRY OF FINANCE','ADA.03/10/07',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('FINANCIAL MANAGEMENT','REVENUE MOBILIZATION (20)','STOOL LAND REVENUE','ADA.03/20/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('FINANCIAL MANAGEMENT','REVENUE MOBILIZATION','REVENUE MOBILIZATION (COLLECTION POINTS) /CEMETERY COLLECTORS','ADA.03/20/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('FINANCIAL MANAGEMENT','REVENUE MOBILIZATION','BONDING','ADA.03/20/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('FINANCIAL MANAGEMENT','REVENUE MOBILIZATION','BUSINESS OPERATING FEE','ADA.03/20/04',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('FINANCIAL MANAGEMENT','REVENUE MOBILIZATION','GRA','ADA.03/20/05',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('FINANCIAL MANAGEMENT','LEVIES','FEE FIXING RESOLUTION','ADA.03/30/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('BUDGET AND RATING','BUDGET MGT','BUDGETESTIMATES','ADA.04/10/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('BUDGET AND RATING','BUDGET MGT','ANNUAL BUDGET PLAN','ADA.04/10/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('BUDGET AND RATING','BUDGET MGT','BUDGET COMMITTEE','ADA.04/10/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('BUDGET AND RATING','BUDGET MGT','COMPOSITE BUDGET','ADA.04/10/04',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('BUDGET AND RATING','BUDGET MGT','PUBLIC FORA','ADA.04/10/05',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('BUDGET AND RATING','BUDGET MGT','REVENUE/BUDGET SENSITIZATION','ADA.04/10/06',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('AUDIT MGT','INTERNAL AUDIT','AUDIT COMMITTEE REPORT','ADA.05/10/01/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('AUDIT MGT','INTERNAL AUDIT','AUDIT PLAN / CHARTERS','ADA.05/10/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('AUDIT MGT','INTERNAL AUDIT','INTERNAL AUDIT AGENCY REPORT /IAA','ADA.05/10/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('AUDIT MGT','EXTERNAL AUDIT','EXTERNAL AUDIT REPORT','ADA.05/20/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('AUDIT MGT','EXTERNAL AUDIT','SPECIAL AUDIT','ADA.05/20/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('LEGAL ADVICE','LEGAL','ASSEMBLY BYE-LAWS','ADA.06/10/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('LEGAL ADVICE','LEGAL','CHRAJ','ADA.06/10/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('LEGAL ADVICE','LEGAL','JUDICIAL SERVICE','ADA.06/10/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('LEGAL ADVICE','PROLITIGATION MGT','PROCUTIONS /CLAIMS AGAINST THE ASSEMBLY','ADA.06/20/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('WORKS','BUILDING','DIMOLISHING OF UNAUTHORIZED STRUCTURES','ADA.07/10/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('WORKS','BUILDING','ELECTRICITY','ADA.07/10/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('WORKS','BUILDING','FINAL','ADA.07/10/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('WORKS','BUILDING','COMMISSING OF PROJECT','ADA.07/10/04',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('WORKS','BUILDING','OPERATION AND MAINTENANCE','ADA.07/10/05',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('WORKS','BUILDING','PWD','ADA.07/10/06',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('WORKS','BUILDING','PLANNING AND BUILDING INSPECTORATE','ADA.07/10/07',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('WORKS','BUILDING','RURAL ELECTRIFICATION','ADA.07/10/08',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('WORKS','BUILDING','COMMUNITY REQUEST','ADA.07/10/09',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('WORKS','BUILDING','SITE MEETING','ADA.07/10/10',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('WORKS','BUILDING','TEMPORAL STRUCTURE','ADA.07/10/11',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('WORKS','WATER','GHANA WATER','ADA.07/20/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('WORKS','WATER','WATER RESOURCE COMMISSION','ADA.07/20/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('PHYSICAL PLANNING','T&CP','APPLICATION FOR LANDS','ADA.08/10/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('PHYSICAL PLANNING','T&CP','BUILDING PERMIT','ADA.08/10/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('PHYSICAL PLANNING','T&CP','CHANGE OF USE','ADA.08/10/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('PHYSICAL PLANNING','T&CP','LAND VALUATION','ADA.08/10/04',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('PHYSICAL PLANNING','T&CP','LANDS COMMISSION','ADA.08/10/05',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('PHYSICAL PLANNING','T&CP','PHYSICAL PLANNING','ADA.08/10/06',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('PHYSICAL PLANNING','T&CP','REGISTRAR OF ASSEMBLY LANDS','ADA.08/10/07',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('PHYSICAL PLANNING','T&CP','SPATIAL PLANNING COMMITTEE','ADA.08/10/08',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('PHYSICAL PLANNING','T&CP','STREET/HOUSING NAMING','ADA.08/10/09',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('PHYSICAL PLANNING','T&CP','TECHNICAL SUB-COMMITTEE','ADA.08/10/10',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('PHYSICAL PLANNING','T&CP','TECHNICAL SITE INSPECTION','ADA.08/10/11',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('PHYSICAL PLANNING','T&CP','CHANGE OF ONWERSHIP','ADA.08/10/12',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HOUSING','HOUSING',NULL,NULL,NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('ROADS','ROAD MAINTENANACE (10)','MAINTENANCE OF ROADS','ADA.10/10/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('ROADS','ROAD TRAFIC INFRASTRUCTURE (20)',NULL,NULL,NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('ROADS','ROAD TRAFIC INFRASTRUCTURE (20)','RAILWAY AUTHORITY','ADA.10/30/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('ROADS','ROAD TRAFIC INFRASTRUCTURE (20)','DEPARTMENT OF FEEDER ROADS','ADA.10/30/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('TRADE INDUSTRY TOURISM','CO-OPERATIONS','BRC,NBSSI, BAC','ADA.11/10/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('TRADE INDUSTRY TOURISM','CO-OPERATIONS','INTRODUCTION OF COMPANIES','ADA.11/10/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('TRADE INDUSTRY TOURISM','CO-OPERATIONS','MINISTRY OF TRADE AND INDUSTRY','ADA.11/10/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('TRADE INDUSTRY TOURISM','CO-OPERATIONS','ONE DISTRICT ON FACTORY','ADA.11/10/04',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('TRADE INDUSTRY TOURISM','CO-OPERATIONS','DEPT. OF CO-OPERATIVE','ADA.11/10/05',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('TRADE INDUSTRY TOURISM','TOURISM','TOURISM','ADA.11/30/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('TRANSPORT','TRANSORT PLANNING (10)','TRANSPORT','ADA.12/10/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('TRANSPORT','TRANSPORT OPERATIONS (20)','ASSOCIATION OF TRANSPORT UNION','ADA.12/20/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('TRANSPORT','TRAFIC MGT. & SAFETY (30)',NULL,NULL,NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('TRANSPORT','WOMEN AND YOUTH IN AGRIC (10)',NULL,'ADA.13/10/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('TRANSPORT','ANIMAL HEALTH & PRODUCTION',NULL,NULL,NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('TRANSPORT','CROP SERVICES','MOFA','ADA.13/30/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('TRANSPORT','AGRIC EXTENSION',NULL,NULL,NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('TRANSPORT','AGRIC ENGINEERING',NULL,NULL,NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('STATISTICS','FIELD OPERATIONS','STATISTICAL SURVEY PREPARATION','ADA.14/10/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('STATISTICS','DATA ENTRY ANALYSIS',NULL,NULL,NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('STATISTICS','REPORTS',NULL,NULL,NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('BIRTH AND DEATH','BIRTH REGISTRATION','BIRTH REGISTER','ADA.15/10/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('BIRTH AND DEATH','DEATH REGISTRATION (20)','DEATH REGITER','ADA.15/20/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('EDUCATION, YOUTH & SPORTS','EDUCATION','GHANA DUCATION SERVICES','ADA.16/10/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('EDUCATION, YOUTH & SPORTS','EDUCATION','G.E.S. (BASIC & J.H.S)','ADA.16/10/01/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('EDUCATION, YOUTH & SPORTS','EDUCATION','G.E.S. ( S.H.S. AND TERTIARY )','ADA.16/10/01/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('EDUCATION, YOUTH & SPORTS','EDUCATION','GHANA SCHOOL FEEDING PROGRAMME','ADA.16/10/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('EDUCATION, YOUTH & SPORTS','EDUCATION','NON-FORMAL EDUCATION','ADA.16/10/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('EDUCATION, YOUTH & SPORTS','EDUCATION','DISTRICT EDUCATION OVERSIGTH COMMITTEE','ADA.16/10/04',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('EDUCATION, YOUTH & SPORTS','EDUCATION','NATIONAL COMMISSION CULTURE','ADA.16/10/05',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('EDUCATION, YOUTH & SPORTS','EDUCATION','GHANA EDU. TRUST FUND (GETFUND)','ADA.16/10/06',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('EDUCATION, YOUTH & SPORTS','YOUTH','NATIONAL YOUTH AUTHORITY','ADA.16/20/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('EDUCATION, YOUTH & SPORTS','YOUTH','NATIONAL YOUTH EMPOLYMENT PROGRAMMEE','ADA.16/20/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('EDUCATION, YOUTH & SPORTS','SPORTS','NATIONAL SPORTS COUNCIL','ADA.16/20/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('EDUCATION, YOUTH & SPORTS','LIBRARY',NULL,NULL,NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('SOCIAL WELFARE AND COMMUNITY DEVT','SOCIAL WELFARE','DISABLE/ PHYSICALLY CHALLENGE','ADA.17/10/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('SOCIAL WELFARE AND COMMUNITY DEVT','SOCIAL WELFARE','DEPARTMENT OF SOCIAL WEFARE','ADA.17/10/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('SOCIAL WELFARE AND COMMUNITY DEVT','SOCIAL WELFARE','DAY CARE CENTERS','ADA.17/10/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('SOCIAL WELFARE AND COMMUNITY DEVT','SOCIAL WELFARE','GENDER MAINSTREM','ADA.17/10/04',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('SOCIAL WELFARE AND COMMUNITY DEVT','COMMUNITY DEVELOPMENT (20)','GHANA GAZETTE','ADA.17/20/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('SOCIAL WELFARE AND COMMUNITY DEVT','COMMUNITY DEVELOPMENT (20)','NON GOVERNMENTAL ORGANIZATION','ADA.17/20/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('SOCIAL WELFARE AND COMMUNITY DEVT','COMMUNITY DEVELOPMENT (20)','REGISTERATION OF MARRIAGES','ADA.17/20/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('SOCIAL WELFARE AND COMMUNITY DEVT','COMMUNITY DEVELOPMENT (20)','RELIGIOUS ORGANIZATION','ADA.17/20/04',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('SOCIAL WELFARE AND COMMUNITY DEVT','COMMUNITY DEVELOPMENT (20)','ASSOCIATIONS','ADA.17/20/05',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('SOCIAL WELFARE AND COMMUNITY DEVT','COMMUNITY DEVELOPMENT (20)','POOR AND VULNERABLES','ADA.17/20/06',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HEALTH ADMINISTRATION','DMOH','MINISTRY OF HEALTH/GHANA HEALTH SERVICE','ADA.18/10/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HEALTH ADMINISTRATION','DMOH','DISTRICT HEALTH COMMITTEE','ADA.18/10/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HEALTH ADMINISTRATION','DMOH','NATIONAL HEALTH INSURANCE UNIT','ADA.18/10/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HEALTH ADMINISTRATION','DMOH','HEALTH PROJECT','ADA.18/10/04',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HEALTH ADMINISTRATION','ENVIRONMENTAL HEALTH','APPLICATION FOR LICENSING BAR AND RESTURANT','ADA.18/20/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HEALTH ADMINISTRATION','ENVIRONMENTAL HEALTH','ENVIRONMENTAL HEALTH','ADA.18/20/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HEALTH ADMINISTRATION','ENVIRONMENTAL HEALTH','NUISANCE (NOICE)','ADA.18/20/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('HEALTH ADMINISTRATION','ENVIRONMENTAL HEALTH','(DISINFECTION AND DISINFECTION )','ADA.18/20/04',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('DISASTER PREVENTION','INTERNAL DISASTER','NADMO','ADA.19/10/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('DISASTER PREVENTION','REFUGEE MGT','.',NULL,NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('WASTE MANAGEMENT','OPERATIONAL','DISTRICT WATER AND SANITATION','ADA.20/10/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('WASTE MANAGEMENT','OPERATIONAL','WASTE MANAGEMENT','ADA.20/10/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('WASTE MANAGEMENT','SUPPORT SERVICES','ZOOMLION GHANA LIMITED','ADA.20/20/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('NATURAL RESOURCES CONSRVATION','FORESTRY','FORESTRY DIVIISSION','ADA.21/10/01',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('NATURAL RESOURCES CONSRVATION','FORESTRY','MINISTRY OF LANDS AND NATURAL RESOURCES','ADA.21/10/02',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('NATURAL RESOURCES CONSRVATION','FORESTRY','MINERAL DEVELOPMENT FUND','ADA.21/10/03',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('NATURAL RESOURCES CONSRVATION','FORESTRY','MINISTRY OF MINES AND ENERGY','ADA.21/10/04',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('NATURAL RESOURCES CONSRVATION','FORESTRY','MINISTRY OF ENVIRONMENTAL SCIENCE AND TECHNOLOGY','ADA.21/10/05',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('NATURAL RESOURCES CONSRVATION','FORESTRY','COMMUNITY MINING PROGRAMME','ADA.21/10/06',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('NATURAL RESOURCES CONSRVATION','FORESTRY','MINERAL COMMISSION','ADA.21/10/07',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('NATURAL RESOURCES CONSRVATION','FORESTRY','NATIONAL PETROLEUM AUTHORITY','ADA.21/10/08',NULL,NULL); INSERT INTO filelists(function,activity,transaction,reference,created_at,updated_at) VALUES ('NATURAL RESOURCES CONSRVATION','GAMES & WILDLIFE',NULL,NULL,NULL,NULL);