2013-02-26 - 4257.100 - Spec - ECALC Process rate change #POLCAApplication

SPECIFICATIONS

4257.100 - Payroll Rate Change Procedure(Ver-2)

Purpose

Payroll entries made prior to E-Calc completion has to be dated as of the first day the rate changes takes effect.

Admin Info

Purpose	Payroll Rate Change Procedure(Ver-2)
Requested By	Joan Profetta
Spec Created By	Venkat A
Spec Created Date	04/17/2013
Spec QA by	Rajesh K
Document Status	Complete

References

Prior Tickets

Documents

Functional Requirement

Currently when the E-Calc process is ran for All Tapes, Embroidery Type A and Embroidery type B, it takes a couple of days to run.
Payroll entries made prior to E-Calc completion are pick up the existing embroidery rates.
Provide option to input Date that has to be Effective date for that particular process.

Solution Summary

Add calender control on Calculate Embroidery rates page.
Update ECalc process to consider provided Effective Date.
If no date is provided, consider default logic - process with current date.

Test Plan

Title	Module	Steps	Expected Result
Calculate Embroidery Rates	Calculate Embroidery Rates	1. User should be able to access POLCA application. 2. Select Calculate Embroidery rates tab. 3. User should be able to see Drop down for Run type and a Calender control for Effective date. 4. Enter Run type , Effective date and Embroidery Machine type. 5. Click on Run Button.	When the ECALC Process is executed Effective date in the PS_NEC_EMB_TAPES Table should be updated with the effective date given in front end(Calender control).
ECALC Package	ECALC Package	1. Execute Wilcomm2Pending.dtsx, ECALC.dtsx package	In this process effective date is updated with current date + 1 in PS_NEC_EMB_TAPES Table.

Solution Details

	Type	Name	Change
1	Page	CaluclateEMBRuntype.aspx CaluclateEMBRuntype.aspx.cs	Calender control will be added for effective date
2	Procedure	NE_ECALC_REPORT GET_SELECTED_TAPES INSERT_NEW_TAPE_ROW CHECK_TAPE_EXISTS_TODAY UPDATE_TAPE_RATES	Effective date logic need to be added in this stored procedures