Table Detail Report

DA_TABLE_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Table Information
Definition: Contains the list of tables and aliases that may be used in Discern Analytics 2.0.
Table Type: REFERENCE





Column Detail - DA_TABLE_INFO


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 data has been created by Cerner
DA_TABLE_INFO_ID DOUBLE N Unique, generated number that identifies a single row on the DA_TABLE_INFO table.
DB_LINK_NAME VARCHAR(16) Y Optional link to a remote database.
DEPRECATED_IND DOUBLE N Indicates this table has been deprecated. A row that has been deprecated indicates that there is a future intention to inactivate the row.
TABLE_ALIAS_NAME VARCHAR(30) N The alias used to represent the physical RDBMS table in join syntax.
TABLE_NAME VARCHAR(100) N The name of the physical RDBMS table.
TABLE_QUERY_TEXT_ID DOUBLE N Identifies the LONG_TEXT_REFERENCE row which contains the query text for this table reference.
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_TABLE_INFO


Child Column in DA_TABLE_INFO(FK) Parent Table Name Parent Column Name
Parents: TABLE_QUERY_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in DA_TABLE_INFO (PK) Child Table Name Child Column Name
Children: DA_TABLE_INFO_ID DA_LV_TABLE_ELEM_RELTN DA_TABLE_INFO_ID
DA_TABLE_RELTN JOIN_TABLE_ID
DA_TABLE_RELTN TABLE_ID


DA_TABLE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discrn Analytics Table Relation
Definition: Contain the tables joins used by both the Domain and the Logical View in Discern Analytics 2.0. A table may be relatd to itself or another table within the Domain or Logical view.
Table Type: REFERENCE





Column Detail - DA_TABLE_RELTN


Column Name Type Null? Definition
BUILD_SEQ DOUBLE N The order the views or domains are built.
CORE_IND DOUBLE N Indicates this row was created by Cerner.
DA_TABLE_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the DA_TABLE_RELTN table.
FROM_CLAUSE_TXT_ID DOUBLE N The long text id that contains the from clause for this relationship.
JOIN_TABLE_ID DOUBLE N The table that will be joined to the table identified in column TABLE_ID.
JOIN_TYPE_FLAG DOUBLE N Identifies whether the join is a regular or shortcut join.
PARENT_ENTITY_ID DOUBLE N Unique identifier from the tables that appear in column parent_entity_name.
PARENT_ENTITY_NAME VARCHAR(32) N Indicates whether the relationship contained on the table is for a domain or a logical view.
REQUIRED_IND DOUBLE N Identifies whether this relationship is required for this logical view. Marking a table relation as required forces the SQL engine to include this join statement to be included in the SQL along with the tables associated with the join, regardless of what columns have been selected in the query.
TABLE_ID DOUBLE N A table that has been defined for use in either a Domain or a 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.
WHERE_CLAUSE_TXT_ID DOUBLE N The long text id that contains the where clause for this relationship.



Relationship Detail - DA_TABLE_RELTN


Child Column in DA_TABLE_RELTN(FK) Parent Table Name Parent Column Name
Parents: JOIN_TABLE_ID DA_TABLE_INFO DA_TABLE_INFO_ID
TABLE_ID DA_TABLE_INFO DA_TABLE_INFO_ID
FROM_CLAUSE_TXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
WHERE_CLAUSE_TXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID


DA_USER_SECURITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics User Security
Definition: Contains the security assignments for Discern Analytics 2.0 users.
Table Type: REFERENCE





Column Detail - DA_USER_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_USER_SECURITY_ID DOUBLE N Unique generated number that identifies a single row on the DA_USER_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 Unique identifier for the Discern Analytics 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.
PRSNL_ID DOUBLE N Identifier for the person that data security is being set for.
SECURITY_ASSIGNMENT_CD DOUBLE N Code value for the security assignment that is to be associated with an entity.
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_USER_SECURITY


Child Column in DA_USER_SECURITY(FK) Parent Table Name Parent Column Name
Parents: ELEMENT_FILTER_TXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
PRSNL_ID PRSNL PERSON_ID