MARIProject Database Structure

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

Field Table(Germ.field)/Type Description Related
EmployeeNumber Personalnummer

NVARCHAR (20) Primary
Salutation Anrede

NVARCHAR (50)
Matchcode Matchcode

NVARCHAR (50) Index
UserCode BenutzerID

NVARCHAR (4) Index

 MARIUser.UserCode (WHERE BenutzerTyp=1)
EmployeeName Personenname

NVARCHAR (50)
FirstName Vorname

NVARCHAR (50)
MiddleName Vorname2

NVARCHAR (50)
Surname Nachname

NVARCHAR (50)
AddressName3 Zusatz

NVARCHAR (50)
AddressStreet Strasse

NVARCHAR (100)

 Private Address
AddressStreetNo Hausnummer

NVARCHAR (100)

 Private Address
AddressZIP PLZ

NVARCHAR (20)

 Private Address
AddressCity Ort

NVARCHAR (100)

 Private Address
AddressCountry Land

NVARCHAR (50)

 Private Address
AddressCounty Bezirk

NVARCHAR (100)

 Private Address
AddressState Bundesland

NVARCHAR (3)

 Private Address
AddressBuilding Gebaeude

NVARCHAR (100)

 Private Address
AddressBlock GebaeudeStockwerk

NTEXT

 Private Address
AdressMemo AdressMemo

NTEXT

 Private Address
Salutation2 Ansprache

NVARCHAR (50)
Phone Telefon

NVARCHAR (20)

 Business Phone
PrivatePhone TelefonPrivat

NVARCHAR (20)
Fax Telefax

NVARCHAR (20)

 Business Fax
PrivateFax TelefaxPrivat

NVARCHAR (20)
Mobile Mobiltelefon

NVARCHAR (20)

 Business Mobile/Celular
PrivateMobile MobiltelefonPrivat

NVARCHAR (20)
NameInitials NamensKuerzel

NVARCHAR (5)
Email Email

NVARCHAR (50)

 Business Email Address
EmailPrivate EmailPrivat

NVARCHAR (50)
DateOfBirth Geburtsdatum

Datetime
BirthState GeburtsLand

NVARCHAR (3)
BirthPlace GeburtsOrt

NVARCHAR (100)
BirthCity GeburtsStadt

NVARCHAR (100)
Position Position

NVARCHAR (90)
Profession Beruf

NVARCHAR (50)
LocationID LocationID

INT

 MARILocation.LocationID
ImageID BildID

INT

 MARIPictures.ImageID
SignaturePictureID SignaturePictureID

INT

 Picture for the signature MARIPictures.SignaturePictureID
AvatarPictureID AvatarPictureID

INT
PDAKey ExternerSchluessel

NVARCHAR (50)

 Key for external HP Systems for the employee
DateOfEntry Eintrittsdatum

Datetime
LeavingDate Austrittsdatum

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
A1Street A1Strasse

NVARCHAR (100)

 Business Address
A1StreetNum A1Hausnummer

NVARCHAR (100)

 Business Address
A1Country A1Land

NVARCHAR (3)

 Business Address
A1ZIP A1PLZ

NVARCHAR (20)

 Business Address
A1City A1Ort

NVARCHAR (100)

 Business Address
A1County A1Bezirk

NVARCHAR (100)

 Business Address
A1State A1Bundesland

NVARCHAR (3)

 Business Address
A1Block A1Gebaeude

NVARCHAR (100)

 Business Address
A1Building A1GebaeudeStockwerk

NTEXT

 Business Address
A1AddressMemo A1AdressMemo

NTEXT

 Business Address
ServiceHandling LeistungsHandling

INT

 Select behaviour in data entry clsImportEmployeeMaster_eServiceHandling
CreateDate Erstanlage

Datetime
CreateUser ErstanlageID

NVARCHAR (4)

 MARIUser.CreateUser (WHERE BenutzerTyp=1)
ChangeDate Aenderung

Datetime
ChangeUser AenderungID

NVARCHAR (4)

 MARIUser.ChangeUser (WHERE BenutzerTyp=1)
Inactive InAktiv

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

 Hide dataset
Memo PersonalMemo

NTEXT
MemoLevel PersonalMemoLevel

SMALLINT
HidePageFlag HidePageFlag

BIGINT
UpdateStamp UpdateStamp

INT

Linked by

