-
Module:
BenAdmin
- Import
-
-
Item State:
Production Complete
- Closed
-
Sprint:
WT Sprint 37 - Enhancement
-
Following is the scenario as of now.
- New hire is added, say with new hire date as 3/14.
- An health enrollment is uploaded on 3/14.
- The new hire rule specifies that new hire becomes eligible on 1st of next month,
- System figures that based on the new hire rule, effective date for this benefit needs to be 4/1. But on file it is 3/14. System successfully imports the file and sets the effective date of the enrollment as 4/1.
The requirement is that the enrollment should be rejected and should show up in the bad file with the reason that the effective date doesn't follow the system rules.
Cindy Wibbing - please edit the description if necessary.
CC Samir Amit Thorve
- is blocked by
-
WT-11154
Import/Export template management -> Server Error on Stage
-
-
Production Complete
{"report":{"apdex":0.5,"isInitial":true,"journeyId":"dad189da-4e4f-40fd-ba92-7bfc5c390bf0","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":1330.8000000044703,"redirectCount":0,"resourceLoadedEnd":1202,"resourceLoadedStart":174.5,"resourceTiming":[{"duration":454,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":174.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":174.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":628.5,"responseStart":0,"secureConnectionStart":0},{"duration":458,"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":174.70000000298023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":174.70000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":632.7000000029802,"responseStart":0,"secureConnectionStart":0},{"duration":458.59999999403954,"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":174.90000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":174.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":633.5,"responseStart":0,"secureConnectionStart":0},{"duration":459.20000000298023,"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":175,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":175,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":634.2000000029802,"responseStart":0,"secureConnectionStart":0},{"duration":459.8999999985099,"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":175.10000000149012,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":175.10000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":635,"responseStart":0,"secureConnectionStart":0},{"duration":474.29999999701977,"initiatorType":"script","name":"https://jira.workterra.net/s/f2623af22c15df767ec6ff268ae0b8bd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":175.20000000298023,"connectEnd":175.20000000298023,"connectStart":175.20000000298023,"domainLookupEnd":175.20000000298023,"domainLookupStart":175.20000000298023,"fetchStart":175.20000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":175.20000000298023,"responseEnd":649.5,"responseStart":649.5,"secureConnectionStart":175.20000000298023},{"duration":583.0999999940395,"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":175.40000000596046,"connectEnd":175.40000000596046,"connectStart":175.40000000596046,"domainLookupEnd":175.40000000596046,"domainLookupStart":175.40000000596046,"fetchStart":175.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":175.40000000596046,"responseEnd":758.5,"responseStart":758.5,"secureConnectionStart":175.40000000596046},{"duration":610.6999999955297,"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":175.80000000447035,"connectEnd":175.80000000447035,"connectStart":175.80000000447035,"domainLookupEnd":175.80000000447035,"domainLookupStart":175.80000000447035,"fetchStart":175.80000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":175.80000000447035,"responseEnd":786.5,"responseStart":786.5,"secureConnectionStart":175.80000000447035},{"duration":613,"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":176,"connectEnd":176,"connectStart":176,"domainLookupEnd":176,"domainLookupStart":176,"fetchStart":176,"redirectEnd":0,"redirectStart":0,"requestStart":176,"responseEnd":789,"responseStart":789,"secureConnectionStart":176},{"duration":620.1000000014901,"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":176.20000000298023,"connectEnd":176.20000000298023,"connectStart":176.20000000298023,"domainLookupEnd":176.20000000298023,"domainLookupStart":176.20000000298023,"fetchStart":176.20000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":176.20000000298023,"responseEnd":796.3000000044703,"responseStart":796.3000000044703,"secureConnectionStart":176.20000000298023},{"duration":620.7000000029802,"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":176.5,"connectEnd":176.5,"connectStart":176.5,"domainLookupEnd":176.5,"domainLookupStart":176.5,"fetchStart":176.5,"redirectEnd":0,"redirectStart":0,"requestStart":176.5,"responseEnd":797.2000000029802,"responseStart":797.2000000029802,"secureConnectionStart":176.5},{"duration":621.1999999955297,"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":176.80000000447035,"connectEnd":176.80000000447035,"connectStart":176.80000000447035,"domainLookupEnd":176.80000000447035,"domainLookupStart":176.80000000447035,"fetchStart":176.80000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":176.80000000447035,"responseEnd":798,"responseStart":798,"secureConnectionStart":176.80000000447035},{"duration":636.8000000044703,"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":177.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":177.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":814.3000000044703,"responseStart":0,"secureConnectionStart":0},{"duration":636.8999999985099,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/ea6f30d2bfdc99578bb23f4a5bac3ecd/shortcuts.js?context=issuenavigation&context=issueaction","startTime":177.80000000447035,"connectEnd":177.80000000447035,"connectStart":177.80000000447035,"domainLookupEnd":177.80000000447035,"domainLookupStart":177.80000000447035,"fetchStart":177.80000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":177.80000000447035,"responseEnd":814.7000000029802,"responseStart":814.7000000029802,"secureConnectionStart":177.80000000447035},{"duration":644.0999999940395,"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":177.90000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":177.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":822,"responseStart":0,"secureConnectionStart":0},{"duration":644.2000000029802,"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":178.20000000298023,"connectEnd":178.20000000298023,"connectStart":178.20000000298023,"domainLookupEnd":178.20000000298023,"domainLookupStart":178.20000000298023,"fetchStart":178.20000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":178.20000000298023,"responseEnd":822.4000000059605,"responseStart":822.4000000059605,"secureConnectionStart":178.20000000298023},{"duration":1021.6999999955297,"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":179.40000000596046,"connectEnd":179.40000000596046,"connectStart":179.40000000596046,"domainLookupEnd":179.40000000596046,"domainLookupStart":179.40000000596046,"fetchStart":179.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":179.40000000596046,"responseEnd":1201.1000000014901,"responseStart":1201.1000000014901,"secureConnectionStart":179.40000000596046},{"duration":1022.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":179.5,"connectEnd":179.5,"connectStart":179.5,"domainLookupEnd":179.5,"domainLookupStart":179.5,"fetchStart":179.5,"redirectEnd":0,"redirectStart":0,"requestStart":179.5,"responseEnd":1202,"responseStart":1202,"secureConnectionStart":179.5},{"duration":296.3999999985099,"initiatorType":"xmlhttprequest","name":"https://jira.workterra.net/rest/webResources/1.0/resources","startTime":903.1000000014901,"connectEnd":903.1000000014901,"connectStart":903.1000000014901,"domainLookupEnd":903.1000000014901,"domainLookupStart":903.1000000014901,"fetchStart":903.1000000014901,"redirectEnd":0,"redirectStart":0,"requestStart":903.1000000014901,"responseEnd":1199.5,"responseStart":1199.4000000059605,"secureConnectionStart":903.1000000014901}],"threshold":1000,"fetchStart":2,"domainLookupStart":2,"domainLookupEnd":2,"connectStart":2,"connectEnd":2,"requestStart":72,"responseStart":166,"responseEnd":167,"domLoading":172,"domInteractive":1535,"domContentLoadedEventStart":1535,"domContentLoadedEventEnd":1657,"domComplete":2302,"loadEventStart":2302,"loadEventEnd":2305,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"87637f1404404e","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":62,"dbReadsTimeInMs":16,"dbConnsTimeInMs":18,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}
Change Request
High
Snehal Katkar (Inactive)
added a comment - Concern: Import is successful even if enrollment effective date do not follow new hire rules.
Cause: There are two dates, enrollment effective date(given in file) and new hire effective date. System was considering greater date amongst these two dates. So, if date given in file is less than new hire effective date, system was considering new hire effective date as enrollment effective date and hence import was getting successful. Records were getting added into Enrollment_Intermidiate table.
Correction: Added a check for date given in file. If it doesn't follow new hire rules then that record will get showed up in bad file. There won't be any changes in database for such enrollments. 
Jayshree Nagpure (Inactive)
added a comment - - edited Hi Snehal Katkar ,
Verified on LB
Company - Qa City of durham for hspl.
Verified scenario's are below :
1) Consider any date as Enrollment effective date, less than new hire effective date for election import- File kicked out to bad with message "Enrollment effective date cannot set prior to new hire effective date"
2) Enter enrollment effective date as per the new hire effective rule- Import done successfully
Other additional scenario's with all New hire rule's are attached in checklist : UpdatedTestcases.xls
Working fine
Marking item state as Ready for Stage
Thanks,
Jayshree
cc : Rakesh Roy Prasad Pise 
Good to LB Checkin