Untitled

avatar
unknown
plain_text
3 months ago
70 kB
12
Indexable
-- ===============================================
-- ALC - ALCON
-- ===============================================
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','CO001','Core','LccName','ALCON Colombia',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','CO001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','CO001','Core','LccCode','CO001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','CO001','Core','hrisCode','SuccessFactors',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','FR001','Core','LccName','ALCON France',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','FR001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','FR001','Core','LccCode','FR001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','FR001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','NL001','Core','LccName','ALCON Netherlands',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','NL001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','NL001','Core','LccCode','NL001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','NL001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','US001','Core','LccName','ALCON United States',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','US001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','US001','Core','LccCode','US001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','US001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','US002','Core','LccName','Electracom US 2',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','US002','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','US002','Core','LccCode','US002',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','US002','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','US003','Core','LccName','Dummy Lcc',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','US003','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','US003','Core','LccCode','US003',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ALC','US003','Core','hrisCode','euHReka',GETUTCDATE())


-- ===============================================
-- ASM - ASML
-- ===============================================
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','CO001','Core','LccName','ASML Colombia',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','CO001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','CO001','Core','LccCode','CO001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','CO001','Core','hrisCode','SuccessFactors',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','FR001','Core','LccName','ASML France',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','FR001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','FR001','Core','LccCode','FR001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','FR001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','NL001','Core','LccName','ASML Netherlands',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','NL001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','NL001','Core','LccCode','NL001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','NL001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','US001','Core','LccName','ASML United States',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','US001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','US001','Core','LccCode','US001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','US001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','US002','Core','LccName','Electracom US 2',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','US002','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','US002','Core','LccCode','US002',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','US002','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','US003','Core','LccName','Dummy Lcc',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','US003','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','US003','Core','LccCode','US003',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ASM','US003','Core','hrisCode','euHReka',GETUTCDATE())


-- ===============================================
-- BHI - Baker-Hughes
-- ===============================================
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','CO001','Core','LccName','Baker-Hughes Colombia',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','CO001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','CO001','Core','LccCode','CO001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','CO001','Core','hrisCode','SuccessFactors',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','FR001','Core','LccName','Baker-Hughes France',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','FR001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','FR001','Core','LccCode','FR001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','FR001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','NL001','Core','LccName','Baker-Hughes Netherlands',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','NL001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','NL001','Core','LccCode','NL001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','NL001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','US001','Core','LccName','Baker-Hughes United States',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','US001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','US001','Core','LccCode','US001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','US001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','US002','Core','LccName','Electracom US 2',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','US002','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','US002','Core','LccCode','US002',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','US002','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','US003','Core','LccName','Dummy Lcc',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','US003','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','US003','Core','LccCode','US003',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','BHI','US003','Core','hrisCode','euHReka',GETUTCDATE())


-- ===============================================
-- DTV - DIRECTV Argentina
-- ===============================================
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','CO001','Core','LccName','DIRECTV Argentina Colombia',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','CO001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','CO001','Core','LccCode','CO001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','CO001','Core','hrisCode','SuccessFactors',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','FR001','Core','LccName','DIRECTV Argentina France',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','FR001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','FR001','Core','LccCode','FR001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','FR001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','NL001','Core','LccName','DIRECTV Argentina Netherlands',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','NL001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','NL001','Core','LccCode','NL001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','NL001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','US001','Core','LccName','DIRECTV Argentina United States',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','US001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','US001','Core','LccCode','US001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','US001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','US002','Core','LccName','Electracom US 2',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','US002','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','US002','Core','LccCode','US002',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','US002','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','US003','Core','LccName','Dummy Lcc',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','US003','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','US003','Core','LccCode','US003',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','DTV','US003','Core','hrisCode','euHReka',GETUTCDATE())


-- ===============================================
-- ECL - Ecolab DE
-- ===============================================
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','CO001','Core','LccName','Ecolab DE Colombia',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','CO001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','CO001','Core','LccCode','CO001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','CO001','Core','hrisCode','SuccessFactors',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','FR001','Core','LccName','Ecolab DE France',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','FR001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','FR001','Core','LccCode','FR001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','FR001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','NL001','Core','LccName','Ecolab DE Netherlands',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','NL001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','NL001','Core','LccCode','NL001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','NL001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','US001','Core','LccName','Ecolab DE United States',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','US001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','US001','Core','LccCode','US001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','US001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','US002','Core','LccName','Electracom US 2',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','US002','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','US002','Core','LccCode','US002',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','US002','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','US003','Core','LccName','Dummy Lcc',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','US003','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','US003','Core','LccCode','US003',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ECL','US003','Core','hrisCode','euHReka',GETUTCDATE())


