Systems and methods for allocating originating calling party identifiers across telecommunications service boundaries

A system for allocating originating calling party identifiers based on call traffic and population data, the system comprising:

• a network interface configured to receive a plurality of call records, each call record comprising an originating calling party identifier, a terminating calling party identifier, a timestamp, and an associated call count;
• a processor;
• a non-transitory memory storing instructions that, when executed by the processor, cause the system to implement:
• a classification module configured to distinguish the terminating calling party identifiers from the originating calling party identifiers within the plurality of call records by applying a column cardinality analysis, wherein the classification module assigns a column exhibiting a greater count of unique entries as the terminating calling party identifiers and assigns a column exhibiting a lesser count of unique entries as the originating calling party identifiers;
• a recon module configured to generate carrier heatmap data and destination heatmap data from the terminating calling party identifiers and to persist the carrier heatmap data and the destination heatmap data;
• a mapping module configured to associate the terminating calling party identifiers with one or more telecommunications-defined service boundaries, each of the telecommunications-defined service boundaries comprising at least one of:
• a regulatory partition, an industry-defined partition used for routing, a number assignment boundary, a billing boundary, an interconnection boundary, a jurisdictional rating boundary, or a compliance boundary;
• a traffic volume module configured to compute, for each of the telecommunications-defined service boundaries, a traffic volume value based on the associated call counts;
• a population datastore storing a population value for each of the telecommunications-defined service boundaries;
• a threshold evaluator configured to list each of the telecommunications-defined service boundaries identified that satisfy one or more selection criteria, the one or more selection criteria comprising at least one of:
• a traffic volume threshold, a population threshold, a wireless subscriber count, a telecom consumer count, or another configurable service demand indicator;
• a numbering plan partition selector configured, for each of the telecommunications-defined service boundaries identified, to:
• (i) retrieve one or more telecommunications numbering plan partitions applicable to each of the telecommunications-defined service boundaries identified;
• (ii) sort the one or more telecommunications numbering plan partitions based on at least one of the selection criteria;
• (iii) resolve ties between the one or more telecommunications numbering plan partitions using a deterministic rule stored in the non-transitory memory;
• and
• (iv) output a set of telecommunications numbering plan partitions for each of the telecommunications-defined service boundaries identified;
• a quantity calculator configured to compute, for each of the telecommunications-defined service boundaries identified, a required quantity of originating calling party identifiers as a weighted combination of the one or more selection criteria values, the required quantity being scaled to a predetermined range and rounded to an integer while enforcing a minimum quantity and a maximum quantity;
• and
• a report generator configured to output (i) a machine-actionable file comprising, for each of the telecommunications-defined service boundaries identified, the required quantity, the one or more selection criteria values, and the set of telecommunications numbering plan partitions determined by the numbering plan partition selector, and (ii) a vector-encoded heatmap report;
• wherein, when a size of the plurality of call records exceeds a dataset threshold, the system reduces processing time and memory utilization by applying a stratified sampling policy defined with respect to the telecommunications-defined service boundaries, the stratified sampling policy comprising:
• (i) computing a base sample size using a binomial proportion formula evaluated at a traffic-share cutoff;
• (ii) allocating per-boundary sample counts proportionally to computed shares of each of the telecommunications-defined service boundaries, the shares determined from the call records, subject to a per-boundary minimum floor and a borderline boost within a predetermined margin of the cutoff;
• and
• (iii) generating a pooled residual sample comprising records from each of the telecommunications-defined service boundaries that do not satisfy the selection criteria, and incorporating the pooled residual sample into the stratified sampling policy to maintain representation across all boundaries,
• thereby ensuring inclusion of the telecommunications-defined service boundaries that satisfy the selection criteria while maintaining a target error margin at the cutoff;
• and
• wherein the machine-actionable file is generated in a structured format suitable for direct ingestion by an automation client configured to procure originating calling party identifiers, the structured format eliminating manual reformatting and reducing end-to-end provisioning latency.