Table Detail Report

DM_TEMP_CONSTRAINTS



Column Section Top of Page


Table-level Detail

Description: Temporary table for primary key constraints.
Definition: DM Merge table
Table Type: ACTIVITY





Column Detail - DM_TEMP_CONSTRAINTS


Column Name Type Null? Definition
COLUMN_NAME VARCHAR(30) Y Column name
CONSTRAINT_NAME VARCHAR(30) Y Constraint name
POSITION DOUBLE Y Column position
TABLE_NAME VARCHAR(30) Y TABLE NAME


DM_TEXT_FIND



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - DM_TEXT_FIND


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_ID DOUBLE N Primary Key for table
FIND_NAME VARCHAR(50) N Name of search criteria inside category
FIND_NAME_KEY VARCHAR(50) N Similar to FIND_NAME but contains only upper case and alphanumeric characters without any special characters or embedded spaces; Typically used in index to improve query performance
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




Parent Column in DM_TEXT_FIND (PK) Child Table Name Child Column Name
Children: DM_TEXT_FIND_ID DM_TEXT_FIND_CAT_R DM_TEXT_FIND_ID
DM_TEXT_FIND_DETAIL DM_TEXT_FIND_ID


DM_TEXT_FIND_CAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Database Management Text Find Category
Definition: This table will store meta-data about the new Text Search tool owned by DM
Table Type: REFERENCE





Column Detail - DM_TEXT_FIND_CAT


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 Primary Key for table
FIND_CATEGORY VARCHAR(30) N Name of search category
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_CAT




Parent Column in DM_TEXT_FIND_CAT (PK) Child Table Name Child Column Name
Children: DM_TEXT_FIND_CAT_ID DM_TEXT_FIND_CAT_R DM_TEXT_FIND_CAT_ID
DM_TEXT_FIND_COMMENT DM_TEXT_FIND_CAT_ID
DM_TEXT_FIND_HIGHLIGHT DM_TEXT_FIND_CAT_ID
DM_TEXT_FIND_QUERY DM_TEXT_FIND_CAT_ID
DM_TEXT_FIND_STRUCT DM_TEXT_FIND_CAT_ID
DM_TEXT_FIND_SUMMARY DM_TEXT_FIND_CAT_ID


DM_TEXT_FIND_CAT_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Database Management Text Find Category Relation
Definition: This table will store meta-data about the new Text Search tool owned by DM
Table Type: REFERENCE





Column Detail - DM_TEXT_FIND_CAT_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_CAT_ID DOUBLE N Reference to the DM_TEXT_FIND_CAT table
DM_TEXT_FIND_CAT_R_ID DOUBLE N Primary Key for table
DM_TEXT_FIND_ID DOUBLE N Reference to the DM_TEXT_FIND 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.



Relationship Detail - DM_TEXT_FIND_CAT_R


Child Column in DM_TEXT_FIND_CAT_R(FK) Parent Table Name Parent Column Name
Parents: DM_TEXT_FIND_ID DM_TEXT_FIND DM_TEXT_FIND_ID
DM_TEXT_FIND_CAT_ID DM_TEXT_FIND_CAT DM_TEXT_FIND_CAT_ID


DM_TEXT_FIND_COMMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: DM_TEXT_FIND_COMMENT
Definition: Stores a list of unstructured objects the user has chosen to exclude from their interrogator reports.
Table Type: REFERENCE





Column Detail - DM_TEXT_FIND_COMMENT


Column Name Type Null? Definition
COMMENT_COL_DT_TM DATETIME N The date value stored in the column named in comment_col_name to use for comparison by the interrogator application.
COMMENT_COL_NAME VARCHAR(30) N The name of the column used to compare for source object changes. This will likely be 'scriptCompileDate', but other values may be provided.
COMMENT_DT_TM DATETIME N The date this comment was requested.
COMMENT_PRSNL_ID DOUBLE N The user who is requesting this comment.
COMMENT_STATE_FLAG DOUBLE N The state flag to indicate the state of the comment when it was recorded by the user.
COMMENT_TEXT VARCHAR(1000) Y The message, if any, the user records to indicate why they are excluding this object.
COMMENT_TYPE_FLAG DOUBLE N The type flag indicator used to differentiate between comment types.
DATA_SOURCE VARCHAR(255) N The object source_data identifier, as determined by the interrogator application.
DM_TEXT_FIND_CAT_ID DOUBLE N Reference to the DM_TEXT_FIND_CAT table for the category this comment is associated with.
DM_TEXT_FIND_COMMENT_ID DOUBLE N Unique generated number that identifies a single row on the DM_TEXT_FIND_COMMENT table.
DM_TEXT_FIND_DATA_ID DOUBLE N Reference to the DM_TEXT_FIND_DATA table for the object being commented on.
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_COMMENT


Child Column in DM_TEXT_FIND_COMMENT(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
COMMENT_PRSNL_ID PRSNL PERSON_ID