| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | T7EHS00_PROTEHSM | Proposed Health Surveillance Protocols from EHSM | 4 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
TOPOccupational Health |
2 | T7EHS00_COMMENPR | Comments at Start/End of a Protocol Assignment | 4 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
3 | T7EHS00_COMMENSC | Comments on Assignment of a Protocol to the Person | 4 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
4 | T7EHS00_PERPROSC | Assign Persons -> Protocols | 4 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
5 | T7EHS00_PERPRSCD | Enter Validity of Protocol with Respect to Person | 4 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
6 | T7EHS00_PREGANA | Table for Comment Field: Protocol_Regulation-analysis_text | 3 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
7 | T7EHS00_PREGDES | Table for Comment Field: Protocol_Regulation-description | 3 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
8 | T7EHS00_PREGFOL | Table for Comment Field: Protocol_Regulation-follow_up | 3 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
9 | T7EHS00_PREGPRO | Table for Comment Field: Protocol_Regulation-procedure_text | 3 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
10 | T7EHS00_PROT | Health Surveillance Protocols | 3 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
11 | T7EHS00_PROTAGNT | Agents for Protocol | 3 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
12 | T7EHS00_PROTEXAM | Examinations for Protocol | 3 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
13 | T7EHS00_PROTFREQ | Frequency of Protocol | 3 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
14 | T7EHS00_PROTJOB | Task Assignment Health Surv. Protocol | 3 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
15 | T7EHS00_PROTMEM | Table for Comment Field: Protocol Description | 3 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
16 | T7EHS00_PROTREG | Regulations for Protocol | 3 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
17 | T7EHS00_PROTT | Protocol Text Table | 3 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
18 | T7EHS00_PRO_TXT | Comment Lines for Protocols in Medical Service | 4 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
19 | T7EHS00_SRV_EXA | Individual Examinations in a Medical Service | 17 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
20 | T7EHS00_SRV_PROT | Health Surv. Protocols for a Med. Service | 4 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |
21 | T7EHS00_VACCH | EHS: Vaccination Data Header Information | 21 | PNUMBER | Protocol Number | nvarchar | 3 | 0 | | |