[WT-8296] ACA Prime File Automation and change file implementation - Workterra Jira

Details

Type: Change Request
Status: Closed
Priority: High
Resolution: Unresolved
Affects Version/s: None
Fix Version/s: None
Component/s: None
Labels:
None

Module:
ACA - Reports
Reported by:
Support
Company:
Prime Healthcare
Item State:
Development - On Hold

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

ACA Prime File Process for year 2018.pdf
184 kB
05/Mar/18 07:16 AM
Prime Checklist QA.xls
13 kB
05/Jul/17 08:32 AM
TechSpec_WT-8296_Prime_Automation_IsRequired_Field_Export.doc
1.13 MB
15/Dec/17 01:20 PM

Issue Links

relates to

WT-10032 ACA: Performance Issue-Getting too much time to export the prime files.

Production Complete

WT-8255 Prime - Full file for Jan 17 and change file Feb 17 onwards

Closed

WT-9963 Prime Healthcare | Getting error while exporting ACA template.

Closed

WT-10243 ACA_prime Automation_Cost related fields are rolling out blank on file

Rejected

WT-12168 ACA : While Exporting ACA files, If the field is Marked as Required and value of that field is blank, not populate complete row

Closed

WT-12790 ACA Prime - if employee waive his enrollment, and its waive enrollment is terminated then termination date should be blank on file

Closed

(1 relates to)

Activity

Ascending order - Click to sort in descending order

Nandkumar Prabhakar Karlekar (Inactive) created issue - 06/Feb/17 06:01 AM

Nandkumar Prabhakar Karlekar (Inactive) made changes - 06/Feb/17 06:02 AM

Field	Original Value	New Value
Assignee	Vijay Siddha [ vijays ]	Mahendra Mungase [ mahendra.mungase ]

Sachin Hingole (Inactive) made changes - 06/Feb/17 09:50 AM

Item State

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Sachin Hingole (Inactive) made changes - 06/Feb/17 09:50 AM

Status

New Request [ 10029 ]

Pending for Approval [ 10002 ]

Sachin Hingole (Inactive) made changes - 06/Feb/17 09:50 AM

Status

Pending for Approval [ 10002 ]

Approved for Development [ 10003 ]

Sachin Hingole (Inactive) made changes - 06/Feb/17 09:50 AM

Status

Approved for Development [ 10003 ]

In Development [ 10007 ]

Sachin Hingole (Inactive) made changes - 06/Feb/17 09:50 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Sachin Hingole (Inactive) made changes - 06/Feb/17 09:50 AM

Status

Local Testing [ 10200 ]

Pending for Stage Approval [ 10300 ]

Sachin Hingole (Inactive) made changes - 06/Feb/17 09:50 AM

Status

Pending for Stage Approval [ 10300 ]

Approved for Stage [ 10030 ]

Sachin Hingole (Inactive) made changes - 06/Feb/17 09:50 AM

Status

Approved for Stage [ 10030 ]

Stage Testing [ 10201 ]

Sachin Hingole (Inactive) made changes - 06/Feb/17 09:50 AM

Status

Stage Testing [ 10201 ]

Pending for Production Approval [ 10301 ]

Sachin Hingole (Inactive) made changes - 06/Feb/17 09:51 AM

Status

Pending for Production Approval [ 10301 ]

Approved for production [ 10034 ]

Sachin Hingole (Inactive) made changes - 06/Feb/17 09:51 AM

Status

Approved for production [ 10034 ]

Production Testing [ 10202 ]

Mahendra Mungase (Inactive) made changes - 07/Feb/17 04:51 AM

Assignee

Mahendra Mungase [ mahendra.mungase ]

Smita Pawar [ smita.pawar ]

Mahendra Mungase (Inactive) made changes - 07/Feb/17 06:54 AM

Production Due Date

07/Mar/2017

Mahendra Mungase (Inactive) made changes - 07/Feb/17 11:40 AM

