|
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. |
|
|
| 16 |
RADF_OBJECTION_YN |
VARCHAR |
No |
|
|
|
| This item records whether a patient, or a proxy acting on their behalf, has an upheld objection to sharing their reasonable adjustment record with the NHS Spine. When an objection exists, the record is not shared. The author, organization, date, and any note for the objection are held in the related RADF Objection items (I EPT 82181 through I EPT 82184). |
| The category values for this column were already listed for column: IMAGING_WILL_CALL_YN |
|
|
| 17 |
RADF_OBJECTION_AUTHOR |
VARCHAR |
No |
|
|
|
| This item records the name of the author who recorded the patient's objection to sharing their reasonable adjustment record. The organization that author belongs to is held in the RADF Objection Organization (I EPT 82182) item. |
|
|
| 18 |
RADF_OBJECTION_ORG |
VARCHAR |
No |
|
|
|
| This item records the name of the organization that recorded the patient's objection to sharing their reasonable adjustment record. The author within that organization is held in the RADF Objection Author (I EPT 82181) item. |
|
|
| 19 |
RADF_OBJECTION_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| This item records when the patient's objection to sharing their reasonable adjustment record was recorded, stored as a UTC instant. |
|
|
| 20 |
RADF_SYNC_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| This item records when the patient's Reasonable Adjustment Digital Flag (RADF) was last successfully retrieved from the NHS Patient Flags Service and merged into the local record. The value is stored as a UTC instant. |
|
|