ADDRESS
The ADDRESS table records the location used for mailing and other street addresses. Only one address per CDADDRUSAGETP is allowed. For example, there can only be one "Mailing" address for a contact.
This table is used by the following domains.
Name | Comment | Datatype | Null Option | Is PK |
---|---|---|---|---|
ADDRESS_ID | A unique, system-generated key that identifies an address in the system. | BIGINT | Not Null | Yes |
COUNTRY_TP_CD | Identifies a country. | BIGINT | Null | No |
RESIDENCE_TP_CD | A type of residence for a given address. Some examples include Home, Apartment and Suite. | BIGINT | Null | No |
PROV_STATE_TP_CD | Identifies US States, Possessions, overseas military locations, as well as non-US country provinces. For overseas military locations, APO or FPO designations are used along with a "state" abbreviation, AE, AP, or AA, and the ZIP code. | BIGINT | Null | No |
ADDR_LINE_ONE | The first line of an address. | VARCHAR(100) | Not Null | No |
P_ADDR_LINE_ONE | The phonetic representation of the first line of an address. Not currently used. | CHAR(8) | Null | No |
ADDR_LINE_TWO | The second line of an address. | VARCHAR(100) | Null | No |
P_ADDR_LINE_TWO | The phonetic representation of the second line of an address. Not currently used. | CHAR(8) | Null | No |
ADDR_LINE_THREE | The third line of an address. | VARCHAR(100) | Null | No |
P_ADDR_LINE_THREE | The phonetic representation of the third line of an address. Not currently used. | CHAR(8) | Null | No |
CITY_NAME | The city of an address. | VARCHAR(50) | Not Null | No |
POSTAL_CODE | Postal Codes, and ZIP Codes, are used by the postal system to uniquely identify an address location. | VARCHAR(20) | Null | No |
ADDR_STANDARD_IND | Indicates whether this address is standardized. | CHAR(1) | Null | No |
OVERRIDE_IND | Indicates whether the address standardization process should be overridden. | CHAR(1) | Null | No |
RESIDENCE_NUM | The apartment, suite, or unit number of the address. | VARCHAR(10) | Null | No |
COUNTY_CODE | A three-digit postal code used to identify the county of the post office. | CHAR(3) | Null | No |
LATITUDE_DEGREES | Latitude of Measure in Degrees identifies an angular distance north or south. Latitude Degrees is useful for Mapping Software (for example, to identify the nearest doctors office). | VARCHAR(10) | Null | No |
LONGITUDE_DEGREES | Longitude of Measure in Degrees identifies an angular distance east or west. Longitude Degrees is useful for Mapping Software (for example, to identify the nearest doctors office). | VARCHAR(10) | Null | No |
LAST_UPDATE_DT | When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. | TIMESTAMP | Not Null | No |
LAST_UPDATE_USER | The ID of the user who last updated the data. | VARCHAR(20) | Null | No |
LAST_UPDATE_TX_ID | A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row. | BIGINT | Null | No |
POSTAL_BARCODE | The structure of the 12 digits postal bar code is as follows: 5 digits for the ZIP code; 4 digits for the ZIP+4 code; 2 digits representing the last 2 digits of the street address; 1 digit checksum calculated as the sum of the other digits modulo 10. | VARCHAR(30) | Null | No |
P_CITY | The phonetic key for City. | VARCHAR(20) | Null | No |
BUILDING_NAME | The name of the building. | VARCHAR(64) | Null | No |
STREET_NUMBER | The street number of the building. For example: "55" in the address "55 Main Road East". | VARCHAR(16) | Null | No |
STREET_NAME | The name of the street. For example: "Main" in the address "55 Main Road East". | VARCHAR(64) | Null | No |
STREET_SUFFIX | The type of street. For example: "Road" in the address "55 Main Road East". | VARCHAR(16) | Null | No |
PRE_DIRECTIONAL | A directional element of the address. | VARCHAR(16) | Null | No |
POST_DIRECTIONAL | A directional element of the address. For example: "East" in the address "55 Main Road East". | VARCHAR(16) | Null | No |
BOX_DESIGNATOR | Box designator. | VARCHAR(16) | Null | No |
BOX_ID | Box identifier. | VARCHAR(16) | Null | No |
STN_INFO | Station information. | VARCHAR(16) | Null | No |
STN_ID | Station identifier. | VARCHAR(16) | Null | No |
REGION | Further qualification of area, in addition to City. | VARCHAR(32) | Null | No |
DEL_DESIGNATOR | Delivery designator. | VARCHAR(16) | Null | No |
DEL_ID | Delivery identifier. | VARCHAR(16) | Null | No |
DEL_INFO | Additional delivery information. | VARCHAR(50) | Null | No |
P_STREET_NAME | The phonetic representation of the name of the street. | VARCHAR(30) | Null | No |
STREET_PREFIX | VARCHAR(16) | Null | No |