Table Detail Report
OEN_PUBLICATION
| Column Section | Relationship Section | Top of Page |
Table-level Detail
| Description: | Based on what characteristics tx is going to be available for routing(published) |
| Definition: | OEN publication. |
| Table Type: | REFERENCE |
Column Detail - OEN_PUBLICATION
| 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. |
| CUSTOM_ELEMENT_NAME | VARCHAR(32) | Y | If published as custom then name of the custom element. if we are publishing based on patient name then patient name could be custom element name. |
| CUSTOM_SCRIPT_ID | DOUBLE | N | Link to the oen_script table |
| FUNCTION_PARAMS_VALUE | VARCHAR(255) | Y | Holds the parameters into the function |
| LOAD_BALANCE_IND | DOUBLE | Y | Is this publication used for load balancing |
| PUBLICATION_DESC | VARCHAR(255) | Y | Text descriptionColumn |
| PUBLICATION_ID | DOUBLE | N | Unique identifier of the publication. |
| PUBLICATION_TYPE_FLAG | DOUBLE | Y | Based on what publication is available. |
| PUBLISH_FUNCTION_FLAG | DOUBLE | Y | What function is being used. |
| READ_ONLY_IND | DOUBLE | Y | Is this publication read_only?Column |
| SOURCE_OBJECT | VARCHAR(32) | Y | If publishing based on Object then source object name e.g. OEOCF |
| SOURCE_OBJECT_ELEMENT | VARCHAR(255) | Y | source object elementColumn |
| TRANSACTION_FLAG | DOUBLE | Y | Used for custom elements |
| 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_PUBLICATION
| Parent Column in OEN_PUBLICATION (PK) | Child Table Name | Child Column Name | |
|---|---|---|---|
| Children: | PUBLICATION_ID | OEN_EXPRESSION | PUBLICATION_ID |
| OEN_PUBLISHER_PUB_R | PUBLICATION_ID |
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 |