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

Import - Mandatory field list on import template

    Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Stage
    • Bug Severity:
      Low
    • Module:
      BenAdmin - Import
    • Reported by:
      Support
    • Item State:
      Production Complete - Closed

      Description

      Client has observed that this listing of mandatory field in a pop up after clicking link on fields mapping screen is not proper. We need to fix this.

        Attachments

        1. ACA_Employee_import.png
          ACA_Employee_import.png
          121 kB
        2. Aftermapping.jpg
          Aftermapping.jpg
          203 kB
        3. beforemapping.jpg
          beforemapping.jpg
          216 kB
        4. beforemapping.jpg
          beforemapping.jpg
          212 kB
        5. EOI.jpg
          EOI.jpg
          167 kB
        6. Import Mandatory Field Mapping.xls
          27 kB
        7. Import Mandatory Field Mapping -UpdatedByACA.xls
          51 kB
        8. MandatoryFields.PNG
          MandatoryFields.PNG
          31 kB
        9. MedicareAftermapping.jpg
          MedicareAftermapping.jpg
          209 kB
        10. PCPImportIssue.jpg
          PCPImportIssue.jpg
          206 kB
        11. PCPIssueAftermapping.jpg
          PCPIssueAftermapping.jpg
          200 kB
        12. Point 1.jpg
          Point 1.jpg
          75 kB
        13. Point 2.jpg
          Point 2.jpg
          93 kB

          Issue Links

            Activity

            Hide
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            Please get this verified on all three environments. We will take it up on observations shared by you

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Please get this verified on all three environments. We will take it up on observations shared by you
            Hide
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Hi Venkatesh Pujari,

            Please take it on Friday 27th JAN.

            Thanks,
            Sachin Hingole

            Jaideep Vinchurkar

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Hi Venkatesh Pujari , Please take it on Friday 27th JAN. Thanks, Sachin Hingole Jaideep Vinchurkar
            Hide
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Jaideep Vinchurkar,

            I have verified the listing of mandatory field in a pop up after clicking link on fields mapping screen. Please find the attached snap shot of the fields displayed for election import. Also note that for other types of templates also same link is displayed as " Note: Employee Social Security Number or Employee ID is mandatory for Import template. Click here to view mandatory fields for Election template for Import. ". As per my understanding the note should be changed as per the type of template and also the fields displayed in pop up for mandatory fields should be changed as per template created.

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Jaideep Vinchurkar , I have verified the listing of mandatory field in a pop up after clicking link on fields mapping screen. Please find the attached snap shot of the fields displayed for election import. Also note that for other types of templates also same link is displayed as " Note: Employee Social Security Number or Employee ID is mandatory for Import template. Click here to view mandatory fields for Election template for Import. ". As per my understanding the note should be changed as per the type of template and also the fields displayed in pop up for mandatory fields should be changed as per template created. Sachin Hingole Thanks, Venkatesh
            Hide
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            Please start analysis for this.

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - Please start analysis for this.
            Hide
            vishal.bajad Vishal Bajad (Inactive) added a comment -

            This issues has been resolved and ready for LB deployment.

            Show
            vishal.bajad Vishal Bajad (Inactive) added a comment - This issues has been resolved and ready for LB deployment.
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -
            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Sachin Hingole FYI
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            As discussed with Vishal Bajad , We need to change display fields under 'Import/Export Field Mapping(s)' information pop up for Import.

            So, Assigning back to Dev Team.

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - As discussed with Vishal Bajad , We need to change display fields under 'Import/Export Field Mapping(s)' information pop up for Import. So, Assigning back to Dev Team. CC - Sachin Hingole
            Hide
            vishal.bajad Vishal Bajad (Inactive) added a comment -

            Changes are completed and Ready for LB Deployment.

            Show
            vishal.bajad Vishal Bajad (Inactive) added a comment - Changes are completed and Ready for LB Deployment.
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment - - edited

            Verified on LB and found below issues.

            1) Import Template Type - Employee Data :

            All mandatory fields [ Employee , Dependent and Election Data ] are not displayed under 'Import/Export Field Mapping(s)' pop up.

            2) Import Template Type - EOI Data:

            Numbering of mandatory fields is not proper.

            3) Import Template Type - Job Data :

            One Field [ Job Schedule ] is missing under 'Import/Export Field Mapping(s)' pop up.

            4) Import Template Type - 1095C Part II , Paycheck Data , TimeSheet Data , ACA Election Offer and 1095C Part III

            All import types mandatory data are displayed under 'Import/Export Field Mapping(s)' pop up.

            CC - Sachin Hingole

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - - edited Verified on LB and found below issues. 1) Import Template Type - Employee Data : All mandatory fields [ Employee , Dependent and Election Data ] are not displayed under 'Import/Export Field Mapping(s)' pop up. 2) Import Template Type - EOI Data: Numbering of mandatory fields is not proper. 3) Import Template Type - Job Data : One Field [ Job Schedule ] is missing under 'Import/Export Field Mapping(s)' pop up. 4) Import Template Type - 1095C Part II , Paycheck Data , TimeSheet Data , ACA Election Offer and 1095C Part III All import types mandatory data are displayed under 'Import/Export Field Mapping(s)' pop up. CC - Sachin Hingole
            Hide
            vishal.bajad Vishal Bajad (Inactive) added a comment -

            Hi ,

            All reported issues has been resolved and pending for Code review , it will deployed on LB with next deployment patch once code review is done.

            Thanks !

            Show
            vishal.bajad Vishal Bajad (Inactive) added a comment - Hi , All reported issues has been resolved and pending for Code review , it will deployed on LB with next deployment patch once code review is done. Thanks !
            Hide
            suraj.sokasane Suraj Sokasane (Inactive) added a comment -

            This is pending for Code review. Will be completed tomorrow. Hence updating the Dev Due date.

            Show
            suraj.sokasane Suraj Sokasane (Inactive) added a comment - This is pending for Code review. Will be completed tomorrow. Hence updating the Dev Due date.
            Hide
            vishal.bajad Vishal Bajad (Inactive) added a comment - - edited

            Hi Revansiddha Gaur ,

            Please share list of all unique fields for ACA import type as Per Import Mandatory Field Mapping.xls .

            Thanks !

            Show
            vishal.bajad Vishal Bajad (Inactive) added a comment - - edited Hi Revansiddha Gaur , Please share list of all unique fields for ACA import type as Per Import Mandatory Field Mapping.xls . Thanks !
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Vishal Bajad,

            Please communicate for this with Nandkumar Prabhakar Karlekar.

            Thanks !

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Vishal Bajad , Please communicate for this with Nandkumar Prabhakar Karlekar . Thanks !
            Hide
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

            Hi Vishal Bajad,

            Please find the updated sheet for all unique fields for ACA templates.

            Import Mandatory Field Mapping -UpdatedByACA.xls

            Updated the details for Template Name as below...

            • ACA EIN Import
            • ACA Offer Import
            • ACA Election Import
            • ACA Benefit Plan Import
            • ACA Employee Import
            • ACA Spouse Import
            • ACA Child Import
            • ACA Unpaid Leave Import
            • ACA Timesheet Import
            • ACA Correction 1095 C Part II SSN
            • ACA Correction 1095 C Part III SSN

            Thanks,
            Revan

            Nandkumar Prabhakar Karlekar

            Show
            revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi Vishal Bajad , Please find the updated sheet for all unique fields for ACA templates. Import Mandatory Field Mapping -UpdatedByACA.xls Updated the details for Template Name as below... ACA EIN Import ACA Offer Import ACA Election Import ACA Benefit Plan Import ACA Employee Import ACA Spouse Import ACA Child Import ACA Unpaid Leave Import ACA Timesheet Import ACA Correction 1095 C Part II SSN ACA Correction 1095 C Part III SSN Thanks, Revan Nandkumar Prabhakar Karlekar
            Hide
            vishal.bajad Vishal Bajad (Inactive) added a comment -

            Hi ,

            Please find below template type for which we have added mandatory fields in pop up list ,

            • Employee Data
            • Election data
            • Dependent Data
            • Beneficiary Template
            • PCP Import
            • Medicare Template
            • Medicaid
            • Candidate Job Application Data
            • Paycheck Data
            • Timesheet Data
            • EOI Data
            • ACA EIN DATA
            • Unpaid Leave Data
            • ACA Election Offer
            • Benefit plan
            • Salary Change
            • 1095 C Part II
            • 1095 C Part III
            • Candidate data
            • Job data
            • Waived Data Import

            We have done with all changes and pending for code review and it will deployed on LB with next deployment patch once we done with code review.

            Thanks !

            Show
            vishal.bajad Vishal Bajad (Inactive) added a comment - Hi , Please find below template type for which we have added mandatory fields in pop up list , Employee Data Election data Dependent Data Beneficiary Template PCP Import Medicare Template Medicaid Candidate Job Application Data Paycheck Data Timesheet Data EOI Data ACA EIN DATA Unpaid Leave Data ACA Election Offer Benefit plan Salary Change 1095 C Part II 1095 C Part III Candidate data Job data Waived Data Import We have done with all changes and pending for code review and it will deployed on LB with next deployment patch once we done with code review. Thanks !
            Hide
            meghana.joshi Meghana Joshi (Inactive) added a comment -

            Tested on LB For Ben admin Import Data Types and Found below Issues :

            Vishal Bajad - Issue : 1 ) Enrollment Applied coverage Amount Fields is displayed two time for PCP Data , EOI Data. Ideally one field should be Enrollment Approved coverage Amount

            2) Displayed Employee Data template heading name two time for Payment Status Type template .

            3) If we open created PCP Data template then it displayed Election Data Fields within popup .

            Mahendra Mungase - As Discussed with Sachin Hingole , Assigning to you for ACA Part verification.

            Show
            meghana.joshi Meghana Joshi (Inactive) added a comment - Tested on LB For Ben admin Import Data Types and Found below Issues : Vishal Bajad - Issue : 1 ) Enrollment Applied coverage Amount Fields is displayed two time for PCP Data , EOI Data. Ideally one field should be Enrollment Approved coverage Amount 2) Displayed Employee Data template heading name two time for Payment Status Type template . 3) If we open created PCP Data template then it displayed Election Data Fields within popup . Mahendra Mungase - As Discussed with Sachin Hingole , Assigning to you for ACA Part verification.
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            Smita Pawar Please do testing on priority.

            Sachin Hingole

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Smita Pawar Please do testing on priority. Sachin Hingole
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            Smita Pawar What's the testing plan?
            Sachin Hingole

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Smita Pawar What's the testing plan? Sachin Hingole
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment - - edited

            This testing was planned in last week i.e till 18 July but we couldn't put time for same due to Wacker neuson- Health EFx file issue WT-8361. Please refer latest stage & Production due date

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - - edited This testing was planned in last week i.e till 18 July but we couldn't put time for same due to Wacker neuson- Health EFx file issue WT-8361 . Please refer latest stage & Production due date
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment - - edited

            Updating testing status for ACA Import templates.

            1.Offer Import template: Correct mandatory fields are displayed on Pop up.
            2.While testing ACA_EIN Import found an issue. Please refer WT-10271 for additional information

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - - edited Updating testing status for ACA Import templates. 1.Offer Import template: Correct mandatory fields are displayed on Pop up. 2.While testing ACA_EIN Import found an issue. Please refer WT-10271 for additional information
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Revansiddha Gaur,

            We need to revisits the specs for ACA Employee Template.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Revansiddha Gaur , We need to revisits the specs for ACA Employee Template.
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have completed testing of below mentioned ACA templates

            ACA EIN Import
            ACA Offer Import
            ACA Benefit Plan Import
            ACA Unpaid Leave Import
            ACA Timesheet Import
            ACA Correction 1095 C Part II SSN
            ACA Correction 1095 C Part III SSN

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have completed testing of below mentioned ACA templates ACA EIN Import ACA Offer Import ACA Benefit Plan Import ACA Unpaid Leave Import ACA Timesheet Import ACA Correction 1095 C Part II SSN ACA Correction 1095 C Part III SSN
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment - - edited

            Hi Revansiddha Gaur,

            As discussed with Dev assigning jira back to Dev to revisit ACA_Employee_Data specification.
            While considering specifications we haven't considered few fields.
            PFA screen shot for additional information.
            e.g.
            Employee First Name
            Employee Last Name
            Employee Date of Birth

            Jayshree Nagpure:
            As discussed please retest the bugs of normal import.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - - edited Hi Revansiddha Gaur , As discussed with Dev assigning jira back to Dev to revisit ACA_Employee_Data specification. While considering specifications we haven't considered few fields. PFA screen shot for additional information. e.g. Employee First Name Employee Last Name Employee Date of Birth Jayshree Nagpure : As discussed please retest the bugs of normal import.
            Hide
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

            Please open separate ticket for ACA and assign this bug to Jayshree Nagpure. We cannot wait more on this.

            Show
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Please open separate ticket for ACA and assign this bug to Jayshree Nagpure . We cannot wait more on this.
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            As per comment, Jayshree please test the bugs of normal import

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - As per comment, Jayshree please test the bugs of normal import
            Hide
            smita.pawar Smita Pawar (Inactive) added a comment -

            Please do not consider any ACA related import we are creating separate ticket for ACA import.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Please do not consider any ACA related import we are creating separate ticket for ACA import.
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Vishal Bajad,

            Verified on Lb
            Company - CAISO

            Verified for below import :

            • Employee Data
            • Election data
            • Dependent Data
            • Beneficiary Template
            • PCP Import
            • Medicare Template
            • Medicaid
            • Candidate Job Application Data
            • Paycheck Data
            • EOI data
            • Salary change
            • Waive import

            From the above import we have encountered issue on below import type :

            • PCP import : Applied coverage is repeated and after creating template election mandatory field are reflecting:
            • Medicare import : after creating template spouse mandatory field are reflecting:
            • Medicaid : after creating template spouse mandatory field are reflecting
            • EOI data : Applied covergae is repeated

            Hence re-opening this jira

            Note : As Mentioned in Above comments I have only considered normal import type not ACA import

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Vishal Bajad , Verified on Lb Company - CAISO Verified for below import : Employee Data Election data Dependent Data Beneficiary Template PCP Import Medicare Template Medicaid Candidate Job Application Data Paycheck Data EOI data Salary change Waive import From the above import we have encountered issue on below import type : PCP import : Applied coverage is repeated and after creating template election mandatory field are reflecting: Medicare import : after creating template spouse mandatory field are reflecting: Medicaid : after creating template spouse mandatory field are reflecting EOI data : Applied covergae is repeated Hence re-opening this jira Note : As Mentioned in Above comments I have only considered normal import type not ACA import Thanks, Jayshree cc : Rakesh Roy Prasad Pise
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Vishal Bajad,

            Could you please share 3C's of reported issues

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Vishal Bajad , Could you please share 3C's of reported issues Thanks, Jayshree cc : Rakesh Roy Prasad Pise
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited

            Verified on LB for Import
            Company - CAISO

            • Employee Data
            • Election data
            • Dependent Data
            • Beneficiary Template
            • PCP Import
            • Medicare Template
            • Medicaid
            • Candidate Job Application Data
            • Paycheck Data
            • EOI data
            • Salary change
            • Waive import

            Working fine as expected
            MArking item state as Ready for Stage

            CC: Rakesh Roy Prasad Pise Jaideep Vinchurkar

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - - edited Verified on LB for Import Company - CAISO Employee Data Election data Dependent Data Beneficiary Template PCP Import Medicare Template Medicaid Candidate Job Application Data Paycheck Data EOI data Salary change Waive import Working fine as expected MArking item state as Ready for Stage CC: Rakesh Roy Prasad Pise Jaideep Vinchurkar
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Hi Vishal Bajad,

            Verified on stage
            Company - City of bellevue for hspl

            • Employee Data
            • Election data
            • Dependent Data
            • Beneficiary Template
            • PCP Import
            • Medicare Template
            • Medicaid
            • Candidate Job Application Data
            • Job Data
            • Paycheck Data
            • EOI data
            • Salary change

            All above import mandatory field is verified and its showing properly.

            Please Note - Waive import is not verified, as enhancement related to waive import WT-8262 is not yet deployed on stage.
            We will test Waive import mandatory field once WT-8262 will deploy on stage.
            Hence, marking item state as Stage QA on Hold.

            Thanks,
            Jayshree

            cc :Rakesh Roy Prasad Pise Jaideep Vinchurkar

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Hi Vishal Bajad , Verified on stage Company - City of bellevue for hspl Employee Data Election data Dependent Data Beneficiary Template PCP Import Medicare Template Medicaid Candidate Job Application Data Job Data Paycheck Data EOI data Salary change All above import mandatory field is verified and its showing properly. Please Note - Waive import is not verified, as enhancement related to waive import WT-8262 is not yet deployed on stage. We will test Waive import mandatory field once WT-8262 will deploy on stage. Hence, marking item state as Stage QA on Hold. Thanks, Jayshree cc : Rakesh Roy Prasad Pise Jaideep Vinchurkar
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on stage
            Company - City of bellevue for hspl

            • Employee Data
            • Election data
            • Dependent Data
            • Beneficiary Template
            • PCP Import
            • Medicare Template
            • Medicaid
            • Candidate Job Application Data
            • Job Data
            • Paycheck Data
            • EOI data
            • Salary change
            • Waive Import
              Working fine,

            Marking item state as Ready for Production

            Thanks,
            Jayshree

            cc : Rakesh Roy Prasad Pise

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on stage Company - City of bellevue for hspl Employee Data Election data Dependent Data Beneficiary Template PCP Import Medicare Template Medicaid Candidate Job Application Data Job Data Paycheck Data EOI data Salary change Waive Import Working fine, Marking item state as Ready for Production Thanks, Jayshree cc : Rakesh Roy Prasad Pise
            Hide
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment -

            Verified on Production
            Company - ASML for hspl

            Employee Data
            Election data
            Dependent Data
            Beneficiary Template
            PCP Import
            Medicare Template
            Medicaid
            Candidate Job Application Data
            Job Data
            Paycheck Data
            EOI data
            Salary change
            Waive Import

            Working fine,
            Marking item state as Production complete

            Show
            jayshree.nagpure Jayshree Nagpure (Inactive) added a comment - Verified on Production Company - ASML for hspl Employee Data Election data Dependent Data Beneficiary Template PCP Import Medicare Template Medicaid Candidate Job Application Data Job Data Paycheck Data EOI data Salary change Waive Import Working fine, Marking item state as Production complete
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            Jennifer LeugersPlease verify this issue and confirm.

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Jennifer Leugers Please verify this issue and confirm.

              People

              Assignee:
              jennifer.leugers Jennifer Leugers
              Reporter:
              jaideep.vinchurkar Jaideep Vinchurkar (Inactive)
              Account Executive:
              Jennifer Leugers
              Developer:
              Vishal Bajad (Inactive)
              QA:
              Sachin Hingole (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Production Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 14h Original Estimate - 14h
                  14h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 70h 25m
                  70h 25m