HR.DEPT (Departments)
| Documentation | HR |
| Schema | HR |
| Name | DEPT |
| Title | Departments |
| Module | HR |
List of company divisions and departments.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | Data Owner | ||
|---|---|---|---|---|---|---|---|---|---|
| 1 | DEPT_ID | int | Table primary key | ||||||
| Table primary key |
|||||||||
| 2 | CODE | varchar(5) | Department 2-5 letter unique business identifier, e.g. HRM, PUR, IT | CEO | |||||
| Department 2-5 letter unique business identifier, e.g. HRM, PUR, IT Data Owner: CEO |
|||||||||
| 3 | NAME | nvarchar(50) | Department name | CEO | |||||
| Department name Data Owner: CEO |
|||||||||
| 4 | MAN_ID | int | HR.EMP (Employees) | Department manager | VP HR | ||||
| Department manager References: HR.EMP (Employees) Data Owner: VP HR |
|||||||||
| 5 | PARENT_DEPT_ID | int | HR.DEPT (Departments) | Parent department | CEO | ||||
| Parent department References: HR.DEPT (Departments) Data Owner: CEO |
|||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| HR.DEPT (Departments) | HR.DEPT (Departments) | HR.DEPT.PARENT_DEPT_ID = HR.DEPT.DEPT_ID | FK_dept_parent |
|
|
HR.DEPT.PARENT_DEPT_ID = HR.DEPT.DEPT_ID Name: FK_dept_parent |
||||
| HR.DEPT (Departments) | HR.EMP (Employees) | HR.DEPT.MAN_ID = HR.EMP.EMP_ID | FK_dept_emp |
|
|
HR.DEPT.MAN_ID = HR.EMP.EMP_ID Name: FK_dept_emp |
||||
| HR.DEPT (Departments) | HR.DEPT (Departments) | HR.DEPT.PARENT_DEPT_ID = HR.DEPT.DEPT_ID | FK_dept_parent |
|
|
HR.DEPT.PARENT_DEPT_ID = HR.DEPT.DEPT_ID Name: FK_dept_parent |
||||
| Access control.CAR (Cards) | HR.DEPT (Departments) | Access control.CAR.CODE = HR.DEPT.DEP | User-defined relation |
|
|
Access control.CAR.CODE = HR.DEPT.DEP Name: User-defined relation |
||||
| Time tracking.DEPT (Departments) | HR.DEPT (Departments) | Time tracking.DEPT.CODE = HR.DEPT.DEPT | User-defined relation |
|
|
Time tracking.DEPT.CODE = HR.DEPT.DEPT Name: User-defined relation |
||||
| HR.EMP (Employees) | HR.DEPT (Departments) | HR.EMP.DEPT_ID = HR.DEPT.DEPT_ID | FK_emp_dept |
|
|
HR.EMP.DEPT_ID = HR.DEPT.DEPT_ID Name: FK_emp_dept |
||||
| Procurement.pur.requisitions (Header) | HR.DEPT (Departments) | Procurement.pur.requisitions.CODE = HR.DEPT.department | User-defined relation |
|
|
Procurement.pur.requisitions.CODE = HR.DEPT.department Name: User-defined relation |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_departmetns | DEPT_ID | ||
| User-defined unique key | CODE | ||
Uses
| Name |
|---|
|
HR.DEPT (Departments)
|
|
HR.DEPT (Departments)
|
Used by
| Name |
|---|
|
HR.DEPT (Departments)
|
|
HR.DEPT (Departments)
|
Exported: 2019-02-04 23:17, Last imported: 2018-02-09 20:22