Table Detail Report
DA_BATCH_SCHED
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Discern Analytcs Batch Schedule |
Definition: | Contains schedule details of schedules created in Discern Analytics 2.0. |
Table Type: | REFERENCE |
Column Detail - DA_BATCH_SCHED
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. |
BEGIN_EFFECTIVE_DT_TM | DATETIME | N | Date and time the batch schedule became effective. |
CREATED_BY_PRSNL_ID | DOUBLE | N | The personnel that created the batch schedule. |
CREATED_DT_TM | DATETIME | Y | The date and time this batch schedule was created. |
DAYS_OF_WEEK | VARCHAR(8) | Y | Days of the week that the schedule is to be run (for example 134=Sun, Tues, Thur) |
DAY_OF_MONTH | DOUBLE | Y | Day of the month that the batch is to be run (1-31, 99=always use the last day of the month) |
DA_BATCH_COLLECTION_ID | DOUBLE | N | Identifies the collection this batch schedule belongs to. |
DA_BATCH_SCHED_DESC | VARCHAR(100) | Y | Description of the batch schedule. |
DA_BATCH_SCHED_ID | DOUBLE | N | Unique generated number that identifies a single row on the DA_BATCH_SCHED table. |
DA_SCHED_TYPE_FLAG | DOUBLE | N | Indicates whether the schedule is for reports or queries. 0=report, 1=query |
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. |
FREQ_NBR | DOUBLE | N | How often the batch schedule occurs (every 1 day, 2 weeks, 3 months) |
RECURRENCE_FLAG | DOUBLE | N | How often the batch schedule occurs (every 1 day, 2 weeks, 3 months) |
TIME_OF_DAY_TXT | VARCHAR(10) | N | Time of day the batch schedule is to be run (24-hour format) |
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_BATCH_SCHED
Child Column in DA_BATCH_SCHED(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DA_BATCH_COLLECTION_ID | DA_BATCH_COLLECTION | DA_BATCH_COLLECTION_ID |
CREATED_BY_PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in DA_BATCH_SCHED (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DA_BATCH_SCHED_ID | DA_BATCH_QUERY | DA_BATCH_SCHED_ID |
DA_BATCH_REPORT | DA_BATCH_SCHED_ID | ||
DA_BATCH_SCHED_LOG | DA_BATCH_SCHED_ID |
DA_BATCH_SCHED_LOG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Discern Analytics Batch Schedule Log |
Definition: | Log containing the execution status of the Discern Analytics 2.0 schedules. |
Table Type: | ACTIVITY |
Column Detail - DA_BATCH_SCHED_LOG
Column Name | Type | Null? | Definition |
---|---|---|---|
BATCH_SCHED_END_DT_TM | DATETIME | Y | The data and time that the last report finished execution for this batch schedule. |
BATCH_SCHED_EXP_START_DT_TM | DATETIME | N | The date/time that this batch schedule should have been run (even if it is hours later). |
BATCH_SCHED_START_DT_TM | DATETIME | N | The date and time that this batch schedule began execution. |
DA_BATCH_SCHED_ID | DOUBLE | N | The batch schedule that this log entry pertains to. |
DA_BATCH_SCHED_LOG_ID | DOUBLE | N | Unique generated number that identifies a single row on the DA_BATCH_SCHED_LOG table. |
ERROR_TXT_ID | DOUBLE | N | Error associated with the execution of the schedule. |
NODE_NAME | VARCHAR(63) | Y | Name of the node on which this schedule execution occurred |
SUCCESS_IND | DOUBLE | N | Indicate if the batch schedule was actually successful or not. |
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_BATCH_SCHED_LOG
Child Column in DA_BATCH_SCHED_LOG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DA_BATCH_SCHED_ID | DA_BATCH_SCHED | DA_BATCH_SCHED_ID |
ERROR_TXT_ID | LONG_TEXT | LONG_TEXT_ID |
Parent Column in DA_BATCH_SCHED_LOG (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DA_BATCH_SCHED_LOG_ID | DA_BATCH_QUERY_LOG | DA_BATCH_SCHED_LOG_ID |
DA_BATCH_REPORT_LOG | DA_BATCH_SCHED_LOG_ID |
DA_BUS_VIEW
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Discern Analytics Business View |
Definition: | The business view is a definition of the visual representation and customization of one or more logical views. |
Table Type: | REFERENCE |
Column Detail - DA_BUS_VIEW
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. |
BUS_VIEW_DESC | VARCHAR(255) | N | A description of the business view. |
BUS_VIEW_NAME | VARCHAR(100) | N | The name of the business view. |
BUS_VIEW_NAME_KEY | VARCHAR(100) | N | The name of the business view, uppercased and white space removed, for use in searching. |
BUS_VIEW_NAME_KEY_A_NLS | VARCHAR(400) | Y | The NLS key for searching in all non-English locales. |
BUS_VIEW_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. |
CAT_COL_LONG_TEXT_ID | DOUBLE | N | Identifies the Category/Column view hierarchy for this business view, stored in XML format on the Long_Text_reference table. |
CORE_IND | DOUBLE | N | Indicates this business view has been created by Cerner. |
DA_BUS_VIEW_ID | DOUBLE | N | Unique, generated number that identifies a single row on the DA_BUS_VIEW table. |
DEPRECATED_IND | DOUBLE | N | Indicates this business view has been deprecated. A row that has been deprecated indicates that there is a future intention to inactivate the row. |
EXTENDED_IND | DOUBLE | N | Indicates a Cerner created business view has been modified by a user. |
OWNER_GROUP_CD | DOUBLE | N | The owner group of the business view, used to categorize items across a solution group or functional area (ex Operational vs Financial). |
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. |
Relationship Detail - DA_BUS_VIEW
Child Column in DA_BUS_VIEW(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CAT_COL_LONG_TEXT_ID | LONG_TEXT_REFERENCE | LONG_TEXT_ID |
Parent Column in DA_BUS_VIEW (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DA_BUS_VIEW_ID | DA_BV_LV_ELEM_RELTN | DA_BUS_VIEW_ID |
DA_DOMAIN_BV_RELTN | DA_BUS_VIEW_ID |
DA_BV_LV_ELEM_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Discern Analytics Business View Logical View Element Relation |
Definition: | Contains the relationships between business views, logical views and elements used in Discern Analytics 2.0 metadata. |
Table Type: | REFERENCE |
Column Detail - DA_BV_LV_ELEM_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
DA_BUS_VIEW_ID | DOUBLE | N | The Business View that this logical view and element relate to. |
DA_BV_LV_ELEM_RELTN_ID | DOUBLE | N | Unique, generated number that identifies a single row on the DA_BV_LV_ELEM_RELTN table. |
DA_ELEMENT_ID | DOUBLE | N | Identifies the element that is defined for this business view/logical view combination. |
DA_LOGICAL_VIEW_ID | DOUBLE | N | Identifies the logical view that is related to this business view and 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. |
Relationship Detail - DA_BV_LV_ELEM_RELTN
Child Column in DA_BV_LV_ELEM_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DA_BUS_VIEW_ID | DA_BUS_VIEW | DA_BUS_VIEW_ID |
DA_ELEMENT_ID | DA_ELEMENT | DA_ELEMENT_ID | |
DA_LOGICAL_VIEW_ID | DA_LOGICAL_VIEW | DA_LOGICAL_VIEW_ID |
DA_CALC_ELEM_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Discern Analytics Calculation Element Relation |
Definition: | Contains the Discern Analytics 2.0 parent/child relationships for calculated elements. |
Table Type: | REFERENCE |
Column Detail - DA_CALC_ELEM_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
CHILD_ELEMENT_ID | DOUBLE | N | An element within a calculation (when an element contains a calculation that includes elements from the logical view). |
DA_CALC_ELEM_RELTN_ID | DOUBLE | N | Unique, generated number that identifies a single row on the DA_CALC_ELEM_RELTN table. |
PARENT_ELEMENT_ID | DOUBLE | N | The actual calculated element when an element contains a calculation that includes elements from the logical view. |
RELTN_TYPE_FLAG | DOUBLE | N | |
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_CALC_ELEM_RELTN
Child Column in DA_CALC_ELEM_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CHILD_ELEMENT_ID | DA_ELEMENT | DA_ELEMENT_ID |
PARENT_ELEMENT_ID | DA_ELEMENT | DA_ELEMENT_ID |