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 |