| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPOccupational Health |
| 1 | T7EHS00_EXAM | Examinations | 3 | EXAM_CODE | Examination Number | nvarchar | 17 | 0 | | |
| 2 | T7EHS00_EXAMLAB | Assignments of Examination to Lab. Tests | 3 | EXAM_CODE | Examination Number | nvarchar | 17 | 0 | | |
| 3 | T7EHS00_EXAMPHY | Assignments of Examination to Physical Tests | 3 | EXAM_CODE | Examination Number | nvarchar | 17 | 0 | | |
| 4 | T7EHS00_EXAMT | Examinations (Text Table) | 4 | EXAM_CODE | Examination Number | nvarchar | 17 | 0 | | |
| 5 | T7EHS00_EXA_AUD | Examination Results: Audiogram | 4 | EXAM_CODE | Examination Number | nvarchar | 17 | 0 | | |
| 6 | T7EHS00_EXA_LAB | Examination Results: Lab. Tests | 4 | EXAM_CODE | Examination Number | nvarchar | 17 | 0 | | |
| 7 | T7EHS00_EXA_PHY | Examination Results: Physical Tests | 4 | EXAM_CODE | Examination Number | nvarchar | 17 | 0 | | |
| 8 | T7EHS00_EXA_PUL | Examination Results: Pulmonary Function Test | 4 | EXAM_CODE | Examination Number | nvarchar | 17 | 0 | | |
| 9 | T7EHS00_EXA_TXT | Examination Comment Lines in Medical Service | 4 | EXAM_CODE | Examination Number | nvarchar | 17 | 0 | | |
| 10 | T7EHS00_LAB_TXT | Comment about Test Results in Medical Service | 4 | EXAM_CODE | Examination Number | nvarchar | 17 | 0 | | |
| 11 | T7EHS00_PROTEXAM | Examinations for Protocol | 5 | EXAM_CODE | Examination Number | nvarchar | 17 | 0 | | |
| 12 | T7EHS00_SRV_EXA | Individual Examinations in a Medical Service | 4 | EXAM_CODE | Examination Number | nvarchar | 17 | 0 | | |
