[WT-5238] ACA - Employee only eligibility records should get on file for ADP Non employee - Workterra Jira

Details

Type: Change Request
Status: Closed
Priority: Medium
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: ACA
Labels:
None

Module:
ACA - Reports
Reported by:
Harbinger
Item State:
Production Complete - Closed
Issue Importance:
Must Have

Description

Currently we are populating all the eligibility records for all health tiers for ADP.

in case of ADP Non employee template, eligibility record should contain employee only ELIG records.

Attachments

Activity

Ascending order - Click to sort in descending order

Yogesh Chaudhari (Inactive) created issue - 04/Oct/16 10:04 AM

Yogesh Chaudhari (Inactive) made changes - 04/Oct/16 11:07 AM

Field	Original Value	New Value
Summary	Employee only eligibility records should get for ADP Non employee	Employee only eligibility records should get on file for ADP Non employee

Yogesh Chaudhari (Inactive) made changes - 04/Oct/16 11:51 AM

Summary

Employee only eligibility records should get on file for ADP Non employee

ACA - Employee only eligibility records should get on file for ADP Non employee

Yogesh Chaudhari (Inactive) made changes - 10/Oct/16 09:24 AM

Item State

Parent values: Development(10200)

Yogesh Chaudhari (Inactive) made changes - 12/Oct/16 07:04 AM

Status

New Request [ 10029 ]

Pending for Approval [ 10002 ]

Yogesh Chaudhari (Inactive) made changes - 12/Oct/16 07:04 AM

Status

Pending for Approval [ 10002 ]

Approved for Development [ 10003 ]

Yogesh Chaudhari (Inactive) made changes - 12/Oct/16 07:04 AM

Status

Approved for Development [ 10003 ]

In Development [ 10007 ]

Yogesh Chaudhari (Inactive) made changes - 12/Oct/16 09:20 AM

Assignee

Yogesh Chaudhari [ yogesh.chaudhari ]

Ramya Tantry [ ramya.tantry ]

Hide

Permalink

Yogesh Chaudhari (Inactive) added a comment - 12/Oct/16 09:23 AM

Hi Ramya Tantry Nandkumar Prabhakar Karlekar

As we discussed, I have exposed New indicator field to identify to execute eligibility for employee only tier.
Exposed field ID is 1526.

Show

Yogesh Chaudhari (Inactive) added a comment - 12/Oct/16 09:23 AM Hi Ramya Tantry Nandkumar Prabhakar Karlekar As we discussed, I have exposed New indicator field to identify to execute eligibility for employee only tier. Exposed field ID is 1526.

Ramya Tantry (Inactive) made changes - 21/Oct/16 12:04 PM

Item State

Parent values: Development(10200)

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

Ramya Tantry (Inactive) made changes - 24/Oct/16 09:01 AM

Code Reviewed By

Yogesh Chaudhari [ 13000 ]

Khandu Kshirsagar (Inactive) made changes - 24/Oct/16 11:08 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)

Hide

Permalink

Sachin Hingole (Inactive) added a comment - 24/Oct/16 02:25 PM - edited

As Yogesh having some network issue, and due to it he is not able to assign.
So as discussed with Yogesh this is already deployed on LB and its on priority so assigning to me.

Below field is exposed for ACA only template "ACA Export Eligibility ACA Eligibility Employee Tier Only" and it should be used for Non Employee template from BSG ADP files.

Show

Sachin Hingole (Inactive) added a comment - 24/Oct/16 02:25 PM - edited As Yogesh having some network issue, and due to it he is not able to assign. So as discussed with Yogesh this is already deployed on LB and its on priority so assigning to me. Below field is exposed for ACA only template "ACA Export Eligibility ACA Eligibility Employee Tier Only" and it should be used for Non Employee template from BSG ADP files.

Sachin Hingole (Inactive) made changes - 24/Oct/16 02:25 PM

Assignee

Ramya Tantry [ ramya.tantry ]

Sachin Hingole [ sachin.hingole ]

