Global Address Data:Database Layouts - Revision history

Admin at 22:50, 20 October 2023

2023-10-20T22:50:34Z

← Older revision		Revision as of 22:50, 20 October 2023
Line 147:		Line 147:
	\|Longitude\|\|decimal\|\|9\|\|Geographic coordinate for a particular delivery point.		\|Longitude\|\|decimal\|\|9\|\|Geographic coordinate for a particular delivery point.
	\|-		\|-
	\|DateAdded\|\|datetime\|\|8\|\| ~~Data~~ was added		\|DateAdded\|\|datetime\|\|8\|\| Date data was added.
	\|-		\|-
	\|GeoLevel\|\|varchar\|\|1\|\|		\|GeoLevel\|\|varchar\|\|1\|\|

Admin at 22:50, 20 October 2023

2023-10-20T22:50:16Z

← Older revision		Revision as of 22:50, 20 October 2023
Line 147:		Line 147:
	\|Longitude\|\|decimal\|\|9\|\|Geographic coordinate for a particular delivery point.		\|Longitude\|\|decimal\|\|9\|\|Geographic coordinate for a particular delivery point.
	\|-		\|-
	\|DateAdded\|\|datetime\|\|8\|\| Data ~~data~~ was added		\|DateAdded\|\|datetime\|\|8\|\| Data was added
	\|-		\|-
	\|GeoLevel\|\|varchar\|\|1\|\|		\|GeoLevel\|\|varchar\|\|1\|\|

Admin: Admin moved page Melissa Address Table:Database Layouts to Global Address Data:Database Layouts

2021-03-31T19:00:06Z

Admin moved page Melissa Address Table:Database Layouts to Global Address Data:Database Layouts

← Older revision	Revision as of 19:00, 31 March 2021
(No difference)

Admin at 18:59, 31 March 2021

2021-03-31T18:59:34Z

← Older revision		Revision as of 18:59, 31 March 2021
Line 1:		Line 1:
	{{~~MelissaAddressTableNav~~}}		{{GlobalAddressDataNav}}

	{{CustomTOC}}		{{CustomTOC}}
Line 166:		Line 166:


	[[Category:~~Melissa~~ Address ~~Table~~]]		[[Category:Global Address Data]]

Admin at 22:52, 31 May 2019

2019-05-31T22:52:47Z

