WORKTERRAProject Type: software

WORKTERRA

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

BCC Invoice Management - Rate Matrix Changes

    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:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 14

      Description

      1. Validation of costs on Rate Matrix (Monthly Cost = Total of Billable SI Component cost)
      2. Implementation to track cost changes for Billed Rate in Rate Matrix
      3. Implementation to track cost changes for Self Insured Component in Rate Matrix

        Attachments

          Issue Links

          is blocked by

          Bug - A problem which impairs or prevents the functions of the product. WT-7195 BCC Invoice Management - Rate Matrix Changes scenarios not working as expected.

          • Medium - Has the potential to affect progress.
          • Closed
          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-3862 BCC - Client Bill Upload Functionality

          • High - Serious problem that could block progress.
          • Closed

          Enhancement - An improvement or enhancement to an existing feature or task. WT-5027 BCC Invoice Management - Rate Matrix Changes for Self Insured Component (Analysis)

          • Medium - Has the potential to affect progress.
          • Production Complete

            Activity

            Ascending order - Click to sort in descending order
            prasanna Prasanna Karlekar (Inactive) created issue -
            shyam.sharma shyam sharma (Inactive) made changes -
            Field Original Value New Value
            Assignee Vijay Siddha [ vijays ] Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Description 1. Validation of costs (Monthly Cost = Total of Billable SI Component cost)
            1. Track cost changes for Billed Rate in Rate Matrix
            2. Track cost changes for Self Insured Component in Rate Matrix
            prasanna Prasanna Karlekar (Inactive) made changes -
            Description 1. Validation of costs (Monthly Cost = Total of Billable SI Component cost)
            1. Track cost changes for Billed Rate in Rate Matrix
            2. Track cost changes for Self Insured Component in Rate Matrix             		1. Validation of costs (Monthly Cost = Total of Billable SI Component cost)
            2. Track cost changes for Billed Rate in Rate Matrix ( New Table for Billed Rate Manipulation)
            3. Track cost changes for Self Insured Component in Rate Matrix (New Table for Self Insured Component Manipulation)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Description 1. Validation of costs (Monthly Cost = Total of Billable SI Component cost)
            2. Track cost changes for Billed Rate in Rate Matrix ( New Table for Billed Rate Manipulation)
            3. Track cost changes for Self Insured Component in Rate Matrix (New Table for Self Insured Component Manipulation)             		1. Validation of costs on Rate Matrix (Monthly Cost = Total of Billable SI Component cost)
            2. Implementation to track cost changes for Billed Rate in Rate Matrix
            3. Implementation to track cost changes for Self Insured Component in Rate Matrix
            prasanna Prasanna Karlekar (Inactive) made changes -
            Summary BCC Invoice Management - Enrollment BCC Invoice Management - Rate Matrix Changes
            shyam.sharma shyam sharma (Inactive) made changes -
            Sprint WT Sprint 14 [ 29 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Rank Ranked higher
            shyam.sharma shyam sharma (Inactive) made changes -
            Developer Prasanna Karlekar [ prasanna ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Dev Due Date 27/Oct/2016
            Dev Estimates 54
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            shyam.sharma shyam sharma (Inactive) made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Report(10109)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue relates to WT-5027 [ WT-5027 ]
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Analysis done in this ticket.

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Analysis done in this ticket.
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Following deployed on LB:
            1. Validation of costs on Rate Matrix (Monthly Cost = Total of Billable SI Component cost)
            2. Implementation to track cost changes for Billed Rate in Rate Matrix

            Following is pending:
            3. Implementation to track cost changes for Self Insured Component in Rate Matrix
            4. Need to track changes for Billed Rate and Self Insured component when Rates date gets extended.
            5. Cost or date changes done in same month.

            Please note, that as of now records can be verified from backed only.

            cc: shyam sharma, Rakesh Roy

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Following deployed on LB: 1. Validation of costs on Rate Matrix (Monthly Cost = Total of Billable SI Component cost) 2. Implementation to track cost changes for Billed Rate in Rate Matrix Following is pending: 3. Implementation to track cost changes for Self Insured Component in Rate Matrix 4. Need to track changes for Billed Rate and Self Insured component when Rates date gets extended. 5. Cost or date changes done in same month. Please note, that as of now records can be verified from backed only. cc: shyam sharma , Rakesh Roy
            prasanna Prasanna Karlekar (Inactive) made changes -
            Attachment Rate Matrix Analysis and Scenarios.xls [ 31442 ]
            Hide
            Permalink
            shyam.sharma shyam sharma (Inactive) added a comment -

            Prasanna Karlekar : can you please update Jira with current progress as this task is from sprint 14
            is this done or still things are pending for this ticket ?

            Show
            shyam.sharma shyam sharma (Inactive) added a comment - Prasanna Karlekar : can you please update Jira with current progress as this task is from sprint 14 is this done or still things are pending for this ticket ?
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            From pending points following is completed:
            3. Implementation to track cost changes for Self Insured Component in Rate Matrix
            4. Need to track changes for Billed Rate and Self Insured component when Rates date gets extended.
            5. Cost or date changes done in same month.

            Following is Pending:

            • Billable to Non Billable and Non Billable to Billable
            • Code Review
            • Functionality Review
            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - From pending points following is completed: 3. Implementation to track cost changes for Self Insured Component in Rate Matrix 4. Need to track changes for Billed Rate and Self Insured component when Rates date gets extended. 5. Cost or date changes done in same month. Following is Pending: Billable to Non Billable and Non Billable to Billable Code Review Functionality Review
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Surender Kumar [ surender.kumar ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Attachment Rate Matrix Analysis and Scenarios.xls [ 31442 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Attachment Rate Matrix Analysis and Scenarios.xls [ 32708 ]
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Hi Alankar Chavan,

            We are done with this development.
            Please find updated document of Rate Matrix scenarios.
            Impact of this changes can be verified from backend or can be seen from Invoice Management Screen.
            From screen, changes can be seen for Billing section as of now.

            cc: Rakesh Roy, shyam sharma

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Hi Alankar Chavan , We are done with this development. Please find updated document of Rate Matrix scenarios. Impact of this changes can be verified from backend or can be seen from Invoice Management Screen. From screen, changes can be seen for Billing section as of now. cc: Rakesh Roy , shyam sharma
            prasanna Prasanna Karlekar (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Hide
            Permalink
            prasanna Prasanna Karlekar (Inactive) added a comment -

            Scenarios for Rate Matrix changes discussed with Design Team.
            Document for Rate Matrix changes reviewed from Lalit.
            Have reviewed the code developed by Surender.

            cc: Lalit Kumar, shyam sharma, Rakesh Roy

            Show
            prasanna Prasanna Karlekar (Inactive) added a comment - Scenarios for Rate Matrix changes discussed with Design Team. Document for Rate Matrix changes reviewed from Lalit. Have reviewed the code developed by Surender. cc: Lalit Kumar , shyam sharma , Rakesh Roy
            prasanna Prasanna Karlekar (Inactive) made changes -
            Code Reviewed By Prasanna Karlekar [ 11907 ]
            surender.kumar surender kumar (Inactive) made changes -
            Assignee Surender Kumar [ surender.kumar ] Alankar Chavan [ alankar.chavan ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            prasanna Prasanna Karlekar (Inactive) made changes -
            Link This issue relates to WT-3862 [ WT-3862 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            alankar.chavan Alankar Chavan (Inactive) made changes -
            Assignee Alankar Chavan [ alankar.chavan ] Venkatesh Pujari [ venkatesh.pujari ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 15/Dec/16 12:08 PM
            • Time Spent:
              5h
               

              Self Insured scenarios verified on Production.

            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Remaining Estimate 10h [ 36000 ]
            Original Estimate 10h [ 36000 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Remaining Estimate 10h [ 36000 ] 5h [ 18000 ]
            Time Spent 5h [ 18000 ]
            Worklog Id 13410 [ 13410 ]
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 15/Dec/16 12:58 PM
            • Time Spent:
              1h
               
              <No comment>
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Remaining Estimate 5h [ 18000 ] 4h [ 14400 ]
            Time Spent 5h [ 18000 ] 6h [ 21600 ]
            Worklog Id 13490 [ 13490 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Link This issue is blocked by WT-7195 [ WT-7195 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production QA(10203)Level 1 values: Re-open(10220)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Production Testing [ 10202 ] Reopen in Production [ 10027 ]
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi surender kumar,

            Please could you assign this ticket to me once the trigger related scenarios are fixed.

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi surender kumar , Please could you assign this ticket to me once the trigger related scenarios are fixed. Thanks, Venkatesh
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Surender Kumar [ surender.kumar ]
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 16/Dec/16 09:35 AM
            • Time Spent:
              5h
               
              <No comment>
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Remaining Estimate 4h [ 14400 ] 0h [ 0 ]
            Time Spent 6h [ 21600 ] 11h [ 39600 ]
            Worklog Id 13913 [ 13913 ]
            Permalink
            surender.kumar surender kumar (Inactive) logged work - 16/Dec/16 10:00 AM - edited
            • Time Spent:
              3h
               
              • Analysis
              • Discussion
              • Testing for different test cases
            surender.kumar surender kumar (Inactive) made changes -
            Time Spent 11h [ 39600 ] 14h [ 50400 ]
            Worklog Id 14039 [ 14039 ]
            surender.kumar surender kumar (Inactive) made changes -
            Worklog Id 14039 [ 14039 ]
            Permalink
            surender.kumar surender kumar (Inactive) logged work - 19/Dec/16 01:20 PM
            • Time Spent:
              3h
               
              • Analysis
              • Discussion
            surender.kumar surender kumar (Inactive) made changes -
            Time Spent 14h [ 50400 ] 17h [ 61200 ]
            Worklog Id 14293 [ 14293 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 19/Dec/16 08:28 PM
            • Time Spent:
              0.75h
               

              Discussion on retro changes that needs to be handled in Triggers for Rate Matrix.

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 17h [ 61200 ] 17.75h [ 63900 ]
            Worklog Id 14422 [ 14422 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 24/Dec/16 11:30 PM
            • Time Spent:
              1h
               

              Rate Matrix changes in case of term date extend and shrink.

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 17.75h [ 63900 ] 18.75h [ 67500 ]
            Worklog Id 15513 [ 15513 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 26/Dec/16 02:18 PM
            • Time Spent:
              1h
               

              Discussion on extend and shrink scenarios and implementation details for Rates.

            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 18.75h [ 67500 ] 19.75h [ 71100 ]
            Worklog Id 15600 [ 15600 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 19.75h [ 71100 ] 20.5h [ 73800 ]
            Worklog Id 15809 [ 15809 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Worklog Id 15809 [ 15809 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 28/Dec/16 02:00 AM - edited
            • Time Spent:
              0.75h
               

              Discussion and review of changes done.

            Permalink
            surender.kumar surender kumar (Inactive) logged work - 25/Jan/17 12:37 PM
            • Time Spent:
              4h
               

              Analysis
              Coding
              Testing

            surender.kumar surender kumar (Inactive) made changes -
            Time Spent 20.5h [ 73800 ] 24.5h [ 88200 ]
            Worklog Id 21053 [ 21053 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee surender kumar [ surender.kumar ] Prasanna Karlekar [ prasanna ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Re-open(10220) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Reopen in Production [ 10027 ] In Development [ 10007 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Resolution Done [ 10000 ] Fixed [ 1 ]
            Status Production Complete [ 10028 ] Closed [ 6 ]
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            We are closing this ticket as all the linked JIRA tickets have been fixed.

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - We are closing this ticket as all the linked JIRA tickets have been fixed.
            Transition Time In Source Status Execution Times
            Prasanna Karlekar (Inactive) made transition -
            New Request Pending for Approval
            		18d 20h 12m 1
            Prasanna Karlekar (Inactive) made transition -
            Pending for Approval Approved for Development
            		3s 1
            Prasanna Karlekar (Inactive) made transition -
            Approved for Development In Development
            		2s 1
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Reopen in Production
            		3d 2h 14m 1
            Venkatesh Pujari (Inactive) made transition -
            Reopen in Production In Development
            		403d 21h 18m 1
            Venkatesh Pujari (Inactive) made transition -
            In Development In LB Testing
            		36d 4h 51m 2
            Venkatesh Pujari (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            		5d 7h 25m 2
            Venkatesh Pujari (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            		5s 2
            Venkatesh Pujari (Inactive) made transition -
            Approved for Stage Stage Testing
            		5s 2
            Venkatesh Pujari (Inactive) made transition -
            Stage Testing Pending for Production Approval
            		20d 12h 45m 2
            Venkatesh Pujari (Inactive) made transition -
            Pending for Production Approval Approved for production
            		5s 2
            Venkatesh Pujari (Inactive) made transition -
            Approved for production In Production Testing
            		4s 2
            Venkatesh Pujari (Inactive) made transition -
            In Production Testing Production Complete
            		12s 1
            Venkatesh Pujari (Inactive) made transition -
            Production Complete Closed
            		4s 1

              People

              Assignee:
              prasanna Prasanna Karlekar (Inactive)
              Reporter:
              prasanna Prasanna Karlekar (Inactive)
              Developer:
              Prasanna Karlekar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 10h Original Estimate - 10h
                  10h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 24.5h
                  24.5h