| View Name: | MARISupportWorkflow |
| Based on table: | MPHotlineWorkFlow |
| Group: | Group: SupportWorkflow |
| Description: | Support Module: Workflow definition for the status |
| ClassID: | 524. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| WorkFlowID | WorkFlowID INT Primary |
||
| Setting | Setting INT Index |
MARISupportSettings.Setting | |
| WorkFlowName | WorkFlowName NVARCHAR (100) Index |
||
| Priority | Priority INT Index |
||
| System | System SMALLINT |
Yes No | |
| WorkFlowMode | WorkFlowMode INT |
||
| InitialStatus | InitialStatus INT |
||
| PictureID | PictureID INT |
Icon Code | MARIPictures.PictureID |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| DesignerDocID | DesignerDocID INT Index |
||
| DesignerContent | DesignerContent NTEXT |
||
| InActive | InActive SMALLINT |
||
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportProduct | Support Module: Support Product: Master Data | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportProductCustomer | Support Module: Support Product: Customer Product Link | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportSettings | Support Module: Settings for the Status, Priority, Mode etc. of hottline issues | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIEmployeesPeriod | Employee Master: One line per employee and valid from period and business unit | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectTimeKeepingLines | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectMaster | Project Master: Master Data | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIQualityProcess | QualityProcess Definition | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportSLA | Support Module: Service Level Agreement Master | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportSLASettings | Support Module: Service Level Agreement Settings | ||||||||||||||||||||||||||||||||||||||||||||||||
| 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.
|
||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportWorkflowTransition | Support Module: Workflow definition for the status transition | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportWorkflowSettings | Support Module: Workflow definition for the status details | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARIProjectTimeKeepingReport | Time Keeping: Link Week Report of employee or for customer | ||||||||||||||||||||||||||||||||||||||||||||||||
| MARISupportSettingsClassType | Support Module: Selection of setting by the HotlineClassType (Ticket, Task, Idea, DevTask, HR Task) |