Swapnil,

As discussed please share detailed analysis & estimation for this enhancement.

Thanks & Regards,
Satya Prakash

Hi Satya,

Please verify attached Analysis document. Quote_Total_Comensation_Statement.doc

Hi Swapnil,

The document is incomplete. It couldn’t be shared with Dave today.

Please discuss the queries with me tomorrow morning.

Thanks & Regards,

Satya Prakash

From: Swapnil Pandhare (JIRA) jira@workterra.atlassian.net
Sent: Tuesday, March 15, 2016 6:22 PM
To: satyap@harbingergroup.com
Subject: [JIRA] (WT-1248) Quote for the total compensation statement

<https://workterra.atlassian.net/secure/ViewProfile.jspa?name=swapnil.pandhare>Swapnil Pandhare commented on<https://workterra.atlassian.net/browse/WT-1248> EnhancementWT-1248 <https://workterra.atlassian.net/browse/WT-1248> Re: Quote for the totalcompensation statementHi Satya,Please verify attached Analysis document.<https://workterra.atlassian.net/secure/attachment/13874/13874_Quote_Total_Comensation_Statement.doc> Quote_Total_Comensation_Statement.doc <https://workterra.atlassian.net/browse/WT-1248#add-comment> Add Comment <https://workterra.atlassian.net/browse/WT-1248#add-comment> Add CommentThis message was sent by Atlassian JIRA(v7.2.0-OD-03-014#72000-sha1:1e7aa97)Atlassian logo

Estimation is attached here : Total_Compensation_Statement_ETA.xls

Today i worked on below points:
1. fetching record from database and add partial view to display record.
2. Now working on UI part.

I worked on Populate Benefit Line Items:
1.Coding is done.
2.Unit testing is done.
I have attached screen shot (Compensationstatement.png) please find the attachment.

checked in files List:
1. App/BusinessLogic/CollectionManager/CollectionManager.vb
2. Shared Library/ValueObjects/ValueObjects/BenefitLineItems.cs
3. BenAdmin/Areas/Customization/Controllers/TotalCompensationStatement/TotalCompensationStatementController.cs
4. BenAdmin/Areas/Customization/Models/FormatTotalCompensationStatement/BenefitLineModel.cs
5. BenAdmin/Areas/Customization/Models/TotalCompensationStatement/TotalCompensationStatementModel.cs
6. BenAdmin/Areas/Customization/Views/Customization/TotalCompensationStatement/TotalCompensationStatement.cshtml

I have created document for Benefits line item with total on total compensation statement screen.Please find the attachment(BenefitsLineItem.doc).

Hi Vaishali,

As discussed, please share estimates for this. We need to start working on this enhancement from today (3/25)

Deepali TidkeRakesh Roy
Deepali: Please have some QA go through the analysis document and start working on Test cases.

After estimated by EOD today we will share ETA.

Thanks & Regards,
Satya Prakash

Hi Satya
I have share estimation for the requirement mentioned in document (BenefitsLineItem.doc) please find the attached ETA excel sheet (ETATotalCompensationStatement.xls)

I have attached document (WORKTERRA - Gelson Market - Total Compensation Statement - Analysis).

I have started working on the enhancement the status is:
1.Check column name not accept for special characters-complete
2.Check the column name is exist or not into table-complete
3.Fetch page id ,table-ref name from db-in process
I have attached updated ETATotalCompensationStatement.xls file PFA.

[~meghana.kulkarni] : kindly go through the analysis document and start working on Test cases.

3.Fetch page id ,table-ref name from db-Completed
4.Add column into table
1.Add field into "paymentstatus" table and related table as AdditionalFieldInfo,FieldsLabel_Multilingual.-Completed
5. hide the column Employee cost and EmployeeTaxType from UI.-Completed

Started test cases writing of enhancement.

