Table Detail Report

OEN_EXPRESSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Holds route expressions
Definition: oen_expression
Table Type: REFERENCE





Column Detail - OEN_EXPRESSION


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.
GROUP_LEVEL DOUBLE Y What level is this expression at
GROUP_NBR DOUBLE Y What group number does this expression belong to
PUBLICATION_ID DOUBLE N Reference to the publication
QUALIFIER_FLAG DOUBLE Y Used for qualifications
RELATION_OPERATOR_FLAG DOUBLE Y used to relate items to each other
RULE_ID DOUBLE N unique rule_id
SEQUENCE_NBR DOUBLE N sequence_nbrColumn
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_TEXT VARCHAR(255) Y value to check against



Relationship Detail - OEN_EXPRESSION


Child Column in OEN_EXPRESSION(FK) Parent Table Name Parent Column Name
Parents: PUBLICATION_ID OEN_PUBLICATION PUBLICATION_ID


OEN_EXPRESSION_STR



Column Section Top of Page


Table-level Detail

Description: Holds the Routing Expression, which CCL will evaluate.
Definition: Routing Expression.
Table Type: REFERENCE





Column Detail - OEN_EXPRESSION_STR


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.
EXPRESSION_STRING VARCHAR(1000) Y Holds the Routing data to be parsed by CCL.Column
RULE_ID DOUBLE N unique rule_id.
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.


OEN_INTERFACE



Column Section Relationship Section Top of Page


Table-level Detail

Description: OEN Interface
Definition: List of all OEN interfaces.
Table Type: REFERENCE





Column Detail - OEN_INTERFACE


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.
DOMAIN_FLAG DOUBLE Y 0 = common 1 = OE 2 = MDI
FORMAT_FLAG DOUBLE Y Not yet defined
INTERFACE_ID DOUBLE N This is unique identifier for the interface
PARENT_IND DOUBLE Y Future use.
PARENT_INTERFACE_ID DOUBLE N future
PRODUCTION_IND DOUBLE N This column indicated if interface is in production or not.
READ_ONLY_IND DOUBLE Y Is the interface read_only.
SCP_EID DOUBLE N SCP id for the interface
SERVICE_FLAG DOUBLE N Indicates the service of the interface
SERVICE_RESOURCE_CD DOUBLE N Internal identifier for service resource
SYSTEM_INTERFACE_ID DOUBLE N system interface id.
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.
VERSION_NBR DOUBLE N Latest version of the interface.



Relationship Detail - OEN_INTERFACE




Parent Column in OEN_INTERFACE (PK) Child Table Name Child Column Name
Children: INTERFACE_ID OEN_INTERFACE_ERR_R INTERFACE_ID
OEN_INTERFACE_SCR_R INTERFACE_ID
OEN_INTERFACE_TRAITS INTERFACE_ID
OEN_PUBLISHER_PUB_R INTERFACE_ID
OEN_SUBSCRIBER_RULE_R INTERFACE_ID


OEN_INTERFACE_ERR_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: OEN INTERFACE ERR R
Definition: Relates the interface to an error.
Table Type: REFERENCE





Column Detail - OEN_INTERFACE_ERR_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.
ENHANCED_IND DOUBLE Y Use enhanced error logic?
ERROR_ID DOUBLE N error_idColumn
ERROR_SEQ_ID DOUBLE N unique id
INTERFACE_ID DOUBLE N interface_idColumn
MAX_RETRY_NBR DOUBLE Y Maximum number of retries
SEQUENCE_ID DOUBLE N Sequence_id
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_INTERFACE_ERR_R


Child Column in OEN_INTERFACE_ERR_R(FK) Parent Table Name Parent Column Name
Parents: ERROR_ID OEN_ERROR ERROR_ID
INTERFACE_ID OEN_INTERFACE INTERFACE_ID
SEQUENCE_ID OEN_SEQUENCE SEQUENCE_ID


OEN_INTERFACE_SCR_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Lists which interface uses which scripts.
Definition: oen interface script relationship
Table Type: REFERENCE





Column Detail - OEN_INTERFACE_SCR_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.
CONTEXT_FLAG DOUBLE Y This lists the type of script that is being used.
INTERFACE_ID DOUBLE N Interface id. This is foreign key from oen_interface table.
SCRIPT_ID DOUBLE N Script id. This is foreign key from oen_script_list 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.
VERSION_NBR DOUBLE N The Version changes when the script is check into/outof production.Column



Relationship Detail - OEN_INTERFACE_SCR_R


Child Column in OEN_INTERFACE_SCR_R(FK) Parent Table Name Parent Column Name
Parents: INTERFACE_ID OEN_INTERFACE INTERFACE_ID
SCRIPT_ID OEN_SCRIPT_LIST SCRIPT_ID