Table Detail Report

SI_UNMTCHD_PRSN_QUE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Person Queue Relation
Definition: This table relates inbound messages to unmatched person information
Table Type: ACTIVITY





Column Detail - SI_UNMTCHD_PRSN_QUE_RELTN


Column Name Type Null? Definition
MESSAGE_DT_TM DATETIME Y The date of the inbound message.
MESSAGE_EVENT_TXT VARCHAR(100) N Message event from the inbound message
MESSAGE_TYPE_TXT VARCHAR(100) N Message type from the inbound message
PROCESS_STATUS_CD DOUBLE N Status of unmatched person record
QUEUE_ID DOUBLE N Queue ID from cqm_oeninterface_que
SI_TRANSACTION_ID DOUBLE Y The transaction associated with the inbound message
SI_UNMTCHD_PRSN_QUE_ID DOUBLE N Foreign Key to si_unmatched_person_que
SI_UNMTCHD_PRSN_QUE_RELTN_ID DOUBLE N PRIMARY KEY
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_UNMTCHD_PRSN_QUE_RELTN


Child Column in SI_UNMTCHD_PRSN_QUE_RELTN(FK) Parent Table Name Parent Column Name
Parents: QUEUE_ID CQM_OENINTERFACE_QUE QUEUE_ID
SI_TRANSACTION_ID SI_TRANSACTION SI_TRANSACTION_ID