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 |