RES (Resources)
| Documentation | Time tracking |
| Name | RES |
| Title | Resources |
| Module | Time tracking |
Table holds resources that are subject to time tracking:
- Human resources
- Equipment
- Vehicles
Columns
| Key | Name | Data type | Null | Attributes | References | Description | Data Owner | Sensitive | ||
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | RESID (ID) | int | Table primary key | PK | ||||||
| Table primary key Data Owner: PK |
||||||||||
| 2 | NAME | varchar(50) | Name of the | PK | Yes | |||||
| Name of the Data Owner: PK Sensitive: Yes |
||||||||||
| 3 | REST (Type) | varchar(50) | Resource type: HR - human resources, EQ - equipment, V - vehicles. | PK | ||||||
| Resource type: HR - human resources, EQ - equipment, V - vehicles. Data Owner: PK |
||||||||||
| 4 | UID | varchar(50) | Unique resource ID. For HR this is employee no. For equipment and vehicles this is id from fixed assets ledger. | PK | ||||||
| Unique resource ID. For HR this is employee no. For equipment and vehicles this is id from fixed assets ledger. Data Owner: PK |
||||||||||
| 5 | EMPNO (Employee no) | varchar(50) | HR.HR.EMP (Employees) | Employee no (for human resources only). | PK | |||||
| Employee no (for human resources only). References: HR.HR.EMP (Employees) Data Owner: PK |
||||||||||
| 6 | INT (Internal flag) | char(10) | Flag whether resource is internal. 1 - internal, 0 - external. | PK | ||||||
| Flag whether resource is internal. 1 - internal, 0 - external. Data Owner: PK |
||||||||||
| 7 | DEPT (Department) | varchar(10) | DEPT (Departments) | Foreign key to departments table. | PK | |||||
| Foreign key to departments table. References: DEPT (Departments) Data Owner: PK |
||||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| RES (Resources) | DEPT (Departments) | RES.DEPT = DEPT.DEPT | User-defined relation |
|
|
RES.DEPT = DEPT.DEPT Name: User-defined relation |
||||
| RES (Resources) | HR.HR.EMP (Employees) | RES.EMPNO = HR.HR.EMP.EMP_NO | User-defined relation |
|
|
RES.EMPNO = HR.HR.EMP.EMP_NO 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 | |
|---|---|---|---|
| PKRES | RESID | ||
| UKRESUID | UID | ||
Uses
| Name |
|---|
|
RES (Resources)
|
Used by
| Name |
|---|
|
RES (Resources)
|
Exported: 2019-02-04 23:17, Last imported: 2018-03-05 00:17