Debbie Kulling This is deployed on production, please verify and confirm.

Hi Prasanna Karlekar

I have verified this issue on Stage

Verified with Partner Login

Verified for Following Scenarios :

1) Pulled "Employee Status Report" For Barrow For HSPL is in ACTIVE status
With Active company Barrow for HSPL.xls

2) Pulled "Employee Status Report " For Barrow for HSPL is in INACTIVE Status
With Inactive Company BArrow For HSPL.xls

3) Again Pulled Report for Same company with Active State
Again Activated Inactive company Barrow for HSPL.xls

4) Also Verified " Employee Census Report "
Employee Census Report.xls

5) Also Verified for "All Employee Status " under Classes and Status
Found One issue while testing this issue which is As discussed already Taken Care of in ticket WT-10799 LOCAL TESTING

Its working fine

Hence, Marking it as Ready for Production

cc: Sachin Hingole Rakesh Roy Prasad Pise

Thank You !

Hi Prasanna Karlekar

I have verified this issue on LB

Verified with Super Admin and Partner Login

Verified for Following Scenarios :

1) Pulled "Employee Status Report" For For QA ASML For HSPL is in ACTIVE status

BSG Report With ASML for HSPL as active.xls

2) Pulled "Employee Status Report " For For QA For ASML for HSPL is in INACTIVE Status

For QA ASML FOR HSPL inactive Status Report.xls

3) Again Pulled Report for Same company with Active State

Again ASML for QA hspl Activated.pdf

4) Also Verified " Employee Census Report "

Employee Census Report.xls

5) Also Verified for "All Employee Status " under Classes and Status
Found One issue while testing this issue which is As discussed already Taken Care of in ticket WT-10799

Its working fine

Hence, Marking it as Ready for Stage

cc:Sachin Hingole Prasad Pise Rakesh Roy

Thank You !

Hi Rakesh Roy

I have tested this issue for Active and Inactive companies

I will be discussing more impacted scenarios with [~meghana joshi]

Till the time testing is In Progress on LB

cc: Sachin Hingole Prasad Pise Hrishikesh Deshpande

Thank You !

[~meghana joshi]

Priya Handepatil Please make sure this is tested on priority once its deployed for testing.
Stage and production due date is 20 Sep and 21 Sep respectively.

[~meghana joshi]Prasanna Karlekar

Following are the 3 Cs:

Concern:
Ascension is an inactivated company and it is not in the list of selected companies but the data is still appearing on the report.

Cause:
Ascension company was active and selected when "Employee Status Report" was created. Now this company is InActive. On UI, for selection, only active companies are appear. Hence, Ascension is not appearing. On report, data was getting displayed for all selected companies irrespective of company status (Active / Inactive) at the time of report execution.

Correction:
We have added check to populate data on report as per company status (Active / Inactive) at the time of report execution. We have done this change Global level Employee Status and Employee Census report.

Affected Files:
WT/trunk/WORKTERRAweb/Database Objects/OnlineEnrollment/04_Stored
Procedures/dbo.OES_SP_InsertUpdateGlobalCensusReport.StoredProcedure.sql
WT/trunk/WORKTERRAweb/RDL/GlobalCensusAcrossCmp.rdl
WT/trunk/WORKTERRAweb/RDL/GlobalEmployeeCensusAcrossCmp.rdl

Impacted Areas:
Global Level - Employee Status Report
Global Level - Employee Census Report

Known Issue:
If all the previously selected companies are made inactive, then proper message needs to be displayed at the time of execution. For this we will create new JIRA.

Thank you!

Hi Debbie Kulling,

We are done with the code fix for this issue. It will get deployed in QA environment tomorrow. After that it will get deployed on Stage and Production as per process.

Thank you!

Hi Debbie Kulling,

Will check this in coming week and will update you by 7-Sep-2017.

Thank you!