| View Name: | MARIEmployeesPeriod |
| Based on table: | MPPersonenPeriode |
| Group: | Group: EmployeeMaster |
| Description: | Employee Master: One line per employee and valid from period and business unit |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| EmployeeNumber | Personalnummer NVARCHAR (20) Primary |
MARIEmployeeMaster.EmployeeNumber | |
| ValidFrom | GueltigAb INT Primary |
MARIPeriods.ValidFrom | |
| EmployeeStatus | PersonalTyp SMALLINT |
1=Regular, 10=Freelancer;100=Retired | MARISettingTypes.EmployeeStatus (WHERE TypTyp=2) clsImportEmployeePeriod_eEmployeeStatus |
| PoliticalCostRatesNet | VerrechnungSatzTyp SMALLINT |
PoliticalCostRates Type | clsImportEmployeePeriod_eCostRateType |
| AccountingCostRate1 | FiBuVerSatzStunde NUMERIC(19,6) |
||
| AccountingCostRate2 | FiBuVerSatzStunde2 NUMERIC(19,6) |
||
| AccountingCostRate3 | FiBuVerSatzStunde3 NUMERIC(19,6) |
||
| AccountingCostRate4 | FiBuVerSatzStunde4 NUMERIC(19,6) |
||
| Currency | WKZ NVARCHAR (3) |
ISO Currency Code | |
| EmployeeGroup1 | GruppenID INT Index |
MARIGroups.EmployeeGroup1 (WHERE Gruppenart=10001) clsImportGroups_eGroupType |
|
| EmployeeGroup2 | GruppenID2 INT |
MARIGroups.EmployeeGroup2 (WHERE Gruppenart=10006) clsImportGroups_eGroupType |
|
| EmployeeGroup3 | GruppenID3 INT |
MARIGroups.EmployeeGroup3 (WHERE Gruppenart=10007) clsImportGroups_eGroupType |
|
| EmployeeFunction | Funktion NVARCHAR (40) |
||
| InitialValue | UeberstundenStart NUMERIC(19,6) |
||
| CalendarID | KalenderID INT Index |
MARICalendar.CalendarID | |
| AddOnCategory3 | AddOnCategory3 INT |
Overtime Calculation Rule | MARITimeBookingAddOnCategory.AddOnCategory3 (WHERE AddOnCategoryType=3) |
| AddOnCategory3Value | AddOnCategory3Value NUMERIC(19,6) |
||
| ShiftPlanID | SchichtPlanID INT Index |
MARIAttendanceShiftRule.ShiftPlanID | |
| PlanningCapacity | Planungskapazitaet SMALLINT |
||
| PayrollEmplNo | Lohnpersonalnummer NVARCHAR (20) Index |
||
| PayrollCompany | Lohnmandant SMALLINT |
MARISysConnections.PayrollCompany (WHERE ConnectionType=6) | |
| WorkFlowID | WorkflowID INT Index |
MARISupportWorkflow.WorkFlowID | |
| DateOfEntry | Eintrittsdatum Datetime |
||
| LeavingDate | Austrittsdatum Datetime |
||
| TravelExpensesRule | ReiseTemplate INT |
MARITravelTemplate.TravelExpensesRule | |
| UpdateStamp | UpdateStamp INT |