| View Name: | MARITrainingExams |
| Based on table: | MPTrainingExams |
| Group: | Group: TrainingParticipant |
| Description: | Training Module: List of exams |
| ClassID: | 444. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ExamNumber | ExamNumber NVARCHAR (20) Primary |
||
| Matchcode | Matchcode NVARCHAR (100) Index |
||
| ProjectNumber | Project NVARCHAR (20) Index |
MARIProjectMaster.ProjectNumber | |
| PhaseID | Phase INT |
MARIProjectPhases.PhaseID | |
| Group1 | Group1 INT |
||
| Group2 | Group2 INT |
||
| Group3 | Group3 INT |
||
| ValidationType | ValidationType INT |
||
| Agency | Agency NVARCHAR (20) |
||
| Responsible | Responsible NVARCHAR (20) |
MARIEmployeeMaster.Responsible | |
| PointsMethod | PointsMethod INT |
||
| PointsToPass | PointsToPass INT |
||
| PointsMax | PointsMax INT |
||
| PointsPercentage | PointsPercentage NUMERIC(19,6) |
||
| ReportID | ReportId INT |
MARISysReports.ReportID | |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Description | Description NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARITrainingParticipantExams | Training Module: Passed exams of participants |