reorder connection id and reserve results and add test for when current time crosses end time during activation