Definition of table: AH - archive header

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