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