-
Type:
Support Activity
-
Status: Resolved
-
Priority:
Critical
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Support Task Type:Demo Company setup
-
Environment:Stage
-
Reported by:Harbinger
-
Module:BenAdmin - Report
-
- Time Spent:
- 0.75h
-
Discussion on Test data creation and document to maintain it.
-
- Time Spent:
- 2h
-
Plans,rates created and also mapped accordingly
| Field | Original Value | New Value |
|---|---|---|
| Remaining Estimate | 10h [ 36000 ] | 8h [ 28800 ] |
| Time Spent | 2h [ 7200 ] | |
| Worklog Id | 17823 [ 17823 ] |
| Remaining Estimate | 8h [ 28800 ] | 7h [ 25200 ] |
| Time Spent | 2h [ 7200 ] | 3h [ 10800 ] |
| Worklog Id | 17851 [ 17851 ] |
-
- Time Spent:
- 1h
-
Discussion and document go through for maintaining the data.
| Remaining Estimate | 7h [ 25200 ] | 6h [ 21600 ] |
| Time Spent | 3h [ 10800 ] | 4h [ 14400 ] |
| Worklog Id | 17959 [ 17959 ] |
| Remaining Estimate | 6h [ 21600 ] | 5.25h [ 18900 ] |
| Time Spent | 4h [ 14400 ] | 4.75h [ 17100 ] |
| Worklog Id | 17960 [ 17960 ] |
| Remaining Estimate | 5.25h [ 18900 ] | 4.75h [ 17100 ] |
| Time Spent | 4.75h [ 17100 ] | 5.25h [ 18900 ] |
| Worklog Id | 18343 [ 18343 ] |
-
- Time Spent:
- 0.75h
-
Discussion with QA for Employee data.
Discussion on structure to be be documented.
| Summary | Test data for Invoice Testing company on Stage | Test data for Invoice and Billing Testing company on Stage |
| Priority | Medium [ 3 ] | Highest [ 1 ] |
| Component/s | Exchange [ 10003 ] |
| Assignee | Venkatesh Pujari [ venkatesh.pujari ] | Prasanna Karlekar [ prasanna ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Remaining Estimate | 4.75h [ 17100 ] | 2.25h [ 8100 ] |
| Time Spent | 5.25h [ 18900 ] | 7.75h [ 27900 ] |
| Worklog Id | 18431 [ 18431 ] |
-
- Time Spent:
- 2.5h
-
Plan and Employee import file creation
-
- Time Spent:
- 6h
-
Maintain Employee Sheet and create employee import file
| Remaining Estimate | 2.25h [ 8100 ] | 0h [ 0 ] |
| Time Spent | 7.75h [ 27900 ] | 13.75h [ 49500 ] |
| Worklog Id | 18713 [ 18713 ] |
| Attachment | Employee Test Data.xls [ 37218 ] |
| Attachment | EmpImport.txt [ 37219 ] |
| Time Spent | 13.75h [ 49500 ] | 15.25h [ 54900 ] |
| Worklog Id | 19025 [ 19025 ] |
Jyoti Agrawal (Inactive)
logged work - 13/Jan/17 11:17 AM -
- Time Spent:
- 1.5h
-
Scenario discussion meeting
| Time Spent | 15.25h [ 54900 ] | 21.25h [ 76500 ] |
| Worklog Id | 19050 [ 19050 ] |
| Attachment | Employee Test Data.xls [ 37218 ] |
| Attachment | EmpImport.txt [ 37219 ] |
| Attachment | Employee Test Data.xls [ 37319 ] |
| Attachment | EmpImport_Billing.txt [ 37320 ] |
-
- Time Spent:
- 6h
-
Created new plan - rate for billing report and election for imported employee's
-
- Time Spent:
- 1.5h
-
Meeting on scenario discussion
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 21.25h [ 76500 ] | 22.75h [ 81900 ] |
| Worklog Id | 19723 [ 19723 ] |
| Time Spent | 22.75h [ 81900 ] | 24.25h [ 87300 ] |
| Worklog Id | 22304 [ 22304 ] |
-
- Time Spent:
- 1h
-
Plan addition for scenarios
| Time Spent | 24.25h [ 87300 ] | 25.25h [ 90900 ] |
| Worklog Id | 23273 [ 23273 ] |
-
- Time Spent:
- 1h
-
Added plans and employees
| Time Spent | 25.25h [ 90900 ] | 27.25h [ 98100 ] |
| Worklog Id | 23480 [ 23480 ] |
| Remaining Estimate | 0h [ 0 ] | 1h [ 3600 ] |
| Time Spent | 27.25h [ 98100 ] | 26.25h [ 94500 ] |
| Worklog Id | 23480 [ 23480 ] |
| Remaining Estimate | 1h [ 3600 ] | 0h [ 0 ] |
| Time Spent | 26.25h [ 94500 ] | 27.75h [ 99900 ] |
| Worklog Id | 23642 [ 23642 ] |
-
- Time Spent:
- 1h
-
Discussion for structure
| Time Spent | 27.75h [ 99900 ] | 28.75h [ 103500 ] |
| Worklog Id | 23737 [ 23737 ] |
-
- Time Spent:
- 2h
-
discussion
document explain
meeting with team and nandu
| Time Spent | 28.75h [ 103500 ] | 30.75h [ 110700 ] |
| Worklog Id | 23782 [ 23782 ] |
| Assignee | Prasanna Karlekar [ prasanna ] | Venkatesh Pujari [ venkatesh.pujari ] |
| Time Spent | 30.75h [ 110700 ] | 32.75h [ 117900 ] |
| Worklog Id | 23805 [ 23805 ] |
-
- Time Spent:
- 2h
-
Discussion on Invoice Audit company.
-
- Time Spent:
- 1.5h
-
Meeting and planning for test company
| Time Spent | 32.75h [ 117900 ] | 34.75h [ 125100 ] |
| Worklog Id | 24066 [ 24066 ] |
-
- Time Spent:
- 2h
-
discussion with Prasanna and venkatesh
ETA Provided
| Time Spent | 34.75h [ 125100 ] | 36.25h [ 130500 ] |
| Worklog Id | 24113 [ 24113 ] |
| Time Spent | 36.25h [ 130500 ] | 36.75h [ 132300 ] |
| Worklog Id | 24113 [ 24113 ] |
-
- Time Spent:
- 4h
-
Analysis and Discussion on Data structure
| Time Spent | 36.75h [ 132300 ] | 40.75h [ 146700 ] |
| Worklog Id | 24353 [ 24353 ] |
| Time Spent | 40.75h [ 146700 ] | 41h [ 147600 ] |
| Worklog Id | 18343 [ 18343 ] |
-
- Time Spent:
- 4h
-
Test scenarios for Ongoing elections
| Time Spent | 41h [ 147600 ] | 45h [ 162000 ] |
| Worklog Id | 24611 [ 24611 ] |
-
- Time Spent:
- 0.5h
-
Discussion on Test scenarios to be documented.
| Time Spent | 45h [ 162000 ] | 45.5h [ 163800 ] |
| Worklog Id | 24744 [ 24744 ] |
| Time Spent | 45.5h [ 163800 ] | 50.5h [ 181800 ] |
| Worklog Id | 24970 [ 24970 ] |
| Time Spent | 50.5h [ 181800 ] | 55.5h [ 199800 ] |
| Worklog Id | 25576 [ 25576 ] |
-
- Time Spent:
- 1h
-
Review of scenarios documented.
| Time Spent | 55.5h [ 199800 ] | 59.5h [ 214200 ] |
| Worklog Id | 25858 [ 25858 ] |
| Time Spent | 59.5h [ 214200 ] | 60.5h [ 217800 ] |
| Worklog Id | 25967 [ 25967 ] |
| Time Spent | 60.5h [ 217800 ] | 61h [ 219600 ] |
| Worklog Id | 25968 [ 25968 ] |
-
- Time Spent:
- 0.5h
-
Discussion on Life plan scenarios.
-
- Time Spent:
- 0.5h
-
Scenario review for Life plans
Hi Venkatesh Pujari,
Scenarios for Health and Life plans, Billing period policies seems to be fine and sufficient as of now.
We should start with customization for this on Test company.
Thank you!
cc: Sachin Hingole, Satya, Jyoti Agrawal
| Attachment | BCC.xls [ 41213 ] |
| Time Spent | 61h [ 219600 ] | 61.5h [ 221400 ] |
| Worklog Id | 28651 [ 28651 ] |
| Time Spent | 61.5h [ 221400 ] | 65.5h [ 235800 ] |
| Worklog Id | 28826 [ 28826 ] |
| Remaining Estimate | 0h [ 0 ] | 1h [ 3600 ] |
| Time Spent | 65.5h [ 235800 ] | 64.5h [ 232200 ] |
| Worklog Id | 28826 [ 28826 ] |
-
- Time Spent:
- 6h
-
Test data and issue logged
| Remaining Estimate | 1h [ 3600 ] | 0h [ 0 ] |
| Time Spent | 64.5h [ 232200 ] | 70.5h [ 253800 ] |
| Worklog Id | 29261 [ 29261 ] |
| Time Spent | 70.5h [ 253800 ] | 71h [ 255600 ] |
| Worklog Id | 29286 [ 29286 ] |
-
- Time Spent:
- 0.5h
-
Discussion on adjustments appearing due to Import of elections with termination date set.
| Time Spent | 71h [ 255600 ] | 75h [ 270000 ] |
| Worklog Id | 29458 [ 29458 ] |
| Attachment | BCC.xls [ 41213 ] |
| Attachment | BCC.xls [ 41621 ] |
| Attachment | Termination and Updation Query.sql [ 41622 ] |
Please could you review the queries (Termination and Updation Query.sql) which I have written for the Termination and updation of the classes,billed rate and self insured components. Also let me know if there are any changes needed in the queries.
Thanks,
Venkatesh
| Assignee | Venkatesh Pujari [ venkatesh.pujari ] | Prasanna Karlekar [ prasanna ] |
-
- Time Spent:
- 0.5h
-
Discussion on Data modification.
-
- Time Spent:
- 0.25h
-
Reviewed few queries
| Time Spent | 75h [ 270000 ] | 75.5h [ 271800 ] |
| Worklog Id | 31147 [ 31147 ] |
Hi Venkatesh Pujari,
Have reviewed the queries and they are correct.
Following needs to be added:
- For block "Terminating Elections of P19 to P22" we also need to add P18.
There is one suggestion, each test case in document BCC.xls, should have some unique name like TestCase1 / TC1 etc. Could review the queries related to class change and Billed Rate / Component cost update syntactically only as was not able to map them with scenarios in test case excel. Also, our test scenarios will increase as we progress. This will help us in identifying the exact scenario that got affected.
Please let me know your views on the same.
Thank you!
| Assignee | Prasanna Karlekar [ prasanna ] | Venkatesh Pujari [ venkatesh.pujari ] |
| Time Spent | 75.5h [ 271800 ] | 75.75h [ 272700 ] |
| Worklog Id | 32498 [ 32498 ] |
| Attachment | BCC.xls [ 41621 ] |
| Attachment | Termination and Updation Query.sql [ 41622 ] |
| Attachment | BCC.xls [ 43003 ] |
| Attachment | Termination and Updation Query.sql [ 43004 ] |
| Assignee | Venkatesh Pujari [ venkatesh.pujari ] | Prasanna Karlekar [ prasanna ] |
| Time Spent | 75.75h [ 272700 ] | 76.75h [ 276300 ] |
| Worklog Id | 33244 [ 33244 ] |
As per your comments above I have modified the scripts and also added Sr. no. to all the test cases. Please could you verify the updated Sheet and queries and let me know if this is fine.
Thanks,
Venkatesh
| Time Spent | 76.75h [ 276300 ] | 78.25h [ 281700 ] |
| Worklog Id | 34278 [ 34278 ] |
| Attachment | Family Rates Scenarios.xlsx [ 57653 ] |
Hi [~meghana joshi], Venkatesh Pujari, Jyoti Agrawal, Harshada Borole, [~parmeshwar.jumbade],
Have created scenarios related Family Rates in Test Company.
Expected output w.r.t. coverage is mentioned in output tab of Family Rates Scenarios.xlsx
.
Kindly do not change any details related to Employee / Plan / Rates mentioned in the attached excel.
Thank you!
cc: Satya
Harshada Borole (Inactive)
logged work - 10/Aug/17 07:01 AM -
- Time Spent:
- 0.5h
-
Discussion on Test scenario's for billing
Parmeshwar Jumbad (Inactive)
logged work - 10/Aug/17 04:13 PM -
- Time Spent:
- 0.5h
-
Discussion on Billing details scenarios and process need to be follow while Add data
-
- Time Spent:
- 1h
-
Preparation and Discussion - Billing test data creation for verification after any code fix
Harshada Borole (Inactive)
made changes -
| Time Spent | 78.25h [ 281700 ] | 78.75h [ 283500 ] |
| Worklog Id | 71011 [ 71011 ] |
Jyoti Agrawal (Inactive)
made changes -
| Time Spent | 78.75h [ 283500 ] | 79.25h [ 285300 ] |
| Worklog Id | 71202 [ 71202 ] |
Parmeshwar Jumbad (Inactive)
made changes -
| Time Spent | 79.25h [ 285300 ] | 79.75h [ 287100 ] |
| Worklog Id | 71336 [ 71336 ] |
Parmeshwar Jumbad (Inactive)
logged work - 11/Aug/17 04:21 PM -
- Time Spent:
- 0.5h
-
Discussion with Harshada about add employees
Try out import employee feature to import employees
Parmeshwar Jumbad (Inactive)
made changes -
| Time Spent | 79.75h [ 287100 ] | 80.25h [ 288900 ] |
| Worklog Id | 71337 [ 71337 ] |
-
- Time Spent:
- 0.25h
-
Go through of changes done for Billing Data
-
- Time Spent:
- 6h
-
Test case document.
Created Benefit plan,Rates,Subrate,Mapped rates with Plan.
Discussion
Harshada Borole (Inactive)
made changes -
| Time Spent | 80.25h [ 288900 ] | 86.25h [ 310500 ] |
| Worklog Id | 71619 [ 71619 ] |
Harshada Borole (Inactive)
made changes -
| Remaining Estimate | 0h [ 0 ] | 6h [ 21600 ] |
| Time Spent | 86.25h [ 310500 ] | 80.25h [ 288900 ] |
| Worklog Id | 71619 [ 71619 ] | |
| Worklog Time Spent | 6h [ 21600 ] |
Harshada Borole (Inactive)
made changes -
| Remaining Estimate | 6h [ 21600 ] | 0h [ 0 ] |
| Time Spent | 80.25h [ 288900 ] | 87.25h [ 314100 ] |
| Worklog Id | 71620 [ 71620 ] |
Harshada Borole (Inactive)
made changes -
| Remaining Estimate | 0h [ 0 ] | 1h [ 3600 ] |
| Time Spent | 87.25h [ 314100 ] | 86.25h [ 310500 ] |
| Worklog Id | 71620 [ 71620 ] |
Harshada Borole (Inactive)
made changes -
| Attachment | Billing Plan Scenarios.xls [ 58710 ] |
Hi,
Have created Scenario's for Billing in Test Company.Also created excel for employee but haven't added Employee's in Test Company.
Billing Plan Scenarios.xls
CC:Jyoti Agrawal, Prasanna Karlekar, [~parmeshwar.jumbade]
Harshada Borole (Inactive)
added a comment - Hi,
Have created Scenario's for Billing in Test Company.Also created excel for employee but haven't added Employee's in Test Company.
Billing Plan Scenarios.xls
CC: Jyoti Agrawal , Prasanna Karlekar , [~parmeshwar.jumbade] | Remaining Estimate | 1h [ 3600 ] | 0h [ 0 ] |
| Time Spent | 86.25h [ 310500 ] | 87.25h [ 314100 ] |
| Worklog Id | 72583 [ 72583 ] |
| Time Spent | 87.25h [ 314100 ] | 87.5h [ 315000 ] |
| Worklog Id | 72815 [ 72815 ] |
-
- Time Spent:
- 0.5h
-
Discussion on Test Company and its maintenance
| Time Spent | 87.5h [ 315000 ] | 88h [ 316800 ] |
| Worklog Id | 88269 [ 88269 ] |
| Environment_New | Stage [ 18443 ] |
| Summary | Test data for Invoice and Billing Testing company on Stage | Test data for Invoice and Billing Testing company |
| Time Spent | 88h [ 316800 ] | 89h [ 320400 ] |
| Worklog Id | 97169 [ 97169 ] |
Following was expected from this ticket:
1. Creation of test data for Invoice
2. Creation of test data for Billing
There is no approval to work on Invoice Test Data creation task.
Hence closing this JIRA.
Thank you!
| Resolution | Unresolved [ 10200 ] | |
| Status | In Progress [ 3 ] | Resolved [ 5 ] |
| Status | Resolved [ 5 ] | Closed [ 6 ] |
Reopening this issue.
We should work on completion of this company, as it will help us in following ways:
1. While doing any code fix in core logic it will ensure, that the changes done have not impacted existing implementation which was expected to remain intact.
2. Going forward, we have Edit Template enhancement in WT-7519 which has major core logic changes. Apart from this, we will also have many more Invoice related changes coming our way. Completion of this company, will help in saving the testing time and also boost our confidence related to existing scenarios being unaffected.
| Resolution | Unresolved [ 10200 ] | |
| Status | Closed [ 6 ] | Reopen [ 4 ] |
This appears to be a "process" recommendation rather than a support task. We need to discuss to categorize them better. CC Jennifer Reed Satya
| Attachment | Invoice_Scenarios_TestData.xlsx [ 72781 ] |
Following is the status update regarding Test Company:
Following is configured in this test company:
Classes
Payroll Schedules
Eligibility Rules
Rates (Health / Non Health / With and without self insured components)
Plans (Health / Non Health)
Rate - Plan mapping
Import template creations (Employee data / Dependent data / Election data)
Detailed scenarios are listed in Invoice_Scenarios_TestData.xlsx. Please refer same for adjustment scenarios.
Adjustments in first invoice:
- There will be only retro adds that will appear in first invoice
- Detailed listing and review of valid scenarios with expected output is complete
- Scenario wise employee and election import is complete
- Output for the first invoice can be validated using this company.
Adjustments appearing on invoices generated after first invoice(we are considering this as Second Invoice):
- Adjustments on invoices after first invoice can be only retro add/ only retro term / both retro add and term.
- High level scenarios are documented in tab "Second Invoice Scenarios" of attached excel.
- We could complete detailed listing and review of scenarios for points 1 and 5 mentioned in tab "Second Invoice Scenarios".
- We listed few scenarios for point 3 for which we have queries. We have already requested AE to validate the scenarios. After which, further listing can be done.
- Detailed listing of other points in tab "Second Invoice Scenarios" is pending.
- None of the scenarios related to second invoice are created in test company
We have not considered scenarios where multiple rate / subrate / self insured components are involved. Creating first invoice scenarios gave us little idea about how this company can be used in a way of automation testing.
Please note, that creating these scenarios is definitely a time taking activity, but will prove to be of great help if done and used regularly.
| Assignee | Prasanna Karlekar [ prasanna ] | Amruta Lohiya [ amruta.baheti ] |
Resolving it. Not setting resolution.
| Resolution | Unresolved [ 10200 ] | |
| Status | Reopen [ 4 ] | Resolved [ 5 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
4d 22h | 1 |
|
351d 3h 38m | 1 |
|
1m 42s | 1 |
|
17d 23h 34m | 1 |
|
21d 19h 38m | 1 |
Prasanna Karlekar,Alankar Chavan,[~meghana.kulkarni],Aditya Vishwakarma,surender kumar