Uploaded image for project: 'Workterra BenAdmin'
  1. Workterra BenAdmin
  2. WB-664

San Luis Obispo - Column Header is not pulling correctly

    Details

    • Environment:
      Production
    • Categories:
      Platform
    • Company:
      County of San Luis Obispo
    • Reported by:
      White Label

      Description

      When pulling the AFLAC Certification New CRITIAL ILLNESS CERTIFICATION: I Certify I am Actively as work. If electing spouse coverage... on a standard report the column header is cutting off (see below) and it is inserting "SPCHAR511134" It also does the same thing on the other question for Accident.

      I don't know if there is a character limit but if there is can we increase it.

        Attachments

          Activity

          Hide
          Prashant.samal Prashant Samal (Inactive) added a comment -

          Please check this

          __________________________
          Satya Amruta Lohiya

          Show
          Prashant.samal Prashant Samal (Inactive) added a comment - Please check this __________________________ Satya Amruta Lohiya
          Hide
          dkulling Debbie Kulling added a comment -

          Please provide update on this ticket

          Show
          dkulling Debbie Kulling added a comment - Please provide update on this ticket
          Hide
          jyoti.agrawal Jyoti Agrawal (Inactive) added a comment -

          Hi Debbie Kulling,

          The field selected has character more than 128 and report service tool has limitation of 128 characters.

          If we try to extend beyond 128 characters system throws error. So we trim the names beyond 128 characters in the code logic.

          Reason of "SPCHAR511134" appended in header name

          If two or more fields have similar name up-to 128 characters, then on trimming all will become same name and system will throw error again. So internally we append some random codes that distinguish such field names with each other.

          If those fields are really required to be shown with complete name, then we can do more R&D if this is anyhow possible. But we are not sure on this.

          Do let us know your views

          Thanks,

          Jyoti Agrawal

          cc: Amruta Lohiya

           

          Show
          jyoti.agrawal Jyoti Agrawal (Inactive) added a comment - Hi Debbie Kulling , The field selected has character more than 128 and report service tool has limitation of 128 characters. If we try to extend beyond 128 characters system throws error. So we trim the names beyond 128 characters in the code logic. Reason of "SPCHAR511134" appended in header name :  If two or more fields have similar name up-to 128 characters, then on trimming all will become same name and system will throw error again. So internally we append some random codes that distinguish such field names with each other. If those fields are really required to be shown with complete name, then we can do more R&D if this is anyhow possible. But we are not sure on this. Do let us know your views Thanks, Jyoti Agrawal cc: Amruta Lohiya  
          Hide
          dkulling Debbie Kulling added a comment -

          Would it be possible to reformat the question somehow from

          To:

          CRITICAL ILLNESS CERTIFICATION:

          I certify I am actively at work.  If electing....

          That way the report would only pull "CRITICAL ILLNESS CERTIFICATION:" as the report column header

          Show
          dkulling Debbie Kulling added a comment - Would it be possible to reformat the question somehow from To: CRITICAL ILLNESS CERTIFICATION: I certify I am actively at work.  If electing.... That way the report would only pull "CRITICAL ILLNESS CERTIFICATION:" as the report column header
          Hide
          amruta.lohiya Amruta Lohiya added a comment -

          Swapnil Pandhare

          Please modify the question

          Show
          amruta.lohiya Amruta Lohiya added a comment - Swapnil Pandhare Please modify the question
          Hide
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

          Hi Debbie Kulling

          We cannot format/modify radio group label in above mentioned way. 

          But, we can add a paragraph control and add formatted text in that. Below paragraph control , we can place radio group control below paragraph. This can be done by editing form from website.

           

          Please let us know if you have more questions on this.

          Thanks,

          Swapnil P.

          Show
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment - Hi Debbie Kulling ,  We cannot format/modify radio group label in above mentioned way.  But, we can add a paragraph control and add formatted text in that. Below paragraph control , we can place radio group control below paragraph. This can be done by editing form from website.   Please let us know if you have more questions on this. Thanks, Swapnil P.
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          Hi Debbie Kulling

          Would you still need Dev to add a Paragraph control and add for Formatted text?

          Let me know either way so I can close/keep it open.

          Thanks!
          Monika

           

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - Hi  Debbie Kulling Would you still need Dev to add a Paragraph control and add for Formatted text? Let me know either way so I can close/keep it open. Thanks! Monika  
          Hide
          dkulling Debbie Kulling added a comment - - edited

          Can you mock up what this will look like in a copy so I can get BCC's approval

          Show
          dkulling Debbie Kulling added a comment - - edited Can you mock up what this will look like in a copy so I can get BCC's approval
          Hide
          niteen.surwase Niteen Surwase (Inactive) added a comment -

          Hi Debbie Kulling

          Please find the mock ups for the field mentioned above.

          Please let us know if anything needs to change in above mock up.

          Thanks,

          Niteen S.

          CC; Swapnil Pandhare Satya

          Show
          niteen.surwase Niteen Surwase (Inactive) added a comment - Hi Debbie Kulling Please find the mock ups for the field mentioned above. Please let us know if anything needs to change in above mock up. Thanks, Niteen S. CC; Swapnil Pandhare Satya
          Hide
          dkulling Debbie Kulling added a comment -

          I am waiting on approval from the client

          Show
          dkulling Debbie Kulling added a comment - I am waiting on approval from the client
          Hide
          dkulling Debbie Kulling added a comment -

          Please proceed with your suggestion above.  I do want to make sure that you know that this question is tied to eligibility.  I want to make sure that this change will not impact any eligibility for any enrollments.

          Show
          dkulling Debbie Kulling added a comment - Please proceed with your suggestion above.  I do want to make sure that you know that this question is tied to eligibility.  I want to make sure that this change will not impact any eligibility for any enrollments.
          Hide
          niteen.surwase Niteen Surwase (Inactive) added a comment -

          Hi Debbie Kulling

          We have changed AFLAC Certification New --> CRITIAL ILLNESS CERTIFICATION field as per above mock-up. It worked as expected and It made no impact on any existing eligibility. 

          Please confirm at you side and let us know if you need any help.

          Thanks,

          Niteen S.

          CC; Swapnil Pandhare Satya Prashant Samal

          Show
          niteen.surwase Niteen Surwase (Inactive) added a comment - Hi Debbie Kulling We have changed  AFLAC Certification New --> CRITIAL ILLNESS CERTIFICATION field as per above mock-up. It worked as expected and It made no impact on any existing eligibility.  Please confirm at you side and let us know if you need any help. Thanks, Niteen S. CC; Swapnil Pandhare Satya Prashant Samal
          Hide
          dkulling Debbie Kulling added a comment -

          I have sent this over to BCC.  I will let you know as soon as I have confirmation from them that we can close the ticket

          Show
          dkulling Debbie Kulling added a comment - I have sent this over to BCC.  I will let you know as soon as I have confirmation from them that we can close the ticket
          Hide
          dkulling Debbie Kulling added a comment -

          I have confirmed with BCC that this is working as expected.  Thank you.  I am closing this ticket.

          Show
          dkulling Debbie Kulling added a comment - I have confirmed with BCC that this is working as expected.  Thank you.  I am closing this ticket.
          Hide
          dkulling Debbie Kulling added a comment -

          I need to reopen this ticket an it will not let me

           

          Show
          dkulling Debbie Kulling added a comment - I need to reopen this ticket an it will not let me  
          Hide
          dkulling Debbie Kulling added a comment -

          I apologize I closed this ticket too soon.  Can you please do the same thing you did on the Critical illness certification to the second question on the same page for Accident.  I did not realize we had the same issue with that question.

          Show
          dkulling Debbie Kulling added a comment - I apologize I closed this ticket too soon.  Can you please do the same thing you did on the Critical illness certification to the second question on the same page for Accident.  I did not realize we had the same issue with that question.
          Hide
          Monika.Demla Monika Demla (Inactive) added a comment -

          hi Niteen Surwase

          Please help in assisting in Opening the ticket.

          Show
          Monika.Demla Monika Demla (Inactive) added a comment - hi Niteen Surwase Please help in assisting in Opening the ticket.
          Hide
          Prashant.samal Prashant Samal (Inactive) added a comment -

          Re-Opening ticket as per the request

          Monika Demla Debbie Kulling Niteen Surwase

          Show
          Prashant.samal Prashant Samal (Inactive) added a comment - Re-Opening ticket as per the request Monika Demla Debbie Kulling Niteen Surwase
          Hide
          niteen.surwase Niteen Surwase (Inactive) added a comment -

          Hi Debbie Kulling

          We have made changes in ACCIDENT CERTIFICATION field accordingly on County of San Luis Obispo.

          Please verify this changes and close the ticket,

          Thanks,

          Niteen S.

          CC: Swapnil Pandhare Satya Prashant Samal Monika Demla

          Show
          niteen.surwase Niteen Surwase (Inactive) added a comment - Hi  Debbie Kulling We have made changes in  ACCIDENT CERTIFICATION  field accordingly on County of San Luis Obispo. Please verify this changes and close the ticket, Thanks, Niteen S. CC: Swapnil Pandhare Satya Prashant Samal Monika Demla
          Hide
          dkulling Debbie Kulling added a comment -

           BCC has verified the change.  Thank you for your help

          Show
          dkulling Debbie Kulling added a comment -  BCC has verified the change.  Thank you for your help

            People

            Assignee:
            dkulling Debbie Kulling
            Reporter:
            dkulling Debbie Kulling
            Account Executive:
            Debbie Kulling
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 11.25h
                11.25h