Skip to main content

Users & Contacts - Key Tables

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

USERS (217 columns)

# Column Type Length Nullable Default
1 Usite float NO
2 uusername nvarchar 255 NO
3 uextn nvarchar 4000 YES
4 umobile nvarchar 4000 YES
5 ufax nvarchar 4000 YES
6 uemail nvarchar 4000 YES
7 Uinv1 int YES
8 Uinv2 int YES
9 Uinv3 int YES
10 Uinv4 int YES
11 Unotes ntext 1073741823 YES
12 uactived nvarchar 4000 YES
13 Uslaid int YES
14 uother1 nvarchar 4000 YES
15 uother2 nvarchar 4000 YES
16 uother3 nvarchar 4000 YES
17 uother4 nvarchar 4000 YES
18 uother5 nvarchar 4000 YES
19 Ulogin nvarchar 4000 YES
20 UPIN nvarchar 4000 YES
21 udontackemails bit NO ((0))
22 Uviewscope int YES ((0))
23 Ushowmeonly int YES ((1))
24 Ushowrecentonly int YES ((0))
25 uinform bit NO ((0))
26 Uinv1site int YES ((0))
27 Uinv2site int YES ((0))
28 Uinv3site int YES ((0))
29 Uinv4site int YES ((0))
30 Uinv5 int YES ((0))
31 Uinv6 int YES ((0))
32 Uinv7 int YES ((0))
33 Uinv8 int YES ((0))
34 Uinv9 int YES ((0))
35 Uinv10 int YES ((0))
36 Uinv5site int YES ((0))
37 Uinv6site int YES ((0))
38 Uinv7site int YES ((0))
39 Uinv8site int YES ((0))
40 Uinv9site int YES ((0))
41 Uinv10site int YES ((0))
42 uinformaction bit NO ((0))
43 uinformclearance bit NO ((0))
44 uinactive bit NO ((0))
45 umobile2 nvarchar 4000 YES
46 Uinv11 int YES ((0))
47 Uinv12 int YES ((0))
48 Uinv13 int YES ((0))
49 Uinv14 int YES ((0))
50 Uinv15 int YES ((0))
51 Uinv16 int YES ((0))
52 Uinv17 int YES ((0))
53 Uinv18 int YES ((0))
54 Uinv19 int YES ((0))
55 Uinv20 int YES ((0))
56 Uinv21 int YES ((0))
57 Uinv22 int YES ((0))
58 Uinv23 int YES ((0))
59 Uinv24 int YES ((0))
60 Uinv25 int YES ((0))
61 Uinv11site int YES ((0))
62 Uinv12site int YES ((0))
63 Uinv13site int YES ((0))
64 Uinv14site int YES ((0))
65 Uinv15site int YES ((0))
66 Uinv16site int YES ((0))
67 Uinv17site int YES ((0))
68 Uinv18site int YES ((0))
69 Uinv19site int YES ((0))
70 Uinv20site int YES ((0))
71 Uinv21site int YES ((0))
72 Uinv22site int YES ((0))
73 Uinv23site int YES ((0))
74 Uinv24site int YES ((0))
75 Uinv25site int YES ((0))
76 UShowSLATimes bit NO ((0))
77 UTitle nvarchar 4000 YES
78 Useriousnesslevel int YES ((0))
79 UcanAdd bit NO ((0))
80 UAllowViewSiteDocs bit NO ((0))
81 UActGuid nvarchar 4000 YES
82 UisChangeApprover bit NO ((0))
83 UCanCreateUser bit NO ((0))
84 Udepartment int YES ((0))
85 UIsHeadofDept bit NO ((0))
86 UdeputySite int YES ((0))
87 UdeputyUsername nvarchar 4000 YES
88 utelhome nvarchar 4000 YES
89 utelpref int YES ((0))
90 ucat2 ntext 1073741823 YES
91 Ulastlogindate datetime YES
92 UNeverSendEmails bit NO ((0))
93 uemail2 nvarchar 4000 YES
94 uemail3 nvarchar 4000 YES
95 UisContractContact bit NO ((0))
96 Uchangeseq int YES ((1))
97 uinformnewarea bit NO ((0))
98 uinformactionarea bit NO ((0))
99 uinformclearancearea bit NO ((0))
100 Uid int NO ((0))
101 UDisclaimerMatchString nvarchar 4000 YES
102 uviewallcleared bit YES ((0))
103 Uphoto varbinary -1 YES
104 UTwitterScreenName nvarchar 4000 YES ('')
105 UFacebookID bigint YES ((0))
106 uisexternal bit YES ((0))
107 uquestion1 int YES ((0))
108 uanswer1 nvarchar 4000 YES ('')
109 uquestion2 int YES ((0))
110 uanswer2 nvarchar 4000 YES ('')
111 uquestion3 int YES ((0))
112 uanswer3 nvarchar 4000 YES ('')
113 uquestion4 int YES ((0))
114 uanswer4 nvarchar 4000 YES ('')
115 uquestion5 int YES ((0))
116 uanswer5 nvarchar 4000 YES ('')
117 UDontAddToMailingList bit YES ((0))
118 uFirstName nvarchar 200 YES
119 uLastName nvarchar 200 YES
120 UCanEditWebDetails bit YES ((0))
121 Ucataloglevel int YES ((1))
122 Ucanaccesscatalog bit YES ((1))
123 UIsImportantContact bit YES ((0))
124 Uhasbeentrained bit YES ((0))
125 UADManager nvarchar 1000 YES ('')
126 UCanViewContracts bit YES ((0))
127 uSalt nvarchar 255 YES ('')
128 uIterations int YES ((0))
129 UIsPOApprover bit YES ((0))
130 UencMethod int YES ((0))
131 uadconnection int YES ((-1))
132 uUseADWebLogin int YES ((0))
133 USnowID int NO ((-1))
134 ulinkedagentid int YES ((0))
135 UPopupNote nvarchar 1000 YES ('')
136 UImportType int NO ((0))
137 UPWDResetStatus int NO ((0))
138 UPWDResetDate datetime YES ((0))
139 UPWDResetString nvarchar 500 YES ('')
140 UCN nvarchar 500 YES ('')
141 udatecreated datetime YES ((0))
142 UAzureOID nvarchar 1000 YES ('')
143 uShowAllUserDashboardButtons bit YES ((1))
144 ucautomateid int YES ((0))
145 uOnPremiseDN nvarchar 1000 YES ('')
146 UJiraID nvarchar 50 YES ('')
147 uphotoBase64 varchar -1 YES ('')
148 UDelegationActivated bit YES ((0))
149 UDelegationTimeBased bit YES ((0))
150 UDelegationStart datetime YES ((0))
151 UDelegationEnd datetime YES ((0))
152 UDelegateUid int YES ((0))
153 UGWid nvarchar 50 YES ('')
154 UServiceNowId nvarchar 100 YES ('')
155 UServiceNowUsername nvarchar 250 YES ('')
156 USGatewayId nvarchar 200 YES ('')
157 UConnectWiseId int YES ((0))
158 UAutotaskId int YES ((-1))
159 ucanaccessinvoices bit YES ((0))
160 USamAccountName nvarchar 250 YES ('')
161 UOktaId nvarchar 250 YES ('')
162 ULastUpdate datetime YES ((0))
163 ulocked bit YES ((0))
164 uallowviewclientdocs bit YES ((0))
165 UAzureTenantId nvarchar 100 YES ('')
166 UAzureLastLoginDate datetime YES ((0))
167 ulinkeduserid int YES
168 umessagegroup int YES
169 upassportalid bigint YES
170 UHubSpotId nvarchar 100 YES
171 UHubSpotUrl nvarchar 1000 YES
172 UHubSpotDontSync bit YES ((0))
173 UHubSpotArchived bit YES ((0))
174 uoppid int YES
175 uunsubscribed bit YES
176 uisserviceaccount bit YES ((0))
177 ucanviewopps bit YES ((0))
178 usalesforcedontsync bit YES
179 uiscommsuser bit YES
180 uactsql nvarchar 50 YES
181 uisimportantcontact2 bit YES
182 uischangeapprover2 bit YES
183 UFacebookUsername nvarchar 250 YES
184 UTwitterId bigint YES
185 udevicescope int YES
186 udontackemails2 bit YES ((1))
187 UInstagramId bigint YES
188 UInstagramUsername nvarchar 200 YES
189 uignoreautomatedbilling bit YES
190 ujirainstance int YES ((1))
191 userviceaccountoverridden bit YES
192 usendaccountsemails bit YES
193 uinformifack bit YES
194 uinformnewareaifack bit YES
195 Uneversendmarketingemails bit YES
196 Uisprospect bit YES ((0))
197 Uwhatsappnumber nvarchar 20 YES
198 utelhomeint bigint YES
199 uextnint bigint YES
200 umobileint bigint YES
201 umobile2int bigint YES
202 ufaxint bigint YES
203 ucanuploaddocuments bit YES
204 udateofbirth datetime YES ((0))
205 CFReceiveMonthlyInfraReport bit YES ((0))
206 CFIsDecisionMaker bit YES ((0))
207 uapprovernotehint nvarchar 200 YES
208 UFederatedIdentityId nvarchar 100 YES
209 Udynamicscrmdetailsid int YES
210 uquotescope int YES ((10))
211 uarea int YES
212 udatelicencesremoved datetime YES ((0))
213 uoutofofficestart datetime YES ((0))
214 uoutofofficeend datetime YES ((0))
215 uoutofofficemessage nvarchar 500 YES
216 uinvoicescope int YES ((0))
217 udelegationoutofoffice bit YES
Back to top