Table Detail Report

CE_DRAFT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Event Draft Relation
Definition: Stores the relationship linking a clinical event to a draft.
Table Type: ACTIVITY





Column Detail - CE_DRAFT_RELTN


Column Name Type Null? Definition
CE_DRAFT_ID DOUBLE N The Draft that is related to this clinical_event.
CE_DRAFT_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the CE_DRAFT_RELTN table.
EVENT_ID DOUBLE N The Event that this draft 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.



Relationship Detail - CE_DRAFT_RELTN


Child Column in CE_DRAFT_RELTN(FK) Parent Table Name Parent Column Name
Parents: CE_DRAFT_ID CE_DRAFT CE_DRAFT_ID


CE_DYNAMIC_LABEL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Event Dynamic Label
Definition: This table is used to store dynamic label information that will either be related to a group of clinical events or can be stored independently from any clinical events. If a dynamic label is related to a clinical event, this will be signified by the population of the label_id on the clinical_event table.
Table Type: ACTIVITY





Column Detail - CE_DYNAMIC_LABEL


Column Name Type Null? Definition
CE_DYNAMIC_LABEL_ID DOUBLE N Unique, generated primary key for CE_DYNAMIC_LABEL.
CREATE_DT_TM DATETIME N The date and time the dynamic label was created.
LABEL_NAME VARCHAR(100) Y The name of the label template that was used to create the dynamic label.
LABEL_PRSNL_ID DOUBLE N The personnel id of the person creating the dynamic_label row.
LABEL_SEQ_NBR DOUBLE N This field identifies the sequence of a label relative to the other labels entered on a patient. The combination of Label_seq and person_id will identify a unique ce_dynamic_label row.
LABEL_STATUS_CD DOUBLE N This field identifies the status of the dynamic_label.
LABEL_TEMPLATE_ID DOUBLE N An identifier used to identify the label template that was used to create the dynamic label.
LONG_TEXT_ID DOUBLE N Id of the textual comments associated with this label.
PERSON_ID DOUBLE N This field identifies the person that the dynamic label was created for.
PREV_DYNAMIC_LABEL_ID DOUBLE N This field contains the unique ID of the previous version of the current row.
RESULT_SET_ID DOUBLE N The result_set_id of the group of results that are related to the dynamic label. From table CE_RESULTS_SET_LINK.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VALID_FROM_DT_TM DATETIME Y Creation date of the row.
VALID_UNTIL_DT_TM DATETIME Y Date the row becomes historical.



Relationship Detail - CE_DYNAMIC_LABEL


Child Column in CE_DYNAMIC_LABEL(FK) Parent Table Name Parent Column Name
Parents: PREV_DYNAMIC_LABEL_ID CE_DYNAMIC_LABEL CE_DYNAMIC_LABEL_ID
LABEL_TEMPLATE_ID DYNAMIC_LABEL_TEMPLATE LABEL_TEMPLATE_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PERSON_ID PERSON PERSON_ID
LABEL_PRSNL_ID PRSNL PERSON_ID




Parent Column in CE_DYNAMIC_LABEL (PK) Child Table Name Child Column Name
Children: CE_DYNAMIC_LABEL_ID CE_DYNAMIC_LABEL PREV_DYNAMIC_LABEL_ID
ENCNTR_NEWBORN_CE_RELTN CE_DYNAMIC_LABEL_ID
LH_CNT_IC_ADV_LTD CE_DYNAMIC_LABEL_ID
LH_CNT_IC_ADV_WOUND_DATA CE_DYNAMIC_LABEL_ID
LH_CNT_IC_PATIENT_DEVICE CE_DYNAMIC_LABEL_ID
LH_CNT_IC_RPT_EVENT CE_DYNAMIC_LABEL_ID
LH_CNT_LTD_DATA CE_DYNAMIC_LABEL_ID


CE_EVENT_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: CE_EVENT_ACTION
Definition: Tracks actions(endorsable etc) that a personnel needs to take on a clinical event
Table Type: ACTIVITY





Column Detail - CE_EVENT_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N The date and time of the action
ACTION_PRSNL_GROUP_ID DOUBLE N The ID of the Pool for which the item is displayed.
ACTION_PRSNL_ID DOUBLE N The person_id of the person from the personnel table (prsnl) who carried out the action.
ACTION_TYPE_CD DOUBLE N Type of action. Example: order; transcribe; cancel; verify; correct; sign; cosign; modify.
ASSIGN_PRSNL_ID DOUBLE N The ID of the Personnel who is assigned to the item from within the Pool.
CE_EVENT_ACTION_ID DOUBLE N Unique, generated number that identifies a single row on the CE_EVENT_ACTION table.
CLINSIG_UPDT_DT_TM DATETIME Y Clinically Significant Date Time
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
ENDORSE_STATUS_CD DOUBLE N Status of event action row, i.e. pending, opened, saved. Zero value will be treated as pending.
EVENT_CD DOUBLE N It is the code that identifies the most basic unit of the storage, i.e. RBC, discharge summary, image.
EVENT_CLASS_CD DOUBLE N Coded value which specifies how the event is stored in and retrieved from the event table's sub-tables. For example, Event_Class_CDs identify events as numeric results, textual results, calculations, medications, etc.
EVENT_ID DOUBLE N Identifier to a logical event row in clinical_event table.
EVENT_TAG VARCHAR(255) N Brief text string to describe the event and to be displayed on the flowsheet. Calculated based on event class and status.
EVENT_TITLE_TEXT VARCHAR(255) Y The title for document results.
LAST_COMMENT_TXT VARCHAR(255) Y The action_comment from the most recently written endorse saved CE_EVENT_PRSNL row.
LAST_SAVED_PRSNL_ID DOUBLE N The action_prsnl_id from the most recently written endorse saved CE_EVENT_PRSNL row that contains an action comment.
MULTIPLE_COMMENT_IND DOUBLE N Indicates whether or not multiple action_comments have been recorded on endorse saved CE_EVENT_PRSNL rows.
MULTIPLE_COMMENT_PRSNL_IND DOUBLE N Indicates whether or not multiple providers have saved action_comments on endorse saved CE_EVENT_PRSNL rows.
NORMALCY_CD DOUBLE N States whether the result is normal. This can be used to determine whether to display the event tag in different color on the flowsheet. For group results, this represents an "overall" normalcy. i.e. Is any result in the group abnormal? Also allows different purge criteria to be applied based on result.
ORIGINATING_PROVIDER_ID DOUBLE N The personnel that originally ordered the event.
PARENT_EVENT_CLASS_CD DOUBLE N The event_class_cd of the clinical event represented by parent_event_id.
PARENT_EVENT_ID DOUBLE N Provides a mechanism for logical grouping of events. i.e. supergroup and group tests. Same as event_id if current row is the highest level parent.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
RESULT_STATUS_CD DOUBLE N Result status code. Valid values: authenticated, unauthenticated, unknown, cancelled, pending, in lab, active, modified, superseded, transcribed, not done.
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 - CE_EVENT_ACTION


