Table Detail Report

DA_GROUP_SECURITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Group Security
Definition: Contains the security assignments for defined security groups in Discern Analytics 2.0.
Table Type: REFERENCE





Column Detail - DA_GROUP_SECURITY


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.
BEGIN_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is considered valid as active current data. This may be valued with the date that the row became active.
DA_GROUP_SECURITY_ID DOUBLE N Generated unique number that identifies a single row on the DA_GROUP_SECURITY table.
ELEMENT_FILTER_TXT_ID DOUBLE N Contains filter values for an element when used for row level security.
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.
PARENT_ENTITY_ID DOUBLE N The item that security is being set for.
PARENT_ENTITY_NAME VARCHAR(30) Y Table name corresponding to the Discern Analytics item security is being set for.
SECURITY_ASSIGNMENT_CD DOUBLE N Code value for the security assignment to be associated with the entity.
SECURITY_GROUP_CD DOUBLE N Code value for the security group to be assigned data access security.
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.



Relationship Detail - DA_GROUP_SECURITY


Child Column in DA_GROUP_SECURITY(FK) Parent Table Name Parent Column Name
Parents: ELEMENT_FILTER_TXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID


DA_GROUP_USER_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Group User Relation
Definition: Contains the relationship between a user group and its members for Discern Analytics 2.0 users.
Table Type: REFERENCE





Column Detail - DA_GROUP_USER_RELTN


Column Name Type Null? Definition
DA_GROUP_USER_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the DA_GROUP_USER_RELTN table.
GROUP_CD DOUBLE N Code value for the security group the user is a member of.
PRSNL_ID DOUBLE N Identifier for the person that is associated with this group.
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 - DA_GROUP_USER_RELTN


