| Table Name: | MPPersonenPeriode |
| View Name: | MARIEmployeesPeriod |
| Group: | Group: EmployeeMaster |
| Description: | Employee Master: One line per employee and valid from period and business unit |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Personalnummer | EmployeeNumber NVARCHAR (20) Primary |
MPPersonenstamm.Personalnummer | |
| GueltigAb | ValidFrom INT Primary |
MPPerioden.PeriodeJahr | |
| PersonalTyp | EmployeeStatus SMALLINT |
1=Regular, 10=Freelancer;100=Retired | MPSetupTypen.TypID (WHERE TypTyp=2) clsImportEmployeePeriod_eEmployeeStatus |
| VerrechnungSatzTyp | PoliticalCostRatesNet SMALLINT |
PoliticalCostRates Type | clsImportEmployeePeriod_eCostRateType |
| FiBuVerSatzStunde | AccountingCostRate1 NUMERIC(19,6) |
||
| FiBuVerSatzStunde2 | AccountingCostRate2 NUMERIC(19,6) |
||
| FiBuVerSatzStunde3 | AccountingCostRate3 NUMERIC(19,6) |
||
| FiBuVerSatzStunde4 | AccountingCostRate4 NUMERIC(19,6) |
||
| WKZ | Currency NVARCHAR (3) |
ISO Currency Code | |
| GruppenID | EmployeeGroup1 INT Index |
MPGruppen.GruppenID (WHERE Gruppenart=10001) clsImportGroups_eGroupType |
|
| GruppenID2 | EmployeeGroup2 INT |
MPGruppen.GruppenID (WHERE Gruppenart=10006) clsImportGroups_eGroupType |
|
| GruppenID3 | EmployeeGroup3 INT |
MPGruppen.GruppenID (WHERE Gruppenart=10007) clsImportGroups_eGroupType |
|
| Funktion | EmployeeFunction NVARCHAR (40) |
||
| UeberstundenStart | InitialValue NUMERIC(19,6) |
||
| KalenderID | CalendarID INT Index |
MPKalender.KalenderID | |
| AddOnCategory3 | AddOnCategory3 INT |
Overtime Calculation Rule | MPTimeBookingAddOnCategory.AddOnCategory (WHERE AddOnCategoryType=3) |
| AddOnCategory3Value | AddOnCategory3Value NUMERIC(19,6) |
||
| SchichtPlanID | ShiftPlanID INT Index |
MPPersonenZeitenSchicht.SchichtID | |
| Planungskapazitaet | PlanningCapacity SMALLINT |
||
| Lohnpersonalnummer | PayrollEmplNo NVARCHAR (20) Index |
||
| Lohnmandant | PayrollCompany SMALLINT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| WorkflowID | WorkFlowID INT Index |
MPHotlineWorkFlow.WorkFlowID | |
| Eintrittsdatum | DateOfEntry Datetime |
||
| Austrittsdatum | LeavingDate Datetime |
||
| ReiseTemplate | TravelExpensesRule INT |
MPReise2Template.Reisetemplate | |
| UpdateStamp | UpdateStamp INT |