Table Detail Report

SI_XDOC_METADATA_INFO



Column Section Relationship Section Top of Page


Table-level Detail

Description: SI XDOC METADATA INFO
Definition: Stores lists of data related to a parent document
Table Type: ACTIVITY





Column Detail - SI_XDOC_METADATA_INFO


Column Name Type Null? Definition
METADATA_INFO VARCHAR(60) Y Other information used to describe the metadata.
METADATA_NAME VARCHAR(40) N Name of the metadata element being stored.
METADATA_TEXT VARCHAR(255) Y Textual representation of the element being stored.
METADATA_VALUE DOUBLE N A numeric value if needed to describe the metadata.
SEQUENCE DOUBLE N Sequence of the metadata appearance in the message.
SI_XDOC_AUTHOR_ID DOUBLE N A foreign key to the parent SI_XDOC_AUTHOR table.
SI_XDOC_METADATA_ID DOUBLE N A foreign key to the parent SI_XDOC_METADATA table.
SI_XDOC_METADATA_INFO_ID DOUBLE N The primary key to the metadata Information 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 - SI_XDOC_METADATA_INFO


Child Column in SI_XDOC_METADATA_INFO(FK) Parent Table Name Parent Column Name
Parents: SI_XDOC_AUTHOR_ID SI_XDOC_AUTHOR SI_XDOC_AUTHOR_ID
SI_XDOC_METADATA_ID SI_XDOC_METADATA SI_XDOC_METADATA_ID


SI_XDOC_QUERY_PERSON_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration External Document Query Person Relationship
Definition: This table stores the dates and statuses of queries to registries or gateways in attempts to query for documents.
Table Type: ACTIVITY





Column Detail - SI_XDOC_QUERY_PERSON_RELTN


Column Name Type Null? Definition
ACK_SI_MESSAGE_LOG_ID DOUBLE N Foreign key to the SI_MESSAGE_LOG table where the record contains information from the acknowledgement of the primary message.
CONTRIBUTOR_SYSTEM_CD DOUBLE N Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
INTERNAL_MESSAGE_IDENT VARCHAR(60) N ** OBSOLETE - this column is no longer used - replaced by usage of the SI_MESSAGE_LOG_ID field.
MESSAGE_SEQUENCE DOUBLE N ** OBSOLETE - this column is no longer used - replaced by usage of the SI_MESSAGE_LOG_ID field.
MESSAGE_TYPE VARCHAR(100) Y This will be the type of message sent for this query, Find Documents, Pix Query are just examples of what can be called.
ORGANIZATION_ID DOUBLE N The organization used to initiate the query.
PARENT_QUERY_PRSN_RELTN_ID DOUBLE N Any row that ha this populated is a Child row to the primary query relationship. These will be spawned because of multiple messages that may be transmitted because of the initial query.
PERSON_ID DOUBLE N The person being whose documents are being queried for. Foreign key to Person table.
QUERY_FROM_DT_TM DATETIME Y This is the date that the query is requesting documents from.
QUERY_START_DT_TM DATETIME N The date that the document query was initiated
QUERY_STATUS_CD DOUBLE N The current status of the querying, Queried, Success, Failure
QUERY_STOP_DT_TM DATETIME N The date that the document query was completed
QUEUE_ID DOUBLE N Foreign key to the CQM_OENINTERFACE_QUE table for the query that has been enqueued to a CQM listener, such as Open Engine.
SI_MESSAGE_LOG_ID DOUBLE N Foreign key to the SI_MESSAGE_LOG table where the record contains the information related to the primary message
SI_XDOC_QUERY_PERSON_RELTN_ID DOUBLE N The primary key of the 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.
USER_ID DOUBLE N The user that initiated the query.



Relationship Detail - SI_XDOC_QUERY_PERSON_RELTN


Child Column in SI_XDOC_QUERY_PERSON_RELTN(FK) Parent Table Name Parent Column Name
Parents: CONTRIBUTOR_SYSTEM_CD CONTRIBUTOR_SYSTEM CONTRIBUTOR_SYSTEM_CD
QUEUE_ID CQM_OENINTERFACE_QUE QUEUE_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
USER_ID PRSNL PERSON_ID
ACK_SI_MESSAGE_LOG_ID SI_MESSAGE_LOG SI_MESSAGE_LOG_ID
SI_MESSAGE_LOG_ID SI_MESSAGE_LOG SI_MESSAGE_LOG_ID
PARENT_QUERY_PRSN_RELTN_ID SI_XDOC_QUERY_PERSON_RELTN SI_XDOC_QUERY_PERSON_RELTN_ID




Parent Column in SI_XDOC_QUERY_PERSON_RELTN (PK) Child Table Name Child Column Name
Children: SI_XDOC_QUERY_PERSON_RELTN_ID SI_EXT_REGISTRY_RESPONSE SI_XDOC_QUERY_PERSON_RELTN_ID
SI_XDOC_METADATA SI_XDOC_QUERY_PERSON_RELTN_ID
SI_XDOC_QUERY_PERSON_RELTN PARENT_QUERY_PRSN_RELTN_ID