|
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. |
|
|
