Skip to main content

SLA & Service Level - Key Tables

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

HOLIDAYS (18 columns)

# Column Type Length Nullable Default
1 Hid int NO
2 Hdate datetime NO
3 hdesc nvarchar 4000 YES
4 Hduration float YES ((0))
5 Htype int YES ((0))
6 HTechnicianID int YES ((0))
7 Hchangeseq int YES ((1))
8 ID uniqueidentifier NO (newsequentialid())
9 henddate datetime YES ((0))
10 hallday bit YES ((0))
11 hentity int YES ((0))
12 hisrecurring bit YES ((0))
13 holid int NO
14 hthirdpartyid nvarchar 100 YES
15 henvironment int YES
16 hentityid int YES ((-1))
17 henablechangefreezeperclient bit YES
18 hrisk float YES

SERVSTATUS (20 columns)

# Column Type Length Nullable Default
1 ssdate datetime NO
2 ssarea int NO
3 sssitenum int NO
4 ssid int NO
5 ssstatus int YES
6 sslastcheck datetime YES
7 ssmessage nvarchar 4000 YES
8 sslastok datetime YES
9 sslastfailed datetime YES
10 ssokcount int YES
11 ssfailedcount int YES
12 sslastemail ntext 1073741823 YES
13 sstotaldownmins int YES ((0))
14 sstotaldowninstances int YES ((0))
15 sspublicnote nvarchar 4000 YES ('')
16 SSWho nvarchar 255 YES ('')
17 SSfaultid int YES ((0))
18 ssmessage_html nvarchar -1 YES
19 sspublicnote_html nvarchar -1 YES
20 ssuniqueid uniqueidentifier NO (newsequentialid())

SLAHEAD (23 columns)

# Column Type Length Nullable Default
1 Slid smallint NO
2 Sldesc nvarchar 4000 YES
3 Slwdid int YES
4 Slcost ntext 1073741823 YES
5 SLAResponseReset bit NO ((0))
6 autoreleaseoption bit NO ((0))
7 SLHoursAreTechsLocalTime bit NO ((0))
8 Slholdnote bit YES ((0))
9 Slholdunassigned bit YES ((0))
10 SLdontsendholdreminders bit YES ((0))
11 SLchangeseq int YES ((0))
12 SLStatusAfterAutoRelease int YES ((-1))
13 slresponseresetapproval bit YES ((0))
14 slautoreleaselimit int YES ((0))
15 SLGUID uniqueidentifier YES (newid())
16 sltrackslaresponsetime bit YES ((1))
17 sltrackslafixbytime bit YES ((1))
18 SLstatusAfterFirstWarning int YES ((-1))
19 SLstatusAfterSecondWarning int YES ((-1))
20 slstatusafterbreach int YES ((-1))
21 slslabartimedisplay bit YES
22 slinactive bit YES
23 slresponseresetcallscreen bit YES ((0))

WORKDAYS (29 columns)

# Column Type Length Nullable Default
1 Wdid int NO
2 Wstart datetime YES
3 Wend datetime YES
4 Wincmonday bit NO ((0))
5 Winctuesday bit NO ((0))
6 Wincwednesday bit NO ((0))
7 Wincthursday bit NO ((0))
8 Wincfriday bit NO ((0))
9 Wincsaturday bit NO ((0))
10 Wincsunday bit NO ((0))
11 Wdesc nvarchar 4000 YES
12 Walldayssame bit NO ((-1))
13 Wend1 datetime YES
14 Wend2 datetime YES
15 Wend3 datetime YES
16 Wend4 datetime YES
17 Wend5 datetime YES
18 Wend6 datetime YES
19 Wend7 datetime YES
20 wstart1 datetime YES
21 wstart2 datetime YES
22 wstart3 datetime YES
23 wstart4 datetime YES
24 wstart5 datetime YES
25 wstart6 datetime YES
26 wstart7 datetime YES
27 Wsummary nvarchar -1 YES
28 WDtimezone nvarchar 100 YES ('')
29 WDGUID uniqueidentifier YES (newid())
Back to top