Table Detail Report

SI_ESO_TRIG_ROUT_R_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration ESO Trigger Routine Relation HistoryThis table stores all mod
Definition: This table stores all modifications made to the ESO_Trig_Routine_R table.
Table Type: REFERENCE





Column Detail - SI_ESO_TRIG_ROUT_R_HIST


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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
MODIFY_PRSNL_ID DOUBLE N Prsnl ID of the user who made new modification on the Outbound_Field_Processing table
ORIG_PRSNL_ID DOUBLE N Prsnl ID of the user who made original record on the Outbound_Field_Processing table
PARENT_ACTIVE_IND DOUBLE N Parent Active Indicator used to track the active indicator of the Parent Table.
REC_BEG_EFF_DT_TM DATETIME Y Copy of the Beg_Eff_Dt_TM from the ESO_TRIG_ROUTINE_R Table
RELATED_TRIG_ROUT_ARG_ID DOUBLE N Related identifier used for recursive relationship within this table.
ROUTINE_ARGS VARCHAR(255) N Routine Argument
ROUTINE_CONTROL DOUBLE N Routine Control Arguments
ROUTINE_ID DOUBLE N Foreign Key to ESO_Routine
SEQUENCE_NBR DOUBLE N Order of Arguments for the Trigger/Routine combination
SI_ESO_TRIG_ROUT_R_HIST_ID DOUBLE N System Integration Trigger Routine Argument History Identifier - Primary Key
TRIGGER_ID DOUBLE N Foreign Key to ESO_Trigger
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_ESO_TRIG_ROUT_R_HIST


Child Column in SI_ESO_TRIG_ROUT_R_HIST(FK) Parent Table Name Parent Column Name
Parents: ROUTINE_ID ESO_TRIG_ROUTINE_R ROUTINE_ID
TRIGGER_ID ESO_TRIG_ROUTINE_R TRIGGER_ID


SI_MAPPING_OBJECT



Column Section Relationship Section Top of Page


Table-level Detail

Description: SI MAPPING OBJECT
Definition: This table holds the mapping objects available for use by the SI Batch piece.
Table Type: REFERENCE





Column Detail - SI_MAPPING_OBJECT


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.
CREATE_DT_TM DATETIME N The date and time the row was created.Column
MAP_ID DOUBLE N This uniquely identifies each mapping object.Column
OBJECT_NAME VARCHAR(255) N The name of the mapping object.Column
OBJECT_TYPE_FLAG DOUBLE N Identifies the type of mapping object.Column
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - SI_MAPPING_OBJECT




Parent Column in SI_MAPPING_OBJECT (PK) Child Table Name Child Column Name
Children: MAP_ID SI_COMSRV_MSG_MAP_R MAP_ID


SI_MESSAGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: SI MESSAGE
Definition: This table defines an inbound message
Table Type: REFERENCE





Column Detail - SI_MESSAGE


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.
APPLICATION VARCHAR(10) N This indicates the ownership of the row.Column
CREATE_DT_TM DATETIME N This is the Date & Time the row was created.Column
INTERFACE_TYPE_CD DOUBLE N Interface type code. Defines what kind of interface.
MAP_NBR DOUBLE N This is the TDB number of the proprietary object the inbound message will be mapped into
MESSAGE_DESC VARCHAR(255) N Simply a description of the message.Column
MESSAGE_FORMAT_CD DOUBLE N This is used to identify what format the messages are in.Column
MESSAGE_ID DOUBLE N This uniquely identifies a message with an application.Column
MESSAGE_TRIGGER_CD DOUBLE N This identifies the Trigger Type of the message (ex. A01).Column
MESSAGE_TYPE_CD DOUBLE N This identifies the type of message (ex. ADT, ORU etc.).Column
MESSAGE_VERSION_CD DOUBLE N This identifies the version of the message (ex. 2.3, 4010 etc.).Column
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - SI_MESSAGE




Parent Column in SI_MESSAGE (PK) Child Table Name Child Column Name
Children: MESSAGE_ID SI_COMSRV_MSG_MAP_R MESSAGE_ID


SI_MESSAGE_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Si_message_log
Definition: This table is used to store inbound and outbound interface messages for auditing and troubleshooting purposes
Table Type: ACTIVITY





Column Detail - SI_MESSAGE_LOG


Column Name Type Null? Definition
ACK_SEQUENCE DOUBLE N ACK SEQUENCE column
APPLICATION_NAME VARCHAR(50) Y The name of the interface application that logged the message.
COMPRESSING_IND DOUBLE N Indicates whether message body has been compressed
ENDPOINT_URI VARCHAR(255) Y Free-text endpoint URI that is associated with the message.
INTERFACEID DOUBLE N Identifier of interface inserting message. Value from OEN_PROCINFO
INTERNAL_MESSAGE_IDENT VARCHAR(40) N System generated message identifier
MESSAGE_DIRECTION_FLAG DOUBLE N Direction of message in relation to the interface inserting row. 0 - not set 1 - Inbound message 2 - Outbound message
MESSAGE_IDENT VARCHAR(40) N Message identifier from message body
MESSAGE_SEQUENCE DOUBLE N Sequence of message in conversation
MESSAGE_SIZE DOUBLE N Size of message as stored on this table
MESSAGE_TEXT LONGBLOB Y Message that was sent/received
SI_MESSAGE_LOG_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_MESSAGE_LOG




Parent Column in SI_MESSAGE_LOG (PK) Child Table Name Child Column Name
Children: SI_MESSAGE_LOG_ID DQR_DOCUMENT_ACTION SI_MESSAGE_LOG_ID
SI_ERROR_RELTN SI_MESSAGE_LOG_ID
SI_HAAD_TRANSACTION SUBMIT_MSGLOG_ID
SI_HAAD_TRANSACTION SUBMIT_RESP_MSGLOG_ID
SI_REPO_REG_RELTN ACK_SI_MESSAGE_LOG_ID
SI_REPO_REG_RELTN SI_MESSAGE_LOG_ID
SI_XDOC_METADATA DOC_RETR_ACK_SI_MESSAGE_LOG_ID
SI_XDOC_METADATA DOC_RETR_SI_MESSAGE_LOG_ID
SI_XDOC_QUERY_PERSON_RELTN ACK_SI_MESSAGE_LOG_ID
SI_XDOC_QUERY_PERSON_RELTN SI_MESSAGE_LOG_ID