[WT-1315] Education and Certificate Info field on "Employee Census Report" - Workterra Jira

Amnesh Goel (Inactive) created issue - 16/Mar/16 04:05 AM

Satya made changes - 16/Mar/16 10:12 AM

Field	Original Value	New Value
Item State		Parent values: Development(10200)Level 1 values: Development Backlog(10205)

Satya made changes - 17/Mar/16 09:18 AM

Status

New Request [ 10029 ]

Product Backlog [ 10100 ]

Satya made changes - 25/Mar/16 08:44 AM

Dev Estimates

42

Deepali Tidke (Inactive) made changes - 25/Mar/16 09:23 AM

QA Estimates

18

Jyoti Agrawal (Inactive) made changes - 30/Mar/16 05:29 AM

Item State

Parent values: Development(10200)Level 1 values: Development Backlog(10205)

Parent values: Development(10200)Level 1 values: In Analysis(10204)

admin made changes - 30/Mar/16 12:39 PM

Fix Version/s

1.0 [ 10000 ]

Rakesh Roy (Inactive) made changes - 04/Apr/16 10:31 AM

Status

Product Backlog [ 10100 ]

Pending for Approval [ 10002 ]

Rakesh Roy (Inactive) made changes - 04/Apr/16 10:31 AM

Status

Pending for Approval [ 10002 ]

Approved for Development [ 10003 ]

Rakesh Roy (Inactive) made changes - 04/Apr/16 10:32 AM

Status

Approved for Development [ 10003 ]

In Development [ 10007 ]

Rakesh Roy (Inactive) made changes - 04/Apr/16 10:32 AM

QA

Rajendra Joshi [ rajendraj ]

Rakesh Roy (Inactive) made changes - 05/Apr/16 02:58 PM

Account Executive

Jennifer Leugers [ jennifer.leugers ]

Amnesh Goel (Inactive) made changes - 06/Apr/16 12:19 PM

Dev Due Date

12/Apr/2016

Amnesh Goel (Inactive) made changes - 06/Apr/16 12:19 PM

Item State

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Parent values: Development(10200)Level 1 values: In Progress(10206)

Jyoti Agrawal (Inactive) made changes - 12/Apr/16 05:31 AM

Item State

Parent values: Development(10200)Level 1 values: In Progress(10206)

Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)

Satya made changes - 12/Apr/16 05:35 AM

Sprint

WT Sprint 1 [ 6 ]

Satya made changes - 12/Apr/16 05:35 AM

Rank

Ranked higher

Jyoti Agrawal (Inactive) made changes - 13/Apr/16 04:22 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Jyoti Agrawal (Inactive) made changes - 13/Apr/16 04:22 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)

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

Jyoti Agrawal (Inactive) made changes - 13/Apr/16 05:35 AM

Assignee

Jyoti Agrawal [ jyoti.agrawal ]

Rakesh Roy [ rakeshr ]

Rakesh Roy (Inactive) made changes - 13/Apr/16 05:37 AM

Assignee

Rakesh Roy [ rakeshr ]

Dhanashree Sherkar [ dhanashree.sherkar ]

Hide

Permalink

Jyoti Agrawal (Inactive) added a comment - 13/Apr/16 05:53 AM

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

Show

Jyoti Agrawal (Inactive) added a comment - 13/Apr/16 05:53 AM 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

Hide

Permalink

Dhanashree Sherkar (Inactive) added a comment - 13/Apr/16 12:14 PM - edited

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)

Show

Dhanashree Sherkar (Inactive) added a comment - 13/Apr/16 12:14 PM - edited 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.<>c DisplayClass39.<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.<>c DisplayClass2a.<BeginInvokeAction>b _20() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c_ DisplayClass25.<BeginInvokeAction>b _22(IAsyncResult asyncResult)

Dhanashree Sherkar (Inactive) made changes - 13/Apr/16 12:15 PM

Status

Local Testing [ 10200 ]

Reopen in Local [ 10018 ]

Dhanashree Sherkar (Inactive) made changes - 13/Apr/16 12:16 PM

Assignee

Dhanashree Sherkar [ dhanashree.sherkar ]

Jyoti Agrawal [ jyoti.agrawal ]

Hide

Permalink

Jyoti Agrawal (Inactive) added a comment - 14/Apr/16 12:44 PM

Dhanashree Sherkar This was script deployment issue in LB Report server.
We have executed script in company For QA LB Austin Ind. Please test in this company.

Show

Jyoti Agrawal (Inactive) added a comment - 14/Apr/16 12:44 PM Dhanashree Sherkar This was script deployment issue in LB Report server. We have executed script in company For QA LB Austin Ind . Please test in this company.

Jyoti Agrawal (Inactive) made changes - 14/Apr/16 12:44 PM

Assignee

Jyoti Agrawal [ jyoti.agrawal ]

Dhanashree Sherkar [ dhanashree.sherkar ]

Jyoti Agrawal (Inactive) made changes - 14/Apr/16 12:46 PM

Status

Reopen in Local [ 10018 ]

In Development [ 10007 ]

Jyoti Agrawal (Inactive) made changes - 14/Apr/16 12:46 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Hide

