SITE_HISTORY

SITE_HISTORY Table Schema

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	--