Name Type MSSql Type Oracle Type DB2 Nullable Description
OH_Client smallint NUMBER(38,0) smallint false client
OH_OType varchar (8) VARCHAR2 (8 CHAR) varchar(8) false object type
OH_Name varchar (200) VARCHAR2 (200 CHAR) varchar(200) false object name
OH_Idnr int NUMBER(38,0) int false primary key of the object header
OH_Title varchar (255) VARCHAR2 (255 CHAR) varchar(255) true title
OH_CrUserIdnr int NUMBER(38,0) int true user who created this object
OH_CrDate datetime DATE timestamp true date of creation
OH_ModUserIdnr int NUMBER(38,0) int true user who modified this object
OH_ModDate datetime DATE timestamp true date of modification
OH_ModCnt int NUMBER(38,0) int true modification counter
OH_LastUserIdnr int NUMBER(38,0) int true user who lately used this object
OH_LastDate datetime DATE timestamp true date of last use
OH_LastCnt int NUMBER(38,0) int true usage counter
OH_JPP_Count smallint NUMBER(38,0) smallint true number of JPP
OH_Share char (1) CHAR (1 CHAR) char(1) true is this object visible in other client (only for client 0) l=readable R=referenceable
OH_C0Ref smallint NUMBER(38,0) smallint true flag if this is a reference to client 0
OH_NoStatUpd smallint NUMBER(38,0) smallint true extended reports to be written (Header Tab): 0=Default (UC_CLIENT_SETTINGS), 1=All, 2=None
OH_DeleteFlag smallint NUMBER(38,0) smallint true delete flag
OH_ExpFlag smallint NUMBER(38,0) smallint true export flag
OH_MaxWait int NUMBER(38,0) int true number of seconds to wait before execution
OH_MaxParallel2 smallint NUMBER(38,0) smallint true maximum number of parallel running jobs
OH_MPElse smallint NUMBER(38,0) smallint true bit array for the checkpoint and what should happen if the maximum number is exceeded
OH_Archive1 varchar (60) VARCHAR2 (60 CHAR) varchar(60) true archive key 1
OH_Archive2 varchar (20) VARCHAR2 (20 CHAR) varchar(20) true archive keyf 2
OH_OpenUserIdnr int NUMBER(38,0) int true opened by user
OH_OpenDate datetime DATE timestamp true opened by user since ...
OH_MaxRetCode int NUMBER(38,0) int true up to this retcode the activity is ENDED_OK
OH_MrtMethod int NUMBER(38,0) int true Method f.max. Runtime (bitmask) 0=no audit, 1=fix in seconds, 2=fix time, 4=ERT+xx%, 256=Cancel, 512=Start Object 65536=SRT in seconds, 131072=SRT ERT+xx%
OH_Mrt int NUMBER(38,0) int true maximum execution time in seconds (should be OH_MRT)
OH_MrtTime char (6) CHAR (6 CHAR) char(6) true Max. runtime in time ddhhmm
OH_MrtErt smallint NUMBER(38,0) smallint true MRT=ERT+xx%
OH_MrtExecute varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Object start for runtime audit
OH_Frt int NUMBER(38,0) int true Fixed runtime in seconds
OH_Ert int NUMBER(38,0) int true Estimated runtime in seconds
OH_ErtCnt smallint NUMBER(38,0) smallint true last x runs to check
OH_ErtCorr smallint NUMBER(38,0) smallint true + xx %
OH_ErtIgn smallint NUMBER(38,0) smallint true Ignore > xx% deviation
OH_ErtMinCnt smallint NUMBER(38,0) smallint true Minimum runs to check
OH_ErtMethod int NUMBER(38,0) int true Method (bitmask) 0=default, 1=fix, 2=avg, 4=max, 8=linearregression 256=Ignore deviation
OH_ErtTrend int NUMBER(38,0) int true Trend (bitmask) 0=undefined, 8=constant upward, 4=upward, 2=downward, 1=constant downward
OH_LastRuns varbinary(100) RAW(100) varchar(100) for bit data true Last 25 runs in seconds
OH_Srt int NUMBER(38,0) int true SRT in Seconds
OH_SrtErt smallint NUMBER(38,0) smallint true SRT=ERT+xx%
OH_FcstStatus int NUMBER(38,0) int true Default status for forecast (i.e. STOP NOMSG)
OH_UC4Priority smallint NUMBER(38,0) smallint true UC4 priority
OH_TZ varchar (8) VARCHAR2 (8 CHAR) varchar(8) true Timezone for this object and script
OH_MrtTZ varchar (8) VARCHAR2 (8 CHAR) varchar(8) true Timezone for max. Runtime when a fixed time is used
OH_RefIdnr int NUMBER(38,0) int true Version Control: Reference to OH_IDNR of original object if OH_DeleteFlag = 2
OH_OX_ContentLen int NUMBER(38,0) int true Length for OX_Content of OX Table
OH_ExtFlag char (1) CHAR (1 CHAR) char(1) true 1=This task is used as an external dependency
OH_OpenSession int NUMBER(38,0) int true SessionId of the User Session which set OH_Open Fields
OH_OV_Flag smallint NUMBER(38,0) smallint true 1=OV is defined, 0=there is no OV
OH_OV_Mode smallint NUMBER(38,0) smallint true Mode for heritage of values (0=InheritAll, 1=InheritDefined, 2=InheritNone)
OH_HostFsc varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Filescan Host
OH_LoginFsc varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Filescan Login Object
OH_MrcExecute varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Alarm object for max retcode
OH_PPFInherit char (1) CHAR (1 CHAR) char(1) true OutputScanTarget (N=no children,Y=with children,C=children only)
OH_HostAttrTypeDst varchar (8) VARCHAR2 (8 CHAR) varchar(8) true Type of the Destination Host.
OH_Queue varchar (200) VARCHAR2 (200 CHAR) varchar(200) true Name of the Queue the Object runs within
OH_ChildQueue varchar (200) VARCHAR2 (200 CHAR) varchar(200) true The children are assigned to this Queue
OH_OPU_Flag smallint NUMBER(38,0) smallint true Object has OPU subtables
OH_OEO_Flag smallint NUMBER(38,0) smallint true Object has OEOs
OH_ChildFlags char (32) CHAR (32 CHAR) char(32) true Flags for Subtables
OH_IsTemplate smallint NUMBER(38,0) smallint true Object is a template
OH_Icon varchar (8) VARCHAR2 (8 CHAR) varchar(8) true object icon
OH_RollbackFlag smallint NUMBER(38,0) smallint true Rollback is enabled for object
OH_Inactive smallint NUMBER(38,0) smallint true SLO active/inactive
OH_SubType varchar (8) VARCHAR2 (8 CHAR) varchar(8) true OType specific SubType
OH_DeactDelay int NUMBER(38,0) int true delay in minutes
OH_AutoDeact char (1) CHAR (1 CHAR) char(1) true deactivate autom. when finished: J/N/A/F J=during first error-free program run, A=always, N=no, F=when errorfree
OH_DeactWhen varchar (30) VARCHAR2 (30 CHAR) varchar(30) true ok state for autom. deactivation
OH_AEVersion varchar (8) VARCHAR2 (8 CHAR) varchar(8) true AE system version

Indexes:

Name Fields Primary Unique Clustered Nonclustered
NK_OH_DelFlag OH_DeleteFlag, OH_Client, OH_OpenUserIdnr, OH_Idnr false false false false
NK_OH_ModDate OH_OType, OH_ModDate false false false false
NK_OH_MrtExecute OH_MrtExecute, OH_Client false false false false
NK_OH_OpenSess OH_OpenSession false false false false
NK_OH_OType OH_Client, OH_OType, OH_Name, OH_Idnr false false false false
NK_OH_RefIdnr OH_RefIdnr, OH_ModCnt, OH_Idnr false false false false
NK_OH_Reorg OH_Client, OH_DeleteFlag, OH_ModDate, OH_RefIdnr, OH_Idnr false false false false
NK_OH_Search OH_Client, OH_DeleteFlag, OH_OType, OH_Name, OH_Idnr false false false false
NK_OH_Search2 OH_Client, OH_Name false false false false
PK_OH OH_Idnr true true true false
UK_OH_Name OH_Name, OH_Client false true false false

Foreign Keys:

Name Local References Foreign References

Return to the Index File