Sachin Hingole (Inactive) made changes - 24/Oct/16 02:25 PM

Status

In Development [ 10007 ]

Mockup Approval [ 10010 ]

Sachin Hingole (Inactive) made changes - 24/Oct/16 02:25 PM

Status

Mockup Approval [ 10010 ]

Mockup Approved [ 10012 ]

Sachin Hingole (Inactive) made changes - 24/Oct/16 02:25 PM

Status

Mockup Approved [ 10012 ]

In Development [ 10007 ]

Sachin Hingole (Inactive) made changes - 24/Oct/16 02:25 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Sachin Hingole (Inactive) made changes - 24/Oct/16 02:25 PM

Item State

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

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

Sachin Hingole (Inactive) made changes - 24/Oct/16 02:43 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

Sachin Hingole (Inactive) added a comment - 24/Oct/16 02:44 PM

Verified on LB, working fine.
Its showing lowest cost plan details on Eligibility records. Needs to add field on eligibility sub template and map it with "ACA Export Eligibility ACA Eligibility Employee Tier Only" field

Show

Sachin Hingole (Inactive) added a comment - 24/Oct/16 02:44 PM Verified on LB, working fine. Its showing lowest cost plan details on Eligibility records. Needs to add field on eligibility sub template and map it with "ACA Export Eligibility ACA Eligibility Employee Tier Only" field

Rakesh Roy (Inactive) made changes - 25/Oct/16 05:01 AM

Developer

Yogesh Chaudhari [ yogesh.chaudhari ]

Hide

Permalink

Ramya Tantry (Inactive) added a comment - 25/Oct/16 05:27 AM

Files affected:

Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_ACA_EligibilityForExport.sql

Show

Ramya Tantry (Inactive) added a comment - 25/Oct/16 05:27 AM Files affected: Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_ACA_EligibilityForExport.sql

Hide

Permalink

Yogesh Chaudhari (Inactive) added a comment - 25/Oct/16 06:00 AM

File Artifacts :

Database Objects/MasterCompanyDB/07_Data/144_~~WT-5238~~_WTB_ACA_NewData_Field.sql
Database Objects/OnlineEnrollment/07_Data/087_~~WT-5238~~_WTB_ACA_NewData_Field.sql

Show

Yogesh Chaudhari (Inactive) added a comment - 25/Oct/16 06:00 AM File Artifacts : Database Objects/MasterCompanyDB/07_Data/144_ WT-5238 _WTB_ACA_NewData_Field.sql Database Objects/OnlineEnrollment/07_Data/087_ WT-5238 _WTB_ACA_NewData_Field.sql

Khandu Kshirsagar (Inactive) made changes - 25/Oct/16 07:28 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)

Sachin Hingole (Inactive) made changes - 25/Oct/16 08:36 AM

Item State

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

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Sachin Hingole (Inactive) made changes - 25/Oct/16 08:36 AM

Status

Local Testing [ 10200 ]

Pending for Stage Approval [ 10300 ]

Sachin Hingole (Inactive) made changes - 25/Oct/16 08:36 AM

Status

Pending for Stage Approval [ 10300 ]

Approved for Stage [ 10030 ]

Sachin Hingole (Inactive) made changes - 25/Oct/16 08:36 AM

Status

Approved for Stage [ 10030 ]

Stage Testing [ 10201 ]

Hide

Permalink

Sachin Hingole (Inactive) added a comment - 25/Oct/16 08:37 AM

Verified on Stage, working fine.

Its showing lowest cost plan details on Eligibility records. Needs to add field on eligibility sub template and map it with "ACA Export Eligibility ACA Eligibility Employee Tier Only" field

Show

Sachin Hingole (Inactive) added a comment - 25/Oct/16 08:37 AM Verified on Stage, working fine. Its showing lowest cost plan details on Eligibility records. Needs to add field on eligibility sub template and map it with "ACA Export Eligibility ACA Eligibility Employee Tier Only" field

Sachin Hingole (Inactive) made changes - 25/Oct/16 12:52 PM

