Reference ZenDesk Incident: 1561442
Description: When BGRS acquires new clients as part of the business process they will contact I.T. to upload/enable the client in MoveXpert. Attached in the ZenDesk request you will find an Excel sheet with the OrgName and OrgNumber.
-- Below is the DBCR you will need to add clients into MoveXpert
IF (@@SERVERNAME not in ('SQLPPLumpsum\LUMPSUM'))
PRINT 'ERROR: This script is only intended to run on correct server name'
PRINT 'INC- 1561442 - Add new client to MoveXpert'
Insert Into Client
(601171,'Honeywell Helios Inc',1 ),
(601170,'United Airlines',1 ),
IF EXISTS (select 3 from Client where ClientNumber in ('601171','601170','601162')and ClientName in ('Honeywell Helios Inc','United Airlines','L''Oreal'))
PRINT 'ERROR: Verification failed!'
Once the DBCR has been applied by the DBA team have the requestor provide confirmation by validating in MoveXpert that the client list provided is now visible in the application.