Files
2015-08-27 12:15:27 +02:00

30 lines
784 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');
END