USE ichq_mysel;
INSERT INTO departments (name, owner_name) VALUES ('Executive Office', NULL);
INSERT INTO departments (name, owner_name) VALUES ('Finance', NULL);
INSERT INTO departments (name, owner_name) VALUES ('Human Resources', 'Nicole');
INSERT INTO departments (name, owner_name) VALUES ('Technology', 'Frank');
INSERT INTO departments (name, owner_name) VALUES ('Operations / Membership Services', 'Gwendolyn / Karya');
INSERT INTO departments (name, owner_name) VALUES ('Conventions', 'Amy');
INSERT INTO departments (name, owner_name) VALUES ('Project Management', 'Juneann');
INSERT INTO departments (name, owner_name) VALUES ('Marketing & Communications', NULL);
INSERT INTO fiscal_years (fy_year, label, start_date, end_date, is_active) VALUES (2022, 'FY22', '2021-07-01', '2022-06-30', 0);
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 1, 'July', '2021-07-01', '2021-07-31', 'Q1' FROM fiscal_years WHERE fy_year = 2022;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 2, 'August', '2021-08-01', '2021-08-31', 'Q1' FROM fiscal_years WHERE fy_year = 2022;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 3, 'September', '2021-09-01', '2021-09-30', 'Q1' FROM fiscal_years WHERE fy_year = 2022;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 4, 'October', '2021-10-01', '2021-10-31', 'Q2' FROM fiscal_years WHERE fy_year = 2022;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 5, 'November', '2021-11-01', '2021-11-30', 'Q2' FROM fiscal_years WHERE fy_year = 2022;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 6, 'December', '2021-12-01', '2021-12-31', 'Q2' FROM fiscal_years WHERE fy_year = 2022;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 7, 'January', '2022-01-01', '2022-01-31', 'Q3' FROM fiscal_years WHERE fy_year = 2022;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 8, 'February', '2022-02-01', '2022-02-28', 'Q3' FROM fiscal_years WHERE fy_year = 2022;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 9, 'March', '2022-03-01', '2022-03-31', 'Q3' FROM fiscal_years WHERE fy_year = 2022;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 10, 'April', '2022-04-01', '2022-04-30', 'Q4' FROM fiscal_years WHERE fy_year = 2022;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 11, 'May', '2022-05-01', '2022-05-31', 'Q4' FROM fiscal_years WHERE fy_year = 2022;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 12, 'June', '2022-06-01', '2022-06-30', 'Q4' FROM fiscal_years WHERE fy_year = 2022;
INSERT INTO fiscal_years (fy_year, label, start_date, end_date, is_active) VALUES (2023, 'FY23', '2022-07-01', '2023-06-30', 0);
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 1, 'July', '2022-07-01', '2022-07-31', 'Q1' FROM fiscal_years WHERE fy_year = 2023;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 2, 'August', '2022-08-01', '2022-08-31', 'Q1' FROM fiscal_years WHERE fy_year = 2023;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 3, 'September', '2022-09-01', '2022-09-30', 'Q1' FROM fiscal_years WHERE fy_year = 2023;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 4, 'October', '2022-10-01', '2022-10-31', 'Q2' FROM fiscal_years WHERE fy_year = 2023;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 5, 'November', '2022-11-01', '2022-11-30', 'Q2' FROM fiscal_years WHERE fy_year = 2023;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 6, 'December', '2022-12-01', '2022-12-31', 'Q2' FROM fiscal_years WHERE fy_year = 2023;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 7, 'January', '2023-01-01', '2023-01-31', 'Q3' FROM fiscal_years WHERE fy_year = 2023;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 8, 'February', '2023-02-01', '2023-02-28', 'Q3' FROM fiscal_years WHERE fy_year = 2023;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 9, 'March', '2023-03-01', '2023-03-31', 'Q3' FROM fiscal_years WHERE fy_year = 2023;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 10, 'April', '2023-04-01', '2023-04-30', 'Q4' FROM fiscal_years WHERE fy_year = 2023;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 11, 'May', '2023-05-01', '2023-05-31', 'Q4' FROM fiscal_years WHERE fy_year = 2023;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 12, 'June', '2023-06-01', '2023-06-30', 'Q4' FROM fiscal_years WHERE fy_year = 2023;
INSERT INTO fiscal_years (fy_year, label, start_date, end_date, is_active) VALUES (2024, 'FY24', '2023-07-01', '2024-06-30', 0);
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 1, 'July', '2023-07-01', '2023-07-31', 'Q1' FROM fiscal_years WHERE fy_year = 2024;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 2, 'August', '2023-08-01', '2023-08-31', 'Q1' FROM fiscal_years WHERE fy_year = 2024;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 3, 'September', '2023-09-01', '2023-09-30', 'Q1' FROM fiscal_years WHERE fy_year = 2024;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 4, 'October', '2023-10-01', '2023-10-31', 'Q2' FROM fiscal_years WHERE fy_year = 2024;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 5, 'November', '2023-11-01', '2023-11-30', 'Q2' FROM fiscal_years WHERE fy_year = 2024;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 6, 'December', '2023-12-01', '2023-12-31', 'Q2' FROM fiscal_years WHERE fy_year = 2024;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 7, 'January', '2024-01-01', '2024-01-31', 'Q3' FROM fiscal_years WHERE fy_year = 2024;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 8, 'February', '2024-02-01', '2024-02-29', 'Q3' FROM fiscal_years WHERE fy_year = 2024;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 9, 'March', '2024-03-01', '2024-03-31', 'Q3' FROM fiscal_years WHERE fy_year = 2024;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 10, 'April', '2024-04-01', '2024-04-30', 'Q4' FROM fiscal_years WHERE fy_year = 2024;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 11, 'May', '2024-05-01', '2024-05-31', 'Q4' FROM fiscal_years WHERE fy_year = 2024;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 12, 'June', '2024-06-01', '2024-06-30', 'Q4' FROM fiscal_years WHERE fy_year = 2024;
INSERT INTO fiscal_years (fy_year, label, start_date, end_date, is_active) VALUES (2025, 'FY25', '2024-07-01', '2025-06-30', 0);
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 1, 'July', '2024-07-01', '2024-07-31', 'Q1' FROM fiscal_years WHERE fy_year = 2025;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 2, 'August', '2024-08-01', '2024-08-31', 'Q1' FROM fiscal_years WHERE fy_year = 2025;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 3, 'September', '2024-09-01', '2024-09-30', 'Q1' FROM fiscal_years WHERE fy_year = 2025;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 4, 'October', '2024-10-01', '2024-10-31', 'Q2' FROM fiscal_years WHERE fy_year = 2025;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 5, 'November', '2024-11-01', '2024-11-30', 'Q2' FROM fiscal_years WHERE fy_year = 2025;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 6, 'December', '2024-12-01', '2024-12-31', 'Q2' FROM fiscal_years WHERE fy_year = 2025;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 7, 'January', '2025-01-01', '2025-01-31', 'Q3' FROM fiscal_years WHERE fy_year = 2025;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 8, 'February', '2025-02-01', '2025-02-28', 'Q3' FROM fiscal_years WHERE fy_year = 2025;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 9, 'March', '2025-03-01', '2025-03-31', 'Q3' FROM fiscal_years WHERE fy_year = 2025;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 10, 'April', '2025-04-01', '2025-04-30', 'Q4' FROM fiscal_years WHERE fy_year = 2025;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 11, 'May', '2025-05-01', '2025-05-31', 'Q4' FROM fiscal_years WHERE fy_year = 2025;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 12, 'June', '2025-06-01', '2025-06-30', 'Q4' FROM fiscal_years WHERE fy_year = 2025;
INSERT INTO fiscal_years (fy_year, label, start_date, end_date, is_active) VALUES (2026, 'FY26', '2025-07-01', '2026-06-30', 1);
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 1, 'July', '2025-07-01', '2025-07-31', 'Q1' FROM fiscal_years WHERE fy_year = 2026;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 2, 'August', '2025-08-01', '2025-08-31', 'Q1' FROM fiscal_years WHERE fy_year = 2026;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 3, 'September', '2025-09-01', '2025-09-30', 'Q1' FROM fiscal_years WHERE fy_year = 2026;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 4, 'October', '2025-10-01', '2025-10-31', 'Q2' FROM fiscal_years WHERE fy_year = 2026;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 5, 'November', '2025-11-01', '2025-11-30', 'Q2' FROM fiscal_years WHERE fy_year = 2026;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 6, 'December', '2025-12-01', '2025-12-31', 'Q2' FROM fiscal_years WHERE fy_year = 2026;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 7, 'January', '2026-01-01', '2026-01-31', 'Q3' FROM fiscal_years WHERE fy_year = 2026;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 8, 'February', '2026-02-01', '2026-02-28', 'Q3' FROM fiscal_years WHERE fy_year = 2026;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 9, 'March', '2026-03-01', '2026-03-31', 'Q3' FROM fiscal_years WHERE fy_year = 2026;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 10, 'April', '2026-04-01', '2026-04-30', 'Q4' FROM fiscal_years WHERE fy_year = 2026;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 11, 'May', '2026-05-01', '2026-05-31', 'Q4' FROM fiscal_years WHERE fy_year = 2026;
INSERT INTO months (fiscal_year_id, month_number, month_name, month_start, month_end, quarter_label) SELECT id, 12, 'June', '2026-06-01', '2026-06-30', 'Q4' FROM fiscal_years WHERE fy_year = 2026;
INSERT INTO users (department_id, first_name, last_name, email, password_hash, job_title, role) SELECT id, 'Madam', 'ED', 'madamed@ichq1922.org', '$2y$12$gEW5BjPkk2svUdoLaHDsQ.q3fG0dLUDNIR6KrI.ISwZCdac/.WG1S', 'Executive Director', 'executive' FROM departments WHERE name = 'Executive Office';
INSERT INTO users (department_id, first_name, last_name, email, password_hash, job_title, role) SELECT id, 'Joshua', 'Admin', 'admin@ichq1922.org', '$2y$12$gEW5BjPkk2svUdoLaHDsQ.q3fG0dLUDNIR6KrI.ISwZCdac/.WG1S', 'System Administrator', 'admin' FROM departments WHERE name = 'Technology';
INSERT INTO users (department_id, first_name, last_name, email, password_hash, job_title, role) SELECT id, 'Amy', 'Conventions', 'amy@ichq1922.org', '$2y$12$gEW5BjPkk2svUdoLaHDsQ.q3fG0dLUDNIR6KrI.ISwZCdac/.WG1S', 'Conventions Lead', 'manager' FROM departments WHERE name = 'Conventions';
INSERT INTO users (department_id, first_name, last_name, email, password_hash, job_title, role) SELECT id, 'Gwendolyn', 'Operations', 'gwendolyn@ichq1922.org', '$2y$12$gEW5BjPkk2svUdoLaHDsQ.q3fG0dLUDNIR6KrI.ISwZCdac/.WG1S', 'Operations Lead', 'manager' FROM departments WHERE name = 'Operations / Membership Services';
INSERT INTO users (department_id, first_name, last_name, email, password_hash, job_title, role) SELECT id, 'Karya', 'Membership', 'karya@ichq1922.org', '$2y$12$gEW5BjPkk2svUdoLaHDsQ.q3fG0dLUDNIR6KrI.ISwZCdac/.WG1S', 'Membership Services Manager', 'manager' FROM departments WHERE name = 'Operations / Membership Services';
INSERT INTO users (department_id, first_name, last_name, email, password_hash, job_title, role) SELECT id, 'Frank', 'Technology', 'frank@ichq1922.org', '$2y$12$gEW5BjPkk2svUdoLaHDsQ.q3fG0dLUDNIR6KrI.ISwZCdac/.WG1S', 'IT Manager', 'manager' FROM departments WHERE name = 'Technology';
INSERT INTO users (department_id, first_name, last_name, email, password_hash, job_title, role) SELECT id, 'Nicole', 'HR', 'nicole@ichq1922.org', '$2y$12$gEW5BjPkk2svUdoLaHDsQ.q3fG0dLUDNIR6KrI.ISwZCdac/.WG1S', 'HR Manager', 'manager' FROM departments WHERE name = 'Human Resources';
INSERT INTO scorecard_categories (name, sort_order) VALUES ('Associate Experience', 1);
INSERT INTO scorecard_categories (name, sort_order) VALUES ('Member Experience', 2);
INSERT INTO scorecard_categories (name, sort_order) VALUES ('Operational Improvements', 3);
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Improve Associate Engagement Score', '#5 Headquarters Operations', 'People', 'HR Business Partner', 1 FROM scorecard_categories WHERE name = 'Associate Experience';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 3.7 FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Improve Associate Engagement Score' AND sc.name = 'Associate Experience' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 4.3 FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Improve Associate Engagement Score' AND sc.name = 'Associate Experience' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 4.5 FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Improve Associate Engagement Score' AND sc.name = 'Associate Experience' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Improve Associate Net Promoter Score', '#5 Headquarters Operations', 'People', 'HR Business Partner', 2 FROM scorecard_categories WHERE name = 'Associate Experience';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'Net Promoter Score: 
- 57
Detractors (0-6) - 71%
Passives (7-8) - 14%
Promoters (9-10) - 14%' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Improve Associate Net Promoter Score' AND sc.name = 'Associate Experience' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'Net Promoter Score: 47
Detractors (0-6) - 6%
Passives (7-8) - 41%
Promoters (9-10) - 53%' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Improve Associate Net Promoter Score' AND sc.name = 'Associate Experience' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'Net Promoter Score: 54
Detractors (0-6) - 0%
Passives (7-8) -46%
Promoters (9-10) - 54%"' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Improve Associate Net Promoter Score' AND sc.name = 'Associate Experience' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Provide Associate Benefits', '#5 Headquarters Operations', 'People', 'HR Business Partner', 3 FROM scorecard_categories WHERE name = 'Associate Experience';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Provide Associate Benefits' AND sc.name = 'Associate Experience' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Provide Associate Benefits' AND sc.name = 'Associate Experience' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Provide Associate Benefits' AND sc.name = 'Associate Experience' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Continuously Improve Customer Care', '#1 Member Growth & Sustainability', 'People', 'Operations Director ', 4 FROM scorecard_categories WHERE name = 'Member Experience';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 20 FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Continuously Improve Customer Care' AND sc.name = 'Member Experience' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 41 FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Continuously Improve Customer Care' AND sc.name = 'Member Experience' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 24 FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Continuously Improve Customer Care' AND sc.name = 'Member Experience' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Continuously Improve Customer Care', '#1 Member Growth & Sustainability', 'People', 'Operations Director ', 5 FROM scorecard_categories WHERE name = 'Member Experience';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'Positive - 68% 
Neutral - 11%
Negative - 21%' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Continuously Improve Customer Care' AND sc.name = 'Member Experience' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'Positive - 76.0% 
Neutral - 8%
Negative - 16%' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Continuously Improve Customer Care' AND sc.name = 'Member Experience' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'Positive - 84.7%
Neutral - 6.6%
Negative - 8.7%' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Continuously Improve Customer Care' AND sc.name = 'Member Experience' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Continuously Improve Customer Care', '#1 Member Growth & Sustainability', 'Process', 'All Managers', 6 FROM scorecard_categories WHERE name = 'Member Experience';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'Resolution SLA - 47% (% of tickets resolved w/in 5 business days)' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Continuously Improve Customer Care' AND sc.name = 'Member Experience' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'Resolution SLA -65% (% of tickets resolved w/in 5 business days)' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Continuously Improve Customer Care' AND sc.name = 'Member Experience' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'Resolution SLA - 96.78%(% of tickets resolved w/in 5 business days)' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Continuously Improve Customer Care' AND sc.name = 'Member Experience' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Provide Member Benefit', '#3 Program Engagement and Participation', 'People', 'Executive Director ', 7 FROM scorecard_categories WHERE name = 'Member Experience';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Provide Member Benefit' AND sc.name = 'Member Experience' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Provide Member Benefit' AND sc.name = 'Member Experience' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Provide Member Benefit' AND sc.name = 'Member Experience' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Membership Engagment', '#3 Program Engagement and Participation', 'People', 'Marketing and Communications Manager', 8 FROM scorecard_categories WHERE name = 'Member Experience';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Membership Engagment' AND sc.name = 'Member Experience' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Membership Engagment' AND sc.name = 'Member Experience' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Membership Engagment' AND sc.name = 'Member Experience' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Improve Technology for Efficiency & Data Integrity', '#1 Member Growth & Sustainability', 'Process', 'IT Manager', 9 FROM scorecard_categories WHERE name = 'Operational Improvements';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Improve Technology for Efficiency & Data Integrity' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Improve Technology for Efficiency & Data Integrity' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Improve Technology for Efficiency & Data Integrity' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Improve Technology for Efficiency & Data Integrity', '#1 Member Growth & Sustainability', 'Process', 'IT Manager', 10 FROM scorecard_categories WHERE name = 'Operational Improvements';
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Improve Technology for Efficiency & Data Integrity', '#1 Member Growth & Sustainability', 'Process', 'IT Manager', 11 FROM scorecard_categories WHERE name = 'Operational Improvements';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Improve Technology for Efficiency & Data Integrity' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Improve Technology for Efficiency & Data Integrity' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Improve Technology for Efficiency & Data Integrity' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Identify Gaps in  Associate  experience and develop a Comprehensive Solution', '#5 Headquarters Operations', 'People', 'HR Business Partner', 12 FROM scorecard_categories WHERE name = 'Operational Improvements';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Identify Gaps in  Associate  experience and develop a Comprehensive Solution' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Identify Gaps in  Associate  experience and develop a Comprehensive Solution' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Identify Gaps in  Associate  experience and develop a Comprehensive Solution' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Identify Gaps in  Associate  experience and develop a Comprehensive Solution', '#5 Headquarters Operations', 'People', 'HR Business Partner', 13 FROM scorecard_categories WHERE name = 'Operational Improvements';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Identify Gaps in  Associate  experience and develop a Comprehensive Solution' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Identify Gaps in  Associate  experience and develop a Comprehensive Solution' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Identify Gaps in  Associate  experience and develop a Comprehensive Solution' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Diversify Income Streams', '#5 Headquarters Operations', 'Professionalism ', 'Project Manager/Marketing and Communications Manager ', 14 FROM scorecard_categories WHERE name = 'Operational Improvements';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Diversify Income Streams' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Diversify Income Streams' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Diversify Income Streams' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Diversify Income Streams', '#5 Headquarters Operations', 'Professionalism ', 'Project Manager', 15 FROM scorecard_categories WHERE name = 'Operational Improvements';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Diversify Income Streams' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Diversify Income Streams' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Diversify Income Streams' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Diversify Income Streams', '#5 Headquarters Operations', 'Professionalism ', 'Project Manager ', 16 FROM scorecard_categories WHERE name = 'Operational Improvements';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Diversify Income Streams' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Diversify Income Streams' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Diversify Income Streams' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Diversify Income Streams', '#3 Program Engagement and Participation', 'Professionalism ', 'Project Manager ', 17 FROM scorecard_categories WHERE name = 'Operational Improvements';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Diversify Income Streams' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Diversify Income Streams' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Diversify Income Streams' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'External Partnerships', '#4 External Engagement and Increased Partnerships', 'Professionalism ', 'Chief of Staff/ Executive Director', 18 FROM scorecard_categories WHERE name = 'Operational Improvements';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'External Partnerships' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'External Partnerships' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'External Partnerships' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Cost Savings', '#5 Headquarters Operations', 'Process', 'Executive Director ', 19 FROM scorecard_categories WHERE name = 'Operational Improvements';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Cost Savings' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Cost Savings' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Cost Savings' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO scorecard_items (category_id, objective_title, igb_pillar, ed_pillar, owner_name, sort_order) SELECT id, 'Continuously Improve and Lean Process', '#5 Headquarters Operations', 'Process', 'Operations Director', 20 FROM scorecard_categories WHERE name = 'Operational Improvements';
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Continuously Improve and Lean Process' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Continuously Improve and Lean Process' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO scorecard_item_results (scorecard_item_id, fiscal_year_id, result_value) SELECT si.id, fy.id, 'N/A' FROM scorecard_items si JOIN scorecard_categories sc ON sc.id = si.category_id JOIN fiscal_years fy WHERE si.objective_title = 'Continuously Improve and Lean Process' AND sc.name = 'Operational Improvements' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Associate Experience', 'Improve Associate Engagement Score', 'HR/ Project Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 3.7, 3.7 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Improve Associate Engagement Score' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 4.3, 4.3 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Improve Associate Engagement Score' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 4.5, 4.5 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Improve Associate Engagement Score' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 4.4, 4.4 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Improve Associate Engagement Score' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Associate Experience', 'Associate Net Promoter Score', 'HR/ Project Manager', 'text');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Net Promoter Score: - 57
Detractors (0-6) - 71%
Passives (7-8) - 14%
Promoters (9-10) - 14%', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Associate Net Promoter Score' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Net Promoter Score: 47
Detractors (0-6) - 6%
Passives (7-8) - 41%
Promoters (9-10) - 53%', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Associate Net Promoter Score' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Net Promoter Score: 54
Detractors (0-6) - 0%
Passives (7-8) -46%
Promoters (9-10) - 54%', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Associate Net Promoter Score' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Net Promoter Score: 84
Detractors (0-6) - 0%
Passives (7-8) - 3%
Promoters (9-10) - 84%', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Associate Net Promoter Score' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Net Promoter Score: 85
Detractors (0-6) -
Passives (7-8) - 
Promoters (9-10) - ', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Associate Net Promoter Score' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Associate Experience', 'Voluntary Turnover Rate - % Decrease', 'HR/ALL', 'percent');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0.211, 0.211 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Voluntary Turnover Rate - % Decrease' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0.173, 0.173 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Voluntary Turnover Rate - % Decrease' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0.3237, 0.3237 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Voluntary Turnover Rate - % Decrease' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0.225, 0.225 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Voluntary Turnover Rate - % Decrease' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Current: 8.9%', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Voluntary Turnover Rate - % Decrease' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Associate Experience', 'Staff Participation % in Medical Benefits Program', 'HR', 'percent');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Tracked', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Staff Participation % in Medical Benefits Program' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Tracked', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Staff Participation % in Medical Benefits Program' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0.8, 0.8 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Staff Participation % in Medical Benefits Program' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0.79, 0.79 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Staff Participation % in Medical Benefits Program' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Tracked', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Staff Participation % in Medical Benefits Program' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Associate Experience', 'Staff Participation % in other Benefits Programs', 'HR', 'percent');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Tracked', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Staff Participation % in other Benefits Programs' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Tracked', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Staff Participation % in other Benefits Programs' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Tracked', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Staff Participation % in other Benefits Programs' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, '
96% participation rate in the Dental Plan
96% participation rate in Vision Plan
79% participation in the Retirement Plan 
42% participation in Flexible Spending Accounts (FSA) 
42% participation in AFLAC Supplemental Insurance 
58% participation in Voluntary Life Insurance 
', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Staff Participation % in other Benefits Programs' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Tracked', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Staff Participation % in other Benefits Programs' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Associate Experience', 'Staff Participation % staff engaging with LinkedIn Learning', 'HR', 'percent');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Tracked', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Staff Participation % staff engaging with LinkedIn Learning' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Tracked', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Staff Participation % staff engaging with LinkedIn Learning' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Tracked', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Staff Participation % staff engaging with LinkedIn Learning' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, '100% activation rate
Average video views per viewer: 31 (27.1% above benchmark vs orgs our size)
Average hours per viewer: 1h 51m (2.4% above benchmark vs orgs our size)
Number of courses completed: 48 vs Number of courses viewed: 225
Number of Video completions: 840 vs Number of videos viewed: 1,021
', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Staff Participation % staff engaging with LinkedIn Learning' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Tracked', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Staff Participation % staff engaging with LinkedIn Learning' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Member Experience', 'Member Net Promoter Score', 'Project Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 20, 20 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Member Net Promoter Score' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 41, 41 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Member Net Promoter Score' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 24, 24 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Member Net Promoter Score' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 63, 63 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Member Net Promoter Score' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 65, 65 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Member Net Promoter Score' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Member Experience', 'Customer Satisfaction Rating', 'Membership Services Manager ', 'text');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Positive - 68% 
Neutral - 11%
Negative - 21%', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Customer Satisfaction Rating' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Positive - 76.0% 
Neutral - 7.7%
Negative - 16.3%', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Customer Satisfaction Rating' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Positive - 77% 
Neutral - 5.4%
Negative - 17.6%', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Customer Satisfaction Rating' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Positive - 86%
Neutral - 7%
Negative - 6%', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Customer Satisfaction Rating' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Positive - 83.4% 
Neutral - 3.8% 
Negative - 12.8%', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Customer Satisfaction Rating' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Member Experience', 'Total Tickets Received', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 21323, 21323 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Tickets Received' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 24602, 24602 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Tickets Received' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 25680, 25680 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Tickets Received' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 27177, 27177 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Tickets Received' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 17340, 17340 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Tickets Received' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Member Experience', 'Total Tickets Resolved', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 21024, 21024 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Tickets Resolved' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 25008, 25008 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Tickets Resolved' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 25706, 25706 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Tickets Resolved' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 27269, 27269 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Tickets Resolved' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 17244, 17244 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Tickets Resolved' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Member Experience', 'Resolution SLA', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Resolution SLA - 47% (% of tickets resolved w/in 5 business days)', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Resolution SLA' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Resolution SLA -65% (% of tickets resolved w/in 5 business days)', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Resolution SLA' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Resolution SLA - 91%(% of tickets resolved w/in 5 business days)', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Resolution SLA' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0.9678, 0.9678 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Resolution SLA' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0.949, 0.949 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Resolution SLA' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Member Experience', 'Total Calls', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Tracked', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Calls' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Tracked', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Calls' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 6871, 6871 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Calls' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 5281, 5281 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Calls' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 5893, 5893 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Calls' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Member Experience', 'Abandonment  Rate', 'Membership Services Manager ', 'percent');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Tracked', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Abandonment  Rate' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Tracked', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Abandonment  Rate' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0.084, 0.084 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Abandonment  Rate' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0.071, 0.071 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Abandonment  Rate' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0.051, 0.051 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Abandonment  Rate' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Member Experience', 'Avg. Speed of Answer', 'Membership Services Manager ', 'time');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Tracked', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Avg. Speed of Answer' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Tracked', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Avg. Speed of Answer' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, '01:08:00', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Avg. Speed of Answer' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, '02:22:00', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Avg. Speed of Answer' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, '00:14:00', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Avg. Speed of Answer' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Member Experience', 'Knowledgebase Article Viewed', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Implemented ', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Knowledgebase Article Viewed' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 1417, 1417 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Knowledgebase Article Viewed' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 42250, 42250 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Knowledgebase Article Viewed' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 46442, 46442 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Knowledgebase Article Viewed' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Member Experience', 'Knowledgebase Article Usefulness', 'Membership Services Manager ', 'text');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Not Implemented ', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Knowledgebase Article Usefulness' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, '13 Liked 
2 Disliked ', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Knowledgebase Article Usefulness' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, '3675 Liked
1837 Disliked ', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Knowledgebase Article Usefulness' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, '699 Liked
429 Dislikes', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Knowledgebase Article Usefulness' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Member Experience', 'Membership Events Planned and Executed', 'Chief of Staff ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 88, 88 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Membership Events Planned and Executed' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Member Experience', 'Membership Events Cost Savings', 'Chief of Staff ', 'text');
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Member Experience', 'Membership Participation % in Benefits Program', 'Chief of Staff ', 'percent');
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Membership Recognition', 'Life Members (confirmed)', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 290, 290 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Life Members (confirmed)' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 116, 116 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Life Members (confirmed)' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 164, 164 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Life Members (confirmed)' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 170, 170 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Life Members (confirmed)' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Membership Recognition', 'Ruby Applications', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 204, 204 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Ruby Applications' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 4, 4 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Ruby Applications' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 310, 310 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Ruby Applications' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 314, 314 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Ruby Applications' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Membership Recognition', 'Cultured Pearl Applications', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 21, 21 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Cultured Pearl Applications' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 2, 2 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Cultured Pearl Applications' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 44, 44 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Cultured Pearl Applications' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 46, 46 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Cultured Pearl Applications' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Membership Retention', 'Renouncements', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 18, 18 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Renouncements' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 37, 37 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Renouncements' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 133, 133 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Renouncements' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 162, 162 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Renouncements' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Membership Retention', 'Omega Rho', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 35, 35 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Omega Rho' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 31, 31 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Omega Rho' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 28, 28 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Omega Rho' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 52, 52 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Omega Rho' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Membership Retention', '% member remaining active from previous fiscal year', 'Membership Services Manager ', 'percent');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, '.33% decrease', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = '% member remaining active from previous fiscal year' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Membership Retention', 'Reclamation/Reactivations', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 925, 925 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Reclamation/Reactivations' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 1659, 1659 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Reclamation/Reactivations' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Membership Retention', 'Total Sorors', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 12880, 12880 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Sorors' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 13058, 13058 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Sorors' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 15172, 15172 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Sorors' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 17567, 17567 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Sorors' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 15602, 15602 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Sorors' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Membership Retention', 'Total Philos', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 861, 861 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Philos' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 1132, 1132 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Philos' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 1241, 1241 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Philos' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 1322, 1322 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Philos' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 1162, 1162 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Philos' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Membership Retention', 'Total Rhoers', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 1552, 1552 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Rhoers' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 1878, 1878 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Rhoers' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 2051, 2051 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Rhoers' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 1933, 1933 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Rhoers' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 1558, 1558 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Rhoers' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Membership Retention', 'Total Rhosebuds', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 458, 458 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Rhosebuds' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 650, 650 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Rhosebuds' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 821, 821 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Rhosebuds' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 318, 318 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Rhosebuds' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0, 0 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Rhosebuds' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Membership Retention', 'Total Sigma Family', NULL, 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, '=SUM(D31:D34)', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Sigma Family' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, '=SUM(E31:E34)', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Sigma Family' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, '=SUM(F31:F34)', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Sigma Family' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 21140, 21140 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Sigma Family' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 18322, 18322 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Sigma Family' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Membership Growth', 'Total TORCH inductees', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 2823, 2823 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total TORCH inductees' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 2642, 2642 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total TORCH inductees' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 2972, 2972 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total TORCH inductees' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 2707, 2707 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total TORCH inductees' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Membership Growth', 'Total Philo Inductees', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 292, 292 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Philo Inductees' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 371, 371 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Philo Inductees' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 409, 409 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Philo Inductees' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 297, 297 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Philo Inductees' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Membership Growth', 'Total Rhoer Inductees', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 615, 615 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Rhoer Inductees' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 863, 863 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Rhoer Inductees' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 823, 823 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Rhoer Inductees' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 754, 754 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Rhoer Inductees' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Membership Growth', 'Total Rhosebud Inductees', 'Membership Services Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 238, 238 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Rhosebud Inductees' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 396, 396 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Rhosebud Inductees' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 464, 464 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Rhosebud Inductees' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 111, 111 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Total Rhosebud Inductees' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Member Intake Fulfillment', '% of Membership Kits Received within 0-14 Days of Induction', 'Membership Services Manager ', 'percent');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0, 0 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = '% of Membership Kits Received within 0-14 Days of Induction' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0, 0 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = '% of Membership Kits Received within 0-14 Days of Induction' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0.791, 0.791 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = '% of Membership Kits Received within 0-14 Days of Induction' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0.89, 0.89 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = '% of Membership Kits Received within 0-14 Days of Induction' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Member Intake Fulfillment', '% of Membership Kits Received within 15+ Days of Induction', 'Membership Services Manager ', 'percent');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0, 0 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = '% of Membership Kits Received within 15+ Days of Induction' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0, 0 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = '% of Membership Kits Received within 15+ Days of Induction' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0.209, 0.209 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = '% of Membership Kits Received within 15+ Days of Induction' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0, 0 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = '% of Membership Kits Received within 15+ Days of Induction' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 0, 0 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = '% of Membership Kits Received within 15+ Days of Induction' AND fy.fy_year = 2026 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Community Impact', 'GHWINS- Undergraduate Engagement', 'Project Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 6, 6 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'GHWINS- Undergraduate Engagement' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 33, 33 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'GHWINS- Undergraduate Engagement' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 7, 7 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'GHWINS- Undergraduate Engagement' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Community Impact', 'GHWINS- Graduate Engagement', 'Project Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 21, 21 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'GHWINS- Graduate Engagement' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 93, 93 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'GHWINS- Graduate Engagement' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 105, 105 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'GHWINS- Graduate Engagement' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Community Impact', 'GHWINS- Total Chapter Engagement', 'Project Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 27, 27 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'GHWINS- Total Chapter Engagement' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 126, 126 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'GHWINS- Total Chapter Engagement' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 112, 112 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'GHWINS- Total Chapter Engagement' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Community Impact', 'GHWINS- Total Disbursement to Chapters', 'Project Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 109105, 109105 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'GHWINS- Total Disbursement to Chapters' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 134572, 134572 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'GHWINS- Total Disbursement to Chapters' AND fy.fy_year = 2023 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 161000, 161000 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'GHWINS- Total Disbursement to Chapters' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Community Impact', 'Financial literacy programs hosted', 'Operations Director', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 20, 20 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Financial literacy programs hosted' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 8, 8 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Financial literacy programs hosted' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Community Impact', 'Leadership Institute Participation', NULL, 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 1200, 1200 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Leadership Institute Participation' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Revenue Growth', 'Total Individual Assessments', 'Finance Manager ', 'text');
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Revenue Growth', 'Donations, Sponsorship and Grant', 'Finance Manager ', 'currency');
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Revenue Growth', 'Sigma Store', 'Finance Manager ', 'text');
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Revenue Growth', 'Vendor Licensing & Royalties', 'Finance Manager ', 'number');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 54408.33, 54408.33 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Vendor Licensing & Royalties' AND fy.fy_year = 2022 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Revenue Growth', 'Internal Conference & Events', 'Finance Manager ', 'text');
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Cost Savings', 'Blazers ($132 to $62) *# of inductees', 'IED / Finance Manager ', 'currency');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 210000, 210000 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Blazers ($132 to $62) *# of inductees' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Cost Savings', 'New Member Kits ($38  to $22 to $5)  *# of inductees', 'IED / Finance Manager ', 'currency');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 29720, 29720 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'New Member Kits ($38  to $22 to $5)  *# of inductees' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'New Member Kits ($22  to $5)  *# of inductees', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'New Member Kits ($38  to $22 to $5)  *# of inductees' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Cost Savings', 'Jewelry ($170 to $140  to $118 to $63)  *# of inductees', 'IED / Finance Manager ', 'currency');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 89160, 89160 FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Jewelry ($170 to $140  to $118 to $63)  *# of inductees' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Jewelry $119 to $64', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Jewelry ($170 to $140  to $118 to $63)  *# of inductees' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Cost Savings', 'Shipping (Posting and Mailings)', 'IED / Finance Manager ', 'text');
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Cost Savings', 'Software and Subscriptions', 'IT Manager', 'text');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Zoom to Teams switch saving $3.6k yr, Adobe  saved  $4k yr in unused licensing', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Software and Subscriptions' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Adobe, ZOOM/Teams, DocuSign', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = 'Software and Subscriptions' AND fy.fy_year = 2025 LIMIT 1;
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Cost Savings', 'Health Benefits', 'IED / Finance Manager ', 'text');
INSERT INTO kpis (category_name, metric_name, owner_name, metric_type) VALUES ('Cost Savings', '(2025) IT Spare Laptops', 'IT Manager', 'text');
INSERT INTO kpi_values (kpi_id, fiscal_year_id, result_value, numeric_value) SELECT k.id, fy.id, 'Saved $6500 with the donation of 11 laptops for spares/interns', NULL FROM kpis k JOIN fiscal_years fy WHERE k.metric_name = '(2025) IT Spare Laptops' AND fy.fy_year = 2024 LIMIT 1;
INSERT INTO performance_goals (department_id, fiscal_year_id, performance_measure, target_value, notes, status_label) SELECT d.id, fy.id, 'Close books in <10 days', '10 days', 'Improved in Q2–Q4', '🟢' FROM departments d JOIN fiscal_years fy WHERE d.name = 'Finance' AND fy.fy_year = 2026;
INSERT INTO performance_goal_quarters (performance_goal_id, quarter_label, actual_value, ytd_percent_to_target) SELECT pg.id, 'Q1', 12, NULL FROM performance_goals pg JOIN departments d ON d.id = pg.department_id WHERE pg.performance_measure = 'Close books in <10 days' AND d.name = 'Finance' LIMIT 1;
INSERT INTO performance_goal_quarters (performance_goal_id, quarter_label, actual_value, ytd_percent_to_target) SELECT pg.id, 'Q2', 9, NULL FROM performance_goals pg JOIN departments d ON d.id = pg.department_id WHERE pg.performance_measure = 'Close books in <10 days' AND d.name = 'Finance' LIMIT 1;
INSERT INTO performance_goal_quarters (performance_goal_id, quarter_label, actual_value, ytd_percent_to_target) SELECT pg.id, 'Q3', 8, NULL FROM performance_goals pg JOIN departments d ON d.id = pg.department_id WHERE pg.performance_measure = 'Close books in <10 days' AND d.name = 'Finance' LIMIT 1;
INSERT INTO performance_goal_quarters (performance_goal_id, quarter_label, actual_value, ytd_percent_to_target) SELECT pg.id, 'Q4', 9, 0.95 FROM performance_goals pg JOIN departments d ON d.id = pg.department_id WHERE pg.performance_measure = 'Close books in <10 days' AND d.name = 'Finance' LIMIT 1;
INSERT INTO performance_goals (department_id, fiscal_year_id, performance_measure, target_value, notes, status_label) SELECT d.id, fy.id, 'Employee Engagement Score', 4.5, 'Met target', NULL FROM departments d JOIN fiscal_years fy WHERE d.name = 'HR' AND fy.fy_year = 2026;
INSERT INTO performance_goal_quarters (performance_goal_id, quarter_label, actual_value, ytd_percent_to_target) SELECT pg.id, 'Q1', 4.3, NULL FROM performance_goals pg JOIN departments d ON d.id = pg.department_id WHERE pg.performance_measure = 'Employee Engagement Score' AND d.name = 'HR' LIMIT 1;
INSERT INTO performance_goal_quarters (performance_goal_id, quarter_label, actual_value, ytd_percent_to_target) SELECT pg.id, 'Q2', 4.4, NULL FROM performance_goals pg JOIN departments d ON d.id = pg.department_id WHERE pg.performance_measure = 'Employee Engagement Score' AND d.name = 'HR' LIMIT 1;
INSERT INTO performance_goal_quarters (performance_goal_id, quarter_label, actual_value, ytd_percent_to_target) SELECT pg.id, 'Q3', 4.6, NULL FROM performance_goals pg JOIN departments d ON d.id = pg.department_id WHERE pg.performance_measure = 'Employee Engagement Score' AND d.name = 'HR' LIMIT 1;
INSERT INTO performance_goal_quarters (performance_goal_id, quarter_label, actual_value, ytd_percent_to_target) SELECT pg.id, 'Q4', 4.5, 0.99 FROM performance_goals pg JOIN departments d ON d.id = pg.department_id WHERE pg.performance_measure = 'Employee Engagement Score' AND d.name = 'HR' LIMIT 1;
INSERT INTO performance_goals (department_id, fiscal_year_id, performance_measure, target_value, notes, status_label) SELECT d.id, fy.id, 'System Uptime %', 0.999, 'Stable', NULL FROM departments d JOIN fiscal_years fy WHERE d.name = 'IT' AND fy.fy_year = 2026;
INSERT INTO performance_goal_quarters (performance_goal_id, quarter_label, actual_value, ytd_percent_to_target) SELECT pg.id, 'Q1', 99.7, NULL FROM performance_goals pg JOIN departments d ON d.id = pg.department_id WHERE pg.performance_measure = 'System Uptime %' AND d.name = 'IT' LIMIT 1;
INSERT INTO performance_goal_quarters (performance_goal_id, quarter_label, actual_value, ytd_percent_to_target) SELECT pg.id, 'Q2', 99.8, NULL FROM performance_goals pg JOIN departments d ON d.id = pg.department_id WHERE pg.performance_measure = 'System Uptime %' AND d.name = 'IT' LIMIT 1;
INSERT INTO performance_goal_quarters (performance_goal_id, quarter_label, actual_value, ytd_percent_to_target) SELECT pg.id, 'Q3', 100, NULL FROM performance_goals pg JOIN departments d ON d.id = pg.department_id WHERE pg.performance_measure = 'System Uptime %' AND d.name = 'IT' LIMIT 1;
INSERT INTO performance_goal_quarters (performance_goal_id, quarter_label, actual_value, ytd_percent_to_target) SELECT pg.id, 'Q4', 99.9, 0.999 FROM performance_goals pg JOIN departments d ON d.id = pg.department_id WHERE pg.performance_measure = 'System Uptime %' AND d.name = 'IT' LIMIT 1;
INSERT INTO monthly_reports (department_id, owner_user_id, fiscal_year_id, month_id, report_title, summary_text, submitted_at) SELECT d.id, u.id, fy.id, m.id, 'Conventions Monthly Report - July FY26', '   •   Board of Directors Retreat
Led the end-to-end development and execution of the retreat: executive-level stakeholder engagement, logistical architecture for 50+ attendees and delivery of a successful executive retreat experience.  Designed and introduced updated travel protocols to enhance internal controls and standardization across travel practices.
   •  Special Events Execution
