dx_promotion_platform_app_20230713@dx-promotion-platform-crdb.us-west-2.aws.ddnw.net:26257/dx_promotion_platform> select * from dasher_promotion where market_id = 75 and end_time > current_timestamp();
id | name | description | prototype_id | status | start_time | end_time | dasher_criteria | promotion_parameters | metadata | created_at | created_by | updated_at | updated_by | market_id | incentive_type | starting_point_id | monetary
---------------------------------------+------------------------------+------------------------------+--------------------------------------+--------+-------------------------------+-------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------+------------+-------------------------------+------------+-----------+--------------------------------------------+-------------------+-------------------------------------------------------------------------------
f2629a78-8538-48d0-856d-a52ca8242c4b | Pay Campaign | | 00000000-0000-0000-0000-000000001111 | ACTIVE | 2126-04-26 02:00:00+00 | 2126-04-26 04:59:00+00 | {"allowlistDasherIds": [], "allowlistStartingPointIds": [1526], "allowlistSubmarketIds": [], "dasherCriterionType": "DASHER_CRITERION_TYPE_ALLOWLIST", "marketId": 75} | {"incentiveType": "INCENTIVE_TYPE_MONETARY_PEAK_PAY_PROACTIVE", "incentiveValue": {"basePayPercentage": null, "cxPromoDetails": null, "cxPromoTarget": null, "distanceMultiplierPerMeter": null, "monetary": {"currency": "USD", "displayString": "$1", "symbol": "$", "unitAmount": 100}, "points": null}, "internal": {"rules": []}, "payOutInfo": "PAY_OUT_TYPE_PER_DELIVERY"} | {"DEACTIVATION": {"deactivatedBy": "{\n}", "deactivationReason": "DEACTIVATION_REASON_UNSPECIFIED", "deactivationReasonDetails": ""}, "EDUCATION": "", "NOTIFICATION": "NOTIFICATION_TYPE_UNSPECIFIED", "OTHER": "{\"type\":\"proactive\",\"ops-reason\":\"kill-mitigation\",\"variant\":\"control\"}"} | 2026-04-28 21:57:36.830259+00 | 0 | 2026-04-28 21:57:36.83026+00 | 0 | 75 | INCENTIVE_TYPE_MONETARY_PEAK_PAY_PROACTIVE | 1526 | {"currency": "USD", "displayString": "$1", "symbol": "$", "unitAmount": 100}
1d6699a1-073c-4744-b5e0-a8a499fbfa3e | Victor test 4 | Test incentive 3 | 00000000-0000-0000-0000-000000001111 | ACTIVE | 2038-02-01 06:00:00+00 | 2038-02-01 13:00:00+00 | {"allowlistDasherIds": [], "allowlistStartingPointIds": [], "allowlistSubmarketIds": [339], "dasherCriterionType": "DASHER_CRITERION_TYPE_UNSPECIFIED", "marketId": 75} | {"incentiveType": "INCENTIVE_TYPE_MONETARY_CHALLENGE", "incentiveValue": {"basePayPercentage": null, "cxPromoDetails": null, "cxPromoTarget": null, "distanceMultiplierPerMeter": null, "monetary": {"currency": "USD", "displayString": "", "symbol": "$", "unitAmount": 300}, "points": null}, "internal": {"rules": [{"businessIds": null, "businessVerticalId": null, "daysSinceOrientedAtMax": null, "daysSinceOrientedAtMin": null, "durationInSeconds": null, "experimentBucket": null, "maxActivePeakPayTotal": null, "maxMinutesSinceIncentiveStartTime": null, "maxNumDeliveriesSinceStaticDate": null, "maxNumLifetimeDeliveries": null, "maxShiftCheckInTime": null, "minMinutesSinceIncentiveStartTime": null, "minNumDeliveriesSinceStaticDate": null, "minNumLifetimeDeliveries": null, "minShiftCheckInTime": null, "numAssignsMax": null, "numAssignsMin": null, "numDeliveries": 2, "numMiles": null, "punchCardChallengeRules": null, "regFlfMax": null, "regFlfMin": null, "ruleType": "INCENTIVE_RULE_TYPE_UNSPECIFIED", "segment": "SUPPLY_SEGMENT_UNSPECIFIED", "shopperCohortLevels": null, "storeIds": null, "totalNumberOfItems": null, "totalNumberOfPerishableItems": null}]}, "payOutInfo": "PAY_OUT_TYPE_LAST_DELIVERY"} | {"DEACTIVATION": {"deactivatedBy": "{\n}", "deactivationReason": "DEACTIVATION_REASON_UNSPECIFIED", "deactivationReasonDetails": ""}, "EDUCATION": "", "NOTIFICATION": "NOTIFICATION_TYPE_UNSPECIFIED", "OTHER": "{}"} | 2026-03-10 21:15:02.295075+00 | 0 | 2026-03-10 21:15:02.295076+00 | 0 | 75 | INCENTIVE_TYPE_MONETARY_CHALLENGE | NULL | {"currency": "USD", "displayString": "", "symbol": "$", "unitAmount": 300}
6d196f8e-e1aa-4b22-8b5c-144ac4cddb6e | pro shopper peak pay segment | pro shopper peak pay segment | 00000000-0000-0000-0000-000000001111 | ACTIVE | 2026-06-22 18:44:03.350095+00 | 2026-06-22 19:44:03.350095+00 | {"allowlistDasherIds": [], "allowlistStartingPointIds": [11396], "allowlistSubmarketIds": [], "dasherCriterionType": "DASHER_CRITERION_TYPE_SEGMENT", "marketId": 75} | {"incentiveType": "INCENTIVE_TYPE_MONETARY_PEAK_PAY_SEGMENT", "incentiveValue": {"basePayPercentage": null, "cxPromoDetails": null, "cxPromoTarget": null, "distanceMultiplierPerMeter": null, "monetary": {"currency": "USD", "displayString": "$1", "symbol": "$", "unitAmount": 100}, "points": null}, "internal": {"rules": [{"businessIds": null, "businessVerticalId": null, "daysSinceOrientedAtMax": null, "daysSinceOrientedAtMin": null, "durationInSeconds": null, "experimentBucket": null, "maxActivePeakPayTotal": null, "maxMinutesSinceIncentiveStartTime": null, "maxNumDeliveriesSinceStaticDate": null, "maxNumLifetimeDeliveries": null, "maxShiftCheckInTime": null, "minMinutesSinceIncentiveStartTime": null, "minNumDeliveriesSinceStaticDate": null, "minNumLifetimeDeliveries": null, "minShiftCheckInTime": null, "numAssignsMax": null, "numAssignsMin": null, "numDeliveries": null, "numMiles": null, "punchCardChallengeRules": null, "regFlfMax": null, "regFlfMin": null, "ruleType": "INCENTIVE_RULE_TYPE_SEGMENT", "segment": "SUPPLY_SEGMENT_DSD_PRO", "shopperCohortLevels": null, "storeIds": null, "totalNumberOfItems": null, "totalNumberOfPerishableItems": null}]}, "payOutInfo": "PAY_OUT_TYPE_UNSPECIFIED"} | {"DEACTIVATION": {"deactivatedBy": "{\n}", "deactivationReason": "DEACTIVATION_REASON_UNSPECIFIED", "deactivationReasonDetails": ""}, "EDUCATION": "", "NOTIFICATION": "NOTIFICATION_TYPE_UNSPECIFIED", "OTHER": "{}"} | 2026-06-22 18:44:03.7746+00 | 0 | 2026-06-22 18:44:03.774601+00 | 0 | 75 | INCENTIVE_TYPE_MONETARY_PEAK_PAY_SEGMENT | 11396 | {"currency": "USD", "displayString": "$1", "symbol": "$", "unitAmount": 100}