Assignee

Smita Pawar [ smita.pawar ]

Revansiddha Gaur [ revansiddha.gaur ]

Kumar Chhajed (Inactive) made changes - 09/Feb/17 11:36 AM

Remaining Estimate	160h [ 576000 ]	159.5h [ 574200 ]
Time Spent		0.5h [ 1800 ]
Worklog Id	24040 [ 24040 ]

Revansiddha Gaur (Inactive) made changes - 21/Apr/17 05:28 AM

Item State

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Revansiddha Gaur (Inactive) made changes - 21/Apr/17 05:29 AM

Remaining Estimate	159.5h [ 574200 ]	157.5h [ 567000 ]
Time Spent	0.5h [ 1800 ]	2.5h [ 9000 ]
Worklog Id		39756 [ 39756 ]

Revansiddha Gaur (Inactive) made changes - 27/Apr/17 05:07 AM

Remaining Estimate	157.5h [ 567000 ]	149.5h [ 538200 ]
Time Spent	2.5h [ 9000 ]	10.5h [ 37800 ]
Worklog Id		41112 [ 41112 ]

Revansiddha Gaur (Inactive) made changes - 27/Apr/17 05:08 AM

Remaining Estimate	149.5h [ 538200 ]	143.5h [ 516600 ]
Time Spent	10.5h [ 37800 ]	16.5h [ 59400 ]
Worklog Id		41113 [ 41113 ]

Revansiddha Gaur (Inactive) made changes - 28/Apr/17 05:21 AM

Remaining Estimate	143.5h [ 516600 ]	136.5h [ 491400 ]
Time Spent	16.5h [ 59400 ]	23.5h [ 84600 ]
Worklog Id		41600 [ 41600 ]

Revansiddha Gaur (Inactive) made changes - 28/Apr/17 07:15 AM

Remaining Estimate	136.5h [ 491400 ]	132.5h [ 477000 ]
Time Spent	23.5h [ 84600 ]	27.5h [ 99000 ]
Worklog Id		41840 [ 41840 ]

Nandkumar Prabhakar Karlekar (Inactive) made changes - 28/Apr/17 07:26 AM

Remaining Estimate	132.5h [ 477000 ]	130.5h [ 469800 ]
Time Spent	27.5h [ 99000 ]	29.5h [ 106200 ]
Worklog Id		41877 [ 41877 ]

Nandkumar Prabhakar Karlekar (Inactive) made changes - 28/Apr/17 07:26 AM

Remaining Estimate	130.5h [ 469800 ]	128.5h [ 462600 ]
Time Spent	29.5h [ 106200 ]	31.5h [ 113400 ]
Worklog Id		41878 [ 41878 ]

Nandkumar Prabhakar Karlekar (Inactive) made changes - 28/Apr/17 07:26 AM

Remaining Estimate	128.5h [ 462600 ]	126.5h [ 455400 ]
Time Spent	31.5h [ 113400 ]	33.5h [ 120600 ]
Worklog Id		41880 [ 41880 ]

Nandkumar Prabhakar Karlekar (Inactive) made changes - 28/Apr/17 07:27 AM

Remaining Estimate	126.5h [ 455400 ]	124.5h [ 448200 ]
Time Spent	33.5h [ 120600 ]	35.5h [ 127800 ]
Worklog Id		41881 [ 41881 ]

Nandkumar Prabhakar Karlekar (Inactive) made changes - 28/Apr/17 07:27 AM

Remaining Estimate	124.5h [ 448200 ]	122.5h [ 441000 ]
Time Spent	35.5h [ 127800 ]	37.5h [ 135000 ]
Worklog Id		41882 [ 41882 ]

Mahendra Mungase (Inactive) made changes - 28/Apr/17 07:47 AM

