WORKTERRAProject Type: software

WORKTERRA

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

2017 ACA - ACA reporting files for Wheaton (Tango)

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Module:
      ACA - Reports
    • Reported by:
      Support
    • Company:
      Wheaton Franciscan Healthcare
    • Severity:
      Medium

      Description

      Please see Kim at BSG's questions below and let us know your feedback:

      During our call today there were some items discussed that I we needed for Workterra to produce the monthly files for 2017.
      Plan IDs for 2017 will change. They will be WHDHP and WPPO. I have attached the 6 Medical Plan names in WT to provide any clarification needed.
      screenshot-2.png
      There is another area that will need to be programmed differently and possibly discussed regarding Field 31 on the DEM file. In 2017, the Ascension plans moved to a Premium Structure based on Salary bands. 4 salary bands were built for 2017 and associated rates were also built in the WT system to determine the proper premium based on the salary. The Minimum Coverage Amount value will be based on these premiums driven by Salary band, but it will only populate the value for the Single HDHP in that salary band.
      For example, someone enrolled in the Family PPO plan for January 2017, earning $34,000 would be in Salary band 1. Their monthly premium in WT would be $335.83, but the amount that would need to report in Field 31 would be 80.17 (single HDHP premium) – HDHP Less than 35006 Sub Rate Name, Employee Pre Tax Cost Associate Only Health Tier.
      It gets a bit more complicated when the Ascension Socially Just (Premium Assistance) program comes into plan. This is a program providing a rate reduction (25%, 50%, 75% or 100%) which is captured in a UDF at the Employee Demographic screen (2017 Medical Subsidy), this reduction would then need to be applied to the above amount. There are approximately 375 employees in this Socially Just program.
      These changes are very different from the 2016 data, which was a static amount. Can you let me know your thoughts on this and if this would be possible in development? Since we are only providing this report for 4 months, if there is a better way to do this due to development process potentially being extensive, please let me know.
      I am still working to finalize all of the rates for those in the Socially Just program. I do have the rates for those based on the Salary Bands
      Band 1 under 35006 $80.17
      Band 2 35006 to 75006 $112.67
      Band 3 75006.01 to 150010 $147.34
      Band 4 over 150010.00 $179.84
      Please let me know if you would like to discuss this to make sure you have a full understanding of this project for 2017.

        Attachments

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-4419 ACA - ACA reporting files for Wheaton (Tango)

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

            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
            Assignee Nandkumar [ satyap ] Revansiddha Gaur [ revansiddha.gaur ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Link This issue relates to WT-4419 [ WT-4419 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 88h [ 316800 ]
            Original Estimate 88h [ 316800 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 88h [ 316800 ] 82h [ 295200 ]
            Time Spent 6h [ 21600 ]
            Worklog Id 31930 [ 31930 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 82h [ 295200 ] 74h [ 266400 ]
            Time Spent 6h [ 21600 ] 14h [ 50400 ]
            Worklog Id 32257 [ 32257 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 74h [ 266400 ] 68h [ 244800 ]
            Time Spent 14h [ 50400 ] 20h [ 72000 ]
            Worklog Id 32480 [ 32480 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 68h [ 244800 ] 67h [ 241200 ]
            Time Spent 20h [ 72000 ] 21h [ 75600 ]
            Worklog Id 32704 [ 32704 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 67h [ 241200 ] 64.5h [ 232200 ]
            Time Spent 21h [ 75600 ] 23.5h [ 84600 ]
            Worklog Id 32906 [ 32906 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 64.5h [ 232200 ] 62h [ 223200 ]
            Time Spent 23.5h [ 84600 ] 26h [ 93600 ]
            Worklog Id 33000 [ 33000 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 62h [ 223200 ] 57.5h [ 207000 ]
            Time Spent 26h [ 93600 ] 30.5h [ 109800 ]
            Worklog Id 33105 [ 33105 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Smita Pawar [ smita.pawar ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 57.5h [ 207000 ] 52h [ 187200 ]
            Time Spent 30.5h [ 109800 ] 36h [ 129600 ]
            Worklog Id 33412 [ 33412 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Van Nguyen [ van.nguyen ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 52h [ 187200 ] 51.25h [ 184500 ]
            Time Spent 36h [ 129600 ] 36.75h [ 132300 ]
            Worklog Id 34458 [ 34458 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Assignee Van Nguyen [ van.nguyen ] Nandkumar [ satyap ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Nandkumar [ satyap ] Smita Pawar [ smita.pawar ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            EDI Analyst 1 Van Nguyen [ van.nguyen ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 51.25h [ 184500 ] 47.75h [ 171900 ]
            Time Spent 36.75h [ 132300 ] 40.25h [ 144900 ]
            Worklog Id 36029 [ 36029 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 47.75h [ 171900 ] 45.75h [ 164700 ]
            Time Spent 40.25h [ 144900 ] 42.25h [ 152100 ]
            Worklog Id 36030 [ 36030 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 45.75h [ 164700 ] 45h 35m [ 164100 ]
            Time Spent 42.25h [ 152100 ] 42h 25m [ 152700 ]
            Worklog Id 36070 [ 36070 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 45h 35m [ 164100 ] 45h 5m [ 162300 ]
            Time Spent 42h 25m [ 152700 ] 42h 55m [ 154500 ]
            Worklog Id 36393 [ 36393 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Revansiddha Gaur [ revansiddha.gaur ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 45h 5m [ 162300 ] 38h 5m [ 137100 ]
            Time Spent 42h 55m [ 154500 ] 49h 55m [ 179700 ]
            Worklog Id 37026 [ 37026 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 38h 5m [ 137100 ] 36h 5m [ 129900 ]
            Time Spent 49h 55m [ 179700 ] 51h 55m [ 186900 ]
            Worklog Id 37028 [ 37028 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 36h 5m [ 129900 ] 31h 5m [ 111900 ]
            Time Spent 51h 55m [ 186900 ] 56h 55m [ 204900 ]
            Worklog Id 37039 [ 37039 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Assignee Revansiddha Gaur [ revansiddha.gaur ] Van Nguyen [ van.nguyen ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 31h 5m [ 111900 ] 18h 5m [ 65100 ]
            Time Spent 56h 55m [ 204900 ] 69h 55m [ 251700 ]
            Worklog Id 37322 [ 37322 ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Remaining Estimate 18h 5m [ 65100 ] 11h 5m [ 39900 ]
            Time Spent 69h 55m [ 251700 ] 76h 55m [ 276900 ]
            Worklog Id 37918 [ 37918 ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Remaining Estimate 11h 5m [ 39900 ] 5h 5m [ 18300 ]
            Time Spent 76h 55m [ 276900 ] 82h 55m [ 298500 ]
            Worklog Id 37919 [ 37919 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 5h 5m [ 18300 ] 0h [ 0 ]
            Time Spent 82h 55m [ 298500 ] 112h 55m [ 406500 ]
            Worklog Id 41031 [ 41031 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 29.5h [ 106200 ]
            Time Spent 112h 55m [ 406500 ] 83h 25m [ 300300 ]
            Worklog Id 41031 [ 41031 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 29.5h [ 106200 ] 27.5h [ 99000 ]
            Time Spent 83h 25m [ 300300 ] 85h 25m [ 307500 ]
            Worklog Id 41156 [ 41156 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 27.5h [ 99000 ] 25.5h [ 91800 ]
            Time Spent 85h 25m [ 307500 ] 87h 25m [ 314700 ]
            Worklog Id 41885 [ 41885 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 25.5h [ 91800 ] 23.5h [ 84600 ]
            Time Spent 87h 25m [ 314700 ] 89h 25m [ 321900 ]
            Worklog Id 41886 [ 41886 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 23.5h [ 84600 ] 21.5h [ 77400 ]
            Time Spent 89h 25m [ 321900 ] 91h 25m [ 329100 ]
            Worklog Id 41887 [ 41887 ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Remaining Estimate 21.5h [ 77400 ] 19.5h [ 70200 ]
            Time Spent 91h 25m [ 329100 ] 93h 25m [ 336300 ]
            Worklog Id 41889 [ 41889 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 19.5h [ 70200 ] 15.5h [ 55800 ]
            Time Spent 93h 25m [ 336300 ] 97h 25m [ 350700 ]
            Worklog Id 42613 [ 42613 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Worklog Id 42613 [ 42613 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 15.5h [ 55800 ] 13.5h [ 48600 ]
            Time Spent 97h 25m [ 350700 ] 99h 25m [ 357900 ]
            Worklog Id 42975 [ 42975 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Remaining Estimate 13.5h [ 48600 ] 5.5h [ 19800 ]
            Time Spent 99h 25m [ 357900 ] 107h 25m [ 386700 ]
            Worklog Id 44086 [ 44086 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Remaining Estimate 5.5h [ 19800 ] 0h [ 0 ]
            Time Spent 107h 25m [ 386700 ] 116h 25m [ 419100 ]
            Worklog Id 44548 [ 44548 ]
            revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
            Time Spent 116h 25m [ 419100 ] 116h 55m [ 420900 ]
            Worklog Id 44902 [ 44902 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Attachment screenshot-1.png [ 49198 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 116h 55m [ 420900 ] 126h 55m [ 456900 ]
            Worklog Id 49000 [ 49000 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Worklog Id 49000 [ 49000 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Time Spent 126h 55m [ 456900 ] 132h 55m [ 478500 ]
            Worklog Id 49004 [ 49004 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Worklog Id 49004 [ 49004 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Stage Testing [ 10201 ] Reopen in Stage [ 10023 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Reopen in Stage [ 10023 ] In Development [ 10007 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status In Development [ 10007 ] Mockup Approval [ 10010 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Mockup Approval [ 10010 ] Mockup Approved [ 10012 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Mockup Approved [ 10012 ] In Development [ 10007 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status In Development [ 10007 ] Mockup Approval [ 10010 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Mockup Approval [ 10010 ] Mockup Approved [ 10012 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Mockup Approved [ 10012 ] In Development [ 10007 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status In Development [ 10007 ] Mockup Approval [ 10010 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Mockup Approval [ 10010 ] Mockup Approved [ 10012 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Mockup Approved [ 10012 ] In Development [ 10007 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Approved for production [ 10034 ] Production Testing [ 10202 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            Van.Nguyen Van Nguyen (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]

              People

              Assignee:
              Van.Nguyen Van Nguyen (Inactive)
              Reporter:
              smita.pawar Smita Pawar (Inactive)
              EDI Analyst 1:
              Van Nguyen (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 88h Original Estimate - 88h
                  88h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 132h 55m
                  132h 55m