Skip to main content

Knowledge Base - Key Tables

Full column listings for the 1 key table in this category.

KBENTRY (318 columns)

# Column Type Length Nullable Default
1 id int NO
2 abstract nvarchar 4000 YES
3 description nvarchar -1 YES
4 resolution nvarchar -1 YES
5 datecreated datetime YES
6 whocreated smallint YES
7 category1 nvarchar 10 YES
8 Nextreviewdate datetime YES
9 Lastreviewdate datetime YES
10 Reviewedby smallint YES
11 Xrefkbentry smallint YES
12 Xreftype smallint YES
13 Xrefdoc smallint YES
14 faultid int YES ((0))
15 descriptionblob varbinary -1 YES
16 descriptionhtml nvarchar -1 YES
17 resolutionblob varbinary -1 YES
18 resolutionhtml nvarchar -1 YES
19 ViewedCount int YES ((0))
20 KBuseful int YES ((0))
21 KBnotuseful int YES ((0))
22 dateedited datetime YES ((0))
23 whoedited int YES ((0))
24 CFdesktopType int YES ((0))
25 CFjustification ntext 1073741823 YES
26 CFnewOrExisting int YES ((0))
27 CFperipheralsDesktop nvarchar 400 YES
28 CFsoftware nvarchar 400 YES
29 CFexistingAsset nvarchar 400 YES
30 CFadministrationRights int YES ((0))
31 CFadministratorJustification nvarchar 400 YES
32 CFcostCentre int YES ((0))
33 CFrequestDetails ntext 1073741823 YES
34 CFexistingLocation nvarchar 400 YES
35 CFlaptopType int YES ((0))
36 CFmobileRequest int YES ((0))
37 CFmobilePhone int YES ((0))
38 CFjobFunction nvarchar 400 YES
39 CFcomments ntext 1073741823 YES
40 CFmobileNumber nvarchar 400 YES
41 CFsimCardNumber nvarchar 400 YES
42 CFperipherals nvarchar 400 YES
43 CFprinterRequestType int YES ((0))
44 CFprinterLocation nvarchar 400 YES
45 CFprinterMake nvarchar 400 YES
46 CFprinterColourMono int YES ((0))
47 CFpaperSize int YES ((0))
48 CFfurtherInfo nvarchar 400 YES
49 CFscanToEmail int YES ((0))
50 CFprinterName nvarchar 400 YES
51 CFnewLocation nvarchar 400 YES
52 CFfirstName nvarchar 400 YES
53 CFlastName nvarchar 400 YES
54 CFemployeeId nvarchar 400 YES
55 CFemailAddress nvarchar 400 YES
56 CFleavingDate datetime YES
57 CFstartingDate datetime YES
58 CFhardware int YES ((0))
59 CFsharedDrive int YES ((0))
60 CFaccessType int YES ((0))
61 CFsharedFilePath nvarchar 400 YES
62 CFchangeType int YES ((0))
63 CFstartDate datetime YES
64 CFendDate datetime YES
65 CFoutageRequired bit YES ((0))
66 CFoutageDuration nvarchar 400 YES
67 CFchangeDuration nvarchar 400 YES
68 CFemergencyChangeReason nvarchar 400 YES
69 KBkey uniqueidentifier YES
70 KBinactive bit YES ((0))
71 KBtype int YES ((0))
72 KBinternalMemo nvarchar -1 YES
73 KBServiceNowId nvarchar 100 YES ('')
74 CFExistingProvider int YES ((0))
75 CFCompanyType int YES ((0))
76 CFOpportunityType int YES ((0))
77 CFHowDidTheyHear int YES ((0))
78 CFOppSize int YES ((0))
79 CFCustomerRequriementsHTML nvarchar -1 YES
80 CFSalesRequirements image 2147483647 YES
81 CFSalesRequirementsHTML nvarchar -1 YES
82 CFSiteReportNotes image 2147483647 YES
83 CFSiteReportNotesHTML nvarchar -1 YES
84 kblimitstartdate datetime YES ((0))
85 kblimitenddate datetime YES ((0))
86 kbfreshdeskid nvarchar 100 YES ('')
87 CFWorkingFromHome int YES ((0))
88 kbtags nvarchar 4000 YES
89 kbpdftemplateid int YES
90 descriptionMarkdown nvarchar -1 YES
91 resolutionMarkdown nvarchar -1 YES
92 kbinternalmemoMarkdown nvarchar -1 YES
93 editorType int YES ((0))
94 CFTonality nvarchar 255 YES
95 CFCategorySuggestion nvarchar 255 YES
96 CFRiskCategory int YES ((0))
97 CFoppWebsite nvarchar 255 YES
98 CFoppLinkedIn nvarchar 255 YES
99 CFAISummary nvarchar 255 YES
100 CFRootCause image 2147483647 YES
101 CFRootCauseHTML nvarchar -1 YES
102 CFChangeClosureCategory int YES ((0))
103 CFChangeImplementationPlan image 2147483647 YES
104 CFChangeImplementationPlanHTML nvarchar -1 YES
105 CFChangePlan image 2147483647 YES
106 CFChangePlanHTML nvarchar -1 YES
107 CFChangeTestPlan image 2147483647 YES
108 CFChangeTestPlanHTML nvarchar -1 YES
109 CFChangeBackoutPlan image 2147483647 YES
110 CFChangeBackoutPlanHTML nvarchar -1 YES
111 CFChangePlanMemo ntext 1073741823 YES
112 CFChangeImplementationPlanMemo ntext 1073741823 YES
113 CFChangeTestPlanMemo ntext 1073741823 YES
114 CFChangeBackoutPlanMemo ntext 1073741823 YES
115 CFAIPriority nvarchar 255 YES
116 CFAITicketType nvarchar 255 YES
117 CFStatementOfWork image 2147483647 YES
118 CFStatementOfWorkHTML nvarchar -1 YES
119 CFExecutiveSummary image 2147483647 YES
120 CFExecutiveSummaryHTML nvarchar -1 YES
121 CFLabelsOpp int YES ((0))
122 CFProposalTermsAndConditions image 2147483647 YES
123 CFProposalTermsAndConditionsHTML nvarchar -1 YES
124 CFDefaultProposalOption int YES ((0))
125 CFCustomerTestimonial image 2147483647 YES
126 CFCustomerTestimonialHTML nvarchar -1 YES
127 CFDefaultStatementOfWork int YES ((0))
128 KBsearchIndexSyncTimestamp datetime YES ((0))
129 KBsearchIndexSyncBatches int YES
130 KBsearchIndexSyncError nvarchar 100 YES
131 CFDiagnosticProcess image 2147483647 YES
132 CFDiagnosticProcessHTML nvarchar -1 YES
133 CFEscalationReason nvarchar 1000 YES
134 CFRecurringProblem bit YES ((0))
135 CFHardwareRequired image 2147483647 YES
136 CFHardwareRequiredHTML nvarchar -1 YES
137 CFHardwareJustification image 2147483647 YES
138 CFHardwareJustificationHTML nvarchar -1 YES
139 CFCompanyName nvarchar 255 YES
140 CFDrsFullName nvarchar 255 YES
141 CFPointOfContactName nvarchar 255 YES
142 CFAddress nvarchar 255 YES
143 CFPhoneNumber nvarchar 255 YES
144 CFFaxNumber nvarchar 255 YES
145 CFEmail nvarchar 255 YES
146 CFHowDidTheyHearAboutUs nvarchar 1000 YES
147 CFWhatServices nvarchar 1000 YES
148 CFFloorplans int YES ((0))
149 CFNewOfficeOrCurrentPractice int YES ((0))
150 CFWhatKindOfSoftware nvarchar 255 YES
151 CFHowManyOps nvarchar 255 YES
152 CFHowManyAdmins nvarchar 255 YES
153 CFBestTimeDay nvarchar 255 YES
154 CFOpportunityLostReason nvarchar 1000 YES
155 CFReEngageDate datetime YES
156 CFQualificationNotes image 2147483647 YES
157 CFQualificationNotesHTML nvarchar -1 YES
158 CFWebsiteDomainName nvarchar 255 YES
159 CFEmailManagement nvarchar 255 YES
160 CFFirewallLoginCredentials nvarchar 255 YES
161 CFServerAdminCredentials nvarchar 255 YES
162 CFWorkstationCredentials nvarchar 255 YES
163 CFImagingSoftware int YES ((0))
164 CFPhoneService int YES ((0))
165 CFVOIP nvarchar 255 YES
166 CFApplicationsUsed nvarchar 255 YES
167 CFNumberOfUsers nvarchar 255 YES
168 CFMicrosoftService int YES ((0))
169 CFM365Service nvarchar 255 YES
170 CFISP nvarchar 255 YES
171 CFFirewallSettings int YES ((0))
172 CFExistingIPScheme nvarchar 255 YES
173 CFNetworkSwitches nvarchar 255 YES
174 CFWirelessAccess nvarchar 255 YES
175 CFNumberofServers nvarchar 255 YES
176 CFOperatingSystem nvarchar 255 YES
177 CFDHCPDNSADDS nvarchar 255 YES
178 CFSoftwareVersions nvarchar 255 YES
179 CFStorageSize nvarchar 255 YES
180 CFHarddriveType nvarchar 255 YES
181 CFEvents nvarchar 255 YES
182 CFErrors nvarchar 255 YES
183 CFHIPAACompliant nvarchar 255 YES
184 CFMSOffice nvarchar 255 YES
185 CF3rdpartydevices nvarchar 255 YES
186 CFVirtualization nvarchar 255 YES
187 CFWorkgroupordomain nvarchar 255 YES
188 CFExistingGroupPolicies nvarchar 255 YES
189 CFExistingRMM nvarchar 255 YES
190 CFUsers nvarchar 255 YES
191 CFUnqiueSharedAccounts nvarchar 255 YES
192 CFBackupServicesLocation nvarchar 255 YES
193 CFCriticalDataLocations nvarchar 255 YES
194 CFServerPanNAS nvarchar 255 YES
195 CFPainPoints ntext 1073741823 YES
196 CFHardwareLookup nvarchar 1000 YES
197 CFRemediationPlanOverview image 2147483647 YES
198 CFRemediationPlanOverviewHTML nvarchar -1 YES
199 CFRemediationPlanSuccessCriteria image 2147483647 YES
200 CFRemediationPlanSuccessCriteriaHTML nvarchar -1 YES
201 CFRemediationPlanSummary nvarchar 255 YES
202 CFRemediationServiceCancellationDate datetime YES
203 CFRemediationServicesToCancel image 2147483647 YES
204 CFRemediationServicesToCancelHTML nvarchar -1 YES
205 CFServicesCancellationRequestDate datetime YES
206 CFServicesToCancel image 2147483647 YES
207 CFServicesToCancelHTML nvarchar -1 YES
208 CFServicesAdded image 2147483647 YES
209 CFServicesAddedHTML nvarchar -1 YES
210 CFServicesRemoved image 2147483647 YES
211 CFServicesRemovedHTML nvarchar -1 YES
212 CFAccountPainPoints image 2147483647 YES
213 CFAccountPainPointsHTML nvarchar -1 YES
214 CFAccountProblemRemediationRoadblocks image 2147483647 YES
215 CFAccountProblemRemediationRoadblocksHTML nvarchar -1 YES
216 CFAccountChangeSuspendBilling bit YES ((0))
217 CFAccountChangeSuspendBillingStartDate datetime YES
218 CFAccountChangeSuspendBillingEndDate datetime YES
219 CFAccountChangeServiceChangeIsOffboarding bit YES ((0))
220 CFSalesEngineeringDependencies image 2147483647 YES
221 CFSalesEngineeringDependenciesHTML nvarchar -1 YES
222 CFSecurityAuthorizationsRemoteAccessRequest nvarchar 1000 YES
223 CFPotentialRecurringValue int YES ((0))
224 CFPotentialOneTimeValue int YES ((0))
225 CFAuthorizationsEquipment image 2147483647 YES
226 CFAuthorizationsEquipmentHTML nvarchar -1 YES
227 CFShippingLabel image 2147483647 YES
228 CFShippingLabelHTML nvarchar -1 YES
229 CFDeliveryEstimatedTimeArrival datetime YES
230 CFShippingTrackingNumber nvarchar 255 YES
231 CFShippingCarrier nvarchar 1000 YES
232 CFShippingSignatureRequired bit YES ((0))
233 CFShippingContact nvarchar 255 YES
234 CFAddionalAgentsJobAid ntext 1073741823 YES
235 CFEscalator int YES ((0))
236 CFEscalationDate datetime YES
237 kbtickettemplateid int YES
238 CFReleaseInfoReleaseDate datetime YES
239 CFProjectType int YES ((0))
240 CFQuickProject bit YES ((0))
241 CFEnhancementsRequestedChange image 2147483647 YES
242 CFEnhancementsRequestedChangeHTML nvarchar -1 YES
243 CFEnhancementsActualChanges image 2147483647 YES
244 CFEnhancementsActualChangesHTML nvarchar -1 YES
245 CFProblemProblem image 2147483647 YES
246 CFProblemProblemHTML nvarchar -1 YES
247 CFProblemStartDate datetime YES
248 CFProblemDiagnosis image 2147483647 YES
249 CFProblemDiagnosisHTML nvarchar -1 YES
250 CFProblemSolution image 2147483647 YES
251 CFProblemSolutionHTML nvarchar -1 YES
252 CFReleaseCommunicationType nvarchar 1000 YES
253 CFReleaseCommunicationContent image 2147483647 YES
254 CFReleaseCommunicationContentHTML nvarchar -1 YES
255 CFReleaseCommunicationDate datetime YES
256 CFReleaseCommunicationTone nvarchar 1000 YES
257 CFReleaseCommunicationAudience nvarchar 1000 YES
258 CFDepartmentSelection nvarchar 1000 YES
259 CFApplicationUpdateApplicationName nvarchar 255 YES
260 CFApplicationUpdateApplicationCurrentVersion nvarchar 255 YES
261 CFApplicationUpdateApplicationRequestedVersion nvarchar 255 YES
262 CFApplicationUpdateReasonForUpdate image 2147483647 YES
263 CFApplicationUpdateReasonForUpdateHTML nvarchar -1 YES
264 CFApplicationUpdateApplicationLicensesRequired bit YES ((0))
265 CFApplicationUpdateIfApplicationLicensingRequiredClientPurchasedNewLicense bit YES ((0))
266 CFApplicationUpdateDoesTheVendorRequireAQuoteForLicensingChanges bit YES ((0))
267 CFApplicationUpdateDescribeDependenciesThatNeedTestedAndUpdated image 2147483647 YES
268 CFApplicationUpdateDescribeDependenciesThatNeedTestedAndUpdatedHTML nvarchar -1 YES
269 CFAppicationUpdateRequestedMainteanceWindow nvarchar 255 YES
270 CFApplicationUpdateEstimatedDowntimeHours nvarchar 255 YES
271 CFMaintenanceMaintenanceWindowConfirmed bit YES ((0))
272 CFKnowledgeLinksDTCKBArticle ntext 1073741823 YES
273 userwhocreated int YES
274 CFMyAccountPortalFeedback nvarchar 255 YES
275 kbaigeneratedsummary nvarchar 1000 YES
276 agentviewedcount int YES ((0))
277 CFRemoteUsers nvarchar 1000 YES
278 CFReleaseDate datetime YES
279 CFSalesRequirementsPLAIN nvarchar -1 YES
280 CFSiteReportNotesPLAIN nvarchar -1 YES
281 CFRootCausePLAIN nvarchar -1 YES
282 CFChangeImplementationPlanPLAIN nvarchar -1 YES
283 CFChangePlanPLAIN nvarchar -1 YES
284 CFChangeTestPlanPLAIN nvarchar -1 YES
285 CFChangeBackoutPlanPLAIN nvarchar -1 YES
286 CFStatementOfWorkPLAIN nvarchar -1 YES
287 CFExecutiveSummaryPLAIN nvarchar -1 YES
288 CFProposalTermsAndConditionsPLAIN nvarchar -1 YES
289 CFCustomerTestimonialPLAIN nvarchar -1 YES
290 CFDiagnosticProcessPLAIN nvarchar -1 YES
291 CFHardwareRequiredPLAIN nvarchar -1 YES
292 CFHardwareJustificationPLAIN nvarchar -1 YES
293 CFQualificationNotesPLAIN nvarchar -1 YES
294 CFRemediationPlanOverviewPLAIN nvarchar -1 YES
295 CFRemediationPlanSuccessCriteriaPLAIN nvarchar -1 YES
296 CFRemediationServicesToCancelPLAIN nvarchar -1 YES
297 CFServicesToCancelPLAIN nvarchar -1 YES
298 CFServicesAddedPLAIN nvarchar -1 YES
299 CFServicesRemovedPLAIN nvarchar -1 YES
300 CFAccountPainPointsPLAIN nvarchar -1 YES
301 CFAccountProblemRemediationRoadblocksPLAIN nvarchar -1 YES
302 CFSalesEngineeringDependenciesPLAIN nvarchar -1 YES
303 CFAuthorizationsEquipmentPLAIN nvarchar -1 YES
304 CFShippingLabelPLAIN nvarchar -1 YES
305 CFEnhancementsRequestedChangePLAIN nvarchar -1 YES
306 CFEnhancementsActualChangesPLAIN nvarchar -1 YES
307 CFProblemProblemPLAIN nvarchar -1 YES
308 CFProblemDiagnosisPLAIN nvarchar -1 YES
309 CFProblemSolutionPLAIN nvarchar -1 YES
310 CFReleaseCommunicationContentPLAIN nvarchar -1 YES
311 CFApplicationUpdateReasonForUpdatePLAIN nvarchar -1 YES
312 CFApplicationUpdateDescribeDependenciesThatNeedTestedAndUpdatedPLAIN nvarchar -1 YES
313 kbdocneedsprocessing bit YES
314 kbdocprocessed bit YES
315 CFDownPaymentPercentage nvarchar 255 YES
316 CFPaymentMethod int YES
317 CFBillingContact nvarchar 255 YES
318 CFFinancing int YES
Back to top