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

          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
          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.
          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
          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.
          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
          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
          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
          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.
          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.
          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.

            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