Table Detail Report

CE_STRING_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: ce string result
Definition: The String Result Table is used to store both text result and interp result (?). In the case of simple text result the Equation_CD column will be empty and will not have Interp_Component.
Table Type: ACTIVITY





Column Detail - CE_STRING_RESULT


Column Name Type Null? Definition
CALCULATION_EQUATION VARCHAR(512) Y This field stores the equation used to calculate the result. Ex. MAP = SAP + (DAP x 2)/3
CRITICAL_HIGH VARCHAR(20) Y Critical high/low values.
CRITICAL_LOW VARCHAR(20) Y Critical high/low values.
EQUATION_ID DOUBLE N Foreign key to the equation table where the equation for the interp result is stored, if applicable.
EVENT_ID DOUBLE N Foreign key to the Event Table.
FEASIBLE_IND DOUBLE Y Indicates whether or not the result is within feasible limits.
INACCURATE_IND DOUBLE Y True if the result value is outside of the measuring instruments accurate limits.
LAST_NORM_DT_TM DATETIME Y (For HL7 compatibility)
MODIFY_FLAG DOUBLE Y this field is obsolete
NORMAL_HIGH VARCHAR(20) Y Normal high/low values.
NORMAL_LOW VARCHAR(20) Y Normal high/low values.
STRING_LONG_TEXT_ID DOUBLE N Long Text ID from the LONG_TEXT table. ID of the long_text row containing the string result text.
STRING_RESULT_FORMAT_CD DOUBLE N Format of a string result: alpha/date/range/approximation...
STRING_RESULT_TEXT VARCHAR(255) N Text.
UNIT_OF_MEASURE_CD DOUBLE N 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 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.



Relationship Detail - CE_STRING_RESULT


Child Column in CE_STRING_RESULT(FK) Parent Table Name Parent Column Name
Parents: EQUATION_ID EQUATION EQUATION_ID
STRING_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID


CE_SUSCEPTIBILITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: ce susceptibility
Definition: ce susceptibility
Table Type: ACTIVITY





Column Detail - CE_SUSCEPTIBILITY


Column Name Type Null? Definition
ABNORMAL_FLAG DOUBLE N Flag to identify abnormal results.
ANTIBIOTIC_CD DOUBLE N The type of antibiotic for microbiology susceptibility results.
ANTIBIOTIC_NOTE VARCHAR(255) Y Text note associated with susceptibility
CHARTABLE_FLAG DOUBLE N Flag to identify chartable results.
DETAIL_SUSCEPTIBILITY_CD DOUBLE N The details of the susceptibility testing.
DILUENT_VOLUME DOUBLE N The volume of diluent needed.
EVENT_ID DOUBLE N Foreign key to the clinical event table.
MICRO_SEQ_NBR DOUBLE N Combined with event_id to form foreign key to ce_microbiology
NOMENCLATURE_ID DOUBLE N Resistance if result_cd is not used
PANEL_ANTIBIOTIC_CD DOUBLE N Descirbes the panel of antibiotics for microbiology susceptibility results.
RESULT_CD DOUBLE N The resistance of an organism to a particular antibiotic (susceptibility interpretation).
RESULT_DT_TM DATETIME N The date and time of the results.
RESULT_NUMERIC_VALUE DOUBLE Y The numeric value of the results.
RESULT_PRSNL_ID DOUBLE N The Personnel ID of the person reporting the results.
RESULT_TEXT_VALUE VARCHAR(100) Y The free text description of the results.
RESULT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
RESULT_UNIT_CD DOUBLE N The unit of measure for the susceptibility interpretation.
SUSCEPTIBILITY_STATUS_CD DOUBLE N The status of the susceptibility.
SUSCEPTIBILITY_TEST_CD DOUBLE N The type of susceptibility testing done (MIC, Kirby-Bauer...).
SUSCEP_SEQ_NBR DOUBLE N Sequence number to make the primary key unique, when there is more than one susceptibility test per growth.
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.



Relationship Detail - CE_SUSCEPTIBILITY


Child Column in CE_SUSCEPTIBILITY(FK) Parent Table Name Parent Column Name
Parents: EVENT_ID CE_MICROBIOLOGY EVENT_ID
MICRO_SEQ_NBR CE_MICROBIOLOGY MICRO_SEQ_NBR
VALID_UNTIL_DT_TM CE_MICROBIOLOGY VALID_UNTIL_DT_TM
RESULT_PRSNL_ID PRSNL PERSON_ID


CE_SUSCEP_FOOTNOTE



Column Section Top of Page


Table-level Detail

Description: footnotes bound to one or more ce_susceptibility rows
Definition: The ce_suscep_footnote table stores footnotes bound to one or more ce_susceptibility rows. The actual contents of the footnote exist in the long_blob table. The maximum size of a blob stored in this table is 32K compressed. A note must be able to fit i
Table Type: ACTIVITY





Column Detail - CE_SUSCEP_FOOTNOTE


Column Name Type Null? Definition
BLOB_LENGTH DOUBLE N Size of the uncompressed blob.
CE_SUSCEP_FOOTNOTE_ID DOUBLE N Unique identifier generated for each row of data in the ce_suscep_footnote table.
CHECKSUM DOUBLE N A unique value, created by parsing the contents of the blob, used as a comparison to identify changes to the blob.
COMPRESSION_CD DOUBLE N Specifies type of compression applied to the blob.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
EVENT_ID DOUBLE N Foreign key to the clinical_event table.
FORMAT_CD DOUBLE N Indicates type of blob. Note that a storage code doesn't exist - all blobs must exist on the long_blob table. Thus only format codes that apply to the storage code "BLOB" are valid here.
REFERENCE_NBR VARCHAR(100) N The combination of the reference nbr and the contributor system code provides a unique identifier to the origin of the data.
SUSCEP_FOOTNOTE_ID DOUBLE N Uniquely identifies a logical suscep footnote row. There may be more than one row with the same suscep_footnote_id, but only one of those rows will be current as indicated by the valid_until_dt_tm field.
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.


CE_SUSCEP_FOOTNOTE_R



Column Section Top of Page


Table-level Detail

Description: Relates ce_susceptibility with ce_suscep_footnote
Definition: The ce_suscep_footnote_r table is a relation table which allows a many-to-many relationship between the ce_susceptibility table and the ce_suscep_footnote table.
Table Type: ACTIVITY





Column Detail - CE_SUSCEP_FOOTNOTE_R


Column Name Type Null? Definition
EVENT_ID DOUBLE N Component of foreign key to ce_susceptibility.
MICRO_SEQ_NBR DOUBLE N Component of foreign key to ce_susceptibility.
SUSCEP_FOOTNOTE_ID DOUBLE N Foreign key to ce_suscep_footnote table.
SUSCEP_SEQ_NBR DOUBLE N Component of foreign key to ce_susceptibility.
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.


CE_UNIT



Column Section Top of Page


Table-level Detail

Description: ce unit
Definition: ce unit
Table Type: REFERENCE





Column Detail - CE_UNIT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N 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.
FROM_TO_FORMULA VARCHAR(255) N The formula to convert a FROM unit to a TO unit.
FROM_UNIT_CD DOUBLE N From Unit Cd
FROM_UNIT_CKI VARCHAR(255) Y From Unit CKI
TO_FROM_FORMULA VARCHAR(255) N The formula for TO UNIT to FROM UNIT
TO_UNIT_CD DOUBLE N To Unit Cd
TO_UNIT_CKI VARCHAR(255) Y To Unit CKI
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.