INSERT INTO forms (name, description) VALUES
	('CommCare', 'Community Care Program Application'),
	('TravelTime', 'Application for Reimbursement for Traveling');

INSERT INTO divisions (name) VALUES
	('DOR'),
	('ET&T'),
	('SP&R'),
	('Shared Services'),
	('Retail'),
	('Finance & Corporate'),
	('Office of the MD'),
	('Human Resources');


INSERT INTO reccs (name, acronym, ord) VALUES
	('Sydney', 'SYD', 1),
	('North', 'NTH', 2),
	('South', 'STH', 3),
	('West', 'WST', 4),
	('Central Coast', 'CCT', 5),
	('Lower Hunter', 'LHT', 6),
	('Upper Hunter', 'UHT', 7);

INSERT INTO states (acronym, name) VALUES
	('ACT', 'Australian Capital Territory'),
	('NSW', 'New South Wales'),
	('NT', 'Northern Territory'),
	('QLD', 'Queensland'),
	('SA', 'South Australia'),
	('TAS', 'Tasmania'),
	('VIC', 'Victoria'),
	('WA', 'Western Australia');

INSERT INTO commcare_justifications (justification, ord) VALUES
    ('Organisation operates outside of Australia', 1),
    ('Individual', 2),
    ('Church or religious group', 3),
    ('Political party / association', 4),
    ('Trade or business association', 5),
    ('Social club', 6),
    ('Organisation discriminates on race, gender, religion or other legally protected classification', 7),
    ('Sporting organisation', 8),
    ('3rd application', 9),
    ('4th application', 10),
    ('Electrical job application approved', 11);

INSERT INTO commcare_org_purposes (purpose, ord) VALUES
	('Animal Welfare', 1), ('Arts & Culture', 2), ('Education', 3),
	('Emergency Services', 4), ('Environment / Construction', 5), ('Health', 6),
	('November', 7), ('Social Welfare', 8), ('Youth Programs / Services', 9), ('Other', 10);

INSERT INTO commcare_grant_uses (grant_use, ord) VALUES
	('Funding for awareness campaigns', 1), ('Funding for charity events', 2), ('Funding research', 3),
	('Purchasing general equipment', 4), ('Purchasing safety equipment', 5), ('Purchasing sporting equipment', 6), ('Purchasing toys', 7),
	('Supported travel trips for the clubs / groups', 8), ('Other', 9);

INSERT INTO commcare_volunteer_roles (role, ord) VALUES
	('Administration / Clerical', 1), ('Coach', 2), ('Co-orindator', 3),
	('Event assistance', 4), ('Fundraiser', 5), ('One - off event participant', 6),
	('President', 7), ('Registrations', 8), ('Secretary', 9),
	('Support', 10), ('Volunteer', 11), ('Other', 12);

INSERT INTO document_groups (name) VALUES
	('CommCare RECC User Docs'),
	('CommCare Marketing Docs');

INSERT INTO documents (name, description, filepath, document_group) VALUES
	('Some RECC Document', 'Blah', 'path/to/file', 1),
	('Some Other RECC Document', 'Bleh', 'path/to/other/file', 1),
	('Some Marketing Doc', 'Hmmm', 'path/to/fake/doc', 2),
	('Some Other Marketing Doc', 'Hmmmmm', 'path/to/fake/doc2', 2);

INSERT INTO commcare_budgets (recc_id, year, month, amount) VALUES
	(1, 2010, 7, 5000),
	(1, 2010, 8, 6000),
	(1, 2010, 9, 4000),
	(1, 2010, 10, 6000),
	(1, 2010, 11, 4000),
	(1, 2010, 12, 3500),
	(1, 2010, 1, 2500),
	(1, 2010, 2, 5000),
	(1, 2010, 3, 5000),
	(1, 2010, 4, 5000),
	(1, 2010, 5, 5000),
	(1, 2010, 6, 5000),
	(2, 2010, 7, 1000),
	(2, 2010, 8, 8000),
	(2, 2010, 9, 9000),
	(2, 2010, 10, 2000),
	(2, 2010, 11, 3000),
	(2, 2010, 12, 3500),
	(2, 2010, 1, 2200),
	(2, 2010, 2, 1000),
	(2, 2010, 3, 7200),
	(2, 2010, 4, 3000),
	(2, 2010, 5, 5500),
	(2, 2010, 6, 4000);

INSERT INTO traveltime_transport_types (acronym, name) VALUES
	('EAV', 'EA Vehicle'),
	('PVT', 'Private'),
	('PUB', 'Public'),
	('TAX', 'Taxi');

INSERT INTO traveltime_duty_types (acronym, name) VALUES
	('ND', 'Normal Day/Shift'),
	('CO', 'Call Out'),
	('OT', 'Over Time');

INSERT INTO paygrades (name, rate, parent_paygrade) VALUES
	('A', 1.00, NULL),
	('A-001', 1.00, 1),
	('A-002', 1.00, 1),
	('A-003', 1.00, 1),
	('A-004', 1.00, 1),
	('B', 1.00, NULL),
	('C', 1.00, NULL),
	('C-001', 1.00, 7),
	('C-002', 1.00, 7),
	('D', 1.00, NULL),
	('E', 1.00, NULL);
