Files Affected :
/WORKTERRAweb/Web/Web Projects/BenAdmin/Areas/Report/Models/CommonReportsModel/ReportFieldsMappingPVModel.cs : Passed Report Type to identify Employee census report
/WORKTERRAweb/App/BusinessLogic/CollectionManager/CollectionManager.vb : checked for Employee census report and gave call to new SP 'OES_SP_GetAddFieldReportsEducationAndCertificateLabelForEmployeeCensusReport' which creates fields for Education and Certificate details for Select Field in UI
/WORKTERRAweb/App/BusinessLogic/Reports/RDLGenerator.vb : called two new SPs 'OES_SP_Report_FillPostSecondaryInfoMatrixWise' and 'OES_SP_Report_FillCertificateInfoMatrixWise' which will create new table for Matrixwise records of Education and certificate detail.Bind these columns in select field and joins.
/WORKTERRAweb/App/BusinessLogic/Reports/ReportDetails.vb : Bind Education and certificate fields in RDL

Database changes :
Addition of three new SPs
1. OES_SP_GetAddFieldReportsEducationAndCertificateLabelForEmployeeCensusReport : Create fields for Educations and certification details
2. OES_SP_Report_FillPostSecondaryInfoMatrixWise : Create matrix wise record from existing table Employee_PostSecondaryInfo
3. OES_SP_Report_FillCertificateInfoMatrixWise :Create matrix wise record from existing table Employee_CertificateInfo

System displayed server error on reports.
Not able to test Enhancement
Error log:-Exception : Could not find stored procedure `OES_SP_Report_FillPostSecondaryInfoMatrixWise`.
App Error Log : ControllerAppTier.Save->BenAdminControllerAppTier.Save->ReportDetails.Save->ReportDetails.PopulateLists
Employee ID : 0
Action Name : SavePreviewReport
Model : System.Web.Mvc.HandleErrorInfo
Controller : Report
Web Error Log : at WORKTERRA.BenAdmin.BenAdminControllerWebTier.Save(ObjectType I_objectType, Object objInputObject, Object I_context, Boolean I_mode) in d:\WT\branches\LB\Web\ControllerWebTier\ControllerWebTier\BenAdminControllerWebTier.cs:line 44
at WORKTERRA.BenAdmin.Areas.Report.Models.StandardReportsModel.PreviewReport() in d:\WT\branches\LB\Web\Web Projects\BenAdmin\Areas\Report\Models\StandardReportsModel\StandardReportsModel.cs:line 347
at WORKTERRA.BenAdmin.Areas.Report.Controllers.ReportController.PreviewReport(StandardReportsModel objStandardReportsModel) in d:\WT\branches\LB\Web\Web Projects\BenAdmin\Areas\Report\Controllers\StandardReportsController\StandardReportsController.cs:line 234
at WORKTERRA.BenAdmin.Areas.Report.Controllers.ReportController.SavePreviewReport(StandardReportsModel objStandardReportsModel, String SubmitType) in d:\WT\branches\LB\Web\Web Projects\BenAdmin\Areas\Report\Controllers\StandardReportsController\StandardReportsController.cs:line 205
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass42.<BeginInvokeSynchronousActionMethod>b_41()
at System.Web.Mvc.Async.AsyncResultWrapper.<>c_DisplayClass8`1.<BeginSynchronous>b_7(IAsyncResult _)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass37.<>cDisplayClass39.<BeginInvokeActionMethodWithFilters>b_33()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b_49()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass4f.<InvokeActionMethodFilterAsynchronously>b_49()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass37.<BeginInvokeActionMethodWithFilters>b_36(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass25.<>cDisplayClass2a.<BeginInvokeAction>b_20()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_DisplayClass25.<BeginInvokeAction>b_22(IAsyncResult asyncResult)

Working fine on Wt stage.
Verified on Austin company.
On Employee Census Report system displayed Education and certification field.
User can add these filed on report for new employee census report.
Employee data verified for existing employee & new hire employee.

Ready for stage.

Working fine on NAIT For HSPL
Verified Education & Certification information for New & existing employee. on employee Census report.

Ready for production.

Working fine on Prodcution
Verified on 1.ASML for hspl
2.LHP for hspl

Login:-1. Employee
2.Partner
1.Verified following points
1.Checked Education& Certification fields in Display And Group By Fields
2.On Employee Census report system displayed fields in Column.
3.Added information by Employee login
4.Verified added information on reports by partner login.
5.Deleted added information by partner login & verified on reports.
Checked for New hire employee & Existing Employee.

Working fine.

Working fine on production