| Table Name: | MPPersonenUrlaubsAntragFreigabe |
| View Name: | MARIEmployeeVacationRequestApproval |
| Group: | Group: EmployeeMaster |
| Description: | Vacation Management: Link to steps of approval process |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| UrlaubsAntragsId | ApplicationLeaveID INT Primary |
MPPersonenUrlaubsAntrag.UrlaubsAntragsId | |
| Schritt | ApprovalStep INT Primary |
||
| FreigabeTyp | ApprovalType INT |
See RuleTypes in MPDocApprovalRessource | |
| FreigabeTypSub | ApprovalSubType INT |
MPDocApprovalRessource.DocApprovalIDRessourceID | |
| FreigabeTypClearer | ApprovalSubTypeClearer INT |
0=undef, 1=Single, 4=Chain | |
| Freigebender | Approver NVARCHAR (20) Index |
MPPersonenstamm.Personalnummer | |
| Freigabe | ApprovalMode SMALLINT Index |
||
| FreigegebenAm | ApprovedDate Datetime |
||
| FreigegebenID | ApprovedUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| FreigabeWartend | ApprovedPending SMALLINT |
-1 for the active employee in the chain | |
| Freigabetext | ApprovalText NTEXT |
||
| AnzahlFreigebender | NumberOfApprovers INT |
||
| UpdateStamp | UpdateStamp INT |