Table Detail Report

DM_TEXT_FIND_LOG_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Interrogator server log details
Definition: This table will store log and status of detailed actions performed by Interrogator server 520
Table Type: ACTIVITY





Column Detail - DM_TEXT_FIND_LOG_DETAIL


Column Name Type Null? Definition
DETAIL_MESSAGE VARCHAR(255) Y Contains message about status
DETAIL_STATUS VARCHAR(20) Y Contains the status information of log row
DM_TEXT_FIND_LOG_DETAIL_ID DOUBLE N Primary Key for table
DM_TEXT_FIND_LOG_ID DOUBLE N Reference to the DM_TEXT_FIND_LOG row that logging affects
END_DT_TM DATETIME Y Contains date/time when logging ended
START_DT_TM DATETIME Y Contains date/time when logging started
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 - DM_TEXT_FIND_LOG_DETAIL


Child Column in DM_TEXT_FIND_LOG_DETAIL(FK) Parent Table Name Parent Column Name
Parents: DM_TEXT_FIND_LOG_ID DM_TEXT_FIND_LOG DM_TEXT_FIND_LOG_ID


DM_TEXT_FIND_QUERY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Datbase Management Text Find Query
Definition: This table will store meta-data about the queries to run in the new Text Search tool owned by DM
Table Type: REFERENCE





Column Detail - DM_TEXT_FIND_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.
DM_TEXT_FIND_CAT_ID DOUBLE N Foreign key to DM_TEXT_FIND_CAT table
DM_TEXT_FIND_QUERY_ID DOUBLE N Primary Key for table
DRIVER_COL_NAME VARCHAR(30) Y The driver column necessary to construct the query joins
JOIN_TYPE_FLAG DOUBLE N **OBSOLETE - THIS COLUMN MOVED TO TABLE DM_TEXT_FIND_DTL_QUERY_R** The flag to indicate how join is performed to get data
QUERY_COL_DEFAULT_WEIGHT DOUBLE N The default weight to assign to this QUERY_GROUP_NAME and QUERY_COLUMN combination.
QUERY_COL_NAME VARCHAR(30) Y The column name to query on in the TEXT
QUERY_GROUP_NAME VARCHAR(40) Y A group name used to associated similar queries to each other.
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.
VALUE_DEFAULT_WEIGHT DOUBLE N The default weight to assign to this QUERY_GROUP_NAME and QUERY_VALUE combination.
WHERE_COL_TEXT VARCHAR(1000) Y The where clause used to find data values to query upon



Relationship Detail - DM_TEXT_FIND_QUERY


Child Column in DM_TEXT_FIND_QUERY(FK) Parent Table Name Parent Column Name
Parents: DM_TEXT_FIND_CAT_ID DM_TEXT_FIND_CAT DM_TEXT_FIND_CAT_ID


DM_TEXT_FIND_QUERY_WEIGHT



Column Section Top of Page


Table-level Detail

Description: Database Management Text Find Query Weighting
Definition: This table will store the relative weighting for specific queries on the query group level.
Table Type: REFERENCE





Column Detail - DM_TEXT_FIND_QUERY_WEIGHT


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.
CRITERIA VARCHAR(2000) N The criteria that will determine what value
CRITERIA_TYPE_FLAG DOUBLE N Indicates what type of data is contained in the Criteria column (an exact value, a range, a regular expression, a custom rule, etc.)
DM_TEXT_FIND_QUERY_WEIGHT_ID DOUBLE N Primary Key for table
QUERY_GROUP_NAME VARCHAR(40) N Indicates which group of queries to this weighting applies to. Value comes from the DM_TEXT_FIND_QUERY 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.
WEIGHT DOUBLE N The weight to assign to this QUERY_GROUP_NAME and QUERY_VALUE combination. 100 will be the default weight assigned to values not contained in this table.


DM_TEXT_FIND_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_TEXT_FIND_QUEUE
Definition: This table serves as a queue for hosting jobs to be consumed by server 520
Table Type: ACTIVITY





Column Detail - DM_TEXT_FIND_QUEUE


Column Name Type Null? Definition
DM_TEXT_FIND_DETAIL_ID DOUBLE N Foreign Key to the DM_TEXT_FIND_DETAIL table
DM_TEXT_FIND_LOG_ID DOUBLE N Foreign Key to the DM_TEXT_FIND_LOG row for this executing report.
DM_TEXT_FIND_QUEUE_ID DOUBLE N PRIMARY KEY
ENQUEUED_ON_DT_TM DATETIME N The date this item was added to the queue.
EXECUTE_ON_DT_TM DATETIME N The Date after which this job can be executed by the assigned server
EXECUTE_ON_NODE_NAME VARCHAR(30) N Name of the Node this job is meant to execute on, or ANY if the call can be run by any server
LOCKED_BY_SERVER_IDENT DOUBLE Y The Internal Server 520 ID that has claimed this job. This value will be NULL until a server claims this task.
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 - DM_TEXT_FIND_QUEUE


Child Column in DM_TEXT_FIND_QUEUE(FK) Parent Table Name Parent Column Name
Parents: DM_TEXT_FIND_DETAIL_ID DM_TEXT_FIND_DETAIL DM_TEXT_FIND_DETAIL_ID
DM_TEXT_FIND_LOG_ID DM_TEXT_FIND_LOG DM_TEXT_FIND_LOG_ID


DM_TEXT_FIND_QUEUE_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_TEXT_FIND_QUEUE_HISTORY
Definition: This table serves as an archival history of the queue for hosting jobs to be consumed by server 520
Table Type: ACTIVITY





Column Detail - DM_TEXT_FIND_QUEUE_HIST


Column Name Type Null? Definition
DM_TEXT_FIND_DETAIL_ID DOUBLE N Foreign Key to the DM_TEXT_FIND_DETAIL table
DM_TEXT_FIND_LOG_ID DOUBLE N Foreign Key to the DM_TEXT_FIND_LOG row for this executing report.
DM_TEXT_FIND_QUEUE_HIST_ID DOUBLE N PRIMARY KEY
ENQUEUED_ON_DT_TM DATETIME N The date this item was added to the queue.
EXECUTE_END_DT_TM DATETIME N The date this job stopped running
EXECUTE_ON_DT_TM DATETIME N The Date after which this job can be executed by the assigned server
EXECUTE_ON_NODE_NAME VARCHAR(30) N Name of the Node this job is meant to execute on, or ANY if the call can be run by any server
EXECUTE_START_DT_TM DATETIME N The date this job began running
LOCKED_BY_NODE_NAME VARCHAR(30) N Node which has locked the job
LOCKED_BY_SERVER_IDENT DOUBLE N The Internal Server 520 ID that has claimed this job. This value will be NULL until a server claims this task.
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 - DM_TEXT_FIND_QUEUE_HIST


Child Column in DM_TEXT_FIND_QUEUE_HIST(FK) Parent Table Name Parent Column Name
Parents: DM_TEXT_FIND_DETAIL_ID DM_TEXT_FIND_DETAIL DM_TEXT_FIND_DETAIL_ID
DM_TEXT_FIND_LOG_ID DM_TEXT_FIND_LOG DM_TEXT_FIND_LOG_ID