| View Name: | MARIEmployeeVacationRequest |
| Based on table: | MPPersonenUrlaubsAntrag |
| Group: | Group: EmployeeMaster |
| Description: | Vacation Management: Vacation Request and Approval |
| ClassID: | 177. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ApplicationLeaveID | UrlaubsAntragsId INT Primary |
||
| EmployeeNumber | Personalnummer NVARCHAR (50) Index |
MARIEmployeeMaster.EmployeeNumber | |
| ApplicationType | AntragsTyp INT |
||
| Status | Antragsstatus INT Index |
||
| ApplicationDate | Antragsdatum Datetime |
||
| ApplicationPeriod | Periode INT Index |
MARIPeriods.ApplicationPeriod | |
| StartDate | Startdatum Datetime |
||
| StartTime | Startzeit Datetime |
||
| EndDate | Enddatum Datetime |
||
| EndTime | Endzeit Datetime |
||
| ProjectNumber | Projektnummer NVARCHAR (20) |
MARIProjectMaster.ProjectNumber | |
| ContractID | VertragsID INT Index |
MARIContract.ContractID | |
| PhaseID | PhasenID INT Index |
MARIProjectPhases.PhaseID | |
| VacationDays | AnzahlUrlaubsTage NUMERIC(19,6) |
||
| HoursQty | AnzahlStunden NUMERIC(19,6) |
||
| Description | Bezeichnung NVARCHAR (50) |
||
| PlanningMethod | Planungsmode INT |
||
| ReferenceID | Planungsreferenz INT Index |
MARIProjectPlanningLines.ReferenceID | |
| ApprovalMode | Freigabemode INT Index |
||
| ApprovedBy | FreigabeID NVARCHAR (4) |
MARIUser.ApprovedBy (WHERE BenutzerTyp=1) | |
| ApprovedDate | FreigabeDatum Datetime |
||
| ApprovalText | FreigabeText NVARCHAR (250) |
||
| VacationTypeID | VacationTypeID INT |
||
| SourceApplicationType | QuellAntragsTyp INT |
||
| SourceReference | QuellReferenz INT |
||
| ActionDetail | AktionsTypDetail INT |
||
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIEmployeeVacationRequestApproval | Vacation Management: Link to steps of approval process |
| MARIEmployeeVacationRequestDays | Vacation Management: Link days for special day request |