Table Detail Report

DA_ELEMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Element
Definition: Defines a column of information that may be used in a query and/or used to filter a query. The element may contain an sql select, a where clause, as well as the defining qualities of the element that are needed by the Discern Analytics 2.0 reporting system.qualities of the element that are needed by the reporting system.
Table Type: REFERENCE





Column Detail - DA_ELEMENT


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.
AGGREGATE_FN_CD DOUBLE N Code value which identifies the aggregate function to use with this element in the data cube.
COLUMN_STRING_TXT_ID DOUBLE N Reference to the long_text_reference table which contains the expression which represents how the data item will be retrieved by a query.
COLUMN_VAL_FLAG DOUBLE N Indicates which attribute, if any, defines the element's ID value. Useful when the column select clause is display text.
CORE_IND DOUBLE N Indicates this row was created by Cerner.
DA_ELEMENT_ID DOUBLE N Unique, generated number that identifies a single row on the DA_ELEMENT table.
DEPRECATED_IND DOUBLE N Indicates this element has been deprecated. A row that has been deprecated indicates that there is a future intention to inactivate the row.
ELEMENT_DESC VARCHAR(255) N A description of how the element is displayed or used.
ELEMENT_NAME VARCHAR(100) N The unique name for the Element.
ELEMENT_NAME_KEY VARCHAR(100) N Uppercased element_name with white spaces and special characters removed.
ELEMENT_NAME_KEY_A_NLS VARCHAR(400) Y The NLS key for searching in all non-English locales.
ELEMENT_TYPE_CD DOUBLE N Code value that Defines the type of element, such as fact or dimension.
ELEMENT_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.
FILTER_CODE_SET DOUBLE N Code set used for generic code value filters.
FILTER_IND DOUBLE N Specifies whether the element is filterable.
FILTER_MEANING VARCHAR(50) N Reference to the filter meaning table. The filter meaning retrieves the information used for displaying prompts and filters.
FORMAT_TXT VARCHAR(50) N Optionally specifies how the element is formatted for reporting.
GROUP_BY_COLUMN_IND DOUBLE N Indicates if the SQL engine will include the text contained in the column_string_txt_id from the long_text_reference in the group by clause.
GROUP_BY_IND DOUBLE N Specifies whether the group_by_string_txt will be added to the Group By .
GROUP_BY_QUAL_IND DOUBLE N Indicates whether the qualification string text will be included in the group by statement.
GROUP_BY_STRING_TXT VARCHAR(255) Y Alternate value to be used in group by expression.
KEY_ELEMENT_ID DOUBLE N Reserved for future use.
OWNER_GROUP_CD DOUBLE N The owner group of the element, used to categorize items across a solution group
QUAL_DATA_TYPE_FLAG DOUBLE N Specifies the data type returned for the qualification such as date, numeric, string
QUAL_STRING_TXT VARCHAR(255) Y Represents the SQL string that will be used in the where clause when this element is used as a filter.
RESULT_DATA_TYPE_FLAG DOUBLE N Specifies the data type returned for the result such as date, numeric, string.
SORT_FLAG DOUBLE N Specifies the report type of sorting used for this 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.
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.
WHERE_CLAUSE_TXT_ID DOUBLE N Reference to the long_text_reference table which contains an qualification expression for the element.



Relationship Detail - DA_ELEMENT


Child Column in DA_ELEMENT(FK) Parent Table Name Parent Column Name
Parents: KEY_ELEMENT_ID DA_ELEMENT DA_ELEMENT_ID
COLUMN_STRING_TXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
WHERE_CLAUSE_TXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
FILTER_MEANING OMF_FILTER_MEANING FILTER_MEANING




Parent Column in DA_ELEMENT (PK) Child Table Name Child Column Name
Children: DA_ELEMENT_ID DA_BV_LV_ELEM_RELTN DA_ELEMENT_ID
DA_CALC_ELEM_RELTN CHILD_ELEMENT_ID
DA_CALC_ELEM_RELTN PARENT_ELEMENT_ID
DA_ELEMENT KEY_ELEMENT_ID
DA_ELEM_UDF_RELTN DA_ELEMENT_ID
DA_LV_TABLE_ELEM_RELTN DA_ELEMENT_ID


DA_ELEM_UDF_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Element User Defined Fields Relation
Definition: Defines relationships from Discern Analytics 2.0 elements to user-defined fields.
Table Type: REFERENCE





Column Detail - DA_ELEM_UDF_RELTN


