generated: 09.12.2016 10:26:40
by UC2010.accdb
AE Database 12.0 (Step 013)
Name | Type | Len | Attributes | Description |
---|---|---|---|---|
AH_Client | Integer | 2 | UC: Null=True | number of the client |
AH_OType | Text | 8 | UC: Null=True | objecttype |
AH_SType | Text | 8 | UC: Null=True | subtype of the activity |
AH_Idnr | Long Integer | 4 | UC: Typ=Zähler Null=False | primary key of the archive header |
AH_USR_Idnr | Long Integer | 4 | UC: Null=True | IDNR of the user that executed this activity |
AH_OH_Idnr | Long Integer | 4 | UC: Null=True | processed IDNR |
AH_TimeStamp1 | Date/Time | 8 | UC: Null=True | activation time |
AH_TimeStamp2 | Date/Time | 8 | UC: Null=True | start time |
AH_TimeStamp3 | Date/Time | 8 | UC: Null=True | end time (before post processing if available) |
AH_TimeStamp4 | Date/Time | 8 | UC: Null=True | end time (including post processing time if available) |
AH_MsgNr | Long Integer | 4 | UC: Null=True | return code |
AH_MsgInsert | Text | 50 | UC: Null=True L=1024 | message insert to the message number |
AH_Info | Text | 20 | UC: Null=True | additional information like job number |
AH_HostDst | Text | 200 | UC: Null=True | name of the host or hostgroup |
AH_LoginDst | Text | 200 | UC: Null=True | name of login object |
AH_CodeNameDst | Text | 200 | UC: Null=True | codetable for filetransfer |
AH_FileNameDst | Text | 255 | UC: Null=True L=512 | filename for filetransfer |
AH_CpuTime | Long Integer | 4 | UC: Null=True | used CPU time |
AH_KernelTime | Long Integer | 4 | UC: Null=True | used kernel time |
AH_UserTime | Long Integer | 4 | UC: Null=True | used user time |
AH_IOCount | Long Integer | 4 | UC: Null=True | count of I/Os |
AH_InfoText | Text | 32 | UC: Null=True | text from Exekutor |
AH_HostSrc | Text | 200 | UC: Null=True | name of host (sender) |
AH_LoginSrc | Text | 200 | UC: Null=True | name of login object for sender file |
AH_CodeNameSrc | Text | 200 | UC: Null=True | codetable for filetransfer (sender) |
AH_FileNameSrc | Text | 255 | UC: Null=True L=512 | filename for filetransfer (sender) |
AH_IntAccount | Text | 16 | UC: Null=True | account |
AH_ProcessId | Text | 10 | UC: Null=True | TSN / process id |
AH_Count | Long Integer | 4 | UC: Null=True L=8 | filetransfer: bytes transfered group: number of started activities |
AH_FileSize | Long Integer | 4 | UC: Null=True L=8 | bytes of the complete file |
AH_Records | Long Integer | 4 | UC: Null=True | number of records |
AH_Status | Long Integer | 4 | UC: Null=True | state of the activity |
AH_RetCode | Long Integer | 4 | UC: Null=True | return code |
AH_ParentAct | Long Integer | 4 | UC: Null=True | AH_Idnr of activator parent |
AH_ParentPrc | Long Integer | 4 | UC: Null=True | AH_Idnr of processor parent |
AH_Restart | Byte | 1 | UC: Null=True | was this a restarted activation? |
AH_RefNr | Long Integer | 4 | UC: Null=True | reference job number |
AH_RestartPoint | Text | 8 | UC: Null=True | restart point from where the task was restarted |
AH_LastRP | Text | 8 | UC: Null=True | last processed restart point |
AH_EventType | Text | 2 | UC: Null=True | TT time event(timer), TS time event(time of execution) |
AH_RepeatType | Text | 1 | UC: Null=True | EV: R=repeated, S=single FT: include subdirectories R=yes S=no QueueM: replicate children |
AH_TimePeriod | Text | 4 | UC: Null=True | period in minutes or HHMM depending on the event type |
AH_CheckCount | Long Integer | 4 | UC: Null=True | number of checks |
AH_OccurCount | Long Integer | 4 | UC: Null=True | number of occourred events |
AH_EventSubType | Text | 2 | UC: Null=True | event sub type |
AH_Operator | Text | 1 | UC: Null=True | G = Greater L = Less E = Equal N = NotEqual |
AH_Value | Long Integer | 4 | UC: Null=True | value to compare |
AH_DeleteFlag | Byte | 1 | UC: Null=True | the delete flag |
AH_Cancel | Text | 1 | UC: Null=True | the cancel flag: M=manually |
AH_TaskCount | Integer | 2 | UC: Null=True | number of AJPP |
AH_Unit | Long Integer | 4 | UC: Null=True | unit of AH_Wert: 0=host specific, 1 = Byte, 2=KB, 3 = MB, 4=GB, 5=TB |
AH_Source | Text | 32 | UC: Null=True | WIN_EVENT: Source |
AH_Category | Long Integer | 4 | UC: Null=True | WIN_EVENT: Category |
AH_TExecType | Text | 1 | UC: Null=True | EV-TS: start after 'start time' E=Execute N=NoExecute EV-TT:S=start immediately FT: 1=filetransfer with wildcard characters QueueM: start ext. jobs |
AH_Archive1 | Text | 60 | UC: Null=True | archive key 1 |
AH_Archive2 | Text | 20 | UC: Null=True | archive key 2 |
AH_MaxRetCode | Long Integer | 4 | UC: Null=True | up to this retcode the activity is ENDED_OK |
AH_ArchiveFlag | Byte | 1 | UC: Null=True | archive flag |
AH_Rest | Memo | 0 | UC: L=1024 Null=True | . additional attributes |
AH_TZ | Text | 8 | UC: Null=True | Timezone for object and script |
AH_TimePeriodTZ | Text | 8 | UC: Null=True | Timezone for time period (event) when HHMM is used |
AH_Name | Text | 200 | UC: Null=True | name of the object |
AH_LDate | Date/Time | 8 | UC: Null=True | logical date |
AH_Transferred | Long Integer | 4 | UC: Null=True L=8 | Transferred bytes |
AH_Compress | Text | 1 | UC: Null=True | Compress level |
AH_LoginSrcO | Text | 200 | UC: Null=True | Original Login Source Name |
AH_LoginDstO | Text | 200 | UC: Null=True | Original Login Destination Name |
AH_ModCnt | Long Integer | 4 | UC: Null=True | modification counter |
AH_ProcFlag | Byte | 1 | UC: Null=True | Processor Task? (1=Yes, 0=No) |
AH_RunTime | Long Integer | 4 | UC: Null=True | Runtime in Seconds |
AH_HostAttrTypeS | Text | 8 | UC: Null=True | attribute type of the host (source) |
AH_HostAttrTypeD | Text | 8 | UC: Null=True | attribute type of the host (destination) |
AH_CmtFlag | Byte | 1 | UC: Typ=Boolean Null=True | 0/1 flag for menue prompting + flag in runnr# field |
AH_SkipMaxPar | Byte | 1 | UC: Typ=Boolean Null=True | 0=evaluation of host max_parallel_settings, 1=ignore host max_parallel_settings |
AH_StartUC4 | Byte | 1 | UC: Typ=Boolean Null=True | 1=JOBD started by UC4 |
AH_RemoteStatus | Long Integer | 4 | UC: Null=True | Msgnr of actual state |
AH_ERT | Long Integer | 4 | UC: Null=True | Estimated Runtime |
AH_ReuseHostGroup | Byte | 1 | UC: Typ=Boolean Null=True | Reuse hostgroup dissolution within job plan? (1=Yes, 0=No) |
AH_HGSrc | Text | 32 | UC: Null=True | Name of source hostgroup |
AH_HGDst | Text | 32 | UC: Null=True | Name of destination hostgroup |
AH_MaxParallelHG | Long Integer | 4 | UC: Null=True | max amount of parallel running tasks in host group |
AH_ChildCnt | Long Integer | 4 | UC: Null=True | Amount of childs |
AH_ChildCntFail | Long Integer | 4 | UC: Null=True | Failed childs (successful restarts compensate failures) |
AH_ChildCntFailAll | Long Integer | 4 | UC: Null=True | Failed childs |
AH_ChildCntRestart | Long Integer | 4 | UC: Null=True | Count of restarted childs |
AH_ContainerType | Text | 8 | UC: Null=True | Original type of object (job, ft, ...) |
AH_ErrorCount | Long Integer | 4 | UC: Null=True | count of errors |
AH_Resource | Long Integer | 4 | UC: Null=True | Count of resources used by this object (JOBS, FT, JOBD) |
AH_LocalDate | Date/Time | 8 | UC: Null=True | local LDATE after script processing with time 0:00:00 |
AH_TopNr | Long Integer | 4 | UC: Null=True | job number of the topmost activity |
AH_EventId | Long Integer | 4 | UC: Null=True | Events: First AH_Idnr, used as ID for communication with Executors |
AH_ModFlag | Byte | 1 | UC: Typ=Boolean Null=True | 1=Task was modified |
AH_EventSubType2 | Text | 2 | UC: Null=True | Second check type (FC=File changed; FS=File stable) |
AH_CheckWithin | Long Integer | 4 | UC: Null=True | Seconds in the past within the Event has to check |
AH_InclSubDir | Byte | 1 | UC: Typ=Boolean Null=True | Check includes sub directores (0=no, 1=yes) |
AH_ConsiderAll | Byte | 1 | UC: Typ=Boolean Null=True | Fileevent: Consider all files (0=no, 1=yes) |
AH_HostFsc | Text | 200 | UC: Null=True | Filescan Host |
AH_LoginFsc | Text | 200 | UC: Null=True | Filescan Login Object |
AH_MrcExecute | Text | 200 | UC: Null=True | Alarm object for max retcode |
AH_PPFInherit | Text | 1 | UC: Null=True | OutputScanTarget (N=no children,Y=with children,C=children only) |
AH_Queue | Text | 200 | UC: Null=True | Name of the Queue the Object runs within |
AH_QueueSlot | Byte | 1 | UC: Typ=Boolean Null=True | Task occupies a Queue Slot (0=no, 1=yes) |
AH_Sent | Long Integer | 4 | UC: Null=True | Files already sent/transferred |
AH_Successful | Long Integer | 4 | UC: Null=True | Files sent successfully |
AH_TotalFiles | Long Integer | 4 | UC: Null=True | Number of files to be transferred |
AH_StreamSize | Long Integer | 4 | UC: Null=True L=8 | Size (Bytes) of uncompressed data streamed from the sender to the receiver agent |
AH_Alias | Text | 200 | UC: Null=True | Alias Name for ProcessFlow task |
AH_Title | Text | 255 | UC: Null=True | The title of OH_Title |
AH_Icon | Text | 8 | UC: Null=True | object icon |
AH_Token | Text | 128 | UC: Null=True | encrypted token |
AH_Deployment | Byte | 1 | UC: Typ=Boolean Null=True | Is deployment Tab active or not |
AH_WFType | Integer | 2 | UC: Null=True | Deployment Workflow Type (0 standard, 1 application, 2 component) |
AH_AppName | Text | 200 | UC: Null=True | Deployment Application Name |
AH_ComponentName | Text | 200 | UC: Null=True | Deployment Component Name |
AH_RollbackFlag | Byte | 1 | UC: Typ=Boolean Null=True | Rollback is enabled for object |
AH_ChildFlags | Text | 32 | UC: Null=True | Flags for Subtables |
AH_RBCount | Long Integer | 4 | UC: Null=True | Number of Rollbacks |
AH_RBErrCount | Long Integer | 4 | UC: Null=True | Number of Errors during Rollback |
AH_SubDirStruct | Byte | 1 | UC: Typ=Boolean Null=True | Transfer complete subfolder structure |
AH_SubType | Text | 8 | UC: Null=True | OType specific SubType |
AH_RemoteStatusIns | Text | 100 | UC: Null=True | MsgInsert for MsgNr in EH_RemoteStatus |
AH_DeplDescIdnr | Long Integer | 4 | UC: Null=True | Task which stores the Deployment Descriptor |
AH_AV_Mode | Byte | 1 | UC: Null=True | Mode for heritage of values (0=InheritAll, 1=InheritDefined, 2=InheritNone |
AH_Description | Text | 255 | UC: Null=True | Period description for periodic tasks |
AH_ParentHir | Long Integer | 4 | UC: Null=True | AH_Idnr of hirarchical parent |
AH_UC4Priority | Integer | 2 | UC: Null=True | UC4 priority |
AH_AJPP_Lnr | Integer | 2 | UC: Null=True | reference to the process line in parent jobplan |
AH_AEVersion | Text | 8 | UC: Null=True | AE system version |
AH_Version | Text | 255 | UC: Null=True L=270 | Full verion of a component (Agent,Server) |
Indexes:
Name | Fields |
---|---|
NK_AH_Alias | AH_Client, AH_Alias, AH_Idnr |
NK_AH_Archive | AH_Client, AH_ArchiveFlag, AH_DeleteFlag, AH_TimeStamp4, AH_Idnr |
NK_AH_Archive1 | AH_Archive1, AH_Client, AH_Idnr |
NK_AH_Archive2 | AH_Archive2, AH_Client, AH_Idnr |
NK_AH_Atyp | AH_Client, AH_OType, AH_SType, AH_TimeStamp1, AH_TimeStamp4, AH_Idnr, AH_EventId |
NK_AH_CmtFlag | AH_CmtFlag, AH_Client, AH_Idnr |
NK_AH_Date1 | AH_Client, AH_TimeStamp1, AH_OType, AH_Idnr |
NK_AH_Date2 | AH_Client, AH_TimeStamp2, AH_OType, AH_Idnr |
NK_AH_Date4_1 | AH_Client, AH_TimeStamp4, AH_Idnr |
NK_AH_Date4_2 | AH_Idnr, AH_Client, AH_TimeStamp4 |
NK_AH_DelFlag | AH_DeleteFlag, AH_Client, AH_Idnr |
NK_AH_ExtCond | AH_Client, AH_LocalDate, AH_Name, AH_Idnr |
NK_AH_IDNR_bearb | AH_OH_Idnr, AH_OType, AH_TimeStamp1, AH_TimeStamp4, AH_Client, AH_Idnr |
NK_AH_Name | AH_Name, AH_Client, AH_Idnr |
NK_AH_Name2 | AH_TimeStamp4, AH_Name, AH_Client, AH_Idnr |
NK_AH_Name3 | AH_Name, AH_TimeStamp4, AH_Client, AH_Idnr, AH_Status, AH_RetCode |
NK_AH_OH_Idnr | AH_Client, AH_Idnr, AH_OH_Idnr |
NK_AH_ParentAct | AH_ParentAct, AH_Idnr |
NK_AH_ParentHir | AH_Client, AH_ParentHir, AH_Idnr |
NK_AH_ParentPrc | AH_ParentPrc, AH_Idnr |
NK_AH_Queue | AH_Client, AH_Queue, AH_TimeStamp1, AH_TimeStamp4, AH_Idnr |
NK_AH_RefNr | AH_RefNr, AH_Idnr |
NK_AH_Reorg | AH_Client, AH_TimeStamp4, AH_Idnr, AH_OType, AH_SType, AH_OH_Idnr, AH_Status |
NK_AH_Run_EvntId | AH_Client, AH_OType, AH_Idnr, AH_EventId |
NK_AH_Timestamp4 | AH_TimeStamp4, AH_OH_Idnr, AH_Idnr |
NK_AH_TopNr | AH_TopNr, AH_Idnr |
NK_AH_USR | AH_USR_Idnr, AH_ParentPrc, AH_Idnr |
PK_AH | AH_Idnr |
Return to the Index File