Table Detail Report
OEN_SCRIPT_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | OEN SCRIPT HISTORY |
Definition: | History table for holding oen_script row revisions |
Table Type: | REFERENCE |
Column Detail - OEN_SCRIPT_HIST
Column Name | Type | Null? | Definition |
---|---|---|---|
BUILD_DT_TM | DATETIME | Y | Date time with seconds precision for when the script was built in the domain |
NOT_EXECUTABLE_IND | DOUBLE | Y | An Indicator which determines if script is executable by user or not. |
OEN_SCRIPT_HIST_ID | DOUBLE | N | PRIMARY KEY - A unique generated number that identifies a unique row |
READ_ONLY_IND | DOUBLE | Y | AN Indicator which determines if a script is read only or not. |
SCRIPT_DESC | VARCHAR(80) | Y | Description of the script version |
SCRIPT_NAME | CHAR(32) | N | Script name of the unique parent row in oen_script table |
SCRIPT_REFCNT | DOUBLE | N | Historical revision count of the script |
SCRIPT_TYPE | VARCHAR(20) | Y | Type of the script (need examples) |
UPDT_APPLCTX | DOUBLE | Y | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | Y | 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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | Y | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | Y | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
USER_NAME | VARCHAR(32) | Y | User name of the user who created the revision |
Relationship Detail - OEN_SCRIPT_HIST
Child Column in OEN_SCRIPT_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SCRIPT_NAME | OEN_SCRIPT | SCRIPT_NAME |
Parent Column in OEN_SCRIPT_HIST (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | OEN_SCRIPT_HIST_ID | OEN_SCRIPT_HIST_CLOB | OEN_SCRIPT_HIST_ID |
OEN_SCRIPT_HIST_CLOB
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | OEN SCRIPT HISTORY - CLOB Fields. |
Definition: | History table for holding oen_script row revisions. This table contains the CLOB fields that save SCRIPT BODY and CHANGE LOG data. (1 row for each type of content) |
Table Type: | REFERENCE |
Column Detail - OEN_SCRIPT_HIST_CLOB
Column Name | Type | Null? | Definition |
---|---|---|---|
OEN_SCRIPT_HIST_CLOB_ID | DOUBLE | N | PRIMARY KEY |
OEN_SCRIPT_HIST_ID | DOUBLE | N | OEN SCRIPT HIST ID - Unique key value for a row in the OEN_SCRIPT_HIST Table |
SCRIPT_CLOB | LONGTEXT | Y | A large character field which can contain either the script body, or the Revision Change Log data. A separate text flag column identifies the type. |
SCRIPT_CLOB_CONTENT_TYPE_TFLG | VARCHAR(20) | N | script CLOB content type text flag. Can be either SCRIPT BODY or CHANGE LOG. |
UPDT_APPLCTX | DOUBLE | Y | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | Y | 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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | Y | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | Y | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | Y | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - OEN_SCRIPT_HIST_CLOB
Child Column in OEN_SCRIPT_HIST_CLOB(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | OEN_SCRIPT_HIST_ID | OEN_SCRIPT_HIST | OEN_SCRIPT_HIST_ID |
OEN_SCRIPT_LIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Holds all Open Engine scripts. |
Definition: | script list |
Table Type: | REFERENCE |
Column Detail - OEN_SCRIPT_LIST
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. |
BUILD_DT_TM | DATETIME | Y | Time stamp of script compile/build/include. |
BUILD_VERSION_NBR | DOUBLE | Y | Incremented when a build of the script is done.Column |
EXECUTABLE_IND | DOUBLE | N | Indicates if script can be compiled/included |
PREV_BUILD_VERSION_NBR | DOUBLE | Y | Version number of the previous build on the script.Column |
PRODUCTION_IND | DOUBLE | Y | Indicates if script is being used in production |
READ_ONLY_IND | DOUBLE | N | Indicator to allow script only as read privileged. |
SCRIPT_DESC | VARCHAR(80) | Y | Description of the script. |
SCRIPT_ID | DOUBLE | N | Script ID |
SCRIPT_NAME | VARCHAR(32) | N | Name of the Script. |
SCRIPT_TYPE | DOUBLE | N | The type of Script: ModOrig-Inbound MaptoLib ModObj-Inbound ModObj-Outbound MapfrLib ModOrig-Outbound Type Ack Route CCLOpen CCLRead CCLSend CCLReset CCLClose AddSeqNbr CustomStartup CheckStartup GenerateStartup MaptoUI MapfrUI MapUItoUI RemoteAck Generic |
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 | Y | Version number of the script. Updated when the script is check into/outof production. |
Relationship Detail - OEN_SCRIPT_LIST
Parent Column in OEN_SCRIPT_LIST (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SCRIPT_ID | OEN_INTERFACE_SCR_R | SCRIPT_ID |
OEN_SCRIPT_BODY | SCRIPT_ID |
OEN_SEQUENCE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | OEN SEQUENCE |
Definition: | Holds the possible sequences of steps. |
Table Type: | REFERENCE |
Column Detail - OEN_SEQUENCE
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_IND | DOUBLE | Y | Was this sequence built custom on site? |
PROTOCOL_FLAG | DOUBLE | Y | Which protocol does this sequence apply to. |
SEQUENCE_DESC | VARCHAR(255) | Y | Text description |
SEQUENCE_ID | DOUBLE | N | Unique sequence_id |
SERVICE_FLAG | DOUBLE | Y | What service does this sequence apply to. |
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. |
USAGE_FLAG | DOUBLE | N | Determines if used as error sequence or step sequence |
Relationship Detail - OEN_SEQUENCE
Parent Column in OEN_SEQUENCE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SEQUENCE_ID | OEN_ERROR_SEQ_R | SEQUENCE_ID |
OEN_INTERFACE_ERR_R | SEQUENCE_ID | ||
OEN_SEQ_STEP_R | SEQUENCE_ID |
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 |