SITE_EVENT - AmericanManufacturingCohort/HR-CDM-Data-Transformation GitHub Wiki
The table below presents the data mappings for the SITE_EVENT table where the source variables refer to the column names in the base data set.
| SITE_EVENT Variable | Source Variable | Note |
|---|---|---|
| site_event_id | N/A | (Auto-generated by a computer program) |
| work_site_id | N/A | Foreign key to the WORK_SITE table |
| year_of_event | -- | |
| month_of_event | -- | |
| day_of_event | -- | |
| event_date | -- | |
| site_event_concept_id | -- | |
| site_event_source_value | -- | |
| site_event_source_concept_id | -- |