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 |