contact_address


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of contact_address.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Contains information about a specific contact’s address

Columns

Column Type Size Nulls Auto Default Children Parents Comments
contact_id BIGINT 19 null
contact.id Defined in XML R

The id of the contact this record belongs to
address_id BIGINT 19 null
addresses.id Defined in XML R

The id of the address this contact address belongs to
created_by Unknown 0 null
users.id Defined in XML R

The id of the user that initially created this record
id BIGINT 19 √ null
priority INT 10 √ NULL
type VARCHAR 255 √ NULL
list_options.option_id Defined in XML R

fk to list_options.option_id WHERE list_options.list_id=‘address-types’
use VARCHAR 255 √ NULL
list_options.option_id Defined in XML R

fk to list_options.option_id WHERE list_options.list_id=‘address-uses’
notes TINYTEXT 255 √ NULL
status CHAR 1 √ NULL

‘A’ for active, ‘I’ for inactive
is_primary CHAR 1 √ NULL

Is the primary address for the contact ‘1’ for yes, ‘0’ for no
created_date DATETIME 19 current_timestamp()
period_start DATETIME 19 √ NULL

Date the address became active
period_end DATETIME 19 √ NULL

Date the address became deactivated
inactivated_reason VARCHAR 45 √ NULL

Values: Moved, Mail Returned, etc
updated_by Unknown 0 null
users.id Defined in XML R

The id of the user that last updated this record

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
address_id Performance Asc address_id
contact_address_idx Performance Asc/Asc contact_id + address_id
contact_id Performance Asc contact_id

Relationships

Close relationships within degrees of separation