| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPOccupational Health |
1 | T7EHS00_EXA_AUD | Examination Results: Audiogram | 2 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
2 | T7EHS00_EXA_LAB | Examination Results: Lab. Tests | 2 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
3 | T7EHS00_EXA_PHY | Examination Results: Physical Tests | 2 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
4 | T7EHS00_EXA_PUL | Examination Results: Pulmonary Function Test | 2 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
5 | T7EHS00_EXA_TXT | Examination Comment Lines in Medical Service | 2 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
6 | T7EHS00_LAB_TXT | Comment about Test Results in Medical Service | 2 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
7 | T7EHS00_PRO_TXT | Comment Lines for Protocols in Medical Service | 2 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
8 | T7EHS00_SERVICE | Medical Service (Main Table) | 2 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
9 | T7EHS00_SRV_BEA | Application: Consultations in Med. Service | 2 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
10 | T7EHS00_SRV_BEAT | Application: Comments on Consultations in Med. Service | 2 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
11 | T7EHS00_SRV_BEF | Test Results for a Person | 11 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
12 | T7EHS00_SRV_DIA | Diagnoses for Person | 18 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
13 | T7EHS00_SRV_EXA | Individual Examinations in a Medical Service | 2 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
14 | T7EHS00_SRV_LIM | Restrictions of Medical Service | 5 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
15 | T7EHS00_SRV_MSA | Application: Medical Measures in Med. Service | 2 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
16 | T7EHS00_SRV_MSAT | Application: Comments on Medical Measures in Med. Service | 2 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
17 | T7EHS00_SRV_PROT | Health Surv. Protocols for a Med. Service | 2 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
18 | T7EHS00_SRV_REOT | Comment Lines for Reopening of Medical Service | 2 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
19 | T7EHS00_SRV_SCH | Appointments for Medical Service | 2 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |
20 | T7EHS00_SRV_TXT | Comment Lines for Medical Service | 2 | SRV_NUMBER | Number of Medical Service | nvarchar | 12 | 0 | | |