Table Description
MARIInfoSimulationBusinessUnitsEmployees Plannings Simulator: Dimension Business Unit / Employees
MARIInfoSimulationProjectEmployees Plannings Simulator: Dimension Projects/Employees
MARIInfoSimulationResourcesEmpoyees Plannings Simulator: Dimension Resources/Employees
MARIDocApprovalRessources Steps in the approval process. Rule Lines (Steps) for each approval prioritry. The rules are used from top (Priority=0) to button.
MARIPurchaseProcess Purchase Process: Header
MARIPurchaseProcessDocumentApproval Purchase Process: Document Approval Employee Link
MARIPurchaseProcessPositionEmployees Purchase Process: Employees linked to a position
MARISupportGroup Support Module: Support Group: Header
MARISupportGroupEmployee Support Module: Support Group: Linked employees
MARISupportProduct Support Module: Support Product: Master Data
MARISupportProductCustomer Support Module: Support Product: Customer Product Link
MARICalendar Calendar Management: Calendar Header
MARIPayrollLine Payroll Interface: Export Lines
MARIEmployeeProperties Employee Master: Additional Settings
MARIEmployeesTravelMilage Employee Master: Linked mileage allowances
MARIEmployeesService Employee Master: Linked services
MARIEmployeesOrganisation Employee Master: One line per regular employee and valid from period, several lines for freelancer employees, per valid from period
MARIEmployeesPeriod Employee Master: One line per employee and valid from period and business unit
MARIEmployeesPool Employee Master: Employee Pool link
MARIEmployeesProjectLinks Employee Master: Project link (standard vacation project...)
MARIEmployeesTrip2TravelMilage Travel Expenses Module: Employee Mileage type (header)
MARIEmployeesTrip2TravelMilageSub Travel Expenses Module: Employee Mileage type (sub)
MARIEmployeeSkills Employee Master: Employee Skill link
MARIEmployeeVacationRequest Vacation Management: Vacation Request and Approval
MARIEmployeeAnnualVacation Employee Master: Vacation Management Annual Vacation
MARIEmployeeCostRates Employee Master: Cost Rates
MARIEmployeeCostRatesProject Employee Master: Cost Rates per project for freelancers
MARIAttendanceAction Attendance: Actions "in the door" (Lines per day)
MARIAttendanceRuleDays Attandence: Actions "in the door" (Day header)
MARIProjectWorkGroup Project Master: Work group
MARIProjectItemBooking 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
MARIProjectBookingsFavorits Time Keeping: Favorits
MARIProjectTimeKeepingLines Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type
MARIProjectTimeKeepingHeader 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).
MARIProjectPhaseEmployeeFeedback Project Phases Master: Employee messages (Feedback) and Project monthly Percentage of completion
MARIProjectPhaseEmployeeLink Project Phases Master: Employee link
MARIProjectPlanningVersions Project Master: Planning versions linked to a project
MARIProjectTravelExpenseRules Travel Expenses Module: Properties by Project
MARIProjectManager Project Master: Linked project manager
MARIQualityProcess QualityProcess Definition
MARITravelTrip Travel Expenses Module: Business Trip Master
MARITravelAccountingHeader Travel Expenses Module: Accounting Header
MARITravelTripLine Travel Expenses Module: Trip receipt line
MARITravelTripTime Travel Expenses Module: Trip day lines
MARITravelTripTimeAllowancesLines Travel Expenses Module: Employee trip days
MARITravelTripTimeAllowances Travel Expenses Module: Employee trip days allowance link
MARIResourcePool Resource Pool: Master Data
MARISimulationMasterDataAuthentication Plannings Simulator: Master Data by dimension authorization
MARISimulationScenarioAuthentication Plannings Simulator: Scenarios authorization
MARIClassNotificationReceipients Event Management: Additional receipients for core data
MARISysMessages System: eMail System (Header)
MARITempReportDocumentHeader Reporting: Temporary Table: Document Header
MARITempReportProjectPhaseService Reporting: Temporary Table: Project Phase Service
MARITempReportTimeKeeping Reporting: Temporary Table: Time Keeping
MARIContract Contract Management: Contract Master Data + Service Master Data
MARIContractDocumentApproval Contract Management: Document Approval
MARIContractPositionEmployee Contract Management: Contract position employee link
MARIMPExchangeSync MS Exchange Server Link Log
MARIEquipmentDetails Equipment: Master Data "date from" based
MARIEquipmentSubjectBooking Time/Costbooking on Equipment data
MARIAttendanceActionArchive Attendance: Actions "in the door" (Lines per day) History
MARITrainingExams Training Module: List of exams
MARITrainingGrade Training Module: List of grades
MARITrainingParticipant Training Module: List Of Participants
MARISysClassApprovalLine Approval of core data receipients
MARIEquipmentLocation Equipment: Current Location of this equipment
MARIDocApprovalRessourcesSub Store 1:n the Receipients for serial or chain approvals
MARIDocumentDraftHead Header for the draft document
MARIDocumentDraftHeadLink Linked contracts and purchase processes
MARIDocumentInvoiceFlow InvoicePaymentReportStore
MARIWorkItem 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
MARIWorkItemPosition Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource
MARICustomerServiceObject Advanced table to sbo standard customer equipment card
MARICustomerServiceObjectLocation Current location of a CSO at the client/Project
MARICustomerLocationTreeElement Tree elements to manage levels, rooms of the customer
MARICreditCardMapping Stores Credit Card Information to Business Partner and Employees for CreditCard Import
MARIEmployeeVacationRequestApproval Vacation Management: Link to steps of approval process
MARITravelAccountingApproval Travel Expenses Module: Approval for travel requests
MARITimeBookingActivityTracker Table to store activities, before they are linked to time bookings
MARIProjectTimeKeepingReport Time Keeping: Link Week Report of employee or for customer
MARIProjectTimeKeepingLinesAddOnCategory Time Keeping: AddOnCategoryDetails
MARIEmployeesCommissionSettings Employee Master: Standard Settings for Commission by Employee
MARINewsletterFilterSet Predefined filter on the E-Mail sources
MARINewsletterMaster Newsletter Design Template
MARINewsletterCampaign Source data for a plain newsletter (one time user)
MARISupportIssueApproval Support Module: Store the approval steps for a ticket
MARITenantEnvironments Base client enviornment (master for over all clients)
MARITenantMonitorAppUsers Bucket to store installation data at client location: assigned users
MARIProjectWorkPackageEntry Work Packages progress reporting by day
MARIBookArchive Project Dokumentation: Archived Book Content
MARIBookPageApproval Project Dokumentation: Book Page Approval Flow
MARIDocumentRecipient Definition of eMail Recipients for documents out of a contract.
MARIContainerLocation Current location of a container
MARIResourcePoolBPTeam External resource team (Supplier, customer)


Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany