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 |