[WT-3438] BSG : - ADP Health Compliance Benefits Import Pipe Delimited-2.51 - Workterra Jira

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
Company:
BDG
Item State:
Production Complete - Closed
Issue Importance:
Must Have

Dev Estimates:
35
Code Reviewed By:

Rohan Khandave

Attachments

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

Attachments

BSG test cases-HEAD-Naming convention-ELIG-COVG .xls
55 kB
27/Jul/16 11:34 AM
Plan_Eligibility_Scenario.txt
11 kB
26/Jul/16 12:57 PM
Plan_Eligibility_Scenario.txt
11 kB
26/Jul/16 12:57 PM
Test_Case_BSG_Pipe_Delimited.xls
78 kB
26/Jul/16 12:57 PM
Valmet Non-employee 20161116.zip
12 kB
16/Nov/16 06:21 PM

Issue Links

relates to

WT-3387 Creating the underline data for ACA Eligibility

Closed

WT-3388 Development of new fields for OFFR Sub-Template

Closed

WT-3389 Development of new fields for ELIG template

Closed

WT-3390 Creating and formatting the ACA Offer and eligibility data for export

Closed

WT-3391 Development of new fields for the Cov template

Closed

WT-3392 Initial Load/change file

Closed

WT-3393 Header /footer development

Closed

WT-2601 BSG ACA Reporting

Closed

(3 relates to)

Activity

Ascending order - Click to sort in descending order

Nandkumar Prabhakar Karlekar (Inactive) created issue - 07/Jul/16 10:06 AM

Nandkumar Prabhakar Karlekar (Inactive) made changes - 07/Jul/16 10:08 AM

Field	Original Value	New Value
Company		BDG [ 10413 ]
Component/s		ACA [ 10004 ]
Issue Importance		Must Have [ 11800 ]
Item State		Parent values: Development(10200)Level 1 values: In Progress(10206)
Module	Parent values: BenAdmin(10100)	Parent values: ACA(10104)Level 1 values: Reports(12001)
Priority	Medium [ 3 ]	High [ 2 ]
Summary	ADP Health Compliance Benefits Import Pipe Delimited-2.51	BSG : - ADP Health Compliance Benefits Import Pipe Delimited-2.51

Nandkumar Prabhakar Karlekar (Inactive) made changes - 07/Jul/16 10:10 AM

Link

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

Nandkumar Prabhakar Karlekar (Inactive) made changes - 07/Jul/16 10:10 AM

Link

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

Nandkumar Prabhakar Karlekar (Inactive) made changes - 07/Jul/16 10:11 AM

Link

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

Nandkumar Prabhakar Karlekar (Inactive) made changes - 07/Jul/16 10:11 AM

Link

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

Nandkumar Prabhakar Karlekar (Inactive) made changes - 07/Jul/16 10:11 AM

Link

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

Nandkumar Prabhakar Karlekar (Inactive) made changes - 07/Jul/16 10:11 AM

Link

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

Nandkumar Prabhakar Karlekar (Inactive) made changes - 07/Jul/16 10:11 AM

Link

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

Hide

Permalink

Nandkumar Prabhakar Karlekar (Inactive) added a comment - 07/Jul/16 10:15 AM - edited

This JIRA is the main JIRA Ticket for the ADP Health Compliance Benefits Import Pipe Delimited-2.51 specification. all sub task's JIRA ID is linked with proper estimation ans assignee with that specific task. Dev Due Date: also mentioned in this JIRA

Show

Nandkumar Prabhakar Karlekar (Inactive) added a comment - 07/Jul/16 10:15 AM - edited This JIRA is the main JIRA Ticket for the ADP Health Compliance Benefits Import Pipe Delimited-2.51 specification. all sub task's JIRA ID is linked with proper estimation ans assignee with that specific task. Dev Due Date: also mentioned in this JIRA

Nandkumar Prabhakar Karlekar (Inactive) made changes - 07/Jul/16 10:20 AM

Link

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

Mahendra Mungase (Inactive) made changes - 26/Jul/16 12:57 PM

Attachment

Test_Case_BSG_Pipe_Delimited.xls [ 22707 ]

Mahendra Mungase (Inactive) made changes - 26/Jul/16 12:57 PM

Attachment

Plan_Eligibility_Scenario.txt [ 22708 ]

Mahendra Mungase (Inactive) made changes - 26/Jul/16 12:57 PM

Attachment

Plan_Eligibility_Scenario.txt [ 22709 ]

Hide

