generated: 09.12.2016 10:27:05
by UC2010.accdb
AE Database 12.0 (Step 013)
| 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* |
| EH_ComplRate | Long Integer | 4 | UC: Null=True | Number of completed tasks in a workflow |
| EH_PassPrio | Byte | 1 | UC: Typ=Boolean Null=True | Pass on Workflow priority to children: 1 means True, 0 is False |
| EH_ModCnt | Long Integer | 4 | UC: Null=True | modification counter |
| EH_AgentSession | Long Integer | 4 | UC: Null=True | CAU agent session number |
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