Table Detail Report

DA_QUERY_DEFAULT_PROMPTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Query Default Prompts
Definition: Contains the default prompts for a user of a Discern Analytics 2.0 Query,
Table Type: REFERENCE





Column Detail - DA_QUERY_DEFAULT_PROMPTS


Column Name Type Null? Definition
DA_QUERY_DEFAULT_PROMPTS_ID DOUBLE N Unique generated number that identifies a single row on the DA_QUERY_DEFAULT_PROMPTS table.
DA_QUERY_ID DOUBLE N The query that these prompts apply to.
DEFAULT_PROMPTS_TEXT_ID DOUBLE N Pointer to the LONG_TEXT_REFERENCE row that contains the default prompts for 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.
USER_PRSNL_ID DOUBLE N The user that selected these prompts during the query execution.



Relationship Detail - DA_QUERY_DEFAULT_PROMPTS


Child Column in DA_QUERY_DEFAULT_PROMPTS(FK) Parent Table Name Parent Column Name
Parents: DA_QUERY_ID DA_QUERY DA_QUERY_ID
DEFAULT_PROMPTS_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
USER_PRSNL_ID PRSNL PERSON_ID


DA_RELATIVE_DATE



Column Section Top of Page


Table-level Detail

Description: Discern Analytics Relative Date
Definition: Used to define the sql needed to convert a relative code for a date range such as 'Year To Date' in Discern Analytics 2.0
Table Type: REFERENCE





Column Detail - DA_RELATIVE_DATE


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.
DA_RELATIVE_DATE_ID DOUBLE N Unique, generated number that identifies a single row on the DA_RELATIVE_DATE table.
FROM_DATE_TXT VARCHAR(255) Y SQL string used to convert a from-date.
RELATIVE_DATE_CD DOUBLE N The type of date that these conversions apply to.
TO_DATE_TXT VARCHAR(255) Y SQL string used to convert a to-date.
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.


DA_REPORT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Report
Definition: The report table is used to store information for each report in Discern Analytics 2.0
Table Type: REFERENCE





Column Detail - DA_REPORT


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.
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.
CATALOG_IND DOUBLE N Identifies reports that are part of a catalog.
CORE_IND DOUBLE N Indicates this report was created by Cerner.
CREATE_DT_TM DATETIME N Date and time the report was created.
CREATE_PRSNL_ID DOUBLE N Person that initially created the report.
DA_DOMAIN_ID DOUBLE N Domain from which the report is generated.
DA_REPORT_ID DOUBLE N Unique, generated number that identifies a single row on the DA_REPORT table.
DEPRECATED_IND DOUBLE N Indicates this report has been deprecated. A row that has been deprecated indicates that there is a future intention to inactivate the row.
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.
EXTENDED_IND DOUBLE N Indicates a Cerner created report has been modified by a user.
FILTER_PROMPT_IND DOUBLE N Indicates whether the report 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.
LONG_TEXT_ID DOUBLE N Contains all of the properties of the report.
OWNER_GROUP_CD DOUBLE N The owner group of the report, 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 report.
REPORT_NAME VARCHAR(255) N Name of the Report.
REPORT_NAME_KEY VARCHAR(255) N Same as the report name, but converted to upper case with spaces removed.
REPORT_NAME_KEY_A_NLS VARCHAR(1020) Y The NLS key for searching in all non-English locales.
REPORT_SERVICE_CD DOUBLE N Reference to code set 4000601 (CclReportServiceBindings). A default of 0.0 indicates the CpmScriptBatch service is used for this report object.
REPORT_TYPE_CD DOUBLE N Method of categorizing a report.
REPORT_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.
SHORT_DESC VARCHAR(2000) N Description of the Report.
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.
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_REPORT


Child Column in DA_REPORT(FK) Parent Table Name Parent Column Name
Parents: DA_DOMAIN_ID DA_DOMAIN DA_DOMAIN_ID
LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
OWNER_PRSNL_ID PRSNL PERSON_ID




Parent Column in DA_REPORT (PK) Child Table Name Child Column Name
Children: DA_REPORT_ID DA_BATCH_REPORT DA_REPORT_ID
DA_DOCUMENT DA_REPORT_ID
DA_FOLDER_REPORT_RELTN DA_REPORT_ID
DA_REPORT_DEFAULT_PROMPTS DA_REPORT_ID
DA_REPORT_QUERY_RELTN DA_REPORT_ID


DA_REPORT_DEFAULT_PROMPTS



Column Section Relationship Section Top of Page


Table-level Detail

Description: DA_REPORT_DEFAULT_PROMPTS
Definition: The purpose of this table is to store user-specific runtime prompt values for reports.
Table Type: REFERENCE





Column Detail - DA_REPORT_DEFAULT_PROMPTS


Column Name Type Null? Definition
DA_REPORT_DEFAULT_PROMPTS_ID DOUBLE N PRIMARY KEY
DA_REPORT_ID DOUBLE Y discern analytics report identifier
DEFAULT_PROMPTS_TEXT_ID DOUBLE Y pointer to the long_text_reference row that contains the default prompts
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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.
USER_PRSNL_ID DOUBLE Y the user that selected these prompts during execution.



Relationship Detail - DA_REPORT_DEFAULT_PROMPTS


Child Column in DA_REPORT_DEFAULT_PROMPTS(FK) Parent Table Name Parent Column Name
Parents: DA_REPORT_ID DA_REPORT DA_REPORT_ID
DEFAULT_PROMPTS_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
USER_PRSNL_ID PRSNL PERSON_ID


DA_REPORT_QUERY_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Report Query Relation
Definition: Defines the relationship between Discern Analytics 2.0 reports and queries.
Table Type: REFERENCE





Column Detail - DA_REPORT_QUERY_RELTN


Column Name Type Null? Definition
DA_QUERY_ID DOUBLE N The query that is related to this report.
DA_REPORT_ID DOUBLE N The report that is related to this query.
DA_REPORT_QUERY_RELTN_ID DOUBLE N Unique, generated number that identifies a single row on the DA_REPORT_QUERY_RELTN table.
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_REPORT_QUERY_RELTN


Child Column in DA_REPORT_QUERY_RELTN(FK) Parent Table Name Parent Column Name
Parents: DA_QUERY_ID DA_QUERY DA_QUERY_ID
DA_REPORT_ID DA_REPORT DA_REPORT_ID