Employee work tasks for payroll fact table
bi_factemployeeworktaskspayroll_s3
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
factempworktaskid | NUMERIC(19,0) | unique identifier for employee and work task combination | PK | ||
employeeId | VARCHAR(36) | unique identifier for employee | bi_dimuser_s3 userid | ||
worktaskId | VARCHAR(36) | unique identifier for work task | Bi_DimWorkTasks_s3 Worktaskid | ||
isprimary | BOOLEAN | indicates if work task is primary work task for employee | |||
totalworktaskhours | FLOAT | total hours employee worked for this work task | |||
worktaskrate | DECIMAL(19,4) | rate at which employee gets paid for the work task | |||
worktaskpay | DECIMAL(19,4) | work task rate multiplied by number of work task hours | |||
PayrollCenterId | VARCHAR(36) | unique identifier for the center where payroll is calculated | bi_dimcenter_s3 centerid | ||
payrollstartdate | DATE | start date of payroll | |||
PayrollendDate | DATE | end date of payroll | |||
AttendanceCenterId | VARCHAR(36) | unique identifer for the center where employee checked-in to do the work task | bi_dimcenter_s3 centerid | ||
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_s3 organizationid | ||
attendancedate | DATE | Date for which pay is calculated. | |||
isproductionhours | BOOLEAN | indicates if the work task is production task or not | |||
payrate | DECIMAL(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 | |||