Skip to main content

Tickets (Faults) - Key Tables

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

FAULTAPPROVAL (30 columns)

# Column Type Length Nullable Default
1 FAid int NO
2 FAseq int NO
3 FAActionNumber int YES ((0))
4 FAEmailstatus int YES ((0))
5 FAResult int YES ((0))
6 FAemailaddr nvarchar 4000 YES
7 FAType int YES ((0))
8 FAunum int YES ((0))
9 FACabID int YES ((0))
10 FATemplateID int NO ((50))
11 faunumrequesting int NO ((0))
12 fauser int YES ((0))
13 fadatetime datetime YES ((0))
14 FAAPid int YES ((0))
15 FAProcessGUID uniqueidentifier YES
16 FAOldProcess bit YES ((0))
17 FANote nvarchar 4000 YES ('')
18 FADelegatedBy int YES ((0))
19 FAruleMatchedId int YES ((-1))
20 FAvotesRequired int YES ((0))
21 FAmandatory bit YES ((0))
22 FArejectionThreshold int YES ((1))
23 fauniqueid int NO
24 falastreminderdatetime datetime YES ((0))
25 faadminoverridden bit YES
26 faadminoverideunum int YES
27 faroleid int YES
28 fadateapproved datetime YES ((0))
29 fastepid int YES
30 faadhoc bit YES

FAULTARC (198 columns)

# Column Type Length Nullable Default
1 Faultid int NO
2 username nvarchar 4000 YES
3 phonenumber nvarchar 4000 YES
4 Symptom ntext 1073741823 YES
5 Status smallint YES
6 Priority smallint YES
7 datereported datetime YES
8 seriousness smallint YES
9 dateoccured datetime YES
10 devicenumber int YES
11 equipmenttype smallint YES
12 sitenumber int YES
13 inventorynumber nvarchar 4000 YES
14 hdid int YES
15 hdduedate datetime YES
16 preallocate bit NO ((0))
17 predated bit NO ((0))
18 pcleared bit NO ((0))
19 pnewfault bit NO ((0))
20 estimate float YES
21 newsection nvarchar 10 YES
22 sectio_ nvarchar 4000 YES
23 category2 nvarchar 4000 YES
24 category3 nvarchar 4000 YES
25 takenby nvarchar 4000 YES
26 datecreated datetime YES
27 datecleared datetime YES
28 clearance ntext 1073741823 YES
29 cleartime float YES
30 fixbydate datetime YES
31 Assignedtoint smallint YES
32 Areaint int YES
33 Suppref nvarchar 4000 YES
34 Elapsedhrs float YES
35 Supplier smallint YES
36 Clearwhoint smallint YES
37 Typenum smallint YES
38 Chargecode1 nvarchar 4000 YES
39 Chargeamount1 float YES
40 Chargecode2 nvarchar 4000 YES
41 Chargeamount2 float YES
42 Customercode nvarchar 10 YES
43 Devsite smallint YES
44 Devconnector bit NO ((0))
45 reportedby nvarchar 4000 YES
46 category4 nvarchar 4000 YES
47 category5 nvarchar 4000 YES
48 Informexthd bit NO ((0))
49 Slastate nvarchar 1 YES
50 slareason nvarchar 4000 YES
51 Suppstate nvarchar 1 YES
52 Suppreason nvarchar 4000 YES
53 Suppdate datetime YES
54 Suppclear datetime YES
55 Changestate nvarchar 1 YES
56 Slaid int YES
57 Suppslaid int YES
58 Approvedby int YES
59 Requesttype int YES
60 Showonweb bit NO ((0))
61 MessSent nvarchar 10 YES
62 SatisfactionLevel int YES ((0))
63 Satisfactioncomment ntext 1073741823 YES
64 InvoiceNumber nvarchar 30 YES
65 InvoiceNote ntext 1073741823 YES
66 InvoiceDate datetime YES
67 InvoicePaidDate datetime YES
68 nonbilltime float YES ((0))
69 mileage float YES ((0))
70 fxrefto int YES ((0))
71 fenduserstatus int YES ((0))
72 fuserdef1 nvarchar 4000 YES
73 fuserdef2 nvarchar 4000 YES
74 fuserdef3 nvarchar 4000 YES
75 fuserdef4 nvarchar 4000 YES
76 fuserdef5 nvarchar 4000 YES
77 fplanneddate datetime YES
78 FSLAholdtime float YES ((0))
79 FSLAonhold bit NO ((0))
80 CCaddress nvarchar 4000 YES
81 suppseriousness int YES ((0))
82 suppelapsedhours float YES ((0))
83 symptom2 ntext 1073741823 YES
84 Flastactiondate datetime YES
85 FHrsAtRate1 float YES ((0))
86 FagreedCleared bit NO ((0))
87 FHrsAtRate2 float YES ((0))
88 FResponseDate datetime YES
89 FResponseTime float YES ((0))
90 FAlsoInform nvarchar 4000 YES
91 Fchangestatus int YES ((0))
92 FJustification ntext 1073741823 YES
93 FBackoutPlan ntext 1073741823 YES
94 FcommunicationPlan ntext 1073741823 YES
95 FTestPlan ntext 1073741823 YES
96 FRiskDescription ntext 1073741823 YES
97 FRiskLevel int YES ((0))
98 FImpactDescription ntext 1073741823 YES
99 FImpactLevel int YES ((0))
100 FServiceID int YES ((0))
101 FCHuserdef1 nvarchar 4000 YES
102 FCHuserdef2 nvarchar 4000 YES
103 FCHuserdef3 nvarchar 4000 YES
104 FCHuserdef4 nvarchar 4000 YES
105 FCHuserdef5 nvarchar 4000 YES
106 FRespondByDate datetime YES
107 SLAresponseState nvarchar 1 YES
108 FSurveyBool1 bit NO ((0))
109 FSurveyBool2 bit NO ((0))
110 FSurveyBool3 bit NO ((0))
111 FSurveyBool4 bit NO ((0))
112 FSurveySent bit NO ((0))
113 FSurveyBool5 bit NO ((0))
114 FplannedDateEnd datetime YES
115 FFlaggedRequest bit NO ((0))
116 FRequestSource int YES ((0))
117 Fread bit NO ((0))
118 FwhoResponded int YES ((0))
119 FUCdatelastemailed datetime YES
120 Finuseby int YES ((0))
121 Forgid int YES ((0))
122 FexcludefromSLA bit NO ((0))
123 FReviewed bit NO ((0))
124 FCurrentFAactionnumber int YES ((0))
125 FCurrentFAsequence int YES ((0))
126 FCurrentApprovalProcess int YES ((0))
127 RequestTypeNew int YES ((1))
128 FapptID nvarchar 4000 YES
129 FApptStatus int YES ((3))
130 FApptTechnician int YES ((0))
131 SuppResponseState nvarchar 1 YES
132 SuppResponseDate datetime YES
133 SuppResponseTime float YES ((0))
134 SuppRespondbydate datetime YES
135 SuppFixbydate datetime YES
136 suppbreachrespsent bit NO ((0))
137 suppbreachfixbysent bit NO ((0))
138 FFaultCodeOpen int YES ((0))
139 FFaultCode int YES ((0))
140 FlastStatus3rdParty int YES ((0))
141 FInform3rdPartySystem bit NO ((0))
142 FApptPlannedDate datetime YES
143 FApptEstimate float YES ((0))
144 Fsurveyneeded bit NO ((0))
145 impact int YES ((-1))
146 urgency int YES ((-1))
147 KnownError bit NO ((0))
148 Development bit NO ((0))
149 causedby int YES
150 FApptExchangeMailBoxFQDN nvarchar 4000 YES
151 MessSentLast nvarchar 10 YES
152 FUnapprovedChangeStatus int YES ((0))
153 Fchangeseq int YES ((1))
154 FLastRecurringEmailSentDate datetime YES
155 FTemplateParentID int YES ((0))
156 FTemplateChildID int YES ((0))
157 FSLAHoldReminderdatelastemailed datetime YES
158 FAssetString nvarchar 4000 YES
159 FMailBoxID int YES ((0))
160 FMergedIntoFaultid int YES ((0))
161 Fresponsestartdate datetime YES
162 FAlertType nvarchar 4000 YES
163 FActIsBillableDefault bit NO ((-1))
164 FEmailDisplayName nvarchar 4000 YES
165 FWorkFlowID int YES ((0))
166 FWorkFlowCurrentStep int YES ((0))
167 FEmailToList ntext 1073741823 YES
168 FEmailCCList ntext 1073741823 YES
169 FEmailPriority int YES ((0))
170 Fchargerate int YES ((-1))
171 FtimezoneName nvarchar 4000 YES
172 FForwardInboundUpdates bit NO ((0))
173 FReleaseNote ntext 1073741823 YES
174 FReleaseID int YES ((0))
175 FTargetDate datetime YES
176 FProjectTimeBudget float YES ((0))
177 FProjectMoneyBudget float YES ((0))
178 FProjectTimeActual float YES ((0))
179 FProjectMoneyActual float YES ((0))
180 FLoggedOutOfHDWorkingHours bit NO ((0))
181 FAcctManInformedSurvey bit NO ((0))
182 FLastStatusChangeInformed int YES ((0))
183 FisTweet bit YES ((0))
184 FTwitterScreenName nvarchar 4000 YES ('')
185 FTwitterID bigint YES ((0))
186 FisFacebookPost bit YES ((0))
187 FFacebookID nvarchar 4000 YES ('')
188 FFacebookUserID bigint YES ((0))
189 FFacebookName nvarchar 4000 YES ('')
190 Ffixbydateadjusted bit YES ((0))
191 FReleaseid2 int YES ((0))
192 FReleaseid3 int YES ((0))
193 FAlternativeContactNo nvarchar 4000 YES ('')
194 FOperationalServiceID int YES ((0))
195 FFlowID int YES ((0))
196 FFlowStep int YES ((0))
197 FFlowStepStarted datetime YES ((0))
198 fLessonsLearned nvarchar 4000 YES ('')

