OTHERS -IsPerionCon - (views - vvICDRVS - compare and alter the code) -CF 2, ordinal error -solutions: sp - EmployerInfo - script nasa 200.6 -NameSuffix only add at tbMaster ---------------------------------------------------------------------------------------------- CF 2 LAST NAME NOT FOUND: ALTER TABLE [PATIENT_DATA].[dbo].[tbMaster2] ADD BirthPlace [varchar](500) NULL GO ALTER TABLE [PATIENT_DATA].[dbo].[tbmaster] ADD [NameSuffix] [varchar](20) NULL GO ---------------------------------------------------------------------------------------------- UPON ENTRY CF 4 ALTER TABLE Patient_Data..tbPatientHistory ADD AlertTags VARCHAR (250) NULL GO ALTER TABLE Patient_Data..tbOutPatientHistory ADD AlertTags VARCHAR (250) NULL GO ---------------------------------------------------------------------------------------------- CF 4 OverrideRateLetter ALTER TABLE Build_File..tbCoCompany ADD OverrideRateLetter VARCHAR(5) GO