Child Column in DA_GROUP_USER_RELTN(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID


DA_LOGICAL_VIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Logical View
Definition: Contains the definitions of logical views fused in Discern Analytics 2.0 metadata.
Table Type: REFERENCE





Column Detail - DA_LOGICAL_VIEW


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.
CORE_IND DOUBLE N Indicates this logical view was created by Cerner.
DA_LOGICAL_VIEW_ID DOUBLE N Unique, generated number that identifies a single row on the DA_LOGICAL_VIEW table.
DEPRECATED_IND DOUBLE N Indicates this logical view has been deprecated. A row that has been deprecated indicates that there is a future intention to inactivate the row.
EXTENDED_IND DOUBLE N Indicates a Cerner created logical view has been modified by a user.
LOGICAL_VIEW_DESC VARCHAR(255) N A description of the logical view.
LOGICAL_VIEW_NAME VARCHAR(100) N The name of the logical view.
LOGICAL_VIEW_NAME_KEY VARCHAR(100) N The name of the logical view, uppercased and white space removed, for use in searching.
LOGICAL_VIEW_NAME_KEY_A_NLS VARCHAR(400) Y The NLS key for searching in all non-English locales.
LOGICAL_VIEW_UUID VARCHAR(100) N The UUID is used to establish a unique identifier across all systems. The UUID for an item will be the same from one environment to another.
OWNER_GROUP_CD DOUBLE N The owner group of the logical view, used to categorize items across a solution group or functional area (ex Operational vs Financial).
PARENT_LOGICAL_VIEW_ID DOUBLE N When a logical view contains a parent_logical_view_id, the view referenced as the parent is considered to be inherited. The logical view will thus contain all of the elements, tables, and joins both of the current logical view as well as the parent logical view. Contents of the parent logical view may not be changed through the child logical view.
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.
VERSION_TXT VARCHAR(50) N Version_txt contains both a major and minor version number. Minor version numbers are auto-updated each time the item is updated, whereas the major version may be updated during the export process. The version_txt is used by the import process to ensure accurate updating across systems.



Relationship Detail - DA_LOGICAL_VIEW


Child Column in DA_LOGICAL_VIEW(FK) Parent Table Name Parent Column Name
Parents: PARENT_LOGICAL_VIEW_ID DA_LOGICAL_VIEW DA_LOGICAL_VIEW_ID




Parent Column in DA_LOGICAL_VIEW (PK) Child Table Name Child Column Name
Children: DA_LOGICAL_VIEW_ID DA_BV_LV_ELEM_RELTN DA_LOGICAL_VIEW_ID
DA_LOGICAL_VIEW PARENT_LOGICAL_VIEW_ID
DA_LV_TABLE_ELEM_RELTN DA_LOGICAL_VIEW_ID


DA_LV_TABLE_ELEM_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Logical View Table Element Relation
Definition: Defines relationships between the logical views, tables and elements for Discern Analytics 2.0 metadata.
Table Type: REFERENCE





Column Detail - DA_LV_TABLE_ELEM_RELTN


Column Name Type Null? Definition
CORE_IND DOUBLE N Indicates this row was created by Cerner.
DA_ELEMENT_ID DOUBLE N Identifies the element that is related to this Table and Logical View.
DA_LOGICAL_VIEW_ID DOUBLE N Identifies the logical view that this Table and Element are related to.
DA_LV_TABLE_ELEM_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the DA_LV_TABLE_ELEM_RELTN table.
DA_TABLE_INFO_ID DOUBLE N Identifies the table that is related to this Logical View and Element.
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 - DA_LV_TABLE_ELEM_RELTN


Child Column in DA_LV_TABLE_ELEM_RELTN(FK) Parent Table Name Parent Column Name
Parents: DA_ELEMENT_ID DA_ELEMENT DA_ELEMENT_ID
DA_LOGICAL_VIEW_ID DA_LOGICAL_VIEW DA_LOGICAL_VIEW_ID
DA_TABLE_INFO_ID DA_TABLE_INFO DA_TABLE_INFO_ID


DA_QUERY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Query
Definition: The query table is used to store information for each query created in Discern Analytics 2.0.
Table Type: REFERENCE





Column Detail - DA_QUERY


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_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CORE_IND DOUBLE N Indicates this query was created by Cerner.
CREATE_DT_TM DATETIME N Date and time the query was created.
CREATE_PRSNL_ID DOUBLE N Person that initially created the query.
DA_DOMAIN_ID DOUBLE N Identifier of the domain, from which the query was built.
DA_QUERY_ID DOUBLE N Unique, generated number that identifies a single row on the DA_QUERY table.
DEPRECATED_IND DOUBLE N Indicates this query has been deprecated. A row that has been deprecated indicates that there is a future intention to inactivate the row.
EXTENDED_IND DOUBLE N Indicates a Cerner created query has been modified by a user.
FILTER_PROMPT_IND DOUBLE N Indicates whether the query contains run-time prompts.
LAST_UPDT_DT_TM DATETIME N The date and time the row was last updated.
LAST_UPDT_USER_ID DOUBLE N The person that last updated this row.
OWNER_GROUP_CD DOUBLE N The owner group of the query, used to categorize items across a solution group or functional area (ex Operational vs Financial).
OWNER_PRSNL_ID DOUBLE N Person_id of the person from the prsnl table that owns the query
PUBLIC_IND DOUBLE N Determines whether the query is available for public use.
QUERY_DESC VARCHAR(2000) N Description of the Query.
QUERY_NAME VARCHAR(255) N Name of the Query.
QUERY_NAME_KEY VARCHAR(255) N Same as the query name, but converted to upper case with spaces removed.
QUERY_NAME_KEY_A_NLS VARCHAR(1020) Y The NLS key for searching in all non-English locales.
QUERY_TEXT_ID DOUBLE N Identifier of the row on the long text reference table that contains the query string.
QUERY_TYPE_CD DOUBLE N Method of categorizing a query.
QUERY_UUID VARCHAR(100) N The UUID is used to establish a unique identifier across all systems. The UUID for an item will be the same from one environment to another.
REPORT_SERVICE_CD DOUBLE N reference to code set 4000601 (ccl report service bindings). a default of 0.0 indicates the cpmscriptbatch service is used for this query object.
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.
VERSION_TXT VARCHAR(50) N Version_txt contains both a major and minor version number. Minor version numbers are auto-updated each time the item is updated, whereas the major version may be updated during the export process. The version_txt is used by the import process to ensure accurate updating across systems.



Relationship Detail - DA_QUERY


Child Column in DA_QUERY(FK) Parent Table Name Parent Column Name
Parents: DA_DOMAIN_ID DA_DOMAIN DA_DOMAIN_ID
QUERY_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
OWNER_PRSNL_ID PRSNL PERSON_ID




Parent Column in DA_QUERY (PK) Child Table Name Child Column Name
Children: DA_QUERY_ID DA_BATCH_QUERY DA_QUERY_ID
DA_DOCUMENT DA_QUERY_ID
DA_FOLDER_QUERY_RELTN DA_QUERY_ID
DA_QUERY_DEFAULT_PROMPTS DA_QUERY_ID
DA_REPORT_QUERY_RELTN DA_QUERY_ID