Item State

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Ashwin Wankhede (Inactive) made changes - 13/Nov/16 06:56 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

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

Sachin Hingole (Inactive) made changes - 15/Nov/16 05:46 AM

Status

Stage Testing [ 10201 ]

Pending for Production Approval [ 10301 ]

Sachin Hingole (Inactive) made changes - 15/Nov/16 05:46 AM

Status

Pending for Production Approval [ 10301 ]

Approved for production [ 10034 ]

Sachin Hingole (Inactive) made changes - 15/Nov/16 05:46 AM

Status

Approved for production [ 10034 ]

Production Testing [ 10202 ]

Sachin Hingole (Inactive) made changes - 15/Nov/16 05:46 AM

Item State

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

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

Sachin Hingole (Inactive) made changes - 15/Nov/16 05:57 AM

Item State

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

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

Hide

Permalink

Sachin Hingole (Inactive) added a comment - 15/Nov/16 05:58 AM

Verified on production, working fine.

Its showing lowest cost plan details on Eligibility records. Needs to add field on eligibility sub template and map it with "ACA Export Eligibility ACA Eligibility Employee Tier Only" field

Show

Sachin Hingole (Inactive) added a comment - 15/Nov/16 05:58 AM Verified on production, working fine. Its showing lowest cost plan details on Eligibility records. Needs to add field on eligibility sub template and map it with "ACA Export Eligibility ACA Eligibility Employee Tier Only" field

Sachin Hingole (Inactive) made changes - 15/Nov/16 05:58 AM

Resolution		Fixed [ 1 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Sachin Hingole (Inactive) made changes - 15/Nov/16 05:58 AM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

Transition	Time In Source Status	Execution Times

Yogesh Chaudhari (Inactive) made transition - 12/Oct/16 07:04 AM

New Request

Pending for Approval

7d 21h

Yogesh Chaudhari (Inactive) made transition - 12/Oct/16 07:04 AM

Pending for Approval

Approved for Development

Yogesh Chaudhari (Inactive) made transition - 12/Oct/16 07:04 AM

Approved for Development

In Development

Sachin Hingole (Inactive) made transition - 24/Oct/16 02:25 PM

In Development

Mockup Approval

12d 7h 20m

Sachin Hingole (Inactive) made transition - 24/Oct/16 02:25 PM

Mockup Approval

Mockup Approved

Sachin Hingole (Inactive) made transition - 24/Oct/16 02:25 PM

Mockup Approved

In Development

Sachin Hingole (Inactive) made transition - 24/Oct/16 02:25 PM

In Development

In LB Testing

Sachin Hingole (Inactive) made transition - 25/Oct/16 08:36 AM

In LB Testing

Pending for Stage Approval

18h 10m

Sachin Hingole (Inactive) made transition - 25/Oct/16 08:36 AM

Pending for Stage Approval

Approved for Stage

Sachin Hingole (Inactive) made transition - 25/Oct/16 08:36 AM

Approved for Stage

Stage Testing

Sachin Hingole (Inactive) made transition - 15/Nov/16 05:46 AM

Stage Testing

Pending for Production Approval

20d 22h 9m

Sachin Hingole (Inactive) made transition - 15/Nov/16 05:46 AM

Pending for Production Approval

Approved for production

Sachin Hingole (Inactive) made transition - 15/Nov/16 05:46 AM

Approved for production

In Production Testing

Sachin Hingole (Inactive) made transition - 15/Nov/16 05:58 AM

In Production Testing

Production Complete

11m 56s

Sachin Hingole (Inactive) made transition - 15/Nov/16 05:58 AM

Production Complete

Closed

People

Assignee:: Sachin Hingole (Inactive)

Reporter:: Yogesh Chaudhari (Inactive)

Developer:: Yogesh Chaudhari (Inactive)

QA:: Smita Pawar (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 04/Oct/16 10:04 AM

Updated:: 15/Nov/16 05:58 AM

Resolved:: 15/Nov/16 05:58 AM