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