| Table Name: | MPTrainingParticipantExams |
| View Name: | MARITrainingParticipantExams |
| Group: | Group: TrainingParticipant |
| Description: | Training Module: Passed exams of participants |
| ClassID: | 445. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ExamRecordID | ExamRecordID INT Primary |
||
| ParticipantNumber | ParticipantNumber NVARCHAR (20) Index |
MPTrainingParticipant.ParticipantNumber | |
| ExamNumber | ExamNumber NVARCHAR (20) Index |
MPTrainingExams.ExamNumber | |
| TestDate | TestDate Datetime |
||
| PointsEarned | PointsEarned INT |
||
| ValidationType | ValidationType INT |
||
| Examiner | Examiner NVARCHAR (20) |
||
| WorkItemID | WorkItemID INT Index |
MPWorkItem.WorkItemID | |
| Memo | Memo NTEXT |
||
| Option1 | Option1 INT |
||
| 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 |