Table OH

Definition of table: OH - object header

generated: 09.12.2016 10:28:30
by UC2010.accdb

AE Database 12.0 (Step 013)

Name Type Len Attributes Description

OH_Client Integer 2 UC: Null=False client

OH_OType Text 8 UC: Null=False object type

OH_Name Text 200 UC: Null=False object name

OH_Idnr Long Integer 4 UC: Typ=Zähler Null=False primary key of the object header

OH_Title Text 255 UC: Null=True title

OH_CrUserIdnr Long Integer 4 UC: Null=True user who created this object

OH_CrDate Date/Time 8 UC: Null=True date of creation

OH_ModUserIdnr Long Integer 4 UC: Null=True user who modified this object

OH_ModDate Date/Time 8 UC: Null=True date of modification

OH_ModCnt Long Integer 4 UC: Null=True modification counter

OH_LastUserIdnr Long Integer 4 UC: Null=True user who lately used this object

OH_LastDate Date/Time 8 UC: Null=True date of last use

OH_LastCnt Long Integer 4 UC: Null=True usage counter

OH_JPP_Count Integer 2 UC: Null=True number of JPP

OH_Share Text 1 UC: Null=True is this object visible in other client (only for client 0) l=readable R=referenceable

OH_C0Ref Byte 1 UC: Typ=Boolean Null=True flag if this is a reference to client 0

OH_NoStatUpd Byte 1 UC: Null=True extended reports to be written (Header Tab): 0=Default (UC_CLIENT_SETTINGS), 1=All, 2=None

OH_DeleteFlag Byte 1 UC: Null=True delete flag

OH_ExpFlag Byte 1 UC: Null=True export flag

OH_MaxWait Long Integer 4 UC: Null=True number of seconds to wait before execution

OH_MaxParallel2 Integer 2 UC: Null=True maximum number of parallel running jobs

OH_MPElse Integer 2 UC: Null=True bit array for the checkpoint and what should happen if the maximum number is exceeded

OH_Archive1 Text 60 UC: Null=True archive key 1

OH_Archive2 Text 20 UC: Null=True archive keyf 2

OH_OpenUserIdnr Long Integer 4 UC: Null=True opened by user

OH_OpenDate Date/Time 8 UC: Null=True opened by user since ...

OH_MaxRetCode Long Integer 4 UC: Null=True up to this retcode the activity is ENDED_OK

OH_MrtMethod Long Integer 4 UC: Null=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 Long Integer 4 UC: Null=True maximum execution time in seconds (should be OH_MRT)

OH_MrtTime Text 6 UC: Null=True Max. runtime in time ddhhmm

OH_MrtErt Integer 2 UC: Null=True MRT=ERT+xx%

OH_MrtExecute Text 200 UC: Null=True Object start for runtime audit

OH_Frt Long Integer 4 UC: Null=True Fixed runtime in seconds

OH_Ert Long Integer 4 UC: Null=True Estimated runtime in seconds

OH_ErtCnt Integer 2 UC: Null=True last x runs to check

OH_ErtCorr Integer 2 UC: Null=True + xx %

OH_ErtIgn Integer 2 UC: Null=True Ignore > xx% deviation

OH_ErtMinCnt Integer 2 UC: Null=True Minimum runs to check

OH_ErtMethod Long Integer 4 UC: Null=True Method (bitmask) 0=default, 1=fix, 2=avg, 4=max, 8=linearregression 256=Ignore deviation

OH_ErtTrend Long Integer 4 UC: Null=True Trend (bitmask) 0=undefined, 8=constant upward, 4=upward, 2=downward, 1=constant downward

OH_LastRuns Memo 0 UC: Typ=binary L=100 Null=True Last 25 runs in seconds

OH_Srt Long Integer 4 UC: Null=True SRT in Seconds

OH_SrtErt Integer 2 UC: Null=True SRT=ERT+xx%

OH_FcstStatus Long Integer 4 UC: Null=True Default status for forecast (i.e. STOP NOMSG)

OH_UC4Priority Integer 2 UC: Null=True UC4 priority

OH_TZ Text 8 UC: Null=True Timezone for this object and script

OH_MrtTZ Text 8 UC: Null=True Timezone for max. Runtime when a fixed time is used

OH_RefIdnr Long Integer 4 UC: Null=True Version Control: Reference to OH_IDNR of original object if OH_DeleteFlag = 2

OH_OX_ContentLen Long Integer 4 UC: Null=True Length for OX_Content of OX Table

OH_ExtFlag Text 1 UC: Null=True 1=This task is used as an external dependency

OH_OpenSession Long Integer 4 UC: Null=True SessionId of the User Session which set OH_Open Fields

OH_OV_Flag Byte 1 UC: Typ=Boolean Null=True 1=OV is defined, 0=there is no OV

OH_OV_Mode Byte 1 UC: Null=True Mode for heritage of values (0=InheritAll, 1=InheritDefined, 2=InheritNone)

OH_HostFsc Text 200 UC: Null=True Filescan Host

OH_LoginFsc Text 200 UC: Null=True Filescan Login Object

OH_MrcExecute Text 200 UC: Null=True Alarm object for max retcode

OH_PPFInherit Text 1 UC: Null=True OutputScanTarget (N=no children,Y=with children,C=children only)

OH_HostAttrTypeDst Text 8 UC: Null=True Type of the Destination Host.

OH_Queue Text 200 UC: Null=True Name of the Queue the Object runs within

OH_ChildQueue Text 200 UC: Null=True The children are assigned to this Queue

OH_OPU_Flag Byte 1 UC: Typ=Boolean Null=True Object has OPU subtables

OH_OEO_Flag Byte 1 UC: Typ=Boolean Null=True Object has OEOs

OH_ChildFlags Text 32 UC: Null=True Flags for Subtables

OH_IsTemplate Byte 1 UC: Typ=Boolean Null=True Object is a template

OH_Icon Text 8 UC: Null=True object icon

OH_RollbackFlag Byte 1 UC: Typ=Boolean Null=True Rollback is enabled for object

OH_Inactive Byte 1 UC: Typ=Boolean Null=True SLO active/inactive

OH_SubType Text 8 UC: Null=True OType specific SubType

OH_DeactDelay Long Integer 4 UC: Null=True delay in minutes

OH_AutoDeact Text 1 UC: Null=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 Text 30 UC: Null=True ok state for autom. deactivation

OH_AEVersion Text 8 UC: Null=True AE system version

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

Indexes:

Name Fields

NK_OH_DelFlag OH_DeleteFlag, OH_Client, OH_OpenUserIdnr, OH_Idnr

NK_OH_ModDate OH_OType, OH_ModDate

NK_OH_MrtExecute OH_MrtExecute, OH_Client

NK_OH_OpenSess OH_OpenSession

NK_OH_OType OH_Client, OH_OType, OH_Name, OH_Idnr

NK_OH_RefIdnr OH_RefIdnr, OH_ModCnt, OH_Idnr

NK_OH_Reorg OH_Client, OH_DeleteFlag, OH_ModDate, OH_RefIdnr, OH_Idnr

NK_OH_Search OH_Client, OH_DeleteFlag, OH_OType, OH_Name, OH_Idnr

NK_OH_Search2 OH_Client, OH_Name

PK_OH OH_Idnr

UK_OH_Name OH_Name, OH_Client

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

Return to the Index File