BC_Timesheet_MasterData.sql

INSERT INTO ministry("ministryName") VALUES ('Education');
INSERT INTO ministry("ministryName") VALUES ('Energy, Mines & Petroleum Resources');
INSERT INTO ministry("ministryName") VALUES ('Environment & Climate Change Strategy');
INSERT INTO ministry("ministryName") VALUES ('Finance');
INSERT INTO ministry("ministryName") VALUES ('Forests, Lands, Natural Resource Operations & Rural Development');
INSERT INTO ministry("ministryName") VALUES ('Health');
INSERT INTO ministry("ministryName") VALUES ('Indigenous Relations & Reconciliation');
INSERT INTO ministry("ministryName") VALUES ('Jobs, Trade & Technology');
INSERT INTO ministry("ministryName") VALUES ('Labour');
INSERT INTO ministry("ministryName") VALUES ('Mental Health & Addictions');
INSERT INTO ministry("ministryName") VALUES ('Municipal Affairs & Housing');
INSERT INTO ministry("ministryName") VALUES ('Public Safety & Solicitor General & Emergency B.C.');
INSERT INTO ministry("ministryName") VALUES ('Social Development & Poverty Reduction');
INSERT INTO ministry("ministryName") VALUES ('Tourism, Arts & Culture');
INSERT INTO ministry("ministryName") VALUES ('Transportation & Infrastructure');

-- Imported from UNSPSC https://www.ungm.org/Public/UNSPSC
INSERT INTO project_sector("projectSectorName") VALUES ('Raw Materials, Chemicals, Paper, Fuel');
INSERT INTO project_sector("projectSectorName") VALUES ('Industrial Equipment & Tools');
INSERT INTO project_sector("projectSectorName") VALUES ('Components & Supplies');
INSERT INTO project_sector("projectSectorName") VALUES ('Construction, Transportation & Facility Equipment & Supplies');
INSERT INTO project_sector("projectSectorName") VALUES ('Medical, Laboratory & Test Equipment & Supplies & Pharmaceuticals');
INSERT INTO project_sector("projectSectorName") VALUES ('Food, Cleaning & Service Industry Equipment & Supplies');
INSERT INTO project_sector("projectSectorName") VALUES ('Business, Communication & Technology Equipment & Supplies');
INSERT INTO project_sector("projectSectorName") VALUES ('Defense, Security & Safety Equipment & Supplies');
INSERT INTO project_sector("projectSectorName") VALUES ('Personal, Domestic & Consumer Equipment & Supplies');
INSERT INTO project_sector("projectSectorName") VALUES ('Services');
INSERT INTO project_sector("projectSectorName") VALUES ('Other');

-- New RFX_Types
-- INSERT INTO rfx_type("rfxTypeName") VALUES ('ITQ (Invitation to Quote)');
-- INSERT INTO rfx_type("rfxTypeName") VALUES ('ITT (Invitation to Tender');
-- INSERT INTO rfx_type("rfxTypeName") VALUES ('JSRFP (Joint Solution Request for Proposals)');
-- INSERT INTO rfx_type("rfxTypeName") VALUES ('NRFP (Negotiated Request for Proposals)');
-- INSERT INTO rfx_type("rfxTypeName") VALUES ('NOI (Notice of Intent)');
-- INSERT INTO rfx_type("rfxTypeName") VALUES ('RFQ (Request for Qualifications)');
-- INSERT INTO rfx_type("rfxTypeName") VALUES ('RFEI (Request for Expression of Interest)');
-- INSERT INTO rfx_type("rfxTypeName") VALUES ('RFI (Request for Information)');
-- INSERT INTO rfx_type("rfxTypeName") VALUES ('RFP (Request for Proposals)');
-- INSERT INTO rfx_type("rfxTypeName") VALUES ('RSO (Request for Standing Offer)');
-- INSERT INTO rfx_type("rfxTypeName") VALUES ('SRFP (Short-form Request for Proposal)');
-- INSERT INTO rfx_type("rfxTypeName") VALUES ('SA (Standing Agreement)');
-- INSERT INTO rfx_type("rfxTypeName") VALUES ('SOW (Statement of Work)');
-- INSERT INTO rfx_type("rfxTypeName") VALUES ('Pre-Qualification List');
-- INSERT INTO rfx_type("rfxTypeName") VALUES ('Direct Award');
-- INSERT INTO rfx_type("rfxTypeName") VALUES ('RCSA (Request for Corporate Supply Arrangement)');

INSERT INTO rfx_type("rfxTypeName") VALUES ('BVNP (Best Value Negotiated Process)');
INSERT INTO rfx_type("rfxTypeName") VALUES ('Call to Market Against Pre-Qualification Lists - Services');
INSERT INTO rfx_type("rfxTypeName") VALUES ('CFP (Call for Proposals)');
INSERT INTO rfx_type("rfxTypeName") VALUES ('F NRFP (Feedback NRFP)');
INSERT INTO rfx_type("rfxTypeName") VALUES ('ITQ (Invitation to quote)');
INSERT INTO rfx_type("rfxTypeName") VALUES ('ITQS (Invitation to quote for Services)');
INSERT INTO rfx_type("rfxTypeName") VALUES ('ITT (Invitation to Tender)');
INSERT INTO rfx_type("rfxTypeName") VALUES ('JSNRFP (Joint Solution NRFP)');
INSERT INTO rfx_type("rfxTypeName") VALUES ('NOI (Notice of Intent)');
INSERT INTO rfx_type("rfxTypeName") VALUES ('RCSA (Request for Corporate Supply Arrangement)');
INSERT INTO rfx_type("rfxTypeName") VALUES ('RFEI (Request for Expression of Interest)');
INSERT INTO rfx_type("rfxTypeName") VALUES ('RFI (Request for Information)');
INSERT INTO rfx_type("rfxTypeName") VALUES ('RFP (Request for Proposals)');
INSERT INTO rfx_type("rfxTypeName") VALUES ('RFQ (Request for Qualifications)');
INSERT INTO rfx_type("rfxTypeName") VALUES ('RMSA (Request for Master Services Agreement)');
INSERT INTO rfx_type("rfxTypeName") VALUES ('RNRFP (Refinement NRFP)');
INSERT INTO rfx_type("rfxTypeName") VALUES ('RRNRFP (Rank and Run NRFP)');
INSERT INTO rfx_type("rfxTypeName") VALUES ('RSO (Request for Standing Offer)');
INSERT INTO rfx_type("rfxTypeName") VALUES ('SRFP (Short Form Request for Proposals)');

--Making edits to the existing project phases
---INSERT INTO rfx_phase("rfxPhaseName") VALUES ('On-boarding');
INSERT INTO rfx_phase("rfxPhaseName") VALUES ('Planning');
INSERT INTO rfx_phase("rfxPhaseName") VALUES ('Drafting');
INSERT INTO rfx_phase("rfxPhaseName") VALUES ('Posted');
INSERT INTO rfx_phase("rfxPhaseName") VALUES ('Evaluation');
INSERT INTO rfx_phase("rfxPhaseName") VALUES ('Award');
INSERT INTO rfx_phase("rfxPhaseName") VALUES ('Closed Out');
INSERT INTO rfx_phase("rfxPhaseName") VALUES ('Suspended');
INSERT INTO rfx_phase("rfxPhaseName") VALUES ('Cancelled');
INSERT INTO rfx_phase("rfxPhaseName") VALUES ('Completed');