FAULTDEVICE (7 columns)

# Column Type Length Nullable Default
1 FDfaultid int NO
2 FDsiteid int NO
3 FDdevnum int NO
4 fdautolink bit YES ((0))
5 fdimpactstatement nvarchar 4000 YES
6 fdactivitystatement nvarchar 4000 YES
7 fdismaintenance bit YES

FAULTITEM (25 columns)

# Column Type Length Nullable Default
1 FLid int NO
2 FLseq int NO
3 FLitem int YES
4 FLorderqty float YES
5 FLshippedqty float YES
6 FLunit int YES
7 FLCostPrice decimal YES
8 FLSellingPrice decimal YES
9 FLstatus nvarchar 30 YES
10 FLdateshipped datetime YES
11 FLNote nvarchar 4000 YES
12 FLNote2 nvarchar 4000 YES
13 FLdesc nvarchar 4000 YES
14 FLdesc2 nvarchar 4000 YES
15 FLitemlocation int YES ((0))
16 FLdevice int YES ((0))
17 FLdevicesite int YES ((0))
18 FLwarrantyreported bit NO ((0))
19 FLselected bit NO ((0))
20 FLStockAdjustedAlready bit NO ((-1))
21 FLchangeseq int YES ((1))
22 flCostCentre int YES ((0))
23 FLUnum int YES ((-1))
24 FLdid int YES ((0))
25 flstbid int YES

FAULTS (757 columns)

# Column Type Length Nullable Default
1 Faultid int NO
2 username nvarchar 255 NO
3 phonenumber nvarchar 4000 YES
4 Symptom nvarchar 4000 YES
5 Status smallint YES
6 datereported datetime YES
7 seriousness smallint YES
8 dateoccured datetime YES
9 devicenumber int YES
10 equipmenttype smallint YES
11 sitenumber int YES
12 inventorynumber nvarchar 4000 YES
13 hdid int YES
14 hdduedate datetime YES
15 estimate float YES
16 sectio_ nvarchar 200 YES
17 category2 nvarchar 4000 YES
18 category3 nvarchar 4000 YES
19 takenby nvarchar 4000 YES
20 datecreated datetime YES
21 datecleared datetime YES
22 clearance ntext 1073741823 YES
23 cleartime float YES
24 fixbydate datetime YES
25 Assignedtoint smallint YES
26 Areaint int YES
27 Suppref nvarchar 4000 YES
28 Elapsedhrs float YES
29 Supplier smallint YES
30 Clearwhoint smallint YES
31 Devsite int YES
32 Devconnector bit NO ((0))
33 reportedby nvarchar 4000 YES
34 category4 nvarchar 4000 YES
35 category5 nvarchar 4000 YES
36 Informexthd bit NO ((0))
37 Slastate nvarchar 1 YES
38 slareason nvarchar 4000 YES
39 Suppstate nvarchar 1 YES
40 Suppreason nvarchar 4000 YES
41 Suppdate datetime YES
42 Suppclear datetime YES
43 Changestate nvarchar 1 YES
44 Slaid int YES
45 Suppslaid int YES
46 Approvedby int YES
47 Requesttype int YES
48 Showonweb bit NO ((0))
49 MessSent nvarchar 15 YES
50 SatisfactionLevel int YES ((0))
51 Satisfactioncomment ntext 1073741823 YES
52 InvoiceNumber nvarchar 30 YES
53 InvoiceNote ntext 1073741823 YES
54 InvoiceDate datetime YES
55 InvoicePaidDate datetime YES
56 nonbilltime float YES ((0))
57 mileage float YES ((0))
58 fxrefto int YES ((0))
59 fenduserstatus int YES ((0))
60 fuserdef1 nvarchar 4000 YES
61 fuserdef2 nvarchar 4000 YES
62 fuserdef3 nvarchar 4000 YES
63 fuserdef4 nvarchar 4000 YES
64 fuserdef5 nvarchar 4000 YES
65 fplanneddate datetime YES
66 FSLAholdtime float YES ((0))
67 FSLAonhold bit NO ((0))
68 CCaddress nvarchar 4000 YES
69 suppseriousness int YES ((0))
70 suppelapsedhours float YES ((0))
71 symptom2 ntext 1073741823 YES
72 Flastactiondate datetime YES
73 FagreedCleared bit NO ((0))
74 FResponseDate datetime YES
75 FResponseTime float YES ((0))
76 FAlsoInform nvarchar 4000 YES
77 Fchangestatus int YES ((0))
78 FJustification ntext 1073741823 YES
79 FBackoutPlan ntext 1073741823 YES
80 FcommunicationPlan ntext 1073741823 YES
81 FTestPlan ntext 1073741823 YES
82 FRiskDescription ntext 1073741823 YES
83 FRiskLevel int YES ((0))
84 FImpactDescription ntext 1073741823 YES
85 FImpactLevel int YES ((0))
86 FServiceID int YES ((0))
87 FCHuserdef1 nvarchar 4000 YES
88 FCHuserdef2 nvarchar 4000 YES
89 FCHuserdef3 nvarchar 4000 YES
90 FCHuserdef4 nvarchar 4000 YES
91 FCHuserdef5 nvarchar 4000 YES
92 FRespondByDate datetime YES
93 SLAresponseState nvarchar 1 YES
94 FSurveyBool1 bit NO ((0))
95 FSurveyBool2 bit NO ((0))
96 FSurveyBool3 bit NO ((0))
97 FSurveyBool4 bit NO ((0))
98 FSurveySent bit NO ((0))
99 FSurveyBool5 bit NO ((0))
100 FplannedDateEnd datetime YES
101 FFlaggedRequest bit NO ((0))
102 FUCdatelastemailed datetime YES
103 FRequestSource int YES ((0))
104 Fread bit NO ((0))
105 FwhoResponded int YES ((0))
106 Forgid int YES ((0))
107 FexcludefromSLA bit NO ((0))
108 FReviewed bit NO ((0))
109 FCurrentFAactionnumber int YES ((0))
110 FCurrentFAsequence int YES ((0))
111 FCurrentApprovalProcess int YES ((0))
112 RequestTypeNew int YES ((1))
113 SuppResponseState nvarchar 1 YES
114 SuppResponseDate datetime YES
115 SuppResponseTime float YES ((0))
116 SuppRespondbydate datetime YES
117 SuppFixbydate datetime YES
118 suppbreachrespsent bit NO ((0))
119 suppbreachfixbysent bit NO ((0))
120 FFaultCodeOpen int YES ((0))
121 FFaultCode int YES ((0))
122 FlastStatus3rdParty int YES ((0))
123 FInform3rdPartySystem bit NO ((0))
124 sitenumberoverride int YES ((0))
125 Symptom2Blob varbinary -1 YES
126 fDeliveryContact nvarchar 4000 YES
127 fDeliveryAddress ntext 1073741823 YES
128 FFollowUpDate datetime YES
129 Fsurveyneeded bit NO ((0))
130 impact int YES ((-1))
131 urgency int YES ((-1))
132 KnownError bit NO ((0))
133 Development bit NO ((0))
134 causedby int YES
135 MessSentLast nvarchar 15 YES
136 FUnapprovedChangeStatus int YES ((0))
137 Fchangeseq int YES ((1))
138 FLastRecurringEmailSentDate datetime YES
139 FTemplateParentID int YES ((0))
140 FTemplateChildID int YES ((0))
141 FSLAHoldReminderdatelastemailed datetime YES
142 FAssetString nvarchar 4000 YES
143 FMailBoxID int YES ((0))
144 FMergedIntoFaultid int YES ((0))
145 Fresponsestartdate datetime YES
146 FOppcontactName nvarchar 4000 YES
147 FOppCompanyName nvarchar 4000 YES
148 FOppEmailAddress nvarchar 4000 YES
149 FOppAddr1 nvarchar 4000 YES
150 FOppAddr2 nvarchar 4000 YES
151 FOppAddr3 nvarchar 4000 YES
152 FOppPostCode nvarchar 4000 YES
153 FOppValue float YES ((0))
154 FOppConversionProbability float YES ((0))
155 FAlertType nvarchar 4000 YES
156 FOppTel nvarchar 4000 YES
157 FActIsBillableDefault bit NO ((-1))
158 FEmailDisplayName nvarchar 4000 YES
159 FWorkFlowID int YES ((0))
160 FWorkFlowCurrentStep int YES ((0))
161 FEmailToList ntext 1073741823 YES
162 FEmailCCList ntext 1073741823 YES
163 FEmailPriority int YES ((0))
164 Fchargerate int YES ((-1))
165 FtimezoneName nvarchar 4000 YES
166 FForwardInboundUpdates bit NO ((0))
167 FReleaseNote ntext 1073741823 YES
168 FReleaseID int YES ((0))
169 FTargetDate datetime YES
170 FProjectTimeBudget float YES ((0))
171 FProjectMoneyBudget float YES ((0))
172 FProjectTimeActual float YES ((0))
173 FProjectMoneyActual float YES ((0))
174 FLoggedOutOfHDWorkingHours bit NO ((0))
175 FAcctManInformedSurvey bit NO ((0))
176 FLastStatusChangeInformed int YES ((0))
177 FOppProfit float YES ((0.00))
178 FGFIAlertType nvarchar 4000 YES
179 fQuoteDescription nvarchar 4000 YES ('')
180 fQuoteLabourAmount float YES ((0.00))
181 fQuotePriority int YES ((0))
182 fBudgetCode int YES ((0))
183 fActualCost float YES ((0.00))
184 fInvoiceStatus int YES ((0))
185 fInvoiceDescription nvarchar 4000 YES ('')
186 fInvoiceLabourAmount float YES ((0.00))
187 fInvoiceMaterialsAmount float YES ((0.00))
188 fFirstTimeFix int YES ((-1))
189 fQuoteMaterialsAmount float YES ((0.00))
190 FUKASAccredited bit YES ((0))
191 FlabNo nvarchar 4000 YES ('')
192 fAttachmentCount int YES ((0))
193 fChildCount int YES ((0))
194 FisTweet bit YES ((0))
195 FTwitterScreenName nvarchar 4000 YES ('')
196 FTwitterID bigint YES ((0))
197 FisFacebookPost bit YES ((0))
198 FFacebookID nvarchar 4000 YES ('')
199 FFacebookUserID bigint YES ((0))
200 FFacebookName nvarchar 4000 YES ('')
201 Ffixbydateadjusted bit YES ((0))
202 fLoggedOnBehalfBy nvarchar 4000 YES ('')
203 FReleaseid2 int YES ((0))
204 FReleaseid3 int YES ((0))
205 FAlternativeContactNo nvarchar 4000 YES ('')
206 FOperationalServiceID int YES ((0))
207 frequestdetailsprinted bit YES ((0))
208 fserviceformprinted bit YES ((0))
209 FAuditStatus int YES ((-1))
210 FAuditUnum int YES ((-1))
211 FAuditDate datetime YES
212 FAuditNote varchar -1 YES
213 FOppCountry nvarchar 4000 YES ('')
214 FOppType nvarchar 4000 YES ('')
215 FOppCustomerTitle nvarchar 4000 YES ('')
216 FOppHear nvarchar 4000 YES ('')
217 FOppCurrentSystem nvarchar 4000 YES ('')
218 FOppCompetitors nvarchar 4000 YES ('')
219 FOppTrialDate datetime YES
220 FOppDemoDate datetime YES
221 FOppDiscountDate datetime YES
222 FOppAttemptsMade int YES ((0))
223 FOppConvertedDate datetime YES
224 FOppProductChosen nvarchar 4000 YES ('')
225 FOppReason nvarchar 4000 YES ('')
226 FOppTargetDate datetime YES
227 FAuditFailedDate datetime YES ((0))
228 FAuditFailedNote ntext 1073741823 YES
229 fReleaseNoteCritical bit YES ((0))
230 FUserRequestedApprover int YES ((-1))
231 FRootCauseBlob varbinary -1 YES
232 fOppClosureCategory int YES ((-1))
233 FMailEntryID nvarchar 4000 YES ('')
234 FOppDontAddToMailingList bit YES ((0))
235 FBugID int YES ((0))
236 fSendPrintRequest int YES ((0))
237 FPagerdutyID nvarchar 255 YES ('')
238 FPagerdutyincidentID nvarchar 255 YES ('')
239 FPagerdutyURL nvarchar 1000 YES ('')
240 FPagerdutyStatus int YES ((0))
241 fproductid int YES ((0))
242 fcomponentid int YES ((0))
243 fversionid int YES ((0))
244 areaintoverride int YES ((0))
245 freassigncount int YES ((0))
246 fcontractid int YES ((0))
247 fdeliveryaddressid int YES ((0))
248 fbillingaddressid int YES ((0))
249 fbillingaddress ntext 1073741823 YES
250 FFlowID int YES ((0))
251 FFlowStep int YES ((0))
252 FFlowStepStarted datetime YES ((0))
253 fLessonsLearned nvarchar 4000 YES ('')
254 FLastStatusChangeInformedManager int YES ((-1))
255 Flastbugzillasync datetime YES ((0))
256 FSapID nvarchar 50 YES ('')
257 FSAPAttachmentsUUID nvarchar 255 YES ('')
258 Symptom2HTML ntext 1073741823 YES
259 FCurrency int YES ((0))
260 FProjectConsignmentHeaderID int YES ((0))
261 FProjectConsignmentDetailID int YES ((0))
262 FServiceFailureStid int YES ((0))
263 FNHDExternalID int YES ((0))
264 FDynamicsID nvarchar 100 YES ('')
265 FCSPID int YES ((0))
266 FProjectStartDate datetime YES ((0))
267 FDeadlineNotificationHours float YES ((0.00))
268 FProjectTargetAllowanceDate datetime YES ((0))
269 fdeadlinedate datetime YES ((0))
270 fReviewedDate datetime YES ((0))
271 fContinuumAssignedTo nvarchar 500 YES ('')
272 fContinuumID nvarchar 500 YES ('')
273 FNCentralTicketID nvarchar 400 YES ('')
274 FNHDUExternalID int NO ((0))
275 FDeleted bit YES ((0))
276 FLastStatusChangeInformedSection int NO ((-1))
277 FLastStatusChangeInformedDate datetime YES ((0))
278 FLastStatusChangeInformedSectionDate datetime YES ((0))
279 FLastStatusChangeInformedManagerDate datetime YES ((0))
280 foppaddr4 nvarchar 500 YES ('')
281 departmentid int NO ((0))
282 orgid int NO ((0))
283 fmatchedruleid int YES ((0))
284 CFdesktopType int YES ((0))
285 CFjustification ntext 1073741823 YES
286 CFnewOrExisting int YES ((0))
287 CFperipheralsDesktop nvarchar 255 YES
288 CFsoftware nvarchar 255 YES
289 CFexistingAsset nvarchar 255 YES
290 CFadministrationRights int YES ((0))
291 CFadministratorJustification nvarchar 255 YES
292 CFcostCentre int YES ((0))
293 CFrequestDetails ntext 1073741823 YES
294 CFexistingLocation nvarchar 255 YES
295 CFlaptopType int YES ((0))
296 CFmobileRequest int YES ((0))
297 CFmobilePhone int YES ((0))
298 CFjobFunction nvarchar 255 YES
299 CFcomments ntext 1073741823 YES
300 CFmobileNumber nvarchar 255 YES
301 CFsimCardNumber nvarchar 255 YES
302 CFperipherals nvarchar 255 YES
303 CFprinterRequestType int YES ((0))
304 CFprinterLocation nvarchar 255 YES
305 CFprinterMake nvarchar 255 YES
306 CFprinterColourMono int YES ((0))
307 CFpaperSize int YES ((0))
308 CFfurtherInfo nvarchar 255 YES
309 CFscanToEmail int YES ((0))
310 CFprinterName nvarchar 255 YES
311 CFnewLocation nvarchar 255 YES
312 CFfirstName nvarchar 255 YES
313 CFlastName nvarchar 255 YES
314 CFemployeeId nvarchar 255 YES
315 CFemailAddress nvarchar 255 YES
316 CFleavingDate datetime YES
317 CFstartingDate datetime YES
318 CFhardware int YES ((0))
319 CFsharedDrive int YES ((0))
320 CFaccessType int YES ((0))
321 CFsharedFilePath nvarchar 255 YES
322 CFchangeType int YES ((0))
323 CFstartDate datetime YES
324 CFendDate datetime YES
325 CFoutageRequired bit YES ((0))
326 CFoutageDuration nvarchar 255 YES
327 CFchangeDuration nvarchar 255 YES
328 CFemergencyChangeReason nvarchar 255 YES
329 fmatchedkbid int YES ((0))
330 fkbmatchdontshow bit YES ((0))
331 fhasbeenclosed bit YES ((0))
332 suppcontractid int YES ((0))
333 fopptimezonename nvarchar 255 YES ('')
334 fcreatedfromid int YES ((0))
335 fshowonroadmap bit YES ((0))
336 froadmapnote nvarchar 1000 YES ('')
337 userid int YES ((0))
338 fphonenumberfrom nvarchar 5 YES ('')
339 faddressfrom nvarchar 5 YES ('')
340 fProjectInstall bit YES ((0))
341 fProjectInternalTask bit YES ((0))
342 fInstallDate datetime YES ((0))
343 fTemplateID int NO ((0))
344 fNHServerLastChangeSeq int NO ((0))
345 FReleaseNoteGroupID int YES ((0))
346 FChangeInformationHTML nvarchar -1 YES
347 fStartTime time NO ('00:00:00')
348 fEndTime time NO ('00:00:00')
349 fbugidstring nvarchar 50 YES ('')
350 FSupplierStatus int YES ((0))
351 dateassigned datetime YES ((0))
352 fsplunkurl nvarchar 500 YES ('')
353 fsplunksearch nvarchar 500 YES ('')
354 fpagerdutyincidentidstring nvarchar 500 YES ('')
355 fbudgettype int YES ((0))
356 fthirdpartycallid nvarchar 200 YES ('')
357 estimatedays float YES ((0.00))
358 FStartTimeSlot int YES ((0))
359 FEndTimeSlot int YES ((0))
360 fappointmenttype int YES ((0))
361 GUID uniqueidentifier YES (newsequentialid())
362 FLocked bit YES ((0))
363 FHasRelatedTickets bit YES ((0))
364 CustomerRef nvarchar 50 YES ('')
365 fpagerdutyeragent int YES ((0))
366 felapsedresponsehours float YES ((0.00))
367 felapsedresolutionhours float YES ((0.00))
368 fslastartdate datetime YES ((0))
369 femailtolistsupplier nvarchar -1 YES ('')
370 femailcclistsupplier nvarchar -1 YES ('')
371 FDattoAlertState int NO ((-1))
372 fcost float YES ((0.00))
373 fquantity int YES ((0))
374 fdevopsagent nvarchar 100 YES ('')
375 FDevOpsCommentCount int YES ((0))
376 FUsingNewProjectDateStorage bit YES ((0))
377 fCreateAcknowledgement bit YES ((0))
378 FSCOMAlertState int YES ((-1))
379 Fuseful int YES ((0))
380 Fnotuseful int YES ((0))
381 FServiceNowId nvarchar 100 YES ('')
382 FOrionAlertID int YES ((0))
383 FOrionAlertActiveID int YES ((0))
384 FOrionAlertName nvarchar 200 YES ('')
385 FOrionAcknowledgeState int YES ((0))
386 FOrionCloseState int YES ((0))
387 FOrionAcknowledgedBy int YES ((0))
388 FOrionAcknowledgedByName nvarchar 100 YES ('')
389 FOrionAcknowledgeDate datetime YES ((0))
390 FOrionAcknowledgeNote nvarchar 1000 YES ('')
391 CFExistingProvider int YES ((0))
392 CFCompanyType int YES ((0))
393 CFOpportunityType int YES ((0))
394 CFHowDidTheyHear int YES ((0))
395 CFOppSize int YES ((0))
396 CFCustomerRequriementsHTML nvarchar -1 YES
397 FSplunkOnCallID nvarchar 100 YES ('')
398 FSplunkOnCallUrl nvarchar 250 YES ('')
399 FSplunkOnCallStatus int YES ((0))
400 FServiceNowNumber nvarchar 20 YES ('')
401 CFSalesRequirements image 2147483647 YES
402 CFSalesRequirementsHTML nvarchar -1 YES
403 FConnectWiseId int YES ((0))
404 FAutotaskId int YES ((-1))
405 FAutotaskNumber nvarchar 100 YES ('')
406 flaststatuschangestatusdate datetime YES ((0))
407 flaststatuschangestatus int YES ((0))
408 FAteraAlertID int YES ((0))
409 CFSiteReportNotes image 2147483647 YES
410 CFSiteReportNotesHTML nvarchar -1 YES
411 fmerakiAlertType nvarchar 100 YES ('')
412 fmerakidevicefield nvarchar 100 YES ('')
413 FLastUpdate datetime YES ((0))
414 FNinjaAlertID nvarchar 100 YES ('')
415 FConnectWiseProjectId int YES ((0))
416 FIsBillable bit YES ((1))
417 fwho nvarchar 4000 YES ('')
418 FresourceType int YES ((0))
419 FresourceBookingType int YES ((0))
420 FresourceBookingTimeslot datetime YES ((0))
421 ffafailed bit YES ((0))
422 FArticleDescription nvarchar -1 YES
423 FArticleResolution nvarchar -1 YES
424 FArticleNotes nvarchar -1 YES
425 FArticleType int YES ((0))
426 fsentinelid nvarchar 500 YES ('')
427 fazuremonitorid nvarchar 250 YES ('')
428 FSyncroAlertID int YES ((0))
429 fdomotzalertid int YES ((0))
430 FAutomateId int YES ((0))
431 FAuvikId nvarchar 100 YES ('')
432 FAuvikUrl nvarchar 1000 YES ('')
433 fslatimeremaining float YES
434 fupdateservicestatus bit YES
435 fservicestatusnote nvarchar 4000 YES
436 Fflowseq int YES
437 fsentinelurl nvarchar 600 YES
438 fsentineldisplayid int YES
439 faddigyalertid nvarchar 50 YES
440 CFSalesRequirementsPLAIN nvarchar -1 YES
441 CFSiteReportNotesPLAIN nvarchar -1 YES
442 fninjaalerttype nvarchar 200 YES ('')
443 fclosedinintegrationsystem bit YES ((0))
444 ffreshdeskid int YES
445 fnewrelicid nvarchar 500 YES
446 fnewrelicincidentid nvarchar 500 YES
447 fbackupradarid int YES
448 fbackupradarstate int YES
449 fazuretenants nvarchar 500 YES
450 fkaseyaid nvarchar 50 YES
451 fcreatedfromautomationstdid int YES
452 falluserscanview int YES ((0))
453 Ftickettags nvarchar 4000 YES
454 fsynctosalesforce bit YES
455 CFWorkingFromHome int YES ((0))
456 FOppRegion nvarchar 100 YES
457 fncdid int YES
458 FInvoiceSeperatelyOverride bit YES
459 FOverrideTicketCost float YES
460 FPurchaseOrderNumber nvarchar 1000 YES
461 fitemsarebillable bit YES
462 FOpportunityThirdPartyURL nvarchar 1000 YES
463 fclonedfromid int YES
464 fsuppliercontactid int YES
465 fdeviceautomateid int YES
466 fninjadeviceid int YES
467 fpagerdutyservice nvarchar 500 YES
468 fNHServerLastFlowChangeSeq int YES ((0))
469 fMailID nvarchar 1000 YES ('')
470 FGUID uniqueidentifier YES (newsequentialid())
471 FprId int YES
472 FbranchId int YES
473 fsmsoverride nvarchar 255 YES
474 CFTonality nvarchar 255 YES
475 CFCategorySuggestion nvarchar 255 YES
476 CFRiskCategory int YES ((0))
477 CFoppWebsite nvarchar 255 YES
478 CFoppLinkedIn nvarchar 255 YES
479 CFAISummary nvarchar 255 YES
480 CFRootCause image 2147483647 YES
481 CFRootCauseHTML nvarchar -1 YES
482 CFRootCausePLAIN nvarchar -1 YES
483 CFChangeClosureCategory int YES ((0))
484 CFChangeImplementationPlan image 2147483647 YES
485 CFChangeImplementationPlanHTML nvarchar -1 YES
486 CFChangeImplementationPlanPLAIN nvarchar -1 YES
487 CFChangePlan image 2147483647 YES
488 CFChangePlanHTML nvarchar -1 YES
489 CFChangePlanPLAIN nvarchar -1 YES
490 CFChangeTestPlan image 2147483647 YES
491 CFChangeTestPlanHTML nvarchar -1 YES
492 CFChangeTestPlanPLAIN nvarchar -1 YES
493 CFChangeBackoutPlan image 2147483647 YES
494 CFChangeBackoutPlanHTML nvarchar -1 YES
495 CFChangeBackoutPlanPLAIN nvarchar -1 YES
496 CFChangePlanMemo ntext 1073741823 YES
497 CFChangeImplementationPlanMemo ntext 1073741823 YES
498 CFChangeTestPlanMemo ntext 1073741823 YES
499 CFChangeBackoutPlanMemo ntext 1073741823 YES
500 CFAIPriority nvarchar 255 YES
501 CFAITicketType nvarchar 255 YES
502 fpipelinestage int YES
503 CFStatementOfWork image 2147483647 YES
504 CFStatementOfWorkHTML nvarchar -1 YES
505 CFStatementOfWorkPLAIN nvarchar -1 YES
506 CFExecutiveSummary image 2147483647 YES
507 CFExecutiveSummaryHTML nvarchar -1 YES
508 CFExecutiveSummaryPLAIN nvarchar -1 YES
509 Ftimesensitivemethod int YES
510 CFLabelsOpp int YES ((0))
511 CFProposalTermsAndConditions image 2147483647 YES
512 CFProposalTermsAndConditionsHTML nvarchar -1 YES
513 CFProposalTermsAndConditionsPLAIN nvarchar -1 YES
514 CFDefaultProposalOption int YES ((0))
515 CFCustomerTestimonial image 2147483647 YES
516 CFCustomerTestimonialHTML nvarchar -1 YES
517 CFCustomerTestimonialPLAIN nvarchar -1 YES
518 CFDefaultStatementOfWork int YES ((0))
519 fprojectstartdate_timezone nvarchar 100 YES
520 fopptargetdate_timezone nvarchar 100 YES
521 fthirdpartyreviewscore int YES
522 fissensitive bit YES
523 fhidefeedback bit YES
524 fcolour nvarchar 7 YES
525 fcolourrule int YES
526 foppjobtitle nvarchar 255 YES
527 FInternetMessageId nvarchar 100 YES
528 fReleaseNoteCriticalProduct int YES
529 frespondbydateadjusted bit YES
530 slaresponsereason nvarchar 4000 YES
531 categoryid2 int YES
532 categoryid3 int YES
533 categoryid4 int YES
534 categoryid5 int YES
535 faisuggestedpriority nvarchar 100 YES
536 faisuggestedresolution nvarchar -1 YES
537 faigeneratedsummary nvarchar 4000 YES
538 faisuggestedtype nvarchar 100 YES
539 faisentimentanalysis nvarchar 100 YES
540 faisatisfactionlevel nvarchar 100 YES
541 faitonality nvarchar 100 YES
542 FsearchIndexSyncTimestamp datetime YES ((0))
543 FsearchIndexSyncBatches int YES
544 FsearchIndexSyncError nvarchar 100 YES
545 faisearchquery nvarchar 100 YES
546 FembeddingMatchTimestamp datetime YES ((0))
547 CFDiagnosticProcess image 2147483647 YES
548 CFDiagnosticProcessHTML nvarchar -1 YES
549 CFDiagnosticProcessPLAIN nvarchar -1 YES
550 CFEscalationReason nvarchar 1000 YES
551 CFRecurringProblem bit YES ((0))
552 CFHardwareRequired image 2147483647 YES
553 CFHardwareRequiredHTML nvarchar -1 YES
554 CFHardwareRequiredPLAIN nvarchar -1 YES
555 CFHardwareJustification image 2147483647 YES
556 CFHardwareJustificationHTML nvarchar -1 YES
557 CFHardwareJustificationPLAIN nvarchar -1 YES
558 CFCompanyName nvarchar 255 YES
559 CFDrsFullName nvarchar 255 YES
560 CFPointOfContactName nvarchar 255 YES
561 CFAddress nvarchar 255 YES
562 CFPhoneNumber nvarchar 255 YES
563 CFFaxNumber nvarchar 255 YES
564 CFEmail nvarchar 255 YES
565 CFHowDidTheyHearAboutUs nvarchar 1000 YES
566 CFWhatServices nvarchar 1000 YES
567 CFFloorplans int YES ((0))
568 CFNewOfficeOrCurrentPractice int YES ((0))
569 CFWhatKindOfSoftware nvarchar 255 YES
570 CFHowManyOps nvarchar 255 YES
571 CFHowManyAdmins nvarchar 255 YES
572 CFBestTimeDay nvarchar 255 YES
573 CFOpportunityLostReason nvarchar 1000 YES
574 CFReEngageDate datetime YES
575 CFQualificationNotes image 2147483647 YES
576 CFQualificationNotesHTML nvarchar -1 YES
577 CFQualificationNotesPLAIN nvarchar -1 YES
578 CFWebsiteDomainName nvarchar 255 YES
579 CFEmailManagement nvarchar 255 YES
580 CFFirewallLoginCredentials nvarchar 255 YES
581 CFServerAdminCredentials nvarchar 255 YES
582 CFWorkstationCredentials nvarchar 255 YES
583 CFImagingSoftware int YES ((0))
584 CFPhoneService int YES ((0))
585 CFVOIP nvarchar 255 YES
586 CFApplicationsUsed nvarchar 255 YES
587 CFNumberOfUsers nvarchar 255 YES
588 CFMicrosoftService int YES ((0))
589 CFM365Service nvarchar 255 YES
590 CFISP nvarchar 255 YES
591 CFFirewallSettings int YES ((0))
592 CFExistingIPScheme nvarchar 255 YES
593 CFNetworkSwitches nvarchar 255 YES
594 CFWirelessAccess nvarchar 255 YES
595 CFNumberofServers nvarchar 255 YES
596 CFOperatingSystem nvarchar 255 YES
597 CFDHCPDNSADDS nvarchar 255 YES
598 CFSoftwareVersions nvarchar 255 YES
599 CFStorageSize nvarchar 255 YES
600 CFHarddriveType nvarchar 255 YES
601 CFEvents nvarchar 255 YES
602 CFErrors nvarchar 255 YES
603 CFHIPAACompliant nvarchar 255 YES
604 CFMSOffice nvarchar 255 YES
605 CF3rdpartydevices nvarchar 255 YES
606 CFVirtualization nvarchar 255 YES
607 CFWorkgroupordomain nvarchar 255 YES
608 CFExistingGroupPolicies nvarchar 255 YES
609 CFExistingRMM nvarchar 255 YES
610 CFUsers nvarchar 255 YES
611 CFUnqiueSharedAccounts nvarchar 255 YES
612 CFBackupServicesLocation nvarchar 255 YES
613 CFCriticalDataLocations nvarchar 255 YES
614 CFServerPanNAS nvarchar 255 YES
615 CFPainPoints ntext 1073741823 YES
616 datefullyclosed datetime YES ((0))
617 fagentsignatureguid nvarchar 50 YES
618 fcustomersignatureguid nvarchar 50 YES
619 fagentbookingtype int YES
620 ffirstresponsedate datetime YES ((0))
621 ffirstresponsetime float YES
622 fpandadocattachment int YES
623 faiconversationsummary nvarchar 4000 YES
624 fclienttoinvoiceid int YES
625 CFHardwareLookup nvarchar 1000 YES
626 CFRemediationPlanOverview image 2147483647 YES
627 CFRemediationPlanOverviewHTML nvarchar -1 YES
628 CFRemediationPlanOverviewPLAIN nvarchar -1 YES
629 CFRemediationPlanSuccessCriteria image 2147483647 YES
630 CFRemediationPlanSuccessCriteriaHTML nvarchar -1 YES
631 CFRemediationPlanSuccessCriteriaPLAIN nvarchar -1 YES
632 CFRemediationPlanSummary nvarchar 255 YES
633 CFRemediationServiceCancellationDate datetime YES
634 CFRemediationServicesToCancel image 2147483647 YES
635 CFRemediationServicesToCancelHTML nvarchar -1 YES
636 CFRemediationServicesToCancelPLAIN nvarchar -1 YES
637 CFServicesCancellationRequestDate datetime YES
638 CFServicesToCancel image 2147483647 YES
639 CFServicesToCancelHTML nvarchar -1 YES
640 CFServicesToCancelPLAIN nvarchar -1 YES
641 CFServicesAdded image 2147483647 YES
642 CFServicesAddedHTML nvarchar -1 YES
643 CFServicesAddedPLAIN nvarchar -1 YES
644 CFServicesRemoved image 2147483647 YES
645 CFServicesRemovedHTML nvarchar -1 YES
646 CFServicesRemovedPLAIN nvarchar -1 YES
647 CFAccountPainPoints image 2147483647 YES
648 CFAccountPainPointsHTML nvarchar -1 YES
649 CFAccountPainPointsPLAIN nvarchar -1 YES
650 CFAccountProblemRemediationRoadblocks image 2147483647 YES
651 CFAccountProblemRemediationRoadblocksHTML nvarchar -1 YES
652 CFAccountProblemRemediationRoadblocksPLAIN nvarchar -1 YES
653 CFAccountChangeSuspendBilling bit YES ((0))
654 CFAccountChangeSuspendBillingStartDate datetime YES
655 CFAccountChangeSuspendBillingEndDate datetime YES
656 CFAccountChangeServiceChangeIsOffboarding bit YES ((0))
657 CFSalesEngineeringDependencies image 2147483647 YES
658 CFSalesEngineeringDependenciesHTML nvarchar -1 YES
659 CFSalesEngineeringDependenciesPLAIN nvarchar -1 YES
660 CFSecurityAuthorizationsRemoteAccessRequest nvarchar 1000 YES
661 CFPotentialRecurringValue int YES ((0))
662 CFPotentialOneTimeValue int YES ((0))
663 CFAuthorizationsEquipment image 2147483647 YES
664 CFAuthorizationsEquipmentHTML nvarchar -1 YES
665 CFAuthorizationsEquipmentPLAIN nvarchar -1 YES
666 CFShippingLabel image 2147483647 YES
667 CFShippingLabelHTML nvarchar -1 YES
668 CFShippingLabelPLAIN nvarchar -1 YES
669 CFDeliveryEstimatedTimeArrival datetime YES
670 CFShippingTrackingNumber nvarchar 255 YES
671 CFShippingCarrier nvarchar 1000 YES
672 CFShippingSignatureRequired bit YES ((0))
673 CFShippingContact nvarchar 255 YES
674 CFAddionalAgentsJobAid ntext 1073741823 YES
675 CFEscalator int YES ((0))
676 CFEscalationDate datetime YES
677 fisdowntime bit YES
678 foppvaluemonthly float YES
679 foppvalueannual float YES
680 foppvalueoneoff float YES
681 CFReleaseInfoReleaseDate datetime YES
682 CFProjectType int YES ((0))
683 CFQuickProject bit YES ((0))
684 CFEnhancementsRequestedChange image 2147483647 YES
685 CFEnhancementsRequestedChangeHTML nvarchar -1 YES
686 CFEnhancementsRequestedChangePLAIN nvarchar -1 YES
687 CFEnhancementsActualChanges image 2147483647 YES
688 CFEnhancementsActualChangesHTML nvarchar -1 YES
689 CFEnhancementsActualChangesPLAIN nvarchar -1 YES
690 CFProblemProblem image 2147483647 YES
691 CFProblemProblemHTML nvarchar -1 YES
692 CFProblemProblemPLAIN nvarchar -1 YES
693 CFProblemStartDate datetime YES
694 CFProblemDiagnosis image 2147483647 YES
695 CFProblemDiagnosisHTML nvarchar -1 YES
696 CFProblemDiagnosisPLAIN nvarchar -1 YES
697 CFProblemSolution image 2147483647 YES
698 CFProblemSolutionHTML nvarchar -1 YES
699 CFProblemSolutionPLAIN nvarchar -1 YES
700 CFReleaseCommunicationType nvarchar 1000 YES
701 CFReleaseCommunicationContent image 2147483647 YES
702 CFReleaseCommunicationContentHTML nvarchar -1 YES
703 CFReleaseCommunicationContentPLAIN nvarchar -1 YES
704 CFReleaseCommunicationDate datetime YES
705 CFReleaseCommunicationTone nvarchar 1000 YES
706 CFReleaseCommunicationAudience nvarchar 1000 YES
707 CFDepartmentSelection nvarchar 1000 YES
708 CFApplicationUpdateApplicationName nvarchar 255 YES
709 CFApplicationUpdateApplicationCurrentVersion nvarchar 255 YES
710 CFApplicationUpdateApplicationRequestedVersion nvarchar 255 YES
711 CFApplicationUpdateReasonForUpdate image 2147483647 YES
712 CFApplicationUpdateReasonForUpdateHTML nvarchar -1 YES
713 CFApplicationUpdateReasonForUpdatePLAIN nvarchar -1 YES
714 CFApplicationUpdateApplicationLicensesRequired bit YES ((0))
715 CFApplicationUpdateIfApplicationLicensingRequiredClientPurchasedNewLicense bit YES ((0))
716 CFApplicationUpdateDoesTheVendorRequireAQuoteForLicensingChanges bit YES ((0))
717 CFApplicationUpdateDescribeDependenciesThatNeedTestedAndUpdated image 2147483647 YES
718 CFApplicationUpdateDescribeDependenciesThatNeedTestedAndUpdatedHTML nvarchar -1 YES
719 CFApplicationUpdateDescribeDependenciesThatNeedTestedAndUpdatedPLAIN nvarchar -1 YES
720 CFAppicationUpdateRequestedMainteanceWindow nvarchar 255 YES
721 CFApplicationUpdateEstimatedDowntimeHours nvarchar 255 YES
722 CFMaintenanceMaintenanceWindowConfirmed bit YES ((0))
723 CFKnowledgeLinksDTCKBArticle ntext 1073741823 YES
724 fnextreviewdate datetime YES ((0))
725 fkbpdftemplate int YES
726 ftemplatewhenlinked int YES
727 TeamId int YES
728 fstatementofworkadded bit YES
729 CFMyAccountPortalFeedback nvarchar 255 YES
730 fdeleteddate datetime YES ((0))
731 fProjectPlanType int YES
732 friskscore float YES
733 Fowningservice int YES
734 faisuggestedurgency int YES
735 faisuggestedimpact int YES
736 fmainprojectid int YES
737 fdisablemilestonemodification bit YES
738 fordersequence int YES
739 fisindexable bit YES
740 fqualificationsmatched nvarchar 4000 YES
741 nextactivityorappointmentdate datetime YES ((0))
742 fismaintenance bit YES
743 ftimezone nvarchar 100 YES
744 fbillingtype int YES
745 fticketreference nvarchar 100 YES
746 CFRemoteUsers nvarchar 1000 YES
747 CFReleaseDate datetime YES
748 faisuggestedcategory nvarchar 100 YES
749 flatitude float YES
750 flongitude float YES
751 faddressindexattempted bit YES
752 Ffirstrespondbydate datetime YES ((0))
753 Fslafirstresponsestate nvarchar 10 YES
754 CFDownPaymentPercentage nvarchar 255 YES
755 CFPaymentMethod int YES
756 CFBillingContact nvarchar 255 YES
757 CFFinancing int YES

