WORKTERRAProject Type: software

WORKTERRA

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

ACA_COB_date format is not coming properly on file.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Module:
      ACA - Reports
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      1.Login to LB.
      2.Edit company say "City of Bellevue".
      3.Navigate to Home << Company Home << Template Management
      4.Edit template 'BSG to COB'.
      5.Click on field mapping.
      6.Map Changed date to Enrollment Election or Rate Change Date.
      7.Save the field mapping.
      8.Navigate to Manual Import/Export
      9.Export the template.
      10.Check the exported file.

      Actual: Changed Date displayed as 9/06/20 even though format was set like MMDDYYYY
      Expected: Changed Date should display like 9/06/2016

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          smita.pawar Smita Pawar (Inactive) created issue -
          smita.pawar Smita Pawar (Inactive) made changes -
          Field Original Value New Value
          Link This issue relates to WT-4088 [ WT-4088 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Dev Due Date 12/Sep/2016
          Dev Estimates 2
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
          Hide
          Permalink
          revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited

          Hi Smita Pawar,

          Concern : Election or Rate Change Date field mapping causes ADP's required date format populating on the file.

          Cause : There is no such option provided field level user prefered format so hard coded this format considering this field matching by discussing in team. But to this hard coded format is causing the issue.

          Correction : Introduced new field to map "ACA Election or Rate Change Date" for ADP spec -COVG - Transaction Date.

          Risk Metigation : Need to test ADP files as well as COB files as there is changes arrised in the field mapping.

          CC: Sachin Hingole Mahendra Mungase Yogesh Chaudhari Kumar Chhajed Ramya Tantry Rakesh Roy Nandkumar Prabhakar Karlekar

          Note :
          1. Further Covg Transaction Date should map with newly introduced field to get proper required format i.e. "ACA Election or Rate Change Date" format information is provided in Description text.
          2. Please ensure this new field should be displayed for only ACA marked templates only to map.

          For COB : need to mapp with "Election or rate changed date" so that this will refer date format as per specified on template settings.

          Test Files:
          COID_NETSECUREID_BenefitsImport_20160912_110355_beforemodification field mapping.txt COID_NETSECUREID_BenefitsImport_20160912_121222_AfterNewFieldMapping.txt

          New field :

          Affected files :
          \Database Objects\MasterCompanyDB\07_Data\103_WT-4712_WTB_ACA_NewData_Fields.sql
          \Database Objects\OnlineEnrollment\07_Data\63_WT-4712_WTB_ACA_NewData_Fields.sql
          \App\BusinessLogic\ImportExportDTS\ACAExportProcessRowwise.vb
          Regards,
          Revan

          Show
          revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - - edited Hi Smita Pawar , Concern : Election or Rate Change Date field mapping causes ADP's required date format populating on the file. Cause : There is no such option provided field level user prefered format so hard coded this format considering this field matching by discussing in team. But to this hard coded format is causing the issue. Correction : Introduced new field to map "ACA Election or Rate Change Date" for ADP spec -COVG - Transaction Date. Risk Metigation : Need to test ADP files as well as COB files as there is changes arrised in the field mapping. CC: Sachin Hingole Mahendra Mungase Yogesh Chaudhari Kumar Chhajed Ramya Tantry Rakesh Roy Nandkumar Prabhakar Karlekar Note : 1. Further Covg Transaction Date should map with newly introduced field to get proper required format i.e. "ACA Election or Rate Change Date" format information is provided in Description text. 2. Please ensure this new field should be displayed for only ACA marked templates only to map. For COB : need to mapp with "Election or rate changed date" so that this will refer date format as per specified on template settings. Test Files: COID_NETSECUREID_BenefitsImport_20160912_110355_beforemodification field mapping.txt COID_NETSECUREID_BenefitsImport_20160912_121222_AfterNewFieldMapping.txt New field : Affected files : \Database Objects\MasterCompanyDB\07_Data\103_ WT-4712 _WTB_ACA_NewData_Fields.sql \Database Objects\OnlineEnrollment\07_Data\63_ WT-4712 _WTB_ACA_NewData_Fields.sql \App\BusinessLogic\ImportExportDTS\ACAExportProcessRowwise.vb Regards, Revan
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Code Review Date 12/Sep/2016
          Code Reviewed By Nandkumar Karlekar [ 11904 ]
          Developer Revansiddha Gaur [ revansiddha.gaur ]
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Assignee Revansiddha Gaur [ revansiddha.gaur ] Smita Pawar [ smita.pawar ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment - - edited

          We have tested above mentioned issue on LB.Its working fine
          but we are deploying this fix to stage with other COB files issue.

          Attaching exported file

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - - edited We have tested above mentioned issue on LB.Its working fine but we are deploying this fix to stage with other COB files issue. Attaching exported file
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          smita.pawar Smita Pawar (Inactive) made changes -
          Attachment Cob.png [ 27303 ]
          gokul.sonawane Gokul Sonawane (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment -

          We have verified above mentioned issue on Stage [Valmet for Hspl].
          Its working fine.
          Currently Date format is coming proper when newly mapped field is mapped.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Stage [Valmet for Hspl] . Its working fine. Currently Date format is coming proper when newly mapped field is mapped.
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment -

          We have verified above mentioned issue on Production [Valmet Benefits].
          Its working fine.
          Attaching screen shot of verified file.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Production [Valmet Benefits] . Its working fine. Attaching screen shot of verified file.
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
          smita.pawar Smita Pawar (Inactive) made changes -
          Attachment 4712.png [ 29390 ]
          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment -

          Above mentioned issue is fixed and its working fine.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - Above mentioned issue is fixed and its working fine.
          smita.pawar Smita Pawar (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          Transition Time In Source Status Execution Times
          Revansiddha Gaur (Inactive) made transition -
          Open In Development
          		3d 1h 59m 1
          Smita Pawar (Inactive) made transition -
          In Development In LB Testing
          		1d 1h 50m 1
          Rakesh Roy (Inactive) made transition -
          In LB Testing Stage Testing
          		13d 22h 19m 1
          Smita Pawar (Inactive) made transition -
          Stage Testing In Production Testing
          		19d 22h 13m 1
          Smita Pawar (Inactive) made transition -
          In Production Testing Production Complete
          		15m 46s 1
          Smita Pawar (Inactive) made transition -
          Production Complete Closed
          		3s 1

            People

            Assignee:
            smita.pawar Smita Pawar (Inactive)
            Reporter:
            smita.pawar Smita Pawar (Inactive)
            Developer:
            Revansiddha Gaur (Inactive)
            QA:
            Smita Pawar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Dev Due Date:
              Code Review Date: