| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPIncident Recording |
| 1 | EHHSSC_AFFLAND | Affected Land Type | 3 | GDT_CODE | GDT Code with Field Length 3 | nvarchar | 3 | 0 | | |
| 2 | EHHSSC_BDYPART | Body Part Code | 3 | GDT_CODE | GDT Code with Field Length 3 | nvarchar | 3 | 0 | | |
| 3 | EHHSSC_BDYSIDE | Body Side Code | 3 | GDT_CODE | GDT Code with Field Length 2 | nvarchar | 2 | 0 | | |
| 4 | EHHSSC_EST_RSK | Estimated Risk | 3 | GDT_CODE | GDT Code with Field Length 2 | nvarchar | 2 | 0 | | |
| 5 | EHHSSC_INC_GRP | Incident Group Code | 3 | GDT_CODE | GDT Code with Field Length 3 | nvarchar | 3 | 0 | | |
| 6 | EHHSSC_INJIL | Injury / Illness Code | 3 | GDT_CODE | GDT Code with Field Length 3 | nvarchar | 3 | 0 | | |
| 7 | EHHSSC_INJILTP | Injury / Illness Type Code | 4 | GDT_CODE | GDT Code with Field Length 21 | nvarchar | 21 | 0 | | |
| 8 | EHHSSC_LOCAT | Location Classification | 3 | GDT_CODE | GDT Code with Field Length 3 | nvarchar | 3 | 0 | | |
| 9 | EHHSSC_MATSTAT | Material State Code | 3 | GDT_CODE | GDT Code with Field Length 3 | nvarchar | 3 | 0 | | |
| 10 | EHHSSC_NM_GRP | Near Miss Group Code | 3 | GDT_CODE | GDT Code with Field Length 3 | nvarchar | 3 | 0 | | |
| 11 | EHHSSC_OCC_TYP | Occupational Incident Type Code | 3 | GDT_CODE | GDT Code with Field Length 3 | nvarchar | 3 | 0 | | |
| 12 | EHHSSC_PER_ROL | Person Role Code | 3 | GDT_CODE | GDT Code with Field Length 10 | nvarchar | 10 | 0 | | |
| 13 | EHHSSC_REL_TYP | Release Type Code | 3 | GDT_CODE | GDT Code with Field Length 3 | nvarchar | 3 | 0 | | |
| 14 | EHHSSC_REPCRIT | Reporting Criteria (OSHA) Code | 3 | GDT_CODE | GDT Code with Field Length 3 | nvarchar | 3 | 0 | | |
| 15 | EHHSSC_SO_GRP | Safety Observation Group Code | 3 | GDT_CODE | GDT Code with Field Length 3 | nvarchar | 3 | 0 | | |
| TOPIntegration Objects |
| 16 | EHFNDC_PERGRP | Person Group | 3 | GDT_CODE | GDT Code with Field Length 3 | nvarchar | 3 | 0 | | |
