TIME (Time tracking)
| Documentation | Time tracking |
| Name | TIME |
| Title | Time tracking |
| Module | Time tracking |
Time log entries.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | Data Owner | ||
|---|---|---|---|---|---|---|---|---|---|
| 1 | TIMID (ID) | int | Table primary key | Production | |||||
| Table primary key Data Owner: Production |
|||||||||
| 2 | DATE | date | Date that resource was utilised | Production | |||||
| Date that resource was utilised Data Owner: Production |
|||||||||
| 3 | RESID (Resource) | int | RES (Resources) | Resource that was utilised | Production | ||||
| Resource that was utilised References: RES (Resources) Data Owner: Production |
|||||||||
| 4 | DEPT (Code) | varchar(50) | DEPT (Departments) | Code of the department that assigned and approved work | Production | ||||
| Code of the department that assigned and approved work References: DEPT (Departments) Data Owner: Production |
|||||||||
| 5 | WO (Work order) | varchar(50) | Number of production work order | Production | |||||
| Number of production work order Data Owner: Production |
|||||||||
| 6 | LOC (Location) | varchar(50) | Work location from the list | Production | |||||
| Work location from the list Data Owner: Production |
|||||||||
| 7 | MIN (Time (mins)) | char(10) | Time in minutes the resource was utilised or time was spent by person on a task | Production | |||||
| Time in minutes the resource was utilised or time was spent by person on a task Data Owner: Production |
|||||||||
| 8 | APV (Approval) | char(1) | Flag whether department manager. Y - approved, N/null - not | Production | |||||
| Flag whether department manager. Y - approved, N/null - not Data Owner: Production |
|||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| TIME (Time tracking) | DEPT (Departments) | TIME.DEPT = DEPT.DEPT | User-defined relation |
|
|
TIME.DEPT = DEPT.DEPT Name: User-defined relation |
||||
| TIME (Time tracking) | RES (Resources) | TIME.RESID = RES.RESID | User-defined relation |
|
|
TIME.RESID = RES.RESID Name: User-defined relation |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PKTIME | TIMID | ||
Uses
| Name |
|---|
|
TIME (Time tracking)
|
Exported: 2019-02-04 23:17, Last imported: 2018-03-05 00:17