Table Detail Report

DM_TEXT_FIND_DATA



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_TEXT_FIND_DATA
Definition: This table will store information about the items being searched by the DM Search Tool
Table Type: REFERENCE





Column Detail - DM_TEXT_FIND_DATA


Column Name Type Null? Definition
ATTRIBUTE_DESC VARCHAR(2000) Y Holds additional attribute information about data row
COMPILE_DT_TM DATETIME Y Holds the last compile date and time for script
DATA_SOURCE VARCHAR(255) N This field identifies the source of the data
DM_TEXT_FIND_DATA_ID DOUBLE N Primary Key for table
DM_TEXT_FIND_DETAIL_ID DOUBLE N Foreign Key back to DM_TEXT_FIND_DETAIL table
FIND_NAME VARCHAR(50) N The Find Name information from the grandparent table.
GROUP_NUM DOUBLE Y Holds Group number of script name
HAS_HIGHLIGHTS_IND DOUBLE Y Indicator as to whether this data object contains highlights
LAST_PRESTAGE_DT_TM DATETIME Y Date when this object was last scanned for highlight content
NODE_NAME VARCHAR(30) Y The name of the node that loaded this content. Adding in support of multi-node functionality.
PARENT_ENTITY_COL VARCHAR(30) N Holds reference to column name where ID value will be found
PARENT_ENTITY_ID DOUBLE N Holds reference to ID which will hold searchable text.
PARENT_ENTITY_NAME VARCHAR(30) N Holds reference of table name which will hold searchable text
ROW_SEQUENCE_NBR DOUBLE N Rows from this data table that do not contain highlights will have a value of 0, all those that do will have be sequenced in order by our server.
SCRIPT_IGNORE_IND DOUBLE N Indicates whether script should be ignored in search
SCRIPT_NAME VARCHAR(30) Y Holds the script name being searched
SCRIPT_PATH VARCHAR(100) Y Holds the path where script is located
SEARCH_COL_NAME VARCHAR(30) N Holds column name which will hold searchable text
SERIALIZED_BLOB_LENGTH DOUBLE Y Length of the BLOB Content written to LONG_TEXT_REFERENCE
SERIALIZED_LONG_BLOB_ID DOUBLE N Foreign Key to the Long Text Reference table for serialized object content
STATUS_FLAG DOUBLE N Holds status of row
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.
USER_NAME VARCHAR(50) Y Holds the user name who owns the script/rule



Relationship Detail - DM_TEXT_FIND_DATA


Child Column in DM_TEXT_FIND_DATA(FK) Parent Table Name Parent Column Name
Parents: DM_TEXT_FIND_DETAIL_ID DM_TEXT_FIND_DETAIL DM_TEXT_FIND_DETAIL_ID
SERIALIZED_LONG_BLOB_ID LONG_BLOB_REFERENCE LONG_BLOB_ID




Parent Column in DM_TEXT_FIND_DATA (PK) Child Table Name Child Column Name
Children: DM_TEXT_FIND_DATA_ID DM_TEXT_FIND_COMMENT DM_TEXT_FIND_DATA_ID
DM_TEXT_FIND_HIGHLIGHT DM_TEXT_FIND_DATA_ID


DM_TEXT_FIND_DETAIL



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_TEXT_FIND_DETAIL
Definition: This table will store meta-data Details about the new Text Search tool owned by DM
Table Type: REFERENCE





Column Detail - DM_TEXT_FIND_DETAIL


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.
DETAIL_DESCRIPTION VARCHAR(100) Y Description of the Detail record
DETAIL_MEANING VARCHAR(20) N Contains a Meaning used to identify the row
DETAIL_SCRIPT_NAME VARCHAR(30) Y Holds a script name to retrieve data, when query can¿t be used
DETAIL_TEXT_ID DOUBLE N Foreign Key back to LONG_TEXT_REFERENCE that contains query to search data.
DETAIL_TYPE_FLAG DOUBLE N A flag that indicates what type of detail row this is.
DM_TEXT_FIND_DETAIL_ID DOUBLE N Primary Key for table
DM_TEXT_FIND_ID DOUBLE N Foreign Key back to DM_TEXT_FIND table
FREQUENCY DOUBLE Y Contains the frequency in which detail should be run in server
MULTI_NODE_IND DOUBLE N This column will indicate whether this report can be run on multiple nodes.
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_DETAIL


