| View Name: | MARIAttendanceShiftPlanDays |
| Based on table: | MPPersonenZeitenSchichtPlanTag |
| Group: | Group: AttandenceRuleHead |
| Description: | Shift: Standard Plan Rhythm Definition |
| ClassID: | 629. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ShiftPlanDayID | SchichtVorlageID INT Primary |
||
| ShifPlanID | SchichtPlan INT |
MARIAttendanceShiftPlan.ShifPlanID | |
| ShiftID | SchichtID INT Index |
MARIAttendanceShiftRule.ShiftID | |
| DayType | TagTyp INT |
||
| LinkType | AnkterTyp INT |
||
| Day | Tag Datetime |
||
| Offset | Offset INT |
||
| Description | Bezeichnung NVARCHAR (50) |
||
| Hours | Stunden NUMERIC(19,6) |
||
| HolidayType | Feiertagstyp INT |
||
| DayStart | Beginn Datetime |
||
| DayEnd | Ende INT |
||
| UpdateStamp | UpdateStamp INT |