Notifications
Clear all
Topic starter
I was wondering if there is anyway around the 50 character limit for email addresses. The clinic I work for refers patients on a daily basis so I would like to enter the specialist's email address and submit the TOCs electronically. My problem is that many of the specialists in my area have email addresses longer than 50 characters so I'm not able to enter the email under the service provider information in Administration. Any suggestions would be greatly appreciated.
Posted : May 16, 2016 9:10 am
mfornkahl,
You can change the length of the email column with a SQL script; That if you have access to the SQL Server.
If you don't have access you can request your DBA to execute the script below.
ALTER TABLE FORMULARY ALTER COLUMN CONTACTEMAIL VARCHAR (255)
Replace the 'FORMULARY' for whatever table this is applicable.
Most email related fields in Centricity have a length of 255 characters
Thank you,
Dennis
Posted : May 16, 2016 9:41 am
I'd caution the advice above. Changes to the schema can be dangerous. At the very least test it in a test system first.
Posted : May 21, 2016 4:34 pm