← Older revision		Revision as of 22:52, 31 May 2019
Line 40:		Line 40:
	\|-		\|-
	\|AddressType\|\|char\|\|1\|\|Address Type Indicator		\|AddressType\|\|char\|\|1\|\|Address Type Indicator
	*~~See [[Result Code Details#Melissa Address Table\|Melissa Address Table Result Codes]]~~		*A - Alias
			*F - Firm or Company address
			*G - General Delivery address
			*H - High Rise or Business complex
			*P - PO Box address
			*R - Rural Route address
			*S - Street or Residential address
			*U or Z - Unique
	\|-		\|-
	\|RBDI\|\|char\|\|1\|\|Business/Residential indication		\|RBDI\|\|char\|\|1\|\|Business/Residential indication

Admin at 16:42, 23 May 2019

2019-05-23T16:42:57Z

← Older revision		Revision as of 16:42, 23 May 2019
Line 52:		Line 52:
	\|DateAdded\|\|datetime\|\|8\|\|Updated Date		\|DateAdded\|\|datetime\|\|8\|\|Updated Date
	\|-		\|-
	\|GeoLevel\|\|varchar\|\| \|\|Geo Level		\|GeoLevel\|\|varchar\|\|1\|\|Geo Level
	*B - Record was coded to rooftop level.		*B - Record was coded to rooftop level.
	A - Record was coded to interpolated rooftop level.		A - Record was coded to interpolated rooftop level.

Admin at 16:36, 23 May 2019

2019-05-23T16:36:46Z

← Older revision		Revision as of 16:36, 23 May 2019
Line 5:		Line 5:
	==US Address Field Names==		==US Address Field Names==
	{\|class="alternate01 sortable" cellspacing="0"		{\|class="alternate01 sortable" cellspacing="0"
	!~~Field~~ Name!!Definition		!Column Name!!Data Type!!Data Len!!Definition
	\|-		\|-
	\|MAK\|\|10-digit random key assigned to each address.		\|MAK\|\|bigint\|\|8\|\|10-digit random key assigned to each address.
	\|-		\|-
	\|Active\|\|Specifies if the address is active. True (1) or False (0).		\|Active\|\|bigint\|\|8\|\|Specifies if the address is active. True (1) or False (0).
	\|-		\|-
	\|Address\|\|Street Address		\|Address\|\|varchar\|\|50\|\|Street Address
	\|-		\|-
	\|Suite\|\|Suite Number		\|Suite\|\|varchar\|\|20\|\|Suite Number
	\|-		\|-
	\|Urbanization\|\|Urbanization Indicator		\|Urbanization\|\|varchar\|\|28\|\|Urbanization Indicator
	\|-		\|-
	\|City\|\|City		\|City\|\|varchar\|\|35\|\|City
	\|-		\|-
	\|State\|\|~~Name of the~~ State Abbreviation		\|State\|\|char\|\|2\|\|Two-character State Abbreviation
	\|-		\|-
	\|AddressKey\|\|Address Key is made of Zipcode/Plus4/DPV		\|AddressKey\|\|char\|\|11\|\|Address Key is made of Zipcode/Plus4/DPV
	\|-		\|-
	\|ParsedRange\|\|House Number. For Example: '6450'		\|ParsedRange\|\|varchar\|\|10\|\|House Number. For Example: '6450'
	\|-		\|-
	\|ParsedPreDir\|\|Direction. For Example: 'E'		\|ParsedPreDir\|\|varchar\|\|5\|\|Direction. For Example: 'E'
	\|-		\|-
	\|ParsedName\|\|Street Name. For Example: 'Side'		\|ParsedName\|\|varchar\|\|40\|\|Street Name. For Example: 'Side'
	\|-		\|-
	\|ParsedSuffix\|\|For Example: 'Dr'		\|ParsedSuffix\|\|varchar\|\|10\|\|For Example: 'Dr'
	\|-		\|-
	\|ParsedPostDir\|\|For Example: 'NE'		\|ParsedPostDir\|\|varchar\|\|5\|\|For Example: 'NE'
	\|-		\|-
	\|ParsedSuiteName\|\|For Example: 'Apt'		\|ParsedSuiteName\|\|varchar\|\|10\|\|For Example: 'Apt'
	\|-		\|-
	\|ParsedSuiteRange\|\|For Example: 'Q'		\|ParsedSuiteRange\|\|varchar\|\|10\|\|For Example: 'Q'
	\|-		\|-
	\|BaseMAK\|\|the ID of the record’s parent for suites, apartments and PO Boxes		\|BaseMAK\|\| \|\| \|\|the ID of the record’s parent for suites, apartments and PO Boxes
	\|-		\|-
	\|AddressType\|\|Address Type Indicator		\|AddressType\|\|char\|\|1\|\|Address Type Indicator
	*See [[Result Code Details#Melissa Address Table\|Melissa Address Table Result Codes]]		*See [[Result Code Details#Melissa Address Table\|Melissa Address Table Result Codes]]
	\|-		\|-
	\|RBDI\|\|Business/Residential indication		\|RBDI\|\|char\|\|1\|\|Business/Residential indication
	\|-		\|-
	\|Latitude\|\|To the level of rooftop or interpolated rooftop for most address		\|Latitude\|\|decimal\|\|9\|\|To the level of rooftop or interpolated rooftop for most address
	\|-		\|-
	\|Longitude\|\|To the level of rooftop or interpolated rooftop for most address		\|Longitude\|\|decimal\|\|9\|\|To the level of rooftop or interpolated rooftop for most address
	\|-		\|-
	\|CensusKey\|\|Census Key statefp/Countyfp/tractce/blockce/suffixlce		\|CensusKey\|\|varchar\|\|16\|\|Census Key statefp/Countyfp/tractce/blockce/suffixlce
	\|-		\|-
	\|DateAdded\|\|Updated Date		\|DateAdded\|\|datetime\|\|8\|\|Updated Date
	\|-		\|-
	\|GeoLevel\|\|Geo Level		\|GeoLevel\|\|varchar\|\| \|\|Geo Level
	*B - Record was coded to rooftop level.		*B - Record was coded to rooftop level.
	A - Record was coded to interpolated rooftop level.		A - Record was coded to interpolated rooftop level.
Line 62:		Line 62:


	==Global Field Names==		==Global Address Field Names==
	Available countries: Canada, France, Germany, Italy, Spain, Portugal, and Slovenia		Available countries: Canada, France, Germany, Italy, Spain, Portugal, and Slovenia

Admin at 23:18, 8 May 2019

2019-05-08T23:18:53Z

← Older revision		Revision as of 23:18, 8 May 2019
Line 64:		Line 64:
	==Global Field Names==		==Global Field Names==
	Available countries: Canada, France, Germany, Italy, Spain, Portugal, and Slovenia		Available countries: Canada, France, Germany, Italy, Spain, Portugal, and Slovenia


	{\|class="alternate01 sortable" cellspacing="0"		{\|class="alternate01 sortable" cellspacing="0"

Admin at 23:18, 8 May 2019

2019-05-08T23:18:37Z

Show changes

Admin at 23:03, 8 May 2019

2019-05-08T23:03:23Z

Show changes