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