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

ADP : Consider historical data on ACA Export files.

    Details

    • Type: Enhancement
    • Status: Product Backlog
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Module:
      ACA - Reports
    • Reported by:
      EDI
    • Item State:
      Development - On Hold
    • Issue Importance:
      Must Have

      Description

      Scenario :

      Employee was in Class1 in Jan file & changed his class to new class in march, So again when
      exported the jan file should be same as original file.

        Attachments

          Activity

          revansiddha.gaur Revansiddha Gaur (Inactive) created issue -
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Field Original Value New Value
          Assignee Nandkumar [ satyap ] Revansiddha Gaur [ revansiddha.gaur ]
          Hide
          revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

          Sachin Hingole shyam sharma

          HI Nandkumar Prabhakar Karlekar,

          Still discussion is not cleared for this Jira. Keeping on hold.

          Regards,
          Revan

          Show
          revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Sachin Hingole shyam sharma HI Nandkumar Prabhakar Karlekar , Still discussion is not cleared for this Jira. Keeping on hold. Regards, Revan
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: On Hold(10207)
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Assignee Revansiddha Gaur [ revansiddha.gaur ] Yogesh Chaudhari [ yogesh.chaudhari ]
          Hide
          yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - - edited

          Assigning to Revan

          Nandkumar Prabhakar Karlekar

          Show
          yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - - edited Assigning to Revan Nandkumar Prabhakar Karlekar
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Assignee Yogesh Chaudhari [ yogesh.chaudhari ] Revansiddha Gaur [ revansiddha.gaur ]
          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 14/Sep/17 09:00 PM
          • Time Spent:
            0.5h
             

            Internal discussion for doubts.

          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 0.5h [ 1800 ]
          Worklog Id 78861 [ 78861 ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 18/Sep/17 07:14 AM
          • Time Spent:
            1.5h
             

            Discussion with revan about this issue.
            Meeting with Team and Nandu to resolve this issue.

          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Time Spent 0.5h [ 1800 ] 2h [ 7200 ]
          Worklog Id 79517 [ 79517 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: On Hold(10207) Parent values: Development(10200)Level 1 values: In Analysis(10204)
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Time Spent 2h [ 7200 ] 8h [ 28800 ]
          Worklog Id 90940 [ 90940 ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Time Spent 8h [ 28800 ] 8.5h [ 30600 ]
          Worklog Id 90946 [ 90946 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 15/Nov/17 10:00 PM
          • Time Spent:
            6h
             

            Analysis to meet requirement.

          yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 16/Nov/17 12:53 AM
          • Time Spent:
            0.5h
             

            Discussion and analysis with revan

          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Status New Request [ 10029 ] Product Backlog [ 10100 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 16/Nov/17 10:00 PM
          • Time Spent:
            4h
             

            Analysis discussion.

          yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 17/Nov/17 12:05 AM
          • Time Spent:
            4h
             

            Analysis and Discussion historical data on file.

          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Time Spent 8.5h [ 30600 ] 12.5h [ 45000 ]
          Worklog Id 91345 [ 91345 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Time Spent 12.5h [ 45000 ] 16.5h [ 59400 ]
          Worklog Id 91347 [ 91347 ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 18/Nov/17 05:53 AM
          • Time Spent:
            0.5h
             

            Discussion withn revan and team about flow.

          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 20/Nov/17 10:00 PM
          • Time Spent:
            8h
             

            To achieve functionality, on analysis basis POC Type coding in progress.

          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 21/Nov/17 10:00 PM
          • Time Spent:
            8h
             

            To achieve functionality, on analysis basis POC Type coding in progress.

          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Time Spent 16.5h [ 59400 ] 24.5h [ 88200 ]
          Worklog Id 91988 [ 91988 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Time Spent 24.5h [ 88200 ] 32.5h [ 117000 ]
          Worklog Id 91989 [ 91989 ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 22/Nov/17 05:47 AM
          • Time Spent:
            2h
             

            Analysis and Discussion with Revan and Nandkumar

          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Time Spent 32.5h [ 117000 ] 34.5h [ 124200 ]
          Worklog Id 92011 [ 92011 ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Time Spent 34.5h [ 124200 ] 35h [ 126000 ]
          Worklog Id 92018 [ 92018 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 22/Nov/17 10:00 PM
          • Time Spent:
            6h
             

            Impact checking on finalized points of Analysis using POC.

          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Time Spent 35h [ 126000 ] 41h [ 147600 ]
          Worklog Id 92796 [ 92796 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 28/Nov/17 10:00 PM
          • Time Spent:
            4h
             

            Analysis, discussion for various scenarios.

          yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 29/Nov/17 06:16 AM
          • Time Spent:
            4h
             

            Analysis and discussion with team about various scenarios

          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Time Spent 41h [ 147600 ] 45h [ 162000 ]
          Worklog Id 93425 [ 93425 ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Time Spent 45h [ 162000 ] 49h [ 176400 ]
          Worklog Id 94191 [ 94191 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Reported by Harbinger [ 10700 ] EDI (Workterra) [ 18440 ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 04/Dec/17 02:03 PM
          • Time Spent:
            2h
             

            Discussion of historical scenarios and use

          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Time Spent 49h [ 176400 ] 51h [ 183600 ]
          Worklog Id 94758 [ 94758 ]
          yogesh.chaudhari Yogesh Chaudhari (Inactive) logged work - 05/Dec/17 02:13 PM
          • Time Spent:
            3h
             

            Discussion and analysis with revan and nandu.

          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Time Spent 51h [ 183600 ] 54h [ 194400 ]
          Worklog Id 94759 [ 94759 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 05/Dec/17 10:00 PM
          • Time Spent:
            3h
             

            Internal discussion with team for queries regarding approval and importance of the jira & dropped the mail to Amit.

          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Time Spent 54h [ 194400 ] 57h [ 205200 ]
          Worklog Id 94827 [ 94827 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: On Hold(10207)
          Hide
          revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

          Hi Amit Thorve,

          As per current implementation, enrollment data gets populated correctly irrespective of any transition take place like class change, address change etc.
          But the thing is if any demographic fields are mapped in a template, will be populated only latest demographic data on a file which is less important for the ACA files.
          To clarify with more detail, please go through our example as below..
          Ex:
          XYZ employee
          Class1-C1
          Address- ABC
          Effective Date- 01/01/2017 to 02/28/2017
          Eligible plans- p1,p2,p3
          Enrolled in- Plan p2 with effective from 01/01/2017

          Now changes happen as below..
          Class1-C2
          Address- DEF
          Effective Date- 03/01/2017 to NULL
          Eligible plans- p4,p5,p6
          Enrolled in- Plan p4 with effective from 03/01/2017

          Exporting -> Suppose today we export a file for Jan month (01/01/2017 to 01/31/2017), will be populated data on the file with his Jan month eligible plans like p1,p2,p3 and his Jan month enrollment data with enrolled as p2 but demographic details of latest only i.e. C2 as Class1, DEF as Address( these data of demographic only discrepancy but this is less important for ACA perspective.)

          We approached to get the approval for the ticket and discussed with Samir that such requirement is not arisen till now from any client till that period we should hold on this JIRA.

          Please let us know your view on this, still this is required, please provide approval.

          Thanks,
          Revan


          CC- Nandkumar Prabhakar Karlekar, Satya, Samir, Ramya Tantry, Smita Pawar, Sachin Hingole

          Show
          revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Amit Thorve , As per current implementation, enrollment data gets populated correctly irrespective of any transition take place like class change, address change etc. But the thing is if any demographic fields are mapped in a template, will be populated only latest demographic data on a file which is less important for the ACA files. To clarify with more detail, please go through our example as below.. Ex: XYZ employee Class1-C1 Address- ABC Effective Date- 01/01/2017 to 02/28/2017 Eligible plans- p1,p2,p3 Enrolled in- Plan p2 with effective from 01/01/2017 Now changes happen as below.. Class1-C2 Address- DEF Effective Date- 03/01/2017 to NULL Eligible plans- p4,p5,p6 Enrolled in- Plan p4 with effective from 03/01/2017 Exporting -> Suppose today we export a file for Jan month (01/01/2017 to 01/31/2017), will be populated data on the file with his Jan month eligible plans like p1,p2,p3 and his Jan month enrollment data with enrolled as p2 but demographic details of latest only i.e. C2 as Class1, DEF as Address( these data of demographic only discrepancy but this is less important for ACA perspective.) We approached to get the approval for the ticket and discussed with Samir that such requirement is not arisen till now from any client till that period we should hold on this JIRA. Please let us know your view on this, still this is required, please provide approval. Thanks, Revan CC- Nandkumar Prabhakar Karlekar , Satya , Samir , Ramya Tantry , Smita Pawar , Sachin Hingole
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Assignee Revansiddha Gaur [ revansiddha.gaur ] Amit Thorve [ amitthorve ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Time Spent 57h [ 205200 ] 58h [ 208800 ]
          Worklog Id 106219 [ 106219 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 26/Feb/18 10:00 PM
          • Time Spent:
            1h
             

            Discussion with Nandkumar about the jira & reply.

          Transition Time In Source Status Execution Times
          Yogesh Chaudhari (Inactive) made transition -
          New Request Product Backlog
          434d 1h 57m 1

            People

            Assignee:
            amitthorve Amit Thorve (Inactive)
            Reporter:
            revansiddha.gaur Revansiddha Gaur (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 58h
                58h