Address formats differ from country to country. The address holds the full address for a location; however to facilitate searching of addresses by some part of the address (e.g. zip code), rows can be stored on this table holding the values for various named parts of the address.

Example

User Ronan Rooney records the following address (in US address format) for participant James Smith:

• 1074 Park Terrace
• Fairfield
• Midway
• Utah 12345

The Curam serve stores this address and creates these rows on this table containing type/value pairs:

• ADD1=1074
• CITY=Midway
• STATE=UT
• ZIP=12345

You write a custom query to retrieve each participant whose address has a city of 'Midway'. Your query uses this table to identify such addresses.

Technical Notes

Not all parts of the address are replicated on this table. You can customize Curam functionality to store additional parts as required. By default, Curam stores rows on this table for:

• US addresses:
• Line 1;
• City;
• State; and
• Zip
• UK addresses:
• Line 1;
• City; and
• Postcode.

This table does not require optimistic locking. All writes to this table will be performed in tandem with the parent address record, which holds the optimistic lock.