prazy1208/text2sql

1[2  {3    "index": 0,4    "rule_id": 1,5    "concept_name": "Transaction Activity",6    "description": "Transaction activity represents the overall movement of financial operations occurring within a system.",7    "insight": "Monitoring transaction activity helps organizations understand operational intensity and financial usage patterns.",8    "keywords": [9      "transactions",10      "transaction activity",11      "financial activity"12    ],13    "content": "Transaction Activity Transaction activity represents the overall movement of financial operations occurring within a system. Monitoring transaction activity helps organizations understand operational intensity and financial usage patterns. transactions transaction activity financial activity"14  },15  {16    "index": 1,17    "rule_id": 2,18    "concept_name": "Transaction Volume Trends",19    "description": "Transaction volume trends describe how the number of financial transactions changes over time.",20    "insight": "Analyzing transaction volume helps identify periods of increased financial activity or operational demand.",21    "keywords": [22      "transaction trends",23      "transaction volume",24      "transaction increase"25    ],26    "content": "Transaction Volume Trends Transaction volume trends describe how the number of financial transactions changes over time. Analyzing transaction volume helps identify periods of increased financial activity or operational demand. transaction trends transaction volume transaction increase"27  },28  {29    "index": 2,30    "rule_id": 3,31    "concept_name": "Account Activity",32    "description": "Account activity reflects how actively financial accounts are used for transactions or operations.",33    "insight": "Understanding account activity helps identify frequently used accounts and engagement patterns.",34    "keywords": [35      "account activity",36      "active accounts",37      "account usage"38    ],39    "content": "Account Activity Account activity reflects how actively financial accounts are used for transactions or operations. Understanding account activity helps identify frequently used accounts and engagement patterns. account activity active accounts account usage"40  },41  {42    "index": 3,43    "rule_id": 4,44    "concept_name": "Account Distribution",45    "description": "Account distribution describes how accounts are organized or spread across different categories or groups.",46    "insight": "Analyzing distribution helps organizations understand structural patterns within the financial system.",47    "keywords": [48      "account distribution",49      "account categories",50      "account groups"51    ],52    "content": "Account Distribution Account distribution describes how accounts are organized or spread across different categories or groups. Analyzing distribution helps organizations understand structural patterns within the financial system. account distribution account categories account groups"53  },54  {55    "index": 4,56    "rule_id": 5,57    "concept_name": "Financial Flow Analysis",58    "description": "Financial flow analysis examines how value moves across the financial system through transactions.",59    "insight": "Understanding flow patterns helps identify major channels of financial movement.",60    "keywords": [61      "financial flow",62      "money movement",63      "transaction flow"64    ],65    "content": "Financial Flow Analysis Financial flow analysis examines how value moves across the financial system through transactions. Understanding flow patterns helps identify major channels of financial movement. financial flow money movement transaction flow"66  },67  {68    "index": 5,69    "rule_id": 6,70    "concept_name": "Spending Patterns",71    "description": "Spending patterns describe how financial resources are utilized across various activities.",72    "insight": "Analyzing spending behavior helps organizations identify common expenditure trends.",73    "keywords": [74      "spending patterns",75      "financial spending",76      "expense behavior"77    ],78    "content": "Spending Patterns Spending patterns describe how financial resources are utilized across various activities. Analyzing spending behavior helps organizations identify common expenditure trends. spending patterns financial spending expense behavior"79  },80  {81    "index": 6,82    "rule_id": 7,83    "concept_name": "Revenue Activity",84    "description": "Revenue activity represents financial inflows generated through operational or business activities.",85    "insight": "Monitoring revenue activity helps organizations track financial performance over time.",86    "keywords": [87      "revenue activity",88      "income generation",89      "financial inflow"90    ],91    "content": "Revenue Activity Revenue activity represents financial inflows generated through operational or business activities. Monitoring revenue activity helps organizations track financial performance over time. revenue activity income generation financial inflow"92  },93  {94    "index": 7,95    "rule_id": 8,96    "concept_name": "Expense Activity",97    "description": "Expense activity reflects financial outflows resulting from operational or business expenditures.",98    "insight": "Tracking expense patterns helps organizations understand cost distribution and spending behavior.",99    "keywords": [100      "expenses",101      "cost activity",102      "financial outflow"103    ],104    "content": "Expense Activity Expense activity reflects financial outflows resulting from operational or business expenditures. Tracking expense patterns helps organizations understand cost distribution and spending behavior. expenses cost activity financial outflow"105  },106  {107    "index": 8,108    "rule_id": 9,109    "concept_name": "Financial Balance Monitoring",110    "description": "Balance monitoring focuses on tracking the financial position of accounts or entities over time.",111    "insight": "Understanding balance patterns helps identify financial stability and resource availability.",112    "keywords": [113      "balance monitoring",114      "account balances",115      "financial position"116    ],117    "content": "Financial Balance Monitoring Balance monitoring focuses on tracking the financial position of accounts or entities over time. Understanding balance patterns helps identify financial stability and resource availability. balance monitoring account balances financial position"118  },119  {120    "index": 9,121    "rule_id": 10,122    "concept_name": "Customer Financial Behavior",123    "description": "Customer financial behavior reflects how customers interact with financial services or perform financial operations.",124    "insight": "Studying financial behavior helps organizations understand customer engagement with financial systems.",125    "keywords": [126      "financial behavior",127      "customer transactions",128      "customer financial activity"129    ],130    "content": "Customer Financial Behavior Customer financial behavior reflects how customers interact with financial services or perform financial operations. Studying financial behavior helps organizations understand customer engagement with financial systems. financial behavior customer transactions customer financial activity"131  },132  {133    "index": 10,134    "rule_id": 11,135    "concept_name": "Transaction Frequency",136    "description": "Transaction frequency measures how often financial operations occur within a defined period.",137    "insight": "Monitoring frequency helps organizations detect changes in system usage patterns.",138    "keywords": [139      "transaction frequency",140      "transaction rate",141      "financial operations"142    ],143    "content": "Transaction Frequency Transaction frequency measures how often financial operations occur within a defined period. Monitoring frequency helps organizations detect changes in system usage patterns. transaction frequency transaction rate financial operations"144  },145  {146    "index": 11,147    "rule_id": 12,148    "concept_name": "Financial Activity Distribution",149    "description": "Financial activity distribution describes how financial operations are spread across different entities or accounts.",150    "insight": "Understanding distribution helps identify concentration of financial activity.",151    "keywords": [152      "financial distribution",153      "activity spread",154      "transaction concentration"155    ],156    "content": "Financial Activity Distribution Financial activity distribution describes how financial operations are spread across different entities or accounts. Understanding distribution helps identify concentration of financial activity. financial distribution activity spread transaction concentration"157  },158  {159    "index": 12,160    "rule_id": 13,161    "concept_name": "Financial Trends Over Time",162    "description": "Financial trends describe how financial activity evolves across different time periods.",163    "insight": "Trend analysis helps organizations identify growth patterns and financial cycles.",164    "keywords": [165      "financial trends",166      "transaction trends",167      "activity trends"168    ],169    "content": "Financial Trends Over Time Financial trends describe how financial activity evolves across different time periods. Trend analysis helps organizations identify growth patterns and financial cycles. financial trends transaction trends activity trends"170  },171  {172    "index": 13,173    "rule_id": 14,174    "concept_name": "High Activity Entities",175    "description": "High activity entities represent accounts or participants that show elevated levels of financial operations.",176    "insight": "Identifying high activity entities helps organizations monitor major contributors to financial activity.",177    "keywords": [178      "high activity accounts",179      "active entities",180      "frequent transactions"181    ],182    "content": "High Activity Entities High activity entities represent accounts or participants that show elevated levels of financial operations. Identifying high activity entities helps organizations monitor major contributors to financial activity. high activity accounts active entities frequent transactions"183  },184  {185    "index": 14,186    "rule_id": 15,187    "concept_name": "Financial Participation",188    "description": "Financial participation reflects how widely financial services or operations are used among participants.",189    "insight": "Analyzing participation helps understand adoption and engagement levels.",190    "keywords": [191      "financial participation",192      "system usage",193      "participant activity"194    ],195    "content": "Financial Participation Financial participation reflects how widely financial services or operations are used among participants. Analyzing participation helps understand adoption and engagement levels. financial participation system usage participant activity"196  },197  {198    "index": 15,199    "rule_id": 16,200    "concept_name": "Financial Growth Patterns",201    "description": "Financial growth patterns describe increases or decreases in financial activity levels over time.",202    "insight": "Understanding growth patterns helps organizations assess expansion or contraction in operations.",203    "keywords": [204      "financial growth",205      "activity growth",206      "transaction growth"207    ],208    "content": "Financial Growth Patterns Financial growth patterns describe increases or decreases in financial activity levels over time. Understanding growth patterns helps organizations assess expansion or contraction in operations. financial growth activity growth transaction growth"209  },210  {211    "index": 16,212    "rule_id": 17,213    "concept_name": "Operational Financial Insights",214    "description": "Operational financial insights focus on understanding the behavior and structure of financial operations within a system.",215    "insight": "These insights help organizations make informed decisions about financial management and operational efficiency.",216    "keywords": [217      "financial insights",218      "operational finance",219      "financial analytics"220    ],221    "content": "Operational Financial Insights Operational financial insights focus on understanding the behavior and structure of financial operations within a system. These insights help organizations make informed decisions about financial management and operational efficiency. financial insights operational finance financial analytics"222  },223  {224    "index": 17,225    "rule_id": 18,226    "concept_name": "Credit Utilization Analysis",227    "description": "Calculates credit card utilization by comparing current_balance against credit_limit from credit_cards table to identify usage patterns.",228    "insight": "Enables Text2SQL to answer queries about customer credit health, overspending risks, and credit availability across different card types.",229    "keywords": [230      "credit utilization",231      "credit limit usage",232      "card balance ratio"233    ],234    "content": "Credit Utilization Analysis Calculates credit card utilization by comparing current_balance against credit_limit from credit_cards table to identify usage patterns. Enables Text2SQL to answer queries about customer credit health, overspending risks, and credit availability across different card types. credit utilization credit limit usage card balance ratio"235  },236  {237    "index": 18,238    "rule_id": 19,239    "concept_name": "Loan Repayment Tracking",240    "description": "Monitors loan payment progress by joining loans and payments tables to track payment_amount against loan_amount over time.",241    "insight": "Supports queries about outstanding loan balances, payment completion rates, and delinquency identification for risk assessment.",242    "keywords": [243      "loan payments",244      "repayment status",245      "outstanding balance"246    ],247    "content": "Loan Repayment Tracking Monitors loan payment progress by joining loans and payments tables to track payment_amount against loan_amount over time. Supports queries about outstanding loan balances, payment completion rates, and delinquency identification for risk assessment. loan payments repayment status outstanding balance"248  },249  {250    "index": 19,251    "rule_id": 20,252    "concept_name": "Fraud Detection Metrics",253    "description": "Analyzes fraud_alerts by alert_type, alert_status, and linked transaction_id to measure fraud incident rates and resolution efficiency.",254    "insight": "Enables Text2SQL to identify fraud patterns, response times, and high-risk transaction types for security monitoring.",255    "keywords": [256      "fraud alerts",257      "suspicious transactions",258      "fraud detection rate"259    ],260    "content": "Fraud Detection Metrics Analyzes fraud_alerts by alert_type, alert_status, and linked transaction_id to measure fraud incident rates and resolution efficiency. Enables Text2SQL to identify fraud patterns, response times, and high-risk transaction types for security monitoring. fraud alerts suspicious transactions fraud detection rate"261  },262  {263    "index": 20,264    "rule_id": 21,265    "concept_name": "Investment Portfolio Performance",266    "description": "Tracks total_value trends in investment_accounts by account_type and customer_id to measure portfolio growth and allocation.",267    "insight": "Supports queries about investment returns, portfolio diversification, and customer wealth accumulation patterns.",268    "keywords": [269      "investment performance",270      "portfolio value",271      "investment growth"272    ],273    "content": "Investment Portfolio Performance Tracks total_value trends in investment_accounts by account_type and customer_id to measure portfolio growth and allocation. Supports queries about investment returns, portfolio diversification, and customer wealth accumulation patterns. investment performance portfolio value investment growth"274  },275  {276    "index": 21,277    "rule_id": 22,278    "concept_name": "Branch Performance Comparison",279    "description": "Aggregates account and transaction metrics by branch_id from branches table to compare city and state level banking activity.",280    "insight": "Enables geographic performance analysis, identifying high-performing branches and regional market opportunities.",281    "keywords": [282      "branch performance",283      "regional banking",284      "branch comparison"285    ],286    "content": "Branch Performance Comparison Aggregates account and transaction metrics by branch_id from branches table to compare city and state level banking activity. Enables geographic performance analysis, identifying high-performing branches and regional market opportunities. branch performance regional banking branch comparison"287  },288  {289    "index": 22,290    "rule_id": 23,291    "concept_name": "Account Balance Volatility",292    "description": "Analyzes balance fluctuations in account_balances_history by tracking recorded_at timestamps to identify stability patterns.",293    "insight": "Helps detect unusual account activity, cash flow issues, and accounts requiring attention or financial advisory services.",294    "keywords": [295      "balance changes",296      "account volatility",297      "balance history"298    ],299    "content": "Account Balance Volatility Analyzes balance fluctuations in account_balances_history by tracking recorded_at timestamps to identify stability patterns. Helps detect unusual account activity, cash flow issues, and accounts requiring attention or financial advisory services. balance changes account volatility balance history"300  },301  {302    "index": 23,303    "rule_id": 24,304    "concept_name": "Customer Relationship Tenure",305    "description": "Calculates customer lifetime by comparing created_at in customers table and opening_date in accounts to measure relationship duration.",306    "insight": "Supports customer segmentation queries, loyalty analysis, and retention strategy effectiveness measurement.",307    "keywords": [308      "customer tenure",309      "relationship duration",310      "customer age"311    ],312    "content": "Customer Relationship Tenure Calculates customer lifetime by comparing created_at in customers table and opening_date in accounts to measure relationship duration. Supports customer segmentation queries, loyalty analysis, and retention strategy effectiveness measurement. customer tenure relationship duration customer age"313  },314  {315    "index": 24,316    "rule_id": 25,317    "concept_name": "Multi-Product Customer Profiling",318    "description": "Identifies customers with multiple products by joining accounts, credit_cards, loans, and investment_accounts on customer_id.",319    "insight": "Enables cross-selling analysis, product penetration metrics, and identification of high-value multi-product customers.",320    "keywords": [321      "product holdings",322      "cross-product ownership",323      "customer products"324    ],325    "content": "Multi-Product Customer Profiling Identifies customers with multiple products by joining accounts, credit_cards, loans, and investment_accounts on customer_id. Enables cross-selling analysis, product penetration metrics, and identification of high-value multi-product customers. product holdings cross-product ownership customer products"326  },327  {328    "index": 25,329    "rule_id": 26,330    "concept_name": "Loan Interest Revenue Potential",331    "description": "Calculates expected interest revenue by multiplying loan_amount by interest_rate and loan duration from loans table.",332    "insight": "Supports revenue forecasting, loan portfolio profitability analysis, and pricing strategy optimization queries.",333    "keywords": [334      "loan interest",335      "interest revenue",336      "loan profitability"337    ],338    "content": "Loan Interest Revenue Potential Calculates expected interest revenue by multiplying loan_amount by interest_rate and loan duration from loans table. Supports revenue forecasting, loan portfolio profitability analysis, and pricing strategy optimization queries. loan interest interest revenue loan profitability"339  },340  {341    "index": 26,342    "rule_id": 27,343    "concept_name": "Payment Method Preferences",344    "description": "Analyzes payment_type distribution from payments table to identify preferred payment channels and methods by customer segments.",345    "insight": "Enables Text2SQL to answer queries about payment behavior, channel optimization, and customer convenience patterns.",346    "keywords": [347      "payment methods",348      "payment channels",349      "payment preferences"350    ],351    "content": "Payment Method Preferences Analyzes payment_type distribution from payments table to identify preferred payment channels and methods by customer segments. Enables Text2SQL to answer queries about payment behavior, channel optimization, and customer convenience patterns. payment methods payment channels payment preferences"352  },353  {354    "index": 27,355    "rule_id": 28,356    "concept_name": "Credit Card Expiry Management",357    "description": "Tracks expiry_date in credit_cards table to identify cards nearing expiration and renewal timing patterns.",358    "insight": "Supports proactive customer communication queries, renewal campaign targeting, and card lifecycle management.",359    "keywords": [360      "card expiry",361      "card renewal",362      "expiring cards"363    ],364    "content": "Credit Card Expiry Management Tracks expiry_date in credit_cards table to identify cards nearing expiration and renewal timing patterns. Supports proactive customer communication queries, renewal campaign targeting, and card lifecycle management. card expiry card renewal expiring cards"365  },366  {367    "index": 28,368    "rule_id": 29,369    "concept_name": "Geographic Customer Distribution",370    "description": "Aggregates customer counts by city and state from customers table to analyze market penetration and demographic spread.",371    "insight": "Enables market analysis queries, branch expansion planning, and regional marketing strategy optimization.",372    "keywords": [373      "customer geography",374      "market distribution",375      "regional customers"376    ],377    "content": "Geographic Customer Distribution Aggregates customer counts by city and state from customers table to analyze market penetration and demographic spread. Enables market analysis queries, branch expansion planning, and regional marketing strategy optimization. customer geography market distribution regional customers"378  },379  {380    "index": 29,381    "rule_id": 30,382    "concept_name": "Account Type Diversification",383    "description": "Analyzes account_type distribution across accounts and investment_accounts tables to measure product mix and preferences.",384    "insight": "Supports product portfolio queries, identifies gaps in account type offerings, and guides product development priorities.",385    "keywords": [386      "account types",387      "product mix",388      "account distribution"389    ],390    "content": "Account Type Diversification Analyzes account_type distribution across accounts and investment_accounts tables to measure product mix and preferences. Supports product portfolio queries, identifies gaps in account type offerings, and guides product development priorities. account types product mix account distribution"391  },392  {393    "index": 30,394    "rule_id": 31,395    "concept_name": "Loan Maturity Schedule",396    "description": "Tracks loan_end_date from loans table to forecast upcoming loan completions and refinancing opportunities.",397    "insight": "Enables cash flow forecasting, renewal opportunity identification, and loan book maturity analysis queries.",398    "keywords": [399      "loan maturity",400      "loan end dates",401      "maturing loans"402    ],403    "content": "Loan Maturity Schedule Tracks loan_end_date from loans table to forecast upcoming loan completions and refinancing opportunities. Enables cash flow forecasting, renewal opportunity identification, and loan book maturity analysis queries. loan maturity loan end dates maturing loans"404  },405  {406    "index": 31,407    "rule_id": 32,408    "concept_name": "Transaction-to-Fraud Correlation",409    "description": "Links transaction_id between transactions and fraud_alerts tables to calculate fraud rate by transaction_type and amount ranges.",410    "insight": "Supports risk profiling queries, identifies vulnerable transaction categories, and improves fraud prevention targeting.",411    "keywords": [412      "fraud by transaction type",413      "transaction fraud rate",414      "risky transactions"415    ],416    "content": "Transaction-to-Fraud Correlation Links transaction_id between transactions and fraud_alerts tables to calculate fraud rate by transaction_type and amount ranges. Supports risk profiling queries, identifies vulnerable transaction categories, and improves fraud prevention targeting. fraud by transaction type transaction fraud rate risky transactions"417  },418  {419    "index": 32,420    "rule_id": 33,421    "concept_name": "Customer Contact Completeness",422    "description": "Evaluates email and phone field population in customers table to measure contact information quality and completeness.",423    "insight": "Enables data quality queries, identifies communication gaps, and supports customer outreach effectiveness analysis.",424    "keywords": [425      "contact information",426      "customer reachability",427      "data completeness"428    ],429    "content": "Customer Contact Completeness Evaluates email and phone field population in customers table to measure contact information quality and completeness. Enables data quality queries, identifies communication gaps, and supports customer outreach effectiveness analysis. contact information customer reachability data completeness"430  },431  {432    "index": 33,433    "rule_id": 34,434    "concept_name": "Branch Account Concentration",435    "description": "Calculates account concentration by branch_id from accounts table to identify branch capacity and workload distribution.",436    "insight": "Supports operational efficiency queries, staffing optimization, and identifies underutilized or overburdened branches.",437    "keywords": [438      "accounts per branch",439      "branch concentration",440      "branch workload"441    ],442    "content": "Branch Account Concentration Calculates account concentration by branch_id from accounts table to identify branch capacity and workload distribution. Supports operational efficiency queries, staffing optimization, and identifies underutilized or overburdened branches. accounts per branch branch concentration branch workload"443  },444  {445    "index": 34,446    "rule_id": 35,447    "concept_name": "Payment Timeliness Analysis",448    "description": "Compares payment_date from payments table against loan payment schedules to measure on-time payment rates and delays.",449    "insight": "Enables delinquency tracking, credit risk assessment, and customer payment behavior pattern identification.",450    "keywords": [451      "payment punctuality",452      "late payments",453      "payment timeliness"454    ],455    "content": "Payment Timeliness Analysis Compares payment_date from payments table against loan payment schedules to measure on-time payment rates and delays. Enables delinquency tracking, credit risk assessment, and customer payment behavior pattern identification. payment punctuality late payments payment timeliness"456  },457  {458    "index": 35,459    "rule_id": 36,460    "concept_name": "Credit Card Issuance Trends",461    "description": "Analyzes issue_date patterns in credit_cards table by card_type to identify seasonal issuance trends and growth patterns.",462    "insight": "Supports acquisition campaign analysis, identifies successful card launch periods, and guides promotional timing.",463    "keywords": [464      "card issuance",465      "new cards",466      "card acquisition"467    ],468    "content": "Credit Card Issuance Trends Analyzes issue_date patterns in credit_cards table by card_type to identify seasonal issuance trends and growth patterns. Supports acquisition campaign analysis, identifies successful card launch periods, and guides promotional timing. card issuance new cards card acquisition"469  },470  {471    "index": 36,472    "rule_id": 37,473    "concept_name": "Customer Transaction Recency",474    "description": "Identifies time since last transaction by customer_id using transaction_date from transactions table to detect dormant accounts.",475    "insight": "Enables customer engagement queries, churn prediction, and reactivation campaign targeting for inactive customers.",476    "keywords": [477      "transaction recency",478      "last transaction",479      "dormant accounts"480    ],481    "content": "Customer Transaction Recency Identifies time since last transaction by customer_id using transaction_date from transactions table to detect dormant accounts. Enables customer engagement queries, churn prediction, and reactivation campaign targeting for inactive customers. transaction recency last transaction dormant accounts"482  }483]