Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Report
    • Reported by:
      Support
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have 25
    • Sprint:
      WT Sprint 3, WT Sprint 5

      Description

      if employees status is COBRA then Employee COBRA flag will be Yes else it will be No.
      We have to take this item as well in development.

      Also need development to provide following fields on Billing report column wise at plan design level

      1. Provider Name - already there but need to show at plan design level
      2. Provider Type - already there but need to show at plan design level
      3. Provider Group Number - new addition
      4. Provider Group Number Suffix - new addition

        Attachments

          Issue Links

            Activity

            Hide
            amnesh.goel Amnesh Goel (Inactive) added a comment -

            Hi Deepali Tidke,

            This is one of the priority item from BCC and it should make to production on or before 5/17. We will give it to QA either today or by max tomorrow first half. Please plan QA of this item.

            Rakesh Roy Satya

            Thanks,
            Amnesh Goel

            Show
            amnesh.goel Amnesh Goel (Inactive) added a comment - Hi Deepali Tidke , This is one of the priority item from BCC and it should make to production on or before 5/17. We will give it to QA either today or by max tomorrow first half. Please plan QA of this item. Rakesh Roy Satya Thanks, Amnesh Goel
            Hide
            alankar.chavan Alankar Chavan (Inactive) added a comment - - edited

            FYI Jyoti Agrawal Amnesh Goel Deepali Tidke Rakesh Roy

            This is tested on Stage

            Following scenarios are tested -

            • In the Standard Report - Billing one - total 5 fields have been exposed namely - Is COBRA, Provider Name - already there but need to show at plan design level, Provider Type - already there but need to show at plan design level, Provider Group Number - new addition & Provider Group Number Suffix - new addition
            • This has been tested with the normal as well as with the Display Column Report
            • Is COBRA field is No when employee's status is Non COBRA and it is Yes when employee's status is COBRA
            • NOTE - testing scope for this enhancement was limited to the above mentioned fields. Other fields / costs calculations have not been tested in the testing

            This is ready for Production

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - - edited FYI Jyoti Agrawal Amnesh Goel Deepali Tidke Rakesh Roy This is tested on Stage Following scenarios are tested - In the Standard Report - Billing one - total 5 fields have been exposed namely - Is COBRA, Provider Name - already there but need to show at plan design level, Provider Type - already there but need to show at plan design level, Provider Group Number - new addition & Provider Group Number Suffix - new addition This has been tested with the normal as well as with the Display Column Report Is COBRA field is No when employee's status is Non COBRA and it is Yes when employee's status is COBRA NOTE - testing scope for this enhancement was limited to the above mentioned fields. Other fields / costs calculations have not been tested in the testing This is ready for Production
            Hide
            alankar.chavan Alankar Chavan (Inactive) added a comment -

            Test cases are written at below path -

            Show
            alankar.chavan Alankar Chavan (Inactive) added a comment - Test cases are written at below path - http://10.0.2.110/testlink/login.php?note=logout Username - alankar and Password - alankarC Log in ->Test Specification Tab -> WT -> BCC Invoice File - Adding new columns in Billing Report
            Hide
            deepalit Deepali Tidke (Inactive) added a comment -

            checked all the scenarios on production >> working fine

            Show
            deepalit Deepali Tidke (Inactive) added a comment - checked all the scenarios on production >> working fine
            Hide
            deepalit Deepali Tidke (Inactive) added a comment - - edited

            Debbie Kulling This is completed on production as per the previous understanding, we have recently received few more changes for it and are working it , we will update you accordingly.

            Show
            deepalit Deepali Tidke (Inactive) added a comment - - edited Debbie Kulling This is completed on production as per the previous understanding, we have recently received few more changes for it and are working it , we will update you accordingly.
            Hide
            deepalit Deepali Tidke (Inactive) added a comment -

            as per discussion with Debbie Kulling few more changes will get implemented in this, hence assigning back to Amnesh

            Show
            deepalit Deepali Tidke (Inactive) added a comment - as per discussion with Debbie Kulling few more changes will get implemented in this, hence assigning back to Amnesh
            Hide
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

            Hi Debbie Kulling,

            We have completed development. Now we are doing unit testing and after successful completion will move it on stage on 06/06/2016
            Rakesh Roy Please plan to test it on 06/06/16.

            Thanks,
            Jyoti A

            Show
            jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Hi Debbie Kulling , We have completed development. Now we are doing unit testing and after successful completion will move it on stage on 06/06/2016 Rakesh Roy Please plan to test it on 06/06/16. Thanks, Jyoti A
            Hide
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - - edited

            Hi
            cc: Rakesh Roy, Satya
            Please test it on Stage environment with reference of attached Document Benefit-wise Billing Report_Demo_Only .doc [Benefit-wise Billing Report_Demo_Only.doc]

            Please test it on priority basis as It is going to be for Demo on 06/07/16.

            Thanks

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - - edited Hi cc: Rakesh Roy , Satya Please test it on Stage environment with reference of attached Document Benefit-wise Billing Report_Demo_Only .doc [Benefit-wise Billing Report_Demo_Only.doc] Please test it on priority basis as It is going to be for Demo on 06/07/16. Thanks
            Hide
            deepalit Deepali Tidke (Inactive) added a comment -

            Kindly start with this on priority

            Show
            deepalit Deepali Tidke (Inactive) added a comment - Kindly start with this on priority
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Hi Aditya Vishwakarma,

            As discussed with Aditya Vishwakarma and Jyoti Agrawal , I have verified report on Stage - TotalWork in following ways for demo purpose:

            1) Create new ' Benefit Wise Billing Details ' standard report . As of Now, user is able to preview report not able to Save.

            2) Create report by selecting 2-3 benefit type and any demographics fields like as :

            FirstName
            Last Name
            Plan Design name
            Employee PreTax
            Total Amount

            NOTE : 1) It is working only with Plan Design name, Employee PreTax ,Total Amount fields as mentioned in document
            2) Selecting more than 3 benefit type then report run but result never appears.

            3) Preview Report and Displayed report like as :


            NOTE : Currently, Report is running and format is verified [ Data not verified as it is for demo only ]

            Thanks & Regards,
            Meghana Kulkarni

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Hi Aditya Vishwakarma , As discussed with Aditya Vishwakarma and Jyoti Agrawal , I have verified report on Stage - TotalWork in following ways for demo purpose: 1) Create new ' Benefit Wise Billing Details ' standard report . As of Now, user is able to preview report not able to Save. 2) Create report by selecting 2-3 benefit type and any demographics fields like as : FirstName Last Name Plan Design name Employee PreTax Total Amount NOTE : 1) It is working only with Plan Design name, Employee PreTax ,Total Amount fields as mentioned in document 2) Selecting more than 3 benefit type then report run but result never appears. 3) Preview Report and Displayed report like as : NOTE : Currently, Report is running and format is verified [ Data not verified as it is for demo only ] Thanks & Regards, Meghana Kulkarni
            Hide
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment -

            Hello Debbie
            We have completed it on stage. can we discuss it on today's call?

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - Hello Debbie We have completed it on stage. can we discuss it on today's call?
            Hide
            shyam.sharma shyam sharma (Inactive) added a comment -

            Carry over this task in Sprint 5 as more changes suggested in yesterday's demo

            Show
            shyam.sharma shyam sharma (Inactive) added a comment - Carry over this task in Sprint 5 as more changes suggested in yesterday's demo
            Hide
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment -

            Hello Debbie
            Did you have a call Or Demo with BCC? Do they request for any changes as we wants to start all changes in one go including adding column of "Approved Coverage Amount" on Benefit wise report.

            For our Second part ie "Billing Report Provider-wise" we have created a Jira ticket WT-2925.

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - Hello Debbie Did you have a call Or Demo with BCC? Do they request for any changes as we wants to start all changes in one go including adding column of "Approved Coverage Amount" on Benefit wise report. For our Second part ie "Billing Report Provider-wise" we have created a Jira ticket WT-2925 .
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            Debbie Kulling Please update.
            Amit Gude

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Debbie Kulling Please update. Amit Gude
            Hide
            dkulling Debbie Kulling added a comment -

            There are two additional items we need to add to complete the "Benefitwise Billing Details"

            1. We need to have the ability to create a plan/rate that when set to "not viewable to employee" the employee does not see it anywhere including the confirmation statement.

            2. In the report customization create the ability to select the rate that should be included in the report.
            -when you select the plan the rates mapped to that plan should display and you should have the ability to select the specific rates.

            David Rhodes

            Show
            dkulling Debbie Kulling added a comment - There are two additional items we need to add to complete the "Benefitwise Billing Details" 1. We need to have the ability to create a plan/rate that when set to "not viewable to employee" the employee does not see it anywhere including the confirmation statement. 2. In the report customization create the ability to select the rate that should be included in the report. -when you select the plan the rates mapped to that plan should display and you should have the ability to select the specific rates. David Rhodes
            Hide
            shyam.sharma shyam sharma (Inactive) added a comment -

            Aditya Vishwakarma Amnesh Goel : Can you please look in to this ?

            Show
            shyam.sharma shyam sharma (Inactive) added a comment - Aditya Vishwakarma Amnesh Goel : Can you please look in to this ?
            Hide
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment -

            Hello Debbie Kulling

            We need to discuss the additional items you mentioned in previous thread on call.

            Amnesh Goel Will be sending you GTM invite for the call at 06/14/2016 8 AM PST

            Amit Gude , Jyoti Agrawal Please join the call.

            Thanks

            Show
            aditya.vishwakarma Aditya Vishwakarma (Inactive) added a comment - Hello Debbie Kulling We need to discuss the additional items you mentioned in previous thread on call. Amnesh Goel Will be sending you GTM invite for the call at 06/14/2016 8 AM PST Amit Gude , Jyoti Agrawal Please join the call. Thanks
            Hide
            dkulling Debbie Kulling added a comment -

            We have another way we would like to accomplish the "billed" rate please disregard 2. below and see revised request

            DISREGARD: 2. In the report customization create the ability to select the rate that should be included in the report.
            -when you select the plan the rates mapped to that plan should display and you should have the ability to select the specific rates.

            REVISED: Add a column to the rate table that represents the "Billed Rate" this rate would pull out on the billing details reports. You would be able to select this rate in the report configuration. The rate would not tie to any other rates in the rate table it would be a free form field much like the Imputed income field.

            David Rhodes

            Show
            dkulling Debbie Kulling added a comment - We have another way we would like to accomplish the "billed" rate please disregard 2. below and see revised request DISREGARD: 2. In the report customization create the ability to select the rate that should be included in the report. -when you select the plan the rates mapped to that plan should display and you should have the ability to select the specific rates. REVISED: Add a column to the rate table that represents the "Billed Rate" this rate would pull out on the billing details reports. You would be able to select this rate in the report configuration. The rate would not tie to any other rates in the rate table it would be a free form field much like the Imputed income field. David Rhodes
            Hide
            amnesh.goel Amnesh Goel (Inactive) added a comment -

            Hi Debbie Kulling,

            Per our last call (5/15) on it, we concluded that there is only following two items left in order to close this ticket.

            1. Add Approved Coverage option for non-health benefits. Remove Coverage Tier option for non-health benefits.
            2. Introduce a new column on Rate-Matrix to receive Billed Rate and for Health benefits consider this column instead of regular billing calculation.

            Point#2 above seems little tricky because for this we would need to understand whole Billing working starting from point where entry goes in Billing table, retro scenarios entry in billing table, retro calculations from billing table and Billing report functioning. We will analyze its feasibility and will let you know by today EOD 6/16 and if require team will speak to you on it.

            Thanks,
            Amnesh Goel

            Show
            amnesh.goel Amnesh Goel (Inactive) added a comment - Hi Debbie Kulling , Per our last call (5/15) on it, we concluded that there is only following two items left in order to close this ticket. Add Approved Coverage option for non-health benefits. Remove Coverage Tier option for non-health benefits. Introduce a new column on Rate-Matrix to receive Billed Rate and for Health benefits consider this column instead of regular billing calculation. Point#2 above seems little tricky because for this we would need to understand whole Billing working starting from point where entry goes in Billing table, retro scenarios entry in billing table, retro calculations from billing table and Billing report functioning. We will analyze its feasibility and will let you know by today EOD 6/16 and if require team will speak to you on it. Thanks, Amnesh Goel
            Hide
            shyam.sharma shyam sharma (Inactive) added a comment -

            Closing this ticket as now in order to implement BCC Invoice file related changes,we have created following two new tickets in JIRA

            1. WT-3054 : BCC Benefit-wise Billing Details - new suggestions 5/16
            2. WT-2925 : Billing Report Provider-wise

            Show
            shyam.sharma shyam sharma (Inactive) added a comment - Closing this ticket as now in order to implement BCC Invoice file related changes,we have created following two new tickets in JIRA 1. WT-3054 : BCC Benefit-wise Billing Details - new suggestions 5/16 2. WT-2925 : Billing Report Provider-wise
            Hide
            shyam.sharma shyam sharma (Inactive) added a comment -

            New ticket created for WT2131

            Show
            shyam.sharma shyam sharma (Inactive) added a comment - New ticket created for WT2131
            Hide
            shyam.sharma shyam sharma (Inactive) added a comment -

            New ticket created for WT-2131

            Show
            shyam.sharma shyam sharma (Inactive) added a comment - New ticket created for WT-2131

              People

              Assignee:
              jyoti.agrawal Jyoti Agrawal (Inactive)
              Reporter:
              deepalit Deepali Tidke (Inactive)
              Account Executive:
              Debbie Kulling
              Developer:
              Jyoti Agrawal (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date: