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