SimPay
super.admin
My Profile
My Sessions
Two-Factor Auth
Logout
Home
1
Master Data Management
Organization Masters
State Master
City Master
Branch Master
Product & Service
Product Master
DSA Master
Bucket Masters
Vintage Masters
Employee Management
Dashboard
Employee List
Add Employee
Organization Chart
Payout Configuration
Categories
Functions
Norms
Payout Types
Field Registry
2
Data Ingestion Process
Ingestion Setup
Configuration
Master Configs
Export/Import Config
Frequency Config
Cycle Management
Ingestion Cycle Masters
Create Ingestion Cycle
Ad Hoc Campaigns
Data Upload
Upload Files
Data Validation
Monitoring & Analytics
Status Dashboard
Analytics Dashboard
Sync Status
Column Analysis
3
Payout Processing
Pre-Processing Setup
Field Configuration
Field Registry
Derived Fields
Pre-Processing Config
Summary Configuration
Payout Cycle Setup
Payout Cycle Masters
Create Payout Cycle
View Payout Cycles
Data Preparation
Evolved Records Dashboard
Search by Agreement
Template & Calculation
Template Management
Template Engine
Create Template
Edit Templates
Multi-Method Templates
Template Arrangements
Payout Execution
Calculate Payouts
Payout Dashboard
Dry Runs
Active Cycles
Finalization & Payment
Recipient Ledger
Finalization Control
4
Business User Tools
Visual Configuration
Orchestration Hub
Natural Language
Guided Wizard
Visual Canvas
Multi-Method Calculator
Template Arrangements
Field Management
Request Fields
Upload Excel
My Requests
Approve Requests
5
Reports & Analytics
Reports
6
Administration
Security Management
User Administration
User Management
Organizations
User Sessions
Access Control
Roles & Permissions
Role Categories
Security Settings
Workflow Management
Workflow Dashboard
Configure Workflows
Pending Approvals
My Requests
System Administration
Admin Dashboard
Database Viewer
Data Validation
Data Lifecycle
Cleanup Data
Performance Settings
7
Help & Support
Translation Demo
Create New Summary Query
Back to List
Basic Information
Name
*
Unique name used to reference this query
Description
Source Table
*
Select a table
agency_bill_master
bounce_penalty_master
bounce_report
bounce_report_inputs
branch_master
bucket_master
change_request_master
city_master
close_dump_inputs
digital_bounce_penal_inputs
digital_live_base
dpd_bom_inputs
dpd_eom_inputs
dsa_master
dual_allocation_inputs
ecs_dump_inputs
enhanced_employee_master
error_code_master
ic_four_receipt_dump_inputs
interface_master
min_max
online_dump_inputs
product_master
repo_dump_inputs
role_master
rural_allocation_inputs
rural_death_inputs
rural_ncl_recovery_inputs
rural_settlement_inputs
staging_payout_inputs
state_master
sub_product_master
tc_dashboard
trail_history_dump_inputs
urban_allocation_inputs
urban_bounce_penal_inputs
urban_death_inputs
urban_live_base
urban_settlement_inputs
vendortracker
vertical_master
vintage_master
ymo_receipt_dump_inputs
The primary table to query
Tags
Comma-separated tags for categorization
Active
Dimensions & Metrics
Dimensions (Group By)
*
Fields to group by (drag to reorder, order matters)
No dimensions selected. Add dimensions below.
Add Dimension
Metrics (Aggregations)
*
Add Metric
Table Joins
Add Join
Filters
Add Filter
Advanced Options
Order By
Add Ordering
Result Limit
Maximum number of results to return (optional)
Post-Processing Expression
Jinja
JSONLogic
Optional expression to apply to each result row after aggregation
Field Registry Integration
Auto-Sync Enabled
This summary query will automatically register its fields in the Field Registry upon saving:
Dimension fields
will be registered as filterable and gridable
Metric fields
will be registered as computable
All fields will be tracked with lifecycle management
Fields are never deleted, only deprecated when removed
Cancel
Save Summary Query
SUM
COUNT
AVG
MIN
MAX
DISTINCT COUNT
CUSTOM
Select Field
Join Table
Select a table
Alias
Join Type
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
Join Condition (ON)
Field
Select Field
Operator
= (Equal)
!= (Not Equal)
> (Greater Than)
>= (Greater or Equal)
< (Less Than)
<= (Less or Equal)
IN
NOT IN
LIKE
IS NULL
IS NOT NULL
Value
Select Field
Ascending
Descending