INSERT INTO change_reason_categories (id, name) VALUES
	(1, 'Temporary Assignment'),
	(2, 'Rotational Staff'),
	(3, 'Others');

INSERT INTO change_reasons (id, code, name, category_id) VALUES
	(1, 'acting_for', 'Acting For', 1),
	(2, 'on_loan', 'On Loan', 1),
	(3, 'secondment', 'Secondment', 1),
	(4, 'end_of_secondment', 'End of Secondment', 1),
	(5, 'apprentice', 'Apprentice', 2),
	(6, 'cadet', 'Cadet', 2),
	(7, 'graduate', 'Graduate', 2),
	(8, 'training', 'Training', 2),
	(9, 'work_experience', 'Work Experience', 2),
	(10, 'fixed_term', 'Fixed Term Extension', 3),
	(11, 'internal_hire', 'Internal Hire', 3),
	(12, 'status_change', 'Change of Emp Status, Hrs or Work Schedule', 3),
	(13, 'engr_movement', 'Band 2 Engineer Movement', 2);

INSERT INTO statuses (id, code, name, requires_reason) VALUES
	(1, 'pending', 'Pending', 0),
	(2, 'declined_manager', 'Declined', 1),
	(3, 'approved', 'Approved', 0),
	(4, 'completed', 'Completed', 0),
	(5, 'declined_hr', 'Declined', 1);

INSERT INTO employee_groups (id, name) VALUES
	(1, 'Permanent Full Time'),
	(2, 'Permanent Part Time'),
	(3, 'Fixed term Full-time'),
	(4, 'Fixed term Part-time'),
	(5, 'Casual Employee'),
	(6, 'Indirect Labour'),
	(7, 'Other');

INSERT INTO employee_subgroups (id, name) VALUES
	(1, 'Senior Contract'),
	(2, 'Enterprise Agreement'),
	(3, 'PM&S Agreement'),
	(4, 'Engineers'' Agreement'),
	(5, 'Exec Asst Agreement'),
	(6, 'Commercial Graduate'),
	(7, 'Labour Agreement'),
	(8, 'Contracted Services'),
	(9, 'Other'),
	(10, 'Director'),
	(11, 'Paid Internship'),
	(12, 'Unpaid Work Exp.');

INSERT INTO employee_group_pairings (group_id, subgroup_id) VALUES
	(1, 1),
	(1, 2),
	(1, 3),
	(1, 4),
	(1, 5),
	(1, 6),
	(2, 1),
	(2, 2),
	(2, 3),
	(2, 4),
	(2, 5),
	(2, 6),
	(3, 1),
	(3, 2),
	(3, 3),
	(3, 4),
	(3, 5),
	(3, 6),
	(4, 1),
	(4, 2),
	(4, 3),
	(4, 4),
	(4, 5),
	(4, 6),
	(5, 2),
	(5, 4),
	(5, 5),
	(6, 7),
	(6, 8),
	(6, 9),
	(7, 10),
	(7, 11),
	(7, 12);

INSERT INTO work_schedule_rules (id, name) VALUES
	(1, '15 Hour Week'),
	(2, '16 Hour Week'),
	(3, '18 Hour Week'),
	(4, '19 Day Month'),
	(5, '20 Hour Week'),
	(6, '24 Hour Week'),
	(7, '25 Hour Week'),
	(8, '25.2 Hour Week'),
	(9, '32 Hour Week'),
	(10, '6 Day Shift'),
	(11, '7 Day Shift'),
	(12, '7.2 Hours 3 Day Week'),
	(13, '7.2 hours 4 day week'),
	(14, '7.2hr *2 Days'),
	(15, '8 Hour Week'),
	(16, '9 HR 4 Day (ULM)'),
	(17, '9DF Major RDO Fri'),
	(18, '9DF Major RDO Mon'),
	(19, '9DF Major RDO Wed'),
	(20, '9DF Minor RDO Fri'),
	(21, '9DF Minor RDO Mon'),
	(22, '9DF Minor RDO Thu'),
	(23, '9DF Minor RDO Tue'),
	(24, '9DF Minor RDO Wed'),
	(25, 'CONT 7.30ST 15:30ET'),
	(26, 'DIRECTOR'),
	(27, 'Full time 35 Hour Week'),
	(28, 'Full Time 36 hr week'),
	(29, 'Hrs Booked Unlimited'),
	(30, 'HRSULM 35 Hour Week');

INSERT INTO rdo_types (id, name) VALUES
	(1, 'Minor'),
	(2, 'Major');
