| Table Name: | MPHotlineSettings |
| View Name: | MARISupportSettings |
| Group: | Group: SupportIssue |
| Description: | Support Module: Settings for the Status, Priority, Mode etc. of hottline issues |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Setting | Setting INT Primary |
1=Status, 2=Type, 3=Priority, 4=Solution, 5=Medium, 6=ModuleType, 7=VersionType, 8=WorkitemStatus, 9=WorkItemPlan_Status, 10=WorkItemPlanTemplate_Status, 11=WorkItemPlanDatesLine_Status, 12=WorkItemQualitySuggestions_Status, 13=WorkItemLinkedPositionStatus, 14=WorkItemItemPositionStatus, 15=WorkItemPositionStatusPartsList | |
| ID | ID INT Primary |
||
| System | SystemFlag SMALLINT (0=false,-1=true) |
||
| Reihenfolge | SettingsOrder INT |
||
| Bezeichnung | Matchcode NVARCHAR (50) |
||
| BezeichnungID | MatchcodeID INT |
||
| Beschreibung | Description NVARCHAR (255) |
||
| BeschreibungID | DescriptionID INT |
||
| Bild | Image INT |
MARIProject internal picture id | |
| Farbe | Color INT |
||
| OptionMode | OptionMode INT |
||
| OptionMemo | OptionMemo NTEXT |
||
| ShowFilterMode | ShowFilterMode INT |
||
| NextMode | NextMode INT |
||
| PreviousMode | PreviousMode INT |
||
| ShowInAllMode | ShowInAllMode INT |
||
| SLAReactionTimeMode | SLAReactionTimeMode INT |
||
| SLASolveTimeMode | SLASolveTimeMode INT |
||
| WorkFlowID | WorkFlowID INT Index |
MPHotlineWorkFlow.WorkFlowID | |
| UpdateStamp | UpdateStamp INT |
| Table | Description | ||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MPGebinde | Definition of a container carrying other goods | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPGebindeZeile | Container Lines to see the goods in the container | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPHotlineAnfrage | Support Module: Support Tickets, Tasks, Ideas, Dev Task, HR Tasks
The type of ticket is defined by the field HotlineClassType.
|
||||||||||||||||||||||||||||||||||||||||||||||||
| MPHotlineGruppe | Support Module: Support Group: Header | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPHotlineSettingsClassType | Support Module: Selection of setting by the HotlineClassType (Ticket, Task, Idea, DevTask, HR Task) | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPHotlineWorkFlow | Support Module: Workflow definition for the status | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPHotlineWorkFlowTransition | Support Module: Workflow definition for the status transition | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPTenantDatabases | Management of MARIProject/SBO client datatabases | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPTenantMonitorAppInstallations | Bucket to store installation data at client location: installed apps | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPTenantMonitorDatabases | Bucket to store installation data at client location: used databases | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPTenantUserGroups | Management of MARIProject/SBO client installations user groups | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPTenantUsersDBLink | Management of MARIProject/SBO client installation licenses, rights | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPTrainingRegistration | Training Module: Registratrion to training cources | ||||||||||||||||||||||||||||||||||||||||||||||||
| 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.
|
||||||||||||||||||||||||||||||||||||||||||||||||
| MPWorkItemPosition | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPWorkItemScheduleDates | Recurring service tasks |