Table Detail Report

UCMR_EXPL_MNU_PROMPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference - Explorer Menu Prompt
Definition: This table contains all the prompt names used in Helix related reports in the Explorer menu.
Table Type: REFERENCE





Column Detail - UCMR_EXPL_MNU_PROMPT


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.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
PARAM_TYPE_TEXT VARCHAR(10) N The data type of the parameter. For example: String, Integer
PARAM_WRAP_TEXT VARCHAR(10) N Indicates if the parameters to this prompt will be wrapped by some format. For example "VALUE()"
PROMPT_NAME VARCHAR(50) N This will save the report names available in the explorer menu.
UCMR_EXPL_MNU_PROMPT_ID DOUBLE N Uniquely Identifies a prompt used in Helix related reports in the Explorer Menu.
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_EXPL_MNU_PROMPT




Parent Column in UCMR_EXPL_MNU_PROMPT (PK) Child Table Name Child Column Name
Children: UCMR_EXPL_MNU_PROMPT_ID UCM_EXPL_MNU_PROMPT_VALUE UCMR_EXPL_MNU_PROMPT_ID


UCMR_EXPL_MNU_REPORT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference - Explorer Menu Report
Definition: Contains all the helix related reports available in the Ex;plorer Menu.
Table Type: REFERENCE





Column Detail - UCMR_EXPL_MNU_REPORT


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.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
REPORT_NAME VARCHAR(50) N Contains a report name available in the Explorer Menu.
UCMR_EXPL_MNU_REPORT_ID DOUBLE N Uniquely identifies an Explorer Menu Report
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_EXPL_MNU_REPORT




Parent Column in UCMR_EXPL_MNU_REPORT (PK) Child Table Name Child Column Name
Children: UCMR_EXPL_MNU_REPORT_ID UCM_EXPL_MNU_SELECTION UCMR_EXPL_MNU_REPORT_ID


UCMR_KARYOTYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference - Karyotype
Definition: This table maintains a list of standard karyotypes.
Table Type: REFERENCE





Column Detail - UCMR_KARYOTYPE


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.
CBO_NOMENCLATURE_ID DOUBLE N Uniquely identifies the karyotype in CBO on the nomenclature table that is related to this karyotype.
COMMON_KARYOTYPE_NAME VARCHAR(40) Y This column contains the user defined common name to the karyotype. It is an optional name.
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.
KARYOTYPE_TEXT_REF_ID DOUBLE N Uniquely identifies the text related to this karyotype.
PREV_UCMR_KARYOTYPE_ID DOUBLE N Used to track versions of the karyotype 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.
SHORT_KARYOTYPE_NAME VARCHAR(6) Y Contains a short name for the karyotype. Used to indicate that the karyotype is eligible for Frequent.
UCMR_KARYOTYPE_ID DOUBLE N Uniquely identifies standard karyotypes.
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.
VALIDATION_VERSION_TXT VARCHAR(10) Y Indicates the version of the validation logic used when validating and associating concepts to this karyotype template.
VIEW_SEQ DOUBLE N This column is used for Frequent karyotypes to indicate an order in which to display them.



Relationship Detail - UCMR_KARYOTYPE


Child Column in UCMR_KARYOTYPE(FK) Parent Table Name Parent Column Name
Parents: KARYOTYPE_TEXT_REF_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in UCMR_KARYOTYPE (PK) Child Table Name Child Column Name
Children: UCMR_KARYOTYPE_ID UCMR_KARYOTYPE_CONCEPT UCMR_KARYOTYPE_ID
UCMR_KARYOTYPE_WP_TMPLT_R UCMR_KARYOTYPE_ID


UCMR_KARYOTYPE_CONCEPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference Karyotype Concept
Definition: This table contains the relationships between concept and a karyotype template.
Table Type: REFERENCE





Column Detail - UCMR_KARYOTYPE_CONCEPT


Column Name Type Null? Definition
DESCRIPTOR_CD DOUBLE N Identifies the corresponding descriptor.
DETAILED_FORMAT_IND DOUBLE N Indicates if this concept was determined from the karyotype written using the detailed system.
IMPLIED_IND DOUBLE N Indicates that this concept was implied from the karyotype instead of directly specified by the karyotype.
NOMENCLATURE_ID DOUBLE N Identifies the CBO Concept in the nomenclature table.
QUESTIONABLE_IND DOUBLE N Indicates if this concept was designated as questionable by the karyotype.
SECTION_NBR DOUBLE N Section of the karyotype where the concept originated from.
UCMR_KARYOTYPE_CONCEPT_ID DOUBLE N Uniquely identifies a relationship between a concept and a karyotype template.
UCMR_KARYOTYPE_ID DOUBLE N Uniquely identifies the karyotype template corresponding to this row.
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_KARYOTYPE_CONCEPT


Child Column in UCMR_KARYOTYPE_CONCEPT(FK) Parent Table Name Parent Column Name
Parents: NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
UCMR_KARYOTYPE_ID UCMR_KARYOTYPE UCMR_KARYOTYPE_ID


UCMR_KARYOTYPE_WP_TMPLT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Unified Case Manager Reference - Karyotype Word Processing Template Relationship
Definition: This table maintains an association between a standard karyotype and 1 or more word processing templates for a given facility. If the facility code is not specified it will be assumed that this word processing template can be used throughout all facilities.
Table Type: REFERENCE





Column Detail - UCMR_KARYOTYPE_WP_TMPLT_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.
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_KARYOTYP_WP_TMPLT_ID DOUBLE N Used to track versions of the karyotype and word processing template relationships. 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_KARYOTYPE_ID DOUBLE N Uniquely identifies the Karyotype involved in this relationship.
UCMR_KARYOTYP_WP_TMPLT_ID DOUBLE N Uniquely identifies a relationship between a karyotype and a word processing template.
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.
WP_TEMPLATE_ID DOUBLE N Uniquely identifies the word processing template involved in this relationship.



Relationship Detail - UCMR_KARYOTYPE_WP_TMPLT_R


Child Column in UCMR_KARYOTYPE_WP_TMPLT_R(FK) Parent Table Name Parent Column Name
Parents: UCMR_KARYOTYPE_ID UCMR_KARYOTYPE UCMR_KARYOTYPE_ID
WP_TEMPLATE_ID WP_TEMPLATE TEMPLATE_ID