Permalink

Dhanashree Sherkar (Inactive) added a comment - 15/Apr/16 01:33 PM

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.

Show

Dhanashree Sherkar (Inactive) added a comment - 15/Apr/16 01:33 PM 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.

Dhanashree Sherkar (Inactive) made changes - 15/Apr/16 01:34 PM

Item State

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

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

Deepali Tidke (Inactive) made changes - 18/Apr/16 04:26 AM

Status

Local Testing [ 10200 ]

Pending for Stage Approval [ 10300 ]

Deepali Tidke (Inactive) made changes - 18/Apr/16 04:27 AM

Status

Pending for Stage Approval [ 10300 ]

Approved for Stage [ 10030 ]

Jyoti Agrawal (Inactive) made changes - 18/Apr/16 11:06 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)

Hide

Permalink

Dhanashree Sherkar (Inactive) added a comment - 18/Apr/16 12:13 PM

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

Ready for production.

Show

Dhanashree Sherkar (Inactive) added a comment - 18/Apr/16 12:13 PM Working fine on NAIT For HSPL Verified Education & Certification information for New & existing employee. on employee Census report. Ready for production.

Dhanashree Sherkar (Inactive) made changes - 18/Apr/16 12:13 PM

Item State

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

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

Jyoti Agrawal (Inactive) made changes - 22/Apr/16 10:35 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)

Jyoti Agrawal (Inactive) made changes - 22/Apr/16 10:35 AM

Status

Approved for Stage [ 10030 ]

Stage Testing [ 10201 ]

Jyoti Agrawal (Inactive) made changes - 22/Apr/16 10:35 AM

Status

Stage Testing [ 10201 ]

Pending for Production Approval [ 10301 ]

Jyoti Agrawal (Inactive) made changes - 22/Apr/16 10:35 AM

Status

Pending for Production Approval [ 10301 ]

Approved for production [ 10034 ]

Hide

Permalink

Dhanashree Sherkar (Inactive) added a comment - 25/Apr/16 07:07 AM

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.

Show

Dhanashree Sherkar (Inactive) added a comment - 25/Apr/16 07:07 AM 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.

Dhanashree Sherkar (Inactive) made changes - 26/Apr/16 07:03 AM

Item State

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

Parent values: Production Complete(10222)

Hide

Permalink

Dhanashree Sherkar (Inactive) added a comment - 26/Apr/16 07:04 AM

Working fine on production

Show

Dhanashree Sherkar (Inactive) added a comment - 26/Apr/16 07:04 AM Working fine on production

Dhanashree Sherkar (Inactive) made changes - 26/Apr/16 07:04 AM

Assignee

Dhanashree Sherkar [ dhanashree.sherkar ]

Jennifer Leugers [ jennifer.leugers ]

Satya made changes - 10/May/16 09:29 AM

Status

Approved for production [ 10034 ]

Production Testing [ 10202 ]

Satya made changes - 10/May/16 09:29 AM

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

Satya made changes - 10/May/16 09:30 AM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

Satya made transition - 17/Mar/16 09:18 AM

New Request

Product Backlog

1d 5h 12m

1

Rakesh Roy (Inactive) made transition - 04/Apr/16 10:31 AM

Product Backlog

Pending for Approval

18d 1h 13m

1

Rakesh Roy (Inactive) made transition - 04/Apr/16 10:31 AM

Pending for Approval

Approved for Development

3s

1

Rakesh Roy (Inactive) made transition - 04/Apr/16 10:32 AM

Approved for Development

In Development

4s

1

Dhanashree Sherkar (Inactive) made transition - 13/Apr/16 12:15 PM

In LB Testing

Reopen in Local

7h 53m

1

Jyoti Agrawal (Inactive) made transition - 14/Apr/16 12:46 PM

Reopen in Local

In Development

1d 31m

1

Jyoti Agrawal (Inactive) made transition - 14/Apr/16 12:46 PM

In Development

In LB Testing

8d 17h 50m

2

Deepali Tidke (Inactive) made transition - 18/Apr/16 04:26 AM

In LB Testing

Pending for Stage Approval

3d 15h 39m

1

Deepali Tidke (Inactive) made transition - 18/Apr/16 04:27 AM

Pending for Stage Approval

Approved for Stage

2s

1

Jyoti Agrawal (Inactive) made transition - 22/Apr/16 10:35 AM

Approved for Stage

Stage Testing

4d 6h 8m

1

Jyoti Agrawal (Inactive) made transition - 22/Apr/16 10:35 AM

Stage Testing

Pending for Production Approval

14s

1

Jyoti Agrawal (Inactive) made transition - 22/Apr/16 10:35 AM

Pending for Production Approval

Approved for production

5s

1

Satya made transition - 10/May/16 09:29 AM

Approved for production

In Production Testing

17d 22h 53m

1

Satya made transition - 10/May/16 09:29 AM

In Production Testing

Production Complete

54s

1

Satya made transition - 10/May/16 09:30 AM

Production Complete

Closed

12s

1

WORKTERRA

Education and Certificate Info field on "Employee Census Report"

Details

Description

Attachments

Activity

People

Dates