-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathTrackerData.xsd
379 lines (378 loc) · 57.2 KB
/
TrackerData.xsd
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="TrackerData" targetNamespace="http://tempuri.org/Recruits.xsd" xmlns:mstns="http://tempuri.org/Recruits.xsd" xmlns="http://tempuri.org/Recruits.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
<xs:annotation>
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
<DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
<Connections>
<Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="CHCRConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="CHCRConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Tracker.My.MySettings.GlobalReference.Default.CHCRConnectionString" Provider="System.Data.SqlClient">
</Connection>
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="todo_by_type_counts_vwTableAdapter" GeneratorDataComponentClassName="todo_by_type_counts_vwTableAdapter" Name="todo_by_type_counts_vw" UserDataComponentName="todo_by_type_counts_vwTableAdapter">
<MainSource>
<DbSource ConnectionRef="CHCRConnectionString (MySettings)" DbObjectName="CHCR.dbo.ToDo_By_Type_vw" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="True">
<CommandText>select study, tobedone, coalesce(persontype, 'N/A') as persontype, count(*) as num
from todo_by_type_vw
where study = @study
group by study, tobedone, persontype
</CommandText>
<Parameters>
<Parameter AllowDbNull="False" AutogeneratedName="study" ColumnName="Study" DataSourceName="CHCR.dbo.ToDo_By_Type_vw" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@study" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Study" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="tobedone" DataSetColumn="tobedone" />
<Mapping SourceColumn="num" DataSetColumn="num" />
<Mapping SourceColumn="persontype" DataSetColumn="persontype" />
<Mapping SourceColumn="study" DataSetColumn="study" />
</Mappings>
<Sources>
</Sources>
</TableAdapter>
</Tables>
<Sources>
</Sources>
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="TrackerData" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="TrackerData" msprop:Generator_DataSetName="TrackerData">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="Studies" msprop:Generator_UserTableName="Studies" msprop:Generator_RowDeletedName="StudiesRowDeleted" msprop:Generator_RowChangedName="StudiesRowChanged" msprop:Generator_RowClassName="StudiesRow" msprop:Generator_RowChangingName="StudiesRowChanging" msprop:Generator_RowEvArgName="StudiesRowChangeEvent" msprop:Generator_RowEvHandlerName="StudiesRowChangeEventHandler" msprop:Generator_TableClassName="StudiesDataTable" msprop:Generator_TableVarName="tableStudies" msprop:Generator_RowDeletingName="StudiesRowDeleting" msprop:Generator_TablePropName="Studies">
<xs:complexType>
<xs:sequence>
<xs:element name="Study" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Study" msprop:Generator_ColumnPropNameInRow="Study" msprop:Generator_ColumnVarNameInTable="columnStudy" msprop:Generator_ColumnPropNameInTable="StudyColumn" type="xs:int" />
<xs:element name="StudyName" msprop:Generator_UserColumnName="StudyName" msprop:Generator_ColumnPropNameInRow="StudyName" msprop:Generator_ColumnVarNameInTable="columnStudyName" msprop:Generator_ColumnPropNameInTable="StudyNameColumn" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Statuses" msprop:Generator_UserTableName="Statuses" msprop:Generator_RowDeletedName="StatusesRowDeleted" msprop:Generator_RowChangedName="StatusesRowChanged" msprop:Generator_RowClassName="StatusesRow" msprop:Generator_RowChangingName="StatusesRowChanging" msprop:Generator_RowEvArgName="StatusesRowChangeEvent" msprop:Generator_RowEvHandlerName="StatusesRowChangeEventHandler" msprop:Generator_TableClassName="StatusesDataTable" msprop:Generator_TableVarName="tableStatuses" msprop:Generator_RowDeletingName="StatusesRowDeleting" msprop:Generator_TablePropName="Statuses">
<xs:complexType>
<xs:sequence>
<xs:element name="Status" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" type="xs:int" />
<xs:element name="Study" msprop:Generator_UserColumnName="Study" msprop:Generator_ColumnPropNameInRow="Study" msprop:Generator_ColumnVarNameInTable="columnStudy" msprop:Generator_ColumnPropNameInTable="StudyColumn" type="xs:int" />
<xs:element name="StatusDescription" msprop:Generator_UserColumnName="StatusDescription" msprop:Generator_ColumnPropNameInRow="StatusDescription" msprop:Generator_ColumnVarNameInTable="columnStatusDescription" msprop:Generator_ColumnPropNameInTable="StatusDescriptionColumn" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="RecruitStatuses" msprop:Generator_UserTableName="RecruitStatuses" msprop:Generator_RowDeletedName="RecruitStatusesRowDeleted" msprop:Generator_RowChangedName="RecruitStatusesRowChanged" msprop:Generator_RowClassName="RecruitStatusesRow" msprop:Generator_RowChangingName="RecruitStatusesRowChanging" msprop:Generator_RowEvArgName="RecruitStatusesRowChangeEvent" msprop:Generator_RowEvHandlerName="RecruitStatusesRowChangeEventHandler" msprop:Generator_TableClassName="RecruitStatusesDataTable" msprop:Generator_TableVarName="tableRecruitStatuses" msprop:Generator_RowDeletingName="RecruitStatusesRowDeleting" msprop:Generator_TablePropName="RecruitStatuses" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element name="RecruitID" msprop:Generator_UserColumnName="RecruitID" msprop:Generator_ColumnPropNameInRow="RecruitID" msprop:Generator_ColumnVarNameInTable="columnRecruitID" msprop:Generator_ColumnPropNameInTable="RecruitIDColumn" type="xs:int" />
<xs:element name="StatusDate" msprop:Generator_UserColumnName="StatusDate" msprop:Generator_ColumnPropNameInRow="StatusDate" msprop:Generator_ColumnVarNameInTable="columnStatusDate" msprop:Generator_ColumnPropNameInTable="StatusDateColumn" type="xs:dateTime" />
<xs:element name="Status" msprop:Generator_UserColumnName="Status" msprop:Generator_ColumnPropNameInRow="Status" msprop:Generator_ColumnVarNameInTable="columnStatus" msprop:Generator_ColumnPropNameInTable="StatusColumn" type="xs:int" />
<xs:element name="AddedBy" msprop:Generator_UserColumnName="AddedBy" msprop:Generator_ColumnPropNameInRow="AddedBy" msprop:Generator_ColumnVarNameInTable="columnAddedBy" msprop:Generator_ColumnPropNameInTable="AddedByColumn" type="xs:string" minOccurs="0" />
<xs:element name="AddedDate" msprop:Generator_UserColumnName="AddedDate" msprop:Generator_ColumnPropNameInRow="AddedDate" msprop:Generator_ColumnVarNameInTable="columnAddedDate" msprop:Generator_ColumnPropNameInTable="AddedDateColumn" type="xs:dateTime" minOccurs="0" />
<xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:string" minOccurs="0" />
<xs:element name="ModifiedDate" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ContactTypes" msprop:Generator_UserTableName="ContactTypes" msprop:Generator_RowDeletedName="ContactTypesRowDeleted" msprop:Generator_RowChangedName="ContactTypesRowChanged" msprop:Generator_RowClassName="ContactTypesRow" msprop:Generator_RowChangingName="ContactTypesRowChanging" msprop:Generator_RowEvArgName="ContactTypesRowChangeEvent" msprop:Generator_RowEvHandlerName="ContactTypesRowChangeEventHandler" msprop:Generator_TableClassName="ContactTypesDataTable" msprop:Generator_TableVarName="tableContactTypes" msprop:Generator_RowDeletingName="ContactTypesRowDeleting" msprop:Generator_TablePropName="ContactTypes">
<xs:complexType>
<xs:sequence>
<xs:element name="ContactType" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ContactType" msprop:Generator_ColumnPropNameInRow="ContactType" msprop:Generator_ColumnVarNameInTable="columnContactType" msprop:Generator_ColumnPropNameInTable="ContactTypeColumn" type="xs:int" />
<xs:element name="ContactTypeDescription" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ContactTypeDescription" msprop:Generator_ColumnPropNameInRow="ContactTypeDescription" msprop:Generator_ColumnVarNameInTable="columnContactTypeDescription" msprop:Generator_ColumnPropNameInTable="ContactTypeDescriptionColumn" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="RecruitContacts" msprop:Generator_UserTableName="RecruitContacts" msprop:Generator_RowDeletedName="RecruitContactsRowDeleted" msprop:Generator_RowChangedName="RecruitContactsRowChanged" msprop:Generator_RowClassName="RecruitContactsRow" msprop:Generator_RowChangingName="RecruitContactsRowChanging" msprop:Generator_RowEvArgName="RecruitContactsRowChangeEvent" msprop:Generator_RowEvHandlerName="RecruitContactsRowChangeEventHandler" msprop:Generator_TableClassName="RecruitContactsDataTable" msprop:Generator_TableVarName="tableRecruitContacts" msprop:Generator_RowDeletingName="RecruitContactsRowDeleting" msprop:Generator_TablePropName="RecruitContacts" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element name="RecruitID" msdata:ReadOnly="true" msprop:Generator_UserColumnName="RecruitID" msprop:Generator_ColumnPropNameInRow="RecruitID" msprop:Generator_ColumnVarNameInTable="columnRecruitID" msprop:Generator_ColumnPropNameInTable="RecruitIDColumn" type="xs:int" />
<xs:element name="ContactDate" msprop:Generator_UserColumnName="ContactDate" msprop:Generator_ColumnPropNameInRow="ContactDate" msprop:Generator_ColumnVarNameInTable="columnContactDate" msprop:Generator_ColumnPropNameInTable="ContactDateColumn" type="xs:dateTime" />
<xs:element name="Initiator" msprop:Generator_UserColumnName="Initiator" msprop:Generator_ColumnPropNameInRow="Initiator" msprop:Generator_ColumnVarNameInTable="columnInitiator" msprop:Generator_ColumnPropNameInTable="InitiatorColumn" type="xs:string" />
<xs:element name="Result" msprop:Generator_UserColumnName="Result" msprop:Generator_ColumnPropNameInRow="Result" msprop:Generator_ColumnVarNameInTable="columnResult" msprop:Generator_ColumnPropNameInTable="ResultColumn" type="xs:string" minOccurs="0" />
<xs:element name="Notes" msprop:Generator_UserColumnName="Notes" msprop:Generator_ColumnPropNameInRow="Notes" msprop:Generator_ColumnVarNameInTable="columnNotes" msprop:Generator_ColumnPropNameInTable="NotesColumn" type="xs:string" minOccurs="0" />
<xs:element name="ContactType" msprop:Generator_UserColumnName="ContactType" msprop:Generator_ColumnPropNameInRow="ContactType" msprop:Generator_ColumnVarNameInTable="columnContactType" msprop:Generator_ColumnPropNameInTable="ContactTypeColumn" type="xs:int" />
<xs:element name="AddedBy" msdata:ReadOnly="true" msprop:Generator_UserColumnName="AddedBy" msprop:Generator_ColumnPropNameInRow="AddedBy" msprop:Generator_ColumnVarNameInTable="columnAddedBy" msprop:Generator_ColumnPropNameInTable="AddedByColumn" type="xs:string" minOccurs="0" />
<xs:element name="AddedDate" msdata:ReadOnly="true" msprop:Generator_UserColumnName="AddedDate" msprop:Generator_ColumnPropNameInRow="AddedDate" msprop:Generator_ColumnVarNameInTable="columnAddedDate" msprop:Generator_ColumnPropNameInTable="AddedDateColumn" type="xs:dateTime" minOccurs="0" />
<xs:element name="ModifiedBy" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:string" minOccurs="0" />
<xs:element name="ModifiedDate" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PhoneNumberTypes" msprop:Generator_UserTableName="PhoneNumberTypes" msprop:Generator_RowDeletedName="PhoneNumberTypesRowDeleted" msprop:Generator_RowChangedName="PhoneNumberTypesRowChanged" msprop:Generator_RowClassName="PhoneNumberTypesRow" msprop:Generator_RowChangingName="PhoneNumberTypesRowChanging" msprop:Generator_RowEvArgName="PhoneNumberTypesRowChangeEvent" msprop:Generator_RowEvHandlerName="PhoneNumberTypesRowChangeEventHandler" msprop:Generator_TableClassName="PhoneNumberTypesDataTable" msprop:Generator_TableVarName="tablePhoneNumberTypes" msprop:Generator_RowDeletingName="PhoneNumberTypesRowDeleting" msprop:Generator_TablePropName="PhoneNumberTypes">
<xs:complexType>
<xs:sequence>
<xs:element name="Type" msdata:ReadOnly="true" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="PhoneNumbers" msprop:Generator_UserTableName="PhoneNumbers" msprop:Generator_RowDeletedName="PhoneNumbersRowDeleted" msprop:Generator_RowChangedName="PhoneNumbersRowChanged" msprop:Generator_RowClassName="PhoneNumbersRow" msprop:Generator_RowChangingName="PhoneNumbersRowChanging" msprop:Generator_RowEvArgName="PhoneNumbersRowChangeEvent" msprop:Generator_RowEvHandlerName="PhoneNumbersRowChangeEventHandler" msprop:Generator_TableClassName="PhoneNumbersDataTable" msprop:Generator_TableVarName="tablePhoneNumbers" msprop:Generator_RowDeletingName="PhoneNumbersRowDeleting" msprop:Generator_TablePropName="PhoneNumbers" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element name="RecruitID" msprop:Generator_UserColumnName="RecruitID" msprop:Generator_ColumnPropNameInRow="RecruitID" msprop:Generator_ColumnVarNameInTable="columnRecruitID" msprop:Generator_ColumnPropNameInTable="RecruitIDColumn" type="xs:int" />
<xs:element name="AreaCode" msprop:Generator_UserColumnName="AreaCode" msprop:Generator_ColumnPropNameInRow="AreaCode" msprop:Generator_ColumnVarNameInTable="columnAreaCode" msprop:Generator_ColumnPropNameInTable="AreaCodeColumn" type="xs:string" />
<xs:element name="PhoneNumber" msprop:Generator_UserColumnName="PhoneNumber" msprop:Generator_ColumnPropNameInRow="PhoneNumber" msprop:Generator_ColumnVarNameInTable="columnPhoneNumber" msprop:Generator_ColumnPropNameInTable="PhoneNumberColumn" type="xs:string" />
<xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn" type="xs:string" />
<xs:element name="Source" msprop:Generator_UserColumnName="Source" msprop:Generator_ColumnPropNameInRow="Source" msprop:Generator_ColumnVarNameInTable="columnSource" msprop:Generator_ColumnPropNameInTable="SourceColumn" type="xs:string" />
<xs:element name="Extension" msprop:Generator_UserColumnName="Extension" msprop:Generator_ColumnPropNameInRow="Extension" msprop:Generator_ColumnVarNameInTable="columnExtension" msprop:Generator_ColumnPropNameInTable="ExtensionColumn" type="xs:string" minOccurs="0" />
<xs:element name="AddedBy" msdata:ReadOnly="true" msprop:Generator_UserColumnName="AddedBy" msprop:Generator_ColumnPropNameInRow="AddedBy" msprop:Generator_ColumnVarNameInTable="columnAddedBy" msprop:Generator_ColumnPropNameInTable="AddedByColumn" type="xs:string" minOccurs="0" />
<xs:element name="AddedDate" msdata:ReadOnly="true" msprop:Generator_UserColumnName="AddedDate" msprop:Generator_ColumnPropNameInRow="AddedDate" msprop:Generator_ColumnVarNameInTable="columnAddedDate" msprop:Generator_ColumnPropNameInTable="AddedDateColumn" type="xs:dateTime" minOccurs="0" />
<xs:element name="ModifiedBy" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:string" minOccurs="0" />
<xs:element name="ModifiedDate" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Addresses" msprop:Generator_UserTableName="Addresses" msprop:Generator_RowDeletedName="AddressesRowDeleted" msprop:Generator_RowChangedName="AddressesRowChanged" msprop:Generator_RowClassName="AddressesRow" msprop:Generator_RowChangingName="AddressesRowChanging" msprop:Generator_RowEvArgName="AddressesRowChangeEvent" msprop:Generator_RowEvHandlerName="AddressesRowChangeEventHandler" msprop:Generator_TableClassName="AddressesDataTable" msprop:Generator_TableVarName="tableAddresses" msprop:Generator_RowDeletingName="AddressesRowDeleting" msprop:Generator_TablePropName="Addresses">
<xs:complexType>
<xs:sequence>
<xs:element name="AddressID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="AddressID" msprop:Generator_ColumnPropNameInRow="AddressID" msprop:Generator_ColumnVarNameInTable="columnAddressID" msprop:Generator_ColumnPropNameInTable="AddressIDColumn" type="xs:int" />
<xs:element name="RecruitID" msprop:Generator_UserColumnName="RecruitID" msprop:Generator_ColumnPropNameInRow="RecruitID" msprop:Generator_ColumnVarNameInTable="columnRecruitID" msprop:Generator_ColumnPropNameInTable="RecruitIDColumn" type="xs:int" />
<xs:element name="PreferenceRank" msprop:Generator_UserColumnName="PreferenceRank" msprop:Generator_ColumnPropNameInRow="PreferenceRank" msprop:Generator_ColumnVarNameInTable="columnPreferenceRank" msprop:Generator_ColumnPropNameInTable="PreferenceRankColumn" type="xs:int" minOccurs="0" />
<xs:element name="Line1" msprop:Generator_UserColumnName="Line1" msprop:Generator_ColumnPropNameInRow="Line1" msprop:Generator_ColumnVarNameInTable="columnLine1" msprop:Generator_ColumnPropNameInTable="Line1Column" type="xs:string" />
<xs:element name="Line2" msprop:Generator_UserColumnName="Line2" msprop:Generator_ColumnPropNameInRow="Line2" msprop:Generator_ColumnVarNameInTable="columnLine2" msprop:Generator_ColumnPropNameInTable="Line2Column" type="xs:string" minOccurs="0" />
<xs:element name="City" msprop:Generator_UserColumnName="City" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInTable="CityColumn" type="xs:string" />
<xs:element name="State" msprop:Generator_UserColumnName="State" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInTable="StateColumn" type="xs:string" />
<xs:element name="Zip" msprop:Generator_UserColumnName="Zip" msprop:Generator_ColumnPropNameInRow="Zip" msprop:Generator_ColumnVarNameInTable="columnZip" msprop:Generator_ColumnPropNameInTable="ZipColumn" type="xs:string" />
<xs:element name="AddedBy" msdata:ReadOnly="true" msprop:Generator_UserColumnName="AddedBy" msprop:Generator_ColumnPropNameInRow="AddedBy" msprop:Generator_ColumnVarNameInTable="columnAddedBy" msprop:Generator_ColumnPropNameInTable="AddedByColumn" type="xs:string" minOccurs="0" />
<xs:element name="AddedDate" msdata:ReadOnly="true" msprop:Generator_UserColumnName="AddedDate" msprop:Generator_ColumnPropNameInRow="AddedDate" msprop:Generator_ColumnVarNameInTable="columnAddedDate" msprop:Generator_ColumnPropNameInTable="AddedDateColumn" type="xs:dateTime" minOccurs="0" />
<xs:element name="ModifiedBy" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:string" minOccurs="0" />
<xs:element name="ModifiedDate" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" minOccurs="0" />
<xs:element name="Country" msprop:Generator_UserColumnName="Country" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInTable="CountryColumn" type="xs:string" minOccurs="0" />
<xs:element name="County" msprop:Generator_UserColumnName="County" msprop:Generator_ColumnPropNameInRow="County" msprop:Generator_ColumnVarNameInTable="columnCounty" msprop:Generator_ColumnPropNameInTable="CountyColumn" type="xs:string" minOccurs="0" />
<xs:element name="BounceDate" msprop:Generator_UserColumnName="BounceDate" msprop:Generator_ColumnPropNameInRow="BounceDate" msprop:Generator_ColumnVarNameInTable="columnBounceDate" msprop:Generator_ColumnPropNameInTable="BounceDateColumn" type="xs:dateTime" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Recruits" msprop:Generator_UserTableName="Recruits" msprop:Generator_RowDeletedName="RecruitsRowDeleted" msprop:Generator_RowChangedName="RecruitsRowChanged" msprop:Generator_RowClassName="RecruitsRow" msprop:Generator_RowChangingName="RecruitsRowChanging" msprop:Generator_RowEvArgName="RecruitsRowChangeEvent" msprop:Generator_RowEvHandlerName="RecruitsRowChangeEventHandler" msprop:Generator_TableClassName="RecruitsDataTable" msprop:Generator_TableVarName="tableRecruits" msprop:Generator_RowDeletingName="RecruitsRowDeleting" msprop:Generator_TablePropName="Recruits" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element name="RecruitID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="RecruitID" msprop:Generator_ColumnPropNameInRow="RecruitID" msprop:Generator_ColumnVarNameInTable="columnRecruitID" msprop:Generator_ColumnPropNameInTable="RecruitIDColumn" type="xs:int" />
<xs:element name="AccLetter" msprop:Generator_UserColumnName="AccLetter" msprop:Generator_ColumnPropNameInRow="AccLetter" msprop:Generator_ColumnVarNameInTable="columnAccLetter" msprop:Generator_ColumnPropNameInTable="AccLetterColumn" type="xs:string" minOccurs="0" />
<xs:element name="AccNumber" msprop:Generator_UserColumnName="AccNumber" msprop:Generator_ColumnPropNameInRow="AccNumber" msprop:Generator_ColumnVarNameInTable="columnAccNumber" msprop:Generator_ColumnPropNameInTable="AccNumberColumn" type="xs:string" minOccurs="0" />
<xs:element name="Sex" msprop:Generator_UserColumnName="Sex" msprop:Generator_ColumnPropNameInRow="Sex" msprop:Generator_ColumnVarNameInTable="columnSex" msprop:Generator_ColumnPropNameInTable="SexColumn" type="xs:string" />
<xs:element name="Randy" msprop:Generator_UserColumnName="Randy" msprop:Generator_ColumnPropNameInRow="Randy" msprop:Generator_ColumnVarNameInTable="columnRandy" msprop:Generator_ColumnPropNameInTable="RandyColumn" type="xs:double" />
<xs:element name="BDate" msprop:Generator_UserColumnName="BDate" msprop:Generator_ColumnPropNameInRow="BDate" msprop:Generator_ColumnVarNameInTable="columnBDate" msprop:Generator_ColumnPropNameInTable="BDateColumn" type="xs:dateTime" minOccurs="0" />
<xs:element name="LastVistDate" msprop:Generator_UserColumnName="LastVistDate" msprop:Generator_ColumnPropNameInRow="LastVistDate" msprop:Generator_ColumnVarNameInTable="columnLastVistDate" msprop:Generator_ColumnPropNameInTable="LastVistDateColumn" type="xs:dateTime" minOccurs="0" />
<xs:element name="LastName" msprop:Generator_UserColumnName="LastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" type="xs:string" />
<xs:element name="FirstName" msprop:Generator_UserColumnName="FirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" type="xs:string" />
<xs:element name="MiddleName" msprop:Generator_UserColumnName="MiddleName" msprop:Generator_ColumnPropNameInRow="MiddleName" msprop:Generator_ColumnVarNameInTable="columnMiddleName" msprop:Generator_ColumnPropNameInTable="MiddleNameColumn" type="xs:string" minOccurs="0" />
<xs:element name="NameSuffix" msprop:Generator_UserColumnName="NameSuffix" msprop:Generator_ColumnPropNameInRow="NameSuffix" msprop:Generator_ColumnVarNameInTable="columnNameSuffix" msprop:Generator_ColumnPropNameInTable="NameSuffixColumn" type="xs:string" minOccurs="0" />
<xs:element name="SeqNum" msprop:Generator_UserColumnName="SeqNum" msprop:Generator_ColumnPropNameInRow="SeqNum" msprop:Generator_ColumnVarNameInTable="columnSeqNum" msprop:Generator_ColumnPropNameInTable="SeqNumColumn" type="xs:int" minOccurs="0" />
<xs:element name="RecruitProgVersion" msprop:Generator_UserColumnName="RecruitProgVersion" msprop:Generator_ColumnPropNameInRow="RecruitProgVersion" msprop:Generator_ColumnVarNameInTable="columnRecruitProgVersion" msprop:Generator_ColumnPropNameInTable="RecruitProgVersionColumn" type="xs:string" />
<xs:element name="Study" msprop:Generator_UserColumnName="Study" msprop:Generator_ColumnPropNameInRow="Study" msprop:Generator_ColumnVarNameInTable="columnStudy" msprop:Generator_ColumnPropNameInTable="StudyColumn" type="xs:int" />
<xs:element name="StatusDate" msprop:Generator_UserColumnName="StatusDate" msprop:Generator_ColumnPropNameInRow="StatusDate" msprop:Generator_ColumnVarNameInTable="columnStatusDate" msprop:Generator_ColumnPropNameInTable="StatusDateColumn" type="xs:dateTime" minOccurs="0" />
<xs:element name="StatusDescription" msprop:Generator_UserColumnName="StatusDescription" msprop:Generator_ColumnPropNameInRow="StatusDescription" msprop:Generator_ColumnVarNameInTable="columnStatusDescription" msprop:Generator_ColumnPropNameInTable="StatusDescriptionColumn" type="xs:string" minOccurs="0" />
<xs:element name="AddedBy" msdata:ReadOnly="true" msprop:Generator_UserColumnName="AddedBy" msprop:Generator_ColumnPropNameInRow="AddedBy" msprop:Generator_ColumnVarNameInTable="columnAddedBy" msprop:Generator_ColumnPropNameInTable="AddedByColumn" type="xs:string" minOccurs="0" />
<xs:element name="AddedDate" msdata:ReadOnly="true" msprop:Generator_UserColumnName="AddedDate" msprop:Generator_ColumnPropNameInRow="AddedDate" msprop:Generator_ColumnVarNameInTable="columnAddedDate" msprop:Generator_ColumnPropNameInTable="AddedDateColumn" type="xs:dateTime" minOccurs="0" />
<xs:element name="ModifiedBy" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:string" minOccurs="0" />
<xs:element name="ModifiedDate" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" minOccurs="0" />
<xs:element name="AccCode" msdata:ReadOnly="true" msprop:Generator_UserColumnName="AccCode" msprop:Generator_ColumnPropNameInRow="AccCode" msprop:Generator_ColumnVarNameInTable="columnAccCode" msprop:Generator_ColumnPropNameInTable="AccCodeColumn" type="xs:string" minOccurs="0" />
<xs:element name="EMailAddress" msprop:Generator_UserColumnName="EMailAddress" msprop:Generator_ColumnPropNameInRow="EMailAddress" msprop:Generator_ColumnVarNameInTable="columnEMailAddress" msprop:Generator_ColumnPropNameInTable="EMailAddressColumn" type="xs:string" minOccurs="0" />
<xs:element name="FullName" msdata:ReadOnly="true" msdata:Expression="LastName + ', ' + FirstName" msprop:Generator_UserColumnName="FullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" type="xs:string" minOccurs="0" />
<xs:element name="Incentive" msprop:Generator_UserColumnName="Incentive" msprop:Generator_ColumnPropNameInRow="Incentive" msprop:Generator_ColumnVarNameInTable="columnIncentive" msprop:Generator_ColumnPropNameInTable="IncentiveColumn" type="xs:string" minOccurs="0" />
<xs:element name="PersonType" msprop:Generator_UserColumnName="PersonType" msprop:Generator_ColumnVarNameInTable="columnPersonType" msprop:Generator_ColumnPropNameInRow="PersonType" msprop:Generator_ColumnPropNameInTable="PersonTypeColumn" type="xs:string" minOccurs="0" />
<xs:element name="QuitDate" msprop:Generator_UserColumnName="QuitDate" msprop:Generator_ColumnVarNameInTable="columnQuitDate" msprop:Generator_ColumnPropNameInRow="QuitDate" msprop:Generator_ColumnPropNameInTable="QuitDateColumn" type="xs:dateTime" minOccurs="0" />
<xs:element name="ConsumNo" msprop:Generator_UserColumnName="ConsumNo" msprop:Generator_ColumnPropNameInRow="ConsumNo" msprop:Generator_ColumnVarNameInTable="columnConsumNo" msprop:Generator_ColumnPropNameInTable="ConsumNoColumn" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="SamplingProgramVersions" msprop:Generator_UserTableName="SamplingProgramVersions" msprop:Generator_RowDeletedName="SamplingProgramVersionsRowDeleted" msprop:Generator_RowChangedName="SamplingProgramVersionsRowChanged" msprop:Generator_RowClassName="SamplingProgramVersionsRow" msprop:Generator_RowChangingName="SamplingProgramVersionsRowChanging" msprop:Generator_RowEvArgName="SamplingProgramVersionsRowChangeEvent" msprop:Generator_RowEvHandlerName="SamplingProgramVersionsRowChangeEventHandler" msprop:Generator_TableClassName="SamplingProgramVersionsDataTable" msprop:Generator_TableVarName="tableSamplingProgramVersions" msprop:Generator_RowDeletingName="SamplingProgramVersionsRowDeleting" msprop:Generator_TablePropName="SamplingProgramVersions">
<xs:complexType>
<xs:sequence>
<xs:element name="RecruitProgVersion" msprop:Generator_UserColumnName="RecruitProgVersion" msprop:Generator_ColumnPropNameInRow="RecruitProgVersion" msprop:Generator_ColumnVarNameInTable="columnRecruitProgVersion" msprop:Generator_ColumnPropNameInTable="RecruitProgVersionColumn" type="xs:string" />
<xs:element name="Notes" msprop:Generator_UserColumnName="Notes" msprop:Generator_ColumnPropNameInRow="Notes" msprop:Generator_ColumnVarNameInTable="columnNotes" msprop:Generator_ColumnPropNameInTable="NotesColumn" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ContactsOverview" msprop:Generator_UserTableName="ContactsOverview" msprop:Generator_RowDeletedName="ContactsOverviewRowDeleted" msprop:Generator_RowChangedName="ContactsOverviewRowChanged" msprop:Generator_RowClassName="ContactsOverviewRow" msprop:Generator_RowChangingName="ContactsOverviewRowChanging" msprop:Generator_RowEvArgName="ContactsOverviewRowChangeEvent" msprop:Generator_RowEvHandlerName="ContactsOverviewRowChangeEventHandler" msprop:Generator_TableClassName="ContactsOverviewDataTable" msprop:Generator_TableVarName="tableContactsOverview" msprop:Generator_RowDeletingName="ContactsOverviewRowDeleting" msprop:Generator_TablePropName="ContactsOverview">
<xs:complexType>
<xs:sequence>
<xs:element name="contactdate" msdata:Caption="Date" msprop:Generator_UserColumnName="contactdate" msprop:Generator_ColumnPropNameInRow="contactdate" msprop:Generator_ColumnVarNameInTable="columncontactdate" msprop:Generator_ColumnPropNameInTable="contactdateColumn" type="xs:dateTime" />
<xs:element name="contacttypedescription" msdata:Caption="Type" msprop:Generator_UserColumnName="contacttypedescription" msprop:Generator_ColumnPropNameInRow="contacttypedescription" msprop:Generator_ColumnVarNameInTable="columncontacttypedescription" msprop:Generator_ColumnPropNameInTable="contacttypedescriptionColumn" type="xs:string" />
<xs:element name="freq" msdata:Caption="Count" msprop:Generator_UserColumnName="freq" msprop:Generator_ColumnPropNameInRow="freq" msprop:Generator_ColumnVarNameInTable="columnfreq" msprop:Generator_ColumnPropNameInTable="freqColumn" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="QueriedAccessCodeList" msprop:Generator_UserTableName="QueriedAccessCodeList" msprop:Generator_RowDeletedName="QueriedAccessCodeListRowDeleted" msprop:Generator_RowChangedName="QueriedAccessCodeListRowChanged" msprop:Generator_RowClassName="QueriedAccessCodeListRow" msprop:Generator_RowChangingName="QueriedAccessCodeListRowChanging" msprop:Generator_RowEvArgName="QueriedAccessCodeListRowChangeEvent" msprop:Generator_RowEvHandlerName="QueriedAccessCodeListRowChangeEventHandler" msprop:Generator_TableClassName="QueriedAccessCodeListDataTable" msprop:Generator_TableVarName="tableQueriedAccessCodeList" msprop:Generator_RowDeletingName="QueriedAccessCodeListRowDeleting" msprop:Generator_TablePropName="QueriedAccessCodeList">
<xs:complexType>
<xs:sequence>
<xs:element name="AddedBy" msprop:Generator_UserColumnName="AddedBy" msprop:nullValue="_null" msprop:Generator_ColumnVarNameInTable="columnAddedBy" msprop:Generator_ColumnPropNameInTable="AddedByColumn" msprop:Generator_ColumnPropNameInRow="AddedBy" type="xs:string" minOccurs="0" />
<xs:element name="AccLetter" msprop:Generator_UserColumnName="AccLetter" msprop:Generator_ColumnPropNameInRow="AccLetter" msprop:Generator_ColumnVarNameInTable="columnAccLetter" msprop:Generator_ColumnPropNameInTable="AccLetterColumn" type="xs:string" />
<xs:element name="AccNumber" msprop:Generator_UserColumnName="AccNumber" msprop:Generator_ColumnPropNameInRow="AccNumber" msprop:Generator_ColumnVarNameInTable="columnAccNumber" msprop:Generator_ColumnPropNameInTable="AccNumberColumn" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="FullNames" msprop:Generator_UserTableName="FullNames" msprop:Generator_RowDeletedName="FullNamesRowDeleted" msprop:Generator_RowChangedName="FullNamesRowChanged" msprop:Generator_RowClassName="FullNamesRow" msprop:Generator_RowChangingName="FullNamesRowChanging" msprop:Generator_RowEvArgName="FullNamesRowChangeEvent" msprop:Generator_RowEvHandlerName="FullNamesRowChangeEventHandler" msprop:Generator_TableClassName="FullNamesDataTable" msprop:Generator_TableVarName="tableFullNames" msprop:Generator_RowDeletingName="FullNamesRowDeleting" msprop:Generator_TablePropName="FullNames">
<xs:complexType>
<xs:sequence>
<xs:element name="FullName" msprop:Generator_UserColumnName="FullName" msprop:Generator_ColumnPropNameInRow="FullName" msprop:Generator_ColumnVarNameInTable="columnFullName" msprop:Generator_ColumnPropNameInTable="FullNameColumn" type="xs:string" minOccurs="0" />
<xs:element name="RecruitID" msprop:Generator_UserColumnName="RecruitID" msprop:Generator_ColumnPropNameInRow="RecruitID" msprop:Generator_ColumnVarNameInTable="columnRecruitID" msprop:Generator_ColumnPropNameInTable="RecruitIDColumn" type="xs:int" minOccurs="0" />
<xs:element name="AccCode" msprop:Generator_UserColumnName="AccCode" msprop:Generator_ColumnPropNameInRow="AccCode" msprop:Generator_ColumnVarNameInTable="columnAccCode" msprop:Generator_ColumnPropNameInTable="AccCodeColumn" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="UpdatedAddresses" msprop:Generator_UserTableName="UpdatedAddresses" msprop:Generator_RowDeletedName="UpdatedAddressesRowDeleted" msprop:Generator_RowChangedName="UpdatedAddressesRowChanged" msprop:Generator_RowClassName="UpdatedAddressesRow" msprop:Generator_RowChangingName="UpdatedAddressesRowChanging" msprop:Generator_RowEvArgName="UpdatedAddressesRowChangeEvent" msprop:Generator_RowEvHandlerName="UpdatedAddressesRowChangeEventHandler" msprop:Generator_TableClassName="UpdatedAddressesDataTable" msprop:Generator_TableVarName="tableUpdatedAddresses" msprop:Generator_RowDeletingName="UpdatedAddressesRowDeleting" msprop:Generator_TablePropName="UpdatedAddresses">
<xs:complexType>
<xs:sequence>
<xs:element name="AddressID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="AddressID" msprop:Generator_ColumnPropNameInRow="AddressID" msprop:Generator_ColumnVarNameInTable="columnAddressID" msprop:Generator_ColumnPropNameInTable="AddressIDColumn" type="xs:int" />
<xs:element name="RecruitID" msprop:Generator_UserColumnName="RecruitID" msprop:Generator_ColumnPropNameInRow="RecruitID" msprop:Generator_ColumnVarNameInTable="columnRecruitID" msprop:Generator_ColumnPropNameInTable="RecruitIDColumn" type="xs:int" />
<xs:element name="PreferenceRank" msprop:Generator_UserColumnName="PreferenceRank" msprop:Generator_ColumnPropNameInRow="PreferenceRank" msprop:Generator_ColumnVarNameInTable="columnPreferenceRank" msprop:Generator_ColumnPropNameInTable="PreferenceRankColumn" type="xs:int" />
<xs:element name="Line1" msprop:Generator_UserColumnName="Line1" msprop:Generator_ColumnPropNameInRow="Line1" msprop:Generator_ColumnVarNameInTable="columnLine1" msprop:Generator_ColumnPropNameInTable="Line1Column" type="xs:string" />
<xs:element name="Line2" msprop:Generator_UserColumnName="Line2" msprop:Generator_ColumnPropNameInRow="Line2" msprop:Generator_ColumnVarNameInTable="columnLine2" msprop:Generator_ColumnPropNameInTable="Line2Column" type="xs:string" minOccurs="0" />
<xs:element name="City" msprop:Generator_UserColumnName="City" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInTable="CityColumn" type="xs:string" />
<xs:element name="State" msprop:Generator_UserColumnName="State" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInTable="StateColumn" type="xs:string" />
<xs:element name="Zip" msprop:Generator_UserColumnName="Zip" msprop:Generator_ColumnPropNameInRow="Zip" msprop:Generator_ColumnVarNameInTable="columnZip" msprop:Generator_ColumnPropNameInTable="ZipColumn" type="xs:string" />
<xs:element name="Country" msprop:Generator_UserColumnName="Country" msprop:Generator_ColumnPropNameInRow="Country" msprop:Generator_ColumnVarNameInTable="columnCountry" msprop:Generator_ColumnPropNameInTable="CountryColumn" type="xs:string" minOccurs="0" />
<xs:element name="County" msprop:Generator_UserColumnName="County" msprop:Generator_ColumnPropNameInRow="County" msprop:Generator_ColumnVarNameInTable="columnCounty" msprop:Generator_ColumnPropNameInTable="CountyColumn" type="xs:string" minOccurs="0" />
<xs:element name="BounceDate" msprop:Generator_UserColumnName="BounceDate" msprop:Generator_ColumnPropNameInRow="BounceDate" msprop:Generator_ColumnVarNameInTable="columnBounceDate" msprop:Generator_ColumnPropNameInTable="BounceDateColumn" type="xs:dateTime" minOccurs="0" />
<xs:element name="AddedBy" msprop:Generator_UserColumnName="AddedBy" msprop:Generator_ColumnPropNameInRow="AddedBy" msprop:Generator_ColumnVarNameInTable="columnAddedBy" msprop:Generator_ColumnPropNameInTable="AddedByColumn" type="xs:string" minOccurs="0" />
<xs:element name="AddedDate" msprop:Generator_UserColumnName="AddedDate" msprop:Generator_ColumnPropNameInRow="AddedDate" msprop:Generator_ColumnVarNameInTable="columnAddedDate" msprop:Generator_ColumnPropNameInTable="AddedDateColumn" type="xs:dateTime" minOccurs="0" />
<xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" type="xs:string" minOccurs="0" />
<xs:element name="ModifiedDate" msprop:Generator_UserColumnName="ModifiedDate" msprop:Generator_ColumnPropNameInRow="ModifiedDate" msprop:Generator_ColumnVarNameInTable="columnModifiedDate" msprop:Generator_ColumnPropNameInTable="ModifiedDateColumn" type="xs:dateTime" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Tickler" msprop:Generator_UserTableName="Tickler" msprop:Generator_RowDeletedName="TicklerRowDeleted" msprop:Generator_RowChangedName="TicklerRowChanged" msprop:Generator_RowClassName="TicklerRow" msprop:Generator_RowChangingName="TicklerRowChanging" msprop:Generator_RowEvArgName="TicklerRowChangeEvent" msprop:Generator_RowEvHandlerName="TicklerRowChangeEventHandler" msprop:Generator_TableClassName="TicklerDataTable" msprop:Generator_TableVarName="tableTickler" msprop:Generator_RowDeletingName="TicklerRowDeleting" msprop:Generator_TablePropName="Tickler">
<xs:complexType>
<xs:sequence>
<xs:element name="ToBeDone" msprop:Generator_UserColumnName="ToBeDone" msprop:Generator_ColumnPropNameInRow="ToBeDone" msprop:Generator_ColumnVarNameInTable="columnToBeDone" msprop:Generator_ColumnPropNameInTable="ToBeDoneColumn" type="xs:string" />
<xs:element name="RequiredStatus" msprop:Generator_UserColumnName="RequiredStatus" msprop:Generator_ColumnPropNameInRow="RequiredStatus" msprop:Generator_ColumnVarNameInTable="columnRequiredStatus" msprop:Generator_ColumnPropNameInTable="RequiredStatusColumn" type="xs:int" />
<xs:element name="DueAfterDays" msprop:Generator_UserColumnName="DueAfterDays" msprop:Generator_ColumnPropNameInRow="DueAfterDays" msprop:Generator_ColumnVarNameInTable="columnDueAfterDays" msprop:Generator_ColumnPropNameInTable="DueAfterDaysColumn" type="xs:int" />
<xs:element name="Study" msprop:Generator_UserColumnName="Study" msprop:Generator_ColumnVarNameInTable="columnStudy" msprop:Generator_ColumnPropNameInRow="Study" msprop:Generator_ColumnPropNameInTable="StudyColumn" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="incentive_card_counts_vw" msprop:Generator_UserTableName="incentive_card_counts_vw" msprop:Generator_RowDeletedName="incentive_card_counts_vwRowDeleted" msprop:Generator_RowChangedName="incentive_card_counts_vwRowChanged" msprop:Generator_RowClassName="incentive_card_counts_vwRow" msprop:Generator_RowChangingName="incentive_card_counts_vwRowChanging" msprop:Generator_RowEvArgName="incentive_card_counts_vwRowChangeEvent" msprop:Generator_RowEvHandlerName="incentive_card_counts_vwRowChangeEventHandler" msprop:Generator_TableClassName="incentive_card_counts_vwDataTable" msprop:Generator_TableVarName="tableincentive_card_counts_vw" msprop:Generator_RowDeletingName="incentive_card_counts_vwRowDeleting" msprop:Generator_TablePropName="incentive_card_counts_vw">
<xs:complexType>
<xs:sequence>
<xs:element name="incentive" msprop:Generator_UserColumnName="incentive" msprop:Generator_ColumnPropNameInRow="incentive" msprop:Generator_ColumnVarNameInTable="columnincentive" msprop:Generator_ColumnPropNameInTable="incentiveColumn" type="xs:string" minOccurs="0" />
<xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" type="xs:string" />
<xs:element name="num_needed" msprop:Generator_UserColumnName="num_needed" msprop:Generator_ColumnPropNameInRow="num_needed" msprop:Generator_ColumnVarNameInTable="columnnum_needed" msprop:Generator_ColumnPropNameInTable="num_neededColumn" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="todo_by_type_counts_vw" msprop:Generator_UserTableName="todo_by_type_counts_vw" msprop:Generator_RowDeletedName="todo_by_type_counts_vwRowDeleted" msprop:Generator_RowChangedName="todo_by_type_counts_vwRowChanged" msprop:Generator_RowClassName="todo_by_type_counts_vwRow" msprop:Generator_RowChangingName="todo_by_type_counts_vwRowChanging" msprop:Generator_RowEvArgName="todo_by_type_counts_vwRowChangeEvent" msprop:Generator_RowEvHandlerName="todo_by_type_counts_vwRowChangeEventHandler" msprop:Generator_TableClassName="todo_by_type_counts_vwDataTable" msprop:Generator_TableVarName="tabletodo_by_type_counts_vw" msprop:Generator_RowDeletingName="todo_by_type_counts_vwRowDeleting" msprop:Generator_TablePropName="todo_by_type_counts_vw">
<xs:complexType>
<xs:sequence>
<xs:element name="tobedone" msprop:Generator_UserColumnName="tobedone" msprop:Generator_ColumnVarNameInTable="columntobedone" msprop:Generator_ColumnPropNameInRow="tobedone" msprop:Generator_ColumnPropNameInTable="tobedoneColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="200" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="num" msdata:Caption="Available" msprop:Generator_UserColumnName="num" msprop:Generator_ColumnVarNameInTable="columnnum" msprop:Generator_ColumnPropNameInRow="num" msprop:Generator_ColumnPropNameInTable="numColumn" type="xs:int" minOccurs="0" />
<xs:element name="Wanted" msprop:Generator_UserColumnName="Wanted" msprop:Generator_ColumnVarNameInTable="columnWanted" msprop:Generator_ColumnPropNameInRow="Wanted" msprop:Generator_ColumnPropNameInTable="WantedColumn" type="xs:int" default="0" />
<xs:element name="persontype" msdata:ReadOnly="true" msprop:Generator_UserColumnName="persontype" msprop:Generator_ColumnPropNameInRow="persontype" msprop:Generator_ColumnVarNameInTable="columnpersontype" msprop:Generator_ColumnPropNameInTable="persontypeColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="study" msprop:Generator_UserColumnName="study" msprop:Generator_ColumnPropNameInRow="study" msprop:Generator_ColumnVarNameInTable="columnstudy" msprop:Generator_ColumnPropNameInTable="studyColumn" type="xs:int" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="CHCRKey1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Studies" />
<xs:field xpath="mstns:Study" />
</xs:unique>
<xs:unique name="CHCRKey2" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Statuses" />
<xs:field xpath="mstns:Status" />
</xs:unique>
<xs:unique name="RecruitStatusesKey1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:RecruitStatuses" />
<xs:field xpath="mstns:RecruitID" />
<xs:field xpath="mstns:StatusDate" />
<xs:field xpath="mstns:Status" />
</xs:unique>
<xs:unique name="CHCRKey4" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:ContactTypes" />
<xs:field xpath="mstns:ContactType" />
</xs:unique>
<xs:unique name="CHCRKey5" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:RecruitContacts" />
<xs:field xpath="mstns:RecruitID" />
<xs:field xpath="mstns:ContactDate" />
</xs:unique>
<xs:unique name="CHCRKey6" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:PhoneNumberTypes" />
<xs:field xpath="mstns:Type" />
</xs:unique>
<xs:unique name="CHCRKey7" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:PhoneNumbers" />
<xs:field xpath="mstns:RecruitID" />
<xs:field xpath="mstns:AreaCode" />
<xs:field xpath="mstns:PhoneNumber" />
</xs:unique>
<xs:unique name="CHCRKey8" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Addresses" />
<xs:field xpath="mstns:AddressID" />
</xs:unique>
<xs:unique name="CHCRKey9" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Recruits" />
<xs:field xpath="mstns:RecruitID" />
</xs:unique>
<xs:unique name="CHCRKey10" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:SamplingProgramVersions" />
<xs:field xpath="mstns:RecruitProgVersion" />
</xs:unique>
<xs:unique name="QueriedAccessCodeListKey1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:QueriedAccessCodeList" />
<xs:field xpath="mstns:AccLetter" />
<xs:field xpath="mstns:AccNumber" />
</xs:unique>
<xs:unique name="CHCRKey12" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:UpdatedAddresses" />
<xs:field xpath="mstns:AddressID" />
</xs:unique>
<xs:unique name="TicklerKey1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Tickler" />
<xs:field xpath="mstns:ToBeDone" />
<xs:field xpath="mstns:Study" />
</xs:unique>
<xs:keyref name="Updated_x0020_addresses" refer="CHCRKey9" msprop:rel_Generator_UserRelationName="Updated addresses" msprop:rel_Generator_RelationVarName="relationUpdated_addresses" msprop:rel_Generator_UserChildTable="UpdatedAddresses" msprop:rel_Generator_UserParentTable="Recruits" msprop:rel_Generator_ParentPropName="RecruitsRow" msprop:rel_Generator_ChildPropName="GetUpdatedAddressesRows">
<xs:selector xpath=".//mstns:UpdatedAddresses" />
<xs:field xpath="mstns:RecruitID" />
</xs:keyref>
<xs:keyref name="SamplingProgramVersionsRecruits" refer="CHCRKey10" msprop:rel_Generator_UserRelationName="SamplingProgramVersionsRecruits" msprop:rel_Generator_RelationVarName="relationSamplingProgramVersionsRecruits" msprop:rel_Generator_UserChildTable="Recruits" msprop:rel_Generator_UserParentTable="SamplingProgramVersions" msprop:rel_Generator_ParentPropName="SamplingProgramVersionsRow" msprop:rel_Generator_ChildPropName="GetRecruitsRows">
<xs:selector xpath=".//mstns:Recruits" />
<xs:field xpath="mstns:RecruitProgVersion" />
</xs:keyref>
<xs:keyref name="Participants" refer="CHCRKey1" msprop:rel_Generator_UserRelationName="Participants" msprop:rel_Generator_RelationVarName="relationParticipants" msprop:rel_Generator_UserChildTable="Recruits" msprop:rel_Generator_UserParentTable="Studies" msprop:rel_Generator_ParentPropName="StudiesRow" msprop:rel_Generator_ChildPropName="GetRecruitsRows">
<xs:selector xpath=".//mstns:Recruits" />
<xs:field xpath="mstns:Study" />
</xs:keyref>
<xs:keyref name="Addresses" refer="CHCRKey9" msprop:rel_Generator_UserRelationName="Addresses" msprop:rel_Generator_RelationVarName="relationAddresses" msprop:rel_Generator_UserChildTable="Addresses" msprop:rel_Generator_UserParentTable="Recruits" msprop:rel_Generator_ParentPropName="RecruitsRow" msprop:rel_Generator_ChildPropName="GetAddressesRows">
<xs:selector xpath=".//mstns:Addresses" />
<xs:field xpath="mstns:RecruitID" />
</xs:keyref>
<xs:keyref name="Phone_x0020_Numbers" refer="CHCRKey9" msprop:rel_Generator_UserRelationName="Phone Numbers" msprop:rel_Generator_RelationVarName="relationPhone_Numbers" msprop:rel_Generator_UserChildTable="PhoneNumbers" msprop:rel_Generator_UserParentTable="Recruits" msprop:rel_Generator_ParentPropName="RecruitsRow" msprop:rel_Generator_ChildPropName="GetPhoneNumbersRows">
<xs:selector xpath=".//mstns:PhoneNumbers" />
<xs:field xpath="mstns:RecruitID" />
</xs:keyref>
<xs:keyref name="PhoneNumberTypesPhoneNumbers" refer="CHCRKey6" msprop:rel_Generator_UserRelationName="PhoneNumberTypesPhoneNumbers" msprop:rel_Generator_RelationVarName="relationPhoneNumberTypesPhoneNumbers" msprop:rel_Generator_UserChildTable="PhoneNumbers" msprop:rel_Generator_UserParentTable="PhoneNumberTypes" msprop:rel_Generator_ParentPropName="PhoneNumberTypesRow" msprop:rel_Generator_ChildPropName="GetPhoneNumbersRows">
<xs:selector xpath=".//mstns:PhoneNumbers" />
<xs:field xpath="mstns:Type" />
</xs:keyref>
<xs:keyref name="Contacts" refer="CHCRKey9" msprop:rel_Generator_UserRelationName="Contacts" msprop:rel_Generator_RelationVarName="relationContacts" msprop:rel_Generator_UserChildTable="RecruitContacts" msprop:rel_Generator_UserParentTable="Recruits" msprop:rel_Generator_ParentPropName="RecruitsRow" msprop:rel_Generator_ChildPropName="GetRecruitContactsRows">
<xs:selector xpath=".//mstns:RecruitContacts" />
<xs:field xpath="mstns:RecruitID" />
</xs:keyref>
<xs:keyref name="ContactTypesRecruitContacts" refer="CHCRKey4" msprop:rel_Generator_UserRelationName="ContactTypesRecruitContacts" msprop:rel_Generator_RelationVarName="relationContactTypesRecruitContacts" msprop:rel_Generator_UserChildTable="RecruitContacts" msprop:rel_Generator_UserParentTable="ContactTypes" msprop:rel_Generator_ParentPropName="ContactTypesRow" msprop:rel_Generator_ChildPropName="GetRecruitContactsRows">
<xs:selector xpath=".//mstns:RecruitContacts" />
<xs:field xpath="mstns:ContactType" />
</xs:keyref>
<xs:keyref name="Status_x0020_History" refer="CHCRKey9" msprop:rel_Generator_UserRelationName="Status History" msprop:rel_Generator_RelationVarName="relationStatus_History" msprop:rel_Generator_UserChildTable="RecruitStatuses" msprop:rel_Generator_UserParentTable="Recruits" msprop:rel_Generator_ParentPropName="RecruitsRow" msprop:rel_Generator_ChildPropName="GetRecruitStatusesRows">
<xs:selector xpath=".//mstns:RecruitStatuses" />
<xs:field xpath="mstns:RecruitID" />
</xs:keyref>
<xs:keyref name="StatusesRecruitStatuses" refer="CHCRKey2" msprop:rel_Generator_UserRelationName="StatusesRecruitStatuses" msprop:rel_Generator_RelationVarName="relationStatusesRecruitStatuses" msprop:rel_Generator_UserChildTable="RecruitStatuses" msprop:rel_Generator_UserParentTable="Statuses" msprop:rel_Generator_ParentPropName="StatusesRow" msprop:rel_Generator_ChildPropName="GetRecruitStatusesRows">
<xs:selector xpath=".//mstns:RecruitStatuses" />
<xs:field xpath="mstns:Status" />
</xs:keyref>
</xs:element>
</xs:schema>