Details

    • Type: Analysis
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:
      Production
    • Module:
      BenAdmin
    • Reported by:
      CareerBuilder
    • Company:
      Marymount High School
    • Severity:
      Simple

      Description

      Good day, Dev-

      The rates for Mary's Basic Life and AD&D come down on the Billing Details Report with $0's, Kristi suggested a Jira Ticket, she does not know how to correct.

      TSOTSIS, MARY Basic Life and AD&D $75,000.00 $48,750.00 07/18/2017 $0.00 $0.00 $0.00

      Can you please research and advise?

      Thanks,

      Raymond

      ref: CT-3214

        Attachments

          Issue Links

            Activity

            Prashant.samal Prashant Samal (Inactive) logged work - 08/Nov/17 01:15 PM
            • Time Spent:
              2h
               
              <No comment>
            Raywill Raymond Williams (Inactive) created issue -
            Hide
            satyap Satya added a comment -

            Hi Prashant,

            Can you please check mentioned details?

            Regards,
            Satya Prakash

            Cc: Samir Swapnil Pandhare Mandar Kulkarni

            Show
            satyap Satya added a comment - Hi Prashant, Can you please check mentioned details? Regards, Satya Prakash Cc: Samir Swapnil Pandhare Mandar Kulkarni
            satyap Satya made changes -
            Field Original Value New Value
            Assignee Satya [ ID10004 ] Prashant Samal [ prashant.samal ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Status New [ 10508 ] In Analysis [ 10008 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Attachment Findings WT-12006.PNG [ 67244 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Attachment Findings WT-12006.PNG [ 67244 ]
            Hide
            Prashant.samal Prashant Samal (Inactive) added a comment -

            Hello Raymond Williams,

            We have corrected the record on the Marymount High School company for now for this employee record and costs are coming down properly on the billing details report

            This occurred due to some inconstancy in the Enrollment Data and Related Billing Details Data
            We will provide more detailed explanation on the same.

            @@ Prasanna Karlekar : Please look into this for root cause and scanning.

            Thanks,
            S Prashant.
            -----------------------------------------------------------------
            Satya Swapnil Pandhare Mandar Kulkarni Rajendra Pawar Avnish Yadav

            Show
            Prashant.samal Prashant Samal (Inactive) added a comment - Hello Raymond Williams , We have corrected the record on the Marymount High School company for now for this employee record and costs are coming down properly on the billing details report This occurred due to some inconstancy in the Enrollment Data and Related Billing Details Data We will provide more detailed explanation on the same. @@ Prasanna Karlekar : Please look into this for root cause and scanning. Thanks, S Prashant. ----------------------------------------------------------------- Satya Swapnil Pandhare Mandar Kulkarni Rajendra Pawar Avnish Yadav
            Prashant.samal Prashant Samal (Inactive) made changes -
            Assignee Prashant Samal [ prashant.samal ] Prasanna Karlekar [ prasanna ]
            Hide
            Raywill Raymond Williams (Inactive) added a comment -
            Show
            Raywill Raymond Williams (Inactive) added a comment - Thanks Prashant Samal !
            Prashant.samal Prashant Samal (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 2h [ 7200 ]
            Worklog Id 89757 [ 89757 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue is caused by WT-8172 [ WT-8172 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Attachment WT-12048_AffectedCompanies.xlsx [ 67322 ]
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Prashant Samal,

            Thank you for initial analysis and correction.

            cc: Gaurav Sodani

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Prashant Samal , Thank you for initial analysis and correction. cc: Gaurav Sodani
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Raymond Williams,

            Following are the 3C's:
            Concern:
            The rates for Mary's Basic Life and AD&D come down on the Billing Details Report with $0's

            Cause:
            This issue is caused by WT-8172 and had impact on Billing Report only. After deployment of WT-8172, all records with future effective date should have been inserted in Billing table too. But this was not done, hence the record was missing from Billing table. As no record was present 0 cost was appearing in Billing Report. We have scanned all companies to check the data discrepancy. Please find company wise affected election count in WT-12048_AffectedCompanies.xlsx. Please note this issue is not there now and will not be there in future too. This issue was only for elections done before 18-Jul-2017(before deployment of WT-8172) and were having effective date greater than 18-Jul-2017.

            Correction:
            No code fix is required. Missing data needs to be inserted in billing table.
            Correction is in progress. Correction for pending companies will be done by tomorrow. We will also provide list of all impacted employees.

            Thank you!

            cc: Gaurav Sodani, Satya, Prashant Samal

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Raymond Williams , Following are the 3C's: Concern: The rates for Mary's Basic Life and AD&D come down on the Billing Details Report with $0's Cause: This issue is caused by WT-8172 and had impact on Billing Report only. After deployment of WT-8172 , all records with future effective date should have been inserted in Billing table too. But this was not done, hence the record was missing from Billing table. As no record was present 0 cost was appearing in Billing Report. We have scanned all companies to check the data discrepancy. Please find company wise affected election count in WT-12048_AffectedCompanies.xlsx . Please note this issue is not there now and will not be there in future too. This issue was only for elections done before 18-Jul-2017(before deployment of WT-8172 ) and were having effective date greater than 18-Jul-2017. Correction: No code fix is required. Missing data needs to be inserted in billing table. Correction is in progress. Correction for pending companies will be done by tomorrow. We will also provide list of all impacted employees. Thank you! cc: Gaurav Sodani , Satya , Prashant Samal
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 2h [ 7200 ] 5.5h [ 19800 ]
            Worklog Id 89964 [ 89964 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 09/Nov/17 07:30 PM
            • Time Spent:
              3.5h
               

              Root cause analysis
              Data scan
              Data correction
              JIRA update
              Email communication

            prasanna Prasanna Karlekar (Inactive) made changes -
            Hide
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Raymond Williams,

            Corrections are done for all pending companies.

            Please find attached WT-12048_AffectedCompanies&Elections.xlsx with following details:

            • "Company List" tab having impacted companies data
            • "Election List" tab having impacted elections data

            Do let us know if anything more is required from our side.

            Thank you!

            cc: Gaurav Sodani

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Raymond Williams , Corrections are done for all pending companies. Please find attached WT-12048_AffectedCompanies&Elections.xlsx with following details: "Company List" tab having impacted companies data "Election List" tab having impacted elections data Do let us know if anything more is required from our side. Thank you! cc: Gaurav Sodani
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Raymond Williams [ raywill ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status In Analysis [ 10008 ] Closed [ 6 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Resolution Done [ 10000 ] Fixed [ 1 ]
            Status Closed [ 6 ] In Analysis [ 10008 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status In Analysis [ 10008 ] Closed [ 6 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 5.5h [ 19800 ] 8.5h [ 30600 ]
            Worklog Id 90245 [ 90245 ]
            prasanna Prasanna Karlekar (Inactive) logged work - 10/Nov/17 07:00 PM
            • Time Spent:
              3h
               

              Data Correction
              Verification
              JIRA update

            Transition Time In Source Status Execution Times
            Prashant Samal (Inactive) made transition -
            NEW In Analysis
            1h 23m 1
            Prasanna Karlekar (Inactive) made transition -
            Closed In Analysis
            20s 1
            Prasanna Karlekar (Inactive) made transition -
            In Analysis Closed
            1d 10h 19m 2

              People

              Assignee:
              Raywill Raymond Williams (Inactive)
              Reporter:
              Raywill Raymond Williams (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

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