Table Detail Report

OEN_INTERFACE_TRAITS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Contains traits for interface
Definition: OEN interface traits
Table Type: REFERENCE





Column Detail - OEN_INTERFACE_TRAITS


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
INTERFACE_ID DOUBLE N interface idColumn
NAME VARCHAR(32) N Name of the trait
SEQUENCE_NBR DOUBLE N This column determine which version interface trait is it?
TRAIT_ID DOUBLE N Id of the trait.
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.
VALUE_IND DOUBLE Y If trait is Boolean type then 0 represents FALSE and 1 represents TRUE.
VALUE_INT DOUBLE Y If trait is integer type, then this field indicates trait's integer value.
VALUE_TEXT VARCHAR(255) Y if trait is of type text, then this field is filled with the trait value.
VERSION_NBR DOUBLE N Version of the trait.



Relationship Detail - OEN_INTERFACE_TRAITS


Child Column in OEN_INTERFACE_TRAITS(FK) Parent Table Name Parent Column Name
Parents: INTERFACE_ID OEN_INTERFACE INTERFACE_ID


OEN_PERSONALITY



Column Section Top of Page


Table-level Detail

Description: open engine interface personality traits
Definition: This table stores the personality traits for the open engine interface.
Table Type: REFERENCE





Column Detail - OEN_PERSONALITY


Column Name Type Null? Definition
DEF_ASYNC_IN DOUBLE Y This column is for future use.
DEF_ASYNC_OUT DOUBLE Y This column is for future use.
DEF_DISK_IN DOUBLE Y This column is for future use.
DEF_DISK_OUT DOUBLE Y This column is for future use.
DEF_GENERAL DOUBLE Y This column is for future use.
DEF_TCPIP_IN DOUBLE Y This column is for future use.
DEF_TCPIP_OUT DOUBLE Y This column is for future use.
HANDLED_BY_GUI DOUBLE N This is the flag which determines if the trait could be handled by GUI or not.
INTERFACEID DOUBLE N This is the ID of the interface.
NAME CHAR(32) Y This column represents the trait name.
PERSONALITY_KEY CHAR(40) N This column represents the personality key which is the combination of interfaceid and trait name.
VALUE VARCHAR(500) Y This column represents the trait value.


OEN_PROCINFO



Column Section Top of Page


Table-level Detail

Description: open engine interface info
Definition: This table contains the information for the open engine interfaces.
Table Type: REFERENCE





Column Detail - OEN_PROCINFO


Column Name Type Null? Definition
CONTROLLABLE DOUBLE Y Future
CURRENT_NODE VARCHAR(15) Y Node on which the comserver is currently set to run
INTERFACEID DOUBLE N Unique identifier for interface. Not popped from a sequence. Incrementing number but if there are gaps, those numbers are used.
PRIMARY_NODE VARCHAR(15) Y Node on which the comserver should run under normal conditions.
PRIMARY_SCP_EID DOUBLE Y SCP entry ID of the comserver on the primary node
PROC_DESC VARCHAR(80) Y Description of the interface
PROC_NAME CHAR(32) N Unique interface name
QUERYABLE DOUBLE Y Future:
SCP_EID DOUBLE N Unique scp id for the interface
SERVICE CHAR(10) N Service provided by the interface
STD_INTERFACEID DOUBLE N STD_INTERFACEID
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 CHAR(10) Y The date interface was created or updated.
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.
UPDT_TM CHAR(8) Y The time interface was created or updated.
USER_NAME CHAR(15) Y The user who created or last updated the interface.


OEN_PRUNEJOB_LOG



Column Section Top of Page


Table-level Detail

Description: Open Engine prune job log
Definition: This table keeps the log of the prune job run to delete data from TXLOG, TELOG and CQM_OEN.. tables.
Table Type: ACTIVITY





Column Detail - OEN_PRUNEJOB_LOG


Column Name Type Null? Definition
CQM_BEG_DT_TM DATETIME Y CQM purge begin data time
CQM_DAYS_KEPT DOUBLE Y CQM days kept
CQM_END_DT_TM DATETIME Y CQM prune job end date time
CQM_TXLOG_DEL_CNT DOUBLE Y Number of records deleted from cqm_txlog_que. Used for SIT tool.Column
PRUNE_ID DOUBLE N Prune Id
QUE_DEL_CNT DOUBLE Y Queue delete count
TELOG_DEL_CNT DOUBLE Y TELOG delete count
TR_1_DEL_CNT DOUBLE Y TR_1 delete count
TXLOG_BEG_DT_TM DATETIME Y TXLOG begin time
TXLOG_DAYS_KEPT DOUBLE Y TXLOG days kept
TXLOG_DEL_CNT DOUBLE Y TXLOG delete count
TXLOG_END_DT_TM DATETIME Y TXLOG end time


OEN_PUBLICATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Based on what characteristics tx is going to be available for routing(published)
Definition: OEN publication.
Table Type: REFERENCE





Column Detail - OEN_PUBLICATION


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
CUSTOM_ELEMENT_NAME VARCHAR(32) Y If published as custom then name of the custom element. if we are publishing based on patient name then patient name could be custom element name.
CUSTOM_SCRIPT_ID DOUBLE N Link to the oen_script table
FUNCTION_PARAMS_VALUE VARCHAR(255) Y Holds the parameters into the function
LOAD_BALANCE_IND DOUBLE Y Is this publication used for load balancing
PUBLICATION_DESC VARCHAR(255) Y Text descriptionColumn
PUBLICATION_ID DOUBLE N Unique identifier of the publication.
PUBLICATION_TYPE_FLAG DOUBLE Y Based on what publication is available.
PUBLISH_FUNCTION_FLAG DOUBLE Y What function is being used.
READ_ONLY_IND DOUBLE Y Is this publication read_only?Column
SOURCE_OBJECT VARCHAR(32) Y If publishing based on Object then source object name e.g. OEOCF
SOURCE_OBJECT_ELEMENT VARCHAR(255) Y source object elementColumn
TRANSACTION_FLAG DOUBLE Y Used for custom elements
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 - OEN_PUBLICATION




Parent Column in OEN_PUBLICATION (PK) Child Table Name Child Column Name
Children: PUBLICATION_ID OEN_EXPRESSION PUBLICATION_ID
OEN_PUBLISHER_PUB_R PUBLICATION_ID