2013-02-26 - 4257.100 - Spec - Payroll Rate Change Procedure #POLCAApplication

SPECIFICATIONS

4257.100 - Spec - Payroll Rate Change Procedure

Purpose

---

Update the Maintain Plant Data Interface to include 3rd Tier rates. And change display lables for Tier 1 and Tier 2 data.

Admin Info

---

Purpose	Payroll Rate Change Procedure
Requested By	Joan Profetta
Spec Created By	Venkat A
Spec Created Date	04/16/2013
Spec QA by	Rajesh Kota
Document Status	Complete

References

---

Prior Tickets

N/A

Documents

N/A

Functional Requirement

---

• Update the Maintain Plant Data Interface to include 3rd Tier rates as
  • Tier 3 Standard Base Rate
  • Tier 3 Floater Base Rate
  • Rename existing labels as
    • Standard Base Rate to Tier1 Standard Base Rate
    • Floater Base Rate to Tier1 Floater Base Rate
    • New Hire Standard Base Rate to Tier2 Standard Base Rate
    • New Hire Floater Base Rate to Tier2 Floater Base Rate

Solution Summary

---

The solution involves

• Update Bus_Unit_Data.aspx and Bus_Unit_Data.aspx.cs pages to add two textboxes for Tier 3 rates.
• Rename existing lables under Base Rate Data section.
• Update tables(PS_NEC_BUS_UNIT_DT) and stored procedures(USP_BU_GET, USP_BUDT_INSERT,USP_HR_REVIEWOPERATION_REPORT,

USP_NECRATE_RATESQL, USP_RAPIDENTRY_INSRTUPDAT and Usp_revemp_lotsize_change) to handle 3rd tier.

Test Plan

[List test scenarios/cases to be executed here]

S.No	Test Scenario	Expected Results
1	Access to Maintain Plant Data page in Polca application	User should be able to view the Maintain Plant Data page
2	When user click on View in Maintain Plant Data, Tier 3 Standard Base Rate, Tier 3 Floater Base Rate should able to view in Base Rate Data section	User should able to view following in Base Rate Data section Tier 3 Standard Base Rate Textbox Tier 3 Floater Base Rate Textbox.
3	Click on Edit link in Maintain Plant Data,	User should able view Tier 3 Standard Base Rate, Tier 3 Floater Base Rate in editable mode with save button enabled in Maintain Plant Data,
4	Click on save button in Maintain Plant Data - plant details tab.	Data for Tier 3 Standard Base Rate, Tier 3 Floater Base Rate should be saved in PS_NEC_BUS_UNIT_DT table

Solution Details

---

	Type	Name	Change
1	Table	PS_NEC_BUS_UNIT_DT	Add two new columns NEC_T3_BASE_RATE, NEC_T3_FL_BASE_RT.
2	Page	Bus_Unit_Data.aspx, Bus_Unit_Data.aspx	i) Add two new textboxs for tier 3 rates.
			ii) Rename existing lables under Base Rate Data section.
3	Stored proc	CALC_EMP_RATES USP_BU_GET USP_BUDT_INSERT USP_HR_REVIEWOPERATION_REPORT USP_NECRATE_RATESQL USP_RAPIDENTRY_INSRTUPDAT Usp_revemp_lotsize_change	Add logic to insert and update tier 3 rates table and page.
4	DB Objects	N/A	Identify and update all procedures where tier 3 rate is hard coded

Issues

---

N/A