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 |