| View Name: | MARIProjectPhaseEmployeeFeedback |
| Based on table: | MPProjektPhasenMeldung |
| Group: | Group: ProjectPhases |
| Description: | Project Phases Master: Employee messages (Feedback) and Project monthly Percentage of completion |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| PhaseFeedbackID | PhasenMeldungsID INT Primary |
||
| PhaseID | PhasenID INT Index |
MARIProjectPhases.PhaseID | |
| ProjectNumber | Projektnummer NVARCHAR (20) Index |
MARIProjectMaster.ProjectNumber | |
| FeedbackType | Meldungsart INT |
||
| EmployeeNumber | Mitarbeiter NVARCHAR (20) |
MARIEmployeeMaster.EmployeeNumber | |
| FeddbackDate | Meldungsdatum Datetime Index |
||
| Period | Periode INT Index |
MARIPeriods.Period | |
| MessageText | MeldungsText NTEXT |
||
| QuantityActual | MengeIst NUMERIC(19,6) |
||
| QuantityPlan | MengePlan NUMERIC(19,6) |
||
| DegreeOfCompletion | Fertigstellungsgrad NUMERIC(19,6) |
||
| QuantityOpen | MengeRest NUMERIC(19,6) |
||
| PhaseStatus | PhasenStatus 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) | |
| UpdateStamp | UpdateStamp INT |