Table Detail Report

SI_BATCH_EVENT_MSG



Column Section Top of Page


Table-level Detail

Description: SI BATCH EVENT MSG
Definition: This table holds the batch events (i.e. UI Messages) in compressed form.
Table Type: ACTIVITY





Column Detail - SI_BATCH_EVENT_MSG


Column Name Type Null? Definition
BATCH_EVENT_ID DOUBLE N Unique batch event identifier.
MESSAGE LONGBLOB Y The compressed batch event (i.e. UI Message).Column
MESSAGE_LENGTH DOUBLE N The size of the compressed batch event (i.e. UI Message).Column
SEQ_NUM DOUBLE N If a message is broken up into pieces this identifies the order of thoes pieces.
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.


SI_BATCH_EVENT_SYS



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table hold the batch events for the individual interfaces.
Definition: Each row on this table represents a batch event for the interface to process.
Table Type: ACTIVITY





Column Detail - SI_BATCH_EVENT_SYS


Column Name Type Null? Definition
BATCH_EVENT_ID DOUBLE N Unique batch event identifier.
BEG_SEG_SEQ_NUM DOUBLE N The sequence number of the first message segment corresponding to the batch event. This value is in reference to the ST segment position
COMPLETE_DT_TM DATETIME Y Indicates the date and time the interface completed processing the batch event.Column
END_SEG_SEQ_NUM DOUBLE N The sequence number of the last message segment corresponding to the batch event. This value is in reference to the ST segment position
EVENT_STATUS_FLAG DOUBLE N Indicates the processing status of each event.Column
EVENT_STATUS_TEXT VARCHAR(500) N Textual description of the batch_event's status.Column
GRP_BEG_SEG_SEQ_NUM DOUBLE N The sequence number indicating the start of the group header segment (2000A, 2010AA, 2010AB loops) for the given batch event. This value is in reference to the ST segment's position.
GRP_END_SEG_SEQ_NUM DOUBLE N The sequence number indicating the end of the group header segment (2000A, 2010AA, 2010AB loops) for the given batch event. This value is in reference to the ST segment's position.
GS_IDENT VARCHAR(250) N Unique identifier for the GS functional GroupColumn
INTERFACE_ID DOUBLE N Identifies a unique interface. This value comes from the INTERFACEID column in the OEN_PROCINFO table.
RESPONSE_CD DOUBLE N The status of the batch event from an acknowledgement, e.g., X12N 997 response.Column
SEQ_NUM DOUBLE N Indicates the order in which the batch events are processed.Column
START_DT_TM DATETIME Y Indicates the date and time the interface started processing the batch event.
ST_IDENT VARCHAR(250) N Unique identifier for the ST transaction setColumn
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_BATCH_EVENT_SYS


Child Column in SI_BATCH_EVENT_SYS(FK) Parent Table Name Parent Column Name
Parents: BATCH_EVENT_ID SI_BATCH_EVENT BATCH_EVENT_ID


SI_BATCH_STATS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Hold the statistical information on a batch.
Definition: This table is where all the statistical information is held for a batch being processed by a specific interface.
Table Type: ACTIVITY





Column Detail - SI_BATCH_STATS


Column Name Type Null? Definition
BATCH_ID DOUBLE N Unique batch identifier.
COMPLETE_DT_TM DATETIME Y The interface completion date and time for the batch.
INTERFACE_ID DOUBLE N Identifies a unique interface.
MESSAGE_COUNT DOUBLE Y A count of the UI Messages processed by the interface for a given batch.Column
OEN_TRIGGER_ID DOUBLE N Open Engine Trigger
START_DT_TM DATETIME Y The interface start date and time for the batch.
TALLY_CD DOUBLE N Code Set (25560) identifies the type of tally being used.
TALLY_VALUE VARCHAR(255) Y The result of the tally.
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_BATCH_STATS


Child Column in SI_BATCH_STATS(FK) Parent Table Name Parent Column Name
Parents: BATCH_ID SI_BATCH BATCH_ID


SI_CONTRIBUTOR_SYSTEM_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contributor System History
Definition: This table stores historical information for the Contributor_System table.
Table Type: REFERENCE





