Address
Provides all address information from network table network_address__v.
| Global ODS Field | Field Type |
Source Data Connector: Network Table: network_address_ods__v |
Source Data Connector: Network FTP Table: network_address_ods__v |
|---|---|---|---|
| composite_key__v | varchar(100) |
|source_connector_name__v|souce_table_name__v|native_id__v| |
|source_connector_name__v|souce_table_name__v|native_id__v|start_date__v|end_date__v| |
| source_system_id__v | varchar(18) |
Extracted from Internal Admin Console (Source ID) |
Extracted from Internal Admin Console (Source ID) |
| native_id__v | varchar(18) | vid__v | vid__v |
| source_connector_name__v | varchar(100) |
Extracted from Internal Admin Console (Connector Name) |
Extracted from Internal Admin Console (Connector Name) |
| source_table_name__v | varchar(100) | network_address__v | network_address__v |
| address_line_1__v | varchar(150) | address_line_1__v | address_line_1__v |
| address_line_2__v | varchar(150) | address_line_2__v | address_line_2__v |
| address_line_3__v | varchar(150) | address_line_3__v | address_line_3__v |
| address_ordinal__v | numeric(3) | address_ordinal__v | address_ordinal__v |
| address_status__v | varchar(100) | address_status__v | address_status__v |
| address_type__v | varchar(100) | address_type__v | address_type__v |
| address_verification_status__v | varchar(100) | address_verification_status__v | address_verification_status__v |
| administrative_area__v | varchar(100) | administrative_area__v | administrative_area__v |
| administrative_area_referencetype__v | varchar(17) | AddressAdminArea | AddressAdminArea |
| cbsa__v | varchar(100) | cbsa__v | cbsa__v |
| country__v | varchar(100) | country__v | country__v |
| country_full_name__v | varchar(15) | AddressCountry | AddressCountry |
| entity_type__v | varchar(10) | entity_type__v | entity_type__v |
| entity_vid__v | varchar(20) | entity_vid__v | entity_vid__v |
| fax_1__v | varchar(30) | fax_1__v | fax_1__v |
| fax_2__v | varchar(30) | fax_2__v | fax_2__v |
| footnotes__v | varchar(100) | footnotes__v | footnotes__v |
| formatted_address__v | varchar(500) | formatted_address__v | formatted_address__v |
| ISO_3166_3__v | varchar(4) | ISO_3166_3__v | ISO_3166_3__v |
| ISO_3166_n__v | varchar(3) | ISO_3166_n__v | ISO_3166_n__v |
| latitude__v | numeric(15,8) | latitude__v | latitude__v |
| locality__v | varchar(150) | locality__v | locality__v |
| longitude__v | numeric(15,8) | longitude__v | longitude__v |
| organization__v | varchar(200) | organization__v | organization__v |
| organization_name__v | varchar(200) | organization_name__v | organization_name__v |
| organization_type__v | varchar(100) | organization_type__v | organization_type__v |
| phone_1__v | varchar(50) | phone_1__v | phone_1__v |
| phone_2__v | varchar(50) | phone_2__v | phone_2__v |
| post_box__v | varchar(100) | post_box__v | post_box__v |
| post_box_number__v | varchar(100) | post_box_number__v | post_box_number__v |
| post_box_type__v | varchar(20) | post_box_type__v | post_box_type__v |
| postal_code__v | varchar(20) | postal_code__v | postal_code__v |
| postal_code_primary__v | varchar(20) | postal_code_primary__v | postal_code_primary__v |
| postal_code_secondary__v | varchar(20) | postal_code_secondary__v | postal_code_secondary__v |
| record_state__v | varchar(20) | record_state__v | record_state__v |
| record_type__v | varchar(100) | record_type__v | record_type__v |
| return_code__v | varchar(100) | return_code__v | return_code__v |
| status_update_time__v | varchar(100) | status_update_time__v | status_update_time__v |
| thoroughfare__v | varchar(150) | thoroughfare__v | thoroughfare__v |
| vid__v | numeric(18) | vid__v | vid__v |
| start_date__v | timestamp | null | start_date__v |
| end_date__v | timestamp | null | end_date__v |
