Table Detail Report

UCMR_CHARGE_ORDERABLE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference - Charge Orderable
Definition: Stores reference data of professional charge orderables that can be associated with a Helix case type.
Table Type: REFERENCE





Column Detail - UCMR_CHARGE_ORDERABLE


Column Name Type Null? Definition
ACCESSION_ASSIGNMENT_CD DOUBLE N Indicates whether to assign the accession number of the case or the workup during activity time.
CATALOG_CD DOUBLE N The catalog code for the charge orders' orderable.
DEF_RENDERING_PHYS_ID DOUBLE N The person identifier of the default rendering physician of the charge orderable.
DEF_SERVICE_DATE_CD DOUBLE N Codeset value of when the service date shall be (e.g. Collected Date or Verified Date)
UCMR_CHARGE_ORDERABLE_ID DOUBLE N Uniquely identifies professional charge orderables that can be associated with a Helix case type.
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_CHARGE_ORDERABLE




Parent Column in UCMR_CHARGE_ORDERABLE (PK) Child Table Name Child Column Name
Children: UCMR_CHARGE_ORDERABLE_ID UCMR_CASE_CHARGE_ORDRBL_R UCMR_CHARGE_ORDERABLE_ID


UCMR_DSR_COL_ORDERABLE_R



Column Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference - DSR Column and Orderable Relationship
Definition: This table stores relationships between a sequencing activity type with the list of columns it can have and their sequence.
Table Type: REFERENCE





Column Detail - UCMR_DSR_COL_ORDERABLE_R


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.
CATALOG_CD DOUBLE N This column indicates the DSR orderables.
COLUMN_CD DOUBLE N The columns associated with DSR Orderables 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.
UCMR_DSR_COL_ORDERABLE_R_ID DOUBLE N Uniquely identifies the relationship between a Document Sequencing Result column and the related orderable.
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.


UCMR_DSR_ORD_GENE_R



Column Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference - Orderable Gene Relationship
Definition: Stores relationships between a sequencing activity type and its associated genes.
Table Type: REFERENCE





Column Detail - UCMR_DSR_ORD_GENE_R


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.
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.
CATALOG_CD DOUBLE N Uniquely identifies the related DRS orderable.
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.
GENE_CD DOUBLE N Uniquely identifies the related gene.
UCMR_DSR_ORD_GENE_R_ID DOUBLE N Uniquely identifies a relationship between a DSR Orderable and a gene.
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.


UCMR_DSR_ORD_SOURCE_R



Column Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference - DSR Orderable Source Relationship
Definition: Stores relationships between a sequencing activity type orderable and its import script file.
Table Type: REFERENCE





Column Detail - UCMR_DSR_ORD_SOURCE_R


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.
ALLOW_MISSING_GENE_IND DOUBLE N Indicator to identify whether to allow the inclusion of variants without genes.
CATALOG_CD DOUBLE N Uniquely identifies the DSR Orderable.associated to the related Source file.
SOURCE_CD DOUBLE N Uniquely identifies the Source file associated with this DSR orderable.
UCMR_DSR_ORD_SOURCE_R_ID DOUBLE N Uniquely identifies a relationship between a DSR orderable and an associated source file.
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.


UCMR_EQUIVALENT_STEP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Management Reference - Equivalent Step
Definition: Stores equivalent orderables for a case step.
Table Type: REFERENCE





Column Detail - UCMR_EQUIVALENT_STEP


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.
CATALOG_CD DOUBLE N Stores the orderable procedure that represents the equivalent.
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.
UCMR_CASE_STEP_ID DOUBLE N Stores the case step identifier to which this equivalent applies.
UCMR_EQUIVALENT_STEP_ID DOUBLE N Uniquely identifies an equivalent orderable for a case step.
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_EQUIVALENT_STEP


Child Column in UCMR_EQUIVALENT_STEP(FK) Parent Table Name Parent Column Name
Parents: UCMR_CASE_STEP_ID UCMR_CASE_STEP UCMR_CASE_STEP_ID