| Table Name: | MPHotlineAnfrageFreigabe |
| View Name: | MARISupportIssueApproval |
| Group: | Group: SupportIssue |
| Description: | Support Module: Store the approval steps for a ticket |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| AnfrageID | AnfrageID INT Primary |
||
| Schritt | Schritt INT Primary |
||
| FreigabeTyp | ApprovalType INT |
||
| FreigabeTypSub | ApprovalSubType INT |
MPDocApprovalRessource.DocApprovalIDRessourceID | |
| FreigabeTypClearer | ApprovalSubTypeClearer INT |
||
| Freigebender | Approver NVARCHAR (20) Index |
MPPersonenstamm.Personalnummer | |
| Freigabe | ApprovalMode SMALLINT (0=false,-1=true) Index |
||
| FreigegebenAm | ApprovedDate Datetime |
||
| FreigegebenID | ApprovedUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| FreigabeWartend | ApprovedPending SMALLINT (0=false,-1=true) |
||
| Freigabetext | ApprovalText NTEXT |
||
| AnzahlFreigebender | NumberOfApprovers INT |
||
| UpdateStamp | UpdateStamp INT |