-
-
Module:
BenAdmin
- Import
-
-
Item State:
Production Complete
- Closed
-
Issue Importance:
Must Have
When we import election data if there is a bad file with spouse/children on bad (employee record is imported) and then we correct that bad file and re-import the data that time the original election record is getting overwritten and new record with only spouse or children (or both) come into effect. This is a big data discrepancy and it take lot of time for correction.
we have to provide workaround for this issue otherwise data load will because a time consuming job in case of large number of bad records.
I already discussed this Jaideep couple of times but as per him there is no resolution to this issue as of now.
CC - Samir, David Rhodes
{"report":{"apdex":0.5,"isInitial":true,"journeyId":"a3026e05-6286-4f71-ae96-e3916153854c","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":1049.1000000238419,"redirectCount":0,"resourceLoadedEnd":989.7000000178814,"resourceLoadedStart":418.7000000178814,"resourceTiming":[{"duration":145.5,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":418.7000000178814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":418.7000000178814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":564.2000000178814,"responseStart":0,"secureConnectionStart":0},{"duration":145.19999998807907,"initiatorType":"link","name":"https://jira.workterra.net/s/dd6a0911920485696ac20493290df627-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/3abe50d469404b639745df44b51476b6/_/download/contextbatch/css/jira.browse.project,jira.view.issue,project.issue.navigator,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&richediton=true","startTime":419.10000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":419.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":564.3000000119209,"responseStart":0,"secureConnectionStart":0},{"duration":146.69999998807907,"initiatorType":"link","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/8.5.0/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.css","startTime":419.2000000178814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":419.2000000178814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":565.9000000059605,"responseStart":0,"secureConnectionStart":0},{"duration":147.40000000596046,"initiatorType":"link","name":"https://jira.workterra.net/s/bd548f27bbf8f278bd83b60dd3284ed8-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:global-static-adgs/jira.webresources:global-static-adgs.css","startTime":419.40000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":419.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":566.8000000119209,"responseStart":0,"secureConnectionStart":0},{"duration":147.69999998807907,"initiatorType":"link","name":"https://jira.workterra.net/s/70725731a158a7140f19ddbd4201ba27-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:global-static/jira.webresources:global-static.css","startTime":419.60000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":419.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":567.3000000119209,"responseStart":0,"secureConnectionStart":0},{"duration":217.09999999403954,"initiatorType":"script","name":"https://jira.workterra.net/s/f2623af22c15df767ec6ff268ae0b8bd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":419.7000000178814,"connectEnd":419.7000000178814,"connectStart":419.7000000178814,"domainLookupEnd":419.7000000178814,"domainLookupStart":419.7000000178814,"fetchStart":419.7000000178814,"redirectEnd":0,"redirectStart":0,"requestStart":419.7000000178814,"responseEnd":636.8000000119209,"responseStart":636.8000000119209,"secureConnectionStart":419.7000000178814},{"duration":272.09999999403954,"initiatorType":"script","name":"https://jira.workterra.net/s/ecf7ec549751ae117b778f0525d6d371-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/4.1.5/_/download/resources/com.atlassian.plugins.atlassian-chaperone:hotspot-tour/hotspot-tour.js?batch=false&locale=en-US","startTime":419.90000000596046,"connectEnd":419.90000000596046,"connectStart":419.90000000596046,"domainLookupEnd":419.90000000596046,"domainLookupStart":419.90000000596046,"fetchStart":419.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":419.90000000596046,"responseEnd":692,"responseStart":692,"secureConnectionStart":419.90000000596046},{"duration":269.30000001192093,"initiatorType":"script","name":"https://jira.workterra.net/s/6ce676f2a5bcc9651cef6e7956f05def-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/3abe50d469404b639745df44b51476b6/_/download/contextbatch/js/jira.browse.project,jira.view.issue,project.issue.navigator,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en-US&richediton=true","startTime":419.90000000596046,"connectEnd":419.90000000596046,"connectStart":419.90000000596046,"domainLookupEnd":419.90000000596046,"domainLookupStart":419.90000000596046,"fetchStart":419.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":419.90000000596046,"responseEnd":689.2000000178814,"responseStart":689.2000000178814,"secureConnectionStart":419.90000000596046},{"duration":272.80000001192093,"initiatorType":"script","name":"https://jira.workterra.net/s/6aa3fcf1fac5fd551eee0b69077524e6-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/aae1242f5fc81cc6a5bb8bc963ccda29/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en-US","startTime":420,"connectEnd":420,"connectStart":420,"domainLookupEnd":420,"domainLookupStart":420,"fetchStart":420,"redirectEnd":0,"redirectStart":0,"requestStart":420,"responseEnd":692.8000000119209,"responseStart":692.8000000119209,"secureConnectionStart":420},{"duration":273.09999999403954,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":420.2000000178814,"connectEnd":420.2000000178814,"connectStart":420.2000000178814,"domainLookupEnd":420.2000000178814,"domainLookupStart":420.2000000178814,"fetchStart":420.2000000178814,"redirectEnd":0,"redirectStart":0,"requestStart":420.2000000178814,"responseEnd":693.3000000119209,"responseStart":693.3000000119209,"secureConnectionStart":420.2000000178814},{"duration":273.59999999403954,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":420.30000001192093,"connectEnd":420.30000001192093,"connectStart":420.30000001192093,"domainLookupEnd":420.30000001192093,"domainLookupStart":420.30000001192093,"fetchStart":420.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":420.30000001192093,"responseEnd":693.9000000059605,"responseStart":693.9000000059605,"secureConnectionStart":420.30000001192093},{"duration":273.80000001192093,"initiatorType":"script","name":"https://jira.workterra.net/s/ecf7ec549751ae117b778f0525d6d371-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/8.5.0/_/download/batch/com.atlassian.auiplugin:split_aui.pattern.label/com.atlassian.auiplugin:split_aui.pattern.label.js?locale=en-US","startTime":420.5,"connectEnd":420.5,"connectStart":420.5,"domainLookupEnd":420.5,"domainLookupStart":420.5,"fetchStart":420.5,"redirectEnd":0,"redirectStart":0,"requestStart":420.5,"responseEnd":694.3000000119209,"responseStart":694.3000000119209,"secureConnectionStart":420.5},{"duration":276.80000001192093,"initiatorType":"link","name":"https://jira.workterra.net/s/05c862146699bb029ceb0a489075e63b-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/bcd66e9a133a1b9f5fd14b56841e1c5b/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":420.90000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":420.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":697.7000000178814,"responseStart":0,"secureConnectionStart":0},{"duration":271.2999999821186,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/e80c7a6aee0fa86c2b1a716575a614aa/shortcuts.js?context=issuenavigation&context=issueaction","startTime":423.60000002384186,"connectEnd":423.60000002384186,"connectStart":423.60000002384186,"domainLookupEnd":423.60000002384186,"domainLookupStart":423.60000002384186,"fetchStart":423.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":423.60000002384186,"responseEnd":694.9000000059605,"responseStart":694.9000000059605,"secureConnectionStart":423.60000002384186},{"duration":273.90000000596046,"initiatorType":"link","name":"https://jira.workterra.net/s/9095228fa10daa2d3e3d7d5760c95e91-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/72477c22780abda5f51fe696920d843f/_/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":423.90000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":423.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":697.8000000119209,"responseStart":0,"secureConnectionStart":0},{"duration":271.69999998807907,"initiatorType":"script","name":"https://jira.workterra.net/s/c19a1b46e985d7fb85efaf27c8febfdd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/72477c22780abda5f51fe696920d843f/_/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":424.10000002384186,"connectEnd":424.10000002384186,"connectStart":424.10000002384186,"domainLookupEnd":424.10000002384186,"domainLookupStart":424.10000002384186,"fetchStart":424.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":424.10000002384186,"responseEnd":695.8000000119209,"responseStart":695.8000000119209,"secureConnectionStart":424.10000002384186},{"duration":564,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":425.10000002384186,"connectEnd":425.10000002384186,"connectStart":425.10000002384186,"domainLookupEnd":425.10000002384186,"domainLookupStart":425.10000002384186,"fetchStart":425.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":425.10000002384186,"responseEnd":989.1000000238419,"responseStart":989.1000000238419,"secureConnectionStart":425.10000002384186},{"duration":564.5,"initiatorType":"script","name":"https://jira.workterra.net/s/d41d8cd98f00b204e9800998ecf8427e-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":425.2000000178814,"connectEnd":425.2000000178814,"connectStart":425.2000000178814,"domainLookupEnd":425.2000000178814,"domainLookupStart":425.2000000178814,"fetchStart":425.2000000178814,"redirectEnd":0,"redirectStart":0,"requestStart":425.2000000178814,"responseEnd":989.7000000178814,"responseStart":989.7000000178814,"secureConnectionStart":425.2000000178814},{"duration":153.5,"initiatorType":"xmlhttprequest","name":"https://jira.workterra.net/rest/webResources/1.0/resources","startTime":834.8000000119209,"connectEnd":834.8000000119209,"connectStart":834.8000000119209,"domainLookupEnd":834.8000000119209,"domainLookupStart":834.8000000119209,"fetchStart":834.8000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":834.8000000119209,"responseEnd":988.3000000119209,"responseStart":988.3000000119209,"secureConnectionStart":834.8000000119209}],"threshold":1000,"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":324,"responseStart":412,"responseEnd":414,"domLoading":416,"domInteractive":1165,"domContentLoadedEventStart":1165,"domContentLoadedEventEnd":1212,"domComplete":1352,"loadEventStart":1352,"loadEventEnd":1354,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"cff477ee09d6a6","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":63,"dbReadsTimeInMs":13,"dbConnsTimeInMs":15,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}
Verified below Scenarios for other benefit types on LB:
1) Verified election for Employee life plan with retro date , Current Date and Future Date
2) Verified election for Spouse life plan with retro date , Current Date and Future Date directly through import and bad files.
3) Verified election for Child life plan with retro date , Current Date and Future Date directly through import and bad files.
4) Verified election for LTD Benefit Type
5) Verified election for HSA Plan dependent upon any other plan for retro date , Current Date and Future Date by changing tier
6) Verified election for HSA Plan
7) Verified election for service based plan
8) Verified multiple plan enrollment within same template
Working Fine.
CC - Sachin Hingole