Database Table EmployeeAssOrgUnit

[This is preliminary documentation and is subject to change.]

Each row in this table corresponds to an association between an employee and an organizational unit

Fields

Field name	Type	Note	Description
Employee_Id	INT	Foreign key	Link to Employee record
OrgUnit_Type	VARCHAR(20)	Foreign key	Link to OrgUnit record
OrgUnit_Code	VARCHAR(20)	Foreign key	Link to OrgUnit record

Relations

Table	Relation
Employee	See field Employee_Id above.
OrgUnit	See fields OrgUnit_Type and OrgUnit_Code above.