10. ANALISIS EXTERNO
12.5 SUGERENCIA DE INDICADORES DE CONTROL
• Obtain the difference between the V coordinates. Then obtain the difference between the H coordinates
• Square the differences
• Add the squares of the two differences together
• Divide the sum of the squares by 10
• Take the square root of the result
• Round according to tariff
Carrier Billing: Advanced Topics
• Industry documents – NECA Tariff No. 4
• V&H 5016 1430, V&H 5038 1453
• Differences
– V 5038 – 5016 = 22 – H 1453 – 1430 = 23
• Differences squared – 22 X 22 = 484 – 23 X 23 = 529
• Total of differences – 484 + 529 = 1013
• Total of differences divided by 10 – 1013 / 10 = 101.3
• Square root of 101.3 = 10.0648
189
Carrier Billing: Advanced Topics
• Industry documents – NECA Tariff No. 4
• Report option allows both bill percentages and mileage calculations for all CLLI’s associated with the OCN selected
• Listing of office type codes
• Company code (OCN) list
190
Carrier Billing: Advanced Topics
• Industry documents – NECA Tariff No. 4
• Used by the industry to determine players on each route
• Used by customers to verify miles and billing percentages against CABs bills
• Must be updated for any network reconfigurations. Make sure changes are effective prior to billing or you may receive disputes. Because BP’s in joint provisioning require
concurrence, this will need to be negotiated in advance of a network reconfiguration
• Can be used for CABs database setup and/or verification
• NECA allows on-line access for Members, consultants, billing vendors
191
Carrier Billing: Advanced Topics
• Industry documents
– LERG (Local Exchange Routing Guide)
• LERG data supports the current local exchange network within the North American Numbering Plan (NANP) and identifies reported planned changes in the network. LERG is primarily designed to be used for routing of calls by service providers (wireless, wireline, inter and intra exchange, etc.). It also supports functions such as networking planning and engineering, numbering administration, and is used by companies, including many outside of the
telecommunications industry, to support a wide range of business operations and planning needs. The LERG has been in existence since 1984, and provides for a common basis for service providers within the NANP to directly report their numbering and routing information
Carrier Billing: Advanced Topics
• Industry documents – LERG
• Administered by Telcordia
• Provides routing data obtained from the Telcordia Business Integrated Routing and Rating Database System (BIRRDS) into which data is entered by Service Providers and/or their agents
• Close of business on the last working day of each month is the cutoff for the data in the LERG that is dated the first of the following month
• LERG contains numerous files. Most LERG files have one or more common elements that can be used to “tie” the files together to permit integrated reports, analysis, etc.
193
Carrier Billing: Advanced Topics
• Industry documents – LERG
• LERG 1 – provides high-level information about Operating Company Numbers (OCN’s) such as the name and type of company (ILEC, CLEC, Wireless, RBOC, etc.) and contact information
• LERG 2 – contains high-level country code information (e.g.
Republic of Hungary = 36). There is no City / Area Code information in this file
• LERG 3 – contains high-level information about NPA’s (Area Codes) including the date the NPA went or is going into effect and permissive dialing periods for splits
• LERG 4 – contains SS7 “Point Code” assignments
• LERG 5 – identifies the NPA’s in use within a LATA
194
Carrier Billing: Advanced Topics
• Industry documents – LERG
• LERG 6 – provides NPA NXX (central office code) information and, where applicable, BLOCK assignments within the NPA NXX. NPA NXX assignments are represented with a BLOCK value of “A”. Thousands Block Pooling assignments are represented by numeric BLOCK values (0-9). This file includes among other data, the Rate Center associated with each record, the OCN (company assigned the record), the serving switch/POI with an associated switch homing arrangement (SHA) Indicator, the identified “use” of the record (e.g. cellular, wireline) and LATA (both switch and Rate Center LATA)
195
Carrier Billing: Advanced Topics
• Industry documents – LERG
• LERG 7 – contains information regarding switches identified by an eleven-character CLLI code. There may be multiple CLLI codes for a single physical switch for various reasons such as the switch performing multiple functions (e.g. as an end office and as a tandem). This file provides high-level switch information such as address, V&H coordinates, switch functionalities, equipment type, etc.
• LERG 7 SHA – contains information regarding the homing arrangements associated with a given switch. Homing arrangements include such situations as mapping to a switch, any appropriate Feature Group B, C, and/or D tandems; STP’s; in the case of remotes, their Hosts; in the case of Points of Interfaces (POI’s), their actual switch; etc.
Carrier Billing: Advanced Topics
• Industry documents – LERG
• LERG 8 – represents Rate Centers. A Rate Center may be a section of a large city, a specific town, or an area that may encompass multiple towns. Rate Centers also have associated V&H Coordinates, derived from Latitude and Longitude, which are then used to compute distances between Rate Centers. In addition, LATA, MTA and NPA is identified for each Rate Center
• LERG 9 – is a “processed” file in that it is a processing of data provided in LERG 6, LERG 7, and LERG 7 SHA.
LERG9 essentially assesses the homing of switches
provided in LERG 7 SHA and summarizes that information by homed-to switch (e.g. by STP, Tandem, etc.)
197
Carrier Billing: Advanced Topics
• Industry documents – LERG
• LERG 10 – provides a mapping of localities to Access Tandem Codes
• LERG 11 – provides a mapping of NPA NXX’s to Access Tandem Codes
• LERG 12 – is a means by which companies report the Location Routing Numbers (LRN’s)
• LERG 13 – there is currently no LERG 13
• LERG 14 – provides data providers an opportunity to identify the tandem to which specific NPA NXX blocks can be routed
• LERG 15 – provides a relationship between 911 tandems and the counties that the tandems serve
198
Carrier Billing: Advanced Topics
• Industry documents – LERG
• Used by the industry to determine the routing of calls
• Used by customers to verify routing against CABs bills
• Must be updated for any network reconfigurations. Make sure changes are effective prior to billing or you may receive disputes
• Can be used to determine airline miles
• Can be used for wireless studies, intra/inter MTA
• Can be used for CABs database setup and/or verification
• Can be used to do many different types of queries. May need to link different files. Custom queries can be created
• Can be used to help determine local jurisdiction and/or populate local tables
199
Carrier Billing: Advanced Topics
• Industry documents
– TPM (Terminating Point Master file)
• Administered by Telcordia
• Supports various systems used for rating and billing
telephone calls and can be used as a source for certain data related to NPA NXX’s. It is useful for those who need to manage NPA NXX related data, who need to associate RAO to NPA NXX’s and who have a need for V&H and Rate Center information associated with NPA NXX’s
• TPM changes are locked on the 3rdThursday of each month and product issuances are dated the 15th of the month following creation
Carrier Billing: Advanced Topics
• Industry documents – TPM data elements
• Numbering Plan Area (Area Code)
• NXX Code (exchange, prefix)
• Operating Company Number
• IDDD Capability Indicator (0 = IDDD cannot originate from the NPA NXX. 1 = indicates it can)
• Vertical (V) Coordinate
• Horizontal (H) Coordinate
• LATA
• Rate Center
• Place Name
• State, Province, Country
201
Carrier Billing: Advanced Topics
• Industry documents – TPM data elements
• Revenue Accounting Office (RAO) (Bill to / Send to)
• Portability Indicator (1 (yes) in this field indicates that at least one line number in the NPA NXX may be ported)
• Thousands-Block Pooling Indicator (1 = Indicates that the NPA NXX has been identified to be part of a pool of NXX’s, within the given NPA, that are assigned 1000 lines at a time)
• NXX Type (wireline, paging, cellular, VoIP, etc.)
• Time Zone (numeric values for each time zone)
• Daylight Savings Time Indicator (0 = Not observed, 1 = Observed)
• Company Type (ILEC, RBOC, IXC, Cellular, ISP, CLEC, etc.)
• Special Calling Cards (RAO based)
• International data - Mexico
202
Carrier Billing: Advanced Topics
• Industry documents – TPM
• Can be used to determine jurisdiction, verify jurisdiction, maybe even reset jurisdiction
• Can be used to determine who owns the NPA NXX (blocks)
• Can be used to determine what type of company owns the NPA NXX by NXX type and/or company type
• Can be used to calculate airline mileage
• Can be used to verify and/or populate RAO
• Must be updated if any data elements change. Make sure changes are effective prior to billing or you may receive disputes
• Can be used for CABs database setup and/or verification
203