MARIProject Database Structure

Table Name:MPPersonenstamm
View Name:MARIEmployeeMaster
Group:Group: EmployeeMaster
Description:Employee Master: Employee Master
ClassID: 33. See Overview of ClassIDs by table.

Field View(engl.field)/Type Description Related
Personalnummer EmployeeNumber

NVARCHAR (20) Primary
Anrede Salutation

NVARCHAR (50)
Matchcode Matchcode

NVARCHAR (50) Index
BenutzerID UserCode

NVARCHAR (4) Index

 MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Personenname EmployeeName

NVARCHAR (50)
Vorname FirstName

NVARCHAR (50)
Vorname2 MiddleName

NVARCHAR (50)
Nachname Surname

NVARCHAR (50)
Zusatz AddressName3

NVARCHAR (50)
Strasse AddressStreet

NVARCHAR (100)

 Private Address
Hausnummer AddressStreetNo

NVARCHAR (100)

 Private Address
PLZ AddressZIP

NVARCHAR (20)

 Private Address
Ort AddressCity

NVARCHAR (100)

 Private Address
Land AddressCountry

NVARCHAR (50)

 Private Address
Bezirk AddressCounty

NVARCHAR (100)

 Private Address
Bundesland AddressState

NVARCHAR (3)

 Private Address
Gebaeude AddressBuilding

NVARCHAR (100)

 Private Address
GebaeudeStockwerk AddressBlock

NTEXT

 Private Address
AdressMemo AdressMemo

NTEXT

 Private Address
Ansprache Salutation2

NVARCHAR (50)
Telefon Phone

NVARCHAR (20)

 Business Phone
TelefonPrivat PrivatePhone

NVARCHAR (20)
Telefax Fax

NVARCHAR (20)

 Business Fax
TelefaxPrivat PrivateFax

NVARCHAR (20)
Mobiltelefon Mobile

NVARCHAR (20)

 Business Mobile/Celular
MobiltelefonPrivat PrivateMobile

NVARCHAR (20)
NamensKuerzel NameInitials

NVARCHAR (5)
Email Email

NVARCHAR (50)

 Business Email Address
EmailPrivat EmailPrivate

NVARCHAR (50)
Geburtsdatum DateOfBirth

Datetime
GeburtsLand BirthState

NVARCHAR (3)
GeburtsOrt BirthPlace

NVARCHAR (100)
GeburtsStadt BirthCity

NVARCHAR (100)
Position Position

NVARCHAR (90)
Beruf Profession

NVARCHAR (50)
LocationID LocationID

INT

 MPLocation.LocationID
BildID ImageID

INT

 MPBilder.BildID
SignaturePictureID SignaturePictureID

INT

 Picture for the signature MPBilder.BildID
AvatarPictureID AvatarPictureID

INT
ExternerSchluessel PDAKey

NVARCHAR (50)

 Key for external HP Systems for the employee
Eintrittsdatum DateOfEntry

Datetime
Austrittsdatum LeavingDate

Datetime
OutOfOfficeStatus OutOfOfficeStatus

INT
OutOfOfficeSubstitute OutOfOfficeSubstitute

NVARCHAR (255)
OutOfOfficeText OutOfOfficeText

NVARCHAR (255)
ExchangeSyncMode ExchangeSyncMode

INT

 Synchronizing appointments with the exchange calendar. Setting which side will be master clsImportEmployeeMaster_eExchangeSyncMode
A1Strasse A1Street

NVARCHAR (100)

 Business Address
A1Hausnummer A1StreetNum

NVARCHAR (100)

 Business Address
A1Land A1Country

NVARCHAR (3)

 Business Address
A1PLZ A1ZIP

NVARCHAR (20)

 Business Address
A1Ort A1City

NVARCHAR (100)

 Business Address
A1Bezirk A1County

NVARCHAR (100)

 Business Address
A1Bundesland A1State

NVARCHAR (3)

 Business Address
A1Gebaeude A1Block

NVARCHAR (100)

 Business Address
A1GebaeudeStockwerk A1Building

NTEXT

 Business Address
A1AdressMemo A1AddressMemo

NTEXT

 Business Address
LeistungsHandling ServiceHandling

INT

 Select behaviour in data entry clsImportEmployeeMaster_eServiceHandling
Erstanlage CreateDate

