| Table Name: | MPHotlineWorkFlow |
| View Name: | MARISupportWorkflow |
| Group: | Group: SupportWorkflow |
| Description: | Support Module: Workflow definition for the status |
| ClassID: | 524. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| WorkFlowID | WorkFlowID INT Primary |
||
| Setting | Setting INT Index |
MPHotlineSettings.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 | MPBilder.BildID |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| DesignerDocID | DesignerDocID INT Index |
||
| DesignerContent | DesignerContent NTEXT |
||
| InActive | InActive SMALLINT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description | ||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPHotlineProdukt | Support Module: Support Product: Master Data | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPHotlineProduktKunde | Support Module: Support Product: Customer Product Link | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPHotlineSettings | Support Module: Settings for the Status, Priority, Mode etc. of hottline issues | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPHotlineSettingsClassType | Support Module: Selection of setting by the HotlineClassType (Ticket, Task, Idea, DevTask, HR Task) | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPHotlineSLA | Support Module: Service Level Agreement Master | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPHotlineSLASettings | Support Module: Service Level Agreement Settings | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPHotlineWorkFlowSettings | Support Module: Workflow definition for the status details | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPHotlineWorkFlowTransition | Support Module: Workflow definition for the status transition | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPPersonenPeriode | Employee Master: One line per employee and valid from period and business unit | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPProjektBuchungserfassung | Time Keeping: ProjectTimeKeepingLines: One line per entry of an employee used for each project type | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPProjektBuchungserfassungBericht | Time Keeping: Link Week Report of employee or for customer | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPProjektstamm | Project Master: Master Data | ||||||||||||||||||||||||||||||||||||||||||||||||
| MPQualityProcess | QualityProcess Definition | ||||||||||||||||||||||||||||||||||||||||||||||||
| 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.
|