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 |