Untitled
unknown
plain_text
2 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