| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPHuman Resources |
| 1 | AHEM | Employees - History | 89 | StatusOfP | Professional Status | nVarChar | 2 | 0 | -1 | 0=Trainee, 1=Worker, 2=Skilled Worker, 3=Supervisor/Foreman, 4=Office Worker, 5=Youth Help/Sheltered Workshop, 6=On Career Advancement Training, 7=Homeworker, 8=Part Time, 9=Part Time > 18 Hrs |
| 2 | OHEM | Employees | 89 | StatusOfP | Professional Status | nVarChar | 2 | 0 | -1 | 0=Trainee, 1=Worker, 2=Skilled Worker, 3=Supervisor/Foreman, 4=Office Worker, 5=Youth Help/Sheltered Workshop, 6=On Career Advancement Training, 7=Homeworker, 8=Part Time, 9=Part Time > 18 Hrs |
