| Table Name: | MPTrainingGrade |
| View Name: | MARITrainingGrade |
| Group: | Group: TrainingParticipant |
| Description: | Training Module: List of grades |
| ClassID: | 446. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| GradeNumber | GradeNumber NVARCHAR (20) Primary |
||
| Matchcode | Matchcode NVARCHAR (100) Index |
||
| Group1 | Group1 INT |
||
| Group2 | Group2 INT |
||
| Group3 | Group3 INT |
||
| ValidationType | ValidationType INT Index |
||
| 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 |
|---|---|
| MPTrainingParticipantGrades | Training Module: Grades of participants |