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

Export > BCC Enhancement - Wrong total amount (extra amount) getting displayed if Self Insured component is configured

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      QA
    • Module:
      BenAdmin - Export
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      Wrong cost is getting exported on the file if Self Insured Component is configured

      I've configured self insured components for Medical plans (Gold_opposite and Silver Alt plans) DONOTUSE_CALLSTESTING on LB

      Invoice for Heath Benefits is finalized and Verified the results on Provider wise Export file.Observed that the total billed amount getting exported on file and the Total Amount on finalized invoice is not matching .

      Actual Amount : 1047768.87
      Expected Amount : 974985.67

      Template Details : 5308 Rowise

        Attachments

          Issue Links

            Activity

            Hide
            rakesh.shahane Rakesh Shahane (Inactive) added a comment -

            Concern : BCC Enhancement - Wrong total amount (extra amount) getting displayed if Self Insured component is configured.

            Cause : This issue was caused due to EmployeeHealthTierPolicyNumber_Log has more than one entry for single enrollment in which was not handled int the SP OES_SP_Export_ProviderWiseInvoiceReport.

            Correction : Now we have taken max Enrollment From EmployeeHealthTierPolicyNumber_Log, So this issue will get resolved.

            Show
            rakesh.shahane Rakesh Shahane (Inactive) added a comment - Concern : BCC Enhancement - Wrong total amount (extra amount) getting displayed if Self Insured component is configured. Cause : This issue was caused due to EmployeeHealthTierPolicyNumber_Log has more than one entry for single enrollment in which was not handled int the SP OES_SP_Export_ProviderWiseInvoiceReport . Correction : Now we have taken max Enrollment From EmployeeHealthTierPolicyNumber_Log, So this issue will get resolved.
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified the fix on LB for mentioned Self Insured Component . Total Amount getting exported on the file is proper for both (rowsie and Columnwise). Working as expected

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified the fix on LB for mentioned Self Insured Component . Total Amount getting exported on the file is proper for both (rowsie and Columnwise). Working as expected
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Updating stage and production testing estimates including creation of self insured components on plans

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Updating stage and production testing estimates including creation of self insured components on plans
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Fix is deployed along with its parent JIRA WT-5308

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Fix is deployed along with its parent JIRA WT-5308
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified Self Insured component for Medical plan on stage on City of Bellevue for HSPL company. Self Insured Component cost is getting exported properly on the file. Ready for Production

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified Self Insured component for Medical plan on stage on City of Bellevue for HSPL company. Self Insured Component cost is getting exported properly on the file. Ready for Production
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified this fix on Production. Providerwise Billing Data export on Rowise , Columnwise Templates are working as expected.

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified this fix on Production. Providerwise Billing Data export on Rowise , Columnwise Templates are working as expected.

              People

              Assignee:
              aniruddha.dev Aniruddha Dev (Inactive)
              Reporter:
              aniruddha.dev Aniruddha Dev (Inactive)
              QA:
              Aniruddha Dev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 2.5h
                  2.5h
                  Remaining:
                  Time Spent - 1h 20m Remaining Estimate - 1h 10m
                  1h 10m
                  Logged:
                  Time Spent - 1h 20m Remaining Estimate - 1h 10m
                  1h 20m