Column Detail - SI_CONTRIBUTOR_SYSTEM_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.
ACT_CONTRIBUTOR_SYSTEM_CD DOUBLE N Copy of the Act_Contributor_System_Cd from the Contributor_system Table
ALT_CONTRIB_SRC_CD DOUBLE N Copy of the Alt_Contrib_Src_Cd from the Contributor_system Table
AOF_ENABLED_IND DOUBLE N When this field is active, the system states that code values will be added on the fly when possible.
AUTHORIZATION_TYPE_CD DOUBLE N The method used for the authorizing messages for this contributor system.
AUTHORIZATION_URL VARCHAR(255) N The URL for authorization information.
AUTO_COMBINE_IND DOUBLE Y Copy of the Auto_Combine_Ind from the Contributor_system Table
CLIENT_IDENT VARCHAR(100) Y Stores the clientId details to contributor_system table. ; Identifies the globally-unique identifier of the client application.; Values are of type UTF8(STRING). Values SHALL not exceed 100 characters in length.
CONTRIBUTOR_SOURCE_CD DOUBLE N Copy of the Contributor_Source_CD from the Contributor_system Table
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.
CONTR_MODE_CD DOUBLE N A description of the workflow that the contributor system is built for (ex: History, Batch, Real-time, etc).
CONTR_SYS_TYPE_CD DOUBLE N Copy of the Contr_Sys_Type_Cd from the Contributor_system Table
DISPLAY VARCHAR(40) Y Copy of the Display from the Contributor_system Table
DOC_EVENT_CLASS_CD DOUBLE N Copy of the Doc_Event_Class_Cd from the Contributor_system Table
ENHANCED_PROCESSING_CD DOUBLE N Additional processing occurs when this value is set
ESI_LOG_BITMAP DOUBLE N This field defines the interaction between the ESI_LOG and LONG_BLOB tables for messages generated through the ESI Java server.
ESI_ORG_ALIAS_CD DOUBLE N Copy of the Esi_Org_Alias_Cd from the Contributor_system Table
ESI_SPECIAL_SOURCE_FLAG DOUBLE N Copy of Esi_special_source_flag from the contributor_system table
ESO_SPECIAL_SOURCE_FLAG DOUBLE N Copy of Eso_special_source_flag from the contributor_system table
EVENT_CLASS_SOURCE_FLAG DOUBLE N Copy of the Event_Class_Source_Flag from the Contributor_system Table
GROUPER_HOLD_TIME DOUBLE Y Copy of the Grouper_Hold_Time from the Contributor_system Table
GROUPER_MULTI_ORDS_IND DOUBLE Y Copy of the Grouper_Multi_Ords_Ind from the Contributor_system Table
IO_RESULT_IND DOUBLE N Indicates whether the IO results from interface will be post to ce_intake_output_resut table.
LISTENER_ALIAS VARCHAR(48) N The selected listener alias is used for outbound document processing through devices associated to this Contributor System
LOC_FACILITY_CD DOUBLE N Copy of the Loc_Facility_Cd from the Contributor_system Table
MAX_GROUPER_ORDERS DOUBLE Y Copy of the Max_Grouper_Orders from the Contributor_system Table
MESSAGE_FORMAT_CD DOUBLE N Copy of the Message_Format_Cd from the Contributor_system Table 25453
MICRO_LIST_REPLACE_FLAG DOUBLE N Copy of the Micro_List_Replace_Flag from the Contributor_system Table
MICRO_MULTI_INTERP_IND DOUBLE Y Copy of the Micro_Multi_Interp_Ind from the Contributor_system Table
MODIFY_PRSNL_ID DOUBLE N Prsnl ID of the user who made new modification on the Contributor_System table
OPF_MATCH_THRESHOLD CHAR(3) Y Copy of the Opf_Match_Threshold from the Contributor_system Table
OPF_REPORT_THRESHOLD CHAR(3) Y Copy of the Opf_Report_Threshold from the Contributor_system Table
ORGANIZATION_ID DOUBLE N Copy of the Organization_id from the Contributor_system Table
ORG_PRSNL_ID DOUBLE N Prsnl ID of the user who made original modification on the Contributor_System table
PRSNL_PERSON_ID DOUBLE N Copy of the Prsnl_Person_ID from the Contributor_system Table
REC_BEG_EFF_DT_TM DATETIME Y Copy of the Beg_Eff_Dt_TM from the Contributor_system Table
RESULT_ALIAS_IND DOUBLE Y Copy of the Result_Alias_Ind from the Contributor_system Table
SI_CONTRIBUTOR_SYSTEM_HIST_ID DOUBLE N PRIMARY KEY
SYS_DIRECTION_CD DOUBLE N Copy of the Sys_Direction_Cd from the Contributor_system Table
TIME_ZONE VARCHAR(100) Y Copy of the Time_Zone from the Contributor_system Table
TIME_ZONE_FLAG DOUBLE N Copy of the Time_Zone_Flag from the Contributor_system Table
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_CONTRIBUTOR_SYSTEM_HIST


Child Column in SI_CONTRIBUTOR_SYSTEM_HIST(FK) Parent Table Name Parent Column Name
Parents: CONTRIBUTOR_SYSTEM_CD CONTRIBUTOR_SYSTEM CONTRIBUTOR_SYSTEM_CD
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
MODIFY_PRSNL_ID PRSNL PERSON_ID
ORG_PRSNL_ID PRSNL PERSON_ID
PRSNL_PERSON_ID PRSNL PERSON_ID


SI_CUSTOM_CDG_LOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: System Integration Custom CCD document generator Log
Definition: Stores a custom log of requests that CDG server failed to process
Table Type: ACTIVITY





Column Detail - SI_CUSTOM_CDG_LOG


Column Name Type Null? Definition
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.
ENCNTR_ID DOUBLE N Foreign Key To The Encounter Table
ERROR_FLAG_TXT VARCHAR(2) Y REASON/TYPE OF ERROR
ERROR_TEXT VARCHAR(500) Y ERROR TEXT MESSAGE
PERSON_ID DOUBLE N Foreign Key To The Person Table
SI_CUSTOM_CDG_LOG_ID DOUBLE N Primary Key Of The Table
TRIGGER_DT_TM DATETIME Y When the request was triggered for the CCD.
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_CUSTOM_CDG_LOG


Child Column in SI_CUSTOM_CDG_LOG(FK) Parent Table Name Parent Column Name
Parents: CONTRIBUTOR_SYSTEM_CD CONTRIBUTOR_SYSTEM CONTRIBUTOR_SYSTEM_CD
ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID