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