The demographics table manages demographic concepts such as birthdate and gender for patients and caregivers.
| Name |
Type
|
Description |
| id |
VARCHAR |
Surrogate key. Primary key for the demographics table.
|
| dob |
VARCHAR |
The date of birth of the patient or caregiver.
|
| deceaseddate |
VARCHAR |
If a patient is deceased, the deceased date of the patient.
|
| deceased |
VARCHAR |
A boolean flag indicating whether the patient is deceased.
|
| racetext |
VARCHAR |
A supplemental text field to store uncoded information for the concept.
|
| maritalstatustext |
VARCHAR |
A supplemental text field to store uncoded information for the concept.
|
| religiontext |
VARCHAR |
A supplemental text field to store uncoded information for the concept.
|
| preferredlanguagetext |
VARCHAR |
A supplemental text field to store uncoded information for the concept.
|
| ethnicitytext |
VARCHAR |
A supplemental text field to store uncoded information for the concept.
|
| multiplebirth |
VARCHAR |
T/F. T if the individual is a member of a multiple birth group.
|
| multiplebirthorder |
SMALLINT |
If available, the birth order of an individual that is a member of a multiple birth group.
|
| genderterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id. A term that describes the gender of the patient or caregiver.
|
| raceterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id. A term that describes the race of the patient or caregiver.
|
| racealternateterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id. A secondary term to describe the race of the patient or caregiver.
|
| maritalstatusterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id. A term that expresses the maritial status of the patient or caregiver.
|
| maritalstatusalternateterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id. A secondary term to describe the marital status of the patient or caregiver.
|
| religionterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id. A term that describes the religion of the patient or caregiver.
|
| religionalternateterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id. A secondary term to describe the religion of the patient or caregiver.
|
| preferredlanguageterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id. A term that describes the preferred language of the patient or caregiver.
|
| preferredlanguagealternateterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id. A secondary term to describe the preferred langauge of the patient or caregiver.
|
| ethnicityterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id. A term that describes the ethnicity of the patient or caregiver.
|
| ethnicityalternateterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id. A secondary term to describe the ethnicity of the patient or caregiver.
|
| inserteddate |
TIMESTAMP |
Timestamp (UTC) indicating the date the row was first inserted into HIEBus.
|
| insertedbyapplication_id |
SMALLINT |
The application that first inserted the row into HIEBus. Foreign key reference to applications.id.
|
| insertedbyuser_id |
VARCHAR |
The user associated with the process that first inserted the row into HIEBus. Foreign key reference to users.id.
|
| modifieddate |
TIMESTAMP |
Timestamp (UTC) indicating the date the row was last modified.
|
| modifiedbyapplication_id |
SMALLINT |
The application that last modified the row. Foreign key reference to applications.id.
|
| modifiedbyuser_id |
VARCHAR |
The user associated with the process that last modified the row. Foreign key reference to users.id.
|
| birthsexterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| tenant_id |
SMALLINT |
Surrogate key. Foreign key reference to tenants.id
|
