July 26, 2016 at 11:02 am
I have what I think is a bit of a twist to the typical recursive query. I'm having some trouble getting what I want and could use a bit of a hand.
I have a table of organization structure which you can see by running the build/insert script below (The whole dataset is 441 rows).
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Business_Unit]') AND type in (N'U'))
DROP TABLE [dbo].[Business_Unit]
CREATE TABLE [dbo].[Business_Unit](
[Business_Unit_Code] [varchar](10) NOT NULL,
[Business_Unit_Name] [varchar](60) NOT NULL,
[Effective_Date] [date] NULL,
[Obsolte_Date] [date] NULL,
[Business_Unit_Level] [int] NOT NULL,
[Business_Unit_Level_Name] [varchar](11) NULL,
[Parent_Business_Unit_Code] [varchar](10) NULL
)
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000000, 'Chairman', '2014-02-21', '', 1, 'Division', '')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000001, 'Board of Directors', '2013-12-06', '', 1, 'Division', '')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000002, 'Hearing Commissioners', '2013-12-06', '', 1, 'Division', '')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000003, 'Office of the President and CEO', '2013-12-06', '2014-02-14', 1, 'Division', '')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000008, 'Office of the President & CEO', '2014-02-21', '', 1, 'Division', '')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000009, 'Legal', '2013-12-06', '', 1, 'Division', '')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000010, 'Office of Public Affairs', '2013-12-06', '2015-05-01', 1, 'Division', '')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000011, 'Corporate Services Division', '2013-12-06', '', 1, 'Division', '')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000012, 'Stakeholder & Government Engagement', '2013-12-06', '', 1, 'Division', '')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000013, 'Operations Division', '2013-09-13', '', 1, 'Division', '')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000014, 'Strategy & Regulatory Division', '2013-12-06', '', 1, 'Division', '')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101801, 'Hearing Services', '2015-04-03', '', 1, 'Division', '')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000004, 'Administrative Services', '2013-12-06', '', 2, 'Branch', '50000011')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000005, 'Information Collection & Dissemination', '2013-12-06', '2014-02-14', 2, 'Branch', '50000011')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000016, 'Information Services', '2013-12-06', '', 2, 'Branch', '50000011')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000017, 'Finance Branch', '2013-12-06', '', 2, 'Branch', '50000011')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000018, 'Internal Audit Services', '2013-12-06', '', 2, 'Branch', '50000011')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000019, 'People And Culture', '2013-12-06', '', 2, 'Branch', '50000011')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000020, 'Alberta Stakeholder Engagement', '2013-12-06', '', 2, 'Branch', '50000012')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000021, 'Oil Sands and Coal Branch', '2013-09-13', '2014-02-21', 2, 'Branch', '50000013')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000022, 'Field and Operations Branch', '2013-12-06', '2014-03-14', 2, 'Branch', '50000013')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000023, 'Geology, Environment and Reserves Branch', '2013-12-06', '2014-03-14', 2, 'Branch', '50000013')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000024, 'Applications Branch', '2013-12-06', '2014-02-14', 2, 'Branch', '50000013')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000025, 'Regulatory Development Branch', '2013-12-06', '2014-02-14', 2, 'Branch', '50000014')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000026, 'Office of Regulatory Enhancement', '2013-12-06', '2014-03-14', 2, 'Branch', '50000014')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101346, 'National/International S&GR', '2013-12-06', '', 2, 'Branch', '50000012')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101378, 'Alberta Government Engagement', '2013-12-13', '', 2, 'Branch', '50000012')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101382, 'Public Affairs', '2013-12-06', '2015-05-01', 2, 'Branch', '50000010')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101746, 'Oil & Gas', '2014-02-21', '2014-10-31', 2, 'Branch', '50000013')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101755, 'In Situ', '2014-02-21', '2014-10-31', 2, 'Branch', '50000013')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101762, 'Mining', '2014-02-21', '2014-10-31', 2, 'Branch', '50000013')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101769, 'Environment & Operational Performance', '2014-02-21', '', 2, 'Branch', '50000013')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101794, 'Authorizations', '2014-02-21', '', 2, 'Branch', '50000013')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101830, 'Closure & Liability', '2014-02-21', '', 2, 'Branch', '50000013')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101843, 'Regulatory Development & Economics', '2014-02-21', '', 2, 'Branch', '50000014')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101850, 'Major Projects & Transformation', '2014-02-21', '', 2, 'Branch', '50000014')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101851, 'Enterprise Planning', '2015-07-03', '', 2, 'Branch', '50000014')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101863, 'Reserves & Resources', '2014-02-21', '', 2, 'Branch', '50000014')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101864, 'Alberta Geological Survey', '2015-05-08', '', 2, 'Branch', '50000014')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101895, 'Information Management', '2014-02-21', '', 2, 'Branch', '50000011')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102348, 'Legal Counsel', '2014-02-21', '2014-02-21', 2, 'Branch', '50000009')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103276, 'Business Continuity Program', '2014-10-31', '2015-06-19', 2, 'Branch', '50000011')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103306, 'Industry Operations', '2014-11-07', '', 2, 'Branch', '50000013')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103326, 'Tailings Management Framework', '2014-11-07', '2015-06-26', 2, 'Branch', '50000014')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103556, 'Environmental Science Program', '2015-01-23', '', 2, 'Branch', '50000012')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104207, 'Centre of Regulatory Excellence', '2015-07-17', '', 2, 'Branch', '50000012')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104486, 'Climate Policy Assurance', '2015-11-27', '', 2, 'Branch', '50000014')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104722, 'Strategy Development', '2016-05-27', '', 2, 'Branch', '50000014')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000027, 'Infrastructure Services Group', '2014-05-02', '2014-08-01', 3, 'Group', '50000027')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000030, 'Oil Sands Advisory', '2013-12-06', '2014-02-14', 3, 'Group', '50000030')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000031, 'Oil Sands and Coal Mining Group', '2013-12-06', '2014-02-21', 3, 'Group', '50000031')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000032, 'In Situ Oil Sands Group', '2013-09-13', '2014-02-14', 3, 'Group', '50000032')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000033, 'Advisory, Operational Services & Support', '2013-12-06', '2014-02-14', 3, 'Group', '50000033')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000034, 'Emergency Management Group', '2013-12-06', '2014-02-14', 3, 'Group', '50000034')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000035, 'Field Operations Group', '2013-12-06', '2014-03-14', 3, 'Group', '50000035')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000036, 'Liability Management Group', '2013-12-06', '2014-02-14', 3, 'Group', '50000036')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000037, 'Technical Operations Group', '2013-12-06', '2014-02-14', 3, 'Group', '50000037')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000038, 'Regional Engagement', '2013-12-06', '', 3, 'Group', '50000038')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000039, 'Alberta Geological Survey Group', '2013-12-06', '2014-03-14', 3, 'Group', '50000039')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000040, 'Energy Resource Appraisal Group', '2013-12-06', '2014-02-14', 3, 'Group', '50000040')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000041, 'Regulatory Outcomes and Delivery Group', '2013-12-06', '2014-02-14', 3, 'Group', '50000041')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000042, 'Oil and Gas Reserves Group', '2013-12-06', '2014-02-14', 3, 'Group', '50000042')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000043, 'Business Operations & Development Group', '2013-12-06', '2014-02-14', 3, 'Group', '50000043')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000044, 'Facilities Applications Group', '2013-12-06', '2014-02-14', 3, 'Group', '50000044')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000045, 'Resources Applications Group', '2013-12-06', '2014-02-14', 3, 'Group', '50000045')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000075, 'Corporate & Financial Reporting', '2013-12-06', '', 3, 'Group', '50000075')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000076, 'Compensation', '2014-04-11', '2014-04-25', 3, 'Group', '50000076')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000077, 'Occupational Health and Safety', '2013-12-06', '', 3, 'Group', '50000077')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000078, 'Organizational Effectiveness', '2013-12-06', '', 3, 'Group', '50000078')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000079, 'Total Rewards', '2013-12-06', '', 3, 'Group', '50000079')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000080, 'Client Services', '2013-12-06', '', 3, 'Group', '50000080')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000081, 'Customer Contact Center', '2013-12-06', '2014-02-14', 3, 'Group', '50000081')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000082, 'Library and Records Services', '2013-12-06', '2014-02-14', 3, 'Group', '50000082')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000084, 'Workplace Services', '2013-12-06', '', 3, 'Group', '50000084')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000086, 'Procurement', '2013-12-06', '', 3, 'Group', '50000086')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000087, 'Printing and Mail', '2013-12-06', '2014-02-14', 3, 'Group', '50000087')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000134, 'Regulatory Engagement', '2013-12-06', '', 3, 'Group', '50000134')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000150, 'Data Compliance Services', '2013-12-06', '2014-02-14', 3, 'Group', '50000150')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000156, 'Core Research Center', '2013-12-06', '2014-02-14', 3, 'Group', '50000156')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000162, 'Information Dissemination Services', '2013-12-06', '2014-02-14', 3, 'Group', '50000162')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000168, 'Business Enablement Services', '2013-12-06', '2014-02-14', 3, 'Group', '50000168')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000172, 'Business Operations Excellence', '2013-12-06', '2014-02-14', 3, 'Group', '50000172')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101301, 'Chief Technology Office', '2013-12-06', '', 3, 'Group', '50101301')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101302, 'Office of the CIO', '2013-12-06', '', 3, 'Group', '50101302')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101307, 'Compliance & Security', '2014-02-21', '2014-10-17', 3, 'Group', '50101307')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101376, 'Design & Multimedia', '2013-12-06', '2015-05-01', 3, 'Group', '50101376')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101377, 'Finance', '2013-12-06', '', 3, 'Group', '50101377')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101381, 'Energy Statistics and Forecasting', '2013-12-06', '2014-02-14', 3, 'Group', '50101381')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101383, 'Strategic Planning & Advice', '2013-12-06', '2015-05-01', 3, 'Group', '50101383')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101384, 'Internal & Corporate Communications', '2013-12-06', '2015-05-01', 3, 'Group', '50101384')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101385, 'Editing Services OPA Integration', '2013-12-06', '2015-05-01', 3, 'Group', '50101385')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101613, 'Indigenous Engagement', '2013-12-06', '', 3, 'Group', '50101613')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101729, 'Engagement Practice', '2014-01-03', '2015-09-04', 3, 'Group', '50101729')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101748, 'Oil & Gas Operations', '2014-02-21', '2014-10-31', 3, 'Group', '50101748')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101752, 'Oil & Gas Technical', '2014-02-21', '2014-10-31', 3, 'Group', '50101752')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101756, 'In Situ Operations', '2014-02-21', '2014-10-31', 3, 'Group', '50101756')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101760, 'In Situ Technical', '2014-02-21', '2014-10-31', 3, 'Group', '50101760')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101763, 'Mining Operations', '2014-02-21', '2014-10-31', 3, 'Group', '50101763')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101767, 'Mining Technical', '2014-02-21', '2014-10-31', 3, 'Group', '50101767')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101772, 'Enforcement & Surveillance Comp Audit', '2014-02-21', '', 3, 'Group', '50101772')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101778, 'Enforcement & Surveillance W (Oil & Gas)', '2014-02-21', '', 3, 'Group', '50101778')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101783, 'Enforcement & Surveillance E (Oil & Gas)', '2014-02-21', '', 3, 'Group', '50101783')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101788, 'Enforcement & Surv (In Situ/Heavy Oil)', '2014-02-21', '', 3, 'Group', '50101788')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101791, 'Enforcement & Surveillance (M&EM&DS)', '2014-02-21', '', 3, 'Group', '50101791')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101797, 'Continuous Improvement', '2014-02-21', '', 3, 'Group', '50101797')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101802, 'Surface Authorizations (Oil & Gas)', '2014-02-21', '2016-06-10', 3, 'Group', '50101802')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101807, 'Subsurface Authorizations (Oil & Gas)', '2014-02-21', '', 3, 'Group', '50101807')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101813, 'Infrastructure Authorizations(Oil & Gas)', '2014-02-21', '', 3, 'Group', '50101813')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101819, 'In Situ Authorizations', '2014-02-21', '', 3, 'Group', '50101819')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101825, 'Mining Authorizations', '2014-02-21', '', 3, 'Group', '50101825')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101831, 'Closure & Liability Oil & Gas', '2014-02-21', '', 3, 'Group', '50101831')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101833, 'Closure & Liability (Oil & Gas)', '2014-02-21', '2015-05-15', 3, 'Group', '50101833')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101838, 'Closure & Liability (In Situ)', '2014-02-21', '', 3, 'Group', '50101838')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101840, 'Closure & Liability (Mining)', '2014-02-21', '', 3, 'Group', '50101840')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101844, 'Regulatory Operations', '2014-02-21', '2015-06-26', 3, 'Group', '50101844')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101847, 'Energy Statistics & Forecasting', '2014-02-21', '2014-03-07', 3, 'Group', '50101847')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101848, 'Energy Statistics', '2014-03-14', '2015-06-05', 3, 'Group', '50101848')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101849, 'Energy Forecasting', '2014-03-14', '2015-06-05', 3, 'Group', '50101849')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101852, 'Corporate Planning', '2015-07-03', '2016-04-01', 3, 'Group', '50101852')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101853, 'Enterprise Risk Management', '2015-07-03', '', 3, 'Group', '50101853')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101854, 'Enterprise Planning and Performance', '2015-07-03', '', 3, 'Group', '50101854')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101855, 'Enterprise Projects', '2014-02-21', '2015-01-09', 3, 'Group', '50101855')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101856, 'AER Transformation & BIC', '2015-01-16', '', 3, 'Group', '50101856')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101858, 'PBR', '2015-01-16', '', 3, 'Group', '50101858')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101859, 'AER Transition Project', '2015-01-16', '2015-07-31', 3, 'Group', '50101859')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101861, 'IRMS', '2015-01-16', '2015-06-26', 3, 'Group', '50101861')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101862, 'Enterprise Project Management Office', '2015-07-03', '', 3, 'Group', '50101862')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101866, 'Groundwater Inventory & Basin Analysis', '2015-05-08', '2016-06-10', 3, 'Group', '50101866')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101869, 'Landscapes & Geological Hazards', '2015-05-08', '2016-06-10', 3, 'Group', '50101869')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101870, 'Environmental Management', '2014-02-21', '2014-03-28', 3, 'Group', '50101870')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101874, 'Reserves', '2014-02-21', '', 3, 'Group', '50101874')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101880, 'Corporate Security', '2014-02-21', '', 3, 'Group', '50101880')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101890, 'Program Delivery and Partner Engagement', '2014-02-21', '', 3, 'Group', '50101890')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101896, 'Material Viewing & Storage Facilities', '2014-02-21', '', 3, 'Group', '50101896')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101900, 'Information Distribution Services', '2014-02-21', '', 3, 'Group', '50101900')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101906, 'Regulatory Submission & Compliance', '2014-02-21', '', 3, 'Group', '50101906')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101910, 'Information Business Excellence', '2014-02-21', '', 3, 'Group', '50101910')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101912, 'National/International S&GR', '2014-02-21', '', 3, 'Group', '50101912')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102700, 'Media & Issues Management', '2014-04-25', '2015-05-01', 3, 'Group', '50102700')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102818, 'Government Engagement', '2014-05-09', '', 3, 'Group', '50102818')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102832, 'Petroleum Systems & Earth Resources', '2015-05-08', '2016-06-10', 3, 'Group', '50102832')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102833, 'Risk Management', '2014-05-16', '2014-09-26', 3, 'Group', '50102833')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102840, 'Bedrock Geological Framework', '2015-05-08', '2016-06-10', 3, 'Group', '50102840')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102841, 'Mapping', '2015-05-08', '2016-06-10', 3, 'Group', '50102841')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103164, 'Information Programs & Standards', '2014-09-26', '', 3, 'Group', '50103164')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103252, 'Risk, Security & Enterprise Architecture', '2014-10-24', '', 3, 'Group', '50103252')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103311, 'Mining & In Situ', '2014-11-07', '', 3, 'Group', '50103311')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103313, 'Oil & Gas', '2014-11-07', '', 3, 'Group', '50103313')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103320, 'Mining', '2014-11-07', '2016-03-25', 3, 'Group', '50103320')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103322, 'Pipelines', '2014-11-07', '', 3, 'Group', '50103322')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103336, 'New Authorizations', '2014-11-07', '', 3, 'Group', '50103336')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103450, 'Land Use Authorizations', '2015-01-23', '', 3, 'Group', '50103450')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103627, 'New Business Capabilities', '2015-03-20', '', 3, 'Group', '50103627')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104113, 'Compliance and Enforcement, Env. & Op.', '2015-06-05', '', 3, 'Group', '50104113')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104151, 'Regulatory Development', '2015-06-12', '', 3, 'Group', '50104151')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104184, 'Technical Advisory, Corporate Planning', '2015-07-03', '', 3, 'Group', '50104184')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104185, 'Energy Statistics and Forecasting', '2015-07-03', '', 3, 'Group', '50104185')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104226, 'Organizational Change Management', '2015-07-31', '', 3, 'Group', '50104226')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104272, 'Future Concepts', '2015-09-04', '2015-11-13', 3, 'Group', '50104272')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104430, 'CoRE', '2015-11-20', '', 3, 'Group', '50104430')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104657, 'OEMS', '2016-04-15', '', 3, 'Group', '50104657')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104751, 'Applied Geosciences', '2016-06-17', '', 3, 'Group', '50104751')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104755, 'Mapping and Modeling', '2016-06-17', '', 3, 'Group', '50104755')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104779, 'Strategy Group', '2016-05-27', '', 3, 'Group', '50104779')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000006, 'Applications and Data Services', '2013-12-06', '', 4, 'Section', '50101301')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000062, 'Service Desk', '2014-05-02', '', 4, 'Section', '50101890')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000066, 'IS Business Services', '2013-12-06', '2014-05-02', 4, 'Section', '50101302')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000071, 'Business Analysis Services', '2014-02-21', '', 4, 'Section', '50101890')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000073, 'Branch Financial Services', '2013-12-06', '', 4, 'Section', '50101377')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000074, 'Centralized Financial Services', '2013-12-06', '', 4, 'Section', '50101377')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000088, 'Applications', '2013-12-06', '2014-02-14', 4, 'Section', '50000032')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000089, 'Geology', '2013-12-06', '2014-02-14', 4, 'Section', '50000032')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000090, 'Administrative Support', '2013-12-06', '2014-02-14', 4, 'Section', '50000031')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000091, 'Applications Coal and Major', '2013-12-06', '2014-02-14', 4, 'Section', '50000031')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000092, 'Applications Operational', '2013-12-06', '2014-02-14', 4, 'Section', '50000031')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000093, 'Applications Surveillance', '2013-12-06', '2014-02-14', 4, 'Section', '50000031')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000094, 'Senior Regulatory Office', '2013-12-06', '2014-02-14', 4, 'Section', '50000033')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000096, 'Compliance Assurance', '2013-12-06', '2014-02-14', 4, 'Section', '50000033')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000097, 'Advisory and Project', '2013-12-06', '2014-02-14', 4, 'Section', '50000033')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000098, 'Business Analysis Systems and Support', '2013-12-06', '2014-02-14', 4, 'Section', '50000033')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000099, 'Emergency Preparedness and Audit', '2013-12-06', '2014-02-14', 4, 'Section', '50000034')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000100, 'Field Incident Response and Support', '2013-12-06', '2014-02-14', 4, 'Section', '50000034')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000112, 'Operations', '2013-12-06', '2014-02-14', 4, 'Section', '50000036')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000113, 'Advisory', '2013-12-06', '2014-02-14', 4, 'Section', '50000036')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000114, 'Pipeline Operations', '2013-12-06', '2014-02-14', 4, 'Section', '50000037')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000115, 'Production Operations', '2013-12-06', '2014-02-14', 4, 'Section', '50000037')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000116, 'Well Operations', '2013-12-06', '2014-02-14', 4, 'Section', '50000037')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000117, 'Applied Geosciences', '2013-12-06', '2014-02-14', 4, 'Section', '50000039')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000119, 'Edmonton Administrative Services Team', '2013-12-06', '2014-02-14', 4, 'Section', '50000039')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000120, 'Edmonton Field and Laboratory Services', '2013-12-06', '2014-02-14', 4, 'Section', '50000039')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000121, 'Groundwater', '2013-12-06', '2014-03-14', 4, 'Section', '50000039')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000122, 'Office of the Provincial Geologist', '2013-12-06', '2014-02-14', 4, 'Section', '50000039')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000123, 'Quarternary Geology', '2013-12-06', '2014-02-14', 4, 'Section', '50000039')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000125, 'Resource Plays Geology', '2013-12-06', '2014-02-14', 4, 'Section', '50000040')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000126, 'Plays Characterization and Integration', '2013-12-06', '2014-02-14', 4, 'Section', '50000040')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000127, 'Resource Geoscience and Estimation', '2013-12-06', '2014-02-14', 4, 'Section', '50000040')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000128, 'Regulatory Outcomes', '2013-12-06', '2014-02-14', 4, 'Section', '50000041')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000129, 'Regulatory Delivery', '2013-12-06', '2014-02-14', 4, 'Section', '50000041')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000130, 'Applications and Hearing Support', '2013-12-06', '2014-02-14', 4, 'Section', '50000041')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000131, 'Oil Reserves', '2013-12-06', '2014-02-14', 4, 'Section', '50000042')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000132, 'Gas Reserves', '2013-12-06', '2014-02-14', 4, 'Section', '50000042')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000133, 'Reserves Administration', '2013-12-06', '2014-02-14', 4, 'Section', '50000042')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000135, 'Business Operations and Support', '2013-12-06', '2014-02-14', 4, 'Section', '50000043')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000136, 'Business Systems and Process Specialists', '2013-12-06', '2014-02-14', 4, 'Section', '50000043')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000142, 'Reservoir Development', '2013-12-06', '2014-02-14', 4, 'Section', '50000045')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000143, 'Surveillance', '2013-09-13', '2014-02-14', 4, 'Section', '50000032')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000144, 'Reservoir Engineering', '2013-12-06', '2014-02-14', 4, 'Section', '50000045')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000145, 'Waste and Storage', '2013-12-06', '2014-02-14', 4, 'Section', '50000045')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000151, 'DCS - Well Data Services', '2013-12-06', '2014-02-14', 4, 'Section', '50000150')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000152, 'DCS - Well Test and Log Compliance', '2013-12-06', '2014-02-14', 4, 'Section', '50000150')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000153, 'DCS - Production Accounting', '2013-12-06', '2014-02-14', 4, 'Section', '50000150')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000154, 'DCS - Core, Drill Cuttings and Tours', '2013-12-06', '2014-02-14', 4, 'Section', '50000150')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000157, 'CRC - Customer Services and Sales', '2013-12-06', '2014-02-14', 4, 'Section', '50000156')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000158, 'CRC - Material Handling', '2013-12-06', '2014-02-14', 4, 'Section', '50000156')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000159, 'CRC - Drilling & Completion Report Proce', '2013-12-06', '2014-02-14', 4, 'Section', '50000156')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000163, 'IDS - Order Fulfillment', '2013-12-06', '2014-02-14', 4, 'Section', '50000162')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000165, 'IPS - Document Conversion and Redaction', '2013-12-06', '2014-02-14', 4, 'Section', '50000162')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000166, 'IPS - Product Management', '2013-12-06', '2014-02-14', 4, 'Section', '50000162')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000167, 'IPS - Spatial Data Products', '2013-12-06', '2014-02-14', 4, 'Section', '50000162')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000170, 'BES - Data Integrity', '2013-12-06', '2014-02-14', 4, 'Section', '50000168')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50100002, 'Surveillance', '2013-12-06', '2014-02-14', 4, 'Section', '50000045')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101306, 'IS Strategy Planning & Portfolio Svcs', '2014-02-21', '2014-05-02', 4, 'Section', '50101302')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101379, 'Fort McMurray', '2013-12-06', '2014-02-14', 4, 'Section', '50000031')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101380, 'Facilities Applications Group - Acting', '2013-12-06', '2014-02-14', 4, 'Section', '50000044')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101513, 'Central Field Operations', '2013-12-06', '2014-02-14', 4, 'Section', '50000035')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101514, 'Northern Field Operations', '2013-12-06', '2014-02-14', 4, 'Section', '50000035')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101515, 'Southern Field Operations', '2013-12-06', '2014-03-14', 4, 'Section', '50000035')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101517, 'Accomodations Planning', '2013-12-06', '', 4, 'Section', '50000084')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101612, 'Hearing Support', '2013-12-06', '2014-02-14', 4, 'Section', '50000043')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101730, 'Resourcing and Workforce Planning', '2014-01-03', '', 4, 'Section', '50000080')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101749, 'Industry Performance', '2014-02-21', '', 4, 'Section', '50103313')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101750, 'Industry Relations', '2014-02-21', '', 4, 'Section', '50103313')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101751, 'Regulatory Effectiveness', '2014-02-21', '', 4, 'Section', '50103322')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101754, 'Technical Resourcing', '2014-02-21', '2014-10-31', 4, 'Section', '50101752')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101757, 'Industry Relations', '2014-02-21', '', 4, 'Section', '50103311')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101758, 'Industry Performance', '2014-03-21', '', 4, 'Section', '50103311')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101759, 'Regulatory Effectiveness', '2014-02-21', '', 4, 'Section', '50103311')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101761, 'Technical Resourcing', '2014-02-21', '2015-05-29', 4, 'Section', '50103311')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101764, 'Industry Relations', '2014-06-27', '2016-03-25', 4, 'Section', '50103320')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101765, 'Regulatory Effectiveness', '2014-02-21', '2016-03-25', 4, 'Section', '50103320')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101766, 'Industry Performance', '2014-02-21', '2016-03-25', 4, 'Section', '50103320')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101768, 'Technical Resourcing', '2014-02-21', '2015-05-29', 4, 'Section', '50103320')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101773, 'Emergency Response & Preparedness', '2014-02-21', '', 4, 'Section', '50101791')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101774, 'Investigations', '2014-02-21', '', 4, 'Section', '50104113')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101775, 'Resource Compliance', '2014-02-21', '', 4, 'Section', '50101772')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101776, 'Technical & Operational Compliance', '2014-02-21', '', 4, 'Section', '50104113')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101777, 'Compliance Info., Training and Process', '2014-02-21', '', 4, 'Section', '50104113')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101779, 'Enf & Surv High Level Grande Prairie O&G', '2014-02-21', '', 4, 'Section', '50101778')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101780, 'Enf & Surv Slave Lake O&G', '2014-02-21', '2014-08-29', 4, 'Section', '50101778')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101781, 'Enf & Surv Drayton Valley O&G', '2014-02-21', '', 4, 'Section', '50101778')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101782, 'Enf. & Surv. St. Albert (Oil & Gas)', '2014-02-21', '', 4, 'Section', '50101783')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101784, 'Enf. & Surv. Red Deer (Oil & Gas)', '2014-02-21', '', 4, 'Section', '50101783')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101785, 'Enf & Surv Wainwright (Oil & Gas))', '2014-02-21', '', 4, 'Section', '50101788')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101786, 'Enf & Surv Midnapore O&G', '2014-02-21', '', 4, 'Section', '50101778')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101787, 'Enf. & Surv. Medicine Hat (Oil & Gas)', '2014-02-21', '', 4, 'Section', '50101783')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101789, 'Enf & Surv Bonnyville ast (In Situ)', '2014-02-21', '', 4, 'Section', '50101788')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101790, 'Enf & Surv Slave Lake West (In Situ)', '2014-02-21', '', 4, 'Section', '50101788')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101792, 'Enforcement & Surveillance (Coal)', '2014-02-21', '', 4, 'Section', '50101791')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101793, 'Enforcement & Surveillance (Oil Sands)', '2014-02-21', '', 4, 'Section', '50101791')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101798, 'Continuous Improvement Execution', '2014-02-21', '', 4, 'Section', '50101797')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101799, 'Continuous Improvement Analytics', '2014-02-21', '', 4, 'Section', '50101797')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101800, 'Continuous Improvement Internal Perf.', '2014-02-21', '', 4, 'Section', '50101797')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101803, 'PLA South', '2014-02-21', '2015-01-16', 4, 'Section', '50101802')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101804, 'PLA Authorizations', '2014-02-21', '2015-01-16', 4, 'Section', '50101802')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101805, 'EPEA & Water Authorizations', '2014-02-21', '', 4, 'Section', '50101813')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101806, 'Authorizations Geophysical/Seismic', '2014-02-21', '2014-11-28', 4, 'Section', '50101802')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101808, 'Reservoir Engineering', '2014-02-21', '', 4, 'Section', '50101807')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101809, 'Reservoir Development', '2014-02-21', '', 4, 'Section', '50101807')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101810, 'Authorizations Waste & Storage', '2014-02-21', '', 4, 'Section', '50101807')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101811, 'Geology', '2014-02-21', '', 4, 'Section', '50101807')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101812, 'Rate Applications', '2014-02-21', '', 4, 'Section', '50101807')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101814, 'Application Assessment', '2014-02-21', '', 4, 'Section', '50101813')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101815, 'Technical Variance and Evaluation', '2014-02-21', '', 4, 'Section', '50101813')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101816, 'Public Involvement Coordination', '2014-02-21', '', 4, 'Section', '50101813')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101817, 'Application Integrity', '2014-02-21', '', 4, 'Section', '50101813')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101818, 'Operational Authorizations', '2014-02-21', '2015-05-29', 4, 'Section', '50101813')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101821, 'Surface', '2014-02-21', '', 4, 'Section', '50101819')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101822, 'PLA', '2014-02-21', '2015-01-16', 4, 'Section', '50101819')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101823, 'Subsurface', '2014-02-21', '', 4, 'Section', '50101819')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101824, 'Water', '2014-03-21', '', 4, 'Section', '50101819')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101826, 'Coal', '2014-02-21', '', 4, 'Section', '50101825')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101827, 'Oil Sands', '2014-02-21', '', 4, 'Section', '50101825')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101828, 'PLA Northeast', '2014-02-21', '2015-01-16', 4, 'Section', '50101825')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101829, 'EPEA & Water', '2014-02-21', '', 4, 'Section', '50101825')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101832, 'Planning & Business Process', '2014-02-21', '2015-05-29', 4, 'Section', '50101831')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101834, 'Liability Management (Oil & Gas)', '2014-02-21', '', 4, 'Section', '50101831')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101835, 'Reclamation Programs', '2014-02-21', '', 4, 'Section', '50101838')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101837, 'Abandonment', '2014-02-21', '2014-08-29', 4, 'Section', '50101833')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101839, 'Land Conservation and Reclamation', '2014-02-21', '', 4, 'Section', '50101838')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101841, 'Remediation & Contaminated Sites', '2014-02-21', '', 4, 'Section', '50101840')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101842, 'Mine Financial Security Program', '2014-02-21', '', 4, 'Section', '50101838')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101845, 'Regulatory Management', '2014-02-21', '2015-11-27', 4, 'Section', '50104151')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101846, 'Regulatory Performance Design', '2014-02-21', '', 4, 'Section', '50104151')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101857, 'AER Transformation', '2015-01-16', '', 4, 'Section', '50101856')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101860, 'AER Transition', '2015-01-16', '2015-06-26', 4, 'Section', '50101859')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101865, 'Science Delivery Systems', '2014-02-21', '2014-04-25', 4, 'Section', '50101864')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101867, 'Petroleum & Earth Resources', '2014-02-21', '2014-04-25', 4, 'Section', '50101864')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101868, 'Geological Framework', '2014-02-21', '2014-04-25', 4, 'Section', '50101864')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101872, 'Air Tracking, Projection & Analysis', '2014-02-21', '2014-03-28', 4, 'Section', '50101870')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101875, 'Conventional', '2014-02-21', '', 4, 'Section', '50101874')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101876, 'Operations & Business Process Management', '2014-02-21', '', 4, 'Section', '50101874')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101877, 'Cretaceous Plays', '2014-02-21', '', 4, 'Section', '50101874')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101878, 'Devonian - Jurassic Plays', '2014-02-21', '', 4, 'Section', '50101874')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101897, 'Warehouse Ops, Calgary', '2014-02-21', '', 4, 'Section', '50101896')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101898, 'Customer Requests', '2014-02-21', '', 4, 'Section', '50101896')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101899, 'Tours Repository & Processing', '2014-02-21', '', 4, 'Section', '50101896')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101901, 'Product Services, Calgary', '2014-02-21', '', 4, 'Section', '50101900')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101902, 'Reprographics', '2014-02-21', '2014-03-14', 4, 'Section', '50101900')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101903, 'Dissemination Channels', '2014-02-21', '2015-08-28', 4, 'Section', '50101900')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101904, '(SRO) Records, Library & FOIP', '2014-02-21', '2014-07-04', 4, 'Section', '50101900')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101905, 'Information & Data Integrity', '2014-02-21', '2014-09-19', 4, 'Section', '50101900')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101907, 'Production Data Services', '2014-02-21', '', 4, 'Section', '50101906')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101908, 'Well Data Services', '2014-02-21', '', 4, 'Section', '50101906')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101909, 'Geological Data Services', '2014-02-21', '2014-03-14', 4, 'Section', '50101906')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101911, 'Reporting & Planning', '2014-02-21', '', 4, 'Section', '50101910')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101913, 'Industry Relations', '2014-02-21', '2014-03-07', 4, 'Section', '50000134')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101914, 'Regional Engagement, North', '2014-03-14', '', 4, 'Section', '50000038')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101915, 'Regional Engagement, South', '2014-03-14', '', 4, 'Section', '50000038')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101916, 'Indigenous Engagement', '2014-02-21', '', 4, 'Section', '50101613')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102175, 'PLA Eastcentral', '2014-02-21', '2015-01-16', 4, 'Section', '50101825')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102176, 'PLA Northcentral', '2014-02-21', '2015-01-16', 4, 'Section', '50101825')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102177, 'PLA Northwest', '2014-02-21', '2015-01-16', 4, 'Section', '50101825')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102180, 'Audit Projects Team', '2014-02-21', '', 4, 'Section', '50101772')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102267, 'Office Services', '2014-03-21', '', 4, 'Section', '50000084')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102285, 'Routine Disclosure, FOIP & Library', '2014-09-26', '', 4, 'Section', '50101910')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102296, 'Well Logs', '2014-03-21', '', 4, 'Section', '50101906')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102297, 'CRC Compliance', '2014-03-21', '', 4, 'Section', '50101906')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102320, 'Industry Relations', '2014-02-21', '', 4, 'Section', '50103322')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102321, 'Industry Relations', '2014-02-21', '2016-01-08', 4, 'Section', '50103313')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102369, 'PLA Geomatics', '2014-02-21', '2015-01-16', 4, 'Section', '50101802')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102371, 'PLA Southcentral', '2014-02-21', '2015-01-16', 4, 'Section', '50101802')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102372, 'PLA Central', '2014-02-21', '2015-01-16', 4, 'Section', '50101802')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102395, 'Aboriginal Relations', '2014-02-21', '2015-04-24', 4, 'Section', '50101613')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102712, 'Corporate Real Estate & Insurance', '2014-04-25', '2016-03-04', 4, 'Section', '50000084')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102728, 'Drilling Waste & Contamination Mgmt', '2014-04-25', '', 4, 'Section', '50101840')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102811, 'IS Contract & Vendor Relations Mgmt', '2014-05-09', '', 4, 'Section', '50101302')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102815, 'IS Planning Management', '2014-05-09', '', 4, 'Section', '50101302')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102838, 'Customer Contact Center', '2015-08-14', '2015-12-11', 4, 'Section', '50101900')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102882, 'Document Conversion', '2014-06-06', '2014-07-04', 4, 'Section', '50101900')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102909, 'Technical Delivery Services', '2014-06-13', '', 4, 'Section', '50101890')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103035, 'Product Services, Edmonton', '2014-07-11', '2016-05-13', 4, 'Section', '50101900')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103052, 'Alternative Dispute Resolution (South)', '2014-08-15', '2015-04-24', 4, 'Section', '50101729')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103104, 'Regulatory Engagement', '2014-08-29', '', 4, 'Section', '50000134')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103132, 'Branch Administration', '2014-09-12', '', 4, 'Section', '50101910')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103152, 'Process Improvement & Operation Support', '2014-09-12', '2016-05-20', 4, 'Section', '50101910')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103167, 'Information Quality', '2014-09-26', '2016-04-15', 4, 'Section', '50103164')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103172, 'Corporate Records', '2014-09-26', '', 4, 'Section', '50103164')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103207, 'Service Improvement', '2015-07-03', '', 4, 'Section', '50101301')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103214, 'Branch Support', '2014-10-24', '', 4, 'Section', '50103450')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103247, 'Employee Service Centre', '2014-10-24', '2015-06-12', 4, 'Section', '50000079')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103279, 'Environmental Assessment', '2014-11-14', '', 4, 'Section', '50101819')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103315, 'Regulatory Effectiveness & GH', '2014-11-07', '', 4, 'Section', '50103313')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103455, 'Provincial Land Use Authorizations', '2015-01-23', '', 4, 'Section', '50103450')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103457, 'Provincial Land Use Field Authorizations', '2015-01-23', '', 4, 'Section', '50103450')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103552, 'Project Resourcing', '2015-07-03', '', 4, 'Section', '50101862')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103576, 'Issues Management', '2015-02-13', '2015-05-01', 4, 'Section', '50102700')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103643, 'New Auths Devt, Industry Engagement', '2015-04-03', '', 4, 'Section', '50103336')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103690, 'Regional Engagement, Central', '2015-05-01', '', 4, 'Section', '50000038')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104072, 'Abandonment', '2015-05-22', '', 4, 'Section', '50101831')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104109, 'Industry Performance', '2015-07-03', '', 4, 'Section', '50103322')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104110, 'Continuous Improvement Program', '2015-06-05', '', 4, 'Section', '50101797')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104114, 'Compliance Assurance', '2015-06-05', '', 4, 'Section', '50104113')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104153, 'Human Capital Systems and Metrics', '2015-06-05', '', 4, 'Section', '50000079')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104155, 'Benefits and Pensions', '2015-06-05', '', 4, 'Section', '50000079')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104156, 'Payroll', '2015-06-05', '', 4, 'Section', '50000079')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104177, 'Solution Design and Delivery', '2015-07-03', '', 4, 'Section', '50101301')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104202, 'Dam Safety', '2015-08-21', '', 4, 'Section', '50101791')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104229, 'Enterprise Content Programs', '2015-08-21', '', 4, 'Section', '50103164')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104231, 'Data Services', '2015-08-14', '', 4, 'Section', '50101900')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104338, 'Production Audit', '2015-09-25', '', 4, 'Section', '50101772')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104479, 'Facility Operations', '2015-12-18', '', 4, 'Section', '50000084')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104752, 'Geoscience Knowledge', '2016-06-17', '', 4, 'Section', '50104751')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104780, 'Strategy Team', '2016-05-27', '', 4, 'Section', '50104779')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000047, 'Project Services', '2013-12-06', '2014-06-06', 5, 'Team', '50000006')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000048, 'Data & Reporting Services', '2013-12-06', '', 5, 'Team', '50000006')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000049, 'Enterprise Content Mgmt & Portal Srvces', '2014-10-10', '', 5, 'Team', '50000006')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000050, 'Quality Assurance and Transition Service', '2015-07-03', '', 5, 'Team', '50104177')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000052, 'Regulatory Systems Services', '2013-12-06', '', 5, 'Team', '50000006')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000057, 'Infrastructure Architecture', '2013-12-06', '', 5, 'Team', '50000027')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000058, 'End User Design', '2014-05-02', '2014-05-09', 5, 'Team', '50000062')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000061, 'Infrastructure Delivery Services', '2013-12-06', '', 5, 'Team', '50000027')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000068, 'IS Business Administrative Services', '2013-12-06', '2014-02-14', 5, 'Team', '50000066')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000069, 'IS Customer Engagement', '2014-02-21', '2014-04-25', 5, 'Team', '50101306')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000101, 'Calgary Head Office Main', '2013-12-06', '2014-02-14', 5, 'Team', '50101513')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000102, 'Red Deer', '2013-12-06', '2014-02-14', 5, 'Team', '50101515')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000103, 'St. Albert', '2013-12-06', '2014-02-14', 5, 'Team', '50101514')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000104, 'Midnapore', '2013-12-06', '2014-02-14', 5, 'Team', '50101513')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000105, 'Wainwright', '2013-12-06', '2014-02-14', 5, 'Team', '50101513')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000106, 'Drayton Valley', '2013-12-06', '2014-03-14', 5, 'Team', '50101515')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000107, 'High Level', '2013-12-06', '2014-02-14', 5, 'Team', '50101514')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000108, 'Medicine Hat', '2013-12-06', '2014-02-14', 5, 'Team', '50101513')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000109, 'Bonnyville', '2013-12-06', '2014-02-14', 5, 'Team', '50101514')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000110, 'Grande Prairie', '2013-12-06', '2014-02-14', 5, 'Team', '50101514')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000118, 'Bedrock Geology', '2013-12-06', '2014-02-14', 5, 'Team', '50000123')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000146, 'Applications Routine', '2013-12-06', '2014-02-14', 5, 'Team', '50101380')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000147, 'Applications Audit', '2013-12-06', '2014-02-14', 5, 'Team', '50101380')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000148, 'Advisory', '2013-12-06', '2014-02-14', 5, 'Team', '50101380')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000149, 'Applications Non-Routine - Technical', '2013-12-06', '2014-02-14', 5, 'Team', '50101380')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50100001, 'Applications Non-Routine -Public Invlmnt', '2013-12-06', '2014-02-14', 5, 'Team', '50101380')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50101401, 'Field Technical Specialists', '2013-12-06', '2014-02-14', 5, 'Team', '50101513')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102272, 'Spatial Data Products', '2014-02-21', '2015-03-06', 5, 'Team', '50101901')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102276, 'Order Fulfillment & Routine Discloses', '2014-02-21', '2016-05-13', 5, 'Team', '50102285')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102282, 'Operations Support', '2014-02-21', '2014-09-05', 5, 'Team', '50101905')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102335, 'Service Desk & Account Provisioning', '2014-06-06', '', 5, 'Team', '50000062')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102444, 'Revenue & Cash Management', '2014-02-21', '', 5, 'Team', '50000074')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102563, 'IS Portfolio Management', '2014-02-21', '2014-05-02', 5, 'Team', '50101306')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102573, 'Expenditure Management', '2014-03-14', '', 5, 'Team', '50000073')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102858, 'End User Support', '2014-06-06', '2014-08-01', 5, 'Team', '50000062')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103155, 'Operations Support', '2014-09-12', '', 5, 'Team', '50104231')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103182, 'GEO Information Services', '2014-10-10', '', 5, 'Team', '50000006')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103235, 'COTS, Product Services', '2014-10-31', '', 5, 'Team', '50000006')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103459, 'Geomatics and Exploration', '2015-01-23', '', 5, 'Team', '50103455')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103461, 'Land Use Authorizations', '2015-01-23', '', 5, 'Team', '50103455')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103463, 'Land Use Authorizations Integration', '2015-01-23', '2015-06-19', 5, 'Team', '50103455')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103465, 'Regional Land Use (South)', '2015-01-23', '', 5, 'Team', '50103457')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103467, 'Regional Land Use (Northcentral)', '2015-01-23', '', 5, 'Team', '50103457')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103469, 'Regional Land Use (Southcentral)', '2015-01-23', '', 5, 'Team', '50103457')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103471, 'Regional Land Use (Northeast)', '2015-01-23', '', 5, 'Team', '50103457')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103473, 'Regional Land Use (Northwest)', '2015-01-23', '', 5, 'Team', '50103457')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104080, 'Intranet e Communications', '2015-06-05', '', 5, 'Team', '50101384')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104179, 'Client Computing, Mobility & Field Serv.', '2015-07-03', '', 5, 'Team', '50000027')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104191, 'Technical Specialists', '2015-07-17', '', 5, 'Team', '50101776')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104205, 'Operational Specialists', '2015-07-24', '', 5, 'Team', '50101776')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104206, 'Technical Advisors', '2015-07-24', '', 5, 'Team', '50101776')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104401, 'Land Use Integration', '2015-11-06', '', 5, 'Team', '50103455')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104482, 'Customer Service And Sales', '2015-12-18', '', 5, 'Team', '50101898')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50104702, 'Strategic Planning', '2016-04-29', '', 5, 'Team', '50101383')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000055, 'Spatial Data Services', '2013-12-06', '', 6, 'Sub Team', '50103182')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000059, 'Data Centre & Mainframe', '2013-12-06', '2014-10-03', 6, 'Sub Team', '50000061')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000060, 'Server, Database & Storage Services', '2013-12-06', '2014-05-16', 6, 'Sub Team', '50000057')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000063, 'Network Security', '2013-12-06', '', 6, 'Sub Team', '50000061')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000064, 'Server Storage', '2013-12-06', '', 6, 'Sub Team', '50000061')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50000065, 'Mainframe Operations', '2013-12-06', '2013-12-13', 6, 'Sub Team', '50000061')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102325, 'Project Management Services', '2014-02-21', '2014-06-06', 6, 'Sub Team', '50000047')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102327, 'Data Management Services', '2014-02-21', '', 6, 'Sub Team', '50000048')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102331, 'Regulatory Systems Services', '2014-02-21', '', 6, 'Sub Team', '50000052')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102334, 'SAP Services', '2014-02-21', '', 6, 'Sub Team', '50000052')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50102336, 'Service Desk & Account Provisioning', '2014-02-21', '2014-06-06', 6, 'Sub Team', '50000062')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103189, 'Mainframe Services', '2014-10-10', '', 6, 'Sub Team', '50000052')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103237, 'Database Services', '2014-10-31', '', 6, 'Sub Team', '50000048')
INSERT INTO [Business_Unit] ([Business_Unit_Code], [Business_Unit_Name], [Effective_Date], [Obsolte_Date], [Business_Unit_Level], [Business_Unit_Level_Name], [Parent_Business_Unit_Code]) VALUES (50103238, 'Business Intelligence Services', '2014-10-31', '', 6, 'Sub Team', '50000048')
I need to "flatten" this table so that all of the applicable hierarchical levels of a business unit are shown as columns. There are six levels; Division, Branch, Group, Section, Team, and SubTeam. The final table would look something like this;
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id('[dbo].[Business_Unit]') AND OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE [dbo].[Business_Unit]
GO
CREATE TABLE [dbo].[Business_Unit](
[Business_Unit_Code] INT NOT NULL CONSTRAINT [PKC_Business_Unit] PRIMARY KEY CLUSTERED
,[Business_Unit_Name] VARCHAR(60) NOT NULL
,[Effective_Date] DATE NOT NULL
,[Obsolte_Date] DATE NULL
,[Business_Unit_Level] INT NOT NULL
,[Business_Unit_Level_Name] VARCHAR(11) NOT NULL
,[Division_Code] INT NOT NULL
,[Division_Name] VARCHAR(60) NOT NULL
,[Branch_Code] INT NULL
,[Branch_Name] VARCHAR(60) NULL
,[Group_Code] INT NULL
,[Goup_Name] VARCHAR(60) NULL
,[Section_Code] INT NULL
,[Section_Name] VARCHAR(60) NULL
,[Team_Code] INT NULL
,[Team_Name] VARCHAR(60) NULL
,[Sub_Team_Code] INT NULL
,[Sub_Team_Name] VARCHAR(60) NULL
)
So, for example, divisional business units would have have The columns from the first table above plus values in the columns Division_Code, and Division_Name (redundant, I know...). For a Business Unit that is a SubTeam it would have The columns from the first table above plus the Code and Name of the Team to which it belongs, the Section to which it belongs, and so on all the way up to it's Division.
Thanks in advance for any assistance you can provide.
July 26, 2016 at 11:37 am
I noticed that my table definition for the [Business_Unit_Flattened] table was not quite right (some columns that should have been nullable were not) so I cleaned it up. Apologies for any confusion.
July 26, 2016 at 2:31 pm
Why do you think that recursion is the correct approach here? I don't think it is, because a recursive query needs to maintain the same "shape" throughout and I don't think that is true with your intermediate results.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
July 26, 2016 at 2:53 pm
You've hit upon the "twist" part. I could be approaching this wrong. I'm assuming a recursion approach because to me this looks like a classic instance of the kind described on Microsoft's site where they describe Recursive Queries Using Common Table Expressions. This is org chart data.
https://technet.microsoft.com/en-us/library/ms186243(v=sql.105).aspx
At the end of the day I don't really care how it get's done. I would like a solution which could be flexible to the number of levels of hierarchy.
Do you know of an alternate approach?
July 31, 2016 at 7:00 pm
michael.lock@aer.ca (7/26/2016)
You've hit upon the "twist" part. I could be approaching this wrong. I'm assuming a recursion approach because to me this looks like a classic instance of the kind described on Microsoft's site where they describe Recursive Queries Using Common Table Expressions. This is org chart data.https://technet.microsoft.com/en-us/library/ms186243(v=sql.105).aspx
At the end of the day I don't really care how it get's done. I would like a solution which could be flexible to the number of levels of hierarchy.
Do you know of an alternate approach?
Hi Michael,
My question would be... why do you want to flatten the hierarchy? I ask, not to be obnoxious, but to possibly be helpful depending on what the end goal actually is once you have the table flattened. What will you do with it once it's flattened? The answer to that question could affect the way we do this.
For example, if one of the goals is to count the number of nodes in the downline for each and every node, that's actually a pretty trivial task when done early enough.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2016 at 9:50 am
michael.lock@aer.ca (7/26/2016)
You've hit upon the "twist" part. I could be approaching this wrong. I'm assuming a recursion approach because to me this looks like a classic instance of the kind described on Microsoft's site where they describe Recursive Queries Using Common Table Expressions. This is org chart data.https://technet.microsoft.com/en-us/library/ms186243(v=sql.105).aspx
At the end of the day I don't really care how it get's done. I would like a solution which could be flexible to the number of levels of hierarchy.
Do you know of an alternate approach?
The source data may be similar, but the question being asked is different, so the technique to arrive at the answer can--and in this case, should--be different.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
August 1, 2016 at 11:58 am
What you are doing is modeling a hierarchy with an adjacency list model (basically fake pointer chains). Google around for "nested sets model" and use it instead. After all, SQL is a set oriented language…
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
August 1, 2016 at 4:13 pm
Nested Sets, themselves, probably won't help much with flattening this hierarchy as requested by the OP. Further, most conversion methods for Nested Sets are terribly slow because of the RBAR-on-Steroids method of using a "push stack".
I will, however, admit that part of a fast, mostly set based conversion to Nested Sets (the part that makes the hierarchical path column) might be the ticket here. I just need to find out what the true end goal is that the OP has for the expected final use because we might be able to take an even greater shortcut.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2016 at 4:14 pm
Jeff Moden (7/31/2016)
michael.lock@aer.ca (7/26/2016)
You've hit upon the "twist" part. I could be approaching this wrong. I'm assuming a recursion approach because to me this looks like a classic instance of the kind described on Microsoft's site where they describe Recursive Queries Using Common Table Expressions. This is org chart data.https://technet.microsoft.com/en-us/library/ms186243(v=sql.105).aspx
At the end of the day I don't really care how it get's done. I would like a solution which could be flexible to the number of levels of hierarchy.
Do you know of an alternate approach?
Hi Michael,
My question would be... why do you want to flatten the hierarchy? I ask, not to be obnoxious, but to possibly be helpful depending on what the end goal actually is once you have the table flattened. What will you do with it once it's flattened? The answer to that question could affect the way we do this.
For example, if one of the goals is to count the number of nodes in the downline for each and every node, that's actually a pretty trivial task when done early enough.
Any feedback on this?
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2016 at 7:18 pm
Adam Mechanic had an improved technique. The only downside was that if the adjacency list had a cycle, it was bitch to find. The old stack algorithms could be written to look for them.
Books in Celko Series for Morgan-Kaufmann Publishing
Analytics and OLAP in SQL
Data and Databases: Concepts in Practice
Data, Measurements and Standards in SQL
SQL for Smarties
SQL Programming Style
SQL Puzzles and Answers
Thinking in Sets
Trees and Hierarchies in SQL
August 2, 2016 at 11:11 am
Hello, and thank you to all of the respondents. I actually didn't think I was going to get anything, it had been a few days. I'm actually on vacation now but since I know that people are willing to work on this with me I'll try to stay on top of the discussion.
The backstory on this is long so I'll save you from that. I'll try to explain this as clearly as possible but I suspect it will still seem confusing.
The use for the flattened table is for a data warehouse which will be used by Tableau to create KPI visualizations. The data being visualized of "milestones" business processes. Counts of how many instances of various processes, how long steps within processes take, how long the process overall takes. The processes belong to business units. They could belong to a business unit from any level in the hierarchy. We need to be able, with tableau, to show a business unit and it's parents (or children) for the purpose of filtering the report e.g. show me all of the processes belonging to all of the groups, sections, teams, and sub-teams in a selected set of branches for a given time period.
August 2, 2016 at 8:43 pm
CELKO (8/1/2016)
Adam Mechanic had an improved technique. The only downside was that if the adjacency list had a cycle, it was bitch to find. The old stack algorithms could be written to look for them.
I actually wrote two articles that took Adam's good formulas and turned them into greased lightning. Adam's formulas are remarkably simple but needed the kicker of knowing how many items were in the "downline" for each node before you counted the number of items in the "downline" for each node. Sounds impossible but studying his formulas and adding a Tally Table driven step associated with a hierarchical path made it a piece of cake. Of course, I gave Adam full credit for his wonderful formulas.
In case anyone is interested, here's the article on the very high performance method for converting to Nested Sets using Adam's formula and a specially built Tally Table structure. It allows you to keep the maintenance simplicity of the Adjacency List, provides hierarchical path information, gives some info as to what the leaf levels are, and creates the full Nested Sets on a million node hierarchy in less than a minute.
http://www.sqlservercentral.com/articles/Hierarchy/94040/
The link for part 2 can be found in the post below and leads to a method which may make Nested Sets obsolete of you're just looking for the most common hierarchical aggregations. Think of it as a pre-aggregated hierarchical warehouse and, it too, takes less than a minute to resolve a million node Adjacency List.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2016 at 8:45 pm
michael.lock@aer.ca (8/2/2016)
Hello, and thank you to all of the respondents. I actually didn't think I was going to get anything, it had been a few days. I'm actually on vacation now but since I know that people are willing to work on this with me I'll try to stay on top of the discussion.The backstory on this is long so I'll save you from that. I'll try to explain this as clearly as possible but I suspect it will still seem confusing.
The use for the flattened table is for a data warehouse which will be used by Tableau to create KPI visualizations. The data being visualized of "milestones" business processes. Counts of how many instances of various processes, how long steps within processes take, how long the process overall takes. The processes belong to business units. They could belong to a business unit from any level in the hierarchy. We need to be able, with tableau, to show a business unit and it's parents (or children) for the purpose of filtering the report e.g. show me all of the processes belonging to all of the groups, sections, teams, and sub-teams in a selected set of branches for a given time period.
I don't know much about Tableau. Instead of using denormalized horizontal data, can it use pre-aggregated , normalized vertical data? Again, just shooting for the best solution and I'm not sure that the horizontal representation would be the best for any kind of graphical solution, although it can certainly be done either way.
Take a look at the following article, which shows the "vertical" method I'm talking about. If that doesn't suit your needs, then we'll whip the rows into columns like you asked for.
http://www.sqlservercentral.com/articles/T-SQL/94570/
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2016 at 10:43 am
Jeff;
Thanks again for your reply. It will take me a little bit of time to investigate the suggestions that you and Celko (I'm presuming Joe Celko) have made. And, since I'm on vacation I don't have convenient access to all of my resources so I may not be able to provide any new insight quickly.
I will say that, as with most things, there are multiple ways to do things in Tableau. Some are simply easier than others. I believe that the flattened table approach may be the simplest from a Tableau perspective. I will report back once I've done some research (and had a few glasses of wine, and had some time in the sun and slept late, and...) 🙂
P.S.
I want to say a special than you to you as well as to Mr. Celko. I've been a non-professional (i.e. It's not an "official" part of my job but something I've wound up having to do) SQL developer since about 2000. When I started with SQL server I had to ask someone how to get data from a table i.e. SELECT * FROM [Table]. I'd say that 90 percent of what I now know about SQL now is attributable to Mr Celko's books and SQL ServerCentral.com. I've read The Guru's Guide to Transact-SQL from cover to cover and was on my bookshelf as a daily reference for years until our librarian threatened to come and take it back.
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply