Employee schedule status dimension table
bi_dimemployeeschedulestatus
Field | Description | Field Type | Primary Key |
|---|---|---|---|
accountname | varchar ( 256 ) | ||
employeeschedulestatuswid | bigint | ||
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
organizationid | varchar ( 36 ) | ||
organizationname | varchar ( 512 ) | ||
podname | varchar ( 20 ) | ||
statusname | The status of the employee in the scheduled time. This is populated only when 'record name' is 'Schedule' or 'StagedSchedule'. It shows whether the employee was working or not in the scheduled time. | varchar ( 1024 ) | |
statuspk | numeric | ||
void | boolean | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |