PATIENT_6

Description: |
This table supplements the PATIENT table. It contains basic information about patients.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2 | IMAGING_WILL_CALL_YN | VARCHAR | No |
Holds a "Will Call" status for the patient. This is a status toggled by a Radiology user (eg. Technologist) to flag the availability of the patient for further processing.
May contain organization-specific values: No
Category Entries:
No
Yes
3 | PAT_PRONOUN_FOR_USE_IN_TEXT_C_NAME | VARCHAR | No |
The pronoun category ID for the patient which is used by the system for text generation.
May contain organization-specific values: Yes
Category Entries:
she/her/hers
he/him/his
they/them/theirs
e/em/eirs
ey/em/eirs
sie/hir/hirs
xie/hir/hirs
ze/hir/hirs
ze/zir/zirs
ze/zem/zirs
ze/zim/zirs
ve/vir/vis
xe/xem/xyrs
yo/yo/yos
co/co/cos
ne/nem/nirs
fae/faer/faers
ve/vis/ver
en/en/ens
any/all
name as pronoun
choose not to disclose
unknown
not listed
she/her
he/him
they/them
e/em
ey/em
sie/hir
xie/hir
ze/hir
ze/zir
ze/zem
ze/zim
ve/vir
xe/xem
yo/yo
co/co
ne/nem
fae/faer
ve/vis
en/en
4 | PAT_PRONOUN_COMMENT | VARCHAR | No |
The pronoun comment or instructions entered by the user who documented a patient's pronouns.
5 | PAT_PRONOUN_OTHER_FREE_TEXT | VARCHAR | No |
The free-text pronouns entered for a patient whose pronouns were not available to be discretely collected as a category value.
6 | PAT_PRONOUN_UPDATE_UTC_DTTM | DATETIME (UTC) | No |
The date and time when the patient's pronouns were last updated, in UTC.
7 | SEX_FOR_MELD_C_NAME | VARCHAR | No |
The patient's sex for adult Model for End-Stage Liver Disease (MELD) calculation.
May contain organization-specific values: No
Category Entries:
Female
Male
8 | DEDUPLICATED_RCVD_DOCUMENT_ID | NUMERIC | No |
Deduplicated received document for this patient
9 | INTERSEX_STATUS_C_NAME | VARCHAR | No |
The intersex status category ID for the patient. (Intersex is an umbrella term for differences in sex traits or reproductive anatomy that a person is born with or which develop in childhood.)
May contain organization-specific values: No
Category Entries:
Yes
No
Unknown
Choose not to disclose
10 | INSIGHT_AI_INTRCT_ID | NUMERIC | No |
The ID of the record containing AI-generated insights for the patient.
11 | MOBILE_PHONE | VARCHAR | No |
This is a virtual item that returns the patient's mobile phone number from the patient phone numbers table in related group 94. If multiple mobile numbers are on file, then the number with the highest priority is returned.
12 | DSQ_MOTHER_FIRST_NAME | VARCHAR | No |
The first name on file with DSQ of the patient's mother.
13 | DSQ_MOTHER_LAST_NAME | VARCHAR | No |
The last name on file with DSQ of the patient's mother.
14 | DSQ_FATHER_FIRST_NAME | VARCHAR | No |
The first name on file with DSQ of the patient's father.
15 | DSQ_FATHER_LAST_NAME | VARCHAR | No |
The last name on file with DSQ of the patient's father.