Workers

Support

support@facton.com
+49 1805-FACTON
Customer Portal

Workers

WRDA_Employees

The WRDA_Employees view provides information on the workers administered in the Data Administration. Additionally, the origin-independent labor rate is returned. Origin-dependent labor rates are provided in the WRDA_EmployeeOrigin view.

Relations

Field (WRDA_Employees)	Field	Table / View
AvailabilityUnitID	UnitID	WRDA_Units
CurrencyID	UnitID	WRDA_Units
CreatorID	DAUserID	WRDA_Users
ModifierID	DAUserID	WRDA_Users

Field description

Field	Description
DAEmployeeID	int, not null FACTON internal ID of the employee.
DAEmployeeParentID	int, null Internal ID of the parent folder
IsGroup	bit, null Returns the value 0 if the current data row is a machine, otherwise the value 1 is returned for a folder.
EmployeeName	nvarchar(max), null Name of the worker in the Company language
EmployeeName _[Country identifier]	nvarchar(max), null Name of the worker in the language according to the country code. Example: EmployeeName_EN for the English name.
EmployeeIdentifier	nvarchar(50), null Semantic key of the worker.
EmployeeDescription	nvarchar(max), null Description of the worker in the Company language
EmployeeDescription _[Country identifier]	nvarchar(max), null Description of the worker in the language according to the country code. Example: EmployeeDescription_EN for the English description.
Availability	float, null Availability. A value of 1 corresponds to 100%.
AvailabilityUnitID	int, null ID for the unit of the availability. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
CurrencyID	int, null Currency ID of the absolute (CostRate) and variable basic labor cost rate (CostRateVar). The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
CostRate	float, null Value of the origin-independent basic labor cost rate The unit is [CurrencyID] / hour
CostRateVar	float, null Variable share of the origin-independent basic labor cost rate The unit is [CurrencyID] / hour
Surcharges on Labor Cost Rates	Origin-independent surcharges on the basic labor cost rate Origin-dependent surcharges are provided by the WRDA_EmployeeOrigin view.
CreatorID	int, null Internal ID of the user who created the data record. The name of the user can be determined via the foreign key (DAUserID) in the WRDA_Users view.
CreationDateTime	datetime, null Creation date of the data record
ModifierID	int, null Internal ID of the user who last updated the data record. The name of the user can be determined via the foreign key (DAUserID) in the WRDA_Users view.
LastUpdateDateTime	datetime, null Modification date
Configured Attributes

WRDA_EmployeeOrigin

The WRDA_EmployeeOrigin view provides the labor data depending on the location (origin).

Relations

Field (WRDA_EmployeeOrigin)	Field	Table / View
DAOriginID	DAOriginID	WRDA_Origins
DAEmployeeID	DAEmployeeID	WRDA_Employees
CurrencyID	UnitID	WRDA_Units
FreeAbsoluteAdditionOneUnitID	UnitID	WRDA_Units
FreeAbsoluteAdditionOneVarUnitID	UnitID	WRDA_Units
FreeAbsoluteAdditionTwoUnitID	UnitID	WRDA_Units
FreeAbsoluteAdditionTwoVarUnitID	UnitID	WRDA_Units

Field description

Field	Description
DAEmployeeOriginID	int, not null FACTON internal ID for the data record.
DAOriginID	int, null FACTON internal ID of the origin. Information on the origin can be determined via the foreign key (DAOriginID) in the WRDA_Origins view.
DAEmployeeID	int, null FACTON internal ID for the employee. Information on the worker can be determined via the foreign key (DAEmployeeID) in the WRDA_Employees view.
IsActive	bit, null Returns the value 1 if the origin is active in the Data Administration, otherwise the value 0 is returned.
CurrencyID	int, null Currency ID of the absolute (EmployeeOriginCostRate) and variable basic labor cost rate (EmployeeOriginCostRateVar). The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
EmployeeOriginCostRate	float, null Value of the origin-dependent basic labor cost rate The unit is [CurrencyID] / hour
EmployeeOriginCostRateVar	float, null Variable share of the origin-dependent basic labor cost rate The unit is [CurrencyID] / hour
FreeAdditionOne	float, null Value of the first percentage surcharge Note: The value 1 equals 1%.
FreeAdditionTwo	float, null Value of the second percentage surcharge Note: The value 1 equals 1%.
FreeAdditionThree	float, null Value of the third percentage surcharge Note: The value 1 equals 1%.
FreeAbsoluteAdditionOne	float, null Value of the first absolute surcharge The unit is [FreeAbsoluteAdditionOneUnitID] / hour
FreeAbsoluteAdditionOneUnitID	int, null ID for the unit of the first absolute surcharge. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
FreeAbsoluteAdditionOneVar	float, null Variable share of the first absolute surcharge The unit is [FreeAbsoluteAdditionOneVarUnitID] / hour
FreeAbsoluteAdditionOneVarUnitID	int, null Unit ID of the variable share of the first absolute surcharge The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
FreeAbsoluteAdditionTwo	float, null Value of the second absolute surcharge The unit is [FreeAbsoluteAdditionTwoUnitID] / hour
FreeAbsoluteAdditionTwoUnitID	int, null ID for the unit of the second absolute surcharge. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.
FreeAbsoluteAdditionTwoVar	float, null Variable share of the second absolute surcharge The unit is [FreeAbsoluteAdditionTwoVarUnitID] / hour
FreeAbsoluteAdditionTwoVarUnitID	int, null Unit ID of the variable share of the second absolute surcharge The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table.