| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Business Partners | ||||||||||
| 1 | OSLP | Sales Employee | 9 | EmpID | Employee ID | Int | 11 | 0 | ||
| General | ||||||||||
| 2 | ARSC4 | Resources - Employees - Log | 2 | EmpID | Employee No. | nVarChar | 11 | 0 | ||
| 3 | RSC4 | Resources - Employees | 2 | EmpID | Employee No. | nVarChar | 11 | 0 | ||
| Human Resources | ||||||||||
| 4 | AHE1 | Absence Information | 1 | empID | Employee ID | Int | 11 | 0 | ||
| 5 | AHE2 | Education | 1 | empID | Employee No. | Int | 11 | 0 | ||
| 6 | AHE3 | Employee Reviews | 1 | empID | Employee No. | Int | 11 | 0 | ||
| 7 | AHE4 | Previous Employment | 1 | empID | Employee No. | Int | 11 | 0 | ||
| 8 | AHE6 | Employee Roles | 1 | empID | Employee No. | Int | 11 | 0 | ||
| 9 | AHE7 | Savings Payments | 1 | empID | Employee No. | Int | 11 | 0 | ||
| 10 | AHEM | Employees - History | 1 | empID | Employee No. | Int | 11 | 0 | ||
| 11 | HEM1 | Absence Information | 1 | empID | Employee ID | Int | 11 | 0 | ||
| 12 | HEM10 | Employee Branch Assignment | 1 | empID | Employee No. | Int | 11 | 0 | ||
| 13 | HEM2 | Education | 1 | empID | Employee No. | Int | 11 | 0 | ||
| 14 | HEM3 | Employee Reviews | 1 | empID | Employee No. | Int | 11 | 0 | ||
| 15 | HEM4 | Previous Employment | 1 | empID | Employee No. | Int | 11 | 0 | ||
| 16 | HEM5 | Employee Data Ownership Authorization | 1 | empID | Employee No. | Int | 11 | 0 | ||
| 17 | HEM6 | Employee Roles | 1 | empID | Employee No. | Int | 11 | 0 | ||
| 18 | HEM7 | Savings Payments | 1 | empID | Employee No. | Int | 11 | 0 | ||
| 19 | HET1 | Employee Transfer Details | 2 | empID | Foreign Key to OHEM | Int | 11 | 0 | ||
| 20 | HTM1 | Team Members | 3 | empID | Employee ID | Int | 11 | 0 | ||
| 21 | OHEM | Employees | 1 | empID | Employee No. | Int | 11 | 0 | ||