| Table Name: | MPTrainingParticipantGrades |
| View Name: | MARITrainingParticipantGrades |
| Group: | Group: TrainingParticipant |
| Description: | Training Module: Grades of participants |
| ClassID: | 447. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ParticipantGradeID | ParticipantGradeID INT Primary |
||
| ParticipantNumber | ParticipantNumber NVARCHAR (20) Index |
MPTrainingParticipant.ParticipantNumber | |
| GradeNumber | GradeNumber NVARCHAR (20) Index |
MPTrainingGrade.GradeNumber | |
| DateOfGrade | DateOfGrade Datetime |
||
| ValidationType | ValidationType INT |
||
| WorkItemID | WorkItemID INT |
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 |