| View Name: | MARIAttendanceShiftPlan |
| Based on table: | MPPersonenZeitenSchichtPlan |
| Group: | Group: AttandenceRuleHead |
| Description: | Shift: Standard Plan Rhythm |
| ClassID: | 628. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ShifPlanID | SchichtPlanID INT Primary |
||
| ShiftPlanDescription | SchichtPlanBezeichnung NVARCHAR (100) Index |
||
| 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 |
|---|---|
| MARIAttendanceShiftPlanDays | Shift: Standard Plan Rhythm Definition |