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

Rogers Cobra - need Enrollment COBRA Qualifying Event Name data transformed to carrier's values

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Environment:
      Production
    • Reported by:
      EDI
    • Company:
      Rogers Memorial Hospital
    • Module:
      BenAdmin - Export
    • Issue Importance:
      Must Have
    • Severity:
      Simple

      Description

      company: Rogers
      template: ROGERS_UMR COBRA
      sub-templates:
      Subscriber
      Spouse
      Child

      field: QUALIFYING EVENT CODE
      Position on File:15
      mapping: Enrollment COBRA Qualifying Event Name

        Attachments

        1. Cobra_Event_DTS.PNG
          Cobra_Event_DTS.PNG
          46 kB
        2. CobraEventBuilder.PNG
          CobraEventBuilder.PNG
          25 kB
        3. Config.PNG
          Config.PNG
          13 kB
        4. Default_CobraEventName.PNG
          Default_CobraEventName.PNG
          18 kB
        5. EventName.PNG
          EventName.PNG
          69 kB
        6. Field Mapping Definitions.xlsx
          50 kB
        7. NewCobraField.PNG
          NewCobraField.PNG
          97 kB
        8. screenshot-1.png
          screenshot-1.png
          4 kB
        9. screenshot-2.png
          screenshot-2.png
          17 kB

          Activity

          Rochelle.Thomas Rochelle Thomas created issue -
          Rochelle.Thomas Rochelle Thomas made changes -
          Field Original Value New Value
          Account Executive Amanda Hagan [ amanda.hagan ]
          EDI Analyst 1 Rochelle Thomas [ rochelle.thomas ]
          Hide
          Rochelle.Thomas Rochelle Thomas added a comment -

          Please data transform 'Enrollment COBRA Qualifying Event Name' to the numeric values below or let us know if there is another solution.
          Example, the field should contain 1,2,3 etc

          1 - Termination of Employment
          2 - Retirement
          3 – Medicare Entitlement
          4 – Death
          5 - Ceasing to be an eligible dependent
          6 - Reduced Hours
          8 - Divorce or Separation
          28 - Termination with Severance

          Amit ThorveVinayak KulkarniCindy Wibbing

          Show
          Rochelle.Thomas Rochelle Thomas added a comment - Please data transform 'Enrollment COBRA Qualifying Event Name' to the numeric values below or let us know if there is another solution. Example, the field should contain 1,2,3 etc 1 - Termination of Employment 2 - Retirement 3 – Medicare Entitlement 4 – Death 5 - Ceasing to be an eligible dependent 6 - Reduced Hours 8 - Divorce or Separation 28 - Termination with Severance Amit Thorve Vinayak Kulkarni Cindy Wibbing
          Rochelle.Thomas Rochelle Thomas made changes -
          Attachment screenshot-1.png [ 72011 ]
          Rochelle.Thomas Rochelle Thomas made changes -
          Link This issue relates to EDI-2887 [ EDI-2887 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Assignee Satya [ ID10004 ] Ganesh Sadawarte [ ganesh.sadawarte ]
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Kanchan Jalgaonkar

          Please check this, Thanks.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Kanchan Jalgaonkar Please check this, Thanks.
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Kanchan Jalgaonkar [ kanchan.jalgaonkar ]
          Hide
          kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) added a comment -

          Hi Vinayak Kulkarni ,

          I have added the config entries .

          Thanks ,
          Kanchan J

          CC-Prajakta Belhe

          Show
          kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) added a comment - Hi Vinayak Kulkarni , I have added the config entries . Thanks , Kanchan J CC- Prajakta Belhe
          kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
          Assignee Kanchan Jalgaonkar [ kanchan.jalgaonkar ] Vinayak Kulkarni [ vinayak.kulkarni ]
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Deploy config changes into production.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Deploy config changes into production.
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Rajendra Pawar [ rajendra.pawar ]
          rajendra.pawar Rajendra Pawar (Inactive) logged work - 19/Jan/18 09:15 AM
          • Time Spent:
            10m
             
            <No comment>
          Hide
          rajendra.pawar Rajendra Pawar (Inactive) added a comment -

          This is done. Kanchan Jalgaonkar, can you please check?

          Vinayak Kulkarni

          Show
          rajendra.pawar Rajendra Pawar (Inactive) added a comment - This is done. Kanchan Jalgaonkar , can you please check? Vinayak Kulkarni
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Remaining Estimate 8h [ 28800 ]
          Original Estimate 8h [ 28800 ]
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Remaining Estimate 8h [ 28800 ] 7h 50m [ 28200 ]
          Time Spent 10m [ 600 ]
          Worklog Id 101078 [ 101078 ]
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Assignee Rajendra Pawar [ rajendra.pawar ] Kanchan Jalgaonkar [ kanchan.jalgaonkar ]
          Hide
          kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) added a comment -

          Hi Rochelle Thomas ,

          We have made the changes , please verify at your end .

          Thanks.

          CC-Vinayak Kulkarni Rajendra Pawar

          Show
          kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) added a comment - Hi Rochelle Thomas , We have made the changes , please verify at your end . Thanks. CC- Vinayak Kulkarni Rajendra Pawar
          kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
          Assignee Kanchan Jalgaonkar [ kanchan.jalgaonkar ] Rochelle Thomas [ rochelle.thomas ]
          kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 19/Jan/18 10:20 AM
          • Time Spent:
            1h
             

            Adding config entries
            verifying the file

          kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
          Remaining Estimate 7h 50m [ 28200 ] 6h 50m [ 24600 ]
          Time Spent 10m [ 600 ] 1h 10m [ 4200 ]
          Worklog Id 101111 [ 101111 ]
          sumeet.kolge Sumeet.Kolge (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Open [ 1 ] Resolved [ 5 ]
          Hide
          Rochelle.Thomas Rochelle Thomas added a comment -

          Hi Kanchan Jalgaonkar,
          Thank you so much!! I tested and it looks good.
          Closing the ticket.

          Vinayak KulkarniAmanda Hagan

          Show
          Rochelle.Thomas Rochelle Thomas added a comment - Hi Kanchan Jalgaonkar , Thank you so much!! I tested and it looks good. Closing the ticket. Vinayak Kulkarni Amanda Hagan
          Rochelle.Thomas Rochelle Thomas made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Closed [ 6 ] Reopen [ 4 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Assignee Rochelle Thomas [ rochelle.thomas ] Vinayak Kulkarni [ vinayak.kulkarni ]
          Status Reopen [ 4 ] In Progress [ 3 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Attachment EventName.PNG [ 72109 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Attachment Config.PNG [ 72110 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Attachment Default_CobraEventName.PNG [ 72111 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Attachment NewCobraField.PNG [ 72112 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Attachment CobraEventBuilder.PNG [ 72113 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Attachment Cobra_Event_DTS.PNG [ 72114 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Attachment Field Mapping Definitions.xlsx [ 72115 ]
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Email from Abhay,

          EDI asked for data transformation of a field. It was done from the back-end. UI doesn't show that it is dt'ed. From the “support” point of view I wish to understand the details and whether this can be done by the user.
          · Do we have a list of fields that are dt enabled?
          · What makes a field eligible for dt, and what does it take to make it dt enabled (so that it shows up
          · What steps are taken from back-end to dt? Can it at least be shown in UI as dt’ed?

          Development comments:

          Below are details about this field and at the end will have answers to your questions.

          Here support work is done for a mapping field "Enrollment cobra qualifying event name", this field is used in cobra templates built using old approach i.e. template type Payroll data.

          This field is used to get cobra event name on file like Termination, Divorce etc. Values may differ for different companies as per requirement. So values are kept in configuration file as below

          If we don't have values in configuration file for a particular company then we have default set of values

          We updated configuration file to get values for Rogers company as per client requirement. However we are using "data transform" terminology wrongly, There is no relation of our regular data transformation with this support task.

          We do have alternative in which user can achieve this from screen by creating cobra template using new approach i.e. template type COBRA data, in this we have another field which pulls out reason

          This field points to event builder cobra reason, these events are part of setting up new cobra approach.

          Once we map this field, we get data transformation available in pop-up

          Below are answers to your questions

          #1 Do we have a list of fields that are dt enabled?

          Yes, this Field Mapping Definitions.xlsx tells whether field is DTS applicable or not in last column, also if we get any field in data transformation page then its a DTS applicable field.

          #2 What makes a field eligible for dt, and what does it take to make it dt enabled (so that it shows up

          if values are fixed set of values, We call it as meta-data, if its a meta-data then its DTS applicable.
          State, country & gender are examples of such fields.

          Also we have implemented/extended DTS feature to some of fields like Enrolled Plan name & classes, these have fixed set of values but values are defined by user, we call it as transactional meta-data, few such type of fields are DTS applicable and we can make such fields as DTS applicable field by doing some code change if we want.

          #3 What steps are taken from back-end to dt? As stated above, We have modified back-end config file.

          Can it at least be shown in UI as dt’ed? No.

          Let us know if you have any questions on this, Thanks.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Email from Abhay , EDI asked for data transformation of a field. It was done from the back-end. UI doesn't show that it is dt'ed. From the “support” point of view I wish to understand the details and whether this can be done by the user. · Do we have a list of fields that are dt enabled? · What makes a field eligible for dt, and what does it take to make it dt enabled (so that it shows up · What steps are taken from back-end to dt? Can it at least be shown in UI as dt’ed? Development comments: Below are details about this field and at the end will have answers to your questions. Here support work is done for a mapping field "Enrollment cobra qualifying event name", this field is used in cobra templates built using old approach i.e. template type Payroll data. This field is used to get cobra event name on file like Termination, Divorce etc. Values may differ for different companies as per requirement. So values are kept in configuration file as below If we don't have values in configuration file for a particular company then we have default set of values We updated configuration file to get values for Rogers company as per client requirement. However we are using "data transform" terminology wrongly, There is no relation of our regular data transformation with this support task. We do have alternative in which user can achieve this from screen by creating cobra template using new approach i.e. template type COBRA data, in this we have another field which pulls out reason This field points to event builder cobra reason, these events are part of setting up new cobra approach. Once we map this field, we get data transformation available in pop-up Below are answers to your questions #1 Do we have a list of fields that are dt enabled? Yes, this Field Mapping Definitions.xlsx tells whether field is DTS applicable or not in last column, also if we get any field in data transformation page then its a DTS applicable field. #2 What makes a field eligible for dt, and what does it take to make it dt enabled (so that it shows up if values are fixed set of values, We call it as meta-data, if its a meta-data then its DTS applicable. State, country & gender are examples of such fields. Also we have implemented/extended DTS feature to some of fields like Enrolled Plan name & classes, these have fixed set of values but values are defined by user, we call it as transactional meta-data, few such type of fields are DTS applicable and we can make such fields as DTS applicable field by doing some code change if we want. #3 What steps are taken from back-end to dt? As stated above, We have modified back-end config file. Can it at least be shown in UI as dt’ed? No. Let us know if you have any questions on this, Thanks.
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Abhay Patil [ abhay.patil ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          Hide
          abhay.patil Abhay Patil (Inactive) added a comment -

          Thanks a lot Vinayak Kulkarni!
          It appears that "Enrollment cobra qualifying event name" is directly read from the enrollment. They also appear to be a fixed set of values as seen in the default values below - and these are not defined by users (like plan names and classes). Therefore not clear why they are not treated as metadata and DTS enabled.

          Show
          abhay.patil Abhay Patil (Inactive) added a comment - Thanks a lot Vinayak Kulkarni ! It appears that "Enrollment cobra qualifying event name" is directly read from the enrollment. They also appear to be a fixed set of values as seen in the default values below - and these are not defined by users (like plan names and classes). Therefore not clear why they are not treated as metadata and DTS enabled.
          abhay.patil Abhay Patil (Inactive) made changes -
          Assignee Abhay Patil [ abhay.patil ] Vinayak Kulkarni [ vinayak.kulkarni ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Attachment screenshot-2.png [ 72294 ]
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Abhay,

          Our DTS information gets stored into specific database table and we can only show a field as DTS enabled if it has information stored into this table. below is snap of state DTS field

          On other hand, config files are stored outside of table and we can see them disconnected from application ( logic and databases) .

          We can make it DTS applicable by doing code changes, However we already have introduced new cobra approach which solves our purpose and is DTS applicable.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Abhay, Our DTS information gets stored into specific database table and we can only show a field as DTS enabled if it has information stored into this table. below is snap of state DTS field On other hand, config files are stored outside of table and we can see them disconnected from application ( logic and databases) . We can make it DTS applicable by doing code changes, However we already have introduced new cobra approach which solves our purpose and is DTS applicable.
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Abhay Patil [ abhay.patil ]
          abhay.patil Abhay Patil (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Sumeet.Kolge (Inactive) made transition -
          Open Resolved
          11h 58m 1
          Vinayak Kulkarni (Inactive) made transition -
          Closed Reopen
          2d 18h 11m 1
          Vinayak Kulkarni (Inactive) made transition -
          Reopen In Progress
          4s 1
          Vinayak Kulkarni (Inactive) made transition -
          In Progress Resolved
          1h 1m 1
          Abhay Patil (Inactive) made transition -
          Resolved Closed
          2d 20h 54m 2

            People

            Assignee:
            abhay.patil Abhay Patil (Inactive)
            Reporter:
            Rochelle.Thomas Rochelle Thomas
            Account Executive:
            Amanda Hagan (Inactive)
            EDI Analyst 1:
            Rochelle Thomas
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 8h
                8h
                Remaining:
                Time Spent - 1h 10m Remaining Estimate - 6h 50m
                6h 50m
                Logged:
                Time Spent - 1h 10m Remaining Estimate - 6h 50m
                1h 10m