HR_EVENT

HR_EVENT Table Schema

The table below presents the data mappings for the HR_EVENT table where the source variables refer to the column names in the base data set.

HR_EVENT Variable	Source Variable	Note
hr_event_id	N/A	(Auto-generated by a computer program)
employee_id	eessno
year_of_event	effdtdt	Extract the year
month_of_event	effdtdt	Extract the month
day_of_event	effdtdt	Extract the day
event_date	effdtdt
hr_event_concept_id	--
hr_event_source_value	action
hr_event_source_concept_id	actioncd
hr_event_description	actionde
hr_event_reason	reasoncd