Table Detail Report

DA_DOCUMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Document
Definition: Contains the generated document created when a Report or Query Run is stored in the Discern Analytics 2.0 system.
Table Type: ACTIVITY





Column Detail - DA_DOCUMENT


Column Name Type Null? Definition
COMPATIBILITY_VERSION_NBR DOUBLE Y Used by Discern Analytics 2.0 to indicate whether a document may be opened by a particular DA2 application revision.;
CREATED_BY_PRSNL_ID DOUBLE N The person that generated this document.
DA_DOCUMENT_ID DOUBLE N Unique, generated number that identifies a single row on the DA_DOCUMENT table.
DA_QUERY_ID DOUBLE N The query which this document was generated from
DA_REPORT_ID DOUBLE N The report format which this document was generated from.
DOCUMENT_NAME VARCHAR(100) Y Optional Name assigned to the document.
DOCUMENT_NAME_KEY VARCHAR(100) Y Uppercase, no spaces document name.
DOCUMENT_NAME_KEY_A_NLS VARCHAR(400) Y Facilitates accent insensitive searches/sorts on the DOCUMENT_NAME_KEY column (National Language Support)
DOC_TYPE_CD DOUBLE N The type of document generated (such as html, pdf, postscript, etc.)
GENERATED_DATA_ID DOUBLE N Contains a link to the document data.
GENERATED_DOC_ID DOUBLE N Document as ran, stored on the long_blob table.
GENERATED_DT_TM DATETIME N Date and time that this document was generated.
REPORT_PARMS_ID DOUBLE N XML String containing the parameters entered for this report run. Stored on the long_blob table.
SECURITY_GROUP_CD DOUBLE N Code value for the security group associated with this document.
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.
VALID_UNTIL_DT_TM DATETIME Y Date and time to which the document remains valid.



Relationship Detail - DA_DOCUMENT


Child Column in DA_DOCUMENT(FK) Parent Table Name Parent Column Name
Parents: DA_QUERY_ID DA_QUERY DA_QUERY_ID
DA_REPORT_ID DA_REPORT DA_REPORT_ID
GENERATED_DATA_ID LONG_BLOB LONG_BLOB_ID
GENERATED_DOC_ID LONG_BLOB LONG_BLOB_ID
REPORT_PARMS_ID LONG_BLOB LONG_BLOB_ID
CREATED_BY_PRSNL_ID PRSNL PERSON_ID




Parent Column in DA_DOCUMENT (PK) Child Table Name Child Column Name
Children: DA_DOCUMENT_ID DA_BATCH_QUERY_LOG CREATED_DOCUMENT_ID
DA_BATCH_REPORT_LOG CREATED_DOCUMENT_ID
DA_DOCUMENT_ORG_RELTN DA_DOCUMENT_ID
DA_DOCUMENT_PRSNL_RELTN DA_DOCUMENT_ID


DA_DOCUMENT_ORG_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Document Organization Relation
Definition: The Document Org Relation table contains the organizations associated with the document when it was generated in Discern Analytics 2.0. (A user must be associated with the same organizations in order to view this document). Only used when organizational security is on.
Table Type: ACTIVITY





Column Detail - DA_DOCUMENT_ORG_RELTN


Column Name Type Null? Definition
DA_DOCUMENT_ID DOUBLE N The document this Organization is related to.
DA_DOCUMENT_ORG_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the DA_DOCUMENT_ORG_RELTN table.
ORGANIZATION_ID DOUBLE N The organization associated with the personnel when the report was generated.
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_DOCUMENT_ORG_RELTN


Child Column in DA_DOCUMENT_ORG_RELTN(FK) Parent Table Name Parent Column Name
Parents: DA_DOCUMENT_ID DA_DOCUMENT DA_DOCUMENT_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


DA_DOCUMENT_PRSNL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Document Personnel Relation
Definition: An optional association between a document and prsnl members or prsnl groups. This will be used to control access to documents in a user's inbox of Discern Analytics 2.0.
Table Type: ACTIVITY





