Returns the actual hours worked by the specified employee(s) during the specified date range.
GetEmployeeActualHours(XmlIds AS String, StartDate AS Date, EndDate AS Date)
XML String
XmlIds = XML String containing the Employee Ids of the records to return. You must format this string using the XML IdList Structure Definition.
StartDate = Start date for the records to return.
EndDate = End date for the records to return.
XML String has the following structure:
|
Field |
Type |
Length |
Description |
|
iEmpId |
Integer |
4 |
Employee Id. Foreign Key to Employee iId. |
|
cEmpCode |
String |
10 |
Employee code. |
|
cEmpLastName |
String |
20 |
Employee last name. |
|
cEmpFirstName |
String |
15 |
Employee first name. |
|
iWorkTypeId |
Integer |
4 |
Work Activity Id. Foreign Key to Work Activity iId. |
|
cWorkType |
String |
30 |
Work Activity name. |
|
nHours |
Decimal |
10,2 |
Total number of actual hours recorded. |