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 |