-
Type:
Enhancement
-
Status: Production Complete
-
Priority:
High
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: BenAdmin
-
Labels:None
-
Module:BenAdmin - EDS
-
Reported by:White Label
-
Company:Utah Valley University
-
Item State:Production Complete - Closed
-
Issue Importance:Must Have
-
Sprint:WT Sprint 18
We need to consider one special character for Dependent SSN. It can be either ^ or ~.
Let UHC know which character will be feasible. This requirement is for ACA files as well. They need to import dependents with special characters as SSN and after proper SSN is submitted all of these would be updated in system.
Note: - 1. Employee SSN (Add Employee, Demographics or through Import )would not be considering this special character.
2. Special character has to be considered on Spouse & child page.
3. It should also be allowed on Beneficiary page.
We need to make sure that all modules in the system works correct with this special character. It would need to implement in Import (demographics and ACA import) as well.
Swapnil Pandhare: Can we please share feasible character with UHC at first.
Nandkumar Prabhakar Karlekar Jaideep Vinchurkar Rakesh Roy Vijay Siddha Samir
Ok Swapnil, please share list of characters which can be allowed for Dependent SSN, we would get it confirmed with UHC first then we will start working on this change request.
For Dependent SSN we cannot consider special characters ^ and ~ .
These special characters are used as data wipeout in Import and as a string concatenating character in EDS module.So using them could cause errors.
We can use one of below special characters:
- ,*,%,!,<,>
We are considering below formats for SSN :
1)123456789 or ######### ( 9 digits or 9 special characters).
2)12345#### (5 digits and 4 special charaters ).
3)#####1234 ( 5 special characters and 4 digits).
Please let us know the format of SSN for Child ,Spouse and Beneficiary we are considering is fine or some other format is required .
| Remaining Estimate | 21h [ 75600 ] | |
| Original Estimate | 21h [ 75600 ] |
| Remaining Estimate | 21h [ 75600 ] | 16h [ 57600 ] |
| Time Spent | 5h [ 18000 ] | |
| Worklog Id | 10225 [ 10225 ] |
| Item State | Parent values: Development(10200)Level 1 values: Development Backlog(10205) | Parent values: Development(10200)Level 1 values: In Analysis(10204) |
| Status | New Request [ 10029 ] | Pending for Approval [ 10002 ] |
| Status | Pending for Approval [ 10002 ] | Approved for Development [ 10003 ] |
Hi Swapnil Pandhare & Chaitali Acharya,
I confirmed with UHC for special characters of Dependent SSN. They are fine with asterisk character *
On Dependents SSN (UI & Import) it should be allowed along with Beneficiary. On confirmation statement when there is * in database we can ignore it and display Null character symbol (---).
Let's schedule this enhancement on priority after WT-6447. UHC will continue using ^ symbol in address line 2 as it is not creating any issues with them as of now.
Rakesh Roy: We should start with test cases for including special characters.
Regards,
Satya Prakash
Nandkumar Prabhakar Karlekar: Can we check if there will be any changes required on ACA for this change?
Cc: shyam sharma Samir Vijay Siddha Sachin Hingole Jaideep Vinchurkar
| Assignee | Swapnil Pandhare [ swapnil.pandhare ] | Chaitali Acharya [ chaitali.acharya ] |
| QA | Priya Dhamande [ priya.dhamande ] |
| Attachment | Queries for WT-6478.doc [ 33223 ] |
Hi Satya
Based on Design Team Meeting Discussion we have certain queries mentioned in below document.
Queries for WT-6478.doc
.
Please let us know further details on this.
CC:Swapnil Pandhare Sheetal Bodhale
Thanks,
Chaitali
| Sprint | WT Sprint 17 [ 32 ] |
| Rank | Ranked lower |
| Original Estimate | 21h [ 75600 ] | 16h [ 57600 ] |
| Original Estimate | 16h [ 57600 ] | 0h [ 0 ] |
| Remaining Estimate | 16h [ 57600 ] | 0h [ 0 ] |
Hi shyam sharma
This is Pending due to UHC Call.
CC:Satya Swapnil Pandhare Sheetal Bodhale
Thanks,
Chaitali
| Attachment | Queries for WT-6478 - Design Team Meeting.doc [ 33538 ] |
Hi Satya
Based on Design Team Meeting Discussion we have certain queries mentioned in below document.
Queries for WT-6478 - Design Team Meeting.doc
Please let us know further details on this.
CC:Swapnil Pandhare Sheetal Bodhale
Thanks,
Chaitali Acharya
| Sprint | WT Sprint 17 [ 32 ] | WT Sprint 18 [ 34 ] |
| Developer | Chaitali Acharya [ chaitali.acharya ] |
Hi Chaitali Acharya,
Can you please share the analysis document for the enhancement, this will help us in test cases writing, impact on Export / Import and testing scope.
Thanks,
Priya
| Time Spent | 5h [ 18000 ] | 7h [ 25200 ] |
| Worklog Id | 11578 [ 11578 ] |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: Development(10200)Level 1 values: In Progress(10206) |
| Status | Approved for Development [ 10003 ] | In Development [ 10007 ] |
| Time Spent | 7h [ 25200 ] | 12h [ 43200 ] |
| Worklog Id | 11763 [ 11763 ] |
| Dev Due Date | 13/Dec/2016 |
| Production Due Date | 19/Dec/2016 | |
| Stage Due Date | 15/Dec/16 [ 2016-12-15 ] |
| Dev Estimates | 32 |
Sheetal Bodhale (Inactive)
logged work - 07/Dec/16 12:18 PM -
- Time Spent:
- 0.5h
-
discussion with chaitali and satya on change.
Sheetal Bodhale (Inactive)
made changes -
| Time Spent | 12h [ 43200 ] | 12.5h [ 45000 ] |
| Worklog Id | 11926 [ 11926 ] |
| Original Estimate | 0h [ 0 ] | 32h [ 115200 ] |
| Time Spent | 12.5h [ 45000 ] | 18.5h [ 66600 ] |
| Worklog Id | 11974 [ 11974 ] |
| Remaining Estimate | 0h [ 0 ] | 32h [ 115200 ] |
| Remaining Estimate | 32h [ 115200 ] | 28h [ 100800 ] |
| Time Spent | 18.5h [ 66600 ] | 22.5h [ 81000 ] |
| Worklog Id | 12147 [ 12147 ] |
| Remaining Estimate | 28h [ 100800 ] | 21h [ 75600 ] |
| Time Spent | 22.5h [ 81000 ] | 29.5h [ 106200 ] |
| Worklog Id | 12593 [ 12593 ] |
| Attachment | TestCases_SpecialCharaterForSSN.xls [ 34953 ] |
| Attachment | TestCases_SpecialCharaterForSSN.xls [ 34957 ] |
| Attachment | TestCases_SpecialCharaterForSSN.xls [ 34953 ] |
Sheetal Bodhale (Inactive)
logged work - 13/Dec/16 09:24 AM -
- Time Spent:
- 0.5h
-
internal discussion and code review
Sheetal Bodhale (Inactive)
made changes -
| Remaining Estimate | 21h [ 75600 ] | 20.5h [ 73800 ] |
| Time Spent | 29.5h [ 106200 ] | 30h [ 108000 ] |
| Worklog Id | 12702 [ 12702 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
| Assignee | Chaitali Acharya [ chaitali.acharya ] | Priya Dhamande [ priya.dhamande ] |
Please thoroughly verify the enhancement.
1)Partner login
2)Company Admin Login
3)Employee Login(with without workflow)
with and without mandatory fields.
change the rights of the fields on spouse and child and check in workflow also without workflow.
As per discussion with Satya ,if Child ,Spouse SSN is mandatory and we enter *,it will be saved as null in database and bypass the SSN mandatory check on click of Continue button in workflow.
CC:Sheetal Bodhale Swapnil Pandhare
Thanks,
Chaitali Acharya
| Remaining Estimate | 20.5h [ 73800 ] | 12.5h [ 45000 ] |
| Time Spent | 30h [ 108000 ] | 38h [ 136800 ] |
| Worklog Id | 12798 [ 12798 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Environment: LB
Company: Caiso and MBF
Login: Partner, Company Admin and Employee
Testing in-progress.
Scenarios Covered Today:
1. Partner:
- Spouse [Spouse, ExSpouse, DP]
- Child [Natural, Step, Disabled Child]
- Confirmation statement Under header Dependents Information - Three dash appeared
- Confirmation statement PDF - Three dash appeared
- Export - Blank appears in place of *
2. Company Admin: - Spouse [Spouse, ExSpouse, DP]
- Child [Natural, Step, Disabled Child]
- Confirmation statement Under header Dependents Information - Three dash appeared
- Confirmation statement PDF - Three dash appeared
- Export - Blank appears in place of *
3. Employee - Spouse [Spouse, ExSpouse, DP]
- Child [Natural, Step, Disabled Child]
- Confirmation statement Under header Dependents Information - Three dash appeared
- Confirmation statement PDF - Three dash appeared
Pending Scenarios: need to check on Reports for all above scenarios. Willbe completing the reaming scenarios tomorrow and will move jira for Stage.
| Original Estimate | 32h [ 115200 ] | 36h [ 129600 ] |
| Remaining Estimate | 12.5h [ 45000 ] | 8h [ 28800 ] |
| Time Spent | 38h [ 136800 ] | 42.5h [ 153000 ] |
| Worklog Id | 13107 [ 13107 ] |
Environment: LB
Company: Caiso and MBF
Login: Partner, Company Admin and Employee
The enhancement is verified on LB and it is working as expected. Scenarios covered are updated in above comments. These are checked by changing the rights for Employee and CA login.
For Impact we have checked on: Confirmation Statement PDF, Confirmation statement
Under header Dependents Information, Export and Reports [Dependent Census].
As mentioned scenarios worked well so moving jira on Stage.
| Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
| Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
| Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
| Remaining Estimate | 8h [ 28800 ] | 7h [ 25200 ] |
| Time Spent | 42.5h [ 153000 ] | 43.5h [ 156600 ] |
| Worklog Id | 13498 [ 13498 ] |
Khandu Kshirsagar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
| Remaining Estimate | 7h [ 25200 ] | 6.5h [ 23400 ] |
| Time Spent | 43.5h [ 156600 ] | 44h [ 158400 ] |
| Worklog Id | 13668 [ 13668 ] |
| Remaining Estimate | 6.5h [ 23400 ] | 5h [ 18000 ] |
| Time Spent | 44h [ 158400 ] | 45.5h [ 163800 ] |
| Worklog Id | 13670 [ 13670 ] |
| Status | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) |
| Status | Stage Testing [ 10201 ] | Pending for Production Approval [ 10301 ] |
| Status | Pending for Production Approval [ 10301 ] | Approved for production [ 10034 ] |
Environment: Stage
Company: Wheaton Franciscan Healthcare OE 2017 For HSPL
Login: Partner, Company Admin and Employee
Scenarios Covered:
1. Partner:
- Added Spouse [Spouse, ExSpouse, DP]
- Added Child [Natural, Step, Disabled Child]
- Verified on Confirmation statement Under header Dependents Information - Three dash appeared
- Verified on Confirmation statement PDF - Three dash appeared
- Export - Blank appears in place of *
2. Company Admin:
- Added Spouse [Spouse, ExSpouse, DP]
- Added Child [Natural, Step, Disabled Child]
- Verified on Confirmation statement Under header Dependents Information - Three dash appeared
- Verified on Confirmation statement PDF - Three dash appeared
- Export - Blank appears in place of *
3. Employee [verified by OE and New Hire Mode]
- Spouse [Spouse, ExSpouse, DP]
- Child [Natural, Step, Disabled Child]
- Confirmation statement Under header Dependents Information - Three dash appeared
- Confirmation statement PDF - Three dash appeared
We have checked Export, Report and Confirmation Statement for its Impact. As mentioned scenarios worked as expected moving jira on Production.
| Remaining Estimate | 5h [ 18000 ] | 2h [ 7200 ] |
| Time Spent | 45.5h [ 163800 ] | 48.5h [ 174600 ] |
| Worklog Id | 14236 [ 14236 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
| Item State | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) | Parent values: Production QA(10203)Level 1 values: On Hold(10219) |
| Item State | Parent values: Production QA(10203)Level 1 values: On Hold(10219) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
| Status | Approved for production [ 10034 ] | Production Testing [ 10202 ] |
| Status | Production Testing [ 10202 ] | Reopen in Production [ 10027 ] |
| Status | Reopen in Production [ 10027 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
| Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
| Status | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
| Status | Stage Testing [ 10201 ] | Pending for Production Approval [ 10301 ] |
| Status | Pending for Production Approval [ 10301 ] | Approved for production [ 10034 ] |
| Status | Approved for production [ 10034 ] | Production Testing [ 10202 ] |
Environment: Production
Company: Utah Valley University For HSPL
Login: Partner, Company Admin and Employee
Scenarios Covered:
1. Partner:
Added Spouse [Spouse, ExSpouse, DP]
Added Child [Natural, Step, Disabled Child]
Verified on Confirmation statement Under header Dependents Information - Three dash appeared
Verified on Confirmation statement PDF - Three dash appeared
Export - Blank appears in place of *
2. Company Admin:
Added Spouse [Spouse, ExSpouse, DP]
Added Child [Natural, Step, Disabled Child]
Verified on Confirmation statement Under header Dependents Information - Three dash appeared
Verified on Confirmation statement PDF - Three dash appeared
Export - Blank appears in place of *
3. Employee [verified by OE and New Hire Mode]
Spouse [Spouse, ExSpouse, DP]
Child [Natural, Step, Disabled Child]
Confirmation statement Under header Dependents Information - Three dash appeared
Confirmation statement PDF - Three dash appeared
We have checked Export, Report and Confirmation Statement for its Impact.
Pending:
As WT-6897 patch, Import dependent SSN didn't went to production cannot verify the Import dependent through Ui. So, will able to complete jira once the mentioned jira goes to production and is verified.
| Remaining Estimate | 2h [ 7200 ] | 0h [ 0 ] |
| Time Spent | 48.5h [ 174600 ] | 52h [ 187200 ] |
| Worklog Id | 14554 [ 14554 ] |
| Assignee | Priya Dhamande [ priya.dhamande ] | Meghana Kulkarni [ meghana.kulkarni ] |
| Assignee | Meghana Kulkarni [ meghana.kulkarni ] | Priya Dhamande [ priya.dhamande ] |
verified the import Spouse and Child SSN through UI. Blank appears even if the SSN is inserted as '*' so closing jira on Production.
Jennifer Leugers: Can you pleas confirm from your end and close the jira.
| Assignee | Priya Dhamande [ priya.dhamande ] | Jennifer Leugers [ jennifer.leugers ] |
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production QA(10203) |
| Item State | Parent values: Production QA(10203) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Time Spent | 52h [ 187200 ] | 52.5h [ 189000 ] |
| Worklog Id | 14923 [ 14923 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
4d 15h 52m | 1 |
|
6s | 1 |
|
13d 18h 5m | 1 |
|
5m 16s | 1 |
|
2s | 1 |
|
7d 19h 17m | 2 |
|
1d 1h 12m | 2 |
|
11s | 2 |
|
2d 19h 8m | 2 |
|
1d 7h 45m | 2 |
|
6s | 2 |
|
19h 49m | 2 |
|
1d 20h 54m | 1 |
CC : Sheetal Bodhale
Hi Satya
We are working on this and will update you by monday.
Thanks,
Swapnil P.