MARIProject Database Structure

View Name:MARIEmployeeAnnualVacation
Based on table:MPPersonenUrlaubsplan
Group:Group: EmployeeMaster
Description:Employee Master: Vacation Management Annual Vacation

Field Table(Germ.field)/Type Description Related
VacationPlanID UrlaubsPlanID

INT Primary

VacationTypeID VacationTypeID

INT Index

EmployeeNumber Personalnummer

NVARCHAR (20) Index

MARIEmployeeMaster.EmployeeNumber
CalendarYear Kalenderjahr

SMALLINT Index

Period Periode

INT

MARIPeriods.Period
DaysPreviousYear RestVorjahr

NUMERIC(19,6)

ManualPreviousYear VorjahrManuell

INT

EntitlementCurrYear Anspruch

NUMERIC(19,6)

New days this year
CompensationCurrYear Abgeltung

NUMERIC(19,6)

SpecialLeave Vortrag

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