| View Name: | MARIPeriodsCalendarWeeks |
| Based on table: | MPPeriodenKW |
| Group: | Group: Periods |
| Description: | Calendar Management: CalendarWeeks by ISO |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| CW | KW INT Primary |
YYYYWW | |
| PeriodYear | Jahr SMALLINT |
YYYY | |
| PeriodWeek | Woche SMALLINT |
WW based on ISO | |
| StartDate | StartDatum Datetime Index |
||
| EndDate | EndDatum Datetime Index |
||
| PeriodMin | PeriodeMin INT Index |
MARIPeriods.PeriodMin | |
| PeriodMax | PeriodeMax INT Index |
MARIPeriods.PeriodMax | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARICalendarDays | Calendar Management: Calendar Day Definition |
| MARIAttendanceRuleDays | Attandence: Actions "in the door" (Day header) |
| MARIProjectItemBooking | Time Keeping: ProjectTimeKeepingItems: For items used in a project each entry is stored in this table. This table is also linked to the header: MPProjectBuchungskopf |
| MARIProjectTimeKeepingLines | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type |
| MARIEquipmentSubjectBooking | Time/Costbooking on Equipment data |
| MARIChefInfoDashboard | Project Dash Board Settings |
| MARIProjectWorkPackageEntry | Work Packages progress reporting by day |