column_names = ["orgScheduleId", "scheduleId", 'absenceScheduleId', 'Name', 'categoryName', "BadgeNo", "Start Date", "Shift Start Time", "Shift End Time", 'begBreak', 'endBreak', "Scheduled Hours"]
orgScheduleId |
Float |
598627685.0 |
In an absence shift this refers to the scheduled shift it origins from. On scheduled shifts and absence shifts that does not origin from a scheduled shift orgScheduleId = 0. |
scheduleId |
Float |
598627685.0 |
Identificator for the scheduled shift. If record is not a scheduled shift scheduleId will be left out. |
absenceScheduleId |
Float |
598627685.0 |
Identificator for the absence shift. If record is not an absence shift absencesheduleId will be left out. |
Name |
String |
"Abdallah, Mohamed" |
Employee full name |
categoryName |
String |
People: Imperial-ACA-0600-1600 |
n/a |
BadgeNo |
String |
"368203" |
Unique employee badge number |
Start Date |
String |
"2022-02-23" |
Employee scheduled shift start date. Format: YYYY-MM-DD |
Shift Start Time |
String |
"2022-02-23 05:30:00" |
Employee scheduled shift start date and time. Format: YYYY-MM-DD HH:MM:SS |
Shift End Time |
String |
"2022-02-23 15:00:00" |
Employee scheduled shift end date and time. Format: YYYY-MM-DD HH:MM:SS |
begBreak |
String |
"12:00:00" |
Employee start break time. Format: HH:MM:SS |
endBreak |
String |
"13:00:00" |
Employee end break time. Format: HH:MM:SS |
Scheduled Hours |
Float |
8.5 |
Employee shift scheduled hours |
unitId |
String |
"60500" |
Unique Business Unit ID number for a specific District |
districtId |
String |
"10291" |
Unique District ID |
unitName |
String |
"Imperial" |
Unique Business Unit name for a specific District |