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