WORKTERRAProject Type: software

WORKTERRA

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

UND Mertiain 834 5010 N4 Segment

    Details

    • Type: Change Request
    • Status: Pending for Approval
    • Priority: Critical
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Export
    • Reported by:
      Support
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Development - On Hold
    • Issue Importance:
      Good To Have

      Description

      I wanted to see if this would be an option. Currently we have a mapping of Country but it is the long name, and not the code. We are seeing the carriers Requiring this field in some Specifications and would like to see about adding 2 other mappings.
      3 total including the existing:

      Employee Country(Currently in Workterra)
      Employee Country Code 2 (Would be a Proposed mapping with the 2-digit country Code)
      Employee Country Code 3 (Would be a Proposed mapping with the 3-digit country Code)

      I have lists I can provide. Currently we are going into the Data Transformation and changing the approx. 234 Countries to their respective codding for all 3 Coverage member tiers. is this possible?

        Attachments

          Issue Links

          clones

          Enhancement - An improvement or enhancement to an existing feature or task. WT-1452 Country Code Mapping

          • High - Serious problem that could block progress.
          • In Development

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            Damion.Velasquez Damion M Velasquez added a comment -

            The description carried over from the linked ticket. I am unable to Data Transform the N4 State or Country Code in the mapping. When I change it, and apply, it is showing as it is thinking and saves but the pop up(Meta Data window) down not close. When you save the Sub template for EE SP or Ch, and go back; changes are not there. This is making the file fail, and it takes a while to manually update the file as it has 12000+ records..

            The states now we need transformed until a permanent solution is there:
            District of Columbia Bogota should equal = DC
            Free State = FS
            Ho Chi Min Saigon = SG

            Country code South Africa = ZA

            Please assist thank you

            Show
            Damion.Velasquez Damion M Velasquez added a comment - The description carried over from the linked ticket. I am unable to Data Transform the N4 State or Country Code in the mapping. When I change it, and apply, it is showing as it is thinking and saves but the pop up(Meta Data window) down not close. When you save the Sub template for EE SP or Ch, and go back; changes are not there. This is making the file fail, and it takes a while to manually update the file as it has 12000+ records.. The states now we need transformed until a permanent solution is there: District of Columbia Bogota should equal = DC Free State = FS Ho Chi Min Saigon = SG Country code South Africa = ZA Please assist thank you
            Hide
            Permalink
            Damion.Velasquez Damion M Velasquez added a comment -

            Thank you

            CC Amit Thorve

            Show
            Damion.Velasquez Damion M Velasquez added a comment - Thank you CC Amit Thorve
            Hide
            Permalink
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Damion,

            We will update you on this by tomorrow EOD. Thanks.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Damion, We will update you on this by tomorrow EOD. Thanks.
            Hide
            Permalink
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Damion,

            This will take an week to complete, However it is not yet scheduled. Please let us know priority of this so that depending upon priority we can think of scheduling this in next sprint which is starting from 6th Nov 2017, Thanks.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Damion, This will take an week to complete, However it is not yet scheduled. Please let us know priority of this so that depending upon priority we can think of scheduling this in next sprint which is starting from 6th Nov 2017, Thanks.
            Hide
            Permalink
            Damion.Velasquez Damion M Velasquez added a comment -

            Hi Vinayak Kulkarni
            the enhancement can be pushed into the next spring but it was requested back in 2016, If it is in next sprint can someone from DEV help me: Im not able to get changes to save in the City or State code positions. It is a high priority due the the Client being UND; also this is a HIPPA File Failure so all records after this error will fail at the carrier.

            The states we need transformed NOW until a permanent solution final:
            District of Columbia Bogota should equal = DC
            Free State = FS
            Ho Chi Min Saigon = SG
            Country code South Africa = ZA

            I've done several variations. I go in and just change one, the window does not disappear, and when I save, then go back. Changes not made. File runs tomorrow so Ill need to know if I have to run and replace. This is very tedious because the volume of records..Thank you

            Show
            Damion.Velasquez Damion M Velasquez added a comment - Hi Vinayak Kulkarni the enhancement can be pushed into the next spring but it was requested back in 2016, If it is in next sprint can someone from DEV help me: Im not able to get changes to save in the City or State code positions. It is a high priority due the the Client being UND; also this is a HIPPA File Failure so all records after this error will fail at the carrier. The states we need transformed NOW until a permanent solution final: District of Columbia Bogota should equal = DC Free State = FS Ho Chi Min Saigon = SG Country code South Africa = ZA I've done several variations. I go in and just change one, the window does not disappear, and when I save, then go back. Changes not made. File runs tomorrow so Ill need to know if I have to run and replace. This is very tedious because the volume of records..Thank you
            Hide
            Permalink
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

            Hi Damion,

            We have updated given transformation.

            We just wanted to mention that you can update it from screen as well. Whenever you open transformation popup, do your changes and click on apply, you would feel that popup is not closing but wait for sometime until popup gets closed then save main page. Let us know if you have any questions on this.

            Show
            Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Damion, We have updated given transformation. We just wanted to mention that you can update it from screen as well. Whenever you open transformation popup, do your changes and click on apply, you would feel that popup is not closing but wait for sometime until popup gets closed then save main page. Let us know if you have any questions on this.
            Hide
            Permalink
            gaurav.sodani Gaurav Sodani (Inactive) added a comment -

            Hi Damion M Velasquez,

            We have frozen all enhancements until 2017 end

            It would be great if you could have a word internally and get us a development approval for this in order to take it forward

            Regards
            Gaurav

            Cc: Vinayak KulkarniSatyaAbhay Patil

            Show
            gaurav.sodani Gaurav Sodani (Inactive) added a comment - Hi Damion M Velasquez , We have frozen all enhancements until 2017 end It would be great if you could have a word internally and get us a development approval for this in order to take it forward Regards Gaurav Cc: Vinayak Kulkarni Satya Abhay Patil

              People

              Assignee:
              Vinayak.Kulkarni Vinayak Kulkarni (Inactive)
              Reporter:
              Damion.Velasquez Damion M Velasquez
              Account Executive:
              Damion M Velasquez
              Developer:
              Rajendra Pawar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - 60h
                  60h
                  Remaining:
                  Time Spent - 5h Remaining Estimate - 55h
                  55h
                  Logged:
                  Time Spent - 5h Remaining Estimate - 55h
                  5h