Table Detail Report
OEN_STD_PROCINFO
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Open Engine Std Proc Info |
Definition: | The table contains all standard interfaces |
Table Type: | REFERENCE |
Column Detail - OEN_STD_PROCINFO
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. |
SERVICE_TYPE_CD | DOUBLE | N | Service type code. Defines what type of service the interface. |
STD_INTERFACE_ID | DOUBLE | N | Interface Id. Identifier for the interface. Generated from the script. No sequence used. |
STD_INTERFACE_NAME | VARCHAR(40) | N | Name of the interface. |
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_STD_PROCINFO
Parent Column in OEN_STD_PROCINFO (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | STD_INTERFACE_ID | OEN_STD_PROCINFO_TRAITS | STD_INTERFACE_ID |
OEN_STD_PROCINFO_TRAITS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | OEN Std Procinfo Traits |
Definition: | This table contains all standard interface traits. |
Table Type: | REFERENCE |
Column Detail - OEN_STD_PROCINFO_TRAITS
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. |
INTERFACE_TRAITS_ID | DOUBLE | N | Interface Traits Id. Identifier for the interface trait. |
STD_INTERFACE_ID | DOUBLE | N | Interface Id. Identifier for the interface. FK from table OEN_STD_PROCINFO |
TRAIT_NAME | VARCHAR(32) | N | Name of the trait.Column |
TRAIT_VALUE | VARCHAR(80) | N | Value of the trait.Column |
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_STD_PROCINFO_TRAITS
Child Column in OEN_STD_PROCINFO_TRAITS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | STD_INTERFACE_ID | OEN_STD_PROCINFO | STD_INTERFACE_ID |
OEN_STEP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | OEN STEP |
Definition: | Holds list of all valid Open Engine STEPS. |
Table Type: | REFERENCE |
Column Detail - OEN_STEP
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. |
STEP_DESC | VARCHAR(255) | Y | Holds a description of this Step.Column |
STEP_ID | DOUBLE | N | Holds a unique number representing this Step.Column |
STEP_VALUE | VARCHAR(30) | Y | Holds a single letter representing this Step.Column |
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_STEP
Parent Column in OEN_STEP (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | STEP_ID | OEN_ERROR | STEP_ID |
OEN_SEQ_STEP_R | STEP_ID |
OEN_SUBSCRIBER_RULE_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | OEN SUBSCRIBER RULE R |
Definition: | Holds relation between subscriber and rule. |
Table Type: | REFERENCE |
Column Detail - OEN_SUBSCRIBER_RULE_R
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 | link to interface table. |
RULE_ID | DOUBLE | N | link to rule table |
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_SUBSCRIBER_RULE_R
Child Column in OEN_SUBSCRIBER_RULE_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | INTERFACE_ID | OEN_INTERFACE | INTERFACE_ID |
OEN_TELOG
Column Section | Top of Page |
Table-level Detail
Description: | Transaction event log |
Definition: | Transaction message activity through the open engine. |
Table Type: | ACTIVITY |
Column Detail - OEN_TELOG
Column Name | Type | Null? | Definition |
---|---|---|---|
CREATE_DT_TM | DATETIME | Y | The date and time the row was insertedColumn |
EID | DOUBLE | N | if event is from inbound or outbound interface |
ESTATUS | CHAR(1) | Y | Flag which states success or Failure |
EVENT_DATE | CHAR(10) | Y | Date the event logged. |
EVENT_KEY | CHAR(25) | N | Unique identifier consist of tx id and time. |
EVENT_TIME | CHAR(8) | Y | Time the event was logged. |
OPID | DOUBLE | N | The inbound interface, the tx came from. |
OTID | CHAR(15) | Y | original tx id. |
PID | DOUBLE | N | Interface id logging the event. |
TID | CHAR(15) | N | tx id for the current interface |