-
Type:
Bug
-
Status: Closed
-
Priority:
High
-
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
Env: LB
Company: ACA Automation
SSN:100000030
Step:-
1.Login to application
2.Navigate to Import Export > Manual Import Export >Select Export radio button>BSG-S
3.From date -07/01/2016-07/15/2016
4.Click on Export button
5.Download file
Employee enrolled in Medical plan on 01/01/2016.
Terminated on 04/01/2016.
Rehired on 07/01/2016
Actual:-Employee was not on the full file of Jan and Jul
Expected:-Employee should come on the file of Jan and Jul if deleted run rate maintenance
Note: Please delete run-rate maintenance as its a full file. Let us know if you need any additional information.
- relates to
-
WT-2601 BSG ACA Reporting
-
- Closed
-
Smita Pawar (Inactive)
created issue -
Smita Pawar (Inactive)
made changes -
| Status | Open [ 1 ] | In Development [ 10007 ] |
Smita Pawar (Inactive)
made changes -
| Description |
Env: LB Company: ACA Automation SSN:100000030 Step:- 1.Login to application 2.Navigate to Import Export > Manual Import Export >Select Export radio button>BSG-S 3.From date -07/01/2016-07/15/2016 4.Click on Export button 5.Download file Employee enrolled in Medical plan on 01/01/2016. Terminated on 04/01/2016. Rehired on 07/01/2016 Actual:-Employee was not on the full file of Jan and Sep Expected:-Employee should come on the file of Jan and Sep if deleted run rate maintenance Note: Please delete run-rate maintenance as its a full file. Let us know if you need any additional information. |
Env: LB Company: ACA Automation SSN:100000030 Step:- 1.Login to application 2.Navigate to Import Export > Manual Import Export >Select Export radio button>BSG-S 3.From date -07/01/2016-07/15/2016 4.Click on Export button 5.Download file Employee enrolled in Medical plan on 01/01/2016. Terminated on 04/01/2016. Rehired on 07/01/2016 Actual:-Employee was not on the full file of Jan and Jul Expected:-Employee should come on the file of Jan and Sep if deleted run rate maintenance Note: Please delete run-rate maintenance as its a full file. Let us know if you need any additional information. |
Smita Pawar (Inactive)
made changes -
| Description |
Env: LB Company: ACA Automation SSN:100000030 Step:- 1.Login to application 2.Navigate to Import Export > Manual Import Export >Select Export radio button>BSG-S 3.From date -07/01/2016-07/15/2016 4.Click on Export button 5.Download file Employee enrolled in Medical plan on 01/01/2016. Terminated on 04/01/2016. Rehired on 07/01/2016 Actual:-Employee was not on the full file of Jan and Jul Expected:-Employee should come on the file of Jan and Sep if deleted run rate maintenance Note: Please delete run-rate maintenance as its a full file. Let us know if you need any additional information. |
Env: LB Company: ACA Automation SSN:100000030 Step:- 1.Login to application 2.Navigate to Import Export > Manual Import Export >Select Export radio button>BSG-S 3.From date -07/01/2016-07/15/2016 4.Click on Export button 5.Download file Employee enrolled in Medical plan on 01/01/2016. Terminated on 04/01/2016. Rehired on 07/01/2016 Actual:-Employee was not on the full file of Jan and Jul Expected:-Employee should come on the file of Jan and Jul if deleted run rate maintenance Note: Please delete run-rate maintenance as its a full file. Let us know if you need any additional information. |
| Assignee | Revansiddha Gaur [ revansiddha.gaur ] | Smita Pawar [ smita.pawar ] |
Gokul Sonawane (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Concern : Rehire employee is not coming on the file
Cause : Used EmploymentDate in select query condition.
Correction : Instead of employementdate used StatusChangeDate to get reflected on the file.
COID_NETSECUREID_BenefitsImport_20160811_153750.txt
| Attachment | COID_NETSECUREID_BenefitsImport_20160811_153750.txt [ 23926 ] |
Sachin Hingole (Inactive)
made changes -
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
We have verified above mentioned fix on LB. [ACA Automation company].
Its working fine, We have verified scenario with same mentioned employee.
Scenarios tested are as follows
1.Tested whether employee is on the file when employee's status is Active
2.Tested whether employee is on the file when employee's status is Terminated
3.Tested whether employee is on the file when employee's status is Rehire
We will move this fix to Stage with BSG file implementation,
Hence currently marking as LB Hold
Smita Pawar (Inactive)
added a comment - We have verified above mentioned fix on LB. [ACA Automation company] .
Its working fine, We have verified scenario with same mentioned employee.
Scenarios tested are as follows
1.Tested whether employee is on the file when employee's status is Active
2.Tested whether employee is on the file when employee's status is Terminated
3.Tested whether employee is on the file when employee's status is Rehire
We will move this fix to Stage with BSG file implementation,
Hence currently marking as LB Hold Smita Pawar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
Smita Pawar (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: On Hold(10211) |
Gokul Sonawane (Inactive)
made changes -
| Item State | Parent values: LB QA(10201)Level 1 values: On Hold(10211) | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
Smita Pawar (Inactive)
made changes -
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
We have verified above mentioned issue on Stage [For ACA BSG Test ACAAutomation].
Its working fine.
We have verified for same employee i.e having SSN: 100000030
Smita Pawar (Inactive)
added a comment - - edited We have verified above mentioned issue on Stage [For ACA BSG Test ACAAutomation] .
Its working fine.
We have verified for same employee i.e having SSN: 100000030 Smita Pawar (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
We will move this with BSG-ACA enhancement
Smita Pawar (Inactive)
added a comment - We will move this with BSG-ACA enhancement Smita Pawar (Inactive)
made changes -
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) |
| Item State | Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) | Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) |
Sachin Hingole (Inactive)
made changes -
| 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 -
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
Sachin Hingole (Inactive)
made changes -
| Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
We have verified above mentioned issue on Production [ACA Automation].
Its working fine
EEID|100000030|100000030|PAUL||TUNNERO|M|08/07/1979
OFFR|100000030|Qualifying Event - Admin Change|Qualifying Event - Admin Change|01/01/2016|01/01/2016|01/01/2016|12/31/2016|08/08/2016 07:15:25.937000 PM
ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|Yes|240.00|410.00|Y|Y|Y|Y|Y|63.08|Y|
ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE+Family|Employee + Family|No|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + CH|Employee + 1|No|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + SP|Employee + Spouse|No|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE|Employee|Yes|50.00|350.00|Y|Y|Y|Y|Y|87.50|Y|
ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE+Family|Employee + Family|No|75.00|175.00|Y|Y|Y|Y|Y|70.00|Y|
ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + CH|Employee + 1|No|65.00|160.00|Y|Y|Y|Y|Y|71.11|Y|
ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + SP|Employee + Spouse|No|60.00|175.00|Y|Y|Y|Y|Y|74.47|Y|
ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|Employee + Child|Employee + Child|No|70.00|180.00|Y|Y|Y|Y|Y|72.00|Y|
COVG|100000030|Qualifying Event - Admin Change|01/01/2016|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|240.00|410.00|01/01/2016|04/01/2016|||||||08/08/2016 07:19:29.000000 PM
Smita Pawar (Inactive)
added a comment - We have verified above mentioned issue on Production [ACA Automation] .
Its working fine
EEID|100000030|100000030|PAUL||TUNNERO|M|08/07/1979
OFFR|100000030|Qualifying Event - Admin Change|Qualifying Event - Admin Change|01/01/2016|01/01/2016|01/01/2016|12/31/2016|08/08/2016 07:15:25.937000 PM
ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|Yes|240.00|410.00|Y|Y|Y|Y|Y|63.08|Y|
ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE+Family|Employee + Family|No|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + CH|Employee + 1|No|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + SP|Employee + Spouse|No|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE|Employee|Yes|50.00|350.00|Y|Y|Y|Y|Y|87.50|Y|
ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE+Family|Employee + Family|No|75.00|175.00|Y|Y|Y|Y|Y|70.00|Y|
ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + CH|Employee + 1|No|65.00|160.00|Y|Y|Y|Y|Y|71.11|Y|
ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + SP|Employee + Spouse|No|60.00|175.00|Y|Y|Y|Y|Y|74.47|Y|
ELIG|100000030|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|Employee + Child|Employee + Child|No|70.00|180.00|Y|Y|Y|Y|Y|72.00|Y|
COVG|100000030|Qualifying Event - Admin Change|01/01/2016|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|240.00|410.00|01/01/2016|04/01/2016|||||||08/08/2016 07:19:29.000000 PM Smita Pawar (Inactive)
made changes -
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
Smita Pawar (Inactive)
made changes -
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
1d 6h 32m | 1 |
Sachin Hingole (Inactive)
made transition
-
|
1d 16h 11m | 1 |
Smita Pawar (Inactive)
made transition
-
|
10d 5h 25m | 1 |
Sachin Hingole (Inactive)
made transition
-
|
16d 23h 28m | 1 |
Smita Pawar (Inactive)
made transition
-
|
2h 52m | 1 |
Smita Pawar (Inactive)
made transition
-
|
2s | 1 |
Please correct the description. As export file period is of July but expected results of Jan and Sept.