Executed logistical framework for two retreats—the Philo Leadership Retreat and ICHQ Intern Experience—under compressed timelines. Mobilized resources to ensure both gatherings achieved their planning goals 
   •   Essence Festival Engagement
Directed high-impact activations, and curated experiences including the “Essence of Sisterhood” Brunch and Honorary Member recognitions. Elevated brand presence and engaged over 250 stakeholders across several key events.
   •   Boule 2026 & Staff Retreat Planning
Initiated strategic hotel sourcing and contracting efforts for upcoming national convenings, including ICHQ Staff Retreat. Partnered with external housing vendor (CMC) to build hotel management platform for the Boule, optimize inventory allocation and secure adequate accommodation placements for Boule 2026, ensuring readiness and capacity planning well in advance of event cycle.
 •   Boule 2026 Registration
In collaboration with the IGG, engineered the setup and launch of Boule registration by working cross-functionally with key stakeholders to finalize registration tiers, secure platform configurations (cvent), implement custom branding and ensure seamless integration of event logistics. Executed a communications rollout strategy to drive engagement and ensure registrant clarity.', NOW() FROM departments d LEFT JOIN users u ON u.department_id = d.id AND u.role IN ('manager','executive') JOIN fiscal_years fy ON fy.fy_year = 2026 JOIN months m ON m.fiscal_year_id = fy.id AND m.month_name = 'July' WHERE d.name = 'Conventions' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Received', 677, 1 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - July FY26' AND d.name = 'Conventions' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Responses w/in 48 hrs.', 659, 2 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - July FY26' AND d.name = 'Conventions' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, 'Actual %', '=E3/E2', 3 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - July FY26' AND d.name = 'Conventions' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, '# Receipts', 109, 4 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - July FY26' AND d.name = 'Conventions' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, '# Timely Reconciliation', 101, 5 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - July FY26' AND d.name = 'Conventions' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, 'Actual %', '=E6/E5', 6 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - July FY26' AND d.name = 'Conventions' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, '# events currently planned', 8, 7 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - July FY26' AND d.name = 'Conventions' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, '% events executed within timeline', 1, 8 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - July FY26' AND d.name = 'Conventions' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, 'Ontime task completion', 1, 9 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - July FY26' AND d.name = 'Conventions' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '% cost variance  - budget vs actual', '20.8% over budget', 10 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - July FY26' AND d.name = 'Conventions' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '# events executed under budget', '1 out of 2 (remaining events were from officer budgets)', 11 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - July FY26' AND d.name = 'Conventions' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '$ total cost savings ', -13195, 12 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - July FY26' AND d.name = 'Conventions' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_reports (department_id, owner_user_id, fiscal_year_id, month_id, report_title, summary_text, submitted_at) SELECT d.id, u.id, fy.id, m.id, 'Conventions Monthly Report - August FY26', '•	Elevated SGR’s national presence through coordination of delegate participation at CBC and Day on the Hill with anticipated strategic partner events, briefings and stakeholder engagement.
•	Strengthened Boule vendor pipeline through end-to-end RFP management for AV and General Service Contractor.
•	Expanded Boule attendees’ experience through strategic hotel negotiations to streamline sub-blocks to enable a seamless hotel portal launch. 
', NOW() FROM departments d LEFT JOIN users u ON u.department_id = d.id AND u.role IN ('manager','executive') JOIN fiscal_years fy ON fy.fy_year = 2026 JOIN months m ON m.fiscal_year_id = fy.id AND m.month_name = 'August' WHERE d.name = 'Conventions' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Received', 768, 1 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - August FY26' AND d.name = 'Conventions' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Responses w/in 48 hrs.', 735, 2 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - August FY26' AND d.name = 'Conventions' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, 'Actual %', '=F3/F2', 3 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - August FY26' AND d.name = 'Conventions' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, '# Receipts', 27, 4 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - August FY26' AND d.name = 'Conventions' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, '# Timely Reconciliation', 26, 5 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - August FY26' AND d.name = 'Conventions' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, 'Actual %', '=F6/F5', 6 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - August FY26' AND d.name = 'Conventions' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, '# events currently planned', 5, 7 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - August FY26' AND d.name = 'Conventions' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, '% events executed within timeline', 1, 8 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - August FY26' AND d.name = 'Conventions' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, 'Ontime task completion', 1, 9 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - August FY26' AND d.name = 'Conventions' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '% cost variance  - budget vs actual', 'N/A - Officer Budgets', 10 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - August FY26' AND d.name = 'Conventions' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '# events executed under budget', 'N/A - Officer Budgets', 11 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - August FY26' AND d.name = 'Conventions' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '$ total cost savings ', 'N/A', 12 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - August FY26' AND d.name = 'Conventions' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_reports (department_id, owner_user_id, fiscal_year_id, month_id, report_title, summary_text, submitted_at) SELECT d.id, u.id, fy.id, m.id, 'Conventions Monthly Report - September FY26', '• Launched Boule housing 10 months ahead of the conference, enhancing booking accuracy, reducing inventory issues, and strengthening overall attendee experience.
• Resolved housing inquiries within 24 hours, ensuring a seamless registration experience and reinforcing trust in operational processes.
• Led strategic vendor evaluations, assessing 6 AV firms and initiating the RFP process for general service contractors to optimize quality, ensure cost efficiency, and advance Boule 2026 operational readiness in alignment with long-term event strategy.', NOW() FROM departments d LEFT JOIN users u ON u.department_id = d.id AND u.role IN ('manager','executive') JOIN fiscal_years fy ON fy.fy_year = 2026 JOIN months m ON m.fiscal_year_id = fy.id AND m.month_name = 'September' WHERE d.name = 'Conventions' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Received', 840, 1 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - September FY26' AND d.name = 'Conventions' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Responses w/in 48 hrs.', 817, 2 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - September FY26' AND d.name = 'Conventions' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, 'Actual %', '=G3/G2', 3 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - September FY26' AND d.name = 'Conventions' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, '# Receipts', 35, 4 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - September FY26' AND d.name = 'Conventions' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, '# Timely Reconciliation', 35, 5 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - September FY26' AND d.name = 'Conventions' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, 'Actual %', '=G6/G5', 6 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - September FY26' AND d.name = 'Conventions' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, '# events currently planned', 7, 7 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - September FY26' AND d.name = 'Conventions' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, '% events executed within timeline', 1, 8 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - September FY26' AND d.name = 'Conventions' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, 'Ontime task completion', 1, 9 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - September FY26' AND d.name = 'Conventions' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '% cost variance  - budget vs actual', 0.294, 10 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - September FY26' AND d.name = 'Conventions' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '# events executed under budget', '2 out of 2', 11 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - September FY26' AND d.name = 'Conventions' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '$ total cost savings ', NULL, 12 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - September FY26' AND d.name = 'Conventions' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_reports (department_id, owner_user_id, fiscal_year_id, month_id, report_title, summary_text, submitted_at) SELECT d.id, u.id, fy.id, m.id, 'Conventions Monthly Report - October FY26', 'Member Growth & Sustainability / Headquarters Operations
•	Achieved 2,384 Boule registrations as of October 31, exceeding the early target of 2,000 by 19%, reflecting strong engagement strategy and registration planning.
Leadership Training & Development
•	Conducted capacity-building sessions for 20 + Boule Sub-Committee Chairs, establishing clarity in scope of work, operational alignment, milestone expectations, and performance accountability across all committees.
External Engagements & Increased Sponsorship
•	Represented Sigma Gamma Rho at IMEX Americas, completing 36 targeted meetings focused on partnership expansion, vendor evaluation, and cost-efficiency opportunities for future national events.
', NOW() FROM departments d LEFT JOIN users u ON u.department_id = d.id AND u.role IN ('manager','executive') JOIN fiscal_years fy ON fy.fy_year = 2026 JOIN months m ON m.fiscal_year_id = fy.id AND m.month_name = 'October' WHERE d.name = 'Conventions' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Received', NULL, 1 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - October FY26' AND d.name = 'Conventions' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Responses w/in 48 hrs.', NULL, 2 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - October FY26' AND d.name = 'Conventions' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, 'Actual %', '=H3/H2', 3 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - October FY26' AND d.name = 'Conventions' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, '# Receipts', NULL, 4 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - October FY26' AND d.name = 'Conventions' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, '# Timely Reconciliation', NULL, 5 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - October FY26' AND d.name = 'Conventions' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, 'Actual %', '=H6/H5', 6 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - October FY26' AND d.name = 'Conventions' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, '# events currently planned', NULL, 7 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - October FY26' AND d.name = 'Conventions' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, '% events executed within timeline', NULL, 8 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - October FY26' AND d.name = 'Conventions' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, 'Ontime task completion', NULL, 9 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - October FY26' AND d.name = 'Conventions' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '% cost variance  - budget vs actual', NULL, 10 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - October FY26' AND d.name = 'Conventions' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '# events executed under budget', NULL, 11 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - October FY26' AND d.name = 'Conventions' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '$ total cost savings ', NULL, 12 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - October FY26' AND d.name = 'Conventions' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_reports (department_id, owner_user_id, fiscal_year_id, month_id, report_title, summary_text, submitted_at) SELECT d.id, u.id, fy.id, m.id, 'Conventions Monthly Report - November FY26', 'Leadership Training & Development
• Delivered a comprehensive strategic briefing on Run of Show best practices for 30+ Boule Sub-Committee Chairs, establishing robust planning standards, fostering operational cohesion, and ensuring unified event execution.
External Engagements
• Secured the AV vendor and initiated the selection process for the General Service Contractor nine months prior to Boule, enhancing cost efficiency and establishing a precedent for early vendor sourcing.
Headquarter Operations
• Collaborated with the committee to support the successful execution of the ICHQ Staff Retreat, contributing to budget optimization and logistical coordination.', NOW() FROM departments d LEFT JOIN users u ON u.department_id = d.id AND u.role IN ('manager','executive') JOIN fiscal_years fy ON fy.fy_year = 2026 JOIN months m ON m.fiscal_year_id = fy.id AND m.month_name = 'November' WHERE d.name = 'Conventions' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Received', NULL, 1 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - November FY26' AND d.name = 'Conventions' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Responses w/in 48 hrs.', NULL, 2 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - November FY26' AND d.name = 'Conventions' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, 'Actual %', '=I3/I2', 3 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - November FY26' AND d.name = 'Conventions' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, '# Receipts', NULL, 4 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - November FY26' AND d.name = 'Conventions' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, '# Timely Reconciliation', NULL, 5 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - November FY26' AND d.name = 'Conventions' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, 'Actual %', '=I6/I5', 6 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - November FY26' AND d.name = 'Conventions' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, '# events currently planned', NULL, 7 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - November FY26' AND d.name = 'Conventions' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, '% events executed within timeline', NULL, 8 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - November FY26' AND d.name = 'Conventions' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, 'Ontime task completion', NULL, 9 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - November FY26' AND d.name = 'Conventions' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '% cost variance  - budget vs actual', NULL, 10 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - November FY26' AND d.name = 'Conventions' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '# events executed under budget', NULL, 11 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - November FY26' AND d.name = 'Conventions' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '$ total cost savings ', NULL, 12 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - November FY26' AND d.name = 'Conventions' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_reports (department_id, owner_user_id, fiscal_year_id, month_id, report_title, summary_text, submitted_at) SELECT d.id, u.id, fy.id, m.id, 'Conventions Monthly Report - December FY26', '• Advanced national event alignment through engagement at AFA Annual Meeting, expanding fraternity/sorority advising relationships and promoting best-practice standardization (Operational Excellence; Member Value).
• Increased Boule planning readiness by supporting Chairs with the event details survey and Run of Show development (Operational Excellence).
• Supported the sorority’s presence at the 2025 Celebration Bowl through coordinated leadership engagement and an NPHC community service activation, enhancing visibility (Brand Elevation; Strategic Partnerships).
• Supported ICHQ Staff Retreat and reconciled expenses under approved budget parameters (Fiscal Stewardship).', NOW() FROM departments d LEFT JOIN users u ON u.department_id = d.id AND u.role IN ('manager','executive') JOIN fiscal_years fy ON fy.fy_year = 2026 JOIN months m ON m.fiscal_year_id = fy.id AND m.month_name = 'December' WHERE d.name = 'Conventions' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Received', NULL, 1 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - December FY26' AND d.name = 'Conventions' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Responses w/in 48 hrs.', NULL, 2 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - December FY26' AND d.name = 'Conventions' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, 'Actual %', '=J3/J2', 3 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - December FY26' AND d.name = 'Conventions' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, '# Receipts', NULL, 4 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - December FY26' AND d.name = 'Conventions' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, '# Timely Reconciliation', NULL, 5 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - December FY26' AND d.name = 'Conventions' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, 'Actual %', '=J6/J5', 6 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - December FY26' AND d.name = 'Conventions' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, '# events currently planned', NULL, 7 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - December FY26' AND d.name = 'Conventions' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, '% events executed within timeline', NULL, 8 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - December FY26' AND d.name = 'Conventions' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, 'Ontime task completion', NULL, 9 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - December FY26' AND d.name = 'Conventions' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '% cost variance  - budget vs actual', NULL, 10 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - December FY26' AND d.name = 'Conventions' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '# events executed under budget', NULL, 11 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - December FY26' AND d.name = 'Conventions' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '$ total cost savings ', NULL, 12 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - December FY26' AND d.name = 'Conventions' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_reports (department_id, owner_user_id, fiscal_year_id, month_id, report_title, summary_text, submitted_at) SELECT d.id, u.id, fy.id, m.id, 'Conventions Monthly Report - January FY26', 'Secured the second-largest service provider for the 2026 Boule, remaining under projected budget and well ahead of timeline milestones, advancing early planning initiatives and supporting financial forecasting. 
• Ongoing management of Boule registration and housing, providing continuous support for Boule attendees. Resolved 55 helpdesk tickets while monitoring attendee needs to make meaningful adjustments, ensuring a seamless experience and optimizing housing allocations. 
• Developed a standardized presentation framework for Boule Chairs, enabling consistent event overviews for the Core Team to ensure alignment, accountability, budget adherence and brand quality. 
• Enhanced leadership development and external engagement by facilitating participation of international and regional IBOD leaders and scholarship recipients at AFLV Central, fostering cross-organizational relationships and exposure to fraternal best practices (Leadership & Development). ', NOW() FROM departments d LEFT JOIN users u ON u.department_id = d.id AND u.role IN ('manager','executive') JOIN fiscal_years fy ON fy.fy_year = 2026 JOIN months m ON m.fiscal_year_id = fy.id AND m.month_name = 'January' WHERE d.name = 'Conventions' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Received', NULL, 1 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - January FY26' AND d.name = 'Conventions' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Responses w/in 48 hrs.', NULL, 2 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - January FY26' AND d.name = 'Conventions' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, 'Actual %', '=K3/K2', 3 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - January FY26' AND d.name = 'Conventions' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, '# Receipts', NULL, 4 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - January FY26' AND d.name = 'Conventions' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, '# Timely Reconciliation', NULL, 5 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - January FY26' AND d.name = 'Conventions' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, 'Actual %', '=K6/K5', 6 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - January FY26' AND d.name = 'Conventions' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, '# events currently planned', NULL, 7 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - January FY26' AND d.name = 'Conventions' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, '% events executed within timeline', NULL, 8 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - January FY26' AND d.name = 'Conventions' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, 'Ontime task completion', NULL, 9 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - January FY26' AND d.name = 'Conventions' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '% cost variance  - budget vs actual', NULL, 10 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - January FY26' AND d.name = 'Conventions' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '# events executed under budget', NULL, 11 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - January FY26' AND d.name = 'Conventions' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '$ total cost savings ', NULL, 12 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - January FY26' AND d.name = 'Conventions' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_reports (department_id, owner_user_id, fiscal_year_id, month_id, report_title, summary_text, submitted_at) SELECT d.id, u.id, fy.id, m.id, 'Conventions Monthly Report - February FY26', NULL, NOW() FROM departments d LEFT JOIN users u ON u.department_id = d.id AND u.role IN ('manager','executive') JOIN fiscal_years fy ON fy.fy_year = 2026 JOIN months m ON m.fiscal_year_id = fy.id AND m.month_name = 'February' WHERE d.name = 'Conventions' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Received', NULL, 1 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - February FY26' AND d.name = 'Conventions' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Responses w/in 48 hrs.', NULL, 2 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - February FY26' AND d.name = 'Conventions' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, 'Actual %', '=L3/L2', 3 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - February FY26' AND d.name = 'Conventions' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, '# Receipts', NULL, 4 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - February FY26' AND d.name = 'Conventions' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, '# Timely Reconciliation', NULL, 5 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - February FY26' AND d.name = 'Conventions' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Receipt Reconciliation Convention Card', NULL, 'Actual %', '=L6/L5', 6 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - February FY26' AND d.name = 'Conventions' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, '# events currently planned', NULL, 7 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - February FY26' AND d.name = 'Conventions' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, '% events executed within timeline', NULL, 8 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - February FY26' AND d.name = 'Conventions' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Improve Event Timeline Adherence:
KPI: Track the timeline for various planning milestones.
KPI: Track Percentage of events planned and executed within the defined timeline.
KPI: Track Number of events concurrently managed without compromising quality.', 0.95, 'Ontime task completion', NULL, 9 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - February FY26' AND d.name = 'Conventions' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '% cost variance  - budget vs actual', NULL, 10 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - February FY26' AND d.name = 'Conventions' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '# events executed under budget', NULL, 11 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - February FY26' AND d.name = 'Conventions' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Increase Cost Efficiency/Reduce Event Costs by 15%
KPI: Track Average cost variance between planned and actual event budgets.
KPI: Track percentage of events that stay within the allocated budget.
KPI: Track total cost savings achieved by negotiating vendor contracts, optimizing resource allocation, etc.', 0.15, '$ total cost savings ', NULL, 12 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Conventions Monthly Report - February FY26' AND d.name = 'Conventions' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_reports (department_id, owner_user_id, fiscal_year_id, month_id, report_title, summary_text, submitted_at) SELECT d.id, u.id, fy.id, m.id, 'Operations / Membership Services Monthly Report - July FY26', NULL, NOW() FROM departments d LEFT JOIN users u ON u.department_id = d.id AND u.role IN ('manager','executive') JOIN fiscal_years fy ON fy.fy_year = 2026 JOIN months m ON m.fiscal_year_id = fy.id AND m.month_name = 'July' WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Received', 2351, 1 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - July FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Responses w/in 48 hrs.', '=E29*E31', 2 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - July FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, 'Actual %', 0.99, 3 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - July FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, '# Received', 2351, 4 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - July FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, '# Resolved w/in 5 BD', '=E32*E34', 5 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - July FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, 'Actual %', 0.99, 6 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - July FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, '# Received', 1166, 7 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - July FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, '# Resolved', 1136, 8 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - July FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, 'Actual %', '=E36/E35', 9 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - July FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Received', 375, 10 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - July FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Closed', 356, 11 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - July FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', 'Completion Rate', '=E39/E38', 12 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - July FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', 'Goal %', '=E38/E35', 13 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - July FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #2 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Received', 378, 14 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - July FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #2 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Closed', 372, 15 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - July FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'July' LIMIT 1;
INSERT INTO monthly_reports (department_id, owner_user_id, fiscal_year_id, month_id, report_title, summary_text, submitted_at) SELECT d.id, u.id, fy.id, m.id, 'Operations / Membership Services Monthly Report - August FY26', NULL, NOW() FROM departments d LEFT JOIN users u ON u.department_id = d.id AND u.role IN ('manager','executive') JOIN fiscal_years fy ON fy.fy_year = 2026 JOIN months m ON m.fiscal_year_id = fy.id AND m.month_name = 'August' WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Received', 2316, 1 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - August FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Responses w/in 48 hrs.', '=F29*F31', 2 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - August FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, 'Actual %', 0.97, 3 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - August FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, '# Received', 2316, 4 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - August FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, '# Resolved w/in 5 BD', '=F32*F34', 5 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - August FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, 'Actual %', 0.97, 6 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - August FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, '# Received', 1303, 7 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - August FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, '# Resolved', 1307, 8 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - August FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, 'Actual %', '=F36/F35', 9 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - August FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Received', 443, 10 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - August FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Closed', 445, 11 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - August FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', 'Completion Rate', '=F39/F38', 12 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - August FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', 'Goal %', '=F38/F35', 13 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - August FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #2 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Received', 407, 14 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - August FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #2 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Closed', 414, 15 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - August FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'August' LIMIT 1;
INSERT INTO monthly_reports (department_id, owner_user_id, fiscal_year_id, month_id, report_title, summary_text, submitted_at) SELECT d.id, u.id, fy.id, m.id, 'Operations / Membership Services Monthly Report - September FY26', NULL, NOW() FROM departments d LEFT JOIN users u ON u.department_id = d.id AND u.role IN ('manager','executive') JOIN fiscal_years fy ON fy.fy_year = 2026 JOIN months m ON m.fiscal_year_id = fy.id AND m.month_name = 'September' WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Received', 3778, 1 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - September FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Responses w/in 48 hrs.', '=G29*G31', 2 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - September FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, 'Actual %', 0.98, 3 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - September FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, '# Received', 3778, 4 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - September FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, '# Resolved w/in 5 BD', '=G32*G34', 5 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - September FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, 'Actual %', 0.93, 6 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - September FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, '# Received', 2045, 7 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - September FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, '# Resolved', 2026, 8 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - September FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, 'Actual %', '=G36/G35', 9 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - September FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Received', 736, 10 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - September FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Closed', 741, 11 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - September FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', 'Completion Rate', '=G39/G38', 12 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - September FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', 'Goal %', '=G38/G35', 13 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - September FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #2 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Received', 626, 14 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - September FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #2 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Closed', 610, 15 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - September FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'September' LIMIT 1;
INSERT INTO monthly_reports (department_id, owner_user_id, fiscal_year_id, month_id, report_title, summary_text, submitted_at) SELECT d.id, u.id, fy.id, m.id, 'Operations / Membership Services Monthly Report - October FY26', NULL, NOW() FROM departments d LEFT JOIN users u ON u.department_id = d.id AND u.role IN ('manager','executive') JOIN fiscal_years fy ON fy.fy_year = 2026 JOIN months m ON m.fiscal_year_id = fy.id AND m.month_name = 'October' WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Received', NULL, 1 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - October FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Responses w/in 48 hrs.', NULL, 2 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - October FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, 'Actual %', NULL, 3 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - October FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, '# Received', NULL, 4 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - October FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, '# Resolved w/in 5 BD', NULL, 5 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - October FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, 'Actual %', NULL, 6 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - October FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, '# Received', NULL, 7 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - October FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, '# Resolved', NULL, 8 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - October FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, 'Actual %', NULL, 9 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - October FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Received', NULL, 10 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - October FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Closed', NULL, 11 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - October FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', 'Completion Rate', NULL, 12 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - October FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', 'Goal %', NULL, 13 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - October FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #2 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Received', NULL, 14 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - October FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #2 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Closed', NULL, 15 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - October FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'October' LIMIT 1;
INSERT INTO monthly_reports (department_id, owner_user_id, fiscal_year_id, month_id, report_title, summary_text, submitted_at) SELECT d.id, u.id, fy.id, m.id, 'Operations / Membership Services Monthly Report - November FY26', NULL, NOW() FROM departments d LEFT JOIN users u ON u.department_id = d.id AND u.role IN ('manager','executive') JOIN fiscal_years fy ON fy.fy_year = 2026 JOIN months m ON m.fiscal_year_id = fy.id AND m.month_name = 'November' WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Received', NULL, 1 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - November FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Responses w/in 48 hrs.', NULL, 2 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - November FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, 'Actual %', NULL, 3 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - November FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, '# Received', NULL, 4 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - November FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, '# Resolved w/in 5 BD', NULL, 5 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - November FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, 'Actual %', NULL, 6 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - November FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, '# Received', NULL, 7 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - November FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, '# Resolved', NULL, 8 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - November FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, 'Actual %', NULL, 9 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - November FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Received', NULL, 10 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - November FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Closed', NULL, 11 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - November FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', 'Completion Rate', NULL, 12 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - November FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', 'Goal %', NULL, 13 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - November FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #2 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Received', NULL, 14 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - November FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #2 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Closed', NULL, 15 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - November FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'November' LIMIT 1;
INSERT INTO monthly_reports (department_id, owner_user_id, fiscal_year_id, month_id, report_title, summary_text, submitted_at) SELECT d.id, u.id, fy.id, m.id, 'Operations / Membership Services Monthly Report - December FY26', NULL, NOW() FROM departments d LEFT JOIN users u ON u.department_id = d.id AND u.role IN ('manager','executive') JOIN fiscal_years fy ON fy.fy_year = 2026 JOIN months m ON m.fiscal_year_id = fy.id AND m.month_name = 'December' WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Received', NULL, 1 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - December FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Responses w/in 48 hrs.', NULL, 2 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - December FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, 'Actual %', NULL, 3 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - December FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, '# Received', NULL, 4 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - December FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, '# Resolved w/in 5 BD', NULL, 5 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - December FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, 'Actual %', NULL, 6 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - December FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, '# Received', NULL, 7 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - December FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, '# Resolved', NULL, 8 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - December FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, 'Actual %', NULL, 9 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - December FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Received', NULL, 10 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - December FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Closed', NULL, 11 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - December FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', 'Completion Rate', NULL, 12 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - December FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', 'Goal %', NULL, 13 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - December FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #2 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Received', NULL, 14 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - December FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #2 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Closed', NULL, 15 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - December FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'December' LIMIT 1;
INSERT INTO monthly_reports (department_id, owner_user_id, fiscal_year_id, month_id, report_title, summary_text, submitted_at) SELECT d.id, u.id, fy.id, m.id, 'Operations / Membership Services Monthly Report - January FY26', NULL, NOW() FROM departments d LEFT JOIN users u ON u.department_id = d.id AND u.role IN ('manager','executive') JOIN fiscal_years fy ON fy.fy_year = 2026 JOIN months m ON m.fiscal_year_id = fy.id AND m.month_name = 'January' WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Received', NULL, 1 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - January FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Responses w/in 48 hrs.', NULL, 2 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - January FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, 'Actual %', NULL, 3 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - January FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, '# Received', NULL, 4 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - January FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, '# Resolved w/in 5 BD', NULL, 5 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - January FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, 'Actual %', NULL, 6 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - January FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, '# Received', NULL, 7 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - January FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, '# Resolved', NULL, 8 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - January FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, 'Actual %', NULL, 9 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - January FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Received', NULL, 10 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - January FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Closed', NULL, 11 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - January FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', 'Completion Rate', NULL, 12 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - January FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', 'Goal %', NULL, 13 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - January FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #2 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Received', NULL, 14 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - January FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #2 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Closed', NULL, 15 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - January FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'January' LIMIT 1;
INSERT INTO monthly_reports (department_id, owner_user_id, fiscal_year_id, month_id, report_title, summary_text, submitted_at) SELECT d.id, u.id, fy.id, m.id, 'Operations / Membership Services Monthly Report - February FY26', NULL, NOW() FROM departments d LEFT JOIN users u ON u.department_id = d.id AND u.role IN ('manager','executive') JOIN fiscal_years fy ON fy.fy_year = 2026 JOIN months m ON m.fiscal_year_id = fy.id AND m.month_name = 'February' WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Received', NULL, 1 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - February FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, '# Responses w/in 48 hrs.', NULL, 2 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - February FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'First Response w/in 48 Hours', 1, 'Actual %', NULL, 3 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - February FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, '# Received', NULL, 4 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - February FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, '# Resolved w/in 5 BD', NULL, 5 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - February FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Tickets Resolved w/in 5 Business Days', 0.65, 'Actual %', NULL, 6 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - February FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, '# Received', NULL, 7 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - February FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, '# Resolved', NULL, 8 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - February FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'Customer Service Team Complete 80% of Incoming Tier 1 Tickets Per Month', 0.8, 'Actual %', NULL, 9 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - February FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Received', NULL, 10 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - February FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Closed', NULL, 11 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - February FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', 'Completion Rate', NULL, 12 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - February FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #1 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', 'Goal %', NULL, 13 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - February FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #2 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Received', NULL, 14 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - February FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'February' LIMIT 1;
INSERT INTO monthly_report_metrics (monthly_report_id, key_result, target_value, measure_label, actual_value, sort_order) SELECT mr.id, 'CSR Agent #2 Completion of Tier 1 Incoming Tickets Per Month', '30%-33%', '# Closed', NULL, 15 FROM monthly_reports mr JOIN departments d ON d.id = mr.department_id JOIN months m ON m.id = mr.month_id WHERE mr.report_title = 'Operations / Membership Services Monthly Report - February FY26' AND d.name = 'Operations / Membership Services' AND m.month_name = 'February' LIMIT 1;
INSERT INTO key_stats (objective_name, stat_name, goal_value, measure_label) VALUES ('Membership Growth Trajectory', 'Membership Count', 'Goal
Stretch Goal', '# Members');
INSERT INTO key_stats (objective_name, stat_name, goal_value, measure_label) VALUES ('Membership Growth Trajectory', 'Membership Count', 18352, '% of Goal');
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Jul 2022', '2022-07-01', '=E3/$C$4', NULL FROM key_stats ks WHERE ks.objective_name = 'Membership Growth Trajectory' AND ks.stat_name = 'Membership Count' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Aug 2022', '2022-08-01', '=F3/$C$4', NULL FROM key_stats ks WHERE ks.objective_name = 'Membership Growth Trajectory' AND ks.stat_name = 'Membership Count' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Sep 2022', '2022-09-01', '=G3/$C$4', NULL FROM key_stats ks WHERE ks.objective_name = 'Membership Growth Trajectory' AND ks.stat_name = 'Membership Count' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Oct 2022', '2022-10-01', '=H3/$C$4', NULL FROM key_stats ks WHERE ks.objective_name = 'Membership Growth Trajectory' AND ks.stat_name = 'Membership Count' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Nov 2022', '2022-11-01', '=I3/$C$4', NULL FROM key_stats ks WHERE ks.objective_name = 'Membership Growth Trajectory' AND ks.stat_name = 'Membership Count' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Dec 2022', '2022-12-01', '=J3/$C$4', NULL FROM key_stats ks WHERE ks.objective_name = 'Membership Growth Trajectory' AND ks.stat_name = 'Membership Count' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Jan 2023', '2023-01-01', '=K3/$C$4', NULL FROM key_stats ks WHERE ks.objective_name = 'Membership Growth Trajectory' AND ks.stat_name = 'Membership Count' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Feb 2023', '2023-02-01', '=L3/$C$4', NULL FROM key_stats ks WHERE ks.objective_name = 'Membership Growth Trajectory' AND ks.stat_name = 'Membership Count' LIMIT 1;
INSERT INTO key_stats (objective_name, stat_name, goal_value, measure_label) VALUES ('Membership Growth Trajectory', 'Membership Count', 22000, '% of Stretch Goal');
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Jul 2022', '2022-07-01', '=E3/$C$5', NULL FROM key_stats ks WHERE ks.objective_name = 'Membership Growth Trajectory' AND ks.stat_name = 'Membership Count' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Aug 2022', '2022-08-01', '=F3/$C$5', NULL FROM key_stats ks WHERE ks.objective_name = 'Membership Growth Trajectory' AND ks.stat_name = 'Membership Count' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Sep 2022', '2022-09-01', '=G3/$C$5', NULL FROM key_stats ks WHERE ks.objective_name = 'Membership Growth Trajectory' AND ks.stat_name = 'Membership Count' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Oct 2022', '2022-10-01', '=H3/$C$5', NULL FROM key_stats ks WHERE ks.objective_name = 'Membership Growth Trajectory' AND ks.stat_name = 'Membership Count' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Nov 2022', '2022-11-01', '=I3/$C$5', NULL FROM key_stats ks WHERE ks.objective_name = 'Membership Growth Trajectory' AND ks.stat_name = 'Membership Count' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Dec 2022', '2022-12-01', '=J3/$C$5', NULL FROM key_stats ks WHERE ks.objective_name = 'Membership Growth Trajectory' AND ks.stat_name = 'Membership Count' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Jan 2023', '2023-01-01', '=K3/$C$5', NULL FROM key_stats ks WHERE ks.objective_name = 'Membership Growth Trajectory' AND ks.stat_name = 'Membership Count' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Feb 2023', '2023-02-01', '=L3/$C$5', NULL FROM key_stats ks WHERE ks.objective_name = 'Membership Growth Trajectory' AND ks.stat_name = 'Membership Count' LIMIT 1;
INSERT INTO key_stats (objective_name, stat_name, goal_value, measure_label) VALUES ('Member Assessment/Feedback', 'Membership Satifiaction w/ICHQ', NULL, 'Negative');
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Jul 2022', '2022-07-01', 0.2, 0.2 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Aug 2022', '2022-08-01', 0.29, 0.29 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Sep 2022', '2022-09-01', 0.14, 0.14 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Oct 2022', '2022-10-01', 0.17, 0.17 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Nov 2022', '2022-11-01', 0.22, 0.22 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Dec 2022', '2022-12-01', 0.33, 0.33 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Jan 2023', '2023-01-01', 0.2, 0.2 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Feb 2023', '2023-02-01', 0.09, 0.09 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stats (objective_name, stat_name, goal_value, measure_label) VALUES ('Member Assessment/Feedback', 'Membership Satifiaction w/ICHQ', NULL, 'Neutral');
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Jul 2022', '2022-07-01', 0.08, 0.08 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Aug 2022', '2022-08-01', 0.09, 0.09 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Sep 2022', '2022-09-01', 0.08, 0.08 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Oct 2022', '2022-10-01', 0.09, 0.09 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Nov 2022', '2022-11-01', 0.02, 0.02 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Dec 2022', '2022-12-01', 0.03, 0.03 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Jan 2023', '2023-01-01', 0.05, 0.05 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Feb 2023', '2023-02-01', 0.09, 0.09 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stats (objective_name, stat_name, goal_value, measure_label) VALUES ('Member Assessment/Feedback', 'Membership Satifiaction w/ICHQ', NULL, 'Positive');
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Jul 2022', '2022-07-01', 0.71, 0.71 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Aug 2022', '2022-08-01', 0.62, 0.62 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Sep 2022', '2022-09-01', 0.78, 0.78 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Oct 2022', '2022-10-01', 0.73, 0.73 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Nov 2022', '2022-11-01', 0.76, 0.76 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Dec 2022', '2022-12-01', 0.64, 0.64 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Jan 2023', '2023-01-01', 0.75, 0.75 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Feb 2023', '2023-02-01', 0.83, 0.83 FROM key_stats ks WHERE ks.objective_name = 'Member Assessment/Feedback' AND ks.stat_name = 'Membership Satifiaction w/ICHQ' LIMIT 1;
INSERT INTO key_stats (objective_name, stat_name, goal_value, measure_label) VALUES ('Associate Engagement', 'Employee Turnover Rate', NULL, '# Employees');
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Jul 2022', '2022-07-01', 30, 30 FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Aug 2022', '2022-08-01', 30, 30 FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Sep 2022', '2022-09-01', 30, 30 FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Oct 2022', '2022-10-01', 30, 30 FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Nov 2022', '2022-11-01', 31, 31 FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Dec 2022', '2022-12-01', 29, 29 FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Jan 2023', '2023-01-01', 29, 29 FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Feb 2023', '2023-02-01', 29, 29 FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stats (objective_name, stat_name, goal_value, measure_label) VALUES ('Associate Engagement', 'Employee Turnover Rate', NULL, '# Resignations / Terminations');
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Jul 2022', '2022-07-01', 0, 0 FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Aug 2022', '2022-08-01', 0, 0 FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Sep 2022', '2022-09-01', 0, 0 FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Oct 2022', '2022-10-01', 0, 0 FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Nov 2022', '2022-11-01', 0, 0 FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Dec 2022', '2022-12-01', 2, 2 FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Jan 2023', '2023-01-01', 0, 0 FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Feb 2023', '2023-02-01', 0, 0 FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stats (objective_name, stat_name, goal_value, measure_label) VALUES ('Associate Engagement', 'Employee Turnover Rate', NULL, 'Turnover Rate');
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Jul 2022', '2022-07-01', '=E13/E12', NULL FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Aug 2022', '2022-08-01', '=F13/F12', NULL FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Sep 2022', '2022-09-01', '=G13/G12', NULL FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Oct 2022', '2022-10-01', '=H13/H12', NULL FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Nov 2022', '2022-11-01', '=I13/I12', NULL FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Dec 2022', '2022-12-01', '=J13/J12', NULL FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Jan 2023', '2023-01-01', '=K13/K12', NULL FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO key_stat_values (key_stat_id, month_label, month_date, value_text, numeric_value) SELECT ks.id, 'Feb 2023', '2023-02-01', '=L13/L12', NULL FROM key_stats ks WHERE ks.objective_name = 'Associate Engagement' AND ks.stat_name = 'Employee Turnover Rate' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'TORCH 2.0 Automation Completion', 'Membership', 'Membership Services Manager / IT', 'FGAB', 'High', 'FY26 - Q1', 'In progress, anticipated full implementation by July 2025', 0 FROM departments d WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'New Charter Automation', 'Membership', 'Membership Services Manager / IT', 'FGAB', 'Medium', 'FY25-Q2', 'Based on IT Infrastructure', 0 FROM departments d WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Sigma Recognition Automation', 'Membership', 'Membership Services Manager / IT', 'FGAB', 'Medium', 'FY25 - Q3', 'Based on IT Infrastructure', 0 FROM departments d WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Creation of a Rhosebud Intake Process', NULL, 'Membership Services Manager ', 'FGAB', 'High', 'FY25- Q1', 'Based SOP/Bylaw Updates after Boule 2024', 0 FROM departments d WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Dedicated Cultured Pearl Service Hours', 'Membership', 'Membership Services Manager ', 'FGAB', 'Low', 'COMPLETE', 'Based on staff availability', 1 FROM departments d WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'International Chapters Service Hours', 'Membership', 'Membership Services Manager ', 'FGAB', 'Medium', 'FY25- Q1', 'Based on staff availability', 1 FROM departments d WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'TORCH II Asynchronous Training', 'Training', 'Membership Services Manager / Trainer', 'FGAB', 'High', 'FY25- Q1', 'Based on approval', 0 FROM departments d WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Affinity Group Fee - Cost attached to our Ruby Recognition.  This affinity group is the largest in the sorority.  Once members apply and are approved, a fee is attached for the research required, them receiving their recognition, certificate, and pin (mirroring the Life Member process).', 'Membership', 'Membership Services Manager ', NULL, NULL, NULL, NULL, 0 FROM departments d WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Advertising - Offer/sell ad space to Soror businesses/other businesses in our newsletter, mobile app, conferences, social media posts, etc.).', NULL, 'Membership Services Manager ', NULL, NULL, NULL, NULL, 0 FROM departments d WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Individual Donations - Members, legacy families, intake classes, etc. can make donations to the organization and in return receive a special tangible item from the organization (shirt, pin, bracelet, etc.) that is only for donors plus name listed on website/app/newsletter.', NULL, 'Membership Services Manager ', NULL, NULL, NULL, NULL, 0 FROM departments d WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Global Chapter Sustainability Plan', NULL, 'Project Manager', 'IFGAB', 'Medium', 'FY26 - Q4', NULL, 0 FROM departments d WHERE d.name = 'Project Management' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Collaborative Branding Strategy (Organization/Products)', NULL, 'Project Manager', 'IGE', 'High', 'FY25 - Q4', NULL, 0 FROM departments d WHERE d.name = 'Project Management' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Create a Robust Vendor Market Place (Vendor Retention Strategy)', NULL, 'Project Manager', 'IGT', 'High', 'FY25 - Q4', NULL, 0 FROM departments d WHERE d.name = 'Project Management' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, '4-yr Limited Edition Product Plan', NULL, 'Project Manager', 'IGT', 'Medium', 'FY25 - Q4', NULL, 0 FROM departments d WHERE d.name = 'Project Management' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Revenue Generation Travel Plan (Biannual Global Retreats)', NULL, 'Project Manager', 'IGB', 'High', 'FY25 - Q4', '2027 - Bermuda/Bahamas/USVI, 2029 - London/Germany, 2031 - UAE', 0 FROM departments d WHERE d.name = 'Project Management' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Creating a Real Estate Plan/Funding for Sigma Mix-Use Facility', NULL, 'Project Manager', 'IGB/ED', 'High', 'FY26 - Q4', NULL, 0 FROM departments d WHERE d.name = 'Project Management' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Identify Permanent place for  SGRHO library/ Historical Artifacts', NULL, 'Project Manager', 'IED', 'High', 'FY26 - Q4', NULL, 0 FROM departments d WHERE d.name = 'Project Management' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Securing additional Grants for Essential Programs/Impact Initiatives', NULL, 'Project Manager', 'IGB/ED', 'High', 'FY26 - Q4', NULL, 0 FROM departments d WHERE d.name = 'Project Management' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Cultured Pearl - Preserving Our legacy- Celebrating our Cultured Pearls  -Through Pictures and Stories', NULL, 'Project Manager', 'IGE', 'Low', 'FY25 - Q4', NULL, 0 FROM departments d WHERE d.name = 'Project Management' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Performance Management Software', NULL, 'HR Manager/IT Manager', 'IED', 'High', NULL, NULL, 0 FROM departments d WHERE d.name = 'Human Resources' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Creation of a Wholistic People Strategy', NULL, 'HR Manager ', 'IFGAB', NULL, NULL, 'Infrastructure', 0 FROM departments d WHERE d.name = 'Human Resources' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Benefits Enrollment Automation', NULL, 'HR Manager ', 'IED', 'High', NULL, NULL, 0 FROM departments d WHERE d.name = 'Human Resources' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Manager Toolkit on Sharepoint', NULL, 'HR Manager ', 'IED', NULL, NULL, NULL, 0 FROM departments d WHERE d.name = 'Human Resources' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Improve/Create HR Section on Sharepoint ', NULL, 'HR Manager / IT Manager', 'IED', NULL, NULL, NULL, 0 FROM departments d WHERE d.name = 'Human Resources' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Improve Onboarding Process (Training/90-day Reviews)', NULL, 'HR Manager ', 'IED', NULL, NULL, NULL, 0 FROM departments d WHERE d.name = 'Human Resources' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Creating Executive Compensation Package', NULL, 'HR Manager ', 'IGB/IFGAB', NULL, NULL, NULL, 0 FROM departments d WHERE d.name = 'Human Resources' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Creating an ICHQ Retirement Plan', NULL, 'HR Manager ', 'IGB/IED/IFGAB', NULL, NULL, NULL, 0 FROM departments d WHERE d.name = 'Human Resources' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'IT Infrastructure Plan (new architecture)', NULL, 'IT Department', 'IED', 'High', 'FY25-Q2', 'Based on system choice', 0 FROM departments d WHERE d.name = 'Technology' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Reorganize Existing Sharepoint and Permissions in Preparation for the implementation of Co-Pilot', NULL, 'IT Manager ', 'IED', 'Medium', 'FY25- Q4', 'AI intergration', 0 FROM departments d WHERE d.name = 'Technology' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Refurbish Website for ICHQ', 'External Engagement', 'IT Manager ', 'IED', 'High', 'FY26 - Q1', 'Based on system choice', 0 FROM departments d WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, '200 SOP''S with Executive Sponsors Identified By June 30, 2026', 'Operations', 'Operations', 'IED', 'High', 'FY26 - Q4', NULL, 0 FROM departments d WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Revenue Generation by Online Ad Marketing and Donation', 'Operations', 'Operations/Project Manager', NULL, 'High', 'FY25- Q1', NULL, 0 FROM departments d WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Clarify Executive Sponsors for ICHQ Roles', 'Training', 'Operations', 'IED', 'Medium', 'FY25-Q2', NULL, 0 FROM departments d WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Continuity of Operations Plan for Succession in Emergencies', 'Operations', 'Operations/Legal', 'ILA', 'Medium', 'FY25-Q2', NULL, 0 FROM departments d WHERE d.name = 'Operations / Membership Services' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Strengthen Internal Controls and provide enhanced visibility for potential risks by:', NULL, 'Finance Manager', 'IGT', 'High', NULL, NULL, 0 FROM departments d WHERE d.name = 'Finance' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, '1. Approval process for travel booked outside of Routespring', NULL, 'IED', 'IGB', 'High', 'FY25 - Q3', NULL, 0 FROM departments d WHERE d.name = 'Finance' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, '2. Cost benefit analysis on several processes and procedures', NULL, 'Finance Manager', 'IGT', 'Medium', NULL, NULL, 0 FROM departments d WHERE d.name = 'Finance' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Implement Grand Chapter''s Decision on ICHQ ', 'Operations', 'IED', 'IGB', 'High', 'FY25- Q1', NULL, 0 FROM departments d WHERE d.name = 'Office of the ED' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Implementation of the Headquarters Awards to encourage more donations ', 'External Engagement', 'IED /Juneann', 'IGT/IGG', NULL, NULL, NULL, 0 FROM departments d WHERE d.name = 'Office of the ED' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Support International Leadership Training and Development ', 'Training', 'IED', 'IGB', NULL, NULL, 'Leadership Institute  Low Cost/High Impact ', 0 FROM departments d WHERE d.name = 'Office of the ED' LIMIT 1;
INSERT INTO strategic_projects (department_id, project_title, strategic_area, ichq_lead, executive_sponsor, priority_level, timeframe_label, notes, is_complete) SELECT d.id, 'Implementation of Chapter Spot ', 'Operations', 'IED/IT Manager', 'IGB', NULL, 'FY26 - Q1', '15 months', 0 FROM departments d WHERE d.name = 'Office of the ED' LIMIT 1;