-
Type:
Story
-
-
Priority:
Normal
-
Resolution:
Done
-
-
Further to INSTRM-843, this ticket captures additional changes to the schema suggested by Princeton University workers. These changes include new tables for the SPS; updates to mcs_data and other minor changes.
There are no comments yet on this issue.
{"report":{"apdex":0.5,"isInitial":true,"journeyId":"19c005cf-cef4-461d-ae39-edf5154869e9","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":3250.5999999046326,"redirectCount":0,"resourceLoadedEnd":3271.8999996185303,"resourceLoadedStart":822.6999998092651,"resourceTiming":[{"duration":6.5,"initiatorType":"link","name":"https://pfspipe.ipmu.jp/jira/s/6857d0cccf13aeaceb2c3277c6bf3892-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/css/_super/batch.css","startTime":822.6999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":822.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":829.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":6.599999904632568,"initiatorType":"link","name":"https://pfspipe.ipmu.jp/jira/s/4ca5cf1725eaa25a0e132608060337f8-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/53bc49863274d15a772d711431705c0c/_/download/contextbatch/css/project.issue.navigator,jira.view.issue,jira.global,jira.general,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&richediton=true","startTime":823,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":823,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":829.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":6.800000190734863,"initiatorType":"link","name":"https://pfspipe.ipmu.jp/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/8.0.5/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.css","startTime":823.1999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":823.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":830,"responseStart":0,"secureConnectionStart":0},{"duration":7.200000286102295,"initiatorType":"link","name":"https://pfspipe.ipmu.jp/jira/s/6f741955bf751f5684bb05515ecce171-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/1.0/_/download/batch/jira.webresources:global-static-adgs/jira.webresources:global-static-adgs.css","startTime":823.3999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":823.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":830.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":7.899999618530273,"initiatorType":"link","name":"https://pfspipe.ipmu.jp/jira/s/9b2891edfaa54fe476fe450e110e4428-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/1.0/_/download/batch/jira.webresources:global-static/jira.webresources:global-static.css","startTime":823.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":823.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":831.3999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":2043.4000000953674,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/s/71200f8ce5613e097dcbc84ab48f0df3-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/0a4716d29b2d5b1bdcdb168b4efc119e/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":823.6999998092651,"connectEnd":823.6999998092651,"connectStart":823.6999998092651,"domainLookupEnd":823.6999998092651,"domainLookupStart":823.6999998092651,"fetchStart":823.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1364.2999997138977,"responseEnd":2867.0999999046326,"responseStart":1732.6999998092651,"secureConnectionStart":823.6999998092651},{"duration":2245.2000002861023,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/s/47d93b27a0f146b1bd3f1d197220131e-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/53bc49863274d15a772d711431705c0c/_/download/contextbatch/js/project.issue.navigator,jira.view.issue,jira.global,jira.general,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":823.7999997138977,"connectEnd":823.7999997138977,"connectStart":823.7999997138977,"domainLookupEnd":823.7999997138977,"domainLookupStart":823.7999997138977,"fetchStart":823.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":1376.7999997138977,"responseEnd":3069,"responseStart":1757.5,"secureConnectionStart":823.7999997138977},{"duration":973.3999996185303,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/s/70bb2263e59e7e1f04fbd137c80b895b-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":824,"connectEnd":824,"connectStart":824,"domainLookupEnd":824,"domainLookupStart":824,"fetchStart":824,"redirectEnd":0,"redirectStart":0,"requestStart":1514.3999996185303,"responseEnd":1797.3999996185303,"responseStart":1796.5999999046326,"secureConnectionStart":824},{"duration":958.1999998092651,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":824.1999998092651,"connectEnd":824.1999998092651,"connectStart":824.1999998092651,"domainLookupEnd":824.1999998092651,"domainLookupStart":824.1999998092651,"fetchStart":824.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1549.0999999046326,"responseEnd":1782.3999996185303,"responseStart":1781.3999996185303,"secureConnectionStart":824.1999998092651},{"duration":1141.8000001907349,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":824.2999997138977,"connectEnd":824.2999997138977,"connectStart":824.2999997138977,"domainLookupEnd":824.2999997138977,"domainLookupStart":824.2999997138977,"fetchStart":824.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":1782.8999996185303,"responseEnd":1966.0999999046326,"responseStart":1965,"secureConnectionStart":824.2999997138977},{"duration":1155.3999996185303,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/s/69508eac48a2781e76116ef9aaf97558-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/8.0.5/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.js?locale=en-US","startTime":824.5,"connectEnd":824.5,"connectStart":824.5,"domainLookupEnd":824.5,"domainLookupStart":824.5,"fetchStart":824.5,"redirectEnd":0,"redirectStart":0,"requestStart":1798,"responseEnd":1979.8999996185303,"responseStart":1978.8999996185303,"secureConnectionStart":824.5},{"duration":13,"initiatorType":"link","name":"https://pfspipe.ipmu.jp/jira/s/cddefc452def736b814cb1124eb8715f-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/6d15dbc1919cf2c5ddb9c9153d7f06f9/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":824.6999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":824.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":837.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":1326.3000001907349,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/rest/api/1.0/shortcuts/803005/36457a83252da76e0efa441a4fb3275c/shortcuts.js?context=issuenavigation&context=issueaction","startTime":824.8999996185303,"connectEnd":824.8999996185303,"connectStart":824.8999996185303,"domainLookupEnd":824.8999996185303,"domainLookupStart":824.8999996185303,"fetchStart":824.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":1966.7999997138977,"responseEnd":2151.199999809265,"responseStart":2150.0999999046326,"secureConnectionStart":824.8999996185303},{"duration":3.700000286102295,"initiatorType":"link","name":"https://pfspipe.ipmu.jp/jira/s/1e83d960b274809d77d87cc5d08ac9f0-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/4a9288299d147101bf66484f4be48925/_/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":1004.8999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1004.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1008.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":1169.5999999046326,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/s/d40a034b2ad49fe248d3d34e35e494ff-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/4a9288299d147101bf66484f4be48925/_/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":1005.1999998092651,"connectEnd":1005.1999998092651,"connectStart":1005.1999998092651,"domainLookupEnd":1005.1999998092651,"domainLookupStart":1005.1999998092651,"fetchStart":1005.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1980.5,"responseEnd":2174.7999997138977,"responseStart":2173.5,"secureConnectionStart":1005.1999998092651},{"duration":1533,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":1006.7999997138977,"connectEnd":1006.7999997138977,"connectStart":1006.7999997138977,"domainLookupEnd":1006.7999997138977,"domainLookupStart":1006.7999997138977,"fetchStart":1006.7999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":2358.2999997138977,"responseEnd":2539.7999997138977,"responseStart":2538.3999996185303,"secureConnectionStart":1006.7999997138977},{"duration":1702.6000003814697,"initiatorType":"script","name":"https://pfspipe.ipmu.jp/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/s4249o/803005/d03c5b13c84abbbcc687d02f1534e41c/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":1006.8999996185303,"connectEnd":1006.8999996185303,"connectStart":1006.8999996185303,"domainLookupEnd":1006.8999996185303,"domainLookupStart":1006.8999996185303,"fetchStart":1006.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":2526.0999999046326,"responseEnd":2709.5,"responseStart":2708.3999996185303,"secureConnectionStart":1006.8999996185303},{"duration":18.299999713897705,"initiatorType":"xmlhttprequest","name":"https://pfspipe.ipmu.jp/jira/rest/webResources/1.0/resources","startTime":3008.0999999046326,"connectEnd":3008.0999999046326,"connectStart":3008.0999999046326,"domainLookupEnd":3008.0999999046326,"domainLookupStart":3008.0999999046326,"fetchStart":3008.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":3008.0999999046326,"responseEnd":3026.3999996185303,"responseStart":3026.3999996185303,"secureConnectionStart":3008.0999999046326}],"threshold":1000,"fetchStart":0,"domainLookupStart":8,"domainLookupEnd":230,"connectStart":230,"connectEnd":608,"secureConnectionStart":417,"requestStart":608,"responseStart":818,"responseEnd":1006,"domLoading":821,"domInteractive":3310,"domContentLoadedEventStart":3310,"domContentLoadedEventEnd":3364,"domComplete":3364,"loadEventStart":3364,"loadEventEnd":3366,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"de1c03d0fcfb00","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":82,"dbReadsTimeInMs":21,"dbConnsTimeInMs":25,"applicationHash":"1f96e09b3c60279a408a2ae47be3c745f571388b","experiments":[]}}
INSTRM-732 Normalize PFI configuration opdb tables ?