TIME (Time tracking) - Time tracking

Box Inc - Enterprise Data Catalog

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)
DEPT (Departments)
RES (Resources)

Exported: 2019-02-04 23:17, Last imported: 2018-03-05 00:17