MARIProject Database Structure

View Name:MARIEmployeeVacationRequestApproval
Based on table:MPPersonenUrlaubsAntragFreigabe
Group:Group: EmployeeMaster
Description:Vacation Management: Link to steps of approval process

Field Table(Germ.field)/Type Description Related
ApplicationLeaveID UrlaubsAntragsId

INT Primary

MARIEmployeeVacationRequest.ApplicationLeaveID
ApprovalStep Schritt

INT Primary

ApprovalType FreigabeTyp

INT

See RuleTypes in MPDocApprovalRessource
ApprovalSubType FreigabeTypSub

INT

MARIDocApprovalRessources.ApprovalSubType
ApprovalSubTypeClearer FreigabeTypClearer

INT

0=undef, 1=Single, 4=Chain
Approver Freigebender

NVARCHAR (20) Index

MARIEmployeeMaster.Approver
ApprovalMode Freigabe

SMALLINT Index

ApprovedDate FreigegebenAm

Datetime

ApprovedUser FreigegebenID

NVARCHAR (4)

MARIUser.ApprovedUser (WHERE BenutzerTyp=1)
ApprovedPending FreigabeWartend

SMALLINT

-1 for the active employee in the chain
ApprovalText Freigabetext

NTEXT

NumberOfApprovers AnzahlFreigebender

INT

UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany