Skip to main content

Automation & Workflows - Key Tables

Full column listings for the 5 key tables in this category.

AUTOASSIGN (52 columns)

# Column Type Length Nullable Default
1 auid int NO
2 auseq int YES
3 auarea int YES
4 ausite int YES
5 aurequesttype int YES
6 ausection nvarchar 4000 YES
7 aucat2 nvarchar 4000 YES
8 aucat3 nvarchar 4000 YES
9 aucat4 nvarchar 4000 YES
10 aucat5 nvarchar 4000 YES
11 auunum int YES
12 AUsectionassigned nvarchar 4000 YES
13 AUUsePreviousTech bit NO ((0))
14 AUStatus int YES ((0))
15 AUseriousness int YES ((-1))
16 AUimpact int YES ((-1))
17 AUurgency int YES ((-1))
18 AUSymptom nvarchar 4000 YES
19 AUSymptom2 nvarchar 4000 YES
20 AUDeviceSite int YES ((0))
21 AUtopLevel int YES ((0))
22 AUMailBoxID int YES ((0))
23 AUSource int YES ((-1))
24 AUNewStatus int YES ((0))
25 AUNewSLA int YES ((-1))
26 AURuleDesc nvarchar 1000 YES ('')
27 AUChangeSeq int YES ((0))
28 AUNewCategory2 int NO ((-1))
29 audontshownotification bit YES ((0))
30 auuse int YES ((0))
31 austopmatching bit YES ((1))
32 aunewproductid int YES ((-1))
33 AUoutcomeid int YES ((0))
34 AUNewCategory3 int YES ((-1))
35 AUNewCategory4 int YES ((-1))
36 AUNewCategory5 int YES ((-1))
37 aunewworkflowid int YES ((-1))
38 AUScriptId int YES ((0))
39 autemplateid int YES ((0))
40 aupopupmsg nvarchar 4000 YES
41 auflowdetailid int YES
42 AUGUID uniqueidentifier YES (newid())
43 AUbatchSize int YES ((5))
44 AUbatchSleep int YES ((0))
45 aunewcolour nvarchar 7 YES
46 ausetcolour bit YES ((0))
47 auactive bit YES ((1))
48 auwtid int YES
49 auticketaiindexing bit YES
50 aupopupmsgishtml bit YES ((0))
51 AUusecriteriagroups bit YES
52 aupopupmsgmodal bit YES ((0))

Automation (39 columns)

# Column Type Length Nullable Default
1 id int NO
2 timestamp datetime NO
3 faultid int NO
4 flowid int NO
5 flowstep int NO
6 flowseq int NO
7 actionid int NO
8 startedbyautomationid int YES
9 automationiteration int NO
10 status int NO
11 error nvarchar 255 YES
12 retryremaining int YES
13 resultactionnumber int YES
14 dateprocessed datetime YES
15 nextretrydate datetime YES
16 executiontype int YES ((0))
17 flowsubdetail_id int YES ((0))
18 runbookid nvarchar 50 YES ('')
19 runbookstep int YES ((0))
20 checkrules bit YES ((0))
21 SystemUse int YES
22 SystemUse2 int YES
23 LastAttemptDate datetime YES ((0))
24 IterationState nvarchar -1 YES
25 lookupid int YES
26 AutomationParams nvarchar -1 YES
27 EntityType int YES ((1))
28 EntityId int YES
29 initialvarscalculated bit YES
30 stopped bit YES
31 infiniteLoopThreshold int YES
32 eventNo int YES
33 stepsexecuted int YES
34 executiontime bigint YES
35 ProcessExecutionCpuTime bigint YES
36 ProcessExecutionLikelyLOH bit YES
37 ProcessExecutionGen2Count int YES
38 seriespredecessorid int YES
39 runbookpath nvarchar 1000 YES

ESCMSG (58 columns)

# Column Type Length Nullable Default
1 EMuserid int NO
2 EMseq int NO
3 EMsummary nvarchar 4000 YES
4 EMreadstatus int YES ((0))
5 EMmailaddr nvarchar 4000 YES
6 EMfull ntext 1073741823 YES
7 EMdate datetime YES
8 EMtype int YES ((0))
9 EMemailstatus int NO
10 EMpopupstatus int NO
11 EMpopupaddr nvarchar 4000 YES
12 EMsubject nvarchar 4000 YES
13 EMbodyandfooter ntext 1073741823 YES
14 EMccaddr nvarchar 4000 YES
15 EmSMSStatus int YES ((0))
16 EMSMSnos nvarchar 4000 YES
17 emailbodyrich varbinary -1 YES
18 EMfaultid int YES ((0))
19 EMactionnumber int YES ((0))
20 EMSMSBody varchar -1 YES
21 EMSendEmailIfNoPopup bit YES ((1))
22 EMEventNo int YES ((0))
23 EMmessage nvarchar 4000 YES ('')
24 EMslackid int YES ((0))
25 emailbodyhtml nvarchar -1 YES
26 EMshown bit YES ((0))
27 emuid int YES ((0))
28 emkeyid int YES ((0))
29 EMapprovalfaseq int YES ((0))
30 Emunid int YES ((0))
31 id uniqueidentifier YES (newsequentialid())
32 EMmsteamsid int YES ((0))
33 EMDeleted bit YES ((0))
34 EMpushStatus int YES ((0))
35 emapiversion nvarchar 200 YES ('')
36 EMeventId int YES ((0))
37 EMNextRetryDate datetime YES ((0))
38 emclientid int YES
39 EMpushFailCount int YES ((0))
40 emretryremaining int YES
41 emprocessed bit YES
42 EMmattermostchannelid int YES
43 EMstatus int YES
44 pk bigint NO
45 EMreplytoaddress nvarchar 250 YES
46 EMmailboxfrom int YES
47 empopupcolour nvarchar 7 YES
48 EMisBatchMaster bit YES
49 EMbatchStatus int YES
50 EMbatchParentId bigint YES
51 EMbatchUse int YES
52 EMattype int YES
53 EMatuniqueid int YES
54 emreaddate datetime YES ((0))
55 emreadinput int YES
56 emmoduleid int YES
57 emthirdpartyid nvarchar 255 YES
58 EMsalesmailboxfromoverride int YES

WORKFLOWHEADER (4 columns)

# Column Type Length Nullable Default
1 WFid int NO
2 WFName nvarchar 4000 YES
3 WFNote ntext 1073741823 YES
4 WFchangeseq int YES ((0))

WORKFLOWSTEP (4 columns)

# Column Type Length Nullable Default
1 WSid int NO
2 WSWFid int YES ((0))
3 WSStepName nvarchar 4000 YES
4 WSsequence int YES ((0))
Back to top