Remaining Estimate	122.5h [ 441000 ]	115.5h [ 415800 ]
Time Spent	37.5h [ 135000 ]	44.5h [ 160200 ]
Worklog Id		41907 [ 41907 ]

Mahendra Mungase (Inactive) made changes - 28/Apr/17 07:55 AM

Remaining Estimate	115.5h [ 415800 ]	113.5h [ 408600 ]
Time Spent	44.5h [ 160200 ]	46.5h [ 167400 ]
Worklog Id		41925 [ 41925 ]

Mahendra Mungase (Inactive) made changes - 28/Apr/17 07:58 AM

Remaining Estimate	113.5h [ 408600 ]	113h [ 406800 ]
Time Spent	46.5h [ 167400 ]	47h [ 169200 ]
Worklog Id		41931 [ 41931 ]

Revansiddha Gaur (Inactive) made changes - 03/May/17 04:54 AM

Remaining Estimate	113h [ 406800 ]	108.5h [ 390600 ]
Time Spent	47h [ 169200 ]	51.5h [ 185400 ]
Worklog Id		42789 [ 42789 ]

Revansiddha Gaur (Inactive) made changes - 04/May/17 05:02 AM

Remaining Estimate	108.5h [ 390600 ]	106h [ 381600 ]
Time Spent	51.5h [ 185400 ]	54h [ 194400 ]
Worklog Id		43047 [ 43047 ]

Revansiddha Gaur (Inactive) made changes - 05/May/17 05:01 AM

Remaining Estimate	106h [ 381600 ]	101h [ 363600 ]
Time Spent	54h [ 194400 ]	59h [ 212400 ]
Worklog Id		43278 [ 43278 ]

Revansiddha Gaur (Inactive) made changes - 09/May/17 05:30 AM

Remaining Estimate	101h [ 363600 ]	98.5h [ 354600 ]
Time Spent	59h [ 212400 ]	61.5h [ 221400 ]
Worklog Id		43900 [ 43900 ]

Nandkumar Prabhakar Karlekar (Inactive) made changes - 09/May/17 01:18 PM

Remaining Estimate	98.5h [ 354600 ]	94.5h [ 340200 ]
Time Spent	61.5h [ 221400 ]	65.5h [ 235800 ]
Worklog Id		44149 [ 44149 ]

Revansiddha Gaur (Inactive) made changes - 12/May/17 04:39 AM

Remaining Estimate	94.5h [ 340200 ]	90.5h [ 325800 ]
Time Spent	65.5h [ 235800 ]	69.5h [ 250200 ]
Worklog Id		44903 [ 44903 ]

Revansiddha Gaur (Inactive) made changes - 15/May/17 05:38 AM

Remaining Estimate	90.5h [ 325800 ]	84.5h [ 304200 ]
Time Spent	69.5h [ 250200 ]	75.5h [ 271800 ]
Worklog Id		45545 [ 45545 ]

Revansiddha Gaur (Inactive) made changes - 17/May/17 07:41 AM

Code Review Date		16/May/2017
Code Reviewed By		Nandkumar Karlekar [ 11904 ]
Item State	Parent values: Development(10200)Level 1 values: In Analysis(10204)	Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Khandu Kshirsagar (Inactive) made changes - 17/May/17 11:32 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Revansiddha Gaur (Inactive) made changes - 17/May/17 11:36 AM

Assignee

Revansiddha Gaur [ revansiddha.gaur ]

Smita Pawar [ smita.pawar ]

Nandkumar Prabhakar Karlekar (Inactive) made changes - 17/May/17 01:07 PM

Remaining Estimate	84.5h [ 304200 ]	82.5h [ 297000 ]
Time Spent	75.5h [ 271800 ]	77.5h [ 279000 ]
Worklog Id		46478 [ 46478 ]

Revansiddha Gaur (Inactive) made changes - 18/May/17 05:59 AM

