HumanResources.uspUpdateEmployeeHireInfo

Procedure/Function: 'HumanResources.uspUpdateEmployeeHireInfo', Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters.

Procedure Name	Description	Parameters
HumanResources.uspUpdateEmployeeHireInfo	Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters.	@RETURN_VALUE int(10) [RETURN VALUE], @EmployeeID int(10) [INPUT], @Title nvarchar(50) [INPUT], @HireDate datetime(23) [INPUT], @RateChangeDate datetime(23) [INPUT], @Rate money(19) [INPUT], @PayFrequency tinyint(3) [INPUT], @CurrentFlag Flag(1) [INPUT]

Dependencies for Procedure/Function 'HumanResources.uspUpdateEmployeeHireInfo', 8 items

Object Name	Type	Field Name
dbo.uspLogError	stored procedure	N/A
HumanResources.Employee	user table	Title
HumanResources.Employee	user table	HireDate
HumanResources.Employee	user table	CurrentFlag
HumanResources.EmployeePayHistory	user table	EmployeeID
HumanResources.EmployeePayHistory	user table	RateChangeDate
HumanResources.EmployeePayHistory	user table	Rate
HumanResources.EmployeePayHistory	user table	PayFrequency