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 |