1.Alter table benefitlineitem with add column for additionalfieldinfoid which references to Additionalfieldinfo table ID.
2.Insert Id into benefitlineitem table.
3.Update SP (dbo.OES_SP_Insert_FormatTotalCompensationStatementBenefitLineItems.StoredProcedure) for insertion.

1. Work on Delete additional benefits line item
Coding part is done.

1. Work on Delete additional benefits line item
Done unit testing.
2.Test Import functionality.

1. Work on save table ref id into db change sp's dbo.OES_SP_UpdateFieldSequence and dbo.OES_SP_Insert_AdditionalField.
2. working on Unit testing.

1.Work on unit testing.:
After change table ref id while adding additional field.

Due to priority task of Matt enhancement on Thursday i was not worked on total compensation statement.So LB build deployment date is 13 april 2016.

Dut to WT-1790 task is on priority so total compensation statement is on hold.

1. This enhancement is done .after Lb build deployment you can able to test.
Known Things:
1. If trying to import invalid data like other than valid number then validations are not working in import.so ,In total compensation statement showing 0 value to that invalid entry.
2.Please create jira ticket for the above issue.

Due to LB build was not deployed on 15/04/2016.This enhancement was deployed on 18/04/2016 on LB enviornment.

Created new Jira item [ WT 1920 ] for above mentioned point.

Not able to see added and imported Additional Benefit Line - Items - employer and employee cost at employee level on LB.

This is the basic of that Enhancement. Because of this can not proceed with the enhancement Hence reopening .

Hi Meghana,
I have commit code for the above.you can able to test it on tomorrow after LB build.

Changes done file Names:
Modified: E:\SVN\LB\App\BusinessLogic\Benefits\FormatTotalCompensationStatement.vb
Modified: E:\SVN\LB\App\BusinessLogic\CollectionManager\CollectionManager.vb
Modified: E:\SVN\LB\App\BusinessLogic\SystemSettings\UserDefinedField.vb
Adding: E:\SVN\LB\Database Objects\MasterCompanyDB\01_DDL25_WT1248_WTB_Benadmin_MODTABLE_BenefitsLineItem.sql
Modified: E:\SVN\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_Get_PageAdditionalFieldList.StoredProcedure.sql
Modified: E:\SVN\LB\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_Insert_FormatTotalCompensationStatementBenefitLineItems.StoredProcedure.sql
Modified: E:\SVN\LB\Shared Library\ValueObjects\ValueObjects\BenefitLineItems.cs
Modified: E:\SVN\LB\Shared Library\ValueObjects\ValueObjects\FormBuilder_AdditionalField.cs
Modified: E:\SVN\LB\Shared Library\ValueObjects\ValueObjects\FormatTotalCompensationStatement.cs
Modified: E:\SVN\LB\Web\Web Projects\BenAdmin\Areas\Customization\Controllers\FormatTotalCompensationStatement\FormatTotalCompensationStatementController.cs
Modified: E:\SVN\LB\Web\Web Projects\BenAdmin\Areas\Customization\Controllers\TotalCompensationStatement\TotalCompensationStatementController.cs
Modified: E:\SVN\LB\Web\Web Projects\BenAdmin\Areas\Customization\Models\FormatTotalCompensationStatement\BenefitLineModel.cs
Modified: E:\SVN\LB\Web\Web Projects\BenAdmin\Areas\Customization\Models\FormatTotalCompensationStatement\FormatTotalCompensationStatementModel.cs
Modified: E:\SVN\LB\Web\Web Projects\BenAdmin\Areas\Customization\Models\TotalCompensationStatement\TotalCompensationStatementModel.cs
Modified: E:\SVN\LB\Web\Web Projects\BenAdmin\Areas\Customization\Views\Customization\FormatTotalCompensationStatement_AdditionalBenefitLine.cshtml
Modified: E:\SVN\LB\Web\Web Projects\BenAdmin\Areas\Customization\Views\Customization\FormatTotalCompensationStatement_AdditionalBenefitLineGrid.cshtml
Modified: E:\SVN\LB\Web\Web Projects\BenAdmin\Areas\Customization\Views\Customization\TotalCompensationStatement\TotalCompensationStatement.cshtml

