generated: 12.12.2016 18:33:01
by UC2010.accdb
AE Database 11.2 (Step 018)
| 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 |
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