added periods_id to event columns and populated values