diff --git a/adapter/adapter-service/pom.xml b/adapter/adapter-service/pom.xml
index 1b082995f..168caeaa3 100644
--- a/adapter/adapter-service/pom.xml
+++ b/adapter/adapter-service/pom.xml
@@ -1,181 +1,181 @@
4.0.0SHRINE Adaptershrine-adapter-servicejarnet.shrineshrine-base1.21.0-SNAPSHOT../../pom.xmlsrc/main/scalasrc/test/scalanet.alchim31.mavenscala-maven-pluginorg.apache.maven.pluginsmaven-jar-plugintest-jarorg.squerylsqueryl_${scala-major-version}org.scala-langscalaporg.scala-langscalap${scala-version}net.shrineshrine-auth${project.version}net.shrineshrine-adapter-client-api${project.version}net.shrineshrine-data-commons${project.version}net.shrineshrine-crypto${project.version}net.shrineshrine-crypto${project.version}test-jartestnet.shrineshrine-client${project.version}net.shrineshrine-protocol${project.version}net.shrineshrine-config${project.version}com.typesafe.slickslick_2.11${slick-version}org.suecarterfreeslick_2.11
- 3.0.3.1
+ ${freeslick-version}org.slf4jslf4j-log4j12${slf4j-version}mysqlmysql-connector-javacom.sun.jersey.jersey-test-frameworkjersey-test-framework-http${jersey-version}testcom.sun.jersey.contribsjersey-simple-server${jersey-version}testcom.h2databaseh2testorg.easymockeasymocktestorg.springframeworkspring-jdbctestnet.shrineshrine-util${project.version}test-jartestnet.shrineshrine-test-commons${project.version}test-jartestnet.shrineshrine-data-commons${project.version}test-jartest
diff --git a/apps/steward-app/pom.xml b/apps/steward-app/pom.xml
index d5a0ee193..fc92b582a 100644
--- a/apps/steward-app/pom.xml
+++ b/apps/steward-app/pom.xml
@@ -1,192 +1,192 @@
shrine-basenet.shrine1.21.0-SNAPSHOT../../pom.xml4.0.0steward-appSteward Appjarsrc/main/scalasrc/test/scalanet.alchim31.mavenscala-maven-plugincom.github.eirslettfrontend-maven-plugin0.0.23src/main/jsinstall node and npminstall-node-and-npmv0.10.332.7.4npm installnpmgenerate-resourcesinstallbower installbowerinstallgrunt defaultgrunt--no-colorio.sprayspray-routing_2.11${spray-version}io.sprayspray-servlet_2.11${spray-version}io.sprayspray-util_2.11${spray-version}io.sprayspray-testkit_2.11${spray-version}testcom.typesafe.akkaakka-actor_2.11${akka-version}com.typesafe.akkaakka-slf4j_2.11${akka-version}com.typesafe.akkaakka-testkit_2.11${akka-testkit-version}testorg.json4sjson4s-native_2.11${json4s-version}com.typesafe.slickslick_2.11${slick-version}org.suecarterfreeslick_2.11
- 3.0.3.1
+ ${freeslick-version}org.slf4jslf4j-log4j12${slf4j-version}com.h2databaseh2${h2-version}testnet.shrineshrine-protocol${project.version}net.shrineshrine-data-commons${project.version}net.shrineshrine-client${project.version}net.shrineshrine-crypto${project.version}test-jartestnet.shrineshrine-auth${project.version}mysqlmysql-connector-java${mysql-version}
diff --git a/pom.xml b/pom.xml
index 07b264f08..f3e40de02 100644
--- a/pom.xml
+++ b/pom.xml
@@ -1,376 +1,377 @@
4.0.0SHRINEnet.shrineshrine-basepom1.21.0-SNAPSHOTUTF-84.2.2.RELEASE2.6.22.11.72.114.121.7.121.2.171.192.2.53.2.20.9.6-RC41.2.11.4.1903.45.1.372.33.0.10.9.51.3.32.3.82.4.03.3.03.1.0
+ 3.1.1.1apps/dashboard-appapps/dashboard-warapps/steward-appapps/steward-warapps/proxyapps/shrine-appapps/warqep/servicehub/broadcaster-aggregatorhub/broadcaster-serviceadapter/adapter-apiadapter/adapter-servicehms-supporttoolscommons/utilcommons/authcommons/protocol-querycommons/data-commonscommons/protocolcommons/cryptocommons/clientcommons/configcommons/ont-supportcommons/test-commonsinstallintegrationshrine-webclientnet.alchim31.mavenscala-maven-plugin${scala-maven-plugin-version}compilecompilecompiletest-compiletestCompiletest-compileprocess-resourcescompileincrementaltrue-XX:+AggressiveOpts-XX:CompileThreshold=500-XX:+UseFastAccessorMethods-XX:+UseStringCache-XX:+OptimizeStringConcat-XX:+TieredCompilation-XX:+UseConcMarkSweepGC-XX:+DoEscapeAnalysis-server-Xms64m-Xmx1024m-XX:MaxPermSize=384m${scala-version}-Xcheckinit-unchecked-deprecation-Xlint:adapted-args,inaccessible,infer-any,missing-interpolator,private-shadow,type-parameter-shadow,unsound-match7maven-compiler-plugin7org.codehaus.mojobuildnumber-maven-plugin1.1org.apache.maven.pluginsmaven-jar-plugin2.4org.apache.maven.pluginsmaven-war-plugin2.1.1org.codehaus.mojobuildnumber-maven-pluginvalidatecreate{0,date,yyyy-MM-dd HH:mm:ss}(not available)org.apache.maven.pluginsmaven-jar-plugintrue${buildNumber}${scmBranch}${timestamp}org.apache.maven.pluginsmaven-war-plugintrue${buildNumber}${scmBranch}${timestamp}org.apache.tomcat.maventomcat7-maven-plugin2.2truetruetruetruehttp://shrine-dev1.catalyst:6060/shrine/rest/happyscm:git:https://open.med.harvard.edu/stash/scm/shrine/shrine.gitCBMI-Nexushttps://repo.open.med.harvard.edu/nexus/content/groups/public/com.typesafeconfig${typesafe-config-version}log4jlog4j${log4j-version}org.springframeworkspring-jdbc${spring.version}testcom.h2databaseh2${h2-version}testorg.easymockeasymock${easymock-version}testorg.slf4jslf4j-log4j12${slf4j-version}testmysqlmysql-connector-java${mysql-version}net.sf.opencsvopencsv${opencsv-version}net.liftweblift-json_${scala-major-version}${lift-version}com.sun.jerseyjersey-server${jersey-version}com.sun.jerseyjersey-servlet${jersey-version}com.sun.jerseyjersey-client${jersey-version}org.squerylsqueryl_${scala-major-version}${squeryl-version}javax.servletjavax.servlet-api${servlet-api-version}providedorg.scala-langscala-library${scala-version}junitjunit${junit-version}testorg.scalatestscalatest_${scala-major-version}${scalatest-version}testorg.scala-langscala-actorsorg.scala-langscala-reflectorg.scala-langscala-actors${scala-version}testorg.scala-langscala-reflect${scala-version}nexusNexus Repohttps://repo.open.med.harvard.edu/nexus/content/repositories/snapshotsfalsenexusNexus Repohttps://repo.open.med.harvard.edu/nexus/content/repositories/releases
diff --git a/qep/service/pom.xml b/qep/service/pom.xml
index 9f71edef3..cb8dab253 100644
--- a/qep/service/pom.xml
+++ b/qep/service/pom.xml
@@ -1,215 +1,215 @@
4.0.0SHRINE Serviceshrine-qepjarnet.shrineshrine-base1.21.0-SNAPSHOT../../pom.xmlsrc/main/scalasrc/test/scalanet.alchim31.mavenscala-maven-pluginfalseorg.squerylsqueryl_${scala-major-version}org.scala-langscalaporg.scala-langscalap${scala-version}com.sun.jerseyjersey-servercom.sun.jerseyjersey-clientnet.shrineshrine-auth${project.version}net.shrineshrine-broadcaster-aggregator${project.version}net.shrineshrine-crypto${project.version}net.shrineshrine-client${project.version}net.shrineshrine-adapter-client-api${project.version}net.shrineshrine-protocol${project.version}net.shrineshrine-data-commons${project.version}com.typesafe.slickslick_2.11${slick-version}org.suecarterfreeslick_2.11
- 3.0.3.1
+ ${freeslick-version}org.slf4jslf4j-log4j12${slf4j-version}mysqlmysql-connector-javalog4jlog4jcom.sun.jersey.jersey-test-frameworkjersey-test-framework-http${jersey-version}testcom.sun.jersey.contribsjersey-simple-server${jersey-version}testcom.h2databaseh2testorg.easymockeasymocktestorg.springframeworkspring-jdbctestnet.shrineshrine-test-commons${project.version}test-jartestnet.shrineshrine-data-commons${project.version}test-jartestnet.shrineshrine-config${project.version}test-jartestnet.shrineshrine-util${project.version}test-jartestorg.codehaus.mojofindbugs-maven-plugin2.3.1Maxorg.codehaus.mojocobertura-maven-plugin2.3org.apache.maven.pluginsmaven-checkstyle-plugin2.5org.apache.maven.pluginsmaven-pmd-plugin2.41.6
diff --git a/qep/service/src/main/sql/mssql.ddl b/qep/service/src/main/sql/mssql.ddl
index c3c03c10a..45e83498d 100644
--- a/qep/service/src/main/sql/mssql.ddl
+++ b/qep/service/src/main/sql/mssql.ddl
@@ -1,7 +1,8 @@
create database qepAuditDB;
use qepAuditDB;
create table "queriesSent" ("shrineNodeId" TEXT NOT NULL,"userName" TEXT NOT NULL,"networkQueryId" BIGINT NOT NULL,"queryName" TEXT NOT NULL,"queryTopicId" TEXT,"queryTopicName" TEXT,"timeQuerySent" BIGINT NOT NULL);
-create table "queriesReceived" ("shrineNodeId" TEXT NOT NULL,"userName" TEXT NOT NULL,"networkQueryId" BIGINT NOT NULL,"queryName" TEXT NOT NULL,"topicId" TEXT,"topicName" TEXT,"timeQuerySent" BIGINT NOT NULL,"timeReceived" BIGINT NOT NULL);
-create table "executionsStarted" ("networkQueryId" BIGINT NOT NULL,"queryName" TEXT NOT NULL,"timeExecutionStarted" BIGINT NOT NULL);
-create table "executionsCompleted" ("networkQueryId" BIGINT NOT NULL,"replyId" BIGINT NOT NULL,"queryName" TEXT NOT NULL,"timeExecutionCompleted" BIGINT NOT NULL);
-create table "resultsSent" ("networkQueryId" BIGINT NOT NULL,"replyId" BIGINT NOT NULL,"queryName" TEXT NOT NULL,"timeResultsSent" BIGINT NOT NULL);
\ No newline at end of file
+create table "previousQueries" ("networkId" BIGINT NOT NULL,"userName" TEXT NOT NULL,"domain" TEXT NOT NULL,"queryName" TEXT NOT NULL,"expression" TEXT NOT NULL,"dateCreated" BIGINT NOT NULL,"deleted" BIT NOT NULL,"queryXml" TEXT NOT NULL,"changeDate" BIGINT NOT NULL);
+create table "queryFlags" ("networkId" BIGINT NOT NULL,"flagged" BIT NOT NULL,"flagMessage" TEXT NOT NULL,"changeDate" BIGINT NOT NULL);
+create table "queryResults" ("resultId" BIGINT NOT NULL,"networkQueryId" BIGINT NOT NULL,"instanceId" BIGINT NOT NULL,"adapterNode" TEXT NOT NULL,"resultType" TEXT NOT NULL,"size" BIGINT NOT NULL,"startDate" BIGINT,"endDate" BIGINT,"status" TEXT NOT NULL,"statusMessage" TEXT,"changeDate" BIGINT NOT NULL);
+create table "queryBreakdownResults" ("networkQueryId" BIGINT NOT NULL,"adapterNode" TEXT NOT NULL,"resultId" BIGINT NOT NULL,"resultType" TEXT NOT NULL,"dataKey" TEXT NOT NULL,"value" BIGINT NOT NULL,"changeDate" BIGINT NOT NULL);
+create table "queryResultProblemDigests" ("networkQueryId" BIGINT NOT NULL,"adapterNode" TEXT NOT NULL,"codec" TEXT NOT NULL,"stamp" TEXT NOT NULL,"summary" TEXT NOT NULL,"description" TEXT NOT NULL,"details" TEXT NOT NULL,"changeDate" BIGINT NOT NULL);
\ No newline at end of file
diff --git a/qep/service/src/main/sql/oracle.ddl b/qep/service/src/main/sql/oracle.ddl
index 40d20e3d8..8f056a327 100644
--- a/qep/service/src/main/sql/oracle.ddl
+++ b/qep/service/src/main/sql/oracle.ddl
@@ -1 +1,6 @@
-create table "queriesSent" ("shrineNodeId" VARCHAR2(256) NOT NULL,"userName" VARCHAR2(256) NOT NULL,"networkQueryId" NUMBER NOT NULL,"queryName" VARCHAR2(256) NOT NULL,"queryTopicId" VARCHAR2(256),"queryTopicName" VARCHAR2(256),"timeQuerySent" NUMBER NOT NULL);
\ No newline at end of file
+create table "queriesSent" ("shrineNodeId" VARCHAR2(256) NOT NULL,"userName" VARCHAR2(256) NOT NULL,"networkQueryId" NUMBER NOT NULL,"queryName" VARCHAR2(256) NOT NULL,"queryTopicId" VARCHAR2(256),"queryTopicName" VARCHAR2(256),"timeQuerySent" NUMBER NOT NULL);
+create table "previousQueries" ("networkId" NUMBER(19) NOT NULL,"userName" VARCHAR(256) NOT NULL,"domain" VARCHAR(256) NOT NULL,"queryName" VARCHAR(256) NOT NULL,"expression" CLOB NOT NULL,"dateCreated" NUMBER(19) NOT NULL,"deleted" CHAR NOT NULL check ("deleted" in ('1', '0')),"queryXml" VARCHAR(256) NOT NULL,"changeDate" NUMBER(19) NOT NULL);
+create table "queryFlags" ("networkId" NUMBER(19) NOT NULL,"flagged" CHAR NOT NULL check ("flagged" in ('1', '0')),"flagMessage" CLOB NOT NULL,"changeDate" NUMBER(19) NOT NULL);
+create table "queryResults" ("resultId" NUMBER(19) NOT NULL,"networkQueryId" NUMBER(19) NOT NULL,"instanceId" NUMBER(19) NOT NULL,"adapterNode" VARCHAR(256) NOT NULL,"resultType" VARCHAR(256) NOT NULL,"size" NUMBER(19) NOT NULL,"startDate" NUMBER(19),"endDate" NUMBER(19),"status" VARCHAR(256) NOT NULL,"statusMessage" VARCHAR(256),"changeDate" NUMBER(19) NOT NULL);
+create table "queryBreakdownResults" ("networkQueryId" NUMBER(19) NOT NULL,"adapterNode" VARCHAR(256) NOT NULL,"resultId" NUMBER(19) NOT NULL,"resultType" VARCHAR(256) NOT NULL,"dataKey" VARCHAR(256) NOT NULL,"value" NUMBER(19) NOT NULL,"changeDate" NUMBER(19) NOT NULL);
+create table "queryResultProblemDigests" ("networkQueryId" NUMBER(19) NOT NULL,"adapterNode" VARCHAR(256) NOT NULL,"codec" VARCHAR(256) NOT NULL,"stamp" VARCHAR(256) NOT NULL,"summary" CLOB NOT NULL,"description" CLOB NOT NULL,"details" CLOB NOT NULL,"changeDate" NUMBER(19) NOT NULL);
\ No newline at end of file