-
Type:
Bug
-
Status:
Closed
-
Priority:
Medium
-
Resolution:
Done
-
Affects Version/s:
None
-
Fix Version/s:
None
-
-
-
-
-
-
Item State:
Production Complete
- Closed
1.Login to LB with Partner.
2.Edit company say 'ACA Automation'.
3.Add new employee.
4.Make sure employee is eligible to ACA plan.
5.Upload the time sheet of the employee [As for first 3 months as Full time and from April as Part time]
6.Add Measurement & stability, New Hire rules.
7.From UI change employee type to Part-time from 04/01/2016.
8.Verify 1095-C report.
Actual: 1J and 2B code reflected for entire year
Expected:1J and 2F code should reflect for Jan, Feb and Mar and 1J and 2B code should reflect for rest of months.
{"report":{"apdex":0.5,"isInitial":true,"journeyId":"4624f1ba-c044-4470-bec4-88cd54909243","key":"jira.project.issue.view-issue","navigationType":0,"readyForUser":1610.1999999284744,"redirectCount":0,"resourceLoadedEnd":1808.5,"resourceLoadedStart":803.6999999284744,"resourceTiming":[{"duration":357.60000002384186,"initiatorType":"link","name":"https://jira.workterra.net/s/3003653444a1e1a85555cab7dcfb3a21-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/css/_super/batch.css","startTime":803.6999999284744,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":803.6999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1161.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":357.60000002384186,"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":804.0999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":804.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1161.6999999284744,"responseStart":0,"secureConnectionStart":0},{"duration":358.2000000476837,"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":804.1999999284744,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":804.1999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1162.3999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":358.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":804.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":804.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1162.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":359,"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":804.3999999761581,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":804.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1163.3999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":413.39999997615814,"initiatorType":"script","name":"https://jira.workterra.net/s/f2623af22c15df767ec6ff268ae0b8bd-CDN/-w431t5/805012/9a9e1fae3639050b38ac467c3aa37e79/2e46d90b5cae895c9c38649c9d510130/_/download/contextbatch/js/_super/batch.js?locale=en-US","startTime":804.5,"connectEnd":804.5,"connectStart":804.5,"domainLookupEnd":804.5,"domainLookupStart":804.5,"fetchStart":804.5,"redirectEnd":0,"redirectStart":0,"requestStart":804.5,"responseEnd":1217.8999999761581,"responseStart":1217.8999999761581,"secureConnectionStart":804.5},{"duration":451.7000000476837,"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":804.5999999046326,"connectEnd":804.5999999046326,"connectStart":804.5999999046326,"domainLookupEnd":804.5999999046326,"domainLookupStart":804.5999999046326,"fetchStart":804.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":804.5999999046326,"responseEnd":1256.2999999523163,"responseStart":1256.2999999523163,"secureConnectionStart":804.5999999046326},{"duration":454.7000000476837,"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":804.6999999284744,"connectEnd":804.6999999284744,"connectStart":804.6999999284744,"domainLookupEnd":804.6999999284744,"domainLookupStart":804.6999999284744,"fetchStart":804.6999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":804.6999999284744,"responseEnd":1259.3999999761581,"responseStart":1259.3999999761581,"secureConnectionStart":804.6999999284744},{"duration":455.6999999284744,"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":804.8999999761581,"connectEnd":804.8999999761581,"connectStart":804.8999999761581,"domainLookupEnd":804.8999999761581,"domainLookupStart":804.8999999761581,"fetchStart":804.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":804.8999999761581,"responseEnd":1260.5999999046326,"responseStart":1260.5999999046326,"secureConnectionStart":804.8999999761581},{"duration":456.6999999284744,"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":805,"connectEnd":805,"connectStart":805,"domainLookupEnd":805,"domainLookupStart":805,"fetchStart":805,"redirectEnd":0,"redirectStart":0,"requestStart":805,"responseEnd":1261.6999999284744,"responseStart":1261.6999999284744,"secureConnectionStart":805},{"duration":457.7000000476837,"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":805.1999999284744,"connectEnd":805.1999999284744,"connectStart":805.1999999284744,"domainLookupEnd":805.1999999284744,"domainLookupStart":805.1999999284744,"fetchStart":805.1999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":805.1999999284744,"responseEnd":1262.8999999761581,"responseStart":1262.8999999761581,"secureConnectionStart":805.1999999284744},{"duration":459.7999999523163,"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":805.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":805.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1265.0999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":458.7999999523163,"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":805.2999999523163,"connectEnd":805.2999999523163,"connectStart":805.2999999523163,"domainLookupEnd":805.2999999523163,"domainLookupStart":805.2999999523163,"fetchStart":805.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":805.2999999523163,"responseEnd":1264.0999999046326,"responseStart":1264.0999999046326,"secureConnectionStart":805.2999999523163},{"duration":459.6999999284744,"initiatorType":"script","name":"https://jira.workterra.net/rest/api/1.0/shortcuts/805012/344f6dde0e779bc821c159302c8a4389/shortcuts.js?context=issuenavigation&context=issueaction","startTime":805.3999999761581,"connectEnd":805.3999999761581,"connectStart":805.3999999761581,"domainLookupEnd":805.3999999761581,"domainLookupStart":805.3999999761581,"fetchStart":805.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":805.3999999761581,"responseEnd":1265.0999999046326,"responseStart":1265.0999999046326,"secureConnectionStart":805.3999999761581},{"duration":460.60000002384186,"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":805.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":805.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1266.1999999284744,"responseStart":0,"secureConnectionStart":0},{"duration":460.7000000476837,"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":805.6999999284744,"connectEnd":805.6999999284744,"connectStart":805.6999999284744,"domainLookupEnd":805.6999999284744,"domainLookupStart":805.6999999284744,"fetchStart":805.6999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":805.6999999284744,"responseEnd":1266.3999999761581,"responseStart":1266.3999999761581,"secureConnectionStart":805.6999999284744}],"threshold":1000,"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":704,"responseStart":797,"responseEnd":799,"domLoading":801,"domInteractive":1839,"domContentLoadedEventStart":1839,"domContentLoadedEventEnd":1884,"domComplete":2187,"loadEventStart":2187,"loadEventEnd":2190,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[],"measures":[],"correlationId":"dcf26473a540ce","effectiveType":"4g","downlink":9.4,"rtt":0,"serverDuration":62,"dbReadsTimeInMs":12,"dbConnsTimeInMs":13,"applicationHash":"156decd7d2b4272533aa6cefc8294af635e1da97","experiments":[]}}
Ramya Tantry (Inactive)
added a comment - Concern : 2B code is not reflecting correctly on 1095-C report.
Cause : When Measurement and stability rules are set and time sheet is also loaded,employee data is dumped in ACAEmployeeData Table.OES_UDF_ACAEmployeeData UDF gives data from ACAEmployeeData table if that employee is present or else it gives data from Employee table.Due to missing brackets between AND and OR, one condtion was getting overwritten. So the UDF was giving combined data of that employee from timesheet and demographics.
Correction : Added brackets in the condition. 
Smita Pawar (Inactive)
added a comment - We have verified above mentioned issue on LB company [ACA Automation] .
Its working fine.
Scenarios verified are as follows.
1.Checked whether 2B code is reflecting on the 1095-C form when kept Measurement & Stability period with Interval of 3 Months
2.Checked whether 2B code is reflecting on the 1095-C form when kept Measurement & Stability period with Interval of 12 Months.
3.Checked Time sheet functionality is working correctly or not
Files Affected:
Database Objects/MasterCompanyDB/02_UDFs/dbo.OES_UDF_ACAEmployeeData.sql