Data Dictionary Elements

The data elements needed to populate the Building List for successful import are group in three main sections: Required elements, Required based on special considerations, and Optional Elements.

Required Elements

The following elements are required for a successful import of Building Lists into The Connected World platform. These elements are marked as being required by the customer or system or both.

Street Address

The full address name of the street where the building or specified location resides, not including Address2 fields.

Characteristic	Requirements
Data type	string
Maximum data length	250 characters
Range of valid values	alphanumeric
Customer required Y/N	Y
System required Y/N	Y
Source of data	Customer
Special considerations	The system does not accept PO boxes as a valid address. If using a directional address in this field (for example, cell tower), the Latitude/Longitude field is required.

Country

The name of the country where the building or specified location resides.

Characteristic	Requirements
Data type	string
Maximum data length	100 characters
Range of valid values	Spell out the full country name; for example: United States, not U.S. (see also, special considerations)
Customer required Y/N	Y
System required Y/N	Y
Source of data	Customer
Special considerations	For international, provide the country name spelling in English.

State

The standard US Postal Service Abbreviation or full state name where the building or specified location resides.

Characteristic	Requirements
Data type	string
Maximum data length	100 characters
Range of valid values	alphanumeric
Customer required Y/N	Y
System required Y/N	Y
Source of data	Customer
Special considerations	Some international addresses do not have a state or province. If this is the case, re-enter the city name in this field.

City

The name of the city where the building or specified location resides.

Characteristic	Requirements
Data type	string
Maximum data length	100 characters
Range of valid values	alphanumeric
Customer required Y/N	Y
System required Y/N	Y
Source of data	Customer
Special considerations	N/A

Postal

The zip code where the building or specified location resides.

Characteristic	Requirements
Data type	string
Maximum data length	45 characters
Range of valid values	US format: Five, or zip code plus four Example: 12345, or 12345-6789
Customer required Y/N	Y
System required Y/N	Y
Source of data	Customer
Special considerations	International codes may vary from US format. If postal is unavailable or unknown, enter “0”.

Latitude

The angular distance of a place north or south of the earth’s equator, or of a celestial object north or south of the celestial equator, usually expressed in degrees and minutes.

Characteristic	Requirements
Data type	Numeric string
Maximum data length	100 characters
Range of valid values	-90 to +90 Default coordinate system is WGS1984
Customer required Y/N	N (with exception of the special considerations indicated below)
System required Y/N	Y
Source of data	Customer or Connectbase (see special considerations)
Special considerations	If using directional addresses and towers, the LAT/LONG is a required field. Except for directional addresses and towers, Connected World processes the LAT/LONG for you. You can, however, choose to provide your own LAT/LONG coordinates, up to six decimal places, which can then be used as alternate identification. This information is particularly useful when an address cannot be geocoded.

Longitude

The angular distance of a place east or west of the meridian at Greenwich, England, or west of the standard meridian of a celestial object, usually expressed in degrees and minutes.

Characteristic	Requirements
Data type	Numeric string
Maximum data length	100 characters
Range of valid values	-180 to +180 Default coordinate system is WGS1984
Customer required Y/N	N (with exception of the special considerations indicated below)
System required Y/N	Y
Source of data	Customer or Connectbase (see special considerations)
Special considerations	If using directional addresses and towers, the LAT/LONG is a required field. Except for directional addresses and towers, Connected World processes the LAT/LONG for you. You can, however, choose to provide your own LAT/LONG coordinates, up to six decimal places, which can then be used as alternate identification. This information is particularly useful when an address cannot be geocoded.

Building Category

Description of the type of building or specified location.

Characteristic	Requirements
Data type	string
Maximum data length	N/A
Range of valid values	Commercial Building Airport Data Center Government Health Care Land Military Residential School/University Utility Venue Wireless
Customer required Y/N	Y
System required Y/N	Y
Source of data	Customer/The Connected World platform
Special considerations	More than one Building Category can be entered for a single address. Multiple building categories must be separated by a comma with no space in between. For example: Land,Military

Network Build Status

A metric to identify the build status of a carrier’s network in a building.

