| Table Name: | MPTrainingExams |
| View Name: | MARITrainingExams |
| Group: | Group: TrainingParticipant |
| Description: | Training Module: List of exams |
| ClassID: | 444. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ExamNumber | ExamNumber NVARCHAR (20) Primary |
||
| Matchcode | Matchcode NVARCHAR (100) Index |
||
| Project | ProjectNumber NVARCHAR (20) Index |
MPProjektstamm.Projektnummer | |
| Phase | PhaseID INT |
MPProjektPhasen.PhasenID | |
| Group1 | Group1 INT |
||
| Group2 | Group2 INT |
||
| Group3 | Group3 INT |
||
| ValidationType | ValidationType INT |
||
| Agency | Agency NVARCHAR (20) |
||
| Responsible | Responsible NVARCHAR (20) |
MPPersonenstamm.Personalnummer | |
| PointsMethod | PointsMethod INT |
||
| PointsToPass | PointsToPass INT |
||
| PointsMax | PointsMax INT |
||
| PointsPercentage | PointsPercentage NUMERIC(19,6) |
||
| ReportId | ReportID INT |
MPSysReports.UserReportID | |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Description | Description NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPTrainingParticipantExams | Training Module: Passed exams of participants |