Remaining Estimate	82.5h [ 297000 ]	81h [ 291600 ]
Time Spent	77.5h [ 279000 ]	79h [ 284400 ]
Worklog Id		46583 [ 46583 ]

Revansiddha Gaur (Inactive) made changes - 18/May/17 06:03 AM

Remaining Estimate	81h [ 291600 ]	73h [ 262800 ]
Time Spent	79h [ 284400 ]	87h [ 313200 ]
Worklog Id		46588 [ 46588 ]

Nandkumar Prabhakar Karlekar (Inactive) made changes - 26/May/17 05:36 AM

Remaining Estimate	73h [ 262800 ]	70h [ 252000 ]
Time Spent	87h [ 313200 ]	90h [ 324000 ]
Worklog Id		49043 [ 49043 ]

Nandkumar Prabhakar Karlekar (Inactive) made changes - 26/May/17 05:36 AM

Remaining Estimate	70h [ 252000 ]	68h [ 244800 ]
Time Spent	90h [ 324000 ]	92h [ 331200 ]
Worklog Id		49044 [ 49044 ]

Revansiddha Gaur (Inactive) made changes - 08/Jun/17 05:12 AM

Remaining Estimate	68h [ 244800 ]	63h [ 226800 ]
Time Spent	92h [ 331200 ]	97h [ 349200 ]
Worklog Id		53096 [ 53096 ]

Rakesh Roy (Inactive) made changes - 09/Jun/17 12:23 PM

Status

Production Testing [ 10202 ]

Reopen in Production [ 10027 ]

Rakesh Roy (Inactive) made changes - 09/Jun/17 12:23 PM

Status

Reopen in Production [ 10027 ]

In Development [ 10007 ]

Rakesh Roy (Inactive) made changes - 09/Jun/17 12:23 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Revansiddha Gaur (Inactive) made changes - 09/Jun/17 12:35 PM

Remaining Estimate	63h [ 226800 ]	61h [ 219600 ]
Time Spent	97h [ 349200 ]	99h [ 356400 ]
Worklog Id		53751 [ 53751 ]

Revansiddha Gaur (Inactive) made changes - 13/Jun/17 05:57 AM

Remaining Estimate	61h [ 219600 ]	59.5h [ 214200 ]
Time Spent	99h [ 356400 ]	100.5h [ 361800 ]
Worklog Id		54370 [ 54370 ]

Revansiddha Gaur (Inactive) made changes - 13/Jun/17 05:58 AM

Remaining Estimate	59.5h [ 214200 ]	59h [ 212400 ]
Time Spent	100.5h [ 361800 ]	101h [ 363600 ]
Worklog Id		54373 [ 54373 ]

Smita Pawar (Inactive) made changes - 15/Jun/17 10:20 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Revansiddha Gaur (Inactive) made changes - 16/Jun/17 04:40 AM

Remaining Estimate	59h [ 212400 ]	58h [ 208800 ]
Time Spent	101h [ 363600 ]	102h [ 367200 ]
Worklog Id		55629 [ 55629 ]

Smita Pawar (Inactive) made changes - 30/Jun/17 10:16 AM

Remaining Estimate	58h [ 208800 ]	56h [ 201600 ]
Time Spent	102h [ 367200 ]	104h [ 374400 ]
Worklog Id		60002 [ 60002 ]

Smita Pawar (Inactive) made changes - 05/Jul/17 08:32 AM

Attachment

Prime Checklist QA.xls [ 54161 ]

Smita Pawar (Inactive) made changes - 05/Jul/17 08:44 AM

Link

This issue relates to ~~WT-9963~~ [ ~~WT-9963~~ ]

Smita Pawar (Inactive) made changes - 10/Jul/17 01:57 PM

Remaining Estimate	56h [ 201600 ]	55.5h [ 199800 ]
Time Spent	104h [ 374400 ]	104.5h [ 376200 ]
Worklog Id		62110 [ 62110 ]

Smita Pawar (Inactive) made changes - 20/Jul/17 11:39 AM

