| View Name: | MARISupportSettings |
| Based on table: | MPHotlineSettings |
| Group: | Group: SupportIssue |
| Description: | Support Module: Settings for the Status, Priority, Mode etc. of hottline issues |
| Field | Table(Germ.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 |
||
| SystemFlag | System SMALLINT (0=false,-1=true) |
||
| SettingsOrder | Reihenfolge INT |
||
| Matchcode | Bezeichnung NVARCHAR (50) |
||
| MatchcodeID | BezeichnungID INT |
||
| Description | Beschreibung NVARCHAR (255) |
||
| DescriptionID | BeschreibungID INT |
||
| Image | Bild INT |
MARIProject internal picture id | |
| Color | Farbe 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 |
MARISupportWorkflow.WorkFlowID | |
| UpdateStamp | UpdateStamp INT |
| Table | Description | ||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MARISupportIssue | Support Module: Support Tickets, Tasks, Ideas, Dev Task, HR Tasks
The type of ticket is defined by the field HotlineClassType.
|
||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportGroup | Support Module: Support Group: Header | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITrainingRegistration | Training Module: Registratrion to training cources | ||||||||||||||||||||||||||||||||||||||||||||||||
| 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.
|
||||||||||||||||||||||||||||||||||||||||||||||||
| MARIWorkItemPosition | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIWorkItemScheduleDates | Recurring service tasks | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportWorkflow | Support Module: Workflow definition for the status | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportWorkflowTransition | Support Module: Workflow definition for the status transition | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITenantDatabases | Management of MARIProject/SBO client datatabases | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITenantMonitorAppInstallations | Bucket to store installation data at client location: installed apps | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITenantMonitorDatabases | Bucket to store installation data at client location: used databases | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITenantUsersDBLink | Management of MARIProject/SBO client installation licenses, rights | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARITenantUserGroups | Management of MARIProject/SBO client installations user groups | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportSettingsClassType | Support Module: Selection of setting by the HotlineClassType (Ticket, Task, Idea, DevTask, HR Task) | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIContainer | Definition of a container carrying other goods | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIContainerLine | Container Lines to see the goods in the container |