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