Link

This issue relates to ~~WT-10243~~ [ ~~WT-10243~~ ]

Smita Pawar (Inactive) made changes - 20/Jul/17 01:27 PM

Remaining Estimate	55.5h [ 199800 ]	54.5h [ 196200 ]
Time Spent	104.5h [ 376200 ]	105.5h [ 379800 ]
Worklog Id		65112 [ 65112 ]

Smita Pawar (Inactive) made changes - 31/Jul/17 02:05 PM

Link

This issue relates to ~~WT-10032~~ [ ~~WT-10032~~ ]

Smita Pawar (Inactive) made changes - 03/Aug/17 12:48 PM

Assignee

Smita Pawar [ smita.pawar ]

Yogesh Chaudhari [ yogesh.chaudhari ]

Smita Pawar (Inactive) made changes - 16/Aug/17 10:27 AM

Production Due Date	07/Mar/2017	07/Sep/2017
Stage Due Date		28/Aug/17 [ 2017-08-28 ]

Revansiddha Gaur (Inactive) made changes - 09/Nov/17 01:09 PM

Remaining Estimate	54.5h [ 196200 ]	52.5h [ 189000 ]
Time Spent	105.5h [ 379800 ]	107.5h [ 387000 ]
Worklog Id		89928 [ 89928 ]

Yogesh Chaudhari (Inactive) made changes - 09/Nov/17 01:55 PM

Remaining Estimate	52.5h [ 189000 ]	46.5h [ 167400 ]
Time Spent	107.5h [ 387000 ]	113.5h [ 408600 ]
Worklog Id		89953 [ 89953 ]

Ramya Tantry (Inactive) made changes - 10/Nov/17 11:47 AM

Remaining Estimate	46.5h [ 167400 ]	45h [ 162000 ]
Time Spent	113.5h [ 408600 ]	115h [ 414000 ]
Worklog Id		90139 [ 90139 ]

Yogesh Chaudhari (Inactive) made changes - 13/Nov/17 01:24 PM

Remaining Estimate	45h [ 162000 ]	37.5h [ 135000 ]
Time Spent	115h [ 414000 ]	122.5h [ 441000 ]
Worklog Id		90492 [ 90492 ]

Ramya Tantry (Inactive) made changes - 14/Nov/17 04:30 AM

Remaining Estimate	37.5h [ 135000 ]	35h [ 126000 ]
Time Spent	122.5h [ 441000 ]	125h [ 450000 ]
Worklog Id		90577 [ 90577 ]

Revansiddha Gaur (Inactive) made changes - 14/Nov/17 05:12 AM

Remaining Estimate	35h [ 126000 ]	29.5h [ 106200 ]
Time Spent	125h [ 450000 ]	130.5h [ 469800 ]
Worklog Id		90599 [ 90599 ]

Ramya Tantry (Inactive) made changes - 15/Nov/17 04:10 AM

Remaining Estimate	29.5h [ 106200 ]	28.5h [ 102600 ]
Time Spent	130.5h [ 469800 ]	131.5h [ 473400 ]
Worklog Id		90834 [ 90834 ]

Yogesh Chaudhari (Inactive) made changes - 15/Nov/17 01:05 PM

Remaining Estimate	28.5h [ 102600 ]	20.5h [ 73800 ]
Time Spent	131.5h [ 473400 ]	139.5h [ 502200 ]
Worklog Id		90953 [ 90953 ]

Yogesh Chaudhari (Inactive) made changes - 29/Nov/17 09:33 AM

Link

This issue relates to ~~WT-8255~~ [ ~~WT-8255~~ ]

Revansiddha Gaur (Inactive) made changes - 04/Dec/17 07:22 AM

Link

This issue relates to ~~WT-12168~~ [ ~~WT-12168~~ ]

Yogesh Chaudhari (Inactive) made changes - 15/Dec/17 01:20 PM

