• Rename customer directory on Pandora
• Rename Contract Log spreadsheet
• Rename user in FTP server and edit directory access
• Update CCare to reflect new code

update HLC_ASSIGNMENTS set CUST_CODE = :new where CUST_CODE = :old;
update HLC_CUST_ENVIRONMENTS set USER_CODE = :new where USER_CODE = :old;
update HLC_CUST_PROFILE set USER_CODE = :new where USER_CODE = :old;
update HLC_CUST_SUBORGS set USER_CODE = :new where USER_CODE = :old;
update HLC_FILES_DOWNLOADED set USER_CODE = :new where USER_CODE = :old;
update HLC_HUG set CUST_CODE = :new where CUST_CODE = :old;
update HLC_NOTIFICATIONS_SENT set CUSTOMER_CODE = :new where CUSTOMER_CODE = :old;
update HLC_PATCHES_SENT set CUSTOMER_CODE = :new where CUSTOMER_CODE = :old;
update HLC_QUOTES set CUSTOMER_CODE = :new where CUSTOMER_CODE = :old;
update HLC_TASKS set CUSTOMER_CODE = :new where CUSTOMER_CODE = :old;
update HLC_TIMESHEETS set USER_CODE = :new where USER_CODE = :old;
update HLC_TRIP_REPORTS set CUST_CODE = :new where CUST_CODE = :old;
update HLC_WORK_DAYS set USER_CODE = :new where USER_CODE = :old;
update NXSCUSTE set USER_CODE = :new where USER_CODE = :old;

• ReleaseWiki updates:
  • Create new user and remove old one
  • Add New user to license groups for Oracle etc. as needed
  • Rename Custom Patches page with new customer code and name, and also change the Access Control List at the top of the page.

HighLine.Standard Operating Procedures