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

Export > BCC Enhancement - cost is eliminated in providerwise export

    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

      Finalized Invoice Details: Health (Sept 2016)
      Company (on LB) : ASML
      Template Name : 5308 Rowise

      the invoice shows Clone of Delta Dental Plan 1 record for employee Jered Adams on Invoice having cost of $44. But this cost is not included in the Provider wise export against Delta Dental AZ Provider.
      So Total Amount Exporting on File is wrong for this provider

      Please check this and update accordingly.

        Attachments

          Issue Links

            Activity

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

            Below are 3C's
            Concern :BCC Enhancement - cost is eliminated in providerwise export
            Cause :This happens because JOIN for EmployeeHealthTierPolicyNumber_Log table, ImportExportEnrollmentDeductiondata, HealthTier were Not Proper.

            Correction We have Handle this as of now in SP.

            Show
            rakesh.shahane Rakesh Shahane (Inactive) added a comment - - edited Below are 3C's Concern :BCC Enhancement - cost is eliminated in providerwise export Cause :This happens because JOIN for EmployeeHealthTierPolicyNumber_Log table, ImportExportEnrollmentDeductiondata, HealthTier were Not Proper. Correction We have Handle this as of now in SP.
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified this fix on LB on Rowise and Column wise templates for Health Plans . Total Billed Amount exported on Providerwise Exported file are proper

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified this fix on LB on Rowise and Column wise templates for Health Plans . Total Billed Amount exported on Providerwise Exported file are proper
            Hide
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            adding stage and production testing estimates.

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - adding stage and production testing estimates.
            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 this on stage . Cost getting exported properly on file

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified this on stage . Cost getting exported properly on file
            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 - 1h Original Estimate - 1h
                  1h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h 10m
                  1h 10m