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

BCC Invoice Management - Adjustments in future Invoice

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Module:
      BenAdmin - Report
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 17

      Description

      Adjustment for :-

      1. First Invoice
      2. Retro Add
      3. Retro Term

        Attachments

          Issue Links

            Activity

            alankar.chavan Alankar Chavan (Inactive) logged work - 22/Nov/16 12:09 PM
            • Time Spent:
              6h
               
              <No comment>
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 23/Nov/16 06:47 AM
            • Time Spent:
              5h
               
              <No comment>
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 24/Nov/16 05:52 AM
            • Time Spent:
              7h
               
              <No comment>
            alankar.chavan Alankar Chavan (Inactive) logged work - 24/Nov/16 06:29 AM
            • Time Spent:
              7h
               
              <No comment>
            alankar.chavan Alankar Chavan (Inactive) logged work - 24/Nov/16 08:39 AM
            • Time Spent:
              6h
               
              <No comment>
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 24/Nov/16 01:27 PM
            • Time Spent:
              7h
               
              <No comment>
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 25/Nov/16 12:50 PM
            • Time Spent:
              7h
               

              Discussion and Scenarios Creation

            prasanna Prasanna Karlekar (Inactive) logged work - 25/Nov/16 01:48 PM
            • Time Spent:
              5h
               

              Discussion on how to create data structure to cover all adjustments
              Discussion on Plans and Rates customization for scenario generation
              Analysis on logic for creating the data structure

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 28/Nov/16 01:33 PM
            • Time Spent:
              7h
               
              <No comment>
            prasanna Prasanna Karlekar (Inactive) logged work - 28/Nov/16 06:00 PM
            • Time Spent:
              4.5h
               
              • Changes discussion and code review for Triggers that are modified for this change
              • Analysis and discussion to track retro add adjustments for cost and election changes.
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 29/Nov/16 01:18 PM
            • Time Spent:
              7h
               
              <No comment>
            alankar.chavan Alankar Chavan (Inactive) logged work - 30/Nov/16 04:15 AM
            • Time Spent:
              3h
               
              <No comment>
            prasanna Prasanna Karlekar (Inactive) logged work - 01/Dec/16 02:42 PM
            • Time Spent:
              3.5h
               

              Discussion, analysis and coding on First Invoice, Retro Add and Retro Term.

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 01/Dec/16 03:10 PM
            • Time Spent:
              7h
               
              <No comment>
            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 02/Dec/16 12:32 PM
            • Time Spent:
              7h
               
              <No comment>
            prasanna Prasanna Karlekar (Inactive) logged work - 02/Dec/16 02:43 PM
            • Time Spent:
              1.5h
               

              Discussion on adjustment scenarios that needs to be unit tested for first invoice and retro add.
              Discussion on population of adjustment grids not coming in sorted order on UI.

            prasanna Prasanna Karlekar (Inactive) logged work - 03/Dec/16 11:24 AM - edited
            • Time Spent:
              4h
               

              Code for pulling Retro Term records
              Basic scenario testing for Retro Terms

            prasanna Prasanna Karlekar (Inactive) logged work - 05/Dec/16 03:28 PM
            • Time Spent:
              2h
               

              Discussion on Billing Trigger update
              Discussion on adjustments in first invoice.
              Changes in Retro procedure for Add and Term.

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 06/Dec/16 01:23 PM
            • Time Spent:
              7h
               

              Scenario generation, Unit testing , LB code checkin

            surender.kumar surender kumar (Inactive) logged work - 07/Dec/16 11:30 AM
            • Time Spent:
              3h
               
              • Triggers Modified
              • Test the different cases
              • check in on stage
            alankar.chavan Alankar Chavan (Inactive) logged work - 07/Dec/16 12:51 PM
            • Time Spent:
              3.5h
               

              2.5 Hr - for started testing on LB
              1 Hr - client call

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 07/Dec/16 01:35 PM
            • Time Spent:
              1h
               
              <No comment>
            alankar.chavan Alankar Chavan (Inactive) logged work - 08/Dec/16 08:01 AM
            • Time Spent:
              2.5h
               

              client call
              build discussion
              KT to Priya and Venkatesh

            alankar.chavan Alankar Chavan (Inactive) logged work - 08/Dec/16 09:09 AM
            • Time Spent:
              1h
               

              Testing Analysis

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 08/Dec/16 12:38 PM
            • Time Spent:
              5h
               

              Tested Billing details and Adjustment scenarios

            priya.dhamande Priya Dhamande (Inactive) logged work - 08/Dec/16 01:56 PM
            • Time Spent:
              4.5h
               
              <No comment>
            alankar.chavan Alankar Chavan (Inactive) logged work - 09/Dec/16 09:09 AM
            • Time Spent:
              8h
               

              Testing and making ready foe client

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 09/Dec/16 11:00 AM
            • Time Spent:
              3h
               
              <No comment>
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 09/Dec/16 01:13 PM
            • Time Spent:
              3h
               
              <No comment>
            priya.dhamande Priya Dhamande (Inactive) logged work - 09/Dec/16 01:56 PM
            • Time Spent:
              4.5h
               
              <No comment>
            alankar.chavan Alankar Chavan (Inactive) logged work - 12/Dec/16 06:18 AM
            • Time Spent:
              4.5h
               

              Production Patch Testing - Basic to make it ready for client

            alankar.chavan Alankar Chavan (Inactive) logged work - 12/Dec/16 01:04 PM
            • Time Spent:
              2h
               

              stage and production testing

            prasanna Prasanna Karlekar (Inactive) logged work - 13/Dec/16 03:46 PM
            • Time Spent:
              0.5h
               

              Discussion on Billing Trigger changes.

            surender.kumar surender kumar (Inactive) logged work - 13/Dec/16 10:00 PM
            • Time Spent:
              4h
               

              Analysis
              Discussion
              Testing
              On Triggers

            alankar.chavan Alankar Chavan (Inactive) logged work - 14/Dec/16 12:40 PM
            • Time Spent:
              0.5h
               

              client call

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 16/Dec/16 12:07 PM
            • Time Spent:
              1h
               

              Billing Details Discussion

            alankar.chavan Alankar Chavan (Inactive) logged work - 16/Dec/16 12:45 PM
            • Time Spent:
              1.5h
               

              Meeting with Devs

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 16/Dec/16 03:03 PM
            • Time Spent:
              10h
               

              Analysis, scenario generation, code fix, unit testing, team meeting

            jyoti.mayne Jyoti Mayne logged work - 16/Dec/16 06:01 PM - edited
            • Time Spent:
              0.5h
               

              attended meeting

            prasanna Prasanna Karlekar (Inactive) logged work - 19/Dec/16 08:30 AM - edited
            • Time Spent:
              3.25h
               

              Scenario discussion and testing for Retro scenarios.
              Discussion on open tickets related to adjustments.

            alankar.chavan Alankar Chavan (Inactive) logged work - 19/Dec/16 01:13 PM
            • Time Spent:
              2.5h
               

              Started LB Testing
              Deployed at 3 PM

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 19/Dec/16 01:19 PM
            • Time Spent:
              8h
               

              Discussion, Scenario generation, unit testing , code check-in

            alankar.chavan Alankar Chavan (Inactive) logged work - 20/Dec/16 12:44 PM
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 20/Dec/16 12:59 PM
            • Time Spent:
              6h
               

              BCC Scenarios Testing

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 21/Dec/16 04:02 AM
            • Time Spent:
              40m
               
              <No comment>
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 21/Dec/16 12:19 PM
            • Time Spent:
              7h
               

              BCC Adjustment scenarios testing

            alankar.chavan Alankar Chavan (Inactive) logged work - 21/Dec/16 01:15 PM
            • Time Spent:
              6.5h
               

              LB Testing - Adjustments
              New Issue : WT-7288

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 22/Dec/16 09:43 AM
            • Time Spent:
              2h
               

              Adjustment scenarios tested

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 22/Dec/16 12:53 PM
            • Time Spent:
              1h
               
              <No comment>
            alankar.chavan Alankar Chavan (Inactive) logged work - 23/Dec/16 04:51 AM
            • Time Spent:
              5h
               

              LB Testing

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 23/Dec/16 12:13 PM
            • Time Spent:
              7h
               

              Bug analysis and fixing

            alankar.chavan Alankar Chavan (Inactive) logged work - 23/Dec/16 12:35 PM
            • Time Spent:
              2.5h
               

              LB Testing

            prasanna Prasanna Karlekar (Inactive) logged work - 24/Dec/16 01:35 AM
            • Time Spent:
              1.5h
               

              Discussion on points that will be deployed on Stage, pending points for Adjustments.

            prasanna Prasanna Karlekar (Inactive) logged work - 25/Dec/16 01:00 AM
            • Time Spent:
              1.5h
               

              Adjustments pending ticket go through, scenario verification and update.

            alankar.chavan Alankar Chavan (Inactive) logged work - 26/Dec/16 12:54 PM
            • Time Spent:
              6h
               

              Stage Patch deployed for BCC Adjustment
              Started Testing basic scenarios on Stage

            kunal.kedari Kunal Kedari (Inactive) logged work - 27/Dec/16 04:24 AM
            • Time Spent:
              1.5h
               

              Testing different scenarios on Stage.

            prasanna Prasanna Karlekar (Inactive) logged work - 27/Dec/16 04:33 AM
            • Time Spent:
              0.75h
               

              JIRA ticket update related to Adjustments.

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 27/Dec/16 09:55 AM
            • Time Spent:
              2h
               

              Testing on stage

            alankar.chavan Alankar Chavan (Inactive) logged work - 27/Dec/16 12:50 PM
            • Time Spent:
              3.5h
               

              Stage Testing

            prasanna Prasanna Karlekar (Inactive) logged work - 28/Dec/16 03:05 AM
            • Time Spent:
              0.75h
               

              Verification for display of records in Billing Report for same month but with multiple elections in same plan for different span.

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 28/Dec/16 07:06 AM
            • Time Spent:
              3h
               

              Testing different scenarios for Life,health plans with self insured rates,billed rates

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 28/Dec/16 10:31 AM
            • Time Spent:
              2h
               

              Flex and Future scenarios

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 28/Dec/16 12:20 PM - edited
            • Time Spent:
              1h
               

              Health plans scenarios

            alankar.chavan Alankar Chavan (Inactive) logged work - 28/Dec/16 12:50 PM - edited
            • Time Spent:
              5h
               

              Stage Testing
              Scenarios related to future enrollments - billing policies - flex and offered life plans
              Issues Logged WT-7420 & WT-7423

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 28/Dec/16 12:50 PM
            • Time Spent:
              5h
               

              Change of logic for data being fetched from intermediate tables

            prasanna Prasanna Karlekar (Inactive) logged work - 28/Dec/16 05:38 PM
            • Time Spent:
              3.5h
               
              • Preparation on points to be discussed in call
              • Data check for CWC and TIBCO for Adjustments
              • BCC Status update call
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 29/Dec/16 04:14 AM
            • Time Spent:
              1h
               

              Call

            alankar.chavan Alankar Chavan (Inactive) logged work - 29/Dec/16 04:14 AM
            • Time Spent:
              1h
               

              client call

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 29/Dec/16 09:16 AM - edited
            • Time Spent:
              3h
               

              Bcc testing scenarios

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 29/Dec/16 12:34 PM
            • Time Spent:
              0.5h
               

              Discussion for scenarios with Alankar

            prasanna Prasanna Karlekar (Inactive) logged work - 30/Dec/16 03:04 AM
            • Time Spent:
              2.5h
               

              Discussion
              Review of changes done after adding Rates intermediate records in Billing table

            alankar.chavan Alankar Chavan (Inactive) logged work - 30/Dec/16 04:25 AM
            • Time Spent:
              6.5h
               

              Stage Testing
              Discussions
              WT - 7451 & WT - 7453 are logged

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 30/Dec/16 04:25 AM
            • Time Spent:
              8h
               

              Code fix, unit testing, discussion, code review

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 30/Dec/16 12:32 PM
            • Time Spent:
              3h
               

              Unit testing for all health benefits with different scenarios, Code fix to track future enrollment retros

            prasanna Prasanna Karlekar (Inactive) logged work - 30/Dec/16 10:00 PM
            • Time Spent:
              1.5h
               

              Invoice pending issue list go through
              Discussion on pending issues

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 02/Jan/17 01:40 PM
            • Time Spent:
              6h
               

              Discussion, Analysis for data discrepancy in Invoice and export ,scenario generation, unit testing

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 03/Jan/17 10:34 AM
            • Time Spent:
              0.5h
               

              Meeting

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 03/Jan/17 01:14 PM
            • Time Spent:
              8h
               

              Data analysis, discussion, code check-in, unit testing

            alankar.chavan Alankar Chavan (Inactive) logged work - 03/Jan/17 02:54 PM
            • Time Spent:
              1.5h
               

              meeting
              status gathering and mailing

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 03/Jan/17 03:29 PM
            • Time Spent:
              2h
               

              Scenarios testing

            prasanna Prasanna Karlekar (Inactive) logged work - 03/Jan/17 11:30 PM - edited
            • Time Spent:
              1.5h
               

              Discussion on further deployment plan.
              Discussion on adjustments expected on Feb 2017 Invoice for CWC, CDC and TIBCO.

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 04/Jan/17 12:42 PM
            • Time Spent:
              2h
               

              Scenario testing for ongoing enrollments in LB

            prasanna Prasanna Karlekar (Inactive) logged work - 07/Jan/17 06:30 AM
            • Time Spent:
              2.5h
               

              Client call preparation.
              Client call.

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 09/Jan/17 12:58 PM
            • Time Spent:
              1h
               

              Discussion, production code check-in

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 13/Jan/17 12:37 PM
            • Time Spent:
              2h
               

              Testing different scenarios

            alankar.chavan Alankar Chavan (Inactive) logged work - 13/Jan/17 12:45 PM
            • Time Spent:
              3h
               

              made document for demo data and company creation

            prasanna Prasanna Karlekar (Inactive) logged work - 17/Jan/17 11:30 PM
            • Time Spent:
              3.5h
               

              Handling Retro Term Adjustments in Invoice

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 18/Jan/17 02:17 PM
            • Time Spent:
              0.25h
               

              Stage code check-in

            prasanna Prasanna Karlekar (Inactive) logged work - 18/Jan/17 07:30 PM
            • Time Spent:
              3.5h
               

              Discussion on Same month Adjustment scenarios for Billing and Invoice both.
              Analysis and approach to handle this scenario.

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 19/Jan/17 05:30 PM
            • Time Spent:
              8h
               

              Data analysis and correction

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 20/Jan/17 05:51 PM
            • Time Spent:
              9h
               

              Data analysis and correction on stage for BCC companies

              People

              Assignee:
              venkatesh.pujari Venkatesh Pujari (Inactive)
              Reporter:
              jyoti.agrawal Jyoti Agrawal (Inactive)
              Account Executive:
              Debbie Kulling
              Developer:
              Jyoti Agrawal (Inactive)
              QA:
              Alankar Chavan (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 160h Original Estimate - 160h
                  160h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 344h 40m
                  344h 40m