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