CE_AUDIT_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Event Audit Log
Definition: Stores audit information for failed personnel action requests that are executed asynchronously through the clinical event server.
Table Type: ACTIVITY





Column Detail - CE_AUDIT_LOG


Column Name Type Null? Definition
CE_AUDIT_LOG_ID DOUBLE N Unique, generated number that identifies a single row on the CE_AUDIT_LOG table.
ERROR_MSG_TXT VARCHAR(255) Y The error associated with a transaction failure.
EVENT_ID DOUBLE N Used to identify a clinical event row for the given audit log row.
OPERATION_DT_TM DATETIME N Date the action on the clinical event row failed.
OPERATION_PRSNL_ID DOUBLE N The personnel id of the person executing a failing action on the clinical event row.
OPERATION_STATUS_CD DOUBLE N The status of the row as the clinical event is being updated,. Valid values are Processing and Completed.
OPERATION_TYPE_CD DOUBLE N Identifies the operation that failed on the clinical event row.
PERSON_ID DOUBLE N The person that is associated with the clinical event row that was being updated.
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_AUDIT_LOG


Child Column in CE_AUDIT_LOG(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID
OPERATION_PRSNL_ID PRSNL PERSON_ID


CE_BLOB



Column Section Top of Page


Table-level Detail

Description: ce blob
Definition: The ce_blob table contains the actual contents of a locally stored document.
Table Type: ACTIVITY





Column Detail - CE_BLOB


Column Name Type Null? Definition
BLOB_CONTENTS LONGBLOB Y Text of the blob.
BLOB_LENGTH DOUBLE N Number of bytes in the blob.
BLOB_SEQ_NUM DOUBLE N Sequence Nbr is used to make the primary key unique in the case where the document has more than one blob.
COMPRESSION_CD DOUBLE N Specifies type of compression applied to the blob.
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_BLOB_RESULT



Column Section Top of Page


Table-level Detail

Description: ce blob result
Definition: The ce_blob_result table contains information about documents. Each ce_blob_result record corresponds to a single physical document. Blob results having a common {event_id, contributor_system_cd, series_ref_nbr} constitute a logical document
Table Type: ACTIVITY





Column Detail - CE_BLOB_RESULT


Column Name Type Null? Definition
BLOB_ATTRIBUTES VARCHAR(255) Y Attributes of remote blob: display rotation angle; display enhancement options (anti-aliasing, color enhancement, etc.)
BLOB_HANDLE VARCHAR(2000) Y Handle to remote blob
CHECKSUM DOUBLE N A unique value, created by parsing the contents of the blob, used as a comparison to identify changes to the blob.
DEVICE_CD DOUBLE Y Describes device which captured image
EVENT_ID DOUBLE N This value comes from an EVENT_ID in the CINICAL_EVENT Table. It may not equate to a primary key in CLIICAL_EVENT
FORMAT_CD DOUBLE N Identifies the type of blob
MAX_SEQUENCE_NBR DOUBLE N Number of blobs and/or remote blobs associated with the blob result.
STORAGE_CD DOUBLE N Identifies location/device where blob is stored. For example, Blob Table, Dictation System, Image Server, HSM, etc.
SUB_SERIES_REF_NBR VARCHAR(60) Y Used to qualify sub-groups of blobs within a Series.
SUCCESSION_TYPE_CD DOUBLE N Indicates how blobs replace/succeed other blobs.
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. We need to determine what that value is.
VERSION_NBR DOUBLE Y Allows an external system to specify the version which it is attempting to update. If zero, no version checking is done. If non-zero, ensure must match version_nbr on update. version_nbr+1 is written to db.


CE_BLOB_SUMMARY



Column Section Top of Page


Table-level Detail

Description: CE_BLOB_SUMMARY
Definition: Blob thumbnail information.
Table Type: ACTIVITY





Column Detail - CE_BLOB_SUMMARY


Column Name Type Null? Definition
BLOB_LENGTH DOUBLE N The size of the blob.
BLOB_SUMMARY_ID DOUBLE N Logical row identifier.
CE_BLOB_SUMMARY_ID DOUBLE N Unique row identifier.
CHECKSUM DOUBLE N The checksum of the blob.
COMPRESSION_CD DOUBLE N Compression used to store the blob.
EVENT_ID DOUBLE N Foreign key to the Clinical Event table.
FORMAT_CD DOUBLE N Identifies the format of the blob.
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 Signifies the time that this event began.
VALID_UNTIL_DT_TM DATETIME N Time at which this event ceased to be valid.


CE_CALCULATION_RESULT



Column Section Top of Page


Table-level Detail

Description: The Calculation equation Table to store calculated results.
Definition: This table will store a new type of result for calculation equations.
Table Type: ACTIVITY





Column Detail - CE_CALCULATION_RESULT


Column Name Type Null? Definition
CALCULATION_RESULT VARCHAR(255) N Calculation result of evaluation of the equation.
CALCULATION_RESULT_FRMT_CD DOUBLE N Code Set 14113Format of the calculation result : alpha/date/range/etc.
EQUATION VARCHAR(2000) N This field stores the equation used to calculate the result. Ex. MAP = SAP + (DAP x 2)/3
EVENT_ID DOUBLE N Identifier to a logical event row in clinical_event table. This is NOT the CE ID
LAST_NORM_DT_TM DATETIME Y For HL7 compatibility
UNIT_OF_MEASURE_CD DOUBLE N CODE SET:54 Unit of measurement for result.
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 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