Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-8255

Prime - Full file for Jan 17 and change file Feb 17 onwards

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Cancelled
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Environment:
      Others
    • Module:
      ACA - 2017
    • Reported by:
      Support
    • Company:
      Prime Healthcare

      Description

      We need one change to happen on the January 2017 file that is due on February 10th,2017 for both the Employee and the Dependent file.

      On the Employee file Column I “ Benefits Effective date” should be all employees for the month of January 2017. On all other months we should see only the changes made with that month

      So on March 10th, 2017 when you send us the February 2017 file the only thing that should be on that file are any changes that happened between the January file and the February file. As of

      today the file you are sending has all data for all months every month and when it is sent to the IRS it creates duplicate which in turn create a problem with our ACA reporting.

      We have the same issue for the employee dependent file on Column F with the exact same scenario.

      Please advise on what it will take to get the programmer to correct this,

        Attachments

          Issue Links

            Activity

            mahendra.mungase Mahendra Mungase (Inactive) created issue -
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-8253 [ WT-8253 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Link This issue relates to WT-8076 [ WT-8076 ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Mahendra Mungase

            Please refer to WT-8076 for comments added today. Is WT-8255 going to be the new JIRA ticket number?

            Thank you.

            Show
            alov Amber Love-Jones (Inactive) added a comment - Mahendra Mungase Please refer to WT-8076 for comments added today. Is WT-8255 going to be the new JIRA ticket number? Thank you.
            alov Amber Love-Jones (Inactive) made changes -
            Assignee Nandkumar [ satyap ] Mahendra Mungase [ mahendra.mungase ]
            Hide
            mahendra.mungase Mahendra Mungase (Inactive) added a comment -

            Hi Smita Pawar

            Please go through the JIRA comments and take appropriate action on it.

            CC - Sachin Hingole Revansiddha Gaur

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - Hi Smita Pawar Please go through the JIRA comments and take appropriate action on it. CC - Sachin Hingole Revansiddha Gaur
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Assignee Mahendra Mungase [ mahendra.mungase ] Smita Pawar [ smita.pawar ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Revansiddha Gaur [ revansiddha.gaur ]
            Hide
            alov Amber Love-Jones (Inactive) added a comment - - edited

            Hello Smita Pawar,

            Prime does see an issue with Column G of the January and February reporting. This Column should always be EDS as that is what we always offer the employee “family coverage”. This was to be hard coded on the back end in the Workterra system as approx. 1 year ago per the specifications given to Jennifer Leugers. This change needs to be made for all facilities going forward.

            Thank you.

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - - edited Hello Smita Pawar , Prime does see an issue with Column G of the January and February reporting. This Column should always be EDS as that is what we always offer the employee “family coverage”. This was to be hard coded on the back end in the Workterra system as approx. 1 year ago per the specifications given to Jennifer Leugers. This change needs to be made for all facilities going forward. Thank you. Amber
            Hide
            alov Amber Love-Jones (Inactive) added a comment -

            Hello Smita Pawar,

            We had a call with the client and wanted to verify that the following items are addressed:

            1. Prime advised that Column G should always be "EDS" as that is what Prime always offer the employee with “family coverage”. This was to be hard coded on the back end in the Workterra system as approx. 1 year ago. Please make sure it is re-coded for all 2017 reporting.

            2. Please review to ensure that all Medical plans for all Prime facilities are flagged for ACA.

            3. What FEIN number is attached on the back end to Summit Surgery Center?

            4. What FEIN number is attached on the back end to Reno Tahoe Anesthesiology?

            5. After the January 2017 report is updated and complete, is Dev able to run changes only reports? Please advise.

            Please research and advise on the above questions at your earliest convenience.

            In the interim, we are working with the Prime facilities to confirm that all employees with nothing listed under Medical (WT-9121 - completed) need to have Waive added under the medical option. Once this has been completed, we will re-run January and February reporting.

            Thank you,

            Amber

            Show
            alov Amber Love-Jones (Inactive) added a comment - Hello Smita Pawar , We had a call with the client and wanted to verify that the following items are addressed: 1. Prime advised that Column G should always be "EDS" as that is what Prime always offer the employee with “family coverage”. This was to be hard coded on the back end in the Workterra system as approx. 1 year ago. Please make sure it is re-coded for all 2017 reporting. 2. Please review to ensure that all Medical plans for all Prime facilities are flagged for ACA. 3. What FEIN number is attached on the back end to Summit Surgery Center? 4. What FEIN number is attached on the back end to Reno Tahoe Anesthesiology? 5. After the January 2017 report is updated and complete, is Dev able to run changes only reports? Please advise. Please research and advise on the above questions at your earliest convenience. In the interim, we are working with the Prime facilities to confirm that all employees with nothing listed under Medical ( WT-9121 - completed) need to have Waive added under the medical option. Once this has been completed, we will re-run January and February reporting. Thank you, Amber
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Amber Love-Jones,

            Please find our inline comments for the above comments.

            1. Prime advised that Column G should always be "EDS" as that is what Prime always offer the employee with “family coverage”.
            This was to be hard coded on the back end in the Workterra system as approx. 1 year ago. Please make sure it is re-coded for all 2017 reporting.
            Harbinger-Noted

            2. Please review to ensure that all Medical plans for all Prime facilities are flagged for ACA.
            Harbinger-Noted. We will consider all medical plans as ACA plan except opt out and waive.

            3. What FEIN number is attached on the back end to Summit Surgery Center?
            Harbinger- We will remove Summit Surgery Center for 2017 & attach this EIN(300852838) to Reno Tahoe Anesthesiology

            4. What FEIN number is attached on the back end to Reno Tahoe Anesthesiology?
            Harbinger- 300852838.

            5. After the January 2017 report is updated and complete, is Dev able to run changes only reports? Please advise.
            Harbinger- Yes

            Please research and advise on the above questions at your earliest convenience.
            In the interim, we are working with the Prime facilities to confirm that all employees with nothing listed under Medical ( WT-9121 CLOSED - completed) need to have Waive added under the medical option. Once this has been completed, we will re-run January and February reporting.
            Harbinger-Noted

            Thanks,
            Revan
            Smita Pawar Mahendra Mungase Sachin Hingole Nandkumar Prabhakar Karlekar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Amber Love-Jones , Please find our inline comments for the above comments. 1. Prime advised that Column G should always be "EDS" as that is what Prime always offer the employee with “family coverage”. This was to be hard coded on the back end in the Workterra system as approx. 1 year ago. Please make sure it is re-coded for all 2017 reporting. Harbinger-Noted 2. Please review to ensure that all Medical plans for all Prime facilities are flagged for ACA. Harbinger-Noted. We will consider all medical plans as ACA plan except opt out and waive. 3. What FEIN number is attached on the back end to Summit Surgery Center? Harbinger- We will remove Summit Surgery Center for 2017 & attach this EIN(300852838) to Reno Tahoe Anesthesiology 4. What FEIN number is attached on the back end to Reno Tahoe Anesthesiology? Harbinger- 300852838. 5. After the January 2017 report is updated and complete, is Dev able to run changes only reports? Please advise. Harbinger- Yes Please research and advise on the above questions at your earliest convenience. In the interim, we are working with the Prime facilities to confirm that all employees with nothing listed under Medical ( WT-9121 CLOSED - completed) need to have Waive added under the medical option. Once this has been completed, we will re-run January and February reporting. Harbinger-Noted Thanks, Revan Smita Pawar Mahendra Mungase Sachin Hingole Nandkumar Prabhakar Karlekar
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Yogesh Chaudhari [ yogesh.chaudhari ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Link This issue relates to WT-8296 [ WT-8296 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 30/Nov/17 06:25 AM - edited
            • Time Spent:
              4h
               

              Analysis of this enhancement on local machine

            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Environment Others [ 18445 ]
            Remaining Estimate 60h [ 216000 ]
            Original Estimate 60h [ 216000 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 60h [ 216000 ] 56h [ 201600 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 94197 [ 94197 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Worklog Id 94197 [ 94197 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 01/Dec/17 02:23 PM
            • Time Spent:
              2h
               

              Worked on prime change file through automation

            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 56h [ 201600 ] 54h [ 194400 ]
            Time Spent 4h [ 14400 ] 6h [ 21600 ]
            Worklog Id 94765 [ 94765 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 07/Dec/17 12:40 PM
            • Time Spent:
              8h
               

              Analysis of change scenario on local machine
              discussion with reav

            revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 07/Dec/17 10:00 PM
            • Time Spent:
              2h
               

              Discussion on change file issue.

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 08/Dec/17 12:41 PM
            • Time Spent:
              7.5h
               

              Worked to export change for Prime

            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 54h [ 194400 ] 46h [ 165600 ]
            Time Spent 6h [ 21600 ] 14h [ 50400 ]
            Worklog Id 95378 [ 95378 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 46h [ 165600 ] 44h [ 158400 ]
            Time Spent 14h [ 50400 ] 16h [ 57600 ]
            Worklog Id 95379 [ 95379 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 44h [ 158400 ] 36.5h [ 131400 ]
            Time Spent 16h [ 57600 ] 23.5h [ 84600 ]
            Worklog Id 95381 [ 95381 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 12/Dec/17 11:41 AM
            • Time Spent:
              6h
               

              Exported prime change file from local made required changes in SP.
              discussion with revan

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 13/Dec/17 11:43 AM
            • Time Spent:
              4h
               

              Worked on the prime change file changes

            yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 14/Dec/17 11:36 AM
            • Time Spent:
              3h
               

              Unit testing of change file scenario on local machine

            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 36.5h [ 131400 ] 33.5h [ 120600 ]
            Time Spent 23.5h [ 84600 ] 26.5h [ 95400 ]
            Worklog Id 97143 [ 97143 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 33.5h [ 120600 ] 27.5h [ 99000 ]
            Time Spent 26.5h [ 95400 ] 32.5h [ 117000 ]
            Worklog Id 97152 [ 97152 ]
            yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
            Remaining Estimate 27.5h [ 99000 ] 23.5h [ 84600 ]
            Time Spent 32.5h [ 117000 ] 36.5h [ 131400 ]
            Worklog Id 97153 [ 97153 ]
            alov Amber Love-Jones (Inactive) made changes -
            Comment [ Hello [~yogesh.chaudhari],

            Please provide a date in January that each monthly file (July 2017 - December 2017) will be sent to Worxtime.

            Thank you!

            Amber ]
            Hide
            Monika.Demla Monika Demla (Inactive) added a comment -

            please close this ticket if this is resolved.

            Show
            Monika.Demla Monika Demla (Inactive) added a comment - please close this ticket if this is resolved.
            Prashant.samal Prashant Samal (Inactive) made changes -
            Epic Link DEV-62 [ 63309 ]
            Hide
            Monika.Demla Monika Demla (Inactive) added a comment -

            Prashant Samal - Could you please confirm on this one as well? if this is close then we can close this ticket

            Show
            Monika.Demla Monika Demla (Inactive) added a comment - Prashant Samal - Could you please confirm on this one as well? if this is close then we can close this ticket
            Prashant.samal Prashant Samal (Inactive) made changes -
            Resolution Cancelled [ 10300 ]
            Status New Request [ 10029 ] Resolution Setting [ 11616 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Status Resolution Setting [ 11616 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Prashant Samal (Inactive) made transition -
            New Request Resolution Setting
            550d 13h 50m 1
            Prashant Samal (Inactive) made transition -
            Resolution Setting Closed
            4s 1

              People

              Assignee:
              yogesh.chaudhari Yogesh Chaudhari (Inactive)
              Reporter:
              mahendra.mungase Mahendra Mungase (Inactive)
              Account Executive:
              Jennifer Johnson (Inactive)
              Developer:
              Nandkumar Prabhakar Karlekar (Inactive)
              QA:
              Mahendra Mungase (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 60h
                  60h
                  Remaining:
                  Time Spent - 36.5h Remaining Estimate - 23.5h
                  23.5h
                  Logged:
                  Time Spent - 36.5h Remaining Estimate - 23.5h
                  36.5h