Table Detail Report

DM_TEXT_FIND_SERVER



Column Section Top of Page


Table-level Detail

Description: DM TEXT FIND SERVER
Definition: This table will serve as a state monitoring table used to track and manage server instances across multiple nodes
Table Type: ACTIVITY





Column Detail - DM_TEXT_FIND_SERVER


Column Name Type Null? Definition
DM_TEXT_FIND_SERVER_ID DOUBLE N PRIMARY KEY
SERVER_INTERNAL_IDENT DOUBLE Y This is a unique java identifier generated at server startup
SERVER_NODE_NAME VARCHAR(30) N The name of the node on which this server instance is running.
SERVER_NODE_TYPE VARCHAR(10) N This identifies the mode the server is running in. Right now this consists of MASTER and SLAVE states.
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.


DM_TEXT_FIND_STRUCT



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_TEXT_FIND_STRUCT
Definition: This table will store structured report information with links to the serialized object content for use with the Interrogator application
Table Type: REFERENCE





Column Detail - DM_TEXT_FIND_STRUCT


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_DETAIL_ID DOUBLE N Foreign Key reference to the report associated with this data.
DM_TEXT_FIND_STRUCT_ID DOUBLE N PRIMARY KEY
GENERATED_MATCH_CONTENT VARCHAR(200) N Dynamic Value that can be used to potentially match content. Designed for future functionality.
LONG_BLOB_ID DOUBLE N Foreign Key to LONG_BLOB_REFERENCE where we are storing the serialized content.
ROW_SEQUENCE_NUMBER DOUBLE N Sequence number to help order rows from single detail report.
SERIALIZED_CLOB_LENGTH DOUBLE N Length of the CLOB Content written to LONG_TEXT_REFERENCE
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_STRUCT


Child Column in DM_TEXT_FIND_STRUCT(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_DETAIL_ID DM_TEXT_FIND_DETAIL DM_TEXT_FIND_DETAIL_ID
LONG_BLOB_ID LONG_BLOB_REFERENCE LONG_BLOB_ID




Parent Column in DM_TEXT_FIND_STRUCT (PK) Child Table Name Child Column Name
Children: DM_TEXT_FIND_STRUCT_ID DM_TEXT_FIND_STRUCT_CMNT DM_TEXT_FIND_STRUCT_ID


DM_TEXT_FIND_STRUCT_CMNT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Data Management - Text Find Structure Comment
Definition: Table to support new Mark as Reviewed feature for Structured Data content containing ECD9 content.
Table Type: REFERENCE





Column Detail - DM_TEXT_FIND_STRUCT_CMNT


Column Name Type Null? Definition
COMMENT_DT_TM DATETIME N Date the comment was written
COMMENT_PRSNL_ID DOUBLE N Foreign Key to the personnel id for the user recording this comment
COMMENT_STATE_FLAG DOUBLE N The state of this particular comment
COMMENT_TEXT VARCHAR(1000) Y The text provided to describe why this comment is being added
DM_TEXT_FIND_STRUCT_CMNT_ID DOUBLE N PRIMARY KEY
DM_TEXT_FIND_STRUCT_ID DOUBLE N Foreign Key reference to the structured object this row is a comment for
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_STRUCT_CMNT


Child Column in DM_TEXT_FIND_STRUCT_CMNT(FK) Parent Table Name Parent Column Name
Parents: DM_TEXT_FIND_STRUCT_ID DM_TEXT_FIND_STRUCT DM_TEXT_FIND_STRUCT_ID
COMMENT_PRSNL_ID PRSNL PERSON_ID


DM_TEXT_FIND_SUMMARY



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_TEXT_FIND_SUMMARY
Definition: This table is going to be used to stage some summary data generated by server 520 so it can be reported on via KART audit.
Table Type: ACTIVITY





Column Detail - DM_TEXT_FIND_SUMMARY


Column Name Type Null? Definition
DM_TEXT_FIND_CAT_ID DOUBLE N Foreign Key to the DM_TEXT_FIND_CAT table
DM_TEXT_FIND_DETAIL_ID DOUBLE N Foreign Key to the DM_TEXT_FIND_DETAIL table
DM_TEXT_FIND_SUMMARY_ID DOUBLE N Unique generated number that identifies a single row on the DM_TEXT_FIND_SUMMARY table.
MARKED_AS_REVIEWED_CNT DOUBLE N Count of the number of rows that were marked as reviewed for this report, if that report supports the Mark as Reviewed functionality
OBJECT_FOUND_CNT DOUBLE N Count of the number of rows found for this report
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_SUMMARY


Child Column in DM_TEXT_FIND_SUMMARY(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_DETAIL_ID DM_TEXT_FIND_DETAIL DM_TEXT_FIND_DETAIL_ID


DM_TRANSACTIONS



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM TRANSACTIONS
Definition: One row per transaction that should be tracked
Table Type: REFERENCE





Column Detail - DM_TRANSACTIONS


Column Name Type Null? Definition
BATCH_END_DT_TM DATETIME Y defines the ending of a transaction
BATCH_START_DT_TM DATETIME Y defines the beginning of a transaction
DESCRIPTION VARCHAR(80) Y description for the transaction
TRANSACTION_CAT_CD DOUBLE Y defines the type of transactions - not currently used
TRANSACTION_ID DOUBLE N unique identifier for the 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.



Relationship Detail - DM_TRANSACTIONS




Parent Column in DM_TRANSACTIONS (PK) Child Table Name Child Column Name
Children: TRANSACTION_ID DM_TRANSACTION_ACTIVITY TRANSACTION_ID