MONITOR_COMPONENT



Column Section Top of Page


Table-level Detail

Description: Monitor Component
Definition: This table describes the relationship between a monitor and the locations associated with the monitor
Table Type: REFERENCE





Column Detail - MONITOR_COMPONENT


Column Name Type Null? Definition
COMPONENT_REFERENCE_ID DOUBLE N Describes a location that will be associated with this monitor. Can be a location or service resource
COMPONENT_SEQUENCE DOUBLE Y Describes the order in which the locations will appear on a monitor
COMPONENT_TYPE_FLAG DOUBLE Y Indicates either list view (1) or icon view (0) for a component.
MONITOR_COMPONENT_ID DOUBLE N Meaningless number that uniquely defines a row on the table.
MONITOR_VIEW_ID DOUBLE N Foreign key to the monitor_view_table. This number identifies the monitor that this component is associated to.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.


MONITOR_FIELD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Monitor field
Definition: This table contains all of the possible column fields for a monitor
Table Type: REFERENCE





Column Detail - MONITOR_FIELD


Column Name Type Null? Definition
DESCRIPTION VARCHAR(100) Y Description of the field
DESCRIPTION_KEY_CAP VARCHAR(100) Y Description with all spaces removed. Used for indexing.
DISPLAY VARCHAR(100) Y Display value of the field
MEANING VARCHAR(15) N The Cerner defined meaning of the field.
MONITOR_FIELD_ID DOUBLE N Meaningless unique identifier of a row on the table. Used as the primary key.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - MONITOR_FIELD




Parent Column in MONITOR_FIELD (PK) Child Table Name Child Column Name
Children: MONITOR_FIELD_ID MONITOR_VIEW_FIELD MONITOR_FIELD_ID


MONITOR_VIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: Monitor view
Definition: This table contains reference data for a specific monitor(s).
Table Type: REFERENCE





Column Detail - MONITOR_VIEW


Column Name Type Null? Definition
DESCRIPTION VARCHAR(200) Y The description of the monitor.
DISCIPLINE_TYPE_CD DOUBLE N Used to store the internal code for the discipline type. Used for filtering.
DISPLAY VARCHAR(50) Y Display value for the monitor.
DISPLAY_HEADER_IND DOUBLE Y The display_header_ind indicates if the display should be shown with the monitor
DISPLAY_KEY_CAP VARCHAR(50) Y This is the display name with all spaces removed and in all caps. Used as index
MONITOR_VIEW_ID DOUBLE N The monitor view id uniquely idenitifies a row on the monitor view table
REFRESH_TIME_SEC DOUBLE Y The refresh time sec indicates how many seconds between each auto refresh
SCROLL_TIME_SEC DOUBLE Y The scroll time sec indicates how many seconds between each auto refresh
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - MONITOR_VIEW




Parent Column in MONITOR_VIEW (PK) Child Table Name Child Column Name
Children: MONITOR_VIEW_ID MONITOR_VIEW_FIELD MONITOR_VIEW_ID


MONITOR_VIEW_FIELD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Monitor View Field
Definition: This table defines the relationship between a monitor view and its column fields
Table Type: REFERENCE





Column Detail - MONITOR_VIEW_FIELD


Column Name Type Null? Definition
CRITICAL_DISPLAY_COLOR DOUBLE Y RGB value of the color displayed at critical time.
CRITICAL_TIME_MIN DOUBLE Y %remaing%
DISPLAY_LENGTH DOUBLE Y Character length of the display field.
FIELD_SEQUENCE DOUBLE Y Sequence number determining the order in when column fields should be displayed on a monitor.
MONITOR_FIELD_ID DOUBLE N Foreign key to the monitor_field table. Defines a field to associate with a monitor.
MONITOR_VIEW_FIELD_ID DOUBLE N Meaningless number that uniquely defines a row on this table.
MONITOR_VIEW_ID DOUBLE N Foreign key to monitor_view table. Defines which monitor this field is related to.
NORMAL_DISPLAY_COLOR DOUBLE Y RGB value of the color normally displayed.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
WARNING_DISPLAY_COLOR DOUBLE Y %warningl%
WARNING_TIME_MIN DOUBLE Y %remaing%



Relationship Detail - MONITOR_VIEW_FIELD


Child Column in MONITOR_VIEW_FIELD(FK) Parent Table Name Parent Column Name
Parents: MONITOR_FIELD_ID MONITOR_FIELD MONITOR_FIELD_ID
MONITOR_VIEW_ID MONITOR_VIEW MONITOR_VIEW_ID


RAD_ENCNTR_TYPE_LOGOUT



Column Section Top of Page


Table-level Detail

Description: Rad Encounter Type Logout
Definition: This table defines the action to be taken for an encounter type when an exam is completed.
Table Type: REFERENCE





Column Detail - RAD_ENCNTR_TYPE_LOGOUT


Column Name Type Null? Definition
CALL_TRANS_WAIT_ROOM_CD DOUBLE N Transport location that a patient will be moved to when a transport is called after exam completion.
ENCNTR_TYPE_CD DOUBLE N Encounter type for this relationship
LOG_OUT_ACTION DOUBLE Y Action to be taken for this encounter type when an exam is completed.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.