{
        "source_table": "time_clocks",
        "target_table": "time_clock_aggregates",
        "group_by": ["user_id", "org_id"],
        "date_field": "clocked_at",
        "date_range_source": "filter",
        "require_date_filter": true,
        "primary_key": "time_clock_aggregate_id",
        "upsert_keys": ["user_id", "org_id", "start_date", "end_date"],
        "conditions": {
            "isdeleted": false
        },
        "aggregations": {
            "start_date": "FROM_FILTER",
            "end_date": "FROM_FILTER",
            "total_net_hours": "0.0",
            "total_overtime_hours": "0.0",
            "total_regular_hours": "0.0",
            "total_payable_hours": "0.0",
            "total_days_worked": "COUNT(DISTINCT clocked_at::date)"
        }
    }