FRM_IMP_SAFETY

Description: |
This table stores implant safety-related information for screening forms, including the implants' IDs, MRI safety status, safety comments, last editing user, and last editing time.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
SCREENING_FORM_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | SCREENING_FORM_ID | NUMERIC | No |
The unique identifier for the screening form record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | IMPLANT_ID | VARCHAR | No |
The unique ID of the patient's implant.
4 | IMPLANT_SAFETY_STATUS_C_NAME | VARCHAR | No |
The implant safety status category ID for the timeout record associated with the patient.
May contain organization-specific values: Yes
Category Entries:
MRI Safe
MRI Unsafe
MRI Conditional
5 | IMPLANT_SAFETY_CMT_NOTE_ID | VARCHAR | No |
The unique ID of the implant safety status comments (HNO).
6 | IMPLANT_SAFETY_AUD_USER_ID | VARCHAR | No |
Tracks the user who last edited the implant safety status.
7 | IMPLANT_SAFETY_AUD_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
8 | IMPLANT_SAFETY_AUD_DTTM | DATETIME (UTC) | No |
Tracks the last time a user updated the implant safety status.