Started testing on LB and found issues [ WT 1945 , WT 1954 , WT 1942 and WT 1920 ].

Testing is blocked on LB due to reporting server issue

Testing Completed on LB.

Will move that enhancement on Stage ones all reported child jira item [ WT 1945 , WT 1954 , WT 1942, WT 1920, WT 1979 and WT 1984 ] are fixed and verified on LB.

Rest are working Fine.

Tested reported issue on LB [ [ WT 1945 , WT 1954 , WT 1942, WT 1979 ] and it is working fine.

WT - 1984 and WT - 1920 - Dev Plate.

Ready for Stage

Testing is in Progress on Stage

Testing Completed on Stage

As discussed with Satya and Deepali , Ones the issues [ WT 1945 , WT 1942 ] are resolved and verified on Stage then it will move on Production.

WT 1942 - Completed testing on Stage
WT 1945 - Completed testing on Stage.

Found one more blocking issue on Stage - WT 2329.
One's that issue is fixed and verified on stage then it will move on Production.

1. SVN\Stage\Shared Library\ValueObjects\ValueObjects\BenefitLineItems.cs
2. SVN\Stage\Web\Web Projects\BenAdmin\Areas\Customization\Views\Customization\TotalCompensationStatement\TotalCompensationStatement.cshtml
3. SVN\Stage\Web\Web Projects\BenAdmin\Areas\Customization\Controllers\FormatTotalCompensationStatement\FormatTotalCompensationStatementController.cs
4. SVN\Stage\Web\Web Projects\BenAdmin\Areas\Customization\Views\Customization\FormatTotalCompensationStatement_AdditionalBenefitLineGrid.cshtml
5. SVN\Stage\App\BusinessLogic\SystemSettings\UserDefinedField.vb
6. SVN\Stage\App\BusinessLogic\CollectionManager\CollectionManager.vb
7. SVN\Stage\Web\Web Projects\BenAdmin\Areas\Customization\Models\TotalCompensationStatement\TotalCompensationStatementModel.cs
8. SVN\Stage\Shared Library\ValueObjects\ValueObjects\FormatTotalCompensationStatement.cs
9. SVN\Stage\Database Objects\MasterCompanyDB\01_DDL\25_WT1248_WTB_Benadmin_MODTABLE_BenefitsLineItem.sql
10.SVN\Stage\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_Insert_FormatTotalCompensationStatement.StoredProcedure.sql
11.SVN\Stage\Web\Web Projects\BenAdmin\Areas\Customization\Models\FormatTotalCompensationStatement\BenefitLineModel.cs
12.SVN\Stage\Shared Library\ValueObjects\ValueObjects\FormBuilder_AdditionalField.cs
13.SVN\Stage\Web\Web Projects\BenAdmin\Areas\Customization\Controllers\TotalCompensationStatement\TotalCompensationStatementController.cs
14.SVN\Stage\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_Insert_FormatTotalCompensationStatementBenefitLineItems.StoredProcedure.sql
15.SVN\Stage\Database Objects\MasterCompanyDB\04_Stored Procedures\dbo.OES_SP_Get_PageAdditionalFieldList.StoredProcedure.sql
16.SVN\Stage\Web\Web Projects\BenAdmin\Areas\Customization\Models\FormatTotalCompensationStatement\FormatTotalCompensationStatementModel.cs
17.SVN\Stage\Web\Web Projects\BenAdmin\Areas\Customization\Views\Customization\FormatTotalCompensationStatement_AdditionalBenefitLine.cshtml
18.SVN\Stage\App\BusinessLogic\Benefits\FormatTotalCompensationStatement.vb
19.Formbuilder.js

Tested all reported issues and it is working fine.

Ready For Production.

Verified on Production - Gelsons Markets for HSPL
Working Fine