| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPOccupational Health |
1 | T7EHS00_EXA_AUD | Examination Results: Audiogram | 5 | EXAM_COUNT | Number of Individual Examinations | nvarchar | 4 | 0 | | |
2 | T7EHS00_EXA_LAB | Examination Results: Lab. Tests | 5 | EXAM_COUNT | Number of Individual Examinations | nvarchar | 4 | 0 | | |
3 | T7EHS00_EXA_PHY | Examination Results: Physical Tests | 5 | EXAM_COUNT | Number of Individual Examinations | nvarchar | 4 | 0 | | |
4 | T7EHS00_EXA_PUL | Examination Results: Pulmonary Function Test | 5 | EXAM_COUNT | Number of Individual Examinations | nvarchar | 4 | 0 | | |
5 | T7EHS00_EXA_TXT | Examination Comment Lines in Medical Service | 5 | EXAM_COUNT | Number of Individual Examinations | nvarchar | 4 | 0 | | |
6 | T7EHS00_LAB_TXT | Comment about Test Results in Medical Service | 5 | EXAM_COUNT | Number of Individual Examinations | nvarchar | 4 | 0 | | |
7 | T7EHS00_SRV_EXA | Individual Examinations in a Medical Service | 5 | EXAM_COUNT | Number of Individual Examinations | nvarchar | 4 | 0 | | |