Employee attendance dimension table
bi_dimemployeeattendance
Field | Description | Field Type | Primary Key |
|---|---|---|---|
dimemployeeattendancewid | 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 | |
recordname | This field describes the type of record being populated. Possible values: - Schedule: Indicates an employee's configured schedule. - Break: Indicates a break within the employee's schedule. - Attendance: Indicates the time that the employee checks-in and checks-out during the day. Businesses can choose whether to allow multiple check-ins in a single day through an org-level setting in Zenoti. This record name is used when only one check-in and check-out time is recorded for the employee during the entire day. - MultipleAttendance: Indicates the time that the employee checks-in and checks-out during the day. Businesses can choose whether to allow multiple check-ins in a single day through an org-level setting in Zenoti. This record name is used when the employee checks-in and checks-out multiple times during the day. Each instance of check-in and check-out shows up in a separate row. - StagedSchedule: This is a dummy record created when the employee provides services outside his/her schedule hours. For each appointment which is serviced outside schedule hours, a separate row is created. - Staged Attendance: This is a dummy record created when the employee has multiple check-in and check-out records in the Multiple Attendance table, but no entry in the Attendance table. This is very rare and only occurs in case of data errors. | varchar ( 36 ) | |
recordpk | numeric |