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.