| Table Name: | MPPersonenZeitenRegel |
| View Name: | MARIAttendanceRule |
| Group: | Group: AttandenceRuleHead |
| Description: | Attendance: Working Time rules (Header valid from) |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Regel | RuleNumber INT Primary |
||
| RegelKopf | WorkingTimeRule INT Index |
MPPersonenZeitenRegelKopf.RegelKopfID | |
| GueltigAb | ValidFrom Datetime Index |
MPPerioden.PeriodeJahr | |
| Bemerkung | Memo NVARCHAR (50) |
||
| Erstanlage | CreateDate Datetime |
||
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPKalenderTage | Calendar Management: Calendar Day Definition |
| MPPersonenZeitenRegelDetails | Attendance: Working Time rules (Details for the rule) |
| MPPersonenZeitenRegelZulagen | Attendance: Working Time rules (Night shift additionals) |
| MPPersonenZeitenSchicht | Shift: Rule Definition |