| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPOccupational Health |
1 | T7EHS00_ANA_DET | EHS: Case History of Person - Description | 5 | LINECOUNTER | Line Counter for Comment Lines | nvarchar | 6 | 0 | | |
2 | T7EHS00_ANA_TXT | Case History of Person | 4 | LINECOUNTER | Line Counter for Comment Lines | nvarchar | 6 | 0 | | |
3 | T7EHS00_BEF_TXT | Comment Lines for Results in Med. Service | 4 | LINECOUNTER | Line Counter for Comment Lines | nvarchar | 6 | 0 | | |
4 | T7EHS00_COMMENPR | Comments at Start/End of a Protocol Assignment | 6 | LINECOUNTER | Line Counter for Comment Lines | nvarchar | 6 | 0 | | |
5 | T7EHS00_COMMENSC | Comments on Assignment of a Protocol to the Person | 5 | LINECOUNTER | Line Counter for Comment Lines | nvarchar | 6 | 0 | | |
6 | T7EHS00_DIA_TXT | Diagnosis Comment Lines in the Medical Service | 4 | LINECOUNTER | Line Counter for Comment Lines | nvarchar | 6 | 0 | | |
7 | T7EHS00_EXA_TXT | Examination Comment Lines in Medical Service | 6 | LINECOUNTER | Line Counter for Comment Lines | nvarchar | 6 | 0 | | |
8 | T7EHS00_LAB_TXT | Comment about Test Results in Medical Service | 7 | LINECOUNTER | Line Counter for Comment Lines | nvarchar | 6 | 0 | | |
9 | T7EHS00_LIM_TXT | Comment Lines for Restrictions in Medical Service | 5 | LINECOUNTER | Line Counter for Comment Lines | nvarchar | 6 | 0 | | |
10 | T7EHS00_PERS_TXT | Comments on Person | 3 | LINECOUNTER | Line Counter for Comment Lines | nvarchar | 6 | 0 | | |
11 | T7EHS00_PREGANA | Table for Comment Field: Protocol_Regulation-analysis_text | 7 | LINECOUNTER | | nvarchar | 3 | 0 | | |
12 | T7EHS00_PREGDES | Table for Comment Field: Protocol_Regulation-description | 7 | LINECOUNTER | | nvarchar | 3 | 0 | | |
13 | T7EHS00_PREGFOL | Table for Comment Field: Protocol_Regulation-follow_up | 7 | LINECOUNTER | | nvarchar | 3 | 0 | | |
14 | T7EHS00_PREGPRO | Table for Comment Field: Protocol_Regulation-procedure_text | 7 | LINECOUNTER | | nvarchar | 3 | 0 | | |
15 | T7EHS00_PROTMEM | Table for Comment Field: Protocol Description | 5 | LINECOUNTER | | nvarchar | 3 | 0 | | |
16 | T7EHS00_PRO_TXT | Comment Lines for Protocols in Medical Service | 5 | LINECOUNTER | Line Counter for Comment Lines | nvarchar | 6 | 0 | | |
17 | T7EHS00_SRV_BEAT | Application: Comments on Consultations in Med. Service | 4 | LINECOUNTER | Line Counter for Comment Lines | nvarchar | 6 | 0 | | |
18 | T7EHS00_SRV_MSAT | Application: Comments on Medical Measures in Med. Service | 5 | LINECOUNTER | Line Counter for Comment Lines | nvarchar | 6 | 0 | | |
19 | T7EHS00_SRV_REOT | Comment Lines for Reopening of Medical Service | 4 | LINECOUNTER | Line Counter for Comment Lines | nvarchar | 6 | 0 | | |
20 | T7EHS00_SRV_TXT | Comment Lines for Medical Service | 3 | LINECOUNTER | Line Counter for Comment Lines | nvarchar | 6 | 0 | | |