-- ===============================================
-- FCA - Friesland Campina
-- ===============================================
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','CO001','Core','LccName','Friesland Campina Colombia',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','CO001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','CO001','Core','LccCode','CO001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','CO001','Core','hrisCode','SuccessFactors',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','FR001','Core','LccName','Friesland Campina France',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','FR001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','FR001','Core','LccCode','FR001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','FR001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','NL001','Core','LccName','Friesland Campina Netherlands',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','NL001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','NL001','Core','LccCode','NL001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','NL001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','US001','Core','LccName','Friesland Campina United States',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','US001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','US001','Core','LccCode','US001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','US001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','US002','Core','LccName','Electracom US 2',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','US002','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','US002','Core','LccCode','US002',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','US002','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','US003','Core','LccName','Dummy Lcc',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','US003','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','US003','Core','LccCode','US003',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','FCA','US003','Core','hrisCode','euHReka',GETUTCDATE())


-- ===============================================
-- HCC - Healthcare Company
-- ===============================================
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','CO001','Core','LccName','Healthcare Company Colombia',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','CO001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','CO001','Core','LccCode','CO001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','CO001','Core','hrisCode','SuccessFactors',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','FR001','Core','LccName','Healthcare Company France',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','FR001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','FR001','Core','LccCode','FR001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','FR001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','NL001','Core','LccName','Healthcare Company Netherlands',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','NL001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','NL001','Core','LccCode','NL001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','NL001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','US001','Core','LccName','Healthcare Company United States',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','US001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','US001','Core','LccCode','US001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','US001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','US002','Core','LccName','Electracom US 2',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','US002','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','US002','Core','LccCode','US002',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','US002','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','US003','Core','LccName','Dummy Lcc',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','US003','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','US003','Core','LccCode','US003',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','HCC','US003','Core','hrisCode','euHReka',GETUTCDATE())


-- ===============================================
-- JCC - JNTL
-- ===============================================
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','CO001','Core','LccName','JNTL Colombia',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','CO001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','CO001','Core','LccCode','CO001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','CO001','Core','hrisCode','SuccessFactors',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','FR001','Core','LccName','JNTL France',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','FR001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','FR001','Core','LccCode','FR001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','FR001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','NL001','Core','LccName','JNTL Netherlands',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','NL001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','NL001','Core','LccCode','NL001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','NL001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','US001','Core','LccName','JNTL United States',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','US001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','US001','Core','LccCode','US001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','US001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','US002','Core','LccName','Electracom US 2',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','US002','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','US002','Core','LccCode','US002',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','US002','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','US003','Core','LccName','Dummy Lcc',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','US003','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','US003','Core','LccCode','US003',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JCC','US003','Core','hrisCode','euHReka',GETUTCDATE())


-- ===============================================
-- JNJ - Johnson & Johnson
-- ===============================================
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','CO001','Core','LccName','Johnson & Johnson Colombia',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','CO001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','CO001','Core','LccCode','CO001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','CO001','Core','hrisCode','SuccessFactors',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','FR001','Core','LccName','Johnson & Johnson France',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','FR001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','FR001','Core','LccCode','FR001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','FR001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','NL001','Core','LccName','Johnson & Johnson Netherlands',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','NL001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','NL001','Core','LccCode','NL001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','NL001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','US001','Core','LccName','Johnson & Johnson United States',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','US001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','US001','Core','LccCode','US001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','US001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','US002','Core','LccName','Electracom US 2',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','US002','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','US002','Core','LccCode','US002',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','US002','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','US003','Core','LccName','Dummy Lcc',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','US003','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','US003','Core','LccCode','US003',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','JNJ','US003','Core','hrisCode','euHReka',GETUTCDATE())