Characteristic	Requirements
Data type	string
Maximum data length	N/A
Range of valid values	Connected In Progress Not Connected Planned Prospect *The spelling and spacing of these values must be entered exactly as shown above.
Customer required Y/N	Y
System required Y/N	Y
Source of data	Customer
Special considerations	All Connected addresses must be OnNet in Building Connectivity Status (see Building Connection Status. Note: The Network Build Status and Building Connection Status are directly correlated. Therefore, the following combinations are invalid: Connected, Near Net Not Connected, OnNet Not Connected, On Net-Limited Access However, a Connected, OffNet building is valid as it indicates a network connection in place that is served by a 3^rd party.

Building Connection Status

A metric that is used to identify the connectivity status of fiber-connected buildings.

Characteristic	Requirements
Data type	string
Maximum data length	N/A
Range of valid values	Near Net OffNet On Net – Limited Access OnNet Prospect *The spelling and spacing of these values must be entered exactly as shown above.
Customer required Y/N	Y
System required Y/N	Y
Source of data	Customer
Special considerations	All OnNet addresses must be “Connected” in the Network Build Status field. Note: The Building Connection Status and Network Build Status are directly correlated. Therefore, the following combinations are invalid: Connected, Near Net Not Connected, OnNet Not Connected, On Net-Limited Access Connected, OffNet However, a Connected, OffNet building is valid as it indicates a network connection in place that is served by a 3^rd party.

Ethernet Zone

The pricing zone for Ethernet services.

Characteristic	Requirements
Data type	Numeric
Maximum data length	10 digits
Range of valid values	1 - 10
Customer required Y/N	Y
System required Y/N	N
Source of data	Customer
Special considerations

Wave Zone

The pricing zone for Wavelength services.

Characteristic	Requirements
Data type	Numeric
Maximum data length	10 digits
Range of valid values	1 - 10
Customer required Y/N	Y
System required Y/N	N
Source of data	Customer
Special considerations

Verizon Pricing Zone

Characteristic	Requirements
Data type	alphanumeric string
Maximum data length	100 characters
Range of valid values	1 - 10
Customer required Y/N	Y
System required Y/N	N
Source of data	Customer
Special considerations

Transaction Indicator

Identifies the type of transaction for this building list; new, update, or delete.

Characteristic	Requirements
Data type	Alphabetical string
Maximum data length	1 character
Range of valid values	U for Update N for New D for Delete
Customer required Y/N	Y
System required Y/N	Y
Source of data	Customer
Special considerations	N/A

Street Name

Identifies the name of the street where the building or designated location resides.

Characteristic	Requirements
Data type	string
Maximum data length	100 characters
Range of valid values	alphanumeric
Customer required Y/N	Y
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations	System generated during data parsing.

Address Status

Indicates if the address is a validated USPS address.

Characteristic	Requirements
Data type	Numeric string
Maximum data length	N/A
Range of valid values	Matched indicates a valid USPS status No Match indicates no validation of USPS status
Customer required Y/N	N
System required Y/N	Y
Source of data	Connectbase/The Connected World platform
Special considerations

AT&T Serving Node CLLI

Characteristic	Requirements
Data type	Alphanumeric string
Maximum data length	11
Range of valid values	11
Customer required Y/N	Y for AT&T only
System required Y/N	N
Source of data	Customer
Special considerations	Connection point must be requested through AT&T process.

AT&T Unique Key

A unique key that is provided by AT&T after a new building is submitted by a Connectbase customer. Revisions to this record are made based on changes or deletions of data associated with the building.

Characteristic	Requirements
Data type	Combination of alphanumeric characters
Maximum data length	N/A
Range of valid values	Leading with customer identifier, followed by numeric string
Customer required Y/N	Y (see special considerations below)
System required Y/N	N
Source of data	Customer
Special considerations	Provided by AT&T after submission of a BLEAP report.

OCN

Operating Company Number (OCN). A four-character ID for a North American Telecom Carrier assigned by NECA (National Exchange Carrier Association) and used to identify the carrier.

Characteristic	Requirements
Data type	alphanumeric string
Maximum data length	4 characters
Range of valid values	N/A
Customer required Y/N	Y
System required Y/N	N
Source of data	Customer
Special considerations	Must be provided at time of implementation.

ICSC Code

The Interexchange Carrier Service Code (ICSC) identifies the provider service, specific by customer segment (CLEC, Wireless, or IXC)

Characteristic	Requirements
Data type	Character string
Maximum data length	4-characters
Range of valid values	N/A
Customer required Y/N	Y
System required Y/N	N
Source of data	Customer
Special considerations	Must be provided at time of implementation.

Required based on special considerations

The following elements are only required based on certain platform features and functions.

Building Key

A unique Connectbase-assigned key to identify the building

Characteristic	Requirements
Data type	Alphanumeric string
Maximum data length	100 characters
Range of valid values	N/A
Customer required Y/N	N
System required Y/N	N (with exception of the special considerations indicated below)
Source of data	Connectbase/The Connected World platform
Special considerations	Required if an existing building is to be updated and the Transaction Indicator is set to U. Required if an existing building is to be deleted and the Transaction Indicator is set to D. When this field is empty, the system generates the key when the Transaction Indicator is set to N.

Ethernet Handoff Type

Related to the type of service to be provided. For example, Ethernet service delivered via CAT5.

Characteristic	Requirements
Data type	String
Maximum data length	N/A
Range of valid values	CAT5 FIBER CAT5/FIBER
Customer required Y/N	N (with exception of the special considerations indicated below)
System required Y/N	N
Source of data	Customer
Special considerations	This is a required field if the building list is to be distributed to other providers.

Wavelength Handoff Type

Related to the type of service to be provided. For example, Ethernet, Sonet, or OTU.

Characteristic	Requirements
Data type	String
Maximum data length	N/A
Range of valid values	Ethernet SONET OTU
Customer required Y/N	N (with exception of the special considerations indicated below)
System required Y/N	N
Source of data	Customer
Special considerations	This is a required field if the building list is to be distributed to other providers.

Comcast Pricing Zone

Characteristic	Requirements
Data type	alphanumeric string
Maximum data length	3
Range of valid values	A - Z
Customer required Y/N	N (except see special considerations)
System required Y/N	N
Source of data	Customer
Special considerations	Required for Comcast distribution list format

CenturyLink Pricing Zone

Characteristic	Requirements
Data type	numeric
Maximum data length	100 characters
Range of valid values	1-10
Customer required Y/N	N (except see special considerations)
System required Y/N	N
Source of data	Customer
Special considerations	Required for CenturyLink building list format.

Sprint Pricing Zone

Characteristic	Requirements
Data type	string
Maximum data length	100 characters
Range of valid values	ONP<zone #>A ONP<zone #>D ONPICBA ONPICBD NNP<zone #>A NNP<zone #>D NNPICBA NNPICBD
Customer required Y/N	N (except see special considerations)
System required Y/N	N
Source of data	Customer
Special considerations	Required for Sprint building lists. Validate pricing zone values with your Sprint Account Manager

ATT Pricing Zone

Characteristic	Requirements
Data type	numeric
Maximum data length	1
Range of valid values	1-9
Customer required Y/N	N (except see special considerations)
System required Y/N	N
Source of data	Customer
Special considerations	Required for AT&T BLEAP report.

ATT Serving Node CLLI

Common Language Information Services Identifier (CLLI) used within the North American telecommunications industry to specify the location and function of telecommunications equipment or of a relevant location, such as an international border or a supporting equipment location.

See Serving Wire Center CLLI for more details.

Characteristic	Requirements
Data type	string
Maximum data length	11
Range of valid values	N/A
Customer required Y/N	N (except see special considerations)
System required Y/N	N
Source of data	Customer
Special considerations	Required for AT&T BLEAP report.

ATT Unique Key

Characteristic	Requirements
Data type	alphanumeric
Maximum data length	100
Range of valid values	N/A
Customer required Y/N	N (see special considerations)
System required Y/N	N
Source of data	Customer
Special considerations	Received from AT&T in BLEAP response file.

Pricing Zone

Geographic types for P2P pricing that tie to underlying service providers cost or to compensate for large stretches of geographic areas that are connected.

Characteristic	Requirements
Data type	numeric
Maximum data length	10
Range of valid values	N/A
Customer required Y/N	N (except see special considerations)
System required Y/N	N
Source of data	Customer
Special considerations	Required for P2P pricing.

Pricing Type

Identifies the location type for P2P Pricing Zones

Characteristic	Requirements
Data type	string
Maximum data length	N/A
Range of valid values	End User Data Center POP
Customer required Y/N	N (except see special considerations)
System required Y/N	N
Source of data	Customer
Special considerations	Required for P2P pricing.

Secondary NNI Location

Secondary network-to-network interface location.

Characteristic	Requirements
Data type	alphanumeric string
Maximum data length	200 characters
Range of valid values	Address, City, State, Zip Code
Customer required Y/N	N
System required Y/N	N (with exception of the special considerations indicated below)
Source of data	Customer
Special considerations	Same rules apply as Primary NNI Location.

Optional Data Dictionary Elements

The following elements are not required, however Connectbase recommends some of these elements be implemented to your building list configurations.

Building Name

The name of the building or the physical address of the building.

The building name designation is what appears on the TCW map when you click on a building.

Characteristic	Requirements
Data type	string
Maximum data length	250 characters
Range of valid values	alphanumeric
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations	Connectbase recommends that you populate this field; however, if this field is left blank, the system populates the field with the street address.

Global ID

A Connectbase proprietary ID system that provides a unique identification code for every location within the seven continents. The Global ID is categorized as follows:

The first two digits of the Global ID uses the ISO-2 Country Code to identify the specific country in which the location resides

The 11 digits Plus Code, which is encoded from the location’s coordinates (latitude and longitude), represents a 10 by 10-foot grid area

Following the plus code, the first two digits indicates spatial reference information that Connectbase has collected from the building footprint, the county parcel, and/or wireless structure. If the location is a building, the location is defined as:

C for campus
S for single-story building
M for multi-story building

If the location is a right of way or parcel, instead of a building, the location is defined as:

T for tower
P for pole
S for structure

The last two-digits enables the user to assign a number for identification of an access floor or entrance. The default value for the last two digits is “00”.

Note

Global ID is a new classification of data for The Connected World. While not all locations have been populated with the Global ID, Connectbase is working to populate the ID for all locations.

Characteristic	Requirements
Data type	alphanumeric
Maximum data length	100
Range of valid values	See description above
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations	Once Connectbase adds any building it gets auto populated.

MSA Name

The Metropolitan Statistical Area or the Core Base Statistical Area (CBSA).

Characteristic	Requirements
Data type	string
Maximum data length	100 characters
Range of valid values	alphabetic
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations	System automatically populates this field if the address is within any MSA area.

Vertical Coordinate

Refers to the V&H (Vertical and Horizontal) coordinate system, initially used by AT&T to calculate long-distance telephone call costs. It is used to calculate the Lat/Long for rate centers and wire centers, as well as the distances between them.

Characteristic	Requirements
Data type	numeric
Maximum data length	N/A
Range of valid values	0 – 10,000
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations

Horizontal Coordinate

Characteristic	Requirements
Data type	numeric
Maximum data length	N/A
Range of valid values	0 – 10,000
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations

Elevation

The terrain elevation.

Characteristic	Requirements
Data type	numeric string
Maximum data length	100 characters
Range of valid values	N/A
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations	For U.S., this field is specified in feet.

Building Number (Customer Unique Key)

This field is used to identify the building number, where applicable.

Characteristic	Requirements
Data type	string
Maximum data length	75 characters
Range of valid values	alphanumeric
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations	This data type equates to the same as the building number.

Access Medium (optional, but recommended)

The medium used for connectivity to the building or specified location.

Characteristic	Requirements
Data type	string
Maximum data length	N/A
Range of valid values	Coax/HFC Copper Fiber Wireless – Fixed Wireless – Mobile Wireless – Satellite Other *Must be spelled exactly as shown
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations	More than one access medium can be provided per address. Multiple access mediums must be separated by a comma with no space in between. For example, Copper, Fiber.

Fiber Ownership

This field is used to identify the fiber deployment status.

Characteristic	Requirements
Data type	String
Maximum data length	N/A
Range of valid values	Built IRU Leased *Must be spelled exactly as shown
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations	N/A

Diversity Type

Defines ownership of the fiber path.

Characteristic	Requirements
Data type	alpha
Maximum data length	N/A
Range of valid values	Dual-Owned Single-Owned Single-Leased Dual-Leased
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations

Protection Type

This field identifies the redundancy mechanism in place at this location

Characteristic	Requirements
Data type	String
Maximum data length	N/A
Range of valid values	Core Protected Dual Path Single Path All
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations

Serving Wire Center CLLI

Characteristic	Requirements
Data type	string
Maximum data length	11
Range of valid values	First four digits is location identifier; next two digits identifies the state; seventh and eighth digits identifies the street address. If an additional three characters is provided, they signify a unique equipment identity for the entity that created the CLLI code. In other words, 8-character CLLIs represent locations; 11-character CLLIs represent switching equipment at a specific location. There is often a one-to-many relationship of Serving Wire Center CLLI locations (8-characters) to multiple switches contained within them (11-characters). Serving Wire Centers are operated by ILECs assigned authorized to deliver service within an exchange. Other service providers may co-locate and operate additional switches within these facilities.
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations	System generated when LAT/LONG is accurately provided or generated. Connectbase receives the validation of active CLLI codes through licensing of the LERG, Record assignment of CLLI values stem from the Connectbase proprietary rendering of spatial data records that define the Serving Wire Centers for each active Central Office CLL code.

LATA

Local Access Transport Area. A term used in U.S. telecommunications regulation for the provision and administration of telecommunications services in the U.S.

Characteristic	Requirements
Data type	string
Maximum data length	Five digits
Range of valid values	N/A
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations	System generated Connectbase receives the validation of active LATA codes through licensing of the LERG.

NPA

Numbering Plan Areas, each identified by a three-digit NPA code, commonly called an area code.

NPAs represent an aggregation of exchange areas for which the given code is applicable. These Code/Exchange area relationships are assigned by the North American Numbering Plan Administration (NANPA) and published in the Local Exchange Routing Guide (LERG) database published monthly by ‘iconectiv’.

Characteristic	Requirements
Data type	string
Maximum data length	3 digits
Range of valid values	N/A
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations	System generated Connectbase receives the validation of active NPA codes through licensing of the LERG, NANPA planning letters, customer reporting, among other resources.

NXX

Area Code/Prefix (NPA/NXX) Assignment.

Valid Prefixes per NPA are published according to exchange switch specifications published in the LERG. A subset of NPA/NXX combinations are serviced by the incumbent Local Exchange Carriers (ILECS) operating Serving Wire Centers.

Characteristic	Requirements
Data type	string
Maximum data length	3 digits
Range of valid values	N/A
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations	System generated Connectbase receives the validation of active NPA/NXX codes through licensing of the LERG.

NPA-NXX

Combination of the Numbering Plan Area (NPA) and Area Code/Prefix (NXX). See NPA and NXX for details.

Install Interval

The timeframe for installation that is quoted by the provider to the customer. Install interval is in number of days and value can range from 1 to 365. An error message pops out in case of invalid input.

Characteristic	Requirements
Data type	numeric
Maximum data length	10
Range of valid values	N/A
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations	N/A

Supplier Name

Synonymous with service provider or carrier.

Characteristic	Requirements
Data type	string
Maximum data length	255
Range of valid values	N/A
Customer required Y/N	N (but recommended)
System required Y/N	N
Source of data	Customer
Special considerations

Special Construction Cost

Used to identify any special construction costs needed to bring a Near Net building OnNet.

Characteristic	Requirements
Data type	Numeric string
Maximum data length	N/A
Range of valid values	Greater than zero
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations	N/A

Demarc Code

Demarcation point is sometimes abbreviated as demarc, DMARC, or similar. The demarcation point varies between countries. The term MPOE (minimum or main point of entry) is synonymous, with the added implication that it occurs as soon as possible upon entering the customer premises.

Characteristic	Requirements
Data type	string
Maximum data length	N/A
Range of valid values	N/A
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations	Default to MPOE.

Access Customer Name

Identifies the purchaser of an access circuit (i.e., the vendor’s customer).

Characteristic	Requirements
Data type	string
Maximum data length	255 characters
Range of valid values	alphanumeric
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations

Access Floor

Identifies the floor where the customer’s end-user access circuit terminates.

Characteristic	Requirements
Data type	string
Maximum data length	45 characters
Range of valid values	alphanumeric
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations

Access Room

Identifies the room where the customer’s end-user access circuit terminates.

Characteristic	Requirements
Data type	string
Maximum data length	45 characters
Range of valid values	alphanumeric
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations

Minimum Circuit Level

Identifies the minimum circuit level required by this vendor to accept orders to bring a Near Net building OnNet (for example, 10M, 10G, 100G, etc., low speed EoC generally in 1.5 increments to 12mb).

Characteristic	Requirements
Data type	alphanumeric string
Maximum data length	N/A
Range of valid values	DS1 DS3 OC3 OC12 OC48 OC192 Ethernet (all possible speeds)
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations	N/A

Minimum Quantity To Accept an Order

Identifies the minimum circuit quantity required by this vendor to accept orders to bring a Near Net building OnNet.

Characteristic	Requirements
Data type	Numeric string
Maximum data length	N/A
Range of valid values	Greater than zero Default: 1
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations	N/A

Building CLLI

Common Language Information Services Identifier (CLLI), used to identify the building location. Network Site codes are typically used to identify building locations, specific to an address.

Characteristic	Requirements
Data type	alphanumeric string
Maximum data length	8
Range of valid values	First four characters represent a geographical code, the fifth and sixth characters represent a geopolitical code. The remaining two characters are uniquely assigned by iconectiv® to identify the building location.
Customer required Y/N	N
System required Y/N	N
Source of data	Customer Provided
Special considerations	None

Handoff Pricing

One-time pricing for hand-off of services to the location.

Characteristic	Requirements
Data type	numeric
Maximum data length	10
Range of valid values	N/A
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations

Indatel Pricing Zone

Characteristic	Requirements
Data type	numeric
Maximum data length	1
Range of valid values	1-5
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations

Distance Band

Identifies buildings within a certain distance range for Near Net analysis.

Characteristic	Requirements
Data type	numeric string
Maximum data length	N/A
Range of valid values	0 – 500 feet 501 - 1000 feet 1001 - 1500 feet 1501+ feet
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations	N/A

LOS Distance 1 Path

Line of Sight distance between nearest fiber route and location.

Characteristic	Requirements
Data type	numeric
Maximum data length	10
Range of valid values	feet
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations

LOS Distance 2 Path

Line of Sight distance between the second nearest fiber route to the location.

Characteristic	Requirements
Data type	numeric
Maximum data length	10
Range of valid values	feet
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations

ROW Distance 1 Path

Right of Way distance between the nearest fiber route to the location.

Characteristic	Requirements
Data type	numeric
Maximum data length	10
Range of valid values	feet
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations

ROW Distance 2 Path

Right of Way distance between the second nearest fiber route to the location.

Characteristic	Requirements
Data type	numeric
Maximum data length	10
Range of valid values	feet
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations

LOS Distance 1 Access Point

Line of Sight distance between the nearest access point, sometimes referred to as the splice point, to the location.

Characteristic	Requirements
Data type	numeric
Maximum data length	10
Range of valid values	feet
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations

LOS Distance 2 Access Point

Line of Sight distance between the second nearest access point, sometimes referred to as the splice point, to the location.

Characteristic	Requirements
Data type	numeric
Maximum data length	10
Range of valid values	feet
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations

ROW Distance 1 Access Point

Right of Way distance between the nearest access point, sometimes referred to as the splice point, to the location.

Characteristic	Requirements
Data type	numeric
Maximum data length	10
Range of valid values	feet
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations

ROW Distance 2 Access Point

Right of Way distance between the second nearest access point, sometimes referred to as the splice point, to the location.

Characteristic	Requirements
Data type	numeric
Maximum data length	10
Range of valid values	feet
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations

Building Competitive Rating

Competitive Ratings data helps customers better understand the competitive landscape and more effectively price services.

Characteristic	Requirements
Data type	string
Maximum data length	N/A
Range of valid values	Green – There is no other competitive fiber provider at this location other than the customer’s own network, the LEC or the cableco. Yellow – A single competitive fiber provider is present at this location Red – Two or more competitor fiber providers are present, in addition to the LEC or cableco, at this location
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations

Wave Install Interval

The timeframe for installation of wavelength services that is quoted by the provider to the customer.

Characteristic	Requirements
Data type	numeric
Maximum data length	10
Range of valid values	N/A
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations	N/A

Primary NNI Location

Primary Network-to-Network Interface location.

Characteristic	Requirements
Data type	Alphanumeric string
Maximum data length	200 characters
Range of valid values	Address, City, State, Zip Code
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations	If adding a Primary NNI location, the address must be complete, have a primary number, street name, city, state, and zip code. Commas are required between each. For example, 350 E Cermak Rd, Chicago, Illinois, 60616

Primary Number

Primary address information such as the building number in a street address.

Characteristic	Requirements
Data type	alphanumeric string
Maximum data length	7 digits
Range of valid values	Greater than zero
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations	System generated during data parsing.

Street Predirection

An address element that indicates geographic location such as N, S, E, W, NE, NW, SE, and SW that is placed to the left of (before) the street name such as E HOOVER ST.

Characteristic	Requirements
Data type	Alphabetic string
Maximum data length	2 characters
Range of valid values	N, S, E, W, NE, NW, SE, SW
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations	N/A

Street Postdirection

An address element that indicates geographic location such as N, S, E, W, NE, NW, SE, and SW that is placed to the right of (after) the street name such as BAY DRIVE W.

Characteristic	Requirements
Data type	Alphanumeric string
Maximum data length	N/A
Range of valid values	N, S, E, W, NE, NW, SE, SW
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations	System generated during data parsing.

Street Suffix

Identifies the type of roadway in abbreviated format, such as St., Blvd., etc.

Characteristic	Requirements
Data type	Alphanumeric string
Maximum data length	45 characters
Range of valid values	St, Blvd, Rd. Way, Cir, etc.
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations	System generated during data parsing.

Secondary Designator

Designation of the unit of the address, such as a suite number, apartment, etc.

Characteristic	Requirements
Data type	string
Maximum data length	75 characters
Range of valid values	alphanumeric
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations	System generated during data parsing.

Secondary Number

Identifier for a secondary address number, such as a floor number, room number, etc.

Characteristic	Requirements
Data type	string
Maximum data length	45 characters
Range of valid values	alphanumeric
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations	System generated during data parsing.

Extra Secondary Designator

Same description as Secondary Designator when additional designators are needed.

Characteristic	Requirements
Data type	string
Maximum data length	75 characters
Range of valid values	alphanumeric
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations	System generated during data parsing.

Extra Secondary Number

Same as Secondary Number when additional designators are needed.

Characteristic	Requirements
Data type	string
Maximum data length	45 characters
Range of valid values	alphanumeric
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations	System generated during data parsing.

Plus4 Code

A ZIP+4 Code uses the basic five-digit code plus four additional digits to identify a geographic segment within the five-digit delivery area, such as a city block, a group of apartments, an individual high-volume receiver of mail, a post office box, or any other unit that could use an extra identifier.

Characteristic	Requirements
Data type	Numeric string
Maximum data length	4 digits
Range of valid values	4-digit postal code extension (plus4 zip code)
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations	System generated during data parsing.

Property Type

An identifier that is used to identify the type of property.

Characteristic	Requirements
Data type	Numeric string
Maximum data length	N/A
Range of valid values	Commercial Residential Unknown
Customer required Y/N	N
System required Y/N	N
Source of data	Connectbase/The Connected World platform
Special considerations

Building Notes

Characteristic	Requirements
Data type	string
Maximum data length	N/A
Range of valid values	alphanumeric
Customer required Y/N	N
System required Y/N	N
Source of data	Customer
Special considerations	N/A

In this section:

Information Resource Center