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