text: -- =============================================
  -- Author:		Ben Driver
  -- Create date: 2019-10-17
  -- Updates: 
  --	2020-01-02: Support of Sprint 4.  Adjustment to Role values (BD)
  --	2019-12-12: Support of Sprint 3 & 4.  Adjustments to Submission Strean and Element values (BD)
  -- 	2019-10-17: Initial script (BD)
  -- Description:	DML to set initial lookup values.
  -- =============================================
  
  USE HMR_DEV; -- uncomment appropriate instance
  --USE HMR_TST;
  --USE HMR_UAT;
  --USE HMR_PRD;
  GO
  
  
  /* Insert Initial Region Entries */
  
  INSERT INTO HMR_REGION (REGION_NUMBER, REGION_NAME) VALUES (1, 'South Coast');
  INSERT INTO HMR_REGION (REGION_NUMBER, REGION_NAME) VALUES (2, 'Southern Interior');
  INSERT INTO HMR_REGION (REGION_NUMBER, REGION_NAME) VALUES (3, 'Northern');
  
  /* Insert Initial District Entries */
  
  INSERT INTO HMR_DISTRICT (DISTRICT_NUMBER, DISTRICT_NAME, REGION_NUMBER) VALUES (1,'Lower Mainland',1);
  INSERT INTO HMR_DISTRICT (DISTRICT_NUMBER, DISTRICT_NAME, REGION_NUMBER) VALUES (2,'Vancouver Island',1);
  INSERT INTO HMR_DISTRICT (DISTRICT_NUMBER, DISTRICT_NAME, REGION_NUMBER) VALUES (3,'Rocky Mountain',2);
  INSERT INTO HMR_DISTRICT (DISTRICT_NUMBER, DISTRICT_NAME, REGION_NUMBER) VALUES (4,'West Kootenay',2);
  INSERT INTO HMR_DISTRICT (DISTRICT_NUMBER, DISTRICT_NAME, REGION_NUMBER) VALUES (5,'Okanagan-Shuswap',2);
  INSERT INTO HMR_DISTRICT (DISTRICT_NUMBER, DISTRICT_NAME, REGION_NUMBER) VALUES (6,'Thompson-Nicola',2);
  INSERT INTO HMR_DISTRICT (DISTRICT_NUMBER, DISTRICT_NAME, REGION_NUMBER) VALUES (7,'Cariboo',2);
  INSERT INTO HMR_DISTRICT (DISTRICT_NUMBER, DISTRICT_NAME, REGION_NUMBER) VALUES (8,'Peace',3);
  INSERT INTO HMR_DISTRICT (DISTRICT_NUMBER, DISTRICT_NAME, REGION_NUMBER) VALUES (9,'Fort George',3);
  INSERT INTO HMR_DISTRICT (DISTRICT_NUMBER, DISTRICT_NAME, REGION_NUMBER) VALUES (10,'Bulkley-Stikine',3);
  INSERT INTO HMR_DISTRICT (DISTRICT_NUMBER, DISTRICT_NAME, REGION_NUMBER) VALUES (11,'Skeena',3);
  
  
  /* Insert Initial Service Area Entries */
  
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (1, 'South Island',2);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (2, 'Central Island',2);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (3, 'North Island',2);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (4, 'Howe Sound',1);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (5, 'Sunshine Coast',1);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (6, 'Lower Mainland',1);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (7, 'Fraser Valley',1);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (8, 'South Okanagan',5);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (9, 'Kootenay Boundary',4);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (10, 'Central Kootenay',4);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (11, 'East Kootenay',3);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (12, 'Selkirk',3);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (13, 'Okanagan-Shuswap',5);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (14, 'Nicola',6);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (15, 'Thompson',6);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (16, 'South Cariboo',7);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (17, 'Central Cariboo',7);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (18, 'North Cariboo',7);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (19, 'Fort George',9);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (20, 'Robson',9);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (21, 'South Peace',8);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (22, 'North Peace',8);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (23, 'Nechako',9);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (24, 'Lakes',10);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (25, 'Bulkley Nass',10);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (26, 'Skeena',11);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (27, 'North Coast',11);
  INSERT INTO HMR_SERVICE_AREA (SERVICE_AREA_NUMBER, SERVICE_AREA_NAME, DISTRICT_NUMBER) VALUES (28, 'Stikine',10);
  
  /* Insert Initial Mime Type Entries */
  
  --INSERT INTO HMR_MIME_TYPE (MIME_TYPE_CODE, DESCRIPTION) VALUES ('application/vnd.ms-excel','Microsoft Excel .xls');
  --INSERT INTO HMR_MIME_TYPE (MIME_TYPE_CODE, DESCRIPTION) VALUES ('application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','Microsoft Excel .xlsx');
  INSERT INTO HMR_MIME_TYPE (MIME_TYPE_CODE, DESCRIPTION) VALUES ('text/csv', 'Comma Separated Values .csv');
  
  /* Insert Initial Location Code values */
  
  INSERT INTO HMR_LOCATION_CODE (LOCATION_CODE, REQUIRED_LOCATION_DETAILS, ADDITIONAL_INFO, REPORTING_FREQUENCY) VALUES ('C', 'Service Area, Highway Unique, GPS/Linear coordinates', 'Site/structure ID', 'Record on Activity Completion');
  INSERT INTO HMR_LOCATION_CODE (LOCATION_CODE, REQUIRED_LOCATION_DETAILS, ADDITIONAL_INFO, REPORTING_FREQUENCY) VALUES ('B', 'Service Area, Highway Unique', 'NA', 'Daily Rollup');
  INSERT INTO HMR_LOCATION_CODE (LOCATION_CODE, REQUIRED_LOCATION_DETAILS, ADDITIONAL_INFO, REPORTING_FREQUENCY) VALUES ('A', 'Service Area', 'NA', 'Monthly Rollup');
  
  /* Load user context variables.  Redeclared further below for subsequent executions */
  
  DECLARE @utcdate DATETIME = (SELECT getutcdate() AS utcdate)
  DECLARE @app_guid UNIQUEIDENTIFIER = (SELECT CASE WHEN SUSER_SID() IS NOT NULL THEN SUSER_SID() ELSE (SELECT CONVERT(uniqueidentifier,STUFF(STUFF(STUFF(STUFF('B00D00A0AC0A0D0C00DD00F0D0C00000',9,0,'-'),14,0,'-'),19,0,'-'),24,0,'-'))) END AS  app_guid)
  DECLARE @app_user VARCHAR(30) = (SELECT CASE WHEN SUBSTRING(SUSER_NAME(),CHARINDEX('\',SUSER_NAME())+1,LEN(SUSER_NAME())) IS NOT NULL THEN SUBSTRING(SUSER_NAME(),CHARINDEX('\',SUSER_NAME())+1,LEN(SUSER_NAME())) ELSE CURRENT_USER END AS app_user)
  DECLARE @app_user_dir VARCHAR(12) = (SELECT CASE WHEN LEN(SUBSTRING(SUSER_NAME(),0,CHARINDEX('\',SUSER_NAME(),0)))>1 THEN SUBSTRING(SUSER_NAME(),0,CHARINDEX('\',SUSER_NAME(),0)) ELSE 'WIN AUTH' END AS app_user_dir)
  
  /* Insert Roles and Permissions */
  
  INSERT INTO HMR_PERMISSION (NAME,DESCRIPTION,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('CODE_W', 'Code Write',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_PERMISSION (NAME,DESCRIPTION,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('CODE_R', 'Code Read',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_PERMISSION (NAME,DESCRIPTION,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('USER_W', 'User Write',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_PERMISSION (NAME,DESCRIPTION,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('USER_R', 'User Read',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_PERMISSION (NAME,DESCRIPTION,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('ROLE_W', 'Role Write',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_PERMISSION (NAME,DESCRIPTION,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('ROLE_R', 'Role Read',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_PERMISSION (NAME,DESCRIPTION,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('FILE_W', 'File Upload Write',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_PERMISSION (NAME,DESCRIPTION,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('FILE_R', 'File Upload Read',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  
  INSERT INTO HMR_ROLE (NAME,DESCRIPTION,IS_INTERNAL,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('SYSTEM_ADMIN', 'System Administrator', 'Y',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE (NAME,DESCRIPTION,IS_INTERNAL,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('DISTRICT_ADMIN', 'District Administrator', 'Y',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE (NAME,DESCRIPTION,IS_INTERNAL,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('STAFF', 'Staff', 'Y',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE (NAME,DESCRIPTION,IS_INTERNAL,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('MANAGER_OPERATION', 'Manager/Operations', 'Y',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE (NAME,DESCRIPTION,IS_INTERNAL,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('MAINT_CONTRACTOR', 'Maintenance Contractor', 'N',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  
  
  
  
  INSERT INTO HMR_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT ROLE_ID FROM HMR_ROLE WHERE NAME = 'SYSTEM_ADMIN'), (SELECT PERMISSION_ID FROM HMR_PERMISSION WHERE NAME = 'CODE_W'),@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT ROLE_ID FROM HMR_ROLE WHERE NAME = 'SYSTEM_ADMIN'), (SELECT PERMISSION_ID FROM HMR_PERMISSION WHERE NAME = 'CODE_R'),@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT ROLE_ID FROM HMR_ROLE WHERE NAME = 'SYSTEM_ADMIN'), (SELECT PERMISSION_ID FROM HMR_PERMISSION WHERE NAME = 'USER_W'),@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT ROLE_ID FROM HMR_ROLE WHERE NAME = 'SYSTEM_ADMIN'), (SELECT PERMISSION_ID FROM HMR_PERMISSION WHERE NAME = 'USER_R'),@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT ROLE_ID FROM HMR_ROLE WHERE NAME = 'SYSTEM_ADMIN'), (SELECT PERMISSION_ID FROM HMR_PERMISSION WHERE NAME = 'ROLE_W'),@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT ROLE_ID FROM HMR_ROLE WHERE NAME = 'SYSTEM_ADMIN'), (SELECT PERMISSION_ID FROM HMR_PERMISSION WHERE NAME = 'ROLE_R'),@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT ROLE_ID FROM HMR_ROLE WHERE NAME = 'DISTRICT_ADMIN'), (SELECT PERMISSION_ID FROM HMR_PERMISSION WHERE NAME = 'CODE_W'),@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT ROLE_ID FROM HMR_ROLE WHERE NAME = 'DISTRICT_ADMIN'), (SELECT PERMISSION_ID FROM HMR_PERMISSION WHERE NAME = 'CODE_R'),@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT ROLE_ID FROM HMR_ROLE WHERE NAME = 'DISTRICT_ADMIN'), (SELECT PERMISSION_ID FROM HMR_PERMISSION WHERE NAME = 'USER_W'),@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT ROLE_ID FROM HMR_ROLE WHERE NAME = 'DISTRICT_ADMIN'), (SELECT PERMISSION_ID FROM HMR_PERMISSION WHERE NAME = 'USER_R'),@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT ROLE_ID FROM HMR_ROLE WHERE NAME = 'STAFF'), (SELECT PERMISSION_ID FROM HMR_PERMISSION WHERE NAME = 'CODE_R'),@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT ROLE_ID FROM HMR_ROLE WHERE NAME = 'MANAGER_OPERATION'), (SELECT PERMISSION_ID FROM HMR_PERMISSION WHERE NAME = 'CODE_R'),@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT ROLE_ID FROM HMR_ROLE WHERE NAME = 'MANAGER_OPERATION'), (SELECT PERMISSION_ID FROM HMR_PERMISSION WHERE NAME = 'USER_R'),@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT ROLE_ID FROM HMR_ROLE WHERE NAME = 'MANAGER_OPERATION'), (SELECT PERMISSION_ID FROM HMR_PERMISSION WHERE NAME = 'ROLE_R'),@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT ROLE_ID FROM HMR_ROLE WHERE NAME = 'MAINT_CONTRACTOR'), (SELECT PERMISSION_ID FROM HMR_PERMISSION WHERE NAME = 'FILE_W'),@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_ROLE_PERMISSION (ROLE_ID,PERMISSION_ID,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT ROLE_ID FROM HMR_ROLE WHERE NAME = 'MAINT_CONTRACTOR'), (SELECT PERMISSION_ID FROM HMR_PERMISSION WHERE NAME = 'FILE_R'),@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  
  GO
  
  /* Insert Initial Code Lookup values */
  
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('UOM', 'dollars', 'dollars',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('UOM', 'each ', 'ea',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('UOM', 'hours ', 'hours',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('UOM', 'km ', 'km',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('UOM', 'lane km', 'lkm',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('UOM', 'line km', 'line km',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('UOM', 'lineal metres ', 'lin m',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('UOM', 'litre ', 'litre',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('UOM', 'm2 ', 'm2',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('UOM', 'm3 ', 'm3',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('UOM', 'pass km', 'pk',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('UOM', 'road km', 'rd km',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('UOM', 'shoulder km ', 'sh km',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('UOM', 'site ', 'site',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('UOM', 'site/number ', 'site/num',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('UOM', 'tonne ', 'tonne',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('UOM', 'number ', 'num',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Deer', '','1', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Moose', '','2', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Elk', '','3', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Bear', '','4', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Sheep', '','5', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Caribou', '','6', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Coyote', '','7', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Porcupine', '','8', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Cougar', '','9', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Raccoon', '','10', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Bobcat', '','11', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Skunk', '','12', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Wolf', '','13', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Fox', '','14', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Beaver', '','15', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Horned Owl', '','16', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Muskrat', '','17', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Eagle', '','18', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Buffalo', '','19', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Badger', '','20', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Possum', '','21', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Otter', '','22', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Lynx', '','23', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Marten', '','24', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Rabbit', '','25', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Other', '','26', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Unknown', '','27', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'White Tail Deer', '','28', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Mule Deer', '','29', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Black Bear', '','30', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SPECIES', 'Grizzly Bear', '','31', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_TIME', 'Dawn', '','1', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_TIME', 'Dusk', '','2', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_TIME', 'Day', '','3', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_TIME', 'Dark', '','4', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_TIME', 'Unknown', '','5', NULL, 'NUMBER');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SIGN_IND', 'Yes', 'Y',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SIGN_IND', 'No', 'N',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SIGN_IND', 'Unknown', 'U',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SEX', 'Male', 'M',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SEX', 'Female', 'F',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_SEX', 'Unknown', 'U',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_AGE', 'Adult', 'A',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_AGE', 'Young', 'Y',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_AGE', 'Unknown', 'U',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WRK_RPT_MAINT_TYPE', 'Quantified', 'Q',NULL, '2', 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WRK_RPT_MAINT_TYPE', 'Routine', 'R',NULL, '1', 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WRK_RPT_MAINT_TYPE', 'Major Event', 'E',NULL, '4', 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WRK_RPT_MAINT_TYPE', 'Additional', 'A',NULL, '3', 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('VOLUME_RANGE1', '< 0.03 m'+NCHAR(0xb3)+'', '<0.03',NULL, '1', 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('VOLUME_RANGE1', '0.03 m'+NCHAR(0xb3)+' to 0.1 m'+NCHAR(0xb3)+' ', '0.03-0.1',NULL, '2', 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('VOLUME_RANGE1', '0.1 m'+NCHAR(0xb3)+' to 0.3 m'+NCHAR(0xb3)+' ', '0.1-0.3',NULL, '3', 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('VOLUME_RANGE1', '0.3 m'+NCHAR(0xb3)+' to 0.5 m'+NCHAR(0xb3)+' ', '0.3-0.5',NULL, '4', 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('VOLUME_RANGE1', '0.5 m'+NCHAR(0xb3)+' to 1.0 m'+NCHAR(0xb3)+' ', '0.5-1.0',NULL, '5', 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('VOLUME_RANGE1', '1.0 m'+NCHAR(0xb3)+' to 5.0 m'+NCHAR(0xb3)+'', '1.0-5.0',NULL, '6', 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('VOLUME_RANGE1', '>5.0 m'+NCHAR(0xb3)+' ', '>5.0',NULL, '7', 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_RPT_RECORD_TYPE', 'WARS', 'W',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_RPT_SIGN', 'Yes', 'Y',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_RPT_SIGN', 'No', 'N',NULL, NULL, 'STRING');
  GO
  INSERT INTO HMR_CODE_LOOKUP (CODE_SET, CODE_NAME, CODE_VALUE_TEXT, CODE_VALUE_NUM, DISPLAY_ORDER, CODE_VALUE_FORMAT) VALUES ('WARS_RPT_SIGN', 'Unknown', 'U',NULL, NULL, 'STRING');
  GO
  
  /* Load user context variables. */
  
  DECLARE @utcdate DATETIME = (SELECT getutcdate() AS utcdate)
  DECLARE @app_guid UNIQUEIDENTIFIER = (SELECT CASE WHEN SUSER_SID() IS NOT NULL THEN SUSER_SID() ELSE (SELECT CONVERT(uniqueidentifier,STUFF(STUFF(STUFF(STUFF('B00D00A0AC0A0D0C00DD00F0D0C00000',9,0,'-'),14,0,'-'),19,0,'-'),24,0,'-'))) END AS  app_guid)
  DECLARE @app_user VARCHAR(30) = (SELECT CASE WHEN SUBSTRING(SUSER_NAME(),CHARINDEX('\',SUSER_NAME())+1,LEN(SUSER_NAME())) IS NOT NULL THEN SUBSTRING(SUSER_NAME(),CHARINDEX('\',SUSER_NAME())+1,LEN(SUSER_NAME())) ELSE CURRENT_USER END AS app_user)
  DECLARE @app_user_dir VARCHAR(12) = (SELECT CASE WHEN LEN(SUBSTRING(SUSER_NAME(),0,CHARINDEX('\',SUSER_NAME(),0)))>1 THEN SUBSTRING(SUSER_NAME(),0,CHARINDEX('\',SUSER_NAME(),0)) ELSE 'WIN AUTH' END AS app_user_dir)
  
  
  /* Insert Submission Strean and Element values */
  
  INSERT INTO HMR_SUBMISSION_STREAM (STREAM_NAME,STAGING_TABLE_NAME,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('MC Work Reporting', 'HMR_WORK_REPORT',@app_user, @utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_SUBMISSION_STREAM (STREAM_NAME,STAGING_TABLE_NAME,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('Rockfall Reporting', 'HMR_ROCKFALL_REPORT',@app_user, @utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_SUBMISSION_STREAM (STREAM_NAME,STAGING_TABLE_NAME,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('Wildlife Reporting', 'HMR_WILDLIFE_REPORT',@app_user, @utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  
  
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Wildlife Reporting'), 'RECORD_TYPE','RECORD TYPE','String', 'WARS_RPT_RECORD_TYPE',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Wildlife Reporting'), 'SERVICE_AREA','SERVICE AREA','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Wildlife Reporting'), 'ACCIDENT_DATE','ACCIDENT DATE','Date', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Wildlife Reporting'), 'TIME_OF_KILL','TIME OF KILL','String', 'WARS_TIME',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Wildlife Reporting'), 'LATITUDE','LATITUDE','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Wildlife Reporting'), 'LONGITUDE','LONGITUDE','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Wildlife Reporting'), 'HIGHWAY_UNIQUE_NUMBER','HIGHWAY UNIQUE NUMBER','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Wildlife Reporting'), 'LANDMARK','LANDMARK','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Wildlife Reporting'), 'START_OFFSET','START OFFSET','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Wildlife Reporting'), 'NEAREST_TOWN','NEAREST TOWN','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Wildlife Reporting'), 'WILDLIFE_SIGN','WILDLIFE SIGN','String', 'WARS_SIGN_IND',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Wildlife Reporting'), 'QUANTITY','QUANTITY','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Wildlife Reporting'), 'SPECIES','SPECIES','Numeric', 'WARS_SPECIES',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Wildlife Reporting'), 'SEX','SEX','String', 'WARS_SEX',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Wildlife Reporting'), 'AGE','AGE','String', 'WARS_AGE',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Wildlife Reporting'), 'COMMENT','COMMENT','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'MAJOR_INCIDENT_NUMBER','MAJOR INCIDENT NUMBER','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'ESTIMATED_ROCKFALL_DATE','ESTIMATED ROCKFALL DATE','Date', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'ESTIMATED_ROCKFALL_TIME','ESTIMATED ROCKFALL TIME','Date', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'START_LATITUDE','START LATITUDE','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'START_LONGITUDE','START LONGITUDE','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'END_LATITUDE','END LATITUDE','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'END_LONGITUDE','END LONGITUDE','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'HIGHWAY_UNIQUE_NUMBER','HIGHWAY UNIQUE NUMBER','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'HIGHWAY_UNIQUE_NAME','HIGHWAY UNIQUE NAME','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'LANDMARK','LANDMARK','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'LAND_MARK_NAME','LAND MARK NAME','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'START_OFFSET','START OFFSET','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'END_OFFSET','END OFFSET','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'DIRECTION_FROM_LANDMARK','DIRECTION FROM LANDMARK','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'LOCATION_DESCRIPTION','LOCATION DESCRIPTION','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'DITCH_VOLUME','DITCH VOLUME','String', 'VOLUME_RANGE1',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'TRAVELLED_LANES_VOLUME','TRAVELLED LANES VOLUME','String', 'VOLUME_RANGE1',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'OTHER_VOLUME','OTHER VOLUME','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'HEAVY_PRECIP','HEAVY PRECIP','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'FREEZE_THAW','FREEZE THAW','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'DITCH_SNOW_ICE','DITCH SNOW ICE','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'VEHICLE_DAMAGE','VEHICLE DAMAGE','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'COMMENTS','COMMENTS','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'REPORTER_NAME','REPORTER NAME','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'MC_PHONE_NUMBER','MC PHONE NUMBER','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'Rockfall Reporting'), 'REPORT_DATE','REPORT DATE','Date', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'RECORD_TYPE','RECORD TYPE','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'SERVICE_AREA','SERVICE AREA','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'RECORD_NUMBER','RECORD NUMBER','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'TASK_NUMBER','TASK NUMBER','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'ACTIVITY_NUMBER','ACTIVITY NUMBER','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'START_DATE','START DATE','Date', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'END_DATE','END DATE','Date', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'ACCOMPLISHMENT','ACCOMPLISHMENT','Numeric', 'UOM',@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'UNIT_OF_MEASURE','UNIT OF MEASURE','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'POSTED_DATE','POSTED DATE','Date', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'HIGHWAY_UNIQUE','HIGHWAY UNIQUE','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'LANDMARK','LANDMARK','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'START_OFFSET','START OFFSET','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'END_OFFSET','END OFFSET','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'START_LATITUDE','START LATITUDE','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'START_LONGITUDE','START LONGITUDE','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'END_LATITUDE','END LATITUDE','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'END_LONGITUDE','END LONGITUDE','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'STRUCTURE_NUMBER','STRUCTURE NUMBER','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'SITE_NUMBER','SITE NUMBER','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'VALUE_OF_WORK ','VALUE OF WORK ','Numeric', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  INSERT INTO HMR_STREAM_ELEMENT (SUBMISSION_STREAM_ID,STAGING_COLUMN_NAME,ELEMENT_NAME,ELEMENT_TYPE,CODE_SET,APP_CREATE_USERID,APP_CREATE_TIMESTAMP,APP_CREATE_USER_GUID,APP_CREATE_USER_DIRECTORY,APP_LAST_UPDATE_USERID,APP_LAST_UPDATE_TIMESTAMP,APP_LAST_UPDATE_USER_GUID,APP_LAST_UPDATE_USER_DIRECTORY) VALUES ((SELECT SUBMISSION_STREAM_ID FROM HMR_SUBMISSION_STREAM WHERE STREAM_NAME = 'MC Work Reporting'), 'COMMENTS','COMMENTS','String', NULL,@app_user,@utcdate,@app_guid,@app_user_dir,@app_user,@utcdate,@app_guid,@app_user_dir);
  
  
  /* Insert Initial Activity Code values */
  
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('101200', 'Temporary Patching', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('101300', 'Overlay Patch ', 'tonne', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('101301', 'Overlay Patch Isolated', 'tonne', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('101302', 'Overlay Patch (handwork)', 'tonne', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('101303', 'Overlay Patch - Isolated (handwork)', 'tonne', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('101304', 'Replacement Patch', 'tonne', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('101305', 'Replacement Patch (handwork)', 'tonne', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('101306', 'Spray Patching', 'litre', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('101307', 'Spray Patching - Isolated', 'litre', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('101308', 'Crack Sealing ', 'litre', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('101309', 'Crack Filling', 'litre', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('102300', 'Graded Aggregate Seal', 'm2', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('102301', 'Graded Aggregate Seal - Isolated', 'm2', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('102302', 'Sand Seal', 'm2', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('103300', 'Grading', 'rd km', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('103301', 'Grading (Re-shaping)', 'rd km', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('103302', 'Shoulder Grading', 'sh km ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('103303', 'Shoulder Grading (Re-shaping)', 'sh km ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('104300', 'Dust Control ', 'litre', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('104301', 'Base Stabilization', 'litre', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('105300', 'Surface Graveling - Crush', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('105301', 'Surface Graveling - Crush - Isolated', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('105302', 'Surface Gravelling - Pit Run', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('105303', 'Surface Gravelling - Pit Run - Isolated', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('105304', 'Shoulder Gravelling - Crush', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('105305', 'Shoulder Gravelling - Crush - Isolated', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('105306', 'Shoulder Gravelling - Pit Run', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('105307', 'Shoulder Gravelling - Pit Run - Isolated', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('106300', 'Road Base Repair', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('107200', 'Machine Surface Cleaning', 'Lkm', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('107201', 'Hand Surface Cleaning', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('107202', 'Surface Cleaning Pedestrian Path', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('107203', 'Surface Cleaning Bicycle path', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('107204', 'Blockage Removal', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('107205', 'Clean Annually Openings', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('107206', 'Barrier Accumulations Removal', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('107300', 'Surface Cleaning Remove Accumulations (barrier)', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('107301', 'Surface Cleaning Remove Accumulations (additional)', 'sh km ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('108200', 'Debris removal', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('108201', 'Debris removal exceeding 1000 cc on travelled lanes and sidewalks', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('108202', 'Debris equal to or less than 1000 cc on travelled lanes or sidewalks', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('108203', 'Debris exceeding 1000 cc on shoulders', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('108204', 'Debris equal to or less than 1000 cc on shoulders', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('108205', 'Dead animals on travelled lanes, shoulders or sidewalks', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('108206', 'Dead animals on the Right-of-Way excluding Travelled Lanes, Shoulders and sidewalks', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('109200', 'Cattle Guard Clean Debris', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('190201', 'Cattle Guard Repair', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('109300', 'Cattleguard System replace, new, elevation correct', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110200', 'Barrier Maintenance', 'Lin m ', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110201', 'Traffic Islands', 'm2', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110202', 'Curb Maintenance', 'Lin m ', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110203', 'Roundabout Maintenance', 'site', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110204', 'Other Raised Hard Surface Infrastructure Maintenance', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110205', 'Safety Devices Maintenance', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110300', 'barrier cable - replace', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110301', 'barrier cable - new', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110302', 'barrier concrete - replace', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110303', 'barrier concrete - new', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110304', 'barrier steel - replace', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110305', 'barrier steel - new', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110306', 'traffic island - replace', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110307', 'traffic island - new', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110308', 'curb asphalt - replace', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110309', 'curb asphalt - new', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110310', 'curb concrete - replace', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110311', 'curb concrete - new', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110312', 'Impact Attenuator - replace, new', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110313', 'anti-glare screen - replace, new', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110314', 'sidewalks - replace', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110315', 'pedestrian paths - replace, new', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('110316', 'spillways - replace, new', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('111200', 'Maintain Railway Crossing Approaches (pavement)', 'm2', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('111201', 'Maintain Railway Crossing Approaches (graveling)', 'm3', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('111202', 'Maintain Railway Crossing Approaches Sight Lines', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('201200', 'Debris Removal by Handwork', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('201300', 'Ditching - 0 to 30 km one-way haul distance', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('201301', 'Ditching - 31 to 60 km one-way haul distance', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('201302', 'Ditching - 61 to 100 km one-way haul distance', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('201303', 'Ditch construction new, repair embankments/ back slopes, widen/deepen collection areas', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('201304', 'Ditching - remove localized minor rock', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('201305', 'Ditch Side-casting', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202200', 'Roadway Culverts Repair by Handwork', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202201', 'Entrance Culverts Repair by Handwork', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202202', 'Slope Flume Repair by Handwork', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202203', 'Catch Basins/Manholes by Handwork', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202204', 'Other Drainage by Handwork', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202205', 'Trash Rack Repair by Handwork', 'site', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202206', 'Culvert Stakes and Markers', 'site', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202301', 'Removal of Debris/obstructions', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202302', 'Culvert Install (to 400mm) max. 2m height of cover', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202303', 'Culvert Install (401mm to 600mm) max. 2m height of cover', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202304', 'Culvert Install (601mm to 1200mm) max. 2m height of cover ', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202305', 'Culvert Install (to 2999mm)', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202306', 'Flume install (to 2999mm)', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202307', 'Re-setting, repair, replace and new other Drainage Appliances', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202308', 'Culvert inserts boring, auguring, pushing, installing', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202309', 'Install rip-rap or other suitable material', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202310', 'Trash racks – clean', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202311', 'Trash racks – repair', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202312', 'Trash racks – replace, new', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('202313', 'catch basin install (metal, concrete)', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('203200', 'Debris Removal Water Course by Handwork', 'site', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('203201', 'Install Rip-rap by Handwork', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('203300', 'removal of Debris/obstructions, provide catchment areas', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('203301', 'install rip-rap or other suitable material', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('301200', 'Travelled Lanes Plowing', 'pk', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('301201', 'Slush/Compact Travelled Lanes Removal', 'pk', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('301202', 'Paved Shoulder Removal', 'sh km ', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('301203', 'Rest Areas, Pullouts and Parking Areas Removal', 'km', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('302200', 'De-icing Application', 'lkm', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('302201', 'Winter Abrasive Application', 'lkm', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('302202', 'Anti-icing Application', 'litres', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('302203', 'Pre-Wet Sand', 'm3', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('302204', 'Pre-Wet Salt', 'm3', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('302205', 'Compact Surface Maintenance', 'pk', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('303200', 'Pedestrian Accessed Areas Winter Accumulations removal', 'm2', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('303201', 'Cattle Guard Systems and Ungulate Guards Snow/Ice Removal', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('303202', 'Snow Fencing /Berms Installation and Removal', 'Lin m ', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('303203', 'Other Winter Accumulations Removal', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('303204', 'Barrier Snow Removal', 'Lin m ', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('303205', 'Ditches and Drainage Appliances Snow/Ice Removal ', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('303206', 'Snow Blowing', 'pk', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('304200', 'Highway Snow Avalanche Deposits Removal', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('304201', 'Other Snow Avalanche Deposits Removal', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('401300', 'cut vegetation (Shoulder top and 0 - 1.8m)', 'sh km ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('401301', 'cut vegetation (Rest Areas/other specified locations)', 'm2', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('401302', 'cut vegetation (Raised Hard Surfaced Infrastructure)', 'm2', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('402300', 'brushing (machine)', 'sh km ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('402301', 'brushing (hand cutting)', 'm2', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('402302', 'brushing (hand cutting individual tree), Danger Tree removal, overhanging trees/limbs', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('403200', 'Highway Litter Removal', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('403201', 'Receptacles - Litter Removal', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('403202', 'Adopt-a-Highway Program Bags Removal', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('403203', 'Graffiti Removal', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('404200', 'Rest Area Maintenance', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('404201', 'Rest Area Repairs / replace', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('405300', 'Schedule 1 and 2 Fences Temporary Repairs', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('405301', 'Schedule 1 and 2 Fences Permanent Repairs', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('405302', 'Specialty Fences - temporary and permanent repair, new ', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('406300', 'Roadside Catchment Appurtenances Repair / replace', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('406301', 'Crack seal/repairs', 'litre', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Line', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('406302', 'rock/sediment/debris removal', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('406303', 'Relief Wells - Clean', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501200', 'Sign Systems Maintenance', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501201', 'Sign Systems Temporary Repair/ Placement / Re-paint', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501202', 'Sign Cleaning', 'num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501300', 'delineator system install - plastic post/ fibreglass post, telspar, u channel post, Shoulder mount', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501301', 'delineator install - barrier, top mount or side mount, W055, shoulder mount', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501302', '1 Post Sign System Install (< 1.09 m2) ', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501303', '1 Post Sign System Install (> 1.09 m2) ', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501304', '2 Post Sign System Install (< 3.2 m2)', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501305', '2 Post Sign System Install (> 3.2m2)', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501306', '3 Post Sign System Install (< 10.1 m2)', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501307', '3 Post Sign System Install (> 10.1 m2) ', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501308', 'Sign install (< 1.09 m2) ', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501309', 'Sign install (1.1 m2 to 3.2 m2)', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501310', 'Sign install (3.3 m2 to 7.1 m2)', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501311', 'Sign install (7.2 m2 to 10.1 m2)', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501312', 'Sign install (> 10.1 m2)', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501313', 'Sign Face Overlay install (< 1.09 m2) ', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501314', 'Sign Face Overlay install (1.1 m2 to 3.2 m2)', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501315', 'Sign Face Overlay install (3.3 m2 to 7.1 m2)', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501316', 'Sign Face Overlay Install (7.2 m2 to 10.1 m2)', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('501317', 'Sign Face Overlay Install (> 10.1 m2)', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('502200', 'Temporary Line Marking', 'Lin m ', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('502201', 'Line Pavement Marking Eradication', 'Lin m ', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('502300', 'restore or new temporary line markings', 'line km', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('502301', 'restore or new temporary pavement markings ', 'm2', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('502302', 'eradicate temporary line markings ', 'line km', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('502303', 'eradicate temporary pavement markings ', 'm2', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('502304', 'eradicate permanent line markings ', 'line km', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('502305', 'eradicate permanent pavement markings', 'm2', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('503200', 'Traffic Management', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('601200', 'Concrete Surface temporary repair', 'm2', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('601201', 'Timber /Asphalt Plank temporary repair', 'm2', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('601202', 'Steel Deck temporary repair', 'm2', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('601300', 'timber Re-decking (Minor)', 'm2', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('601301', 'timber Re-decking (Major)', 'm2', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('601302', 'linseed oil/mineral spirit treatment', 'm2', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('601303', 'Deck - concrete repair', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('601304', 'Deck - crack seal', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('601305', 'Deck - crack repair', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('602200', 'Bridge Cleaning', 'site', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('602201', 'Joint/Bearing/Drain Cleaning', 'site', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('603200', 'Drain /Pipe/Flume Maintenance -BR', 'site', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('604200', 'Bridge Joint Maintenance', 'site', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('604300', 'Bridge Joint Armour / Joint seal replace', 'Lin m ', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('605200', 'Bridge Bearing Maintenance', 'site', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('605300', 'Bridge Bearing and components replace', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('606200', 'Bailey/Acrow Parts/Maintenance', 'site/num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('607300', 'Coating steel/timber surfaces, steel/timber rail systems', 'm2', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('608300', 'Concrete structure, crack seal repair', 'm3', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('609200', 'Steel / aluminum Structure repair', 'site', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('610200', 'Bridge Piling/Bracing', 'site', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('610300', 'Bridge Pile replace', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('611300', 'Retaining Wall / components - repair, replace', 'm2', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('612200', 'Bridge Posts Maintenance', 'site/num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('612201', 'Bridge Railing Permanent Repairs', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('612202', 'Bridge Rail Maintenance', 'site/num', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('613200', 'Truss timber Maintenance', 'site', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('613300', 'Truss Rods, Lateral Rods, End Posts, Main Braces, Counter Braces, Floor Beams, Corbels - replace', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('613301', 'Truss Rods or Camber - adjust', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('614200', 'Timber and Log Bridge Repair', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('614300', 'Timber and Log, components - replace', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('701200', 'Vehicle Accident Response', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('701201', 'Surface Spill Clean', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('701202', 'Cargo / Incident Debris Removal', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('702200', 'Major Event Response', 'dollars', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('702400', 'Major Event Response Additional Maintenance (H200)', 'dollars', 'Additional', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('703200', 'Highway Inspection', 'km', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('703201', 'Bridge Structure Inspection', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('703202', 'Safety Device Inspection', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('704200', 'Highway Patrol', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('705200', 'Public and stakeholder communications', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Province wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('901200', 'Arrestor Bed Incident Response', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('901201', 'Arrestor Bed Aggregate Maintenance', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('901202', 'Arrestor Bed Winter Monitoring & Maintenance', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('902200', 'Barrier Kootenay Pass - Remove and Store Barrier', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('902202', 'Barrier Kootenay Pass - Re-establish Barrier', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('904200', 'Bridge and Tunnel Mechanical System Failures Repair/Maintenance', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('904201', 'Bridge and Tunnel - Certify Sprinkler System', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('904202', 'Bridge and Tunnel Computer Workstation Components Cleaning ', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('905200', 'Bridge Traveller Repair or Replace Components', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('905201', 'Bridge Traveller Annual Certification', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('905202', 'Bridge Traveller Monthly Operational Test', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('906200', 'Car Pool Parking Lot Surface Maintenance', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('908200', 'Maintain or Repair Dock', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('908201', 'Dock and Ramp Removal and Return', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('909200', 'Dragnet Vehicle Arresting Barrier Incident Response', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('909201', 'Dragnet Vehicle Arresting Barrier Inspect, Repair, Replace and Adjust, Quarterly', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('909202', 'Dragnet Vehicle Arresting Barrier Annual Maintenance', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('909203', 'Dragnet Vehicle Arresting Barrier Winter Maintenance Response', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('910200', 'Graveyard Cut Vegetation', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('910201', 'Graveyard Fence repair or paint', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('911200', 'Highway Crossing Infrastructure Restrict Access as directed', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('911201', 'Highway Crossing Infrastructure Repair or Replace Components', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('911202', 'Highway Crossing Infrastructure Accumulation or Debris Removal', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('911300', 'Highway Crossing Infrastructure - surface repairs', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('912200', 'Horizontal Drain System Repair or Replace Components', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('912201', 'Horizontal Drain System Cut Vegetation', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('912202', 'Horizontal Drain System Annual Inspection', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('912203', 'Horizontal Drain System Flush and Clean as directed', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('913200', 'Invasive Plants Management Annual Agency meeting', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('913201', 'Invasive Plants Management Gravel Pit inspections', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('913300', 'Invasive Plants Management Re-vegetation seeding', 'm2', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('916200', 'Movable Bridge Repair or Replace Components', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('916201', 'Movable Bridge Maintain deck joints annually', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('917300', 'Pavement surface reflectors - replace, new', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('918200', 'repair or replace Reaction Ferry Vessel components.', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('918201', 'repair or replace the shore based Ramp System', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('918202', 'Ferry Facility Maintenance - repair or replace ', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('919200', 'Salt Containment Infrastructure Maintenance for steel/fabric annually', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('919201', 'Salt Containment Infrastructure Repair or Replace Salt Containment Components ', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('919202', 'Salt Containment Infrastructure Regenerate Evapotranspiration surface annually', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('920200', 'Snow Avalanche Deposit Removal from Highway', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('920201', 'Snow Avalanche Deposit Removal from catchment areas, static defence structures', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('920202', 'Snow Avalanche Increased Patrols at Hazard Level Moderate or Higher', 'Hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('922000', 'Snow Shed Maintain, repair or replace Snow Shed components', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('923300', 'Sound Wall and components - repair, replace', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('924200', 'Vehicle Inspection Station Remove Winter Accumulations ', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'b'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('925200', 'Repair or Replace Components Wildlife Exclusion System ', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('925201', 'Accumulation or Debris Removal - Wildlife Exclusion System ', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('925202', 'Inspect Condition annually -Wildlife Exclusion System ', 'ea', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('925300', 'repairs - Wildlife Exclusion System ', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('925301', 'Remove Brush -Wildlife Exclusion System ', 'm2', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Either', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('925302', 'Restore height- Wildlife Exclusion System ', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('926200', 'Bridge Patrol', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('926300', 'Refuse and trash - removal - demonstration site clean up', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('927300', 'Bridge Deck repair - Bridge Deck Inspection, Maintenance and Traffic Management', 'ea', 'Quantified', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('928200', 'Refuse Site Maintenance – Receiving, Sorting, Depositing, & Covering Local waste', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('928201', 'Refuse Site Maintenance – Sorting & Preparing & Transferring General Recyclable Materials', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('928202', 'Refuse Site Maintenance – Sorting & Preparing & Transferring Scrap Metal Recyclable Materials', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('929200', 'Small Airport Winter Maintenance – Snow Removal ', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('929201', 'Small Airport Winter Maintenance – Compact Snow Mtce', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('929202', 'Small Airport Winter Maintenance – Edge Markers', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('929203', 'Small Airport Winter Maintenance – Surface Cleaning', 'hours', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('929204', 'Small Airport Winter Maintenance – Chemical (Urea) Application', 'litre', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('930200', 'Median & interchange vegetation control', 'site', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('931200', 'Median cleaning ', 'site', 'Routine', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), NULL, 'Local Area Specification' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('996499', 'H200 - More Quantified', 'dollars', 'Additional', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Service Area wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('997499', 'H200 - Routine above RMS Cap', 'dollars', 'Additional', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'c'), 'Point', 'Service Area wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('998499', 'H200 - Maintenance Services on Class 8/F', 'dollars', 'Additional', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Service Area wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  INSERT INTO HMR_ACTIVITY_CODE (ACTIVITY_NUMBER, ACTIVITY_NAME, UNIT_OF_MEASURE, MAINTENANCE_TYPE, LOCATION_CODE_ID, POINT_LINE_FEATURE, ACTIVITY_APPLICATION, APP_CREATE_USERID, APP_CREATE_TIMESTAMP, APP_CREATE_USER_GUID, APP_CREATE_USER_DIRECTORY, APP_LAST_UPDATE_USERID, APP_LAST_UPDATE_TIMESTAMP, APP_LAST_UPDATE_USER_GUID, APP_LAST_UPDATE_USER_DIRECTORY) VALUES ('999499', 'H200 - Other ', 'dollars', 'Additional', (SELECT LOCATION_CODE_ID FROM HMR_LOCATION_CODE WHERE dbo.HMR_LOCATION_CODE.LOCATION_CODE = 'a'), NULL, 'Service Area wide' , @app_user, @utcdate, @app_guid, @app_user_dir, @app_user, @utcdate, @app_guid, @app_user_dir);
  
  GO
  
  