DA_BATCH_COLLECTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Batch Collection
Definition: Identifies collections of schedules.
Table Type: REFERENCE





Column Detail - DA_BATCH_COLLECTION


Column Name Type Null? Definition
COLLECTION_NAME VARCHAR(100) N Defines the name of the collection
COLLECTION_NAME_KEY VARCHAR(100) N This field contains the Collection Name with all special characters removed and all alpha characters converted to uppercase.
CREATE_PRSNL_ID DOUBLE N Identifies the user account that created this row
DA_BATCH_COLLECTION_ID DOUBLE N Unique generated number that identifies a single row on the DA_BATCH_COLLECTION table.
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_COLLECTION


Child Column in DA_BATCH_COLLECTION(FK) Parent Table Name Parent Column Name
Parents: CREATE_PRSNL_ID PRSNL PERSON_ID




Parent Column in DA_BATCH_COLLECTION (PK) Child Table Name Child Column Name
Children: DA_BATCH_COLLECTION_ID DA_BATCH_SCHED DA_BATCH_COLLECTION_ID


DA_BATCH_QUERY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Batch Query
Definition: Contains the list of queries to be ran in the Discern Analytics 2.0 scheduler.
Table Type: REFERENCE





Column Detail - DA_BATCH_QUERY


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.
ADDITIONAL_PARAMETER_TXT_ID DOUBLE N Additional parameters to be used for running the query
ASSIGNED_DOCUMENT_NAME VARCHAR(100) Y Name of the document to be assigned.
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.
CREATED_BY_PRSNL_ID DOUBLE N The person that generated this batch query.
CREATED_DT_TM DATETIME Y The date and time this batch query was created.
DA_BATCH_QUERY_DESC VARCHAR(100) Y Description of the batch query.
DA_BATCH_QUERY_ID DOUBLE N Unique generated number that identifies a single row on the DA_BATCH_QUERY table.
DA_BATCH_SCHED_ID DOUBLE N The schedule that generates this query.
DA_QUERY_ID DOUBLE N The query that is a part of this batch
DOCUMENT_TYPE_CD DOUBLE N The type of document generated (such as html, pdf, postscript, etc.)
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.
PROCESS_SEQ DOUBLE N Sequence within the job that the batch query should be run
RUNTIME_PROMPT_TXT_ID DOUBLE N Runtime prompts to be used for running the query.
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_QUERY


Child Column in DA_BATCH_QUERY(FK) Parent Table Name Parent Column Name
Parents: DA_BATCH_SCHED_ID DA_BATCH_SCHED DA_BATCH_SCHED_ID
DA_QUERY_ID DA_QUERY DA_QUERY_ID
ADDITIONAL_PARAMETER_TXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
RUNTIME_PROMPT_TXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
CREATED_BY_PRSNL_ID PRSNL PERSON_ID




Parent Column in DA_BATCH_QUERY (PK) Child Table Name Child Column Name
Children: DA_BATCH_QUERY_ID DA_BATCH_QUERY_LOG DA_BATCH_QUERY_ID


DA_BATCH_QUERY_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Batch Query Log
Definition: Log containing the execution status of scheduled Discern Analytics 2.0 queries.
Table Type: ACTIVITY





Column Detail - DA_BATCH_QUERY_LOG


Column Name Type Null? Definition
BATCH_QUERY_END_DT_TM DATETIME Y Date and time that the batch query finished.
BATCH_QUERY_START_DT_TM DATETIME N Date and time that the batch query began execution.
CREATED_DOCUMENT_ID DOUBLE N Document identifier that was created from the executed query
DA_BATCH_QUERY_ID DOUBLE N The query that these statistics are for.
DA_BATCH_QUERY_LOG_ID DOUBLE N Unique generated number that identifies a single row on the DA_BATCH_QUERY_LOG table.
DA_BATCH_SCHED_LOG_ID DOUBLE N The statistics for the schedule that this query was part of.
ERROR_TXT_ID DOUBLE N Error associated with the execution of the query.
SUCCESS_IND DOUBLE N Indicate if the batch query 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_QUERY_LOG


