With the release of WIMS Client 8.3.2 a database upgrade is required.  The upgrade is automatically applied when logging into a Facility Database for the first time with the WIMS 8.3.2 client. 

Tech Notes:

SQL Server Scripts:

OPSROOT

INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('DBUP','2025-03-29 08:34:00','OEL','OEL(VarNum,QtrOffset/Date)','Operational Evaluation Level','14818','SPECIAL'','','')

INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('DBUP','2025-03-29 08:34:00','OELZ','OELZ(VarNum,QtrOffset/Date,Decimal Places, MDL Rule, optional No Value Print)','Operational Evaluation Level','14819','SPECIAL'','','')

INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('DBUP','2025-03-29 08:34:00','LRAA','LRAA(VarNum,QtrOffset/Date)',Locational Running Annual Averages (LRAA)','14816','SPECIAL'','','')

INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('DBUP','2025-03-29 08:34:00','LRAAZ','LRAAZ(VarNum,QtrOffset/Date,Decimal Places, MDL Rule, optional No Value Print)',Locational Running Annual Averages (LRAA)','14817','SPECIAL'','','')

Facility Databases

ALTER TABLE LOGBOOKENTRIES ADD RIOID [uniqueidentifier] NULL

ALTER TABLE LC_SAMPLEDEF ADD TRIGGERVARID [numeric](18, 0) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLEDEF ADD TRIGGERCOMPARE NVARCHAR(20) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLEDEF ADD TRIGGERVALUE FLOAT NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLEDEF ADD TRIGGERGROUPING NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLEDEF ADD TRIGGERSTAT NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLEDEF ADD TRIGGERCREATE NVARCHAR(50) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLEDEF ADD TRIGGERMESSAGE NVARCHAR(1000) NULL DEFAULT (NULL)

ALTER TABLE LC_SAMPLEDEF ADD LATERESULTNOTIFICATIONLISTID [numeric](18, 0) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLEDEF ADD LATERESULTNOTIFYAFTERDAYS [numeric](18, 0) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLEDEF ADD LATERESULTNOTIFYAFTERHOURS [numeric](18, 0) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLEDEF ADD NORESULTNOTIFICATIONLISTID [numeric](18, 0) NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLE ADD LATERESULTEMAILSENT DATETIME NULL DEFAULT (NULL)
ALTER TABLE LC_SAMPLE ADD NORESULTEMAILSENT DATETIME NULL DEFAULT (NULL)

Add Records to EventType Table:

EVENTTYPE=Sample Missing Results
DESCRIPTION=Sample Missing Results Notification
SYSTEM_CLASS=6

EVENTTYPE=Closed Sample Missing Results 
DESCRIPTION=Closed Sample Missing Results Notification
SYSTEM_CLASS=5

Oracle:

OPSROOT

INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('DBUP','2025-03-29 08:34:00','OEL','OEL(VarNum,QtrOffset/Date)','Operational Evaluation Level','14818','SPECIAL'','','')

INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('DBUP','2025-03-29 08:34:00','OELZ','OELZ(VarNum,QtrOffset/Date,Decimal Places, MDL Rule, optional No Value Print)','Operational Evaluation Level','14819','SPECIAL'','','')

INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('DBUP','2025-03-29 08:34:00','LRAA','LRAA(VarNum,QtrOffset/Date)',Locational Running Annual Averages (LRAA)','14816','SPECIAL'','','')

INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('DBUP','2025-03-29 08:34:00','LRAAZ','LRAAZ(VarNum,QtrOffset/Date,Decimal Places, MDL Rule, optional No Value Print)',Locational Running Annual Averages (LRAA)','14817','SPECIAL'','','')

Facility Databases

ALTER TABLE LOGBOOKENTRIES ADD RIOID NVARCHAR2 (100) NULL

ALTER TABLE LC_SAMPLEDEF ADD TRIGGERVARID NUMBER DEFAULT NULL
ALTER TABLE LC_SAMPLEDEF ADD TRIGGERCOMPARE NVARCHAR2(20) DEFAULT NULL
ALTER TABLE LC_SAMPLEDEF ADD TRIGGERVALUE NUMBER DEFAULT NULL
ALTER TABLE LC_SAMPLEDEF ADD TRIGGERGROUPING NVARCHAR2(20) DEFAULT NULL
ALTER TABLE LC_SAMPLEDEF ADD TRIGGERSTAT NVARCHAR2(50) DEFAULT NULL
ALTER TABLE LC_SAMPLEDEF ADD TRIGGERCREATE NVARCHAR2(50) DEFAULT NULL
ALTER TABLE LC_SAMPLEDEF ADD TRIGGERMESSAGE NVARCHAR2(1000) DEFAULT NULL

ALTER TABLE LC_SAMPLEDEF ADD LATERESULTNOTIFICATIONLISTID NUMBER NULL
ALTER TABLE LC_SAMPLEDEF ADD LATERESULTNOTIFYAFTERDAYS NUMBER NULL
ALTER TABLE LC_SAMPLEDEF ADD LATERESULTNOTIFYAFTERHOURS NUMBER NULL
ALTER TABLE LC_SAMPLEDEF ADD NORESULTNOTIFICATIONLISTID NUMBER NULL
ALTER TABLE LC_SAMPLE ADD LATERESULTEMAILSENT DATE NULL
ALTER TABLE LC_SAMPLE ADD NORESULTEMAILSENT DATE NULL

Add Records to EventType Table:

EVENTTYPE=Sample Missing Results
DESCRIPTION=Sample Missing Results Notification
SYSTEM_CLASS=6

EVENTTYPE=Closed Sample Missing Results 
DESCRIPTION=Closed Sample Missing Results Notification
SYSTEM_CLASS=5