-- ===============================================
-- MAE - Maersk
-- ===============================================
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','CO001','Core','LccName','Maersk Colombia',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','CO001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','CO001','Core','LccCode','CO001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','CO001','Core','hrisCode','SuccessFactors',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','FR001','Core','LccName','Maersk France',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','FR001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','FR001','Core','LccCode','FR001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','FR001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','NL001','Core','LccName','Maersk Netherlands',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','NL001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','NL001','Core','LccCode','NL001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','NL001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','US001','Core','LccName','Maersk United States',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','US001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','US001','Core','LccCode','US001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','US001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','US002','Core','LccName','Electracom US 2',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','US002','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','US002','Core','LccCode','US002',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','US002','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','US003','Core','LccName','Dummy Lcc',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','US003','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','US003','Core','LccCode','US003',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','MAE','US003','Core','hrisCode','euHReka',GETUTCDATE())


-- ===============================================
-- SAM - Samsung
-- ===============================================
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','CO001','Core','LccName','Samsung Colombia',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','CO001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','CO001','Core','LccCode','CO001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','CO001','Core','hrisCode','SuccessFactors',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','FR001','Core','LccName','Samsung France',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','FR001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','FR001','Core','LccCode','FR001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','FR001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','NL001','Core','LccName','Samsung Netherlands',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','NL001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','NL001','Core','LccCode','NL001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','NL001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','US001','Core','LccName','Samsung United States',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','US001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','US001','Core','LccCode','US001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','US001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','US002','Core','LccName','Electracom US 2',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','US002','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','US002','Core','LccCode','US002',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','US002','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','US003','Core','LccName','Dummy Lcc',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','US003','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','US003','Core','LccCode','US003',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','SAM','US003','Core','hrisCode','euHReka',GETUTCDATE())


-- ===============================================
-- UNI - Unilever
-- ===============================================
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','CO001','Core','LccName','Unilever Colombia',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','CO001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','CO001','Core','LccCode','CO001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','CO001','Core','hrisCode','SuccessFactors',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','FR001','Core','LccName','Unilever France',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','FR001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','FR001','Core','LccCode','FR001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','FR001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','NL001','Core','LccName','Unilever Netherlands',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','NL001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','NL001','Core','LccCode','NL001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','NL001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','US001','Core','LccName','Unilever United States',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','US001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','US001','Core','LccCode','US001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','US001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','US002','Core','LccName','Electracom US 2',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','US002','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','US002','Core','LccCode','US002',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','US002','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','US003','Core','LccName','Dummy Lcc',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','US003','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','US003','Core','LccCode','US003',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','UNI','US003','Core','hrisCode','euHReka',GETUTCDATE())


-- ===============================================
-- VES - Vestas
-- ===============================================
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','CO001','Core','LccName','Vestas Colombia',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','CO001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','CO001','Core','LccCode','CO001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','CO001','Core','hrisCode','SuccessFactors',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','FR001','Core','LccName','Vestas France',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','FR001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','FR001','Core','LccCode','FR001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','FR001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','NL001','Core','LccName','Vestas Netherlands',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','NL001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','NL001','Core','LccCode','NL001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','NL001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','US001','Core','LccName','Vestas United States',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','US001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','US001','Core','LccCode','US001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','US001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','US002','Core','LccName','Electracom US 2',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','US002','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','US002','Core','LccCode','US002',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','US002','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','US003','Core','LccName','Dummy Lcc',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','US003','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','US003','Core','LccCode','US003',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','VES','US003','Core','hrisCode','euHReka',GETUTCDATE())


-- ===============================================
-- ENE - Eneco
-- ===============================================
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','CO001','Core','LccName','Eneco Colombia',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','CO001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','CO001','Core','LccCode','CO001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','CO001','Core','hrisCode','SuccessFactors',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','FR001','Core','LccName','Eneco France',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','FR001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','FR001','Core','LccCode','FR001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','FR001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','NL001','Core','LccName','Eneco Netherlands',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','NL001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','NL001','Core','LccCode','NL001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','NL001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','US001','Core','LccName','Eneco United States',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','US001','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','US001','Core','LccCode','US001',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','US001','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','US002','Core','LccName','Electracom US 2',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','US002','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','US002','Core','LccCode','US002',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','US002','Core','hrisCode','euHReka',GETUTCDATE())

insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','US003','Core','LccName','Dummy Lcc',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','US003','Core','PayrollProviderCode','euHReka',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','US003','Core','LccCode','US003',GETUTCDATE())
insert into [dbo].[PlatformActivation] ([Street],[GlobalCustomerCode],[LocalCountryCode],[Prefix],[Key],[Value],[LastUpdate])
 values('EU01','ENE','US003','Core','hrisCode','euHReka',GETUTCDATE())
Editor is loading...
Leave a Comment