Column Detail - DA_DOCUMENT_PRSNL_RELTN


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.
DA_DOCUMENT_ID DOUBLE N The document this personnel member or personnel group is associated with.
DA_DOCUMENT_PRSNL_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the DA_DOCUMENT_PRSNL_RELTN table.
DELIVERY_DT_TM DATETIME Y The date and time the document was delivered to the document inbox.
PRSNL_GROUP_ID DOUBLE N The personnel group that is associated with the document.
PRSNL_ID DOUBLE N The personnel member that is associated with the document.
READ_CHANGE_DT_TM DATETIME Y The date and time the personnel member changed the read / unread status.
READ_IND DOUBLE N Flag to indicate whether the document has been read by the personnel member.
REQUESTED_BY_PRSNL_ID DOUBLE N Represents the prsnl that requested the new document / prsnl relationship (in this case, it is the user that either manually marked the document to be saved to a certain prsnl / prsnl group or the user that scheduled the document for execution)
SHORT_DESC VARCHAR(200) N A description of, or reason for, the selected document being sent, as defined by the user responsible for the document being sent. For display in the DA2 Document Inbox.
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_DOCUMENT_PRSNL_RELTN


Child Column in DA_DOCUMENT_PRSNL_RELTN(FK) Parent Table Name Parent Column Name
Parents: DA_DOCUMENT_ID DA_DOCUMENT DA_DOCUMENT_ID
PRSNL_ID PRSNL PERSON_ID
REQUESTED_BY_PRSNL_ID PRSNL PERSON_ID
PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID


DA_DOMAIN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Domain
Definition: Contains the definitions of business domains for used for reporting in Discern Analytics 2.0.
Table Type: REFERENCE





Column Detail - DA_DOMAIN


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_DOMAIN_ID DOUBLE N Unique, generated number that identifies a single row on the DA_DOMAIN table.
DEPRECATED_IND DOUBLE N Indicates this domain has been deprecated. A row that has been deprecated indicates that there is a future intention to inactivate the row.
DOMAIN_DESC VARCHAR(255) N A description of the business domain.
DOMAIN_NAME VARCHAR(100) N The name of the business domain.
DOMAIN_NAME_KEY VARCHAR(100) N The name of the business domain, uppercased and white space removed, for use in searching.
DOMAIN_NAME_KEY_A_NLS VARCHAR(400) Y The NLS key for searching in all non-English locales.
DOMAIN_OPTIONS_TXT_ID DOUBLE N Long Text Id that contains the domain options.
DOMAIN_TYPE_CD DOUBLE N Identifies the type of DA2 domain, such as from da2 metadata, or for JDBC reporting
DOMAIN_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.
EXTENDED_IND DOUBLE N Indicates a Cerner created Domain has been modified by a user.
OWNER_GROUP_CD DOUBLE N The owner group of the domain, used to categorize items across a solution group or functional area (ex Operational vs Financial).
TIMER_NAME VARCHAR(255) Y The timer to be used when running queries from this business domain.
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_DOMAIN


Child Column in DA_DOMAIN(FK) Parent Table Name Parent Column Name
Parents: DOMAIN_OPTIONS_TXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in DA_DOMAIN (PK) Child Table Name Child Column Name
Children: DA_DOMAIN_ID DA_DOMAIN_BV_RELTN DA_DOMAIN_ID
DA_QUERY DA_DOMAIN_ID
DA_REPORT DA_DOMAIN_ID


DA_DOMAIN_BV_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Domain Business View Relation
Definition: Contains the relationships between Business domains and Business Views used in Discern Analytics 2.0 metadata.
Table Type: REFERENCE





Column Detail - DA_DOMAIN_BV_RELTN


Column Name Type Null? Definition
BUS_VIEW_SEQ DOUBLE N The sequence value which determines the logical ordering of the view within a domain.
CORE_IND DOUBLE N Indicates this row was created by Cerner.
DA_BUS_VIEW_ID DOUBLE N A business View that is related to this Domain.
DA_DOMAIN_BV_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the DA_DOMAIN_BV_RELTN table.
DA_DOMAIN_ID DOUBLE N The Domain that is associated with this Business View.
REQUIRED_IND DOUBLE N Indicates whether the business view is required for this domain. Marking a business view in a domain as required forces the SQL engine to include any join statements marked as required in the logical views (contained in the business view) to be included in the SQL along with the tables associated with the join, regardless of what columns have been selected in the query
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_DOMAIN_BV_RELTN


Child Column in DA_DOMAIN_BV_RELTN(FK) Parent Table Name Parent Column Name
Parents: DA_BUS_VIEW_ID DA_BUS_VIEW DA_BUS_VIEW_ID
DA_DOMAIN_ID DA_DOMAIN DA_DOMAIN_ID