employer_data


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 employer_data.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 records of employers associated with patients in the system

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
name VARCHAR 255 √ NULL
street VARCHAR 255 √ NULL
street_line_2 TINYTEXT 255 √ NULL
postal_code VARCHAR 255 √ NULL
city VARCHAR 255 √ NULL
state VARCHAR 255 √ NULL
country VARCHAR 255 √ NULL
date DATETIME 19 √ NULL
pid BIGINT 19 0
patient_data.pid Defined in XML R

The internal patient identifier
start_date DATETIME 19 √ NULL

Employment start date for patient
end_date DATETIME 19 √ NULL

Employment end date for patient
occupation LONGTEXT 2147483647 √ NULL
list_options.option_id Defined in XML R

Employment Occupation fk to list_options.option_id where list_id=OccupationODH
industry TEXT 65535 √ NULL
list_options.option_id Defined in XML R

Employment Industry fk to list_options.option_id where list_id=IndustryODH
created_by INT 10 √ NULL
users.id Defined in XML R

The id of the user that initially created this record
uuid BINARY 16 √ NULL

UUID for this employer record, for data exchange purposes

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
pid Performance Asc pid
uuid_unique Must be unique Asc uuid

Relationships

Close relationships within degrees of separation