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 |