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