Table Detail Report
OEN_PUBLISHER_PUB_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Publisher publication relationship |
Definition: | publisher publication relationship |
Table Type: | REFERENCE |
Column Detail - OEN_PUBLISHER_PUB_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 | interface idColumn |
PUBLICATION_ID | DOUBLE | N | Publication 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_PUBLISHER_PUB_R
Child Column in OEN_PUBLISHER_PUB_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | INTERFACE_ID | OEN_INTERFACE | INTERFACE_ID |
PUBLICATION_ID | OEN_PUBLICATION | PUBLICATION_ID |
OEN_ROLLBACK
Column Section | Top of Page |
Table-level Detail
Description: | Open engine rollback |
Definition: | the tx is put in this table before being replayed. |
Table Type: | ACTIVITY |
Column Detail - OEN_ROLLBACK
Column Name | Type | Null? | Definition |
---|---|---|---|
PID | DOUBLE | N | Interface id |
TX_KEY | CHAR(27) | N | Unique identifier of the Tx |
OEN_ROUTE_RULE
Column Section | Top of Page |
Table-level Detail
Description: | Holds route rules |
Definition: | Holds route rules Table |
Table Type: | REFERENCE |
Column Detail - OEN_ROUTE_RULE
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. |
PUBLISHER_ID | DOUBLE | N | interface who is publishing this rule |
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_SCRIPT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | open engine script |
Definition: | open engine script Table |
Table Type: | REFERENCE |
Column Detail - OEN_SCRIPT
Column Name | Type | Null? | Definition |
---|---|---|---|
BUILD_DATE | CHAR(10) | Y | Future: Date when script was compiled |
BUILD_TIME | CHAR(8) | Y | Future: the time the script was compiled. |
NOT_EXECUTABLE | DOUBLE | Y | A flag which determines if script is executable by user or not. |
READ_ONLY | DOUBLE | Y | A flag which determines if a script is read only or not. |
SCRIPT_BODY | LONGTEXT | Y | Actual script body |
SCRIPT_DESC | VARCHAR(80) | Y | script descriptionColumn |
SCRIPT_LANGUAGE | VARCHAR(20) | Y | The scripting language that the script was written in. An empty/null value indicates the scripting language is CCL for passivity. |
SCRIPT_NAME | CHAR(32) | N | Script name - Unique identifier |
SCRIPT_REFCNT | DOUBLE | Y | Passed to a user to determine if some one else has not updated a script before him/her. |
SCRIPT_TYPE | CHAR(20) | Y | script typeColumn |
UPDT_DATE | CHAR(10) | Y | A date when script was created or last 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_TIME | CHAR(8) | Y | A time when script was created or last updated. |
USER_NAME | CHAR(32) | Y | User name who created or updated the script. |
Relationship Detail - OEN_SCRIPT
Parent Column in OEN_SCRIPT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SCRIPT_NAME | OEN_SCRIPT_HIST | SCRIPT_NAME |
OEN_SCRIPT_BODY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Script body. Stores the actual script content in each line in separate row. |
Definition: | script body |
Table Type: | REFERENCE |
Column Detail - OEN_SCRIPT_BODY
Column Name | Type | Null? | Definition |
---|---|---|---|
LINE_NBR | DOUBLE | N | Line number of the script. The script is broken up into multiple lines. This is the ordering of the lines. |
SCRIPT_ID | DOUBLE | N | Script ID from OEN_SCRIPT_LIST. |
SCRIPT_LINE | VARCHAR(255) | Y | Actual content of the script line. |
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 | Version number of the script. When a script is check into/outof production, this number in incremented. |
Relationship Detail - OEN_SCRIPT_BODY
Child Column in OEN_SCRIPT_BODY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SCRIPT_ID | OEN_SCRIPT_LIST | SCRIPT_ID |