MyClockingState |
Returns clocking stateReturns clocking state for the logged in user. If the user is not clocked in, returns null.
Catalogus: Horeko
Schema: Clocking
Label: {res:itgen_horeko_myclockingstate_plural}
Dit is een alleen-lezen tabel. De Horeko API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive UniversalSQL-stuurprogramma voor Horeko ondersteunt dit niet. In het laatste geval gebruikt u de tabel NativePlatformScalarRequests om gegevens te uploaden naar de Horeko-API.
Tabelkolommen
De kolommen van de tabel MyClockingState worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
BreakLength |
int32 |
Break Length |
☐ |
|
ClockedInBy_EmployeeNumber |
string |
{res:itgen_horeko_clockedinby_employeenumber} |
☐ |
|
ClockedInBy_FirstName |
string |
{res:itgen_horeko_clockedinby_firstname} |
☐ |
|
ClockedInBy_FullName |
string |
{res:itgen_horeko_clockedinby_fullname} |
☐ |
|
ClockedInBy_Id |
int32 |
{res:itgen_horeko_clockedinby_id} |
☐ |
|
ClockedInBy_ImagePath |
string |
{res:itgen_horeko_clockedinby_imagepath} |
☐ |
|
ClockedInBy_LastName |
string |
{res:itgen_horeko_clockedinby_lastname} |
☐ |
|
ClockedInBy_MiddleName |
string |
{res:itgen_horeko_clockedinby_middlename} |
☐ |
|
ClockedOutBy_EmployeeNumber |
string |
{res:itgen_horeko_clockedoutby_employeenumber} |
☐ |
|
ClockedOutBy_FirstName |
string |
{res:itgen_horeko_clockedoutby_firstname} |
☐ |
|
ClockedOutBy_FullName |
string |
{res:itgen_horeko_clockedoutby_fullname} |
☐ |
|
ClockedOutBy_Id |
int32 |
{res:itgen_horeko_clockedoutby_id} |
☐ |
|
ClockedOutBy_ImagePath |
string |
{res:itgen_horeko_clockedoutby_imagepath} |
☐ |
|
ClockedOutBy_LastName |
string |
{res:itgen_horeko_clockedoutby_lastname} |
☐ |
|
ClockedOutBy_MiddleName |
string |
{res:itgen_horeko_clockedoutby_middlename} |
☐ |
|
ClockInMethod |
int32 |
Clock-in Method |
☐ |
0 = Fingerprint | 1 = Android app | 2 = iOS app | 3 = PIN | 4 = Manager | 5 = Web app |
ClockOutMethod |
int32 |
Clock-out Method |
☐ |
0 = Fingerprint | 1 = Android app | 2 = iOS app | 3 = PIN | 4 = Manager | 5 = Web app |
Comment |
string |
Commentaar |
☐ |
|
DepartmentName |
string |
Afdeling Naam |
☐ |
|
Employee_EmployeeNumber |
string |
{res:itgen_horeko_employee_employeenumber} |
☐ |
|
Employee_FirstName |
string |
{res:itgen_horeko_employee_firstname} |
☐ |
|
Employee_FullName |
string |
{res:itgen_horeko_employee_fullname} |
☐ |
|
Employee_Id |
int32 |
{res:itgen_horeko_employee_id} |
☐ |
|
Employee_ImagePath |
string |
{res:itgen_horeko_employee_imagepath} |
☐ |
|
Employee_LastName |
string |
{res:itgen_horeko_employee_lastname} |
☐ |
|
Employee_MiddleName |
string |
{res:itgen_horeko_employee_middlename} |
☐ |
|
End |
datetime |
Einde |
☐ |
|
Id |
int32 |
ID |
☐ |
|
ManagerComment |
string |
Manager Comment |
☐ |
|
RoundedEnd |
datetime |
Rounded End |
☐ |
|
RoundedStart |
datetime |
Rounded Start |
☐ |
|
Shift_Break |
int32 |
{res:itgen_horeko_shift_break} |
☐ |
|
Shift_End |
datetime |
{res:itgen_horeko_shift_end} |
☐ |
|
Shift_Id |
int32 |
{res:itgen_horeko_shift_id} |
☐ |
|
Shift_Name |
string |
{res:itgen_horeko_shift_name} |
☐ |
|
Shift_Start |
datetime |
{res:itgen_horeko_shift_start} |
☐ |
|
Start |
datetime |
Start |
☐ |
|
Status |
int32 |
Status |
☐ |
0 = Undecided | 1 = Approved | 2 = Disapproved |
StatusChangedBy_EmployeeNumber |
string |
{res:itgen_horeko_statuschangedby_employeenumber} |
☐ |
|
StatusChangedBy_FirstName |
string |
{res:itgen_horeko_statuschangedby_firstname} |
☐ |
|
StatusChangedBy_FullName |
string |
{res:itgen_horeko_statuschangedby_fullname} |
☐ |
|
StatusChangedBy_Id |
int32 |
{res:itgen_horeko_statuschangedby_id} |
☐ |
|
StatusChangedBy_ImagePath |
string |
{res:itgen_horeko_statuschangedby_imagepath} |
☐ |
|
StatusChangedBy_LastName |
string |
{res:itgen_horeko_statuschangedby_lastname} |
☐ |
|
StatusChangedBy_MiddleName |
string |
{res:itgen_horeko_statuschangedby_middlename} |
☐ |
|
StatusChangedDateTime |
datetime |
Status Changed Date Time |
☐ |
|
TeamName |
string |
Naam team |
☐ |
|
UndefinedClockedInLocation |
boolean |
Undefined Clocked-in Location |
☐ |
|
UndefinedClockedOutLocation |
boolean |
Undefined Clocked-out Location |
☐ |
|
WorkedTimeExcludingBreaks |
double |
Worked Time Excluding Breaks |
☐ |
|
WorkedTimeIncludingBreaks |
double |
Workedtimeincludingbreaks |
☐ |
|
28-07-2024 19:16 Versie 24.1.6-BETA+4856