14.1 Table Definitions
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
Related Pages:
- 14.1 Index of Table Names
- 14.1 System Configuration Tables
- 14.1 Scheduling Parameters Tables
- 14.1 Users, Roles, Profiles and Permissions Tables
- 14.1 Employees, Shifts and Postings Tables
- 14.1 Travel Tables
- 14.1 Jobs, Activities and Breaks Tables
- 14.1 Scheduling Constraints Tables
- 14.1 Auditing Tables
- 14.1 DB Tidying Tables
- 14.1 UI Support Tables
The tables are grouped by function in order to help with finding your way around. Most groupings will be obvious, but, where not, the following rules have been used:
- any table specifically to do with a single employee is in the 'Employee' grouping
- any table specifically to do with a single job is in the 'Job' grouping
- tables relating to groupings of employees (FRU, team etc) are in the 'Geography' grouping
- tables relating to scheduling data about the general employee or job, such as shift definitions, Local Knowledge definitions etc are in the 'Scheduling Constraints' grouping