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 |