Knowledgebase: Syntax
[QODBC-Desktop] What can I do with Employee Earnings (EmployeeEarning)?
Posted by brad waddell on 12 March 2009 05:21 PM

EmployeeEarning INSERT

Create a new Employee and EmployeeEarning Line

INSERT INTO EmployeeEarning (FirstName, MiddleName, LastName, PayrollInfoEarningsPayrollItemWageRefListID, PayrollInfoEarningsRate, FQSaveToCache) VALUES ('Tom','T.','QODBC', '10000-933272656', 30000.0, 0)

Create a new EmployeeEarning Line for an Existing Employee

INSERT INTO EmployeeEarning (ListID, PayrollInfoEarningsPayrollItemWageRefListID, PayrollInfoEarningsRate) VALUES ('300000-934380930', '20000-934380928', 40000)

 

EmployeeEarning UPDATE

UPDATE "EmployeeEarning" SET PayrollInfoEarningsRate = 25000.0 WHERE "ListID" = '390000-933272659' AND "PayrollInfoEarningsPayrollItemWageRefListID" = '10000-933272656'

UPDATE "EmployeeEarning" SET PayrollInfoEarningsRate = 20.000 WHERE "ListID" = '390000-933272659' AND "PayrollInfoEarningsPayrollItemWageRefListID" = '50000-933272657'

 

EmployeeEarning DELETE

DELETE FROM "EmployeeEarning" WHERE "ListID" = '390000-933272659' AND "PayrollInfoEarningsPayrollItemWageRefListID" = '10000-933272656'

DELETE FROM "EmployeeEarning" WHERE "ListID" = '390000-933272659' AND "PayrollInfoEarningsPayrollItemWageRefListID" = '50000-933272657'

Note: You MUST specify PayrollInfoEarningsPayrollItemWageRefListID in the delete as the example.

          If you run the query as per: DELETE FROM EmployeeEarning WHERE ListID = '300000-934380930', you may get an error "invalid bookmark value".

 

EmployeeEarning SELECT

SELECT Name, ListID, PayrollInfoEarningsPayrollItemWageRefListID, PayrollInfoEarningsRate FROM EmployeeEarning

Note: If you have trouble seeing your changes, try running your queries in unoptimized mode like this:

SELECT Name, ListID, PayrollInfoEarningsPayrollItemWageRefListID, PayrollInfoEarningsRate FROM EmployeeEarning unoptimized

(141 vote(s))
Helpful
Not helpful

Comments (1)
blue goulding
04 January 2014 05:00 AM
Can you create (write) a payroll record
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).