This table links a Person record with a person’s address information.
Indicates the preferred order in which the person’s addresses will be selected. Indexed with PersonID. Defaults to 1. Required.
|AddressTypeCodeSetID||12.0.0||Number(16,0)||Identification number of the associated CodeSet table row. Indexed. Required.|
|EndDate||12.0.0||Date||Last day on which the address is related to the person. Defaults to NULL. Optional.|
Unique sequential number generated by the application. Indexed. Required.
Identification number of the associated Address table row. Indexed. Required.
|PersonID||12.0.0||Number(16,0)||Identification number of the associated Person table row pertaining to the phone number. Indexed with AddressPriorityOrder. Required.|
|StartDate||12.0.0||Date||First day on which the address is related to the person. Defaults to NULL. Optional|
|WhenCreated||12.0.0||Timestamp(6)||The date and time the record was created. Defaults to system date. Required.|
The date and time the record was modified. Defaults to system date. Required.
The name of the person who created the record. Defaults to user. Required.
The name of person who modified the record. Defaults to user. Required.