Table Detail Report

CE_GROUPING_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Event Grouping Queue
Definition: Queue of person_ids with clinical event rows that need to processed for groupings.
Table Type: ACTIVITY





Column Detail - CE_GROUPING_QUEUE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE Y Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE Y The person who caused the active_status_cd to be set or change.
CE_GROUPING_QUEUE_ID DOUBLE N Unique generated number that identifies a single row on the CE_GROUPING_QUEUE table.
CREATE_DT_TM DATETIME Y This is the original date and time the row was created.
ERROR_MESSAGE_TXT VARCHAR(1500) Y The last error message received when this row was processed.
PERSON_ID DOUBLE Y The ID of the patient who needs their events checked for grouping.
PROCESS_DT_TM DATETIME Y The date and time when this row was last processed.
QUEUE_STATUS_TFLG VARCHAR(20) Y Status of item in the queue. Values: skip, failure, success, pending
REMAINING_RETRY_CNT DOUBLE Y The number of times this row can be processed by grouping procedures.
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.



Relationship Detail - CE_GROUPING_QUEUE


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


CE_IMPLANT_RESULT



Column Section Top of Page


Table-level Detail

Description: CE IMPLANT RESULT
Definition: Track the devices implanted or extracted from a person.
Table Type: ACTIVITY





Column Detail - CE_IMPLANT_RESULT


Column Name Type Null? Definition
BATCH_NBR VARCHAR(15) Y Batch number of the implant/explant.
CULTURE_IND DOUBLE Y Is the implant cultured?
ECRI_CODE VARCHAR(20) Y Electronic tracking code for the implant/explant.
EVENT_ID DOUBLE N Foreign key to the clinical_event table.
EXPIRATION_DT_TM DATETIME Y Time at which the implant expires.
EXPLANT_DISPOSITION_CD DOUBLE N Indicates where the explant was sent.
EXPLANT_REASON_CD DOUBLE N Reason for explant.
HARVEST_SITE VARCHAR(50) Y Site of the explant.
ITEM_ID DOUBLE N Foreign key to the item_definition table.
ITEM_SIZE VARCHAR(25) Y The size of the implant/explant.
LOT_NBR VARCHAR(15) Y Lot number of the implant/explant.
MANUFACTURER_CD DOUBLE N Manufacturer code for the implant/explant.
MANUFACTURER_FT VARCHAR(50) Y Free-text manufacturer name.
MODEL_NBR VARCHAR(15) Y Model number of the implant/explant.
OTHER_IDENTIFIER VARCHAR(30) Y An additional identifier for the implant/explant. Site defined.
REFERENCE_ENTITY_ID DOUBLE N *** OBSOLETE *** An foreign key to another table specified in reference_name.
REFERENCE_ENTITY_NAME VARCHAR(32) Y *** OBSOLETE *** Context field for the reference_entity_id.
TISSUE_GRAFT_TYPE_CD DOUBLE N Indicates the graft type.
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 Time at which the event became valid.
VALID_UNTIL_DT_TM DATETIME N Time at which the event ceased to be valid.


CE_INTAKE_OUTPUT_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Event Intake / Output Result
Definition: This table can be used to quickly determine the Intake / Output balance information for a given period.
Table Type: ACTIVITY





Column Detail - CE_INTAKE_OUTPUT_RESULT


Column Name Type Null? Definition
CE_IO_RESULT_ID DOUBLE N SEQUENCE_NAME:OCF_SEQ Unique identifier generated for each row of this table.
ENCNTR_ID DOUBLE N The ID of the Encounter. FK from ENCOUNTER table
EVENT_ID DOUBLE N Identifies a logical intake output result. There may be more than one row with the same event_id and io_dt_tm values, but only one of those rows will be current as indicated by the valid_until_dt_tm field. Foreign Key: XFK2 - (Clinical event) SEQUENCE NAME:CLINICAL_EVENT_SEQ
IO_END_DT_TM DATETIME Y The clinical end date and time of the I&O activity.
IO_RESULT_ID DOUBLE N This column will receive a fresh value from the OCF_SEQ sequence. It uniquely identifies a logical intake output result row. There may be more than one row with the same IO_RESULT_ID, but only one of those rows will be current as indicated by the valid_until_dt_tm field.
IO_START_DT_TM DATETIME N The clinical start date and time of the I&O activity.
IO_STATUS_CD DOUBLE N CODE SET:4000160 Indicates whether a clinician has accepted the measurement or not. Current valid values are accepted and rejected.
IO_TYPE_FLAG DOUBLE N States whether the data is patient intake or output. 0=Not Defined, 1=Intake, 2=Output
IO_VOLUME DOUBLE Y The volume of intake or output. The volume unit must be 'ml' from code_set 54.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number. Identifies person who is associated with the intake output result. SEQUENCE NAME:PERSON_ONLY_SEQ
REFERENCE_EVENT_CD DOUBLE N The event_cd of the REFERENCE_EVENT_ID result.
REFERENCE_EVENT_ID DOUBLE N The result that contributed to the Intgake or Output result.
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 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. Current version of the result has an open "Until Dt Tm" value.



Relationship Detail - CE_INTAKE_OUTPUT_RESULT


Child Column in CE_INTAKE_OUTPUT_RESULT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID


CE_INTERP_COMP



Column Section Top of Page


Table-level Detail

Description: ce interp comp
Definition: ce interp comp
Table Type: ACTIVITY





Column Detail - CE_INTERP_COMP


Column Name Type Null? Definition
COMP_EVENT_ID DOUBLE N The combination of the Comp Event ID and the Comp Event Version Nbr is the primary key of the result record that is used as an operand for the interp result.
COMP_IDX DOUBLE N A sequence nbr used to make the primary key unique.
COMP_NAME VARCHAR(200) Y Name of the component used in the calculation_equation. For example for an equation like MAP = SAP + (DAP x 2)/3 , comp_name would be SAP or DAP.
EVENT_ID DOUBLE N Foreign key to the Event Table.
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 this row is valid.
VALID_UNTIL_DT_TM DATETIME N Contains the "End Point" of when a row in the table is valid. Current version of the result has an open "Until Dt Tm" value. We need to determine what that value is.


CE_INVENTORY_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: CE INVENTORY RESULT
Definition: Track information about any device or machine that was hooked up to a patient.
Table Type: ACTIVITY





Column Detail - CE_INVENTORY_RESULT


Column Name Type Null? Definition
BODY_SITE VARCHAR(50) Y Site of the that the item was used on.
DESCRIPTION VARCHAR(255) Y Description of the item.
EVENT_ID DOUBLE N Foreign key to the clinical_event table.
ITEM_ID DOUBLE N Foreign key to the item_definition table. This is the item's key back to the item_definition table in the materials management data model. If an item is free text then this will NOT be filled out.
ITEM_NBR VARCHAR(255) Y Item number for the item. It is user defined.
QUANTITY DOUBLE Y Quantity of the item.
REFERENCE_ENTITY_ID DOUBLE N *** OBSOLETE *** Id into a table defined by the user.
REFERENCE_ENTITY_NAME VARCHAR(32) Y *** OBSOLETE *** Name of the table for which the reference_entity_id references.
SERIAL_MNEMONIC VARCHAR(30) Y The serial mnemonic of the item.
SERIAL_NBR VARCHAR(30) Y The serial number of the item.
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 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_INVENTORY_RESULT


Child Column in CE_INVENTORY_RESULT(FK) Parent Table Name Parent Column Name
Parents: ITEM_ID ITEM_DEFINITION ITEM_ID