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 |