With the release of WIMS Client 8.5.0 a database upgrade is required. The upgrade is automatically applied when logging into a Facility Database for the first time with the WIMS 8.5.0 client. Tech Notes:SQL Server scripts:
Added EventType Record for customer complaint
EventType="Customer Complaint"
Description = "Customer Complaint"
RecOrder = ?
ShowStartDate = True
SHOWENDDATE = False
SHOWDURATION = False
SHOWFLOW = False
SHOWDATEDUE = True
SHOWDATECOMPLETE = True
UD1CAPTION = "SAMPLENUM"
UD1TYPE = 2
UD2CAPTION = "UD2"
UD2TYPE = 0
CHANGE_LOCATION_STATUS = False
LOCATION_STATUS_TYPE_ID = Null
VAR_REQUIRED = False
SYSTEM_CLASS = 9
ALTER TABLE MDE ADD DYNAMICSQL NVARCHAR(4000) NULL DEFAULT (NULL)
ALTER TABLE LC_TEST ADD RECVSAMPLE [Numeric](18, 0) NOT NULL DEFAULT (0)
ALTER TABLE LOCATION ADD MONSITEID NVARCHAR(50) NULL DEFAULT (NULL)
Oracle Scripts
Add Event Type Record (described above)
ALTER TABLE MDE ADD DYNAMICSQL NVARCHAR2(2000) DEFAULT NULL
ALTER TABLE LC_TEST ADD RECVSAMPLE NUMBER DEFAULT 0
ALTER TABLE LOCATION ADD MONSITEID NVARCHAR2(50) DEFAULT NULL
|