WORKTERRAProject Type: software

WORKTERRA

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

BSG ACA Reporting

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Module:
      ACA - Reports
    • Reported by:
      Support
    • Item State:
      Development - Development Backlog
    • Issue Importance:
      Must Have

      Description

      This will be an individual module; I am seeing lot of work in this.

      1 BSG needed this on 10/01/2016

        Attachments

          Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. WT-3921 Offer Identifier and Event Reason display blank in BSG file

          • High - Serious problem that could block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3922 Time format is missing for Transaction date in Offer, Coverage tag

          • Low - Minor problem or easily worked around.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3923 Incorrect Employer Cost display in BSG file

          • High - Serious problem that could block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3925 ELIG - Incorrect Dependent and Spouse Coverage flag display in BSG file

          • High - Serious problem that could block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3926 Incorrect Medical Plan Code identifier display for ELIG tag in BSG File

          • Critical - This problem will block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3927 COVG - Multiple COVG rows for single plan enrollment

          • High - Serious problem that could block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3961 COVG - Event Reason , Event Date ,Medical Plan Code display blank for future enrolled EE

          • Critical - This problem will block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3983 ELIG - Wait period Indicator , Waived Coverage display blank in Export file

          • High - Serious problem that could block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3996 Terminated EE does not display in retro file

          • High - Serious problem that could block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3997 COVG - Incorrect Medical Plan Coverage Level Code , Medical Plan Coverage Level Description value display in file

          • High - Serious problem that could block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-4001 Credit pool value did not consider in EE and ER cost in ELIG , COVG template

          • Medium - Has the potential to affect progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-4004 Bydefault DTS display incorrect value in map data field

          • Low - Minor problem or easily worked around.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-4301 Change File - No change in employee eligibility still it's populating in change file

          • High - Serious problem that could block progress.
          • Closed
          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-3438 BSG : - ADP Health Compliance Benefits Import Pipe Delimited-2.51

          • High - Serious problem that could block progress.
          • Closed

          Enhancement - An improvement or enhancement to an existing feature or task. WT-3440 BSG ADP Health Compliance Benefit Import XML v2.42 XML

          • High - Serious problem that could block progress.
          • Closed

          Enhancement - An improvement or enhancement to an existing feature or task. WT-3441 BSG Health Compliance Non Employee Import 2.52

          • High - Serious problem that could block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3928 When plan is mapped to two rates [Such as Flat amount & percentage] then ER cost is not displaying correctly in eligibility element

          • Medium - Has the potential to affect progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3929 ACA_Open enrollment offer displayed even though it is not configured on the Export template

          • Medium - Has the potential to affect progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3948 COVG Template - EE,ER cost displayed zero when we move the EE from one class to other class

          • Medium - Has the potential to affect progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3949 COVG - Incorrect Transaction Date in file when change the EE classes.

          • Medium - Has the potential to affect progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3953 When employee changes the tier of enrollment in that case continuous offer is not displaying in same plan. [decrease in tier]

          • Medium - Has the potential to affect progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3954 ACA_Full File does not show record of an employee who is not enrolled (Waived coverage)

          • High - Serious problem that could block progress.
          • Production Complete

          Bug - A problem which impairs or prevents the functions of the product. WT-3955 Tierwise cost is not changing in the ELIG ELEMENT. It always displayed cost of enrolled plan.

          • High - Serious problem that could block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3956 OFFR Template - Offer tag details display blank

          • Critical - This problem will block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3957 If employee is getting multiple modes, then its not reflecting in Offer element

          • High - Serious problem that could block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3963 Offer element is not getting updated in case of New Hire employee

          • Medium - Has the potential to affect progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-3985 Rehire employee is not coming on the file.

          • High - Serious problem that could block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-4010 Employee & Dependent did not considered in change file when there is change in the tier

          • Medium - Has the potential to affect progress.
          • Closed

          Enhancement - An improvement or enhancement to an existing feature or task. WT-4048 Health Efx Benefit File Format Version 1.0 7-3-2015

          • High - Serious problem that could block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-4078 ACA_Waive subtemplate_table allies are not used in mapped fields.

          • Medium - Has the potential to affect progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-4079 ACA_Unable to add data transformation field for waiver subtemplate

          • Critical - This problem will block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-4271 In case of continuous enrollment, if rates are changing those are not reflecting on the file

          • Medium - Has the potential to affect progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-4273 In case of waive scenario_New hire employees Offer and Eligibility elements are not having complete information

          • Medium - Has the potential to affect progress.
          • Closed

          Change Request - Change Request WT-5168 ACA - Reason for waiver code from ADP file fetches blank space (instead of no space) on coverage template

          • Low - Minor problem or easily worked around.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-6658 ACA - Mandatory field data missing for employee on Valmet Benefit Import FEB change file

          • High - Serious problem that could block progress.
          • Closed

            Activity

            Descending order - Click to sort in ascending order
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            As Currently using WT-8973 for metso ACA file and now we are not delivering file
            for Valmet and Tango. Please refer WT: 8973 for 2017 metso ACA files updates.

            Hence we are closing this ticket. Please feel free to reopen ticket if required.

            Thanks,
            Smita

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - As Currently using WT-8973 for metso ACA file and now we are not delivering file for Valmet and Tango. Please refer WT: 8973 for 2017 metso ACA files updates. Hence we are closing this ticket. Please feel free to reopen ticket if required. Thanks, Smita
            Hide
            Permalink
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            attached updated BSG-InternalTracking.xls excel for Valmet change and Tango files.

            Nandkumar Prabhakar Karlekar Revansiddha Gaur Mahendra Mungase Yogesh Chaudhari

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - attached updated BSG-InternalTracking.xls excel for Valmet change and Tango files. Nandkumar Prabhakar Karlekar Revansiddha Gaur Mahendra Mungase Yogesh Chaudhari
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            Attaching test cases for BSG enhancement.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Attaching test cases for BSG enhancement.
            Hide
            Permalink
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Hi Nandkumar Prabhakar Karlekar,

            As discussed attached BSG-InternalTracking.xls excel having current status of BSG group files.

            Thanks,
            Sachin Hingole

            Yogesh Chaudhari Revansiddha Gaur Mahendra Mungase

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Hi Nandkumar Prabhakar Karlekar , As discussed attached BSG-InternalTracking.xls excel having current status of BSG group files. Thanks, Sachin Hingole Yogesh Chaudhari Revansiddha Gaur Mahendra Mungase
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            Hi Debbie,

            We have fixed previously mentioned issue for Non employee ACA file.
            After fixing issues we have exported latest files for non employee from Valmet company.

            We have uploaded non employee test files on FTP.

            FTP details are as follows

            URL - https://ftpsecure.ebsbenefits.com
            Folder path- /users/workterraaca/BSG ACA/Valmet ADP File/NonEmployee/10262016
            File name- G32B64JRY120CY5E_valmet1_NonEmployee_20160101_054640.zip

            Previous Issues are as follows

            ADDR
            Starting from the end of the line, the country codes are 2 digit max. not “USA” but “US”.
            If the country is “US” the zip is 5 digits, and the Zip code extension (optional) is limited to 4 digits.
            Harbinger Comments - Now country code field will show only 2 chars i.e. US. and also zip codes will show 5 digits and extension will show 4 digits.

            COVG
            Medical Coverage Level Code is limited to 20 characters. “ Employee + Spouse + Children” is too long.
            Harbinger Comments - We have corrected it by changing data transformation, it will not exceed 20 chars for Medical Coverage Level Code.

            EEID
            Four cases of missing NonEmployee Type (C, R, or O are required.)
            Harbinger Comments - This is also fixed by changing data transformation, File will show only C, R or O.

            EEID John M Lemieux seems to be missing quite a bit of information. He would fail.
            Harbinger Comments - For employee John M Lemieux, as he was enrolled in active plans before his change of status and as active plans are not selected on the template. This employee is not on the file.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Hi Debbie, We have fixed previously mentioned issue for Non employee ACA file. After fixing issues we have exported latest files for non employee from Valmet company. We have uploaded non employee test files on FTP. FTP details are as follows URL - https://ftpsecure.ebsbenefits.com Folder path- /users/workterraaca/BSG ACA/Valmet ADP File/NonEmployee/10262016 File name- G32B64JRY120CY5E_valmet1_NonEmployee_20160101_054640.zip Previous Issues are as follows ADDR Starting from the end of the line, the country codes are 2 digit max. not “USA” but “US”. If the country is “US” the zip is 5 digits, and the Zip code extension (optional) is limited to 4 digits. Harbinger Comments - Now country code field will show only 2 chars i.e. US. and also zip codes will show 5 digits and extension will show 4 digits. COVG Medical Coverage Level Code is limited to 20 characters. “ Employee + Spouse + Children” is too long. Harbinger Comments - We have corrected it by changing data transformation, it will not exceed 20 chars for Medical Coverage Level Code. EEID Four cases of missing NonEmployee Type (C, R, or O are required.) Harbinger Comments - This is also fixed by changing data transformation, File will show only C, R or O. EEID John M Lemieux seems to be missing quite a bit of information. He would fail. Harbinger Comments - For employee John M Lemieux, as he was enrolled in active plans before his change of status and as active plans are not selected on the template. This employee is not on the file.
            10 older comments

              People

              Assignee:
              dkulling Debbie Kulling
              Reporter:
              nandkumar Nandkumar Prabhakar Karlekar (Inactive)
              Developer:
              Nandkumar Prabhakar Karlekar (Inactive)
              QA:
              Sachin Hingole (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 35h
                  35h
                  Remaining:
                  Time Spent - 20h Remaining Estimate - 15h
                  15h
                  Logged:
                  Time Spent - 20h Remaining Estimate - 15h
                  20h