33 lines
825 B
SQL
33 lines
825 B
SQL
DROP procedure IF EXISTS `CreatePayrollItem`
|
|
|
|
|
|
#
|
|
|
|
|
|
CREATE PROCEDURE `CreatePayrollItem` (
|
|
IN personId INT,
|
|
IN organizationId INT,
|
|
IN employedDate DATETIME,
|
|
IN reportsToPersonId INT,
|
|
IN countryId INT,
|
|
IN baseSalaryCents INT,
|
|
IN budgetId INT,
|
|
IN open TINYINT,
|
|
IN additiveTaxLevel DOUBLE,
|
|
IN subtractiveTaxLevelId INT,
|
|
IN isContractor TINYINT
|
|
)
|
|
BEGIN
|
|
INSERT INTO Payroll
|
|
(PersonId, OrganizationId, EmployedDate, ReportsToPersonId,
|
|
CountryId, BaseSalaryCents, BudgetId, Open, AdditiveTaxLevel,
|
|
SubtractiveTaxLevelId, IsContractor, TerminatedDate)
|
|
VALUES
|
|
(personId, organizationId, employedDate, reportsToPersonId,
|
|
countryId, baseSalaryCents, budgetId, open, additiveTaxLevel,
|
|
subtractiveTaxLevelId, isContractor, '2099-12-31');
|
|
|
|
SELECT LAST_INSERT_ID() AS Identity;
|
|
|
|
END
|