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 |