Table Detail Report

CE_CODED_RESULT



Column Section Top of Page


Table-level Detail

Description: ce coded result
Definition: The ce_coded_result table contains diagnosis and other coded data.
Table Type: ACTIVITY





Column Detail - CE_CODED_RESULT


Column Name Type Null? Definition
ACR_CODE_STR VARCHAR(15) Y If this is an ACR code, this field will hold the code value, and the nomenclature_id field will be null. This field will be null if this is not an ACR code.
DESCRIPTOR VARCHAR(255) Y Textual modifier of the coded result.
EVENT_ID DOUBLE N Foreign key to the Event Table.
GROUP_NBR DOUBLE Y Optional grouping of coded results within the parent clinical event.
NOMENCLATURE_ID DOUBLE N Foreign key to the medical nomenclature table. Will only be null for ACR codes.
PATHOLOGY_STR VARCHAR(15) Y pathology component of acr code
PROC_CODE_STR VARCHAR(5) Y proc code component of acr code
RESULT_CD DOUBLE N Allows the use of a code value instead of a nomenclature id. The code set of the code_value is user defined.
RESULT_SET DOUBLE Y A non-nomenclature option. Code set of result_cd if it is not null.
SEQUENCE_NBR DOUBLE N Sequence Nbr is used to make the primary key unique in the case alpha result occupies more than one row.
UNIT_OF_MEASURE_CD DOUBLE Y Unit of measure for coded results which are numeric in nature
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.


CE_CONFIG



Column Section Top of Page


Table-level Detail

Description: CE CONFIG
Definition: CE CONFIG
Table Type: ACTIVITY





Column Detail - CE_CONFIG


Column Name Type Null? Definition
FIELD_NAME VARCHAR(32) N
FIELD_TYPE_FLAG DOUBLE Y
FIELD_VALUE VARCHAR(100) Y
SERVER_ID DOUBLE N
STORAGE_CD DOUBLE N
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.


CE_CONTRIBUTOR_LINK



Column Section Top of Page


Table-level Detail

Description: The calculation link table
Definition: Stores linked contributor link event ids to a calculation
Table Type: ACTIVITY





Column Detail - CE_CONTRIBUTOR_LINK


Column Name Type Null? Definition
CE_VALID_FROM_DT_TM DATETIME N Calculation contributor Valid_from
CONTRIBUTOR_EVENT_ID DOUBLE N Calculation contributor Event_id
EVENT_ID DOUBLE N Identifier to a logical event row in clinical_event table.
TYPE_FLAG DOUBLE N Type of Contributor:0=Not Defined, 1=Calculation, 2=String, 3=Coded, 4=Date
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_DATE_RESULT



Column Section Top of Page


Table-level Detail

Description: ce date result
Definition: ce date result
Table Type: ACTIVITY





Column Detail - CE_DATE_RESULT


Column Name Type Null? Definition
DATE_TYPE_FLAG DOUBLE N Type of date being stored.
EVENT_ID DOUBLE N Foreign key to the clinical event table.
RESULT_DT_TM DATETIME N The actual date result.
RESULT_DT_TM_OS DOUBLE Y *** OBSOLETE *** This field is no longer supported and should not be used.
RESULT_TZ DOUBLE Y Time zone associated with the corresponding DT_TM column.
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.


CE_DRAFT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Clinical Event Draft
Definition: Stores information about a set of clinical event rows that are in a draft state.
Table Type: ACTIVITY





Column Detail - CE_DRAFT


Column Name Type Null? Definition
CE_DRAFT_ID DOUBLE N Unique, generated number that identifies a single row on the CE_DRAFT table.
CREATE_DT_TM DATETIME N Identifies the date & time the record was created.
ENTRY_MODE_CD DOUBLE N The application that created the draft.
LAST_MODIFIED_DT_TM DATETIME N The date and time when any portion of the draft was last modified.
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




Parent Column in CE_DRAFT (PK) Child Table Name Child Column Name
Children: CE_DRAFT_ID CE_DRAFT_RELTN CE_DRAFT_ID
NC_CHARTED_VIEW CE_DRAFT_ID