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