| View Name: | MARIAttendanceShiftRule |
| Based on table: | MPPersonenZeitenSchicht |
| Group: | Group: AttandenceRuleHead |
| Description: | Shift: Rule Definition |
| ClassID: | 627. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ShiftID | SchichtID INT Primary |
||
| ShiftDescription | SchichtBezeichnung NVARCHAR (100) Index |
||
| ShiftMethod | SchichtMethode INT |
||
| TimeFactor | ZeitFaktor NUMERIC(19,6) |
||
| StandardStart | StandardStart Datetime Index |
||
| StandardEnd | StandardEnd Datetime |
||
| RuleNumber | Regel INT |
MARIAttendanceRule.RuleNumber | |
| AddOnCategory0 | AddOnCategory0 INT |
Overwrite sales add on category | MARITimeBookingAddOnCategory.AddOnCategory0 (WHERE AddOnCategoryType=0) |
| AddOnCategory2 | AddOnCategory2 INT |
Overwrite employee cost add on categories | MARITimeBookingAddOnCategory.AddOnCategory2 (WHERE AddOnCategoryType=2) |
| AddOnCategory3 | AddOnCategory3 INT |
Overwrite Overtime Calculation Rule | MARITimeBookingAddOnCategory.AddOnCategory3 (WHERE AddOnCategoryType=3) |
| Comment | Bemerkung NTEXT |
||
| Color | Farbe INT |
||
| Option1 | Option1 INT |
||
| Option2 | Option2 INT |
||
| Inactive | InAktiv SMALLINT (0=false,-1=true) Index |
||
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIEmployeesPeriod | Employee Master: One line per employee and valid from period and business unit |
| MARIAttendanceRuleDays | Attandence: Actions "in the door" (Day header) |
| MARIAttendanceShiftPlanDays | Shift: Standard Plan Rhythm Definition |