| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPOccupational Health |
1 | T7EHS00_CAL_FAV | EHS: Medical Practice Calendar Favorites | 6 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
2 | T7EHS00_CAL_PHYS | Assgmt of MP Calendar Owner to Physician for Service Appt | 8 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
3 | T7EHS00_EXAM | Examinations | 19 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
4 | T7EHS00_EXAMLAB | Assignments of Examination to Lab. Tests | 12 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
5 | T7EHS00_EXAMPHY | Assignments of Examination to Physical Tests | 12 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
6 | T7EHS00_EXAMT | Examinations (Text Table) | 11 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
7 | T7EHS00_EXA_PHY | Examination Results: Physical Tests | 12 | CRDTIMESTAMP | | decimal | 15 | 0 | | |
8 | T7EHS00_LABTEST | Tests for Laboratory Examinations | 16 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
9 | T7EHS00_LABTESTT | Possible Tests for Laboratory Examinations | 10 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
10 | T7EHS00_PERPRSCD | Enter Validity of Protocol with Respect to Person | 10 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
11 | T7EHS00_PHYTEST | Tests for Physical Examinations | 13 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
12 | T7EHS00_PHYTESTT | Possible Tests for Physical Examinations | 10 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
13 | T7EHS00_PREGANA | Table for Comment Field: Protocol_Regulation-analysis_text | 13 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
14 | T7EHS00_PREGDES | Table for Comment Field: Protocol_Regulation-description | 13 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
15 | T7EHS00_PREGFOL | Table for Comment Field: Protocol_Regulation-follow_up | 13 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
16 | T7EHS00_PREGPRO | Table for Comment Field: Protocol_Regulation-procedure_text | 13 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
17 | T7EHS00_PROT | Health Surveillance Protocols | 37 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
18 | T7EHS00_PROTAGNT | Agents for Protocol | 15 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
19 | T7EHS00_PROTEXAM | Examinations for Protocol | 15 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
20 | T7EHS00_PROTFREQ | Frequency of Protocol | 15 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
21 | T7EHS00_PROTMEM | Table for Comment Field: Protocol Description | 11 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
22 | T7EHS00_PROTREG | Regulations for Protocol | 20 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
23 | T7EHS00_PROTT | Protocol Text Table | 11 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |
24 | T7EHS00_VACCH | EHS: Vaccination Data Header Information | 16 | CRDTIMESTAMP | Creation Time | decimal | 15 | 0 | | |