UCMR_DSR_FIELD_COLUMN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference Document Sequencing Result Field Column
Definition: This table contains all the filtered columns for a Sequecing field wrt to an Sequecing Orderable in DCR
Table Type: REFERENCE





Column Detail - UCMR_DSR_FIELD_COLUMN


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 columns associated with the DSR Orderable which is listed as Catalog_cd in this table.
COLUMN_SEQUENCE DOUBLE N The sequence for each column from column_cd.
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.
PREV_UCMR_DSR_FIELD_COLUMN_ID DOUBLE N Used to track versions of the DSR Field column. 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.
UCMR_DSR_FIELD_COLUMN_ID DOUBLE N Uniquely identifies a filtered column for a Sequencing field wrt to an Sequencing Orderable in DCR
UCMR_LAYOUT_FIELD_ID DOUBLE N Uniquely identifies the related UCMR Layout 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.



Relationship Detail - UCMR_DSR_FIELD_COLUMN


Child Column in UCMR_DSR_FIELD_COLUMN(FK) Parent Table Name Parent Column Name
Parents: UCMR_LAYOUT_FIELD_ID UCMR_LAYOUT_FIELD UCMR_LAYOUT_FIELD_ID


UCM_DSR_PANEL_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Document Sequencing Results Panel Info
Definition: Stores panel information about a set of variant results for an order.
Table Type: ACTIVITY





Column Detail - UCM_DSR_PANEL_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.
CORRECTED_IND DOUBLE N Indicates whether or not the variant is capable of being pulled into Document Case Report. When a variant is marked as reportable and corrected the value will be 1.
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.
LAST_RPT_UPDT_DT_TM DATETIME Y The last date and time the set of reportable variants was corrected.
ORDER_ID DOUBLE N The order (i.e., panel) used to obtain this variant result.
PREV_UCM_DSR_PANEL_INFO_ID DOUBLE N Used to track versions of the DSR panel group 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.
SORT_COLUMN_CD DOUBLE Y Determines the column by which sort has to be applied on variants.
SORT_FLAG DOUBLE Y Determines the way in which the sort has to be applied on variants. 0 - no sort 1 - ascending order 2 - descendng order
UCM_DSR_PANEL_INFO_ID DOUBLE N Uniquely identifies panel information about a set of variant results for an order.
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_DSR_PANEL_INFO


Child Column in UCM_DSR_PANEL_INFO(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
PREV_UCM_DSR_PANEL_INFO_ID UCM_DSR_PANEL_INFO UCM_DSR_PANEL_INFO_ID




Parent Column in UCM_DSR_PANEL_INFO (PK) Child Table Name Child Column Name
Children: UCM_DSR_PANEL_INFO_ID UCM_DSR_PANEL_INFO PREV_UCM_DSR_PANEL_INFO_ID