Employee work tasks for payroll fact table
bi_factemployeeworktaskspayroll
field | Field type | Description | Primary Key | Mapped dimension table Mapped dimension column | |
|---|---|---|---|---|---|
factemployeeworktaskspayrollwid | BIGINT | unique identifier for the row | Yes | ||
factempworktaskid | NUMERIC(19,0) | unique identifier for employee and work task combination | |||
employeewid | BIGINT | unique identifier for employee | bi_dimuser userwid | ||
worktaskwid | BIGINT | unique identifier for work task | bi_dimworktasks worktaskswid | ||
isprimary | BOOLEAN | indicates if work task is primary work task for employee | |||
totalworktaskhours | FLOAT | total hours employee worked for this work task | |||
worktaskrate | NUMERIC(19,4) | rate at which employee gets paid for the work task | |||
worktaskpay | NUMERIC(19,4) | work task rate multiplied by number of work task hours | |||
payrollcenterwid | BIGINT | unique identifier for the center where payroll is calculated | bi_dimcenter centerwid | ||
payrollstartdate | DATE | start date of payroll | |||
PayrollendDate | DATE | end date of payroll | |||
attendancecenterwid | BIGINT | unique identifer for the center where employee checked-in to do the work task | bi_dimcenter centerwid | ||
void | BOOLEAN | indicates if row is void or not | |||
payrollbatchid | VARCHAR(36) | batch ID for payroll computation | |||
organizationid | VARCHAR(36) | unique identifier for the organization | bi_dimcenter organizationid | ||
attendancedate | DATE | Date for which pay is calculated. | |||
isproductionhours | BOOLEAN | indicates if the work task is production task or not | |||
payrate | NUMERIC(19,4) | pay rate set for the employee | |||
etlcreatedby | NUMERIC(19,0) | internal to Zenoti | |||
etlcreateddate | TIMESTAMP | internal to Zenoti | |||
podname | VARCHAR(20) | indicates the region of the POD. Internal to Zenoti | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||