Employee schedule fact table
This table lists the fact table columns used for the employee schedule data model.
Bi_FactEmployeeSchedule
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
centertimingwid | bigint | Ignore this column. | |||
employeeattendancewid | bigint | The primary key constraint column for the current record in core system. Internal to zenoti | |||
employeeschedulestatuswid | bigint | Status of the schedule | |||
employeebreakcategorywid | bigint | Indicates what type of break is taken by the employee | Bi_DimEmployeeBreakCategory EmployeeBreakCategorywid | ||
Centerwid | bigint | A unique identifier for the center, generated in Centre dimension(Bi_DimCentre). | Bi_DimCenter centerwid | ||
Employeewid | bigint | A unique identifier for an employee(Bi_Dimuser). | Bi_DimUser userwid | ||
EndTime | TIMESTAMP | The end date and time corresponding to the 'record name'. For example, if the record name is 'Schedule', this field populates the end date and time of the schedule. | |||
etlCreatedBy | numeric(19) | ETL system admin user who inserted or updated the corresponding record in this table. | |||
etlCreatedDate | TIMESTAMP | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |||
ExpectedCheckinTime | FLOAT | The time at which the guest is expected to check-in. | |||
ExpectedCheckoutTime | FLOAT | The time at which the guest is expected to check-out. | |||
FactEmployeeSchedulewid | bigint | A unique identifier for each record generated in the fact table. | Yes | ||
factemployeescheduleid | numeric(19) | A unique identifier for each record generated in the fact table. | |||
OrganizationId | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter Organizationid | ||
OutsideScheduleInMinutes | FLOAT | Break minutes outside schedule | |||
PODID | integer | Internal to the ETL, says from which POD data is being synced the table | |||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
RecordPk | numeric(19) | The primary key constraint column for the current record in core system. | |||
RecoveryTime | INT | The total recovery time (in minutes) taken by the employee within the scheduled time. Only appointments that are in (Open, Closed, Check-in, Confirmed) statuses are considered. This is populated only when the 'record name' is 'Schedule' or 'StagedSchedule'. | |||
resourcewid | bigint | Indicates the room assigned to service provider in the given schedule | Bi_DimResource Resourcewid | ||
ScheduleDate | TIMESTAMP | The date associated with the corresponding record. | |||
ServiceTime | FLOAT | The total time (in minutes) for which the employee provided a service within the scheduled time. Only appointments that are in (Open, Closed, Check-in, Confirmed) statuses are considered. This includes the recovery time and is populated only when the 'record name' is 'Schedule' or 'StagedSchedule'. | |||
StartTime | TIMESTAMP | The start date and time corresponding to the 'record name'. For example, if the record name is 'Schedule', this field populates the start date and time of the schedule. | |||
void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
WithInScheduleInMinutes | FLOAT | Break minutes with in schedule | |||
worktaskwid | bigint | The unique identifier of the work task. These are tasks that employees can undertake beyond their principal job | |||
IsMandatoryBreakComplete | BOOLEAN | Indicates if employee completed mandatory break | |||
TimeOffInMinutes | INTEGER | Time off employee has taken in the day in minutes | |||
VacationTimeOffInMins | FLOAT | Indicates number of minutes employee has logged as vacation hours | |||
HolidayTimeOffInMins | FLOAT | Indicates number of minutes employee has logged as holiday hours | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||