EmployeeStandardPay
Return and update employee standard pay details on employee contact cards for an AccountRight company file.
Table Specific Information
Select
MYOB allows a subset of columns to be used in the WHERE clause of a SELECT query. These columns may be used with the following operators: =, !=, >, <, >=, <=. In addition, queries with multiple criteria can be executed by combining the criteria with AND and OR operators.
These columns support the above comparison types for server side filtering: ID, Memo, HoursPerPayFrequency, PayFrequency, CategoryID, CategoryDisplayID, CategoryName, EmployeeID, EmployeeDisplayID, EmployeeName, PayrollDetailsID. All the other columns and operators are processed client side.
SELECT * FROM EmployeeStandardPay WHERE ID = "1bed306d-2da4-49b3-9023-153c3dc5b2e9" SELECT * FROM EmployeeStandardPay WHERE EmployeeID = "2aed306d-2da3-49b1-9023-153c3dc5b2ef" SELECT * FROM EmployeeStandardPay WHERE HoursPerPayFrequency = 11
Update
To update an existing employee, along with its PayrollCategories, either pass a JSON string to the PayrollCategories value or use a temporary table like below.
Note: this will replace all the current PayrollCategories with the ones below.
INSERT INTO EmployeePayrollCategoryItems#TEMP (payrollcategoryid) VALUES ("2ced306d-1da3-49b1-2223-153c3dc5b2ef") UPDATE EmployeeStandardPay SET PayrollCategories = "EmployeePayrollCategoryItems#TEMP" WHERE ID = "1bed306d-2da4-49b3-9023-153c3dc5b2e9"
Columns
Name | Type | ReadOnly | References | Description |
ID [KEY] | Uuid | True |
Unique identifier in the form of a guid. | |
Memo | String | False |
Memo text for the object. | |
HoursPerPayFrequency | Decimal | True |
Hours worked in a pay period. | |
PayFrequency | String | True |
Pay frequency can consist of the following: Weekly, Fortnightly, TwiceAMonth, Monthly. | |
RowVersion | String | True |
Number value that changes upon a record update, can be used for change control but does does not preserve a date or a time. | |
URI | String | True |
Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web. | |
CategoryID | Uuid | False |
Unique category identifier in the form of a guid. | |
CategoryDisplayID | String | True |
Display id for the category. | |
CategoryName | String | True |
Name of the category. | |
CategoryURI | String | True |
Uniform resource identifier associated with the category object. | |
EmployeeID | Uuid | False |
Contacts.ID |
Unique guid identifier belonging to the assigned employee contact. |
EmployeeDisplayID | String | True |
Customer contact Card ID, can also be used as a unique employee contact identifier. | |
EmployeeName | String | True |
Name of the employee contact. | |
EmployeeURI | String | True |
Uniform resource identifier associated with the employee contact object. | |
PayrollDetailsID | Uuid | True |
Unique identifier in the form of a guid. | |
PayrollDetailsURI | String | True |
Uniform resource identifier associated with the object. | |
PayrollCategories | String | False |
All payroll categories linked to the employee contact, includes all payroll categories of type Wage. |