Child Column in DM_TEXT_FIND_DETAIL(FK) Parent Table Name Parent Column Name
Parents: DM_TEXT_FIND_ID DM_TEXT_FIND DM_TEXT_FIND_ID
DETAIL_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in DM_TEXT_FIND_DETAIL (PK) Child Table Name Child Column Name
Children: DM_TEXT_FIND_DETAIL_ID DM_TEXT_FIND_DATA DM_TEXT_FIND_DETAIL_ID
DM_TEXT_FIND_DTL_QUERY_R DM_TEXT_FIND_DETAIL_ID
DM_TEXT_FIND_LOG DM_TEXT_FIND_DETAIL_ID
DM_TEXT_FIND_QUEUE DM_TEXT_FIND_DETAIL_ID
DM_TEXT_FIND_QUEUE_HIST DM_TEXT_FIND_DETAIL_ID
DM_TEXT_FIND_STRUCT DM_TEXT_FIND_DETAIL_ID
DM_TEXT_FIND_SUMMARY DM_TEXT_FIND_DETAIL_ID


DM_TEXT_FIND_DTL_QUERY_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Datbase Management Text Find Detail Query Relation
Definition: This table will store the relation between detail rows, and what queries to run against those detail rows.
Table Type: REFERENCE





Column Detail - DM_TEXT_FIND_DTL_QUERY_R


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_DETAIL_ID DOUBLE N Foreign Key back to DM_TEXT_FIND_DETAIL table
DM_TEXT_FIND_DTL_QUERY_R_ID DOUBLE N Primary Key for table
JOIN_TYPE_FLAG DOUBLE N Indicates which join should be used when querying 0 = no join necessary; 1 = AND style join; 2 = Outer join favoring column name hits; 3 = Outer join favoring driver values; 4 = OR style join
QUERY_GROUP_NAME VARCHAR(40) N Indicates which group of queries to row for given DETAIL_ID
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 - DM_TEXT_FIND_DTL_QUERY_R


Child Column in DM_TEXT_FIND_DTL_QUERY_R(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_HIGHLIGHT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Management - Text Find Highlight
Definition: This table will store highlights found in unstructured data content which will be used for assembling ICD9 content reports.
Table Type: REFERENCE





Column Detail - DM_TEXT_FIND_HIGHLIGHT


Column Name Type Null? Definition
DM_TEXT_FIND_CAT_ID DOUBLE N Foreign Key reference to the search category associated with this data
DM_TEXT_FIND_DATA_ID DOUBLE N Foreign Key reference to the data object associated with this data
DM_TEXT_FIND_HIGHLIGHT_ID DOUBLE N PRIMARY KEY
HIGHLIGHT_SOURCE_NAME VARCHAR(50) N The Source NAME used to find the Highlights for this row
HIGHLIGHT_TEXT VARCHAR(250) N The context in which this highlight was found
HIGHLIGHT_WEIGHT DOUBLE Y The weighting of this highlight. Higher numbers indicate more reliable results
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_HIGHLIGHT


Child Column in DM_TEXT_FIND_HIGHLIGHT(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_DATA_ID DM_TEXT_FIND_DATA DM_TEXT_FIND_DATA_ID


DM_TEXT_FIND_LOG



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - DM_TEXT_FIND_LOG


Column Name Type Null? Definition
DM_TEXT_FIND_DETAIL_ID DOUBLE N Reference to the DM_TEXT_FIND_DETAIL row that logging affects
DM_TEXT_FIND_LOG_ID DOUBLE N Primary Key for table
END_DT_TM DATETIME Y Contains date/time when logging ended
LOG_DESCRIPTION VARCHAR(255) Y Contains additional information about action being logged
LOG_MESSAGE VARCHAR(255) Y Contains message about status
LOG_STATUS VARCHAR(20) Y Contains the status information of log row
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


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




Parent Column in DM_TEXT_FIND_LOG (PK) Child Table Name Child Column Name
Children: DM_TEXT_FIND_LOG_ID DM_TEXT_FIND_LOG_DETAIL DM_TEXT_FIND_LOG_ID
DM_TEXT_FIND_QUEUE DM_TEXT_FIND_LOG_ID
DM_TEXT_FIND_QUEUE_HIST DM_TEXT_FIND_LOG_ID