HR_EVENT - AmericanManufacturingCohort/HR-CDM-Data-Transformation GitHub Wiki
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 |