Child Column in CE_EVENT_ACTION(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
ACTION_PRSNL_ID PRSNL PERSON_ID
ASSIGN_PRSNL_ID PRSNL PERSON_ID
LAST_SAVED_PRSNL_ID PRSNL PERSON_ID
ORIGINATING_PROVIDER_ID PRSNL PERSON_ID
ACTION_PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID




Parent Column in CE_EVENT_ACTION (PK) Child Table Name Child Column Name
Children: CE_EVENT_ACTION_ID CE_PRCS_QUEUE CE_EVENT_ACTION_ID
CE_RTE_PRSNL_RELTN CE_EVENT_ACTION_ID


CE_EVENT_ACTION_MODIFIER



Column Section Top of Page


Table-level Detail

Description: Modifier table to the ce_event_prsnl table. This would contain extensions of act
Definition: Modifier table to the ce_event_prsnl table. This would contain extensions of action_type_cd from ce_event_prsnl table
Table Type: ACTIVITY





Column Detail - CE_EVENT_ACTION_MODIFIER


Column Name Type Null? Definition
ACTION_TYPE_MODIFIER_CD DOUBLE N CODE SET: 254550 Extension or modification of type of action for an event prsnl. For example, an action_type of Convey can have an action_modifier_type of email, phone mail etc.
CE_EVENT_ACTION_MODIFIER_ID DOUBLE N SEQUENCE NAME:OCF_SEQ Primary Key for the table.
EVENT_ACTION_MODIFIER_ID DOUBLE N SEQUENCE NAME:OCF_SEQ Uniquely identifies a logical event action modifier row. There may be more than one row with the same event_action_modifier_id, but only one of those rows will be current as indicated by the valid_until_dt_tm field.
EVENT_ID DOUBLE N Identifier to a logical event row in clinical_event table.
EVENT_PRSNL_ID DOUBLE N Identifier to a logical event prsnl row in ce_event_prsnl table.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
VALID_FROM_DT_TM DATETIME N Creation date for row. Contains the "Beginning Point" of when a row in the table is valid.
VALID_UNTIL_DT_TM DATETIME N Contains the "End Point" of when a row in the table is valid.This indicates when


CE_EVENT_MODIFIER



Column Section Relationship Section Top of Page


Table-level Detail

Description: The ce_event_modifier table stores items which apply to a clinical event. For i
Definition: The ce_event_modifier table stores items which apply to a clinical event. For instance, a modifier for a blood pressure reading may be the orientation of the person during the reading (sitting, standing?).
Table Type: ACTIVITY





Column Detail - CE_EVENT_MODIFIER


Column Name Type Null? Definition
EVENT_ID DOUBLE N Foreign key to clinical_event table.
GROUP_SEQUENCE DOUBLE Y Maps groups of items into separate sets for display and ordering purposes. Starts at 0 and can have only positive values (0-n)
ITEM_SEQUENCE DOUBLE Y Maps the Items within a group to a unique identifier for ordering purposes. Starts at 0 and can have only positive values (0-n)
MODIFIER_CD DOUBLE N Indicates the type of modifier. This code value will imply a code set for the modifier_value_cd field. I have not yet created a code set for this code...
MODIFIER_VALUE_CD DOUBLE N The value of the modification. Code set depends on the value of modifier_cd.
MODIFIER_VALUE_FT DOUBLE Y not used anymore.
MODIFIER_VALUE_PERSON_ID DOUBLE N If the modification value is a person, the person_id will go in this field, and modifier_value_cd will be set to zero.
MODIFIER_VAL_FT VARCHAR(100) Y If the modification value is free text, the value will go in this field, and modifier_value_cd will be set to zero.
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.
VALID_FROM_DT_TM DATETIME N Contains the Beginning Point of when a row in the table is valid.
VALID_UNTIL_DT_TM DATETIME N Contains the End Point of when a row in the table is valid.



Relationship Detail - CE_EVENT_MODIFIER


Child Column in CE_EVENT_MODIFIER(FK) Parent Table Name Parent Column Name
Parents: MODIFIER_VALUE_PERSON_ID PERSON PERSON_ID