With the release of WIMS Client 8.3.4 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.4 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','','')

INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('DBUP','2025-03-29 08:34:00','MDEINFO','MDEINFO(formname/id,stat,date,optional where clause)','Monthly Data Entry Form Information','14825','SPECIAL','','')

Facility Databases

ALTER TABLE VARDESC ADD ISACTIVE [Numeric](18, 0)  NOT NULL DEFAULT (-1)

ALTER TABLE MDE ADD RIOGUID [uniqueidentifier] NULL DEFAULT (NULL)

CREATE TABLE [dbo].[EVENTTRIGGERS]([ID] [int] IDENTITY(1,1) NOT NULL,[AUDITUSER] [varchar](50) NULL,[AUDITTIMESTAMP] [datetime] NULL DEFAULT (getdate()),[NAME] [nvarchar](500) NULL,[NOTES] [nvarchar](100) NULL,[VARID] [Numeric](18, 0) NULL DEFAULT NULL,[NOTIFICATIONLISTID] [numeric](18, 0) NULL DEFAULT (NULL),[COMPARE] [nvarchar](255) NULL,[COMPAREVALUE] [FLOAT] NULL) ON [PRIMARY]

ALTER TABLE UDCAPS ALTER COLUMN CAPTION NVARCHAR(50)

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 TRIGGERNOTIFICATIONLISTID [numeric](18, 0) 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:

ALTER TABLE LC_SCHEDULE ADD YEARMONTHDAYYEARFREQ [Numeric](18, 0) NOT NULL DEFAULT (1)
ALTER TABLE LC_SCHEDTEMP ADD YEARMONTHDAYYEARFREQ [Numeric](18, 0) NOT NULL DEFAULT (1)

ALTER TABLE LC_SCHEDULE ADD YEARCRITYEARFREQ [Numeric](18, 0) NOT NULL DEFAULT (1)
ALTER TABLE LC_SCHEDTEMP ADD YEARCRITYEARFREQ [Numeric](18, 0) NOT NULL DEFAULT (1)

 

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

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

EVENTTYPE=Triggered Sample
DESCRIPTION=Triggered Sample
SYSTEM_CLASS=7

EVENTTYPE=Triggered Event
DESCRIPTION=Triggered Event
SYSTEM_CLASS=8

 

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'','','')

INSERT INTO SPREADFUNCTIONS (AUDITUSER, AUDITTIMESTAMP,NAME,SYNTAX, DESCRIPTION,HELPID, TAG1,TAG2, TAG3) VALUES ('DBUP','2025-03-29 08:34:00','MDEINFO','MDEINFO(formname/id,stat,date,optional where clause)','Monthly Data Entry Form Information','14825','SPECIAL','','')

Facility Databases

ALTER TABLE VARDESC ADD ISACTIVE NUMBER DEFAULT -1

ALTER TABLE MDE ADD RIOGUID NVARCHAR2 (100) NULL

ALTER TABLE UDCAPS MODIFY(CAPTION NVARCHAR2(50))

ALTER TABLE LOGBOOKENTRIES ADD RIOID NVARCHAR2 (100) NULL

CREATE TABLE "EVENTTRIGGERS"
                 ("ID" NUMBER NOT NULL,
                "AUDITUSER"  VARCHAR2(50) NULL,
                "AUDITTIMESTAMP"  DATE DEFAULT NULL,
                "NAME"  NVARCHAR2 (500) NULL,
                "NOTES" NVARCHAR2 (1000) NULL,
                "VARID" NUMBER DEFAULT NULL,
                "NOTIFICATIONLISTID" NUMBER DEFAULT NULL,
                "COMPARE"  NVARCHAR2 (255) NULL,
                "COMPAREVALUE" NUMBER DEFAULT 0 NULL)

CREATE SEQUENCE  "A_EVENTTRIGGERS" INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE CACHE 20 NOORDER

CREATE TRIGGER "T_EVENTTRIGGERS"  BEFORE INSERT ON  "EVENTTRIGGERS"  FOR EACH ROW BEGIN SELECT "A_EVENTTRIGGERS" .NEXTVAL INTO :NEW "ID" FROM DUAL; END T_EVENTTRIGGERS;

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

ALTER TABLE LC_SCHEDULE ADD YEARMONTHDAYYEARFREQ NUMBER DEFAULT 1
ALTER TABLE LC_SCHEDTEMP ADD YEARMONTHDAYYEARFREQ NUMBER DEFAULT 1
ALTER TABLE LC_SCHEDULE ADD YEARCRITYEARFREQ NUMBER DEFAULT 1
ALTER TABLE LC_SCHEDTEMP ADD YEARCRITYEARFREQ NUMBER DEFAULT 1

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

EVENTTYPE=Triggered Sample
DESCRIPTION=Triggered Sample
SYSTEM_CLASS=7