Developer Notes:
Hide
script to create provider_dimension added.
Show
script to create provider_dimension added.
Modifier_dim also added for possible future use.
Testing Notes:
provider_dimension table has been added to the scripts and everything appears to be working correctly.
Currently, the timeline is generating an error and this is because it is looking for the provider_dimension table. This table is part of the standard i2b2, the OMOP CDM has its own provider table. For i2b2 on OMOP a provider view needs to be created so any plugins like the timeline will not generate errors looking for the i2b2 provider_dimension table.
{"report":{"fcp":1027.9000000953674,"ttfb":415.40000009536743,"pageVisibility":"visible","entityId":11186,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"b8ab573e-5a18-4e25-96ac-f6e5b69e3ab9","navigationType":0,"readyForUser":1076.2000000476837,"redirectCount":0,"resourceLoadedEnd":1141.8000001907349,"resourceLoadedStart":424.7000000476837,"resourceTiming":[{"duration":178,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/7fd763ecdf5ed1f47fc4d22fa8382e97-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":424.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":424.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":602.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":178.40000009536743,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/898b8076c5e82f53cd816ca393e45a56-CDN/4x9nqn/820011/16zrvj4/41b71ca9fb0eed92dc73e9510f2744ee/_/download/contextbatch/css/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.css?jira.create.linked.issue=true&richediton=true&whisper-enabled=true","startTime":425,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":425,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":603.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":353.60000014305115,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/4c9c503fe98f210445831b0d7b0cdc33-CDN/4x9nqn/820011/16zrvj4/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":425.2000000476837,"connectEnd":629.6000001430511,"connectStart":606.6000001430511,"domainLookupEnd":606.6000001430511,"domainLookupStart":606.6000001430511,"fetchStart":425.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":629.7000000476837,"responseEnd":778.8000001907349,"responseStart":648.9000000953674,"secureConnectionStart":617.9000000953674},{"duration":333.5,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/694e598c1ae48b0f96655173631cd247-CDN/4x9nqn/820011/16zrvj4/41b71ca9fb0eed92dc73e9510f2744ee/_/download/contextbatch/js/project.issue.navigator,jira.view.issue,jira.global,atl.general,-_super/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true&whisper-enabled=true","startTime":425.60000014305115,"connectEnd":629.9000000953674,"connectStart":606.9000000953674,"domainLookupEnd":606.9000000953674,"domainLookupStart":606.9000000953674,"fetchStart":425.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":630,"responseEnd":759.1000001430511,"responseStart":649.9000000953674,"secureConnectionStart":618.2000000476837},{"duration":224.79999995231628,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/53f54e0ac3f00bb56b136b4d2fff2853-CDN/4x9nqn/820011/16zrvj4/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":425.90000009536743,"connectEnd":632.6000001430511,"connectStart":607.2000000476837,"domainLookupEnd":607.2000000476837,"domainLookupStart":607.2000000476837,"fetchStart":425.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":632.6000001430511,"responseEnd":650.7000000476837,"responseStart":647.7000000476837,"secureConnectionStart":619.6000001430511},{"duration":228,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":426,"connectEnd":638.8000001907349,"connectStart":615.4000000953674,"domainLookupEnd":615.4000000953674,"domainLookupStart":615.4000000953674,"fetchStart":426,"redirectEnd":0,"redirectStart":0,"requestStart":638.8000001907349,"responseEnd":654,"responseStart":652,"secureConnectionStart":626.8000001907349},{"duration":228.39999985694885,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":426.30000019073486,"connectEnd":639.9000000953674,"connectStart":616.7000000476837,"domainLookupEnd":616.7000000476837,"domainLookupStart":616.7000000476837,"fetchStart":426.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":640,"responseEnd":654.7000000476837,"responseStart":653.2000000476837,"secureConnectionStart":628.1000001430511},{"duration":189.40000009536743,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/30748292e4ca68be6947d7969829384b-CDN/4x9nqn/820011/16zrvj4/4f66da484ef7d95a2a604d3ab014374c/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":426.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":426.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":615.8000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":229.89999985694885,"initiatorType":"script","name":"https://community.i2b2.org/jira/rest/api/1.0/shortcuts/820011/a9e270f026ecabffc9a59343e5439391/shortcuts.js?context=issuenavigation&context=issueaction","startTime":426.60000014305115,"connectEnd":641.8000001907349,"connectStart":618.8000001907349,"domainLookupEnd":618.8000001907349,"domainLookupStart":618.8000001907349,"fetchStart":426.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":641.9000000953674,"responseEnd":656.5,"responseStart":655.3000001907349,"secureConnectionStart":630.1000001430511},{"duration":358.39999985694885,"initiatorType":"link","name":"https://community.i2b2.org/jira/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/4x9nqn/820011/16zrvj4/efa42a25652b26dfd802540c024826b3/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":540.3000001907349,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":540.3000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":898.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":428.10000014305115,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/8087506fefd02b4096991c90836b49f6-CDN/4x9nqn/820011/16zrvj4/efa42a25652b26dfd802540c024826b3/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":540.5,"connectEnd":948,"connectStart":921.3000001907349,"domainLookupEnd":921.3000001907349,"domainLookupStart":921.3000001907349,"fetchStart":540.5,"redirectEnd":0,"redirectStart":0,"requestStart":949.9000000953674,"responseEnd":968.6000001430511,"responseStart":966.2000000476837,"secureConnectionStart":934},{"duration":562.2999999523163,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":549.2000000476837,"connectEnd":1096.5,"connectStart":1070.1000001430511,"domainLookupEnd":1070.1000001430511,"domainLookupStart":1070.1000001430511,"fetchStart":549.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":1096.6000001430511,"responseEnd":1111.5,"responseStart":1110.8000001907349,"secureConnectionStart":1083.3000001907349},{"duration":565.6000001430511,"initiatorType":"script","name":"https://community.i2b2.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/4x9nqn/820011/16zrvj4/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":576.2000000476837,"connectEnd":1126.5,"connectStart":1100.7000000476837,"domainLookupEnd":1100.7000000476837,"domainLookupStart":1100.7000000476837,"fetchStart":576.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":1126.6000001430511,"responseEnd":1141.8000001907349,"responseStart":1140.5,"secureConnectionStart":1113.4000000953674},{"duration":160.10000014305115,"initiatorType":"xmlhttprequest","name":"https://community.i2b2.org/jira/rest/webResources/1.0/resources","startTime":948.5,"connectEnd":1091.9000000953674,"connectStart":1075.5,"domainLookupEnd":1075.5,"domainLookupStart":1075.5,"fetchStart":948.5,"redirectEnd":0,"redirectStart":0,"requestStart":1092,"responseEnd":1108.6000001430511,"responseStart":1107.6000001430511,"secureConnectionStart":1080.1000001430511}],"fetchStart":0,"domainLookupStart":267,"domainLookupEnd":340,"connectStart":341,"connectEnd":374,"secureConnectionStart":351,"requestStart":374,"responseStart":416,"responseEnd":576,"domLoading":420,"domInteractive":1169,"domContentLoadedEventStart":1169,"domContentLoadedEventEnd":1202,"domComplete":1390,"loadEventStart":1390,"loadEventEnd":1390,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1154},{"name":"bigPipe.sidebar-id.end","time":1154.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.start","time":1154.9000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":1155.9000000953674},{"name":"activityTabFullyLoaded","time":1213.9000000953674}],"measures":[],"correlationId":"3bde69395e0983","effectiveType":"4g","downlink":9.8,"rtt":0,"serverDuration":191,"dbReadsTimeInMs":69,"dbConnsTimeInMs":77,"applicationHash":"0629dd8d260e3954ece49053e565d01dabe11609","experiments":[]}}
Major