Daily close Roll-up of raw punches → one row per user-day with status + duration procedures/imports/sp_close_attendance_day.sql SCD2 merge Handles brand-new keys ...