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 NameDescriptionParameters
HumanResources.uspUpdateEmployeeHireInfoUpdates 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 NameTypeField Name
dbo.uspLogErrorstored procedureN/A
HumanResources.Employeeuser tableTitle
HumanResources.Employeeuser tableHireDate
HumanResources.Employeeuser tableCurrentFlag
HumanResources.EmployeePayHistoryuser tableEmployeeID
HumanResources.EmployeePayHistoryuser tableRateChangeDate
HumanResources.EmployeePayHistoryuser tableRate
HumanResources.EmployeePayHistoryuser tablePayFrequency