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

Import | Dependent SSN can be imported with Special character '*' only

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Import
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Sprint:
      WT Sprint 18

      Description

      As per discussion with EDS team, user can also able to import dependent SSN with special character as * , if the 9 digit SSN is not available.

      The '*' should not be visible on its dependent page. The data base should save as null only, even if it is added as *.

        Attachments

          Issue Links

            Activity

            priya.dhamande Priya Dhamande (Inactive) created issue -
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Field Original Value New Value
            Link This issue relates to WT-6478 [ WT-6478 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Ankur Deshpande [ ankur.deshpande ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 07/Dec/16 02:37 PM
            • Time Spent:
              1h
               
              <No comment>
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Dev Estimates 10
            Developer Ankur Deshpande [ ankur.deshpande ]
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            QA Rashmita Dudhe [ rashmita.dudhe ]
            Sprint WT Sprint 18 [ 34 ]
            Remaining Estimate 10h [ 36000 ]
            Original Estimate 10h [ 36000 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Remaining Estimate 10h [ 36000 ] 9h [ 32400 ]
            Time Spent 1h [ 3600 ]
            Worklog Id 12024 [ 12024 ]
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 07/Dec/16 03:14 PM
            • Time Spent:
              3h
               
              <No comment>
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Remaining Estimate 9h [ 32400 ] 6h [ 21600 ]
            Time Spent 1h [ 3600 ] 4h [ 14400 ]
            Worklog Id 12039 [ 12039 ]
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 09/Dec/16 10:34 AM
            • Time Spent:
              2.5h
               
              <No comment>
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Remaining Estimate 6h [ 21600 ] 3.5h [ 12600 ]
            Time Spent 4h [ 14400 ] 6.5h [ 23400 ]
            Worklog Id 12307 [ 12307 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Code Review Date 09/Dec/2016
            Code Reviewed By Jaideep Vinchurkar [ 11908 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Ankur Deshpande [ ankur.deshpande ] Rashmita Dudhe [ rashmita.dudhe ]
            rakeshr Rakesh Roy (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Rashmita Dudhe [ rashmita.dudhe ] Meghana Kulkarni [ meghana.kulkarni ]
            Hide
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            This is implemented same way as it is on UI. This is only for dependents.

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - This is implemented same way as it is on UI. This is only for dependents.
            meghana.joshi Meghana Joshi (Inactive) made changes -
            Assignee Meghana Kulkarni [ meghana.kulkarni ] Priya Dhamande [ priya.dhamande ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            This jira is kept on Hold for testing till the related enhancement WT-6478 is completed. As we need to verify the change through UI as well. So, changing the Status accordingly.

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - This jira is kept on Hold for testing till the related enhancement WT-6478 is completed. As we need to verify the change through UI as well. So, changing the Status accordingly.
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment - - edited

            Environment: LB
            Company: Caiso and MBF
            Import Template:
            StarSSNImportForDependent_Child
            StarSSNImportForDependent_Spouse

            Scenarios Covered:
            Existing Employee: Added Spouse, ExSpouse
            Existing Employee: Added Child [Natural, Step], ExSpouse

            For all above scenario * was imported successfully and no * is appearing on Spouse and Child page as required.

            Need to check the Employee Template for SSN as *

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - - edited Environment: LB Company: Caiso and MBF Import Template: StarSSNImportForDependent_Child StarSSNImportForDependent_Spouse Scenarios Covered: Existing Employee: Added Spouse, ExSpouse Existing Employee: Added Child [Natural, Step] , ExSpouse For all above scenario * was imported successfully and no * is appearing on Spouse and Child page as required. Need to check the Employee Template for SSN as *
            priya.dhamande Priya Dhamande (Inactive) logged work - 14/Dec/16 01:07 PM - edited
            • Time Spent:
              2h
               
              <No comment>
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Original Estimate 10h [ 36000 ] 14h [ 50400 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Remaining Estimate 3.5h [ 12600 ] 0h [ 0 ]
            Time Spent 6.5h [ 23400 ] 10.5h [ 37800 ]
            Worklog Id 13100 [ 13100 ]
            ankur.deshpande Ankur Deshpande (Inactive) logged work - 14/Dec/16 01:35 PM
            • Time Spent:
              2h
               
              <No comment>
            ankur.deshpande Ankur Deshpande (Inactive) made changes -
            Time Spent 10.5h [ 37800 ] 12.5h [ 45000 ]
            Worklog Id 13120 [ 13120 ]
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Dev Due Date 09/Dec/2016
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Hide
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            Priya Dhamande, JUST FYI, this implementation is for Dependents only for employee we do not allow NULL SSN.

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Priya Dhamande , JUST FYI, this implementation is for Dependents only for employee we do not allow NULL SSN.
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            yes Jaideep Vinchurkar, for testing Impact I will be checking for employee as well.

            Ankur Deshpande
            This patch was already deployed 5 days back but in today's LB patch it went again.
            Any code changes we made on it?

            Please let me know, as I need to test again otherwise.

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - yes Jaideep Vinchurkar , for testing Impact I will be checking for employee as well. Ankur Deshpande This patch was already deployed 5 days back but in today's LB patch it went again. Any code changes we made on it? Please let me know, as I need to test again otherwise.
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            Environment: LB
            Company: MBF
            Import Template:
            StarSSNImportForDependent_Child
            StarSSNImportForDependent_Spouse

            The Import for '*' for dependent is verified on LB and it is imported for multiple and single input. Above mentioned scenarios worked well, so moving jira on Stage.

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - Environment: LB Company: MBF Import Template: StarSSNImportForDependent_Child StarSSNImportForDependent_Spouse The Import for '*' for dependent is verified on LB and it is imported for multiple and single input. Above mentioned scenarios worked well, so moving jira on Stage.
            priya.dhamande Priya Dhamande (Inactive) made changes -
            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)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            priya.dhamande Priya Dhamande (Inactive) logged work - 15/Dec/16 01:04 PM
            • Time Spent:
              0.5h
               
              <No comment>
            priya.dhamande Priya Dhamande (Inactive) logged work - 15/Dec/16 01:05 PM
            • Time Spent:
              0.5h
               
              <No comment>
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Time Spent 12.5h [ 45000 ] 13h [ 46800 ]
            Worklog Id 13496 [ 13496 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Time Spent 13h [ 46800 ] 13.5h [ 48600 ]
            Worklog Id 13497 [ 13497 ]
            khandu.kshirsagar 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)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 2h [ 7200 ]
            Time Spent 13.5h [ 48600 ] 11.5h [ 41400 ]
            Worklog Id 13100 [ 13100 ]
            priya.dhamande Priya Dhamande (Inactive) logged work - 16/Dec/16 01:11 PM
            • Time Spent:
              1.5h
               
              <No comment>
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Description As per discussion with EDI team, user can also able to import dependent SSN with special character as * , if the 9 digit SSN is not available.

            The '*' should not be visible on its dependent page. The data base should save as null only, even if it is added as *.
            As per discussion with EDS team, user can also able to import dependent SSN with special character as * , if the 9 digit SSN is not available.

            The '*' should not be visible on its dependent page. The data base should save as null only, even if it is added as *.
            priya.dhamande Priya Dhamande (Inactive) logged work - 19/Dec/16 11:57 AM
            • Time Spent:
              2h
               
              <No comment>
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            Environment: Stage
            Company: Wheaton Franciscan Healthcare OE 2017 For HSPL
            Import Template:
            StarSSNImportForDependent_Child
            StarSSNImportForDependent_Spouse

            The Demographics Import for '*' for dependent is verified on Stage and it is imported for multiple and single input. Above mentioned scenarios worked well, so moving jira on Production.

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - Environment: Stage Company: Wheaton Franciscan Healthcare OE 2017 For HSPL Import Template: StarSSNImportForDependent_Child StarSSNImportForDependent_Spouse The Demographics Import for '*' for dependent is verified on Stage and it is imported for multiple and single input. Above mentioned scenarios worked well, so moving jira on Production.
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Remaining Estimate 2h [ 7200 ] 0h [ 0 ]
            Time Spent 11.5h [ 41400 ] 13.5h [ 48600 ]
            Worklog Id 14222 [ 14222 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            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)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Time Spent 13.5h [ 48600 ] 15h [ 54000 ]
            Worklog Id 14404 [ 14404 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Production Testing [ 10202 ] Reopen in Production [ 10027 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Reopen in Production [ 10027 ] In Development [ 10007 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
            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)
            priya.dhamande Priya Dhamande (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)
            Hide
            priya.dhamande Priya Dhamande (Inactive) added a comment -

            Environment: Production
            Company: Wheaton Franciscan Healthcare OE 2017 For HSPL
            Import Template:
            StarSSNImportForDependent_Child
            StarSSNImportForDependent_Spouse

            The Demographics Import for '*' for dependent is verified on Production for Spouse and Child and it is imported for multiple and single input. So, closing jira on production.

            Show
            priya.dhamande Priya Dhamande (Inactive) added a comment - Environment: Production Company: Wheaton Franciscan Healthcare OE 2017 For HSPL Import Template: StarSSNImportForDependent_Child StarSSNImportForDependent_Spouse The Demographics Import for '*' for dependent is verified on Production for Spouse and Child and it is imported for multiple and single input. So, closing jira on production.
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production QA(10203)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Item State Parent values: Production QA(10203) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            priya.dhamande Priya Dhamande (Inactive) made changes -
            Time Spent 15h [ 54000 ] 16.5h [ 59400 ]
            Worklog Id 14884 [ 14884 ]
            priya.dhamande Priya Dhamande (Inactive) logged work - 22/Dec/16 05:31 PM
            • Time Spent:
              1.5h
               
              <No comment>
            Transition Time In Source Status Execution Times
            Jaideep Vinchurkar (Inactive) made transition -
            New Request Pending for Approval
            1d 4h 17m 1
            Jaideep Vinchurkar (Inactive) made transition -
            Pending for Approval Approved for Development
            1s 1
            Jaideep Vinchurkar (Inactive) made transition -
            Approved for Development In Development
            2s 1
            Priya Dhamande (Inactive) made transition -
            In Production Testing Reopen in Production
            5m 53s 1
            Priya Dhamande (Inactive) made transition -
            Reopen in Production In Development
            3s 1
            Priya Dhamande (Inactive) made transition -
            In Development In LB Testing
            3d 16h 31m 2
            Priya Dhamande (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            4d 3h 15m 2
            Priya Dhamande (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            5s 2
            Priya Dhamande (Inactive) made transition -
            Approved for Stage Stage Testing
            4d 1h 34m 2
            Priya Dhamande (Inactive) made transition -
            Stage Testing Pending for Production Approval
            14s 2
            Priya Dhamande (Inactive) made transition -
            Pending for Production Approval Approved for production
            4s 2
            Priya Dhamande (Inactive) made transition -
            Approved for production In Production Testing
            2d 17h 23m 2
            Priya Dhamande (Inactive) made transition -
            In Production Testing Production Complete
            8s 1
            Priya Dhamande (Inactive) made transition -
            Production Complete Closed
            2s 1

              People

              Assignee:
              priya.dhamande Priya Dhamande (Inactive)
              Reporter:
              priya.dhamande Priya Dhamande (Inactive)
              Developer:
              Ankur Deshpande (Inactive)
              QA:
              Rashmita Dudhe (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 14h Original Estimate - 14h
                  14h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 16.5h
                  16.5h