Table Detail Report
UCM_EXPL_MNU_PROMPT_VALUE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Unified Case Manager Explorer Menu Prompt Value |
Definition: | This table holds the values of each prompt item selected by the user to be saved. |
Table Type: | ACTIVITY |
Column Detail - UCM_EXPL_MNU_PROMPT_VALUE
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. |
PROMPT_VALUE_TEXT | VARCHAR(500) | N | The value of the individualselected items of prompt. |
UCMR_EXPL_MNU_PROMPT_ID | DOUBLE | N | Uniquely identifies the related prompt. |
UCM_EXPL_MNU_PROMPT_VALUE_ID | DOUBLE | N | Uniquely identifies the values of a prompt item selected by the user to be saved. |
UCM_EXPL_MNU_SELECTION_ID | DOUBLE | N | Uniquely identifies the related menu selection. |
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 - UCM_EXPL_MNU_PROMPT_VALUE
Child Column in UCM_EXPL_MNU_PROMPT_VALUE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | UCMR_EXPL_MNU_PROMPT_ID | UCMR_EXPL_MNU_PROMPT | UCMR_EXPL_MNU_PROMPT_ID |
UCM_EXPL_MNU_SELECTION_ID | UCM_EXPL_MNU_SELECTION | UCM_EXPL_MNU_SELECTION_ID |
UCM_EXPL_MNU_SELECTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Unified Case Manager - Explorer Menu Selection |
Definition: | This table holds the names given to the set of selections the user wants to save. |
Table Type: | ACTIVITY |
Column Detail - UCM_EXPL_MNU_SELECTION
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. |
LOGICAL_DOMAIN_ID | DOUBLE | N | The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table. |
SELECTION_NAME | VARCHAR(100) | N | The name given by the user for the selection tobe saved. |
UCMR_EXPL_MNU_REPORT_ID | DOUBLE | N | Uniquely identifies the related report. |
UCM_EXPL_MNU_SELECTION_ID | DOUBLE | N | Uniquely identifies a selection the user wants to save. |
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 - UCM_EXPL_MNU_SELECTION
Child Column in UCM_EXPL_MNU_SELECTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
UCMR_EXPL_MNU_REPORT_ID | UCMR_EXPL_MNU_REPORT | UCMR_EXPL_MNU_REPORT_ID |
Parent Column in UCM_EXPL_MNU_SELECTION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | UCM_EXPL_MNU_SELECTION_ID | UCM_EXPL_MNU_PROMPT_VALUE | UCM_EXPL_MNU_SELECTION_ID |
UCM_FAMILY_HISTORY_REVIEW
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Unified Case Management - Family History Review |
Definition: | This table will track when a provider reviews the Consumer entered family history data. |
Table Type: | ACTIVITY |
Column Detail - UCM_FAMILY_HISTORY_REVIEW
Column Name | Type | Null? | Definition |
---|---|---|---|
PERSON_ID | DOUBLE | N | Uniquely identifies the person for which the family history was reviewed. |
REVIEWER_ID | DOUBLE | N | Uniquely identifies the user for the provider who reviewed the family history data. |
REVIEW_DT_TM | DATETIME | N | The date and time the family history data was reviewed. |
REVIEW_TZ | DOUBLE | N | The time zone associated to the review data and time. |
UCM_FAMILY_HISTORY_REVIEW_ID | DOUBLE | N | Uniquely identifies a family history record which has been reviewed by a provider. |
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 - UCM_FAMILY_HISTORY_REVIEW
Child Column in UCM_FAMILY_HISTORY_REVIEW(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PERSON | PERSON_ID |
REVIEWER_ID | PRSNL | PERSON_ID |
UCM_KARYOTYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Unified Case Manager - Karyotype |
Definition: | Contains karyotype activity data |
Table Type: | ACTIVITY |
Column Detail - UCM_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. |
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_STATUS_FLAG | DOUBLE | N | Represents the status of the Karyotype. Whether it was validated, not validated(validation is turned off), or validation was overridden. 0 - Not Validated; 1 - Validated; 2 - Overridden |
KARYOTYPE_TEXT_ID | DOUBLE | N | Uniquely identifies the text information related to this karyotype. |
PREV_UCM_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. |
UCM_KARYOTYPE_ID | DOUBLE | N | Uniquely identifies a karyotype. |
UCM_REPORT_FIELD_ID | DOUBLE | N | Uniquely identifies the report field where the karyotype was captured. |
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. |
VALIDATION_VERSION_TXT | VARCHAR(10) | Y | Indicates the version of the validation logic used when validating and associating concepts to this karyotype. |
Relationship Detail - UCM_KARYOTYPE
Child Column in UCM_KARYOTYPE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | KARYOTYPE_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
UCM_REPORT_FIELD_ID | UCM_REPORT_FIELD | UCM_REPORT_FIELD_ID |
Parent Column in UCM_KARYOTYPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | UCM_KARYOTYPE_ID | UCM_KARYOTYPE_CONCEPT | UCM_KARYOTYPE_ID |
UCM_KARYOTYPE_CONCEPT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Unified Case Manager Karyotype Concept |
Definition: | This table contains the relationships between concept and a karyotype. |
Table Type: | ACTIVITY |
Column Detail - UCM_KARYOTYPE_CONCEPT
Column Name | Type | Null? | Definition |
---|---|---|---|
DESCRIPTOR_CD | DOUBLE | N | Identifies the descriptorcode that corresponds to this row. |
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 from where the concept originated . |
UCM_KARYOTYPE_CONCEPT_ID | DOUBLE | N | Uniquely identifies a relationship between concept and a karyotype. |
UCM_KARYOTYPE_ID | DOUBLE | N | Uniquely identifies the corresponding karyotype. |
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 - UCM_KARYOTYPE_CONCEPT
Child Column in UCM_KARYOTYPE_CONCEPT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID |
UCM_KARYOTYPE_ID | UCM_KARYOTYPE | UCM_KARYOTYPE_ID |