Table Detail Report
OEN_SEQ_STEP_R
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | OEN SEQ STEP R |
| Definition: | Relation between the OEN_SEQUENCE and OEN_STEP tables. |
| Table Type: | REFERENCE |
Column Detail - OEN_SEQ_STEP_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. |
| ORDER_NBR | DOUBLE | N | The ordering of the steps.Column |
| SEQUENCE_ID | DOUBLE | N | Sequence ID from OEN_SEQUENCE table.Column |
| STEP_ID | DOUBLE | N | Step ID from OEN_STEP table.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_SEQ_STEP_R
| Child Column in OEN_SEQ_STEP_R(FK) | Parent Table Name | Parent Column Name | |
|---|---|---|---|
| Parents: | SEQUENCE_ID | OEN_SEQUENCE | SEQUENCE_ID |
| STEP_ID | OEN_STEP | STEP_ID |
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 |