Permalink

Mahendra Mungase (Inactive) added a comment - 26/Jul/16 12:57 PM

Hello Sachin Hingole

Please find attached test cases for BSG group.

I have written test cases for below points

1.EEID

2.OFFER

3.Dependent

and Scenario for ELIG.

Thanks,

Mahendra.

Show

Mahendra Mungase (Inactive) added a comment - 26/Jul/16 12:57 PM Hello Sachin Hingole Please find attached test cases for BSG group. I have written test cases for below points 1.EEID 2.OFFER 3.Dependent and Scenario for ELIG. Thanks, Mahendra.

Smita Pawar (Inactive) made changes - 27/Jul/16 11:22 AM

Attachment

Smita BSG test cases.xls [ 22753 ]

Smita Pawar (Inactive) made changes - 27/Jul/16 11:29 AM

Attachment

Smita BSG test cases.xls [ 22753 ]

Smita Pawar (Inactive) made changes - 27/Jul/16 11:34 AM

Attachment

BSG test cases-HEAD-Naming convention-ELIG-COVG .xls [ 22754 ]

Hide

Permalink

Smita Pawar (Inactive) added a comment - 27/Jul/16 11:40 AM

FYI Sachin Hingole,Nandkumar Prabhakar Karlekar,

We have added test cases for BSG Pipe delimiter file.

Hi Debbie Kulling,

Request you to go through the attached test cases files and let us know if any corrections are needed from our side.

Thanks,
Smita

Show

Smita Pawar (Inactive) added a comment - 27/Jul/16 11:40 AM FYI Sachin Hingole , Nandkumar Prabhakar Karlekar , We have added test cases for BSG Pipe delimiter file. Hi Debbie Kulling , Request you to go through the attached test cases files and let us know if any corrections are needed from our side. Thanks, Smita

Nandkumar Prabhakar Karlekar (Inactive) made changes - 27/Jul/16 12:32 PM

Assignee

Nandkumar [ satyap ]

Debbie Kulling [ dkulling ]

Smita Pawar (Inactive) made changes - 19/Aug/16 01:21 PM

Assignee

Debbie Kulling [ dkulling ]

Smita Pawar [ smita.pawar ]

Smita Pawar (Inactive) made changes - 19/Aug/16 01:21 PM

Item State

Parent values: Development(10200)Level 1 values: In Progress(10206)

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

Smita Pawar (Inactive) made changes - 19/Aug/16 01:21 PM

Status

New Request [ 10029 ]

Product Backlog [ 10100 ]

Smita Pawar (Inactive) made changes - 19/Aug/16 01:21 PM

Status

Product Backlog [ 10100 ]

Pending for Approval [ 10002 ]

Smita Pawar (Inactive) made changes - 19/Aug/16 01:21 PM

Status

Pending for Approval [ 10002 ]

Approved for Development [ 10003 ]

Smita Pawar (Inactive) made changes - 19/Aug/16 01:22 PM

Status

Approved for Development [ 10003 ]

In Development [ 10007 ]

Smita Pawar (Inactive) made changes - 19/Aug/16 01:22 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Smita Pawar (Inactive) made changes - 19/Aug/16 01:22 PM

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)

Hide

Permalink

Smita Pawar (Inactive) added a comment - 19/Aug/16 01:23 PM

We have completed the testing for this enhancement on LB and executed the test cases.

Show

Smita Pawar (Inactive) added a comment - 19/Aug/16 01:23 PM We have completed the testing for this enhancement on LB and executed the test cases.

Smita Pawar (Inactive) made changes - 29/Aug/16 07:24 AM

Status

Local Testing [ 10200 ]

Pending for Stage Approval [ 10300 ]

Smita Pawar (Inactive) made changes - 29/Aug/16 07:24 AM

Status

Pending for Stage Approval [ 10300 ]

Approved for Stage [ 10030 ]

Smita Pawar (Inactive) made changes - 29/Aug/16 07:25 AM

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)

Smita Pawar (Inactive) made changes - 29/Aug/16 07:25 AM

Status

Approved for Stage [ 10030 ]

Stage Testing [ 10201 ]

Rakesh Roy (Inactive) made changes - 07/Sep/16 06:23 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Rakesh Roy (Inactive) made changes - 07/Sep/16 06:23 AM

Status

Stage Testing [ 10201 ]

Pending for Production Approval [ 10301 ]

Rakesh Roy (Inactive) made changes - 07/Sep/16 06:23 AM

Status

