-
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
-
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
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 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 We will move this with BSG-ACA enhancement
Smita Pawar (Inactive)
added a comment - We will move this with BSG-ACA enhancement 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 
Please correct the description. As export file period is of July but expected results of Jan and Sept.