FAULTSERVICE (7 columns)

# Column Type Length Nullable Default
1 FSfaultid int NO
2 FSstid int NO
3 fsrtid int YES ((-1))
4 fsstdid int YES ((-1))
5 fstype int YES ((0))
6 fsautolink bit YES ((0))
7 fsid int NO

FAULTTODO (12 columns)

# Column Type Length Nullable Default
1 FTfaultid int NO
2 FTseq int NO
3 FTDone bit NO ((0))
4 FTDoneby int YES
5 FTNote ntext 1073741823 YES
6 FTStartDate datetime YES
7 FTEndDate datetime YES
8 FTactualStart datetime YES
9 FTactualEnd datetime YES
10 FTsortseq int YES ((0))
11 FTaddedBy int YES
12 ftgroupid int YES

FaultBudget (11 columns)

# Column Type Length Nullable Default
1 FBTid int NO
2 FBTfaultid int NO
3 FBTbtid int NO
4 FBThours float YES
5 FBTrate float YES
6 FBTestimatedtime float YES
7 FBTestimatedmoney float YES
8 FBTactualtime float YES
9 FBTactualmoney float YES
10 FBTscheduledtime float YES ((-9999.00))
11 fbtqdid int YES

FaultMerge (17 columns)

# Column Type Length Nullable Default
1 FMid int NO
2 FMfaultid int NO
3 FMmergedIntoFaultid int NO
4 FMtimestamp datetime NO
5 FMwho int NO
6 FMoldStatus int YES
7 FMoldExcludeFromSLA bit YES
8 FMemailToListChanges nvarchar 4000 YES
9 FMemailCCListChanges nvarchar 4000 YES
10 FMattachmentIds nvarchar -1 YES
11 FMappointmentIds nvarchar -1 YES
12 FMchildTicketIds nvarchar -1 YES
13 FMunmerged bit YES
14 FMunmergedWho int YES
15 FMunmergedTimestamp datetime YES
16 fmdeviceids nvarchar -1 YES
17 FMmergetype int YES

FaultOLA (17 columns)

# Column Type Length Nullable Default
1 FOid int NO
2 FOfaultid int NO
3 FOwtid int NO
4 FOtargethours float YES
5 FOactualhours float YES
6 FOtargetdate datetime YES
7 FOstatus int YES
8 FOtargetmet bit YES
9 fostartdate datetime YES ((0))
10 fopausedate datetime YES ((0))
11 foenddate datetime YES ((0))
12 foruleid int YES
13 foteamid int YES
14 fopriorityid int YES
15 fostepid int YES
16 fostageid int YES
17 foflowid int YES

FaultWatch (4 columns)

# Column Type Length Nullable Default
1 FWfaultid int NO
2 FWunum int NO
3 fwemail nvarchar 255 YES
4 fwid int NO

FaultsTimeEntry (6 columns)

# Column Type Length Nullable Default
1 FTEID int NO
2 FTEFaultID int NO
3 FTEActionCode int NO
4 FTETime float YES
5 FTEActionBillingPlanID int YES
6 FTEValue float YES

RelatedFaults (3 columns)

# Column Type Length Nullable Default
1 rfid int NO
2 rffaultid1 int NO
3 rffaultid2 int NO
Back to top