Pending for Production Approval [ 10301 ]

Approved for production [ 10034 ]

Rakesh Roy (Inactive) made changes - 07/Sep/16 06:23 AM

Status

Approved for production [ 10034 ]

Production Testing [ 10202 ]

Hide

Permalink

Mahendra Mungase (Inactive) added a comment - 08/Sep/16 12:22 PM

We have completed the testing for this enhancement on Production and executed the test cases.

Show

Mahendra Mungase (Inactive) added a comment - 08/Sep/16 12:22 PM We have completed the testing for this enhancement on Production and executed the test cases.

Mahendra Mungase (Inactive) made changes - 08/Sep/16 12:22 PM

Resolution		Done [ 10000 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Mahendra Mungase (Inactive) made changes - 08/Sep/16 12:22 PM

Resolution	Done [ 10000 ]	Fixed [ 1 ]
Status	Production Complete [ 10028 ]	Closed [ 6 ]

Mahendra Mungase (Inactive) made changes - 08/Sep/16 12:22 PM

Item State

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Hide

Permalink

Mahendra Mungase (Inactive) added a comment - 18/Oct/16 12:33 PM

Hi Debbie Kulling

Below are the file path

URL - https://ftpsecure.ebsbenefits.com/thinclient/Transfer.aspx

1.FTP Path - /users/workterraaca/BSG ACA/Valmet ADP File/09272016
File Name- Valmet_09272016.zip

2.FTP Path - /users/workterraaca/BSG ACA/Valmet ADP File/Multiemployer
File Name - Valmet-Multiemployer-09302016.zip

3.FTP Path -/users/workterraaca/BSG ACA/Valmet ADP File/NonEmployee/Oct 7, 2016
File name – Valmet-Non-Employee-10072016.zip

Show

Mahendra Mungase (Inactive) added a comment - 18/Oct/16 12:33 PM Hi Debbie Kulling Below are the file path URL - https://ftpsecure.ebsbenefits.com/thinclient/Transfer.aspx 1.FTP Path - /users/workterraaca/BSG ACA/Valmet ADP File/09272016 File Name- Valmet_09272016.zip 2.FTP Path - /users/workterraaca/BSG ACA/Valmet ADP File/Multiemployer File Name - Valmet-Multiemployer-09302016.zip 3.FTP Path -/users/workterraaca/BSG ACA/Valmet ADP File/NonEmployee/Oct 7, 2016 File name – Valmet-Non-Employee-10072016.zip

Hide

Permalink

Sachin Hingole (Inactive) added a comment - 21/Oct/16 01:32 PM

Hi Debbie Kulling

We have uploaded Benefit Import and Multi-Employer files on EBS FTP.
These files are retrieved from “Valmet Benefits” production company.
Below are the FTP details. Zip has Benefit Import and Multi-Employer files.

FTP URL - https://ftpsecure.ebsbenefits.com
Folder Path - /users/workterraaca/BSG ACA/Valmet ADP File/10212016
File Name - ActiveEE&MultiEmployer-JAN2016.zip

We are working on change file for Benefit Import and We will share it in next week.
Multiemployer template will have only full file no change files for subsequent months.

Please note employee SSN 209480860 is not eligible to any of the active plan and he had enrolled in Medical Opt out plan.
So eligibility element is not reflected on file.

Thanks,
Sachin Hingole

shyam sharma Rakesh Roy Nandkumar Prabhakar Karlekar Smita Pawar Revansiddha Gaur Yogesh Chaudhari Mahendra Mungase

Show

Sachin Hingole (Inactive) added a comment - 21/Oct/16 01:32 PM Hi Debbie Kulling We have uploaded Benefit Import and Multi-Employer files on EBS FTP. These files are retrieved from “Valmet Benefits” production company. Below are the FTP details. Zip has Benefit Import and Multi-Employer files. FTP URL - https://ftpsecure.ebsbenefits.com Folder Path - /users/workterraaca/BSG ACA/Valmet ADP File/10212016 File Name - ActiveEE&MultiEmployer-JAN2016.zip We are working on change file for Benefit Import and We will share it in next week. Multiemployer template will have only full file no change files for subsequent months. Please note employee SSN 209480860 is not eligible to any of the active plan and he had enrolled in Medical Opt out plan. So eligibility element is not reflected on file. Thanks, Sachin Hingole shyam sharma Rakesh Roy Nandkumar Prabhakar Karlekar Smita Pawar Revansiddha Gaur Yogesh Chaudhari Mahendra Mungase

Cindy Wibbing (Inactive) made changes - 16/Nov/16 06:21 PM

Attachment

Valmet Non-employee 20161116.zip [ 32630 ]

Hide

Permalink

Cindy Wibbing (Inactive) added a comment - 16/Nov/16 06:23 PM

Hi Sachin Hingole
I have made the modifications to the Non-employee file and resubmitted the file to ADP. The file has passed.
I have attached the file that passed so that you can review against the original and make whatever changes are needed in your template/programming.
The file and changes made (changes.txt) are contained in the attached zip file called Valmet Non-employee 20161116.zip
Let me know if you have any questions.
Thanks!
Cindy

Show

Cindy Wibbing (Inactive) added a comment - 16/Nov/16 06:23 PM Hi Sachin Hingole I have made the modifications to the Non-employee file and resubmitted the file to ADP. The file has passed. I have attached the file that passed so that you can review against the original and make whatever changes are needed in your template/programming. The file and changes made (changes.txt) are contained in the attached zip file called Valmet Non-employee 20161116.zip Let me know if you have any questions. Thanks! Cindy

Hide

Permalink

Sachin Hingole (Inactive) added a comment - 17/Nov/16 09:51 AM

Hi Cindy Wibbing,

We have shared latest Non-EE file from Valmet Production on 9-Nov-2016, refer JIRA EDI-1041.
We have taken care of the points mentioned in text files from "Valmet Non-employee 20161116.zip" in the Non-EE file shared on 9-Nov-2016.

Let us know if you need any other details.

Thanks,
Sachin Hingole

Nandkumar Prabhakar Karlekar shyam sharma Rakesh Roy Mahendra Mungase Revansiddha Gaur

Show

Sachin Hingole (Inactive) added a comment - 17/Nov/16 09:51 AM Hi Cindy Wibbing , We have shared latest Non-EE file from Valmet Production on 9-Nov-2016, refer JIRA EDI-1041. We have taken care of the points mentioned in text files from "Valmet Non-employee 20161116.zip" in the Non-EE file shared on 9-Nov-2016. Let us know if you need any other details. Thanks, Sachin Hingole Nandkumar Prabhakar Karlekar shyam sharma Rakesh Roy Mahendra Mungase Revansiddha Gaur

Transition	Time In Source Status	Execution Times

Smita Pawar (Inactive) made transition - 19/Aug/16 01:21 PM

New Request

Product Backlog

43d 3h 15m

Smita Pawar (Inactive) made transition - 19/Aug/16 01:21 PM

Product Backlog

Pending for Approval

Smita Pawar (Inactive) made transition - 19/Aug/16 01:21 PM

Pending for Approval

Approved for Development

Smita Pawar (Inactive) made transition - 19/Aug/16 01:22 PM

Approved for Development

In Development

Smita Pawar (Inactive) made transition - 19/Aug/16 01:22 PM

In Development

In LB Testing

11s

Smita Pawar (Inactive) made transition - 29/Aug/16 07:24 AM

In LB Testing

Pending for Stage Approval

9d 18h 2m

Smita Pawar (Inactive) made transition - 29/Aug/16 07:24 AM

Pending for Stage Approval

Approved for Stage

Smita Pawar (Inactive) made transition - 29/Aug/16 07:25 AM

Approved for Stage

Stage Testing

18s

Rakesh Roy (Inactive) made transition - 07/Sep/16 06:23 AM

Stage Testing

Pending for Production Approval

8d 22h 58m

Rakesh Roy (Inactive) made transition - 07/Sep/16 06:23 AM

Pending for Production Approval

Approved for production

Rakesh Roy (Inactive) made transition - 07/Sep/16 06:23 AM

Approved for production

In Production Testing

Mahendra Mungase (Inactive) made transition - 08/Sep/16 12:22 PM

In Production Testing

Production Complete

1d 5h 58m

Mahendra Mungase (Inactive) made transition - 08/Sep/16 12:22 PM

Production Complete

Closed

People

Assignee:: Smita Pawar (Inactive)

Reporter:: Nandkumar Prabhakar Karlekar (Inactive)

Account Executive:: Debbie Kulling

Developer:: Revansiddha Gaur (Inactive)

QA:: Sachin Hingole (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 07/Jul/16 10:06 AM

Updated:: 17/Nov/16 09:51 AM

Resolved:: 08/Sep/16 12:22 PM

Dev Due Date:: 29/Jul/2016

Code Review Date:: 20/Jul/2016