Returns the scheduled hours for the specified employee(s) during the specified date range.
GetEmployeeScheduleHours(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 |
Identifying code for the employee. |
|
cEmpLastName |
String |
20 |
Last name. |
|
cEmpFirstName |
String |
15 |
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 schedule hours recorded. |