| Table Name: | MPPersonenSkills |
| View Name: | MARIEmployeeSkills |
| Group: | Group: EmployeeMaster |
| Description: | Employee Master: Employee Skill link |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Personalnummer | EmployeeNumber NVARCHAR (20) Primary |
Link to Employee | MPPersonenstamm.Personalnummer |
| GruppenID | EmployeeGroup INT Primary |
Skill ID | MPSkills.GruppenID |
| Prioritaet | Priority SMALLINT |
Values 0..100 | |
| Kenntnisse | Knowledge NVARCHAR (200) |
Additional knowledge | |
| GueltigVon | ValidFrom Datetime |
||
| GueltigBis | ValidTo Datetime |
||
| Wiedervorlage | Reminder Datetime |
||
| Erstanlage | CreateDate Datetime |
||
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| UpdateStamp | UpdateStamp INT |