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 |