-
Type:
Support Activity
-
Status:
Closed
-
Priority:
Critical
-
Resolution:
Done
-
Affects Version/s:
None
-
Fix Version/s:
None
-
-
-
Support Task Type:
ACA Historical Data Load
-
-
-
Hello,
Please load the attached records per the provided spreadsheet for Cobra enrollments. We do not administer Cobra nor do we have Cobra plans in Wt. I believe last year the records were loaded from the backend by creating general plans for 2016. can you do the same process as last year to get the records loaded into WT.
Thanks
{"report":{"apdex":1,"isInitial":true,"journeyId":"7b9f4f3f-155a-4227-a89c-4de00efde508","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":765.9000000059605,"redirectCount":0,"resourceLoadedEnd":1001.9000000059605,"resourceLoadedStart":156.29999999701977,"resourceTiming":[{"duration":215.6000000089407,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":156.29999999701977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":156.29999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":371.90000000596046,"responseStart":0,"secureConnectionStart":0},{"duration":215.6000000089407,"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":156.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":156.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":372.1000000089407,"responseStart":0,"secureConnectionStart":0},{"duration":215.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":156.70000000298023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":156.70000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":372.29999999701977,"responseStart":0,"secureConnectionStart":0},{"duration":215.5,"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":156.90000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":156.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":372.40000000596046,"responseStart":0,"secureConnectionStart":0},{"duration":215.3999999910593,"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":157.1000000089407,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":157.1000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":372.5,"responseStart":0,"secureConnectionStart":0},{"duration":224.5,"initiatorType":"script","name":"https://jira.workterra.net/s/f2623af22c15df767ec6ff268ae0b8bd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":157.20000000298023,"connectEnd":157.20000000298023,"connectStart":157.20000000298023,"domainLookupEnd":157.20000000298023,"domainLookupStart":157.20000000298023,"fetchStart":157.20000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":157.20000000298023,"responseEnd":381.70000000298023,"responseStart":381.70000000298023,"secureConnectionStart":157.20000000298023},{"duration":274.5,"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":157.40000000596046,"connectEnd":157.40000000596046,"connectStart":157.40000000596046,"domainLookupEnd":157.40000000596046,"domainLookupStart":157.40000000596046,"fetchStart":157.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":157.40000000596046,"responseEnd":431.90000000596046,"responseStart":431.90000000596046,"secureConnectionStart":157.40000000596046},{"duration":277.19999998807907,"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":157.6000000089407,"connectEnd":157.6000000089407,"connectStart":157.6000000089407,"domainLookupEnd":157.6000000089407,"domainLookupStart":157.6000000089407,"fetchStart":157.6000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":157.6000000089407,"responseEnd":434.79999999701977,"responseStart":434.79999999701977,"secureConnectionStart":157.6000000089407},{"duration":277.5,"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":157.79999999701977,"connectEnd":157.79999999701977,"connectStart":157.79999999701977,"domainLookupEnd":157.79999999701977,"domainLookupStart":157.79999999701977,"fetchStart":157.79999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":157.79999999701977,"responseEnd":435.29999999701977,"responseStart":435.29999999701977,"secureConnectionStart":157.79999999701977},{"duration":277.70000000298023,"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":157.90000000596046,"connectEnd":157.90000000596046,"connectStart":157.90000000596046,"domainLookupEnd":157.90000000596046,"domainLookupStart":157.90000000596046,"fetchStart":157.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":157.90000000596046,"responseEnd":435.6000000089407,"responseStart":435.6000000089407,"secureConnectionStart":157.90000000596046},{"duration":277.90000000596046,"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":158,"connectEnd":158,"connectStart":158,"domainLookupEnd":158,"domainLookupStart":158,"fetchStart":158,"redirectEnd":0,"redirectStart":0,"requestStart":158,"responseEnd":435.90000000596046,"responseStart":435.90000000596046,"secureConnectionStart":158},{"duration":278.09999999403954,"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":158.20000000298023,"connectEnd":158.20000000298023,"connectStart":158.20000000298023,"domainLookupEnd":158.20000000298023,"domainLookupStart":158.20000000298023,"fetchStart":158.20000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":158.20000000298023,"responseEnd":436.29999999701977,"responseStart":436.29999999701977,"secureConnectionStart":158.20000000298023},{"duration":361.29999999701977,"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":158.40000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":158.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":519.7000000029802,"responseStart":0,"secureConnectionStart":0},{"duration":278.1000000089407,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/a664c2c06e52d83566c477b9899c262e/shortcuts.js?context=issuenavigation&context=issueaction","startTime":158.5,"connectEnd":158.5,"connectStart":158.5,"domainLookupEnd":158.5,"domainLookupStart":158.5,"fetchStart":158.5,"redirectEnd":0,"redirectStart":0,"requestStart":158.5,"responseEnd":436.6000000089407,"responseStart":436.6000000089407,"secureConnectionStart":158.5},{"duration":361.29999999701977,"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":158.6000000089407,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":158.6000000089407,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":519.9000000059605,"responseStart":0,"secureConnectionStart":0},{"duration":278.40000000596046,"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":158.79999999701977,"connectEnd":158.79999999701977,"connectStart":158.79999999701977,"domainLookupEnd":158.79999999701977,"domainLookupStart":158.79999999701977,"fetchStart":158.79999999701977,"redirectEnd":0,"redirectStart":0,"requestStart":158.79999999701977,"responseEnd":437.20000000298023,"responseStart":437.20000000298023,"secureConnectionStart":158.79999999701977},{"duration":62.900000005960464,"initiatorType":"xmlhttprequest","name":"https://jira.workterra.net/rest/webResources/1.0/resources","startTime":546.2000000029802,"connectEnd":546.2000000029802,"connectStart":546.2000000029802,"domainLookupEnd":546.2000000029802,"domainLookupStart":546.2000000029802,"fetchStart":546.2000000029802,"redirectEnd":0,"redirectStart":0,"requestStart":546.2000000029802,"responseEnd":609.1000000089407,"responseStart":609.1000000089407,"secureConnectionStart":546.2000000029802}],"threshold":1000,"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":3,"responseStart":150,"responseEnd":152,"domLoading":154,"domInteractive":1019,"domContentLoadedEventStart":1019,"domContentLoadedEventEnd":1071,"domComplete":1316,"loadEventStart":1316,"loadEventEnd":1320,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"68eeb1d5d14115","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":118,"dbReadsTimeInMs":18,"dbConnsTimeInMs":20,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}
Yogesh Chaudhari (Inactive)
added a comment - Hi lisa davison
We are not able to see Line14, Line15 and Line16 codes in the above attached file for all the employees. Also in the above file, *Month Index * column should be the month value not the range of months. If you wants to import code for Jan to March months then there should be 3 rows with month Index as 01,02, and 03 respectively.
Please provide the file again with expected codes and reformat file with month index column.
IE: Darbisi – Employee is not employed from March, System has provided 1H and 2A code for Line14 and Line16 respectively.
Nandkumar Prabhakar Karlekar Sachin Hingole 
Hello Yogesh,
I have completed and attached the spreadsheet for the Cobra Participants. Keep in mind this sheet only represents when they were in COBRA. If they had coverage through ASML prior in the year it does not account for that. Please refer to WT for prior coverage.
IE: Darbisi – Employed at ASML Jan- Feb. Cobra March – June. Sheet only shows March through June since that is when he was on COBRA.
Password: asml2016 Copy of 1095c Code Specifications 2016.xls
Please give me an ETA on when we can have another file pulled for the Cobra population.
Thanks