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 |