Table Detail Report

UCM_CASE_INTEGRATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Management - Case Integration
Definition: This table stores case integration information.
Table Type: ACTIVITY





Column Detail - UCM_CASE_INTEGRATION


Column Name Type Null? Definition
CKI_IDENTIFIER VARCHAR(50) Y Indicates the SCD pattern this document was based on. It is used in conjunction with the CKI_SOURCE to find the unique SCD pattern on the SCR_PATTERN table.
CKI_SOURCE CHAR(12) Y Indicates the SCD pattern this document was based on. It is used in conjunction with the CKI_IDENTIFIER to find the unique SCD pattern on the SCR_PATTERN table.
CREATE_DT_TM DATETIME N Used to track when this case was created. This field should never be updated as it will be used to trace back to the specific reference data used for this case.
EVENT_ID DOUBLE N Indicates the CLINICAL_EVENT for this document.
STORY_ID DOUBLE N Indicates the SCD story (document) for the case.
STORY_STATUS_CD DOUBLE N Identifies the current status of the story such as pending, in-process, complete, in-review, corrected, and corrected in-review.
UCM_CASE_INTEGRATION_ID DOUBLE N Unique identifier for this case integration document.
UCM_CASE_STEP_ID DOUBLE N Indicates the case step this document is associated with.
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 - UCM_CASE_INTEGRATION


Child Column in UCM_CASE_INTEGRATION(FK) Parent Table Name Parent Column Name
Parents: STORY_ID SCD_STORY SCD_STORY_ID
UCM_CASE_STEP_ID UCM_CASE_STEP UCM_CASE_STEP_ID


UCM_CASE_STEP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Management Case Step
Definition: This table stores high level case information.
Table Type: ACTIVITY





Column Detail - UCM_CASE_STEP


Column Name Type Null? Definition
CREATE_DT_TM DATETIME N This field contains the date and time this row/record was created.
LOCKED_IND DOUBLE Y This field indicates if this case step is locked by another user. Use the UPDT fields to determine who and when the case step was locked.
OPT_ADDON_CATALOG_CD DOUBLE N Orderable for an optional case step that was added on to a case.
ORDER_ID DOUBLE N This field is used to store the order that represents this case step.
PARENT_UCM_CASE_STEP_ID DOUBLE N Indicates the parent case step of a specific case step.
SPECIMEN_ORDER_ID DOUBLE N Used to store the order that represents the specimen order that created this case step.
UCMR_CASE_STEP_ID DOUBLE N This field is used to store the reference case step this case step was built using.
UCM_CASE_ID DOUBLE N This field contains the unique identifier for the case.
UCM_CASE_STEP_ID DOUBLE N This field contains a unique identifier for the case step.
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.
VIEW_SEQ DOUBLE N Identifies the sequence the case step within the case is to be viewed.



Relationship Detail - UCM_CASE_STEP


Child Column in UCM_CASE_STEP(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
SPECIMEN_ORDER_ID ORDERS ORDER_ID
UCMR_CASE_STEP_ID UCMR_CASE_STEP UCMR_CASE_STEP_ID
UCM_CASE_ID UCM_CASE UCM_CASE_ID
PARENT_UCM_CASE_STEP_ID UCM_CASE_STEP UCM_CASE_STEP_ID




Parent Column in UCM_CASE_STEP (PK) Child Table Name Child Column Name
Children: UCM_CASE_STEP_ID UCM_CASE_EVENT RELATED_CASE_STEP_ID
UCM_CASE_EVENT UCM_CASE_STEP_ID
UCM_CASE_INTEGRATION UCM_CASE_STEP_ID
UCM_CASE_STEP PARENT_UCM_CASE_STEP_ID
UCM_REQUIRED_STEP REQUIRED_UCM_CASE_STEP_ID
UCM_REQUIRED_STEP UCM_CASE_STEP_ID


UCM_CHARGE_ORDER_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager - Charge Order Relationship
Definition: Stores the activity data representing a professional charge that has been placed for a helix case.
Table Type: ACTIVITY





Column Detail - UCM_CHARGE_ORDER_R


Column Name Type Null? Definition
ORDER_ID DOUBLE N Uniquely identifies the charge order to an order on the ORDERS table.
RENDERING_PHYS_ID DOUBLE N Uniquely identifies the rendering physician for the charge order.
SERVICE_DATE_CD DOUBLE N Uniquely identifies the service date selection of this charge order.
UCM_CASE_ID DOUBLE N Uniquely identifies the case to which this charge order is associated.
UCM_CHARGE_ORDER_R_ID DOUBLE N Uniquely identifies data representing a professional charge that has been placed for a helix case.
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 - UCM_CHARGE_ORDER_R


Child Column in UCM_CHARGE_ORDER_R(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
RENDERING_PHYS_ID PRSNL PERSON_ID
UCM_CASE_ID UCM_CASE UCM_CASE_ID


UCM_DSR_VARIANT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager - Document Sequencing Results Variant
Definition: Stores variant results for an order.
Table Type: ACTIVITY





Column Detail - UCM_DSR_VARIANT


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
ORDER_ID DOUBLE N The order (i.e., panel) used to obtain this variant result.
PREV_UCM_DSR_VARIANT_ID DOUBLE N Used to track versions of the variant information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
REPORTABLE_IND DOUBLE N Indicates whether or not the variant is capable of being pulled into Document Case Report.
UCM_DSR_VARIANT_ID DOUBLE N Uniquely stores variant results for an order.
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.
VARIANT_NAME VARCHAR(250) Y The name of the variant.
VARIANT_SEQ DOUBLE N The sequence of rows in the order the variants were created or imported.



Relationship Detail - UCM_DSR_VARIANT


Child Column in UCM_DSR_VARIANT(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID




Parent Column in UCM_DSR_VARIANT (PK) Child Table Name Child Column Name
Children: UCM_DSR_VARIANT_ID UCM_DSR_VARIANT_INFO UCM_DSR_VARIANT_ID


UCM_DSR_VARIANT_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager - Document Sequencing Results Variant Information
Definition: Stores property values for a variant.
Table Type: ACTIVITY





Column Detail - UCM_DSR_VARIANT_INFO


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
COLUMN_CD DOUBLE N The column associated with the orderable for this specific variant info property instance
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
INFO_CD DOUBLE N The code set for this field may vary depending on the column_cd. For example, the Gene column will have a different code set for infor_cd than the Variant Classification Column.
INFO_NBR DOUBLE N Contains the result for numeric variant properties.
INFO_TXT VARCHAR(250) Y Contains the human readable result for this variant property.
PREV_UCM_DSR_VARIANT_INFO_ID DOUBLE N Used to track versions of the dsr variant information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
UCM_DSR_VARIANT_ID DOUBLE N Uniquely identifies the related DSR Variant.
UCM_DSR_VARIANT_INFO_ID DOUBLE N Uniquely identifies a property value for a variant.
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 - UCM_DSR_VARIANT_INFO


Child Column in UCM_DSR_VARIANT_INFO(FK) Parent Table Name Parent Column Name
Parents: UCM_DSR_VARIANT_ID UCM_DSR_VARIANT UCM_DSR_VARIANT_ID