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 |