Returns the actual times worked by the specified employee(s) during the specified date range.
GetEmployeeActualTimes(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 |
|
dDate |
DateTime |
8 |
Date of activity. |
|
iEmpId |
Integer |
4 |
Employee Id. Foreign Key to Employee iId. |
|
cWorkType |
String |
30 |
The name of the work activity. |
|
iId |
Integer |
4 |
Primary Key - Unique Identifier. |
|
iLocationId |
Integer |
4 |
Not used. |
|
iCardId |
Integer |
4 |
Employee Schedule Header Id. Foreign Key to EmpCards iId. |
|
iWorkTypeId |
Integer |
4 |
Employee Work Activity Id. Foreign Key to Work Activities iId. |
|
cTimeIn |
String |
8 |
Actual time in, in military (HHMM) format. |
|
cTimeOut |
String |
8 |
Actual time out, in military (HHMM) format. |
|
iGId |
Integer |
4 |
Employee Schedule Record Global Id. |
|
iScheduleId |
Integer |
4 |
Employee Schedule Id. |