text: DECLARE @UserId UNIQUEIDENTIFIER;
  DECLARE @NotificationId UNIQUEIDENTIFIER = 'ceb03ae8-2792-4dfc-8f87-6b2384f62504';
  
  SELECT @UserId = id
  FROM   [Identity].[aspnetusers]
  WHERE  [email] = 'sunily@sfwltd.co.uk'
  
  INSERT [Notification].[notification]
         ([id],
          [userid],
          [notificationtype],
          [competentauthority],
          [notificationnumber],
          [createddate],
          [reasonforexport],
          [hasspecialhandlingrequirements],
          [specialhandlingdetails],
          [isrecoverypercentagedataprovidedbyimporter],
          [wastegenerationprocess],
          [iswastegenerationprocessattached])
  VALUES (@NotificationId,
          @UserId,
          2,
          1,
          N'GB 0001 002504',
          Cast(N'2016-10-10 10:00:00.0000000' AS DATETIME2),
          N'Use of advanced facilities',
          0,
          NULL,
          1,
          NULL,
          1)
  
  INSERT [Notification].[MeansOfTransport]
  	   ([Id],
  	    [NotificationId],
  		[MeansOfTransport])
  VALUES (N'C2A7B7BA-1DC6-465F-8461-F4C1731B55EF',
  		@NotificationId,
  		N'R;S;R;T');
  
  INSERT [Notification].[FacilityCollection] (
  	[Id],
  	[NotificationId],
  	[AllFacilitiesPreconsented]
  )
  VALUES (
  	N'B42960F8-BAFA-458D-B74B-5EB0FC8DFBAD',
  	@NotificationId,
  	1
  )
  
  INSERT [Notification].[facility]
         ([id],
          [name],
          [isactualsiteoftreatment],
          [type],
          [registrationnumber],
          [additionalregistrationnumber],
          [address1],
          [address2],
          [townorcity],
          [postalcode],
          [region],
          [country],
          [fullname],
          [telephone],
          [fax],
          [email],
          [FacilityCollectionId],
          [otherdescription])
  VALUES (NEWID(),
          N'Waste Treatment Facility',
          1,
          1,
          N'45645684546',
          NULL,
          N'1 Rue Strasse',
          N'German Suburb',
          N'Dortmund',
          N'64151',
          N'Dortmund',
          N'Germany',
          N'Maxwell Bob',
          N'53-2225557777',
          N'53-3336669999',
          N'test@importer.de',
          N'B42960F8-BAFA-458D-B74B-5EB0FC8DFBAD',
          NULL)
  
  INSERT [Notification].[facility]
         ([id],
          [name],
          [isactualsiteoftreatment],
          [type],
          [registrationnumber],
          [additionalregistrationnumber],
          [address1],
          [address2],
          [townorcity],
          [postalcode],
          [region],
          [country],
          [fullname],
          [telephone],
          [fax],
          [email],
          [FacilityCollectionId],
          [otherdescription])
  VALUES (NEWID(),
          N'Scrap Waste Reclamation',
          0,
          2,
          N'IMPORTER123',
          NULL,
          N'1 Normal Strasse',
          N'Near XYZ',
          N'Dortmund',
          N'654451',
          N'Dortmund',
          N'Germany',
          N'John Bob',
          N'53-2225557777',
          N'53-3336669999',
          N'test@importer.de',
          N'B42960F8-BAFA-458D-B74B-5EB0FC8DFBAD',
          NULL)
  
  INSERT [Notification].[importer]
         ([id],
          [name],
          [type],
          [registrationnumber],
          [additionalregistrationnumber],
          [address1],
          [address2],
          [townorcity],
          [postalcode],
          [region],
          [country],
          [fullname],
          [telephone],
          [fax],
          [email],
          [notificationid],
          [otherdescription])
  VALUES (NEWID(),
          N'Importer',
          2,
          N'IMPORTER123',
          NULL,
          N'Opp. ABCD',
          N'Near XYZ',
          N'Woking',
          N'GU22 7UY',
          N'Surrey',
          N'United Kingdom',
          N'John Bob',
          N'44-2225557777',
          N'44-3336669999',
          N'test@importer.com',
          @NotificationId,
          NULL)
  
  INSERT [Notification].[ProducerCollection]
  	   ([Id],
  	    [NotificationId])
  VALUES (N'4B9B1842-0DE7-4589-91D0-C3D372BEA935',
  		@NotificationId)
  
  INSERT [Notification].[producer]
         ([id],
          [name],
          [issiteofexport],
          [type],
          [registrationnumber],
          [additionalregistrationnumber],
          [address1],
          [address2],
          [townorcity],
          [postalcode],
          [region],
          [country],
          [fullname],
          [telephone],
          [fax],
          [email],
          [producercollectionid],
          [otherdescription])
  VALUES (NEWID(),
          N'Metal Products Ltd',
          1,
          3,
          N'Not applicable',
          NULL,
          N'Station Approach',
          N'Opp. TESCO',
          N'Woking',
          N'GU22 7UY',
          N'Surrey',
          N'United Kingdom',
          N'James Teller',
          N'44-7778889999',
          N'44-1112223333',
          N'test@exporter.com',
          N'4B9B1842-0DE7-4589-91D0-C3D372BEA935',
          NULL)
  
  INSERT [Notification].[producer]
         ([id],
          [name],
          [issiteofexport],
          [type],
          [registrationnumber],
          [additionalregistrationnumber],
          [address1],
          [address2],
          [townorcity],
          [postalcode],
          [region],
          [country],
          [fullname],
          [telephone],
          [fax],
          [email],
          [producercollectionid],
          [otherdescription])
  VALUES (NEWID(),
          N'New Producer',
          0,
          1,
          N'Not applicable',
          NULL,
          N'Station Approach',
          N'Opp. TESCO',
          N'Woking',
          N'GU22 7UY',
          N'Surrey',
          N'United Kingdom',
          N'John Smith',
          N'44-7778889999',
          N'44-1112223333',
          N'test@producer.com',
          N'4B9B1842-0DE7-4589-91D0-C3D372BEA935',
          NULL)
  
  INSERT [Notification].[exporter]
         ([id],
          [name],
          [type],
          [registrationnumber],
          [additionalregistrationnumber],
          [address1],
          [address2],
          [townorcity],
          [postalcode],
          [region],
          [country],
          [fullname],
          [telephone],
          [fax],
          [email],
          [notificationid],
          [otherdescription])
  VALUES (NEWID(),
          N'Exporter',
          2,
          N'EXP12345',
          N'EXP12356',
          N'Station Approach',
          N'Opp. TESCO',
          N'Woking',
          N'GU22 7UY',
          N'Surrey',
          N'United Kingdom',
          N'John Smith',
          N'44-7778889999',
          N'44-1112223333',
          N'test@exporter.com',
          @NotificationId,
          NULL)
  
  INSERT [Notification].[shipmentinfo]
         ([id],
          [notificationid],
          [numberofshipments],
          [quantity],
          [units],
          [firstdate],
          [lastdate])
  VALUES (NEWID(),
          @NotificationId,
          520,
          Cast(35000.0000 AS DECIMAL(18, 4)),
          3,
          Cast(N'2016-09-01' AS DATE),
          Cast(N'2017-08-27' AS DATE))
  
  INSERT [Notification].[CarrierCollection]
  	   ([Id],
  	    [NotificationId])
  VALUES (N'0A564ADC-217C-4DFA-A04C-81233C09EFB4',
  		@NotificationId)
  
  INSERT [Notification].[carrier]
         ([id],
          [name],
          [carriercollectionid],
          [type],
          [registrationnumber],
          [additionalregistrationnumber],
          [address1],
          [address2],
          [townorcity],
          [postalcode],
          [region],
          [country],
          [fullname],
          [telephone],
          [fax],
          [email],
          [otherdescription])
  VALUES (NEWID(),
          N'Carrier',
          N'0A564ADC-217C-4DFA-A04C-81233C09EFB4',
          1,
          N'CARRIER12345',
          NULL,
          N'Business House',
          N'Reading Street',
          N'Guildford',
          N'GU21 5EM',
          N'Surrey',
          N'United Kingdom',
          N'Karen Murrey',
          N'44-4445556666',
          N'44-1112223333',
          N'test@carrier.com',
          NULL)
  
  INSERT [Notification].[carrier]
         ([id],
          [name],
          [carriercollectionid],
          [type],
          [registrationnumber],
          [additionalregistrationnumber],
          [address1],
          [address2],
          [townorcity],
          [postalcode],
          [region],
          [country],
          [fullname],
          [telephone],
          [fax],
          [email],
          [otherdescription])
  VALUES (NEWID(),
          N'Carrier Two',
          N'0A564ADC-217C-4DFA-A04C-81233C09EFB4',
          2,
          N'CAR98765',
          NULL,
          N'1 Bridge Lane',
          N'High Street',
          N'Send',
          N'GU22 1AA',
          N'Surrey',
          N'United Kingdom',
          N'Michael Murray',
          N'44-4445556666',
          N'44-1112223333',
          N'test@carrier.com',
          NULL)
  
  INSERT [Notification].[packaginginfo]
         ([id],
          [packagingtype],
          [otherdescription],
          [notificationid])
  VALUES (NEWID(),
          4,
          NULL,
          @NotificationId)
  
  INSERT [Notification].[packaginginfo]
         ([id],
          [packagingtype],
          [otherdescription],
          [notificationid])
  VALUES (NEWID(),
          5,
          NULL,
          @NotificationId)
  
  DECLARE @TransportRouteId UNIQUEIDENTIFIER = NEWID();
  INSERT INTO [Notification].[TransportRoute]
  ([Id], [NotificationId])
  VALUES (@TransportRouteId, 
  		@NotificationId)
  
  DECLARE @CountryId UNIQUEIDENTIFIER;
  
  SELECT @CountryId = id
  FROM   [Lookup].[country]
  WHERE  [name] = 'United Kingdom';
  
  DECLARE @CAId UNIQUEIDENTIFIER;
  
  SELECT @CAId = id
  FROM   [Lookup].[competentauthority]
  WHERE  [code] = 'GB01';
  
  DECLARE @EntryId UNIQUEIDENTIFIER;
  DECLARE @ExitId UNIQUEIDENTIFIER;
  
  SELECT @EntryId = id
  FROM   [Notification].[entryorexitpoint]
  WHERE  [name] = 'Dover';
  
  INSERT [Notification].[stateofexport]
         ([id],
          [TransportRouteId],
          [countryid],
          [competentauthorityid],
          [exitpointid])
  VALUES (NEWID(),
          @TransportRouteId,
          @CountryId,
          @CAId,
          @EntryId)
  
  SELECT @CountryId = id
  FROM   [Lookup].[country]
  WHERE  [name] = 'Germany';
  
  SELECT @CAId = id
  FROM   [Lookup].[competentauthority]
  WHERE  [code] = 'DE023';
  
  SELECT @ExitId = id
  FROM   [Notification].[entryorexitpoint]
  WHERE  [name] = 'Aachen';
  
  INSERT [Notification].[stateofimport]
         ([id],
          [TransportRouteId],
          [countryid],
          [competentauthorityid],
          [entrypointid])
  VALUES (NEWID(),
          @TransportRouteId,
          @CountryId,
          @CAId,
          @ExitId)
  
  SELECT @CountryId = id
  FROM   [Lookup].[country]
  WHERE  [name] = 'France';
  
  SELECT @CAId = id
  FROM   [Lookup].[competentauthority]
  WHERE  [code] = 'F';
  
  SELECT @EntryId = id
  FROM   [Notification].[entryorexitpoint]
  WHERE  [name] = 'Calais';
  
  SELECT @ExitId = id
  FROM   [Notification].[entryorexitpoint]
  WHERE  [name] = 'Lille';
  
  INSERT [Notification].[transitstate]
         ([id],
          [TransportRouteId],
          [countryid],
          [competentauthorityid],
          [entrypointid],
          [exitpointid],
          [ordinalposition])
  VALUES (NEWID(),
          @TransportRouteId,
          @CountryId,
          @CAId,
          @EntryId,
          @ExitId,
          1)
  
  INSERT [Notification].[operationcodes]
         ([id],
          [notificationid],
          [operationcode])
  VALUES (NEWID(),
          @NotificationId,
          14)
  
  INSERT [Notification].[operationcodes]
         ([id],
          [notificationid],
          [operationcode])
  VALUES (NEWID(),
          @NotificationId,
          15)
  
  INSERT [Notification].[operationcodes]
         ([id],
          [notificationid],
          [operationcode])
  VALUES (NEWID(),
          @NotificationId,
          16)
  
  DECLARE @WasteTypeId UNIQUEIDENTIFIER = NEWID();		
  		
  INSERT [Notification].[wastetype]
         ([id],
          [chemicalcompositiontype],
          [chemicalcompositionname],
          [chemicalcompositiondescription],
          [notificationid],
          [hasannex],
          [otherwastetypedescription],
          [energyinformation],
          [woodtypedescription],
          [optionalinformation])
  VALUES (@WasteTypeId,
          3,
          NULL,
          N'Wooden blocks',
          @NotificationId,
          0,
          NULL,
          NULL,
          N'Wooden blocks',
          NULL)
  
  INSERT [Notification].[wastecomposition]
         ([id],
          [constituent],
          [minconcentration],
          [maxconcentration],
          [wastetypeid],
          [chemicalcompositiontype])
  VALUES (NEWID(),
          N'Plastics',
          Cast(1.00 AS DECIMAL(5, 2)),
          Cast(3.00 AS DECIMAL(5, 2)),
          @WasteTypeId,
          2)
  
  INSERT [Notification].[wastecomposition]
         ([id],
          [constituent],
          [minconcentration],
          [maxconcentration],
          [wastetypeid],
          [chemicalcompositiontype])
  VALUES (NEWID(),
          N'Wood',
          Cast(1.00 AS DECIMAL(5, 2)),
          Cast(3.00 AS DECIMAL(5, 2)),
          @WasteTypeId,
          4)
  
  INSERT [Notification].[wastecomposition]
         ([id],
          [constituent],
          [minconcentration],
          [maxconcentration],
          [wastetypeid],
          [chemicalcompositiontype])
  VALUES (NEWID(),
          N'Paper',
          Cast(1.00 AS DECIMAL(5, 2)),
          Cast(3.00 AS DECIMAL(5, 2)),
          @WasteTypeId,
          1)
  
  INSERT [Notification].[wastecomposition]
         ([id],
          [constituent],
          [minconcentration],
          [maxconcentration],
          [wastetypeid],
          [chemicalcompositiontype])
  VALUES (NEWID(),
          N'Textiles',
          Cast(1.00 AS DECIMAL(5, 2)),
          Cast(3.00 AS DECIMAL(5, 2)),
          @WasteTypeId,
          5)
  
  INSERT [Notification].[wastecomposition]
         ([id],
          [constituent],
          [minconcentration],
          [maxconcentration],
          [wastetypeid],
          [chemicalcompositiontype])
  VALUES (NEWID(),
          N'Metals',
          Cast(1.00 AS DECIMAL(5, 2)),
          Cast(3.00 AS DECIMAL(5, 2)),
          @WasteTypeId,
          6)
  
  INSERT [Notification].[physicalcharacteristicsinfo]
         ([id],
          [physicalcharacteristictype],
          [otherdescription],
          [notificationid])
  VALUES (NEWID(),
          4,
          NULL,
          @NotificationId)
  
  INSERT [Notification].[physicalcharacteristicsinfo]
         ([id],
          [physicalcharacteristictype],
          [otherdescription],
          [notificationid])
  VALUES (NEWID(),
          3,
          NULL,
          @NotificationId)
  
  INSERT [Notification].[technologyemployed]
         ([id],
          [annexprovided],
          [details],
          [notificationid],
          [furtherdetails])
  VALUES (NEWID(),
          0,
          'Electrolysis',
          @NotificationId,
          'A cathode and anode are used to separate recoverable materials from an ionic solution of waste.')
  
  INSERT [Notification].[wastecodeinfo]
         ([id],
          [wastecodeid],
          [customcode],
          [notificationid],
  		[codetype])
  VALUES (NEWID(),
          (SELECT TOP 1 id FROM [Lookup].[WasteCode] WHERE [code] = 'A1030'),
          NULL,
          @NotificationId,
  		(SELECT TOP 1 CodeType FROM [Lookup].[WasteCode] WHERE [code] = 'A1030')),
  		(NEWID(),
          (SELECT TOP 1 id FROM [Lookup].[WasteCode] WHERE [code] = '01 05 04'),
          NULL,
          @NotificationId,
  		(SELECT TOP 1 CodeType FROM [Lookup].[WasteCode] WHERE [code] = '01 05 04')),
  		(NEWID(),
          NULL,
          N'1561231',
          @NotificationId,
  		8),
  		(NEWID(),
  		NULL,
          N'Iron filings',
          @NotificationId,
  		7),
  		(NEWID(),
  		NULL,
          N'GB01',
          @NotificationId,
  		9),
  		(NEWID(),
  		NULL,
          N'XV72663',
          @NotificationId,
  		10),
  		(NEWID(),
          (SELECT TOP 1 id FROM [Lookup].[WasteCode] WHERE [Description] = 'Explosives'),
          NULL,
          @NotificationId,
  		(SELECT TOP 1 CodeType FROM [Lookup].[WasteCode] WHERE [Description] = 'Explosives')),
  		(NEWID(),
          (SELECT TOP 1 id FROM [Lookup].[WasteCode] WHERE [code] = 'Y1'),
          NULL,
          @NotificationId,
  		(SELECT TOP 1 CodeType FROM [Lookup].[WasteCode] WHERE [code] = 'Y1')),
  		(NEWID(),
          (SELECT TOP 1 id FROM [Lookup].[WasteCode] WHERE [code] = 'H1'),
          NULL,
          @NotificationId,
  		(SELECT TOP 1 CodeType FROM [Lookup].[WasteCode] WHERE [code] = 'H1')),
  		(NEWID(),
          (SELECT TOP 1 Id FROM [Lookup].[WasteCode] WHERE [code] = 'UN 0004'),
          NULL,
          @NotificationId,
  		(SELECT TOP 1 CodeType FROM [Lookup].[WasteCode] WHERE [code] = 'UN 0004'));
  
  INSERT [Notification].[wasteadditionalinformation]
         ([id],
          [constituent],
          [minconcentration],
          [maxconcentration],
          [wastetypeid],
          [wasteinformationtype])
  VALUES (NEWID(),
          N'Chlorine',
          Cast(2.00 AS DECIMAL(5, 2)),
          Cast(5.00 AS DECIMAL(5, 2)),
          @WasteTypeId,
          5)
  
  INSERT [Notification].[wasteadditionalinformation]
         ([id],
          [constituent],
          [minconcentration],
          [maxconcentration],
          [wastetypeid],
          [wasteinformationtype])
  VALUES (NEWID(),
          N'Moisture content',
          Cast(2.00 AS DECIMAL(5, 2)),
          Cast(5.00 AS DECIMAL(5, 2)),
          @WasteTypeId,
          2)
  
  INSERT [Notification].[wasteadditionalinformation]
         ([id],
          [constituent],
          [minconcentration],
          [maxconcentration],
          [wastetypeid],
          [wasteinformationtype])
  VALUES (NEWID(),
          N'Ash content',
          Cast(2.00 AS DECIMAL(5, 2)),
          Cast(5.00 AS DECIMAL(5, 2)),
          @WasteTypeId,
          3)
  
  INSERT [Notification].[wasteadditionalinformation]
         ([id],
          [constituent],
          [minconcentration],
          [maxconcentration],
          [wastetypeid],
          [wasteinformationtype])
  VALUES (NEWID(),
          N'Net calorific value',
          Cast(2.00 AS DECIMAL(5, 2)),
          Cast(5.00 AS DECIMAL(5, 2)),
          @WasteTypeId,
          1)
  
  INSERT [Notification].[wasteadditionalinformation]
         ([id],
          [constituent],
          [minconcentration],
          [maxconcentration],
          [wastetypeid],
          [wasteinformationtype])
  VALUES (NEWID(),
          N'Heavy metals',
          Cast(2.00 AS DECIMAL(5, 2)),
          Cast(5.00 AS DECIMAL(5, 2)),
          @WasteTypeId,
          4)
  
  DECLARE @NotificationAssessmentId UNIQUEIDENTIFIER = NEWID();
  
  INSERT INTO [Notification].[notificationassessment]
              ([id],
               [notificationapplicationid],
               [status])
  VALUES      (@NotificationAssessmentId,
                @NotificationId,
                10 ) ;
  
  INSERT INTO [Notification].[NotificationDates]
  (
  	[Id],
  	[NotificationAssessmentId],
  	[NotificationReceivedDate],
      [PaymentReceivedDate],
      [CommencementDate],
      [CompleteDate],
      [TransmittedDate],
      [AcknowledgedDate],
      [NameOfOfficer]
  )
  VALUES
  (
  	(SELECT Cast(Cast(Newid() AS BINARY(10))
                             + Cast(Getdate() AS BINARY(6)) AS UNIQUEIDENTIFIER)),
  	@NotificationAssessmentId,
  	'2016-10-17',
  	'2016-10-17',
  	'2016-10-18',
  	'2016-10-18',
  	'2016-10-19',
  	'2016-10-20',
  	'Jane'
  )
  
  INSERT INTO [Notification].[Consent]
  (
  	[Id],
  	[From],
  	[To],
  	[Conditions],
  	[UserId],
  	[NotificationApplicationId]
  )
  VALUES
  (
  	(SELECT Cast(Cast(Newid() AS BINARY(10))
                             + Cast(Getdate() AS BINARY(6)) AS UNIQUEIDENTIFIER)),
  	'2016-10-20',
  	DATEADD(month, 1, CONVERT(date,GETDATE())),
  	'Let me win at chess',
  	(SELECT [Id] FROM [Identity].[AspNetUsers] WHERE [Email] LIKE 'superuser@environment-agency.gov.uk'),
  	@NotificationId
  )
  
  
  INSERT INTO [Notification].[FinancialGuaranteeCollection]
  			(
  				[Id],
  				[NotificationId]
  			)
  VALUES
  			(
  				(SELECT Cast(Cast(Newid() AS BINARY(10))
  							   + Cast(Getdate() AS BINARY(6)) AS UNIQUEIDENTIFIER)),
  				@NotificationId
  			)
  
  INSERT INTO [Notification].[FinancialGuarantee]
  (
  	[Id],
  	[Status],
  	[ReceivedDate],
  	[CompletedDate],
  	[CreatedDate],
  	[DecisionDate],
  	[ActiveLoadsPermitted],
  	[FinancialGuaranteeCollectionId],
  	[Decision]
  )
  VALUES
  (
  	(SELECT Cast(Cast(Newid() AS BINARY(10))
  					+ Cast(Getdate() AS BINARY(6)) AS UNIQUEIDENTIFIER)),
  	4,
  	'2016-10-13',
  	'2016-10-13',
  	GETDATE(),
  	'2016-10-20',
  	520,
  	(SELECT Id FROM [Notification].[FinancialGuaranteeCollection] WHERE [NotificationId] = @NotificationId),
  	1
  )
  
  INSERT [Notification].[EntryExitCustomsSelection]
  		(Id,
  		[Entry],
  		[Exit],
  		TransportRouteId
  		)
  VALUES (NEWID(),
  		0,
  		0,
  		@TransportRouteId)