Attachment

TechSpec_WT-8296_Prime_Automation_IsRequired_Field_Export.doc [ 70177 ]

Yogesh Chaudhari (Inactive) made changes - 15/Dec/17 01:21 PM

Assignee

Yogesh Chaudhari [ yogesh.chaudhari ]

Revansiddha Gaur [ revansiddha.gaur ]

Revansiddha Gaur (Inactive) made changes - 28/Dec/17 07:05 AM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Parent values: Development(10200)Level 1 values: On Hold(10207)

Revansiddha Gaur (Inactive) made changes - 28/Dec/17 07:12 AM

Link

This issue relates to ~~WT-12790~~ [ ~~WT-12790~~ ]

Smita Pawar (Inactive) made changes - 28/Dec/17 09:17 AM

Status

Local Testing [ 10200 ]

Reopen in Local [ 10018 ]

Sachin Hingole (Inactive) made changes - 05/Mar/18 05:14 AM

Status

Reopen in Local [ 10018 ]

In Development [ 10007 ]

Revansiddha Gaur (Inactive) made changes - 05/Mar/18 07:12 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Revansiddha Gaur (Inactive) made changes - 05/Mar/18 07:12 AM

Status

Local Testing [ 10200 ]

Pending for Stage Approval [ 10300 ]

Revansiddha Gaur (Inactive) made changes - 05/Mar/18 07:12 AM

Status

Pending for Stage Approval [ 10300 ]

Approved for Stage [ 10030 ]

Revansiddha Gaur (Inactive) made changes - 05/Mar/18 07:12 AM

Status

Approved for Stage [ 10030 ]

Stage Testing [ 10201 ]

Revansiddha Gaur (Inactive) made changes - 05/Mar/18 07:12 AM

Status

Stage Testing [ 10201 ]

Pending for Production Approval [ 10301 ]

Revansiddha Gaur (Inactive) made changes - 05/Mar/18 07:12 AM

Status

Pending for Production Approval [ 10301 ]

Approved for production [ 10034 ]

Revansiddha Gaur (Inactive) made changes - 05/Mar/18 07:12 AM

Status

Approved for production [ 10034 ]

Production Testing [ 10202 ]

Revansiddha Gaur (Inactive) made changes - 05/Mar/18 07:16 AM

Attachment

ACA Prime File Process for year 2018.pdf [ 74044 ]

Revansiddha Gaur (Inactive) made changes - 05/Mar/18 07:20 AM

Assignee	Revansiddha Gaur [ revansiddha.gaur ]	Amit Thorve [ amitthorve ]
Resolution		Cancelled [ 10300 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Revansiddha Gaur (Inactive) made changes - 05/Mar/18 07:20 AM

Resolution	Cancelled [ 10300 ]
Status	Production Complete [ 10028 ]	Closed [ 6 ]

Revansiddha Gaur (Inactive) made changes - 06/Mar/18 04:04 AM

Remaining Estimate	20.5h [ 73800 ]	20h [ 72000 ]
Time Spent	139.5h [ 502200 ]	140h [ 504000 ]
Worklog Id		107135 [ 107135 ]

Revansiddha Gaur (Inactive) made changes - 06/Mar/18 04:30 AM

Remaining Estimate	20h [ 72000 ]	19.5h [ 70200 ]
Time Spent	140h [ 504000 ]	140.5h [ 505800 ]
Worklog Id		107139 [ 107139 ]

People

Assignee:: Amit Thorve (Inactive)

Reporter:: Nandkumar Prabhakar Karlekar (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 06/Feb/17 06:01 AM

Updated:: 06/Mar/18 04:30 AM

Pre-Prod Due Date:: 28/Aug/2017

Production Due Date:: 07/Sep/2017

Code Review Date:: 16/May/2017

Time Tracking

Estimated:

160h

Remaining:

19.5h

Logged:

140.5h