MARIProject Database Structure

Table group of WorkItem
Table/View English Description
MARIWorkItem WorkItem 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
MARIWorkItemDocumentLink WorkItemDocumentLink Service Task Link created documents
MARIWorkItemOptions WorkItemOptions Training Course: selectable options by the participants
MARIWorkItemPhaseCPosFilter WorkItemPhaseCPosFilter Training Course: Filter selectable phases or contract positions
MARIWorkItemPosition WorkItemPosition Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource
MARIWorkItemPositionSerial WorkItemPositionSerial Serialnumbers, Batchnumbers for work item positions
MARIWorkItemResources WorkItemResources Employees or Equipment necessary for the tasks
MARIWorkItemResults WorkItemResults Results of quality process questionnaire
MARIWorkItemScheduleDates WorkItemScheduleDates Recurring service tasks
MARIWorkItemSettings WorkItemSettings Additional Properties for a service order
MPWorkItem WorkItem 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
MPWorkItemDocumentLink WorkItemDocumentLink Service Task Link created documents
MPWorkItemOptions WorkItemOptions Training Course: selectable options by the participants
MPWorkItemPhaseCPosFilter WorkItemPhaseCPosFilter Training Course: Filter selectable phases or contract positions
MPWorkItemPosition WorkItemPosition Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource
MPWorkItemPositionSerial WorkItemPositionSerial Serialnumbers, Batchnumbers for work item positions
MPWorkItemResources WorkItemResources Employees or Equipment necessary for the tasks
MPWorkItemResults WorkItemResults Results of quality process questionnaire
MPWorkItemScheduleDates WorkItemScheduleDates Recurring service tasks
MPWorkItemSettings WorkItemSettings Additional Properties for a service order

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany