Definition of table: EH - executive header

generated: 12.12.2016 18:33:20
by UC2010.accdb

AE Database 11.2 (Step 018)



Name Type Len Attributes Description
EH_Client Integer 2 UC: Null=False client
EH_OType Text 8 UC: Null=False type of the activity
EH_USR_Idnr Long Integer 4 UC: Null=True executing user
EH_OH_Idnr Long Integer 4 UC: Null=False reference to the object header (OH)
EH_Name Text 200 UC: Null=True name of the object
EH_AH_Idnr Long Integer 4 UC: Null=False reference to the archive header (AH), Primary Key
EH_ParentAct Long Integer 4 UC: Null=True AH_Idnr of activator parent
EH_ParentPrc Long Integer 4 UC: Null=True AH_Idnr of processor parent
EH_EJPP_Lnr Integer 2 UC: Null=True reference to the process line in parent jobplan
EH_StartTime Date/Time 8 UC: Null=True job starttime
EH_Status Long Integer 4 UC: Null=True job state
EH_HostDst Text 200 UC: Null=True host name
EH_LoginDst Text 200 UC: Null=True name of login object
EH_CodeNameDst Text 200 UC: Null=True code table for FT
EH_FileNameDst Text 255 UC: Null=True L=512 filename for FT
EH_HostSrc Text 200 UC: Null=True host name (sender)
EH_LoginSrc Text 200 UC: Null=True name of login object
EH_CodeNameSrc Text 200 UC: Null=True code table (sender)
EH_FileNameSrc Text 255 UC: Null=True L=512 filename for FT (sender); EMail notification: Attached File
EH_FileType Text 1 UC: Null=True text, binary ...
EH_Ov Text 1 UC: Null=True overwrite
EH_StartType Text 200 UC: Null=True starttype
EH_MaxCpu Long Integer 4 UC: Null=True max. CPU time
EH_Message Memo 0 UC: L=256 Null=True actual script line in progress
EH_Priority Text 5 UC: Null=True . priority
EH_Express Integer 2 UC: Null=True . express
EH_Output Text 8 UC: Null=True . destination of the job reports QueueM: destination of the job reports
EH_JobClass Text 8 UC: Null=True . job class
EH_Rest Memo 0 UC: L=1024 Null=True . additional attributes
EH_ProcessId Text 10 UC: Null=True TSN / process id
EH_CpuTime Long Integer 4 UC: Null=True used CPU time
EH_KernelTime Long Integer 4 UC: Null=True used kernel time
EH_UserTime Long Integer 4 UC: Null=True used user time
EH_IOCount Long Integer 4 UC: Null=True job: number of I/O's cockpit: frm_hight
EH_InfoText Text 32 UC: Null=True text from Executor
EH_Count Long Integer 4 UC: Null=True L=8 FT:number of bytes transferred (in progress) JP: recursive level group: number of tasks with errors cockpit: frm_width
EH_FileSize Long Integer 4 UC: Null=True L=8 bytes of the complete file
EH_Records Long Integer 4 UC: Null=True number of records
EH_HostAttrType Text 8 UC: Null=True attribute type of the host
EH_TaskCount Integer 2 UC: Null=True number of EJPP
EH_IntAccount Text 16 UC: Null=True Account
EH_Erase Byte 1 UC: Typ=Boolean Null=True delete file after filetransfer
EH_AutoDeact Text 1 UC: Null=True automatic deaktivation, QueueM: terminate automatically
EH_ActAtRun Byte 1 UC: Typ=Boolean Null=True activation at runtime?
EH_MaxParallel Integer 2 UC: Null=True group: maximum number of parallel tasks FT: maximum number of parallel filetransfers using wildcard characters QueueM: maximum number of parallel running jobs
EH_Restart Byte 1 UC: Null=True restart activation?
EH_RefNr Long Integer 4 UC: Null=True reference job number
EH_RestartPoint Text 8 UC: Null=True restart point from where the task was restarted
EH_LastRP Text 8 UC: Null=True last processed restart point
EH_EventType Text 2 UC: Null=True Evnt: TT time event(timer), TS time event(time of execution) Call-Op: OOA_TYP: question, message or alarm
EH_RepeatType Text 1 UC: Null=True EV: R=repeated, S=single FT: include subdirectories R=yes S=no QueueM: Replicate Children
EH_TExecType Text 1 UC: Null=True EV-TS: start after 'start time' E=execute N=noexecute EV-TT:S=start immediately FT: 1=filetransfer using wildcard characters; QueueM: Start ext. Jobs
EH_TimePeriod Text 4 UC: Null=True evnt: period in minutes or HHMM depending on the event type Call-Op: escalation time schedule: period
EH_NextCheck Date/Time 8 UC: Null=True evnt: time when the event will be checked the next time Call-Op: time when to escalate schedule: end of the period
EH_Cancel Text 1 UC: Null=True cancel flag: M=manually
EH_Max1 Long Integer 4 UC: Null=True maximum... FT: max. number of lines QueueM: Up to this retcode the ext. task is ENDED_OK
EH_QuSRName Text 8 UC: Null=True serverroutine which has to be notified when the task ends
EH_QuAcv Long Integer 4 UC: Null=True ACV for the message
EH_RetCode Long Integer 4 UC: Null=True user returncode
EH_EJ_ContentLen Long Integer 4 UC: Null=True text length of EJ_Inhalt (EJ_content)
EH_MaxParallel2 Integer 2 UC: Null=True maximum number of parallel running jobs
EH_MPElse Integer 2 UC: Null=True bitarray for max parallel checkpoint and for what to do when the max. number is exceeded
EH_QuAddr Text 32 UC: Null=True address for late confirmation
EH_MaxRetCode Long Integer 4 UC: Null=True up to this retcode the activity is ENDED_OK
EH_Ert Long Integer 4 UC: Null=True Estimated Runtime
EH_MrtTimeT Date/Time 8 UC: Null=True MRT as Timestamp f. Check
EH_ManualRelease Text 1 UC: Null=True Y = task waits for manual release before start
EH_Signal Long Integer 4 UC: Null=True Signals in this task (bitmask): 1=TCP exceeded, 2=MRT exceeded, 4=SRT not reached
EH_LDate Date/Time 8 UC: Null=True logical date
EH_RDate Date/Time 8 UC: Null=True real date
EH_TopNr Long Integer 4 UC: Null=True job number of the topmost activity
EH_LastCheck Date/Time 8 UC: Null=True time of last event check
EH_LastOccur Date/Time 8 UC: Null=True time of last event occurrence
EH_CheckCount Long Integer 4 UC: Null=True number of checks
EH_OccurCount Long Integer 4 UC: Null=True number of occurred events
EH_LastMsgNr Long Integer 4 UC: Null=True last message number
EH_LastMsgInsert Text 255 UC: Null=True L=1024 last messege insert
EH_EventSubType Text 2 UC: Null=True event sub type
EH_Operator Text 1 UC: Null=True G = greater L = less E = equal N = notequal
EH_Value Long Integer 4 UC: Null=True value to compare at file events console event: eventcounter job/ft: status counter
EH_Object1 Text 200 UC: Null=True Call-OP: name of the Call-Op when an escalation occurs Cockpit: Resource JOBP/JSCH: global alerting object QueueM: Alarm Object
EH_Text Memo 0 UC: Null=True L=0 Typ=clob inlinelength=1004 Call-OP: text to send
EH_Execute Text 255 UC: Null=True Call-OP: action to be executed (e.g. play .wav file) job: actually running program
EH_MaxWait Long Integer 4 UC: Null=True maximum time to wait before execution (in seconds) QueueM: polling interval of the queue-object within the executor
EH_MrtMethod Long Integer 4 UC: Null=True Method for 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%
EH_Mrt Long Integer 4 UC: Null=True maximum running time (in seconds)
EH_MrtTime Text 6 UC: Null=True Max. runtime in time ddhhmm or ssssss
EH_MrtErt Integer 2 UC: Null=True MRT=ERT+xx%
EH_MrtExecute Text 200 UC: Null=True Call-Operator for auditing
EH_Srt Long Integer 4 UC: Null=True SRT in Seconds
EH_SrtErt Integer 2 UC: Null=True SRT=ERT+xx%
EH_Unit Long Integer 4 UC: Null=True file event: unit of the value 0=host specific, 1 = byte, 2=KB, 3 = MB, 4=GB, 5=TB
EH_Source Text 32 UC: Null=True WIN_EVENT: source; Mail Notification: Attached Reports
EH_Category Long Integer 4 UC: Null=True WIN_EVENT: category QueueM: Queue Type Message Number
EH_External Long Integer 4 UC: Null=True bit array for external notification 1=SNMP, 2=eMail
EH_Archive1 Text 60 UC: Null=True archive key 1
EH_Archive2 Text 20 UC: Null=True archive key 2
EH_GrpRestart Text 1 UC: Null=True Y=restart in group and not immediately
EH_FiFoNr Long Integer 4 UC: Null=True FirstInFirstOut Ranking
EH_UC4Priority Integer 2 UC: Null=True UC4 priority
EH_MPOk Text 1 UC: Null=True maximum number of parallel running jobs is checked
EH_MPWaiting Text 1 UC: Null=True maximum number of parallel running jobs: tasks are waiting
EH_DeactDelay Long Integer 4 UC: Null=True delay in minutes
EH_MrtTZ Text 8 UC: Null=True Timezone for max. runtime when HHMM is used
EH_TimePeriodTZ Text 8 UC: Null=True Timezone for time period when HHMM is used
EH_TZ Text 8 UC: Null=True Timezone for this object and script
EH_DeactWhen Text 30 UC: Null=True ok state for autom. deactivation
EH_RWhen Text 30 UC: Null=True ok state global result
EH_ProcFlag Byte 1 UC: Null=True Processor Task? (1=Yes, 0=No)
EH_ParentHir Long Integer 4 UC: Null=True AH_Idnr of hirarchical parent
EH_ReloadFlag Byte 1 UC: Null=True for dynamic schedule
EH_Transferred Long Integer 4 UC: Null=True L=8 Transferred Bytes
EH_Compress Text 1 UC: Null=True Compress level
EH_ExtFlag Text 1 UC: Null=True 1=This task is used as an external dependency
EH_EndTime Date/Time 8 UC: Null=True job endtime
EH_CmtFlag Byte 1 UC: Typ=Boolean Null=True 0/1 flag for menue prompting + flag in runnr# field
EH_SkipMaxPar Byte 1 UC: Typ=Boolean Null=True 0=check host max_parallel_settings, 1=ignore host max_parallel_settings
EH_StartUC4 Byte 1 UC: Typ=Boolean Null=True 1=JOBD started by UC4
EH_RemoteStatus Long Integer 4 UC: Null=True Msgnr of actual state
EH_HostAttrTypeSrc Text 8 UC: Null=True attribute type of the host (source)
EH_ReuseHostGroup Byte 1 UC: Typ=Boolean Null=True Reuse hostgroup dissolution within job plan? (1=Yes, 0=No)
EH_HGSrc Text 32 UC: Null=True Name of source hostgroup
EH_HGDst Text 32 UC: Null=True Name of destination hostgroup
EH_MaxParallelHG Long Integer 4 UC: Null=True max amount of parallel running tasks in host group
EH_ChildCnt Long Integer 4 UC: Null=True Amount of childs
EH_ChildCntActive Long Integer 4 UC: Null=True Amount of childs that are active at the moment
EH_ChildCntEnded Long Integer 4 UC: Null=True Amount of finished childs
EH_ChildNr Long Integer 4 UC: Null=True Running number of child (X st child)
EH_ChildCntFail Long Integer 4 UC: Null=True Failed childs (successful restarts compensate failures)
EH_ChildCntFailAll Long Integer 4 UC: Null=True Failed childs
EH_ChildCntRestart Long Integer 4 UC: Null=True Count of restarted childs
EH_ContainerType Text 8 UC: Null=True Original type of object (job, ft, ...)
EH_ErrorCount Long Integer 4 UC: Null=True count of errors
EH_NextOccur Date/Time 8 UC: Null=True Next dispatch
EH_Resource Long Integer 4 UC: Null=True Count of resources used by this object (JOBS, FT, JOBD)
EH_EV_Flag Byte 1 UC: Typ=Boolean Null=True 1=EV is defined, 0=there is no EV
EH_RunTime Long Integer 4 UC: Null=True Runtime in Seconds
EH_LocalDate Date/Time 8 UC: Null=True local LDATE after script processing with time 0:00:00
EH_EV_Mode Byte 1 UC: Null=True Mode for heritage of values (0=InheritAll, 1=InheritDefined, 2=InheritNone)
EH_EV_Inherit Long Integer 4 UC: Null=True Inherit values from father? (0=no inherit, 1=yest)
EH_ModUserIdnr Long Integer 4 UC: Null=True User who is modifying this task
EH_ModDate Date/Time 8 UC: Null=True Date/Time since this task is modifying
EH_LastModUserIdnr Long Integer 4 UC: Null=True Last User who modified this task
EH_EventId Long Integer 4 UC: Null=True Events: First AH_Idnr, used as ID for communication with Executors
EH_ModFlag Byte 1 UC: Typ=Boolean Null=True 1 = Task was modified
EH_EventSubType2 Text 2 UC: Null=True Second check type (FC=File changed; FS=File stable)
EH_CheckWithin Long Integer 4 UC: Null=True Seconds in the past within the Event has to check
EH_InclSubDir Byte 1 UC: Typ=Boolean Null=True Check includes sub directores (0=no, 1=yes)
EH_Subject Text 255 UC: Null=True Subject (for mail notification)
EH_OptReport Text 64 UC: Null=True Optional reports
EH_ConsiderAll Byte 1 UC: Typ=Boolean Null=True Fileevent: Consider all files (0=no, 1=yes)
EH_RandomId Long Integer 4 UC: Null=True Randomly generated ID by an agent to identify jobs also activated by this agent. (Default=0)
EH_HostFsc Text 200 UC: Null=True Filescan Host
EH_LoginFsc Text 200 UC: Null=True Filescan Login Object
EH_PPFFlag Byte 1 UC: Typ=Boolean Null=True 1=PPF is defined, 0=no PPF
EH_MrcExecute Text 200 UC: Null=True Alarm object for max retcode
EH_PPFInherit Text 1 UC: Null=True OutputScanTarget (N=no children,Y=with children,C=children only)
EH_Queue Text 200 UC: Null=True Name of the Queue the Object runs within
EH_ChildQueue Text 200 UC: Null=True The children are assigned to this Queue
EH_QueueSlot Byte 1 UC: Typ=Boolean Null=True Task occupies a Queue Slot (0=no, 1=yes)
EH_QueueSlotOK Byte 1 UC: Typ=Boolean Null=True Is Queue Slot already assigned? (0=no, 1=yes)
EH_QueuePriority Integer 2 UC: Null=True Priority of the Queue
EH_ERTEnd Date/Time 8 UC: Null=True Estimated end of the Task
EH_Sent Long Integer 4 UC: Null=True Files already sent/transferred
EH_Successful Long Integer 4 UC: Null=True Files sent successfully
EH_FTRestart Byte 1 UC: Null=True Restart behavior during new file transfer (0 = none, 1 = continue, 2 = new)
EH_KeepAtt Byte 1 UC: Typ=Boolean Null=True Keep file attributes (only on the same OS possible) (0=no, 1=yes)
EH_CancelOn1stErr Byte 1 UC: Typ=Boolean Null=True Shall a FT be cancelled when an error occurs during a wildcard FT or not. (0 = no, 1 = yes)
EH_SubStatus Long Integer 4 UC: Null=True job state
EH_BH_Idnr Long Integer 4 UC: Null=True reference of the used buffer header
EH_TotalFiles Long Integer 4 UC: Null=True Number of files to be transferred
EH_StreamSize Long Integer 4 UC: Null=True L=8 Size (Bytes) of uncompressed data streamed from the sender to the receiver agent
EH_MemID Long Integer 4 UC: Null=True MemID of GENX Message, saved at prompt-start
EH_DVAR_Memid Long Integer 4 UC: Null=True MQMEM_Id; entry with infos for UCDVAR_R
EH_RemoteStatusIns Text 100 UC: Null=True MsgInsert for MsgNr in EH_RemoteStatus
EH_MemIDLen Long Integer 4 UC: Null=True L�nge des Speichers in EH_MemID
EH_DynFileCount Integer 2 UC: Null=True Number dynamic registered Outputfiles
EH_EPUD_Flag Byte 1 UC: Typ=Boolean Null=True Task has EPUDs
EH_ParentEJPPVFlag Byte 1 UC: Typ=Boolean Null=True Task has EJPPVs
EH_OEO_Flag Byte 1 UC: Typ=Boolean Null=True Task OEOs
EH_GeneratedFlag Byte 1 UC: Typ=Boolean Null=True Task is already generated
EH_ReportSrc Byte 1 UC: Null=True Source of attached reports (0=Database, 1=Ext. files, 2=All)
EH_Alias Text 200 UC: Null=True Alias Name for ProcessFlow task
EH_ChildFlags Text 32 UC: Null=True Flags for Subtables
EH_PromptTimeout Date/Time 8 UC: Null=True Prompt-Timeout time for Timer processing
EH_Session Long Integer 4 UC: Null=True Orignial session of the start-user
EH_Title Text 255 UC: Null=True The title of OH_Title
EH_Icon Text 8 UC: Null=True object icon
EH_Deployment Byte 1 UC: Typ=Boolean Null=True Is deployment Tab active or not
EH_WFType Integer 2 UC: Null=True Deployment Workflow Type (0 standard, 1 application, 2 component)
EH_AppName Text 200 UC: Null=True Deployment Application Name
EH_ComponentName Text 200 UC: Null=True Deployment Component Name
EH_RollbackFlag Byte 1 UC: Typ=Boolean Null=True Rollback is enabled for object
EH_LoopIteration Long Integer 4 UC: Null=True Iteration of loop in which task has been started
EH_RBCount Long Integer 4 UC: Null=True Number of Rollbacks
EH_RBErrCount Long Integer 4 UC: Null=True Number of Errors during Rollback
EH_SubDirStruct Byte 1 UC: Typ=Boolean Null=True Transfer complete subfolder structure
EH_ReqParameters Byte 1 UC: Typ=Boolean Null=True Request Parameters (0=No, 1=Yes)
EH_HostVara Text 200 UC: Null=True Agent for resolving Filelist or Backen VARA we are waiting for
EH_SubType Text 8 UC: Null=True OType specific SubType
EH_RerunState Integer 2 UC: Typ=Boolean Null=True State for Rerun
EH_ActivationTime Date/Time 8 UC: Null=True Activation time (= AH_Timestamp1)
EH_ERTCalc Integer 2 UC: Null=True The status of ERT calculation (0=no ERT, 1=ERT calculation active, 2=ERT calculation succeeded, 3=ERT calculation failed)
EH_ERTStatus Integer 2 UC: Null=True Status of the job before start of ERT calculation
EH_DeplDescIdnr Long Integer 4 UC: Null=True Task which stores the Deployment Descriptor
EH_MsgMemId Long Integer 4 UC: Null=True MemID of saved message
EH_MsgMemIdLen Long Integer 4 UC: Null=True Length of memory in EH_MsgMemId
EH_WFName Text 200 UC: Null=True Deployment Workflow Name
EH_AutoQuit Text 1 UC: Null=True J=Quit automatically on escalation
EH_Description Text 255 UC: Null=True Period description for periodic tasks
EH_AEVersion Text 8 UC: Null=True AE system version
EH_MQSet Text 1 UC: Null=True 1 for new MQ1* and 2 for new MQ2*


Indexes:

Name Fields
NK_EH_ChildNr EH_ParentPrc, EH_Status, EH_ChildNr, EH_AH_Idnr
NK_EH_EventId EH_EventId
NK_EH_HOST EH_Status, EH_HostDst, EH_HostSrc, EH_HostVara
NK_EH_Mrt EH_MrtTimeT
NK_EH_Name EH_Name, EH_Alias, EH_Client, EH_OType, EH_Status, EH_StartType
NK_EH_NextCheck EH_NextCheck, EH_OType, EH_Status
NK_EH_OH_IDNR EH_OH_Idnr, EH_Status, EH_Client, EH_AH_Idnr
NK_EH_OType EH_OType, EH_StartTime
NK_EH_ParentAct EH_ParentAct, EH_Client
NK_EH_ParentHir EH_ParentHir, EH_Client
NK_EH_ParentPrc EH_ParentPrc, EH_Client
NK_EH_Queue EH_Queue, EH_Status, EH_QueueSlotOK, EH_Client, EH_UC4Priority, EH_FiFoNr
NK_EH_RefNr EH_RefNr
NK_EH_StartType EH_StartType, EH_Status, EH_Client
NK_EH_Status EH_Status, EH_Client
NK_EH_TopNr EH_TopNr
PK_EH EH_AH_Idnr


Return to the Index File