SITE_HISTORY - AmericanManufacturingCohort/HR-CDM-Data-Transformation GitHub Wiki
The table below presents the data mappings for the SITE_HISTORY table where the source variables refer to the column names in the base data set.
| SITE_HISTORY Variable | Source Variable | Note |
|---|---|---|
| site_history_id | N/A | (Auto-generated by a computer program) |
| work_site_id | N/A | Foreign key to the WORK_SITE table |
| site_event_id | N/A | Foreign key to the SITE_EVENT table |
| year_of_record | -- | |
| month_of_record | -- | |
| day_of_record | -- | |
| record_date | -- | |
| site_owner | -- | |
| site_type_source_value | -- | |
| site_status_source_value | -- |