Child Column in DA_BATCH_QUERY_LOG(FK) Parent Table Name Parent Column Name
Parents: DA_BATCH_QUERY_ID DA_BATCH_QUERY DA_BATCH_QUERY_ID
DA_BATCH_SCHED_LOG_ID DA_BATCH_SCHED_LOG DA_BATCH_SCHED_LOG_ID
CREATED_DOCUMENT_ID DA_DOCUMENT DA_DOCUMENT_ID
ERROR_TXT_ID LONG_TEXT LONG_TEXT_ID


DA_BATCH_REPORT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Batch Report
Definition: Contains report schedule information for reports scheduled in Discern Analytics 2.0.
Table Type: REFERENCE





Column Detail - DA_BATCH_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.
ADDITIONAL_PARAMETER_TXT_ID DOUBLE N Additional parameters to be used for running the report
ASSIGNED_DOCUMENT_NAME VARCHAR(100) Y Name of the document to be assigned.
BEGIN_EFFECTIVE_DT_TM DATETIME N Date and time batch report is effective.
CREATED_BY_PRSNL_ID DOUBLE N Personnel that added the report to be scheduled.
CREATED_DT_TM DATETIME Y Date and time this batch report was created.
DA_BATCH_REPORT_DESC VARCHAR(100) Y Description of the batch report.
DA_BATCH_REPORT_ID DOUBLE N Unique generated number that identifies a single row on the DA_BATCH_REPORT table.
DA_BATCH_SCHED_ID DOUBLE N The schedule that generates this report.
DA_REPORT_ID DOUBLE N The identifier of the report that is to be run.
DOC_TYPE_CD DOUBLE N Type of document to be produced
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.
PROCESS_SEQ DOUBLE N Sequence within the job that the batch report should be run
REPORT_PARAMETER_TXT_ID DOUBLE N Report parameters to be used for running the report
RUNTIME_PROMPT_TXT_ID DOUBLE N Runtime prompts to be used for running the report.
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_REPORT


Child Column in DA_BATCH_REPORT(FK) Parent Table Name Parent Column Name
Parents: DA_BATCH_SCHED_ID DA_BATCH_SCHED DA_BATCH_SCHED_ID
DA_REPORT_ID DA_REPORT DA_REPORT_ID
ADDITIONAL_PARAMETER_TXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
REPORT_PARAMETER_TXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
RUNTIME_PROMPT_TXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
CREATED_BY_PRSNL_ID PRSNL PERSON_ID




Parent Column in DA_BATCH_REPORT (PK) Child Table Name Child Column Name
Children: DA_BATCH_REPORT_ID DA_BATCH_REPORT_LOG DA_BATCH_REPORT_ID


DA_BATCH_REPORT_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Discern Analytics Batch Report Log
Definition: Log containing detail execution status for reports scheduled in Discern Analytics 2.0
Table Type: ACTIVITY





Column Detail - DA_BATCH_REPORT_LOG


Column Name Type Null? Definition
BATCH_REPORT_END_DT_TM DATETIME Y Date and time that the batch report finished.
BATCH_REPORT_START_DT_TM DATETIME N Date and time that the batch report began execution.
CREATED_DOCUMENT_ID DOUBLE N Document identifier that was created from the executed report
DA_BATCH_REPORT_ID DOUBLE N The report that these statistics are for.
DA_BATCH_REPORT_LOG_ID DOUBLE N Unique generated number that identifies a single row on the DA_BATCH_REPORT_LOG table.
DA_BATCH_SCHED_LOG_ID DOUBLE N The statistics for the schedule that this report was part of.
ERROR_TXT_ID DOUBLE N Error associated with the execution of the report.
SUCCESS_IND DOUBLE N Indicate if the batch report 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_REPORT_LOG


Child Column in DA_BATCH_REPORT_LOG(FK) Parent Table Name Parent Column Name
Parents: DA_BATCH_REPORT_ID DA_BATCH_REPORT DA_BATCH_REPORT_ID
DA_BATCH_SCHED_LOG_ID DA_BATCH_SCHED_LOG DA_BATCH_SCHED_LOG_ID
CREATED_DOCUMENT_ID DA_DOCUMENT DA_DOCUMENT_ID
ERROR_TXT_ID LONG_TEXT LONG_TEXT_ID