add confirmation_ts to intermediate logs model
add confirmation_ts to intermediate logs model