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