Shift models
WRDA_ShiftModels
The WRDA_ShiftModels view provides the location-independent shift model information administered in the Data Administration. Locational properties are provided in the WRDA_ShiftModelOrigin view.
Relations
| Field (WRDA_AdditionalCosts) | Field | Table / View |
|---|---|---|
FreeAbsoluteAdditionOneUnitID |
UnitID |
|
FreeAbsoluteAdditionOneVarUnitID |
UnitID |
|
FreeAbsoluteAdditionTwoUnitID |
UnitID |
|
FreeAbsoluteAdditionTwoVarUnitID |
UnitID |
|
CreatorID |
DAUserID |
|
ModifierID |
DAUserID |
Field description
| Field | Description |
|---|---|
DAShiftModelID |
int, not null FACTON internal ID of the shift model. |
DAShiftModelParentID |
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 for a folder. |
ShiftModelName |
nvarchar(max), null Label of the shift model in the Company language. |
ShiftModelName |
nvarchar(max), null Name of the shift model in the language according to the country code. Example: ShiftModelName_EN for the English name. |
ShiftModelIdentifier |
nvarchar(50), null Semantic key of the shift model |
ShiftModelDescription |
nvarchar(max), null Description of the shift model in the Company language. |
ShiftModelDescription |
nvarchar(max), null Description of the shift model in the language according to the country code. Example: ShiftModelDescription_EN for the English description. |
MaxCapacityOfEmployee |
int, null Value of the maximum worker capacity in the unit The value is independent of the assigned origin. |
MaxCapacityOfMachine |
int, null Value of the maximum worker capacity in the unit The value is independent of the assigned origin. |
FreeAdditionOne |
float, null Value of the first surcharge as a percentage according to the settings “Extras | Settings | Worker” Fixed unit is currently %. A value of 1 equals 1%. |
FreeAdditionTwo |
float, null Value of the second surcharge as a percentage according to the settings “Extras | Settings | Worker” Fixed unit is currently %. A value of 1 equals 1%. |
FreeAdditionThree |
float, null Value of the third surcharge as a percentage according to the settings “Extras | Settings | Worker” Fixed unit is currently %. A value of 1 equals 1%. |
FreeAbsoluteAdditionOne |
float, null Value of the first absolute surcharge according to the settings “Extras | Settings | Worker” The unit is [FreeAbsoluteAdditionOneUnitID] / hour |
FreeAbsoluteAdditionOneUnitID |
int, null ID for the unit of the first absolute shift surcharge. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table. |
FreeAbsoluteAdditionOneVar |
float, null Value of the first absolute, variable shift surcharge. The unit is [FreeAbsoluteAdditionOneVarUnitID] / hour |
FreeAbsoluteAdditionOneVarUnitID |
int, null ID for the unit of the first absolute, variable shift 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 according to the settings “Extras | Settings | Worker” The unit is [FreeAbsoluteAdditionTwoUnitID] / hour |
FreeAbsoluteAdditionTwoUnitID |
int, null ID for the unit of the second absolute shift surcharge. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table. |
FreeAbsoluteAdditionTwoVar |
float, null Value of the second absolute, variable shift surcharge. The unit is [FreeAbsoluteAdditionTwoVarUnitID] / hour |
FreeAbsoluteAdditionTwoVarUnitID |
int, null ID for the unit of the second absolute, variable shift surcharge. The label of the unit can be determined via the foreign key (UnitID) in the WRDA_Units table. |
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 |
WRDA_ShiftModelOrigin
The WRDA_ShiftModelOrigin view provides locational shift model data.
Relations
| Field (WRDA_EmployeeOrigin) | Field | Table / View |
|---|---|---|
DAOriginID |
DAOriginID |
|
DAShiftModelID |
DAEmployeeID |
|
FreeAbsoluteAdditionOneUnitID |
UnitID |
|
FreeAbsoluteAdditionOneVarUnitID |
UnitID |
|
FreeAbsoluteAdditionTwoUnitID |
UnitID |
|
FreeAbsoluteAdditionTwoVarUnitID |
UnitID |
Field description
| Field | Description |
|---|---|
DAShiftModelOriginID |
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. |
DAShiftModelID |
int, null FACTON internal ID for the shift model. 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. |
MaxCapacityEmployee |
int, null Value of the maximum capacity of the worker. Unit is hour / year |
MaxCapacityMachine |
int, null Value of the maximum capacity of the machine. Unit is hour / year |
EmployeeOriginCostRate |
float, null Value of the origin-dependent labor cost rate Unit is CurrencyID / hour |
EmployeeOriginCostRateVar |
float, null Variable share of the origin-dependent basic labor cost rate Unit is CurrencyID / hour |
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. |
FreeAbsoluteAdditionOne |
float, null Value of the first absolute surcharge The unit is [FreeAbsoluteAdditionOneUnitID] / hour |