Datetime
ErstanlageID CreateUser

NVARCHAR (4)

 MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Aenderung ChangeDate

Datetime
AenderungID ChangeUser

NVARCHAR (4)

 MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
InAktiv Inactive

SMALLINT (0=false,-1=true) Index

 Hide dataset
PersonalMemo Memo

NTEXT
PersonalMemoLevel MemoLevel

SMALLINT
HidePageFlag HidePageFlag

BIGINT
UpdateStamp UpdateStamp

INT

Linked by

Table Description
MPAuswertungGeschaeftsbereicheMA Plannings Simulator: Dimension Business Unit / Employees
MPAuswertungProjekteMA Plannings Simulator: Dimension Projects/Employees
MPAuswertungRessourcenMA Plannings Simulator: Dimension Resources/Employees
MPBelegeEmpfaenger Definition of eMail Recipients for documents out of a contract.
MPBuchArchiv Project Dokumentation: Archived Book Content
MPBuchSeitenFreigabe Project Dokumentation: Book Page Approval Flow
MPCreditCardMapping Stores Credit Card Information to Business Partner and Employees for CreditCard Import
MPCustomerEquipmentCard Advanced table to sbo standard customer equipment card
MPCustomerEquipmentLocation Current location of a CSO at the client/Project
MPCustomerLocationTreeElement Tree elements to manage levels, rooms of the customer
MPDocApprovalRessource Steps in the approval process. Rule Lines (Steps) for each approval prioritry. The rules are used from top (Priority=0) to button.
MPDocApprovalRessourceSub Store 1:n the Receipients for serial or chain approvals
MPDocumentDraftHead Header for the draft document
MPDocumentDraftHeadLink Linked contracts and purchase processes
MPDocumentInvoiceFlow InvoicePaymentReportStore
MPEKVertraege Purchase Process: Header
MPEKVertraegeBelegeFreigabe Purchase Process: Document Approval Employee Link
MPEKVertraegePositionenPers Purchase Process: Employees linked to a position
MPEquipmentDetails Equipment: Master Data "date from" based
MPEquipmentLocation Equipment: Current Location of this equipment
MPEquipmentSubjectBooking Time/Costbooking on Equipment data
MPExchangeSync MS Exchange Server Link Log
MPGebindeLocation Current location of a container
MPHotlineAnfrageFreigabe Support Module: Store the approval steps for a ticket
MPHotlineGruppe Support Module: Support Group: Header
MPHotlineGruppeMitarbeiter Support Module: Support Group: Linked employees
MPHotlineProdukt Support Module: Support Product: Master Data
MPHotlineProduktKunde Support Module: Support Product: Customer Product Link
MPKalender Calendar Management: Calendar Header
MPLohnZeile Payroll Interface: Export Lines
MPNewsletterCampaign Source data for a plain newsletter (one time user)
MPNewsletterFilterSet Predefined filter on the E-Mail sources
MPNewsletterMaster Newsletter Design Template
MPPersonenEigenschaften Employee Master: Additional Settings
MPPersonenFahrzeugarten Employee Master: Linked mileage allowances
MPPersonenLeistungen Employee Master: Linked services
MPPersonenOrganisation Employee Master: One line per regular employee and valid from period, several lines for freelancer employees, per valid from period
MPPersonenPeriode Employee Master: One line per employee and valid from period and business unit
MPPersonenPool Employee Master: Employee Pool link
MPPersonenProjektVorlagen Employee Master: Project link (standard vacation project...)
MPPersonenProvisionsEinstellungen Employee Master: Standard Settings for Commission by Employee
MPPersonenReise2Fahrz Travel Expenses Module: Employee Mileage type (header)
MPPersonenReise2FahrzSub Travel Expenses Module: Employee Mileage type (sub)
MPPersonenSkills Employee Master: Employee Skill link
MPPersonenUrlaubsAntrag Vacation Management: Vacation Request and Approval
MPPersonenUrlaubsAntragFreigabe Vacation Management: Link to steps of approval process
MPPersonenUrlaubsplan Employee Master: Vacation Management Annual Vacation
MPPersonenVerrechnung Employee Master: Cost Rates
MPPersonenVerrechnungProjekt Employee Master: Cost Rates per project for freelancers
MPPersonenZeitenAktionen Attendance: Actions "in the door" (Lines per day)
MPPersonenZeitenAktionenArchiv Attendance: Actions "in the door" (Lines per day) History
MPPersonenZeitenTage Attandence: Actions "in the door" (Day header)
MPPersonenZeitenVorerfassung Table to store activities, before they are linked to time bookings
MPProjektArbeitskreis Project Master: Work group
MPProjektArbeitspaketerfassung Work Packages progress reporting by day
MPProjektArtikelerfassung Time Keeping: ProjectTimeKeepingItems: For items used in a project each entry is stored in this table. This table is also linked to the header: MPProjectBuchungskopf
MPProjektBuchungFavoriten Time Keeping: Favorits
MPProjektBuchungserfassung Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type
MPProjektBuchungserfassungBericht Time Keeping: Link Week Report of employee or for customer
MPProjektBuchungserfassungZuschlaege Time Keeping: AddOnCategoryDetails
MPProjektBuchungskopf Time Keeping: ProjectTimeKeepingHeader: One line per employee and period. This header table indicates the booking month of time sheet entries. (no project information is stored).
MPProjektPhasenMeldung Project Phases Master: Employee messages (Feedback) and Project monthly Percentage of completion
MPProjektPhasenMitarbeiter Project Phases Master: Employee link
MPProjektPlanungsversion Project Master: Planning versions linked to a project
MPProjektReiseRegeln Travel Expenses Module: Properties by Project
MPProjektstammProjektleiter Project Master: Linked project manager
MPQualityProcess QualityProcess Definition
MPReise2 Travel Expenses Module: Business Trip Master
MPReise2BuchungKopf Travel Expenses Module: Accounting Header
MPReise2Freigabe Travel Expenses Module: Approval for travel requests
MPReise2Zeile Travel Expenses Module: Trip receipt line
MPReise2Zeiten Travel Expenses Module: Trip day lines
MPReise2ZeitenPauschalen Travel Expenses Module: Employee trip days
MPReise2ZeitenPauschalenZeilen Travel Expenses Module: Employee trip days allowance link
MPRessourcenGPTeam External resource team (Supplier, customer)
MPRessourcenPool Resource Pool: Master Data
MPSimulationStammdatenBerechtigung Plannings Simulator: Master Data by dimension authorization
MPSimulationSzenarienBerechtigung Plannings Simulator: Scenarios authorization
MPSysClassApprovalLine Approval of core data receipients
MPSysClassNotificationReceipients Event Management: Additional receipients for core data
MPSysMessages System: eMail System (Header)
MPTenantEnvironments Base client enviornment (master for over all clients)
MPTenantMonitorAppUsers Bucket to store installation data at client location: assigned users
MPTmpRptPrintBelegKopf Reporting: Temporary Table: Document Header
MPTmpRptProjektPhaseLeistung Reporting: Temporary Table: Project Phase Service
MPTmpRptStundenUeberblick Reporting: Temporary Table: Time Keeping
MPTrainingExams Training Module: List of exams
MPTrainingGrade Training Module: List of grades
MPTrainingParticipant Training Module: List Of Participants
MPVKVertraege Contract Management: Contract Master Data + Service Master Data
MPVKVertraegeBelegeFreigabe Contract Management: Document Approval
MPVKVertraegePositionenPers Contract Management: Contract position employee link
MPWorkItem The table is used basically for service task and other tasks. For each dimension using this table, special views have been created. See also the description of the field WorkItemType.
DimensionClassID/WorkItemTypeView
Service Task364MARIWorkItem_ServiceTask
Internal Service Task365MARIWorkItem_InternalServiceTask
Result Task456MARIWorkItem_ResultTask
Service Plan379MARIWorkItem_ServicePlan
Service Plan Template378MARIWorkItem_ServicePlanTemplate
Qualification493MARIWorkItem_Qualification
Qualification Plan494MARIWorkItem_QualificationPlan
Qualification Task495MARIWorkItem_QualificationTask
Business Partner Audit Template496MARIWorkItem_BPAuditTemplate
Business Partner Audit Plan497MARIWorkItem_BPAuditPlan
Business Partner Audit498MARIWorkItem_BPAuditTask
Trainings Course/Event/Meeting492MARIWorkItem_TrainingCourse
Part List401
Check List Limit471
Production Task522
MPWorkItemPosition Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany