ADDRESS

From ICISWiki

Back to TABLE CHANGES v5.6

Contents 1 ADDRESS Table Design v5.6 2 UDFLDS Table Entries 2.1 Legend 2.2 Notes

ADDRESS Table Design v5.6

Field Name	Description	Data Type	Field Size
ADDRID	Unique identifier for the address. Primary key	Number	Long Integer
ADDRTAB	"INSTITUT" or "PERSONS" (specify table to link to)	Text	40
ADDRREC	The ID of the location institute (institute, individual, department etc) to which the address applies. May be multiple AddressIDs sharing the same InstitID, representing different types of address	Number	Long Integer
ADDRTYPE	AddressType. Type of address, such as shipping address, port of entry, normal mailing address, Courier address, P.O Box, Street address, Personal address. Lookup in UDFLDS	Number	Long Integer
ADDR1	1st line of address.	Text	125
ADDR2	2nd line of address.	Text	125
CITYID	LOCID of the city location entry in the LOCATION table.	Number	Long Integer
STATEID	LOCID of the state/province location entry in the LOCATION table.	Number	Long Integer
CPOSTAL	POSTAL_CODE. Postal code (e.g., US zip code).	Text	10
CNTRYID	LOCID of the country location entry in the LOCATION table.	Number	Long Integer
APHONE	Phone number.	Text	25
AFAX	Fax number.	Text	25
AEMAIL	Email address.	Text	255
ADDRSTAT	Status field of ADDRID, like NSTAT in NAMES, 1 = preferred or primary address, 9 = deleted or inactive	Number	Long Integer

UDFLDS Table Entries

FLDNO	FTABLE	FTYPE	FCODE	FNAME	FDESC
1700	ADDRESS	ADDRTYPE	MAIL	Mailing address	Preferred address for regular business mail (could be street address or PO box)
1701	ADDRESS	ADDRTYPE	PRIVATE	Private address	Preferred address for regular private mail
1702	ADDRESS	ADDRTYPE	SHIP	Shipping address	Shipping address
1703	ADDRESS	ADDRTYPE	ENTRY	Port of entry	Port of entry for international shipments into country
1704	ADDRESS	ADDRTYPE	COURIER	Courier deliveries	Address for courier delivery
1705	ADDRESS	ADDRTYPE	STREET	Street address	Actual physical address (even if not used for mail, shipping etc)

Legend

(gray cell)	Already existing field/entry
(yellow cell)	New field/entry to be added
(gold cell)	Replace existing entry with this new code/size

Notes

ADDRESS holds alternative addresses for INSTITUT. An address is a formalised description of a location, and so perhaps should logically be connected to location rather than institution. However, by defining INSTITUT to be any kind of location that can be associated with an address, associating address with institution simplifies the association of an address with an institution .