Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki



Search the wiki


Search Engine

Here you can search through the pages of this Namespace, their attachments and the files uploaded to the system.
Note: the results will only display the items you have permissions to read.

Filter by Category

This search, performed through 2.14 MB (338 documents, 3448 words), completed in 0.0 seconds and yielded 3 results.

HumanResources EmployeePayHistory (table) — 63.6%

[...] datetime not null Date the change in pay is effective Rate money not null Salary hourly rate. PayFrequency tinyint not null 1 = Salary received monthly, 2 = Salary received biweekly ModifiedDate datetime not null (getdate()) Date and time the record was last updated. Primary Key Primary Key Columns PK_EmployeePayHistory_EmployeeID_RateChangeDate EmployeeID, RateChangeDate Check Constraints Check Constraint Expression Description CK_EmployeePayHistory_

HumanResources uspUpdateEmployeeHireInfo (procedure) — 27.3%

[...] @Title [nvarchar](50), @HireDate [datetime], @RateChangeDate [datetime], @Rate [money], @PayFrequency [tinyint], @CurrentFlag [dbo].[Flag] WITH EXECUTE AS CALLER AS BEGIN SET NOCOUNT ON; BEGIN TRY BEGIN TRANSACTION; UPDATE [HumanResources].[Employee] SET [Title] = @Title ,[HireDate] = @HireDate ,[CurrentFlag] = @CurrentFlag WHERE [EmployeeID] = @EmployeeID; INSERT INTO [HumanResources].[EmployeePayHistory] ([EmployeeID] ,[RateChangeDate] ,[Rate] ,[PayFrequency]) [...]

WikiMarkup — 9.1%

[...] {Wanted} BirthDate Gender HireDate MaritalStatus SickLeaveHours VacationHours EndDate StartDate PayFrequency Rate (table) EmailPromotion BOMLevel [...]

ScrewTurn Wiki version Some of the icons created by FamFamFam.