MARIProject Database Structure

Table Name:MPPersonenUrlaubsplan
View Name:MARIEmployeeAnnualVacation
Group:Group: EmployeeMaster
Description:Employee Master: Vacation Management Annual Vacation

Field View(engl.field)/Type Description Related
UrlaubsPlanID VacationPlanID

INT Primary

VacationTypeID VacationTypeID

INT Index

Personalnummer EmployeeNumber

NVARCHAR (20) Index

MPPersonenstamm.Personalnummer
Kalenderjahr CalendarYear

SMALLINT Index

Periode Period

INT

MPPerioden.PeriodeJahr
RestVorjahr DaysPreviousYear

NUMERIC(19,6)

VorjahrManuell ManualPreviousYear

INT

Anspruch EntitlementCurrYear

NUMERIC(19,6)

New days this year
Abgeltung CompensationCurrYear

NUMERIC(19,6)

Vortrag SpecialLeave

NUMERIC(19,6)

Field is used for the Carry Forwared value from the previsous year.
Memo Memo

NTEXT

UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany