DEPT (Departments)
| Documentation | Time tracking |
| Name | DEPT |
| Title | Departments |
| Module | Time tracking |
List of departments imported from HR application.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | Data Owner | ||
|---|---|---|---|---|---|---|---|---|---|
| 1 | DEPT (Code) | varchar(50) | HR.HR.DEPT (Departments) | Department 3 digit code consistent with HR application | HR | ||||
| Department 3 digit code consistent with HR application References: HR.HR.DEPT (Departments) Data Owner: HR |
|||||||||
| 2 | NAME | varchar(50) | Depratment name. Consistent with HR application. | HR | |||||
| Depratment name. Consistent with HR application. Data Owner: HR |
|||||||||
| 3 | TRK (Tracks time) | char(1) | Default: 0 | Flag whether time tracking is enabled for department resources. Y - tracks, N/null - doesn't track time | Production | ||||
| Flag whether time tracking is enabled for department resources. Y - tracks, N/null - doesn't track time Default: 0 Data Owner: Production |
|||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| DEPT (Departments) | HR.HR.DEPT (Departments) | DEPT.DEPT = HR.HR.DEPT.CODE | User-defined relation |
|
|
DEPT.DEPT = HR.HR.DEPT.CODE Name: User-defined relation |
||||
| RES (Resources) | DEPT (Departments) | RES.DEPT = DEPT.DEPT | User-defined relation |
|
|
RES.DEPT = DEPT.DEPT Name: User-defined relation |
||||
| TIME (Time tracking) | DEPT (Departments) | TIME.DEPT = DEPT.DEPT | User-defined relation |
|
|
TIME.DEPT = DEPT.DEPT Name: User-defined relation |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PKDEPT | DEPT | ||
Uses
| Name |
|---|
|
DEPT (Departments)
|
Used by
| Name |
|---|
|
DEPT (Departments)
|
Exported: 2019-02-04 23:17, Last imported: 2018-03-05 00:17