Column Name Type Null? Definition
DA_ELEMENT_ID DOUBLE N Identifier of the element representing this user defined field in Discern Analytics 2.0.
DA_ELEM_UDF_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the DA_ELEM_UDF_RELTN table.
FIELD_SEQ DOUBLE N The sequence of this field in the list of parent fields for the element.
PARENT_ENTITY_ID DOUBLE N Identifier of the entity representing this user defined field.
PARENT_ENTITY_NAME VARCHAR(32) N Name of the entity representing this user defined field.
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_ELEM_UDF_RELTN


Child Column in DA_ELEM_UDF_RELTN(FK) Parent Table Name Parent Column Name
Parents: DA_ELEMENT_ID DA_ELEMENT DA_ELEMENT_ID


DA_FOLDER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Folder
Definition: The folder table is used to capture information for each folder used in Discern Analyics 2.0 reporting
Table Type: REFERENCE





Column Detail - DA_FOLDER


Column Name Type Null? Definition
CORE_IND DOUBLE N Indicates this business view was created by Cerner.
CREATE_DT_TM DATETIME N Date and time the folder was created.
CREATE_PRSNL_ID DOUBLE N Person that initially created the folder.
DA_FOLDER_ID DOUBLE N Unique generated number that identifies a single row on the DA_FOLDER table.
DA_FOLDER_NAME VARCHAR(255) N Name of the folder.
DA_FOLDER_NAME_KEY VARCHAR(255) N Same as the folder name, but converted to upper case with spaces removed.
DA_FOLDER_NAME_KEY_A_NLS VARCHAR(1020) Y The NLS key for searching in all non-English locales.
FOLDER_DESC VARCHAR(2000) N Description of the folder.
FOLDER_TYPE_CD DOUBLE N Method of categorizing a folder.
FOLDER_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.
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 folder, used to categorize items across a solution group or functional area (ex Operational vs Financial).
PARENT_FOLDER_ID DOUBLE N Higher level folder for this one.
PUBLIC_IND DOUBLE N Determines whether the folder is available for public use.
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_FOLDER


Child Column in DA_FOLDER(FK) Parent Table Name Parent Column Name
Parents: PARENT_FOLDER_ID DA_FOLDER DA_FOLDER_ID
CREATE_PRSNL_ID PRSNL PERSON_ID




Parent Column in DA_FOLDER (PK) Child Table Name Child Column Name
Children: DA_FOLDER_ID DA_FOLDER PARENT_FOLDER_ID
DA_FOLDER_QUERY_RELTN DA_FOLDER_ID
DA_FOLDER_REPORT_RELTN DA_FOLDER_ID


DA_FOLDER_QUERY_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Folder Query Relation
Definition: Defines the relationship between Folders and queries in Discern Analytics 2.0
Table Type: REFERENCE





Column Detail - DA_FOLDER_QUERY_RELTN


Column Name Type Null? Definition
DA_FOLDER_ID DOUBLE N The folder that this query resides in.
DA_FOLDER_QUERY_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the DA_FOLDER_QUERY_RELTN table.
DA_QUERY_ID DOUBLE N The query that resides in this folder.
QUERY_ALIAS_NAME VARCHAR(255) Y Name of the Query as it will be shown in the folder.
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_FOLDER_QUERY_RELTN


Child Column in DA_FOLDER_QUERY_RELTN(FK) Parent Table Name Parent Column Name
Parents: DA_FOLDER_ID DA_FOLDER DA_FOLDER_ID
DA_QUERY_ID DA_QUERY DA_QUERY_ID


DA_FOLDER_REPORT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Folder Report Relation
Definition: Defines the relationship between Reports and folders in Discern Analytics 2.0.
Table Type: REFERENCE





Column Detail - DA_FOLDER_REPORT_RELTN


Column Name Type Null? Definition
DA_FOLDER_ID DOUBLE N The folder that this report resides in.
DA_FOLDER_REPORT_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the DA_FOLDER_REPORT_RELTN table.
DA_REPORT_ID DOUBLE N Report that resides in this folder.
REPORT_ALIAS_NAME VARCHAR(255) N Name of the Report as it will be shown in the folder.
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 report object.
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.
VIEWER_MODE_CD DOUBLE N reference to code set 4002472 (da2 object types). A default of 0.0 indicates the standard da2 report viewer will be used to display reports.



Relationship Detail - DA_FOLDER_REPORT_RELTN


Child Column in DA_FOLDER_REPORT_RELTN(FK) Parent Table Name Parent Column Name
Parents: DA_FOLDER_ID DA_FOLDER DA_FOLDER_ID
DA_REPORT_ID DA_REPORT DA_REPORT_ID