CVG_ADDR_HX

Description:

This table extracts each coverage's historical addresses.

Primary Key

Column Name	Ordinal Position
CVG_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CVG_ID	NUMERIC	No
	The unique identifier for the coverage record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	ADDR_HX_CITY	VARCHAR	No
	This item is used to store the city listed in a coverage's historical address.
4	ADDR_HX_STATE_C_NAME	VARCHAR	No
	This item is used to store the state listed in a coverage's historical address. May contain organization-specific values: Yes
5	ADDR_HX_ZIP	VARCHAR	No
	This item is used to store the ZIP code listed in a coverage's historical address.
6	ADDR_HX_COUNTY_C_NAME	VARCHAR	No
	This item is used to store the county listed in a coverage's historical address. May contain organization-specific values: Yes
7	ADDR_HX_COUNTRY_C_NAME	VARCHAR	No
	This item is used to store the country listed in a coverage's historical address. May contain organization-specific values: Yes
8	ADDR_HX_HOUSE_NUM	VARCHAR	No
	This item is used to store the house number listed in a coverage's historical address.
9	ADDR_HX_DISTRICT_C_NAME	VARCHAR	No
	This item is used to store the district listed in a coverage's historical address. May contain organization-specific values: Yes
10	ADDR_HX_CONTACT	VARCHAR	No
	This item is used to store the name of the contact person associated with a coverage's historical address.
11	ADDR_HX_START_DT	DATETIME	No
	This item is used to store the date on which a coverage's historical address became effective.
12	ADDR_HX_END_DT	DATETIME	No
	This item is used to store the date on which a coverage's historical address is no longer effective.
13	ADDR_HX_PDS_IDNT	VARCHAR	No
	This item is used to store the unique identifier assigned to a coverage's historical address by the Personal Demographics Service.
14	ADDR_HX_TYPE_C_NAME	VARCHAR	No
	This item is used to store the address type of a coverage's historical address. May contain organization-specific values: No Category Entries: Permanent Temporary Confidential Correspondence Next of Kin Subscriber Home