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

City of SeaTac-November Invoice

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Environment:
      Production
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Report
    • Reported by:
      Client
    • Company:
      City of SeaTac
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 41

      Description

      Hello,

      Per the client:
      The November invoice has 3 adjustments for October which do show the credited amount, but not the rebilled amount. Can you please help to correct this?

      The group is expecting their invoice on Oct 20th. Can you please expedite this request?

      Thank you,
      Kira Hamilton
      Debbie Kulling

        Attachments

          Issue Links

            Activity

            prasanna Prasanna Karlekar (Inactive) logged work - 19/Oct/17 07:30 PM
            • Time Spent:
              6.5h
               

              Issue go through
              Issue Analysis
              Issue fix
              Unit testing
              Data scan for impacted invoices
              JIRA update

            prasanna Prasanna Karlekar (Inactive) logged work - 07/Nov/17 02:30 AM
            • Time Spent:
              0.5h
               

              Scenario Testing

            prasanna Prasanna Karlekar (Inactive) logged work - 07/Nov/17 10:00 PM - edited
            • Time Spent:
              2.75h
               

              Scenario listing following is complete:
              Basic structure
              First Invoice - scenarios related to Billed Rate
              First Invoice - scenarios related to Self Insured Component
              First Invoice - scenarios related to Non Health plans

            prasanna Prasanna Karlekar (Inactive) logged work - 08/Nov/17 10:00 PM - edited
            • Time Spent:
              2.5h
               

              Scenario Listing for Second Invoice (Cost Changes) -
              Cost changes for Billed Rate terminated elections
              Cost changes for Billed Rate ongoing elections
              Cost changes for self insured component terminated elections
              Cost changes for self insured component ongoing elections
              Cost changes for non health terminated elections
              Cost changes for non health ongoing elections

            prasanna Prasanna Karlekar (Inactive) logged work - 10/Nov/17 02:30 AM
            • Time Spent:
              0.5h
               

              Scenario Listing for Second Invoice -
              Coverage and Tier changes

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 13/Nov/17 04:27 PM
            • Time Spent:
              4h
               

              Scenarios go through, discussion with Prasanna, Scenarios creation

            prasanna Prasanna Karlekar (Inactive) logged work - 13/Nov/17 07:00 PM
            • Time Spent:
              0.75h
               

              Discussion on test data creation
              Scenario discussion related to Test data

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 14/Nov/17 01:04 PM
            • Time Spent:
              6h
               

              Scenario creations, discussion with Prasanna

            prasanna Prasanna Karlekar (Inactive) logged work - 14/Nov/17 10:00 PM
            • Time Spent:
              6.5h
               

              Planning on Classes,Plans, rate, subrates, eligibility rules required
              Discussion
              Classes, plans, rate plan mapping documentation
              Review of documented test data for scenario: First Invoice - Effective Term in same month-All policies
              Backend verification to check reusabiltiy of existing test data
              Integration with final document

            prasanna Prasanna Karlekar (Inactive) logged work - 16/Nov/17 02:30 AM
            • Time Spent:
              0.5h
               

              Review of documented test data for scenario:
              First Invoice - Effective Term in different month-In Progress

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 16/Nov/17 01:12 PM
            • Time Spent:
              5.5h
               

              Scenario documentation, discussion with Prasanna

            prasanna Prasanna Karlekar (Inactive) logged work - 16/Nov/17 08:30 PM
            • Time Spent:
              0.75h
               

              Scenario discussion for Cost changes and Tier changes

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

              Scenario creations

            prasanna Prasanna Karlekar (Inactive) logged work - 17/Nov/17 07:00 PM
            • Time Spent:
              1h
               

              Scenario discussion

            prasanna Prasanna Karlekar (Inactive) logged work - 21/Nov/17 02:30 AM
            • Time Spent:
              0.5h
               

              Discussion on tasks completed
              JIRA update

            prasanna Prasanna Karlekar (Inactive) logged work - 22/Nov/17 01:00 AM
            • Time Spent:
              0.5h
               

              Scenario review - First Invoice Different Start and End months pending scenarios

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 23/Nov/17 01:10 PM - edited
            • Time Spent:
              1h
               

              Plan Creation

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 24/Nov/17 01:44 PM
            • Time Spent:
              7h
               

              Code correction after review, unit testing, data correction in compnaies

            prasanna Prasanna Karlekar (Inactive) logged work - 24/Nov/17 02:05 PM
            • Time Spent:
              1h
               

              Scenario review - First Invoice Different Start and End months - Complete
              Analysis and Discussion on Employee Import file creation - In Progress

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 27/Nov/17 01:29 PM
            • Time Spent:
              4h
               

              Scenario creation, discussion with Lalit and Prasanna

            prasanna Prasanna Karlekar (Inactive) logged work - 27/Nov/17 08:30 PM
            • Time Spent:
              6.5h
               

              Scenario discussion - Tier changes in same plan
              Import teamplate creation for employee and election import
              Test employee and election import file creation
              Discussion with QA as test employee not getting imported
              Employee load file creation
              Classes and Eligibility changes as cost not getting assigned on test employee import

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 28/Nov/17 05:44 PM
            • Time Spent:
              6.5h
               

              Documenting Tier change in same plan, election effective retrospectively
              Discussion with Prasanna

            prasanna Prasanna Karlekar (Inactive) logged work - 28/Nov/17 11:30 PM
            • Time Spent:
              4h
               

              Employee import
              Election import
              Scenario discussion
              Doing scenario verification manually will be time taking task hence, getting the expected output documented in excel sheet to import in Database - Getting issues related to formats - In Progress

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 29/Nov/17 05:48 PM
            • Time Spent:
              6.5h
               

              Documenting mid month plan change
              Discussion with Lalit and Prasanna
              Importing Excel in database

            prasanna Prasanna Karlekar (Inactive) logged work - 29/Nov/17 06:00 PM - edited
            • Time Spent:
              2h
               

              Invoice test scenario document integration
              Scenario discussion on tier change in same / different plans
              Disucssion on scenarios completed
              Discussion on data import in database for record verification
              JIRA update - Pending and completed tasks

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 30/Nov/17 01:40 PM
            • Time Spent:
              3h
               
              • Election import data creation for Self insured plan and Non Health Plan
              • Imported Self insured plan election
              • Issue analysis for Non health import error
              • Verified First invoice billing data
            prasanna Prasanna Karlekar (Inactive) logged work - 30/Nov/17 06:30 PM
            • Time Spent:
              0.25h
               

              Discussion on data that needs to be imported

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 01/Dec/17 01:28 PM
            • Time Spent:
              2h
               

              Non health plan cost configuration
              Non health and self insured election import

            prasanna Prasanna Karlekar (Inactive) logged work - 01/Dec/17 10:00 PM
            • Time Spent:
              0.75h
               

              Non health plan data not getting imported
              Template creation for Non Health election data
              Test file creation
              Non health data import - Not successful error appearing. Need to try more

            jyoti.agrawal Jyoti Agrawal (Inactive) logged work - 05/Dec/17 10:44 AM
            • Time Spent:
              4h
               

              Unit testing, discussion with Prasanna

            prasanna Prasanna Karlekar (Inactive) logged work - 06/Dec/17 10:00 PM
            • Time Spent:
              1h
               

              Code review
              Code checkin

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 12/Dec/17 06:44 PM
            • Time Spent:
              2.5h
               

              Analysis and scenario creation

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 13/Dec/17 06:46 PM
            • Time Spent:
              2h
               

              Testing on LB

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 28/Dec/17 09:50 AM
            • Time Spent:
              2h
               

              Testing on Stage

            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 29/Dec/17 11:24 AM
            • Time Spent:
              1h
               

              Testing on Production

              People

              Assignee:
              Kira.Hamilton Kira Hamilton (Inactive)
              Reporter:
              Kira.Hamilton Kira Hamilton (Inactive)
              Account Executive:
              Debbie Kulling
              Developer:
              Prasanna Karlekar (Inactive)
              QA:
              Venkatesh Pujari (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0h
                  0h
                  Remaining:
                  Time Spent - 101.75h Remaining Estimate - 2h
                  2h
                  Logged:
                  Time Spent - 101.75h Remaining Estimate - 2h
                  101.75h