1 <?xml version="1.0" encoding="utf-8"?><Database Name="webcpe_reporting" Class="CPEWebDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
2 <Connection Mode="AppSettings" ConnectionString="Data Source=localhost;Initial Catalog=webcpe_reporting;Integrated Security=True" SettingsObjectName="CPE.App.NotifyConsole.Properties.Settings" SettingsPropertyName="webcpe_reportingConnectionString" Provider="System.Data.SqlClient" />
3 <Table Name="dbo.AdobeTransactions" Member="AdobeTransactions">
4 <Type Name="AdobeTransaction">
5 <Column Name="AdobeTransactionKey" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
6 <Column Name="Created" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
7 <Column Name="MeetingSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
8 <Column Name="Principal_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
9 <Column Name="StartDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
10 <Column Name="EndDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
11 <Association Name="MeetingSession_AdobeTransaction" Member="MeetingSession" ThisKey="MeetingSessionKey" OtherKey="MeetingSessionKey" Type="MeetingSession" IsForeignKey="true" />
14 <Table Name="dbo.ServiceLog" Member="ServiceLogs">
15 <Type Name="ServiceLog">
16 <Column Name="LogKey" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
17 <Column Name="Created" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
18 <Column Name="ServiceMethod" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
19 <Column Name="Details" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
22 <Table Name="dbo.Courses" Member="Courses">
24 <Column Name="ProjectCode" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
25 <Column Name="Name" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
28 <Table Name="dbo.HostMessageLog" Member="HostMessageLogs">
29 <Type Name="HostMessageLog">
30 <Column Name="MessageLogKey" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
31 <Column Name="Timestamp" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
32 <Column Name="SCO_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
33 <Column Name="Principal_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
34 <Column Name="Message" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
37 <Table Name="dbo.Learners" Member="Learners">
39 <Column Name="LearnerID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsDbGenerated="true" CanBeNull="false" />
40 <Column Name="FirstName" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
41 <Column Name="LastName" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
42 <Column Name="Email" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
45 <Table Name="dbo.MeetingDetails" Member="MeetingDetails">
46 <Type Name="MeetingDetail">
47 <Column Name="MeetingKey" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
48 <Column Name="CourseCode" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
49 <Column Name="Instructor" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
50 <Column Name="Location" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
51 <Column Name="TopicID" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
52 <Column Name="TopicName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
53 <Association Name="MeetingDetail_Meeting" Member="Meetings" ThisKey="MeetingKey" OtherKey="MeetingKey" Type="Meeting" />
56 <Table Name="dbo.MeetingParticipantSessions" Member="MeetingParticipantSessions">
57 <Type Name="MeetingParticipantSession">
58 <Column Name="MeetingParticipantSessionKey" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
59 <Column Name="MeetingSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
60 <Column Name="ParticipantKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
61 <Column Name="PlaySound" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
62 <Column Name="Created" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
63 <Association Name="MeetingParticipantSession_ParticipantEngagement" Member="ParticipantEngagements" ThisKey="MeetingParticipantSessionKey" OtherKey="MeetingParticipantSessionKey" Type="ParticipantEngagement" />
64 <Association Name="MeetingParticipantSession_ParticipantEngagementVerification" Member="ParticipantEngagementVerifications" ThisKey="MeetingParticipantSessionKey" OtherKey="MeetingParticipantSessionKey" Type="ParticipantEngagementVerification" />
65 <Association Name="MeetingParticipantSession_ParticipantTracking" Member="ParticipantTrackings" ThisKey="MeetingParticipantSessionKey" OtherKey="MeetingParticipantSessionKey" Type="ParticipantTracking" />
66 <Association Name="MeetingSession_MeetingParticipantSession" Member="MeetingSession" ThisKey="MeetingSessionKey" OtherKey="MeetingSessionKey" Type="MeetingSession" IsForeignKey="true" />
69 <Table Name="dbo.Meetings" Member="Meetings">
71 <Column Name="SCO_ID" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
72 <Column Name="MeetingKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
73 <Association Name="Meeting_MeetingSession" Member="MeetingSessions" ThisKey="SCO_ID" OtherKey="SCO_ID" Type="MeetingSession" />
74 <Association Name="MeetingDetail_Meeting" Member="MeetingDetail" ThisKey="MeetingKey" OtherKey="MeetingKey" Type="MeetingDetail" IsForeignKey="true" />
77 <Table Name="dbo.MeetingSessionHeartbeats" Member="MeetingSessionHeartbeats">
78 <Type Name="MeetingSessionHeartbeat">
79 <Column Name="MeetingSessionKey" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
80 <Column Name="Timestamp" Type="System.DateTime" DbType="DateTime NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
81 <Association Name="MeetingSession_MeetingSessionHeartbeat" Member="MeetingSession" ThisKey="MeetingSessionKey" OtherKey="MeetingSessionKey" Type="MeetingSession" IsForeignKey="true" />
84 <Table Name="dbo.MeetingSessionHeartbeatTicks" Member="MeetingSessionHeartbeatTicks">
85 <Type Name="MeetingSessionHeartbeatTick">
86 <Column Name="MeetingSessionKey" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
87 <Column Name="Timestamp" Type="System.DateTime" DbType="DateTime NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
88 <Column Name="Principal_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
89 <Column Name="PreviousInterval" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
92 <Table Name="dbo.MeetingSessionPauses" Member="MeetingSessionPauses">
93 <Type Name="MeetingSessionPause">
94 <Column Name="MesstingSessionPauseKey" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
95 <Column Name="MeetingSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
96 <Column Name="StartDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
97 <Column Name="EndDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
98 <Association Name="MeetingSession_MeetingSessionPause" Member="MeetingSession" ThisKey="MeetingSessionKey" OtherKey="MeetingSessionKey" Type="MeetingSession" IsForeignKey="true" />
101 <Table Name="dbo.MeetingSessions" Member="MeetingSessions">
102 <Type Name="MeetingSession">
103 <Column Name="MeetingSessionKey" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
104 <Column Name="SCO_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
105 <Column Name="Name" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
106 <Column Name="StartDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
107 <Column Name="EndDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
108 <Column Name="OwnerPrincipal_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
109 <Column Name="Recording" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
110 <Association Name="MeetingSession_AdobeTransaction" Member="AdobeTransactions" ThisKey="MeetingSessionKey" OtherKey="MeetingSessionKey" Type="AdobeTransaction" />
111 <Association Name="MeetingSession_MeetingParticipantSession" Member="MeetingParticipantSessions" ThisKey="MeetingSessionKey" OtherKey="MeetingSessionKey" Type="MeetingParticipantSession" />
112 <Association Name="MeetingSession_MeetingSessionHeartbeat" Member="MeetingSessionHeartbeats" ThisKey="MeetingSessionKey" OtherKey="MeetingSessionKey" Type="MeetingSessionHeartbeat" />
113 <Association Name="MeetingSession_MeetingSessionPause" Member="MeetingSessionPauses" ThisKey="MeetingSessionKey" OtherKey="MeetingSessionKey" Type="MeetingSessionPause" />
114 <Association Name="Meeting_MeetingSession" Member="Meeting" ThisKey="SCO_ID" OtherKey="SCO_ID" Type="Meeting" IsForeignKey="true" />
117 <Table Name="dbo.MeetingSettings" Member="MeetingSettings">
118 <Type Name="MeetingSetting">
119 <Column Name="MeetingKey" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
120 <Column Name="Interval" Type="System.Int32" DbType="Int" CanBeNull="true" />
121 <Column Name="Text" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
122 <Column Name="Duration" Type="System.Int32" DbType="Int" CanBeNull="true" />
125 <Table Name="dbo.ParticipantEngagements" Member="ParticipantEngagements">
126 <Type Name="ParticipantEngagement">
127 <Column Name="ParticipantEngagementKey" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
128 <Column Name="MeetingParticipantSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
129 <Column Name="Principal_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
130 <Column Name="DisplayTime" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
131 <Column Name="ResponseTime" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
132 <Association Name="MeetingParticipantSession_ParticipantEngagement" Member="MeetingParticipantSession" ThisKey="MeetingParticipantSessionKey" OtherKey="MeetingParticipantSessionKey" Type="MeetingParticipantSession" IsForeignKey="true" />
133 <Association Name="Participant_ParticipantEngagement" Member="Participant" ThisKey="Principal_ID" OtherKey="Principal_ID" Type="Participant" IsForeignKey="true" />
136 <Table Name="dbo.ParticipantEngagementsArchive" Member="ParticipantEngagementsArchives">
137 <Type Name="ParticipantEngagementsArchive">
138 <Column Name="ParticipantEngagementKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
139 <Column Name="MeetingParticipantSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
140 <Column Name="Principal_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
141 <Column Name="DisplayTime" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
142 <Column Name="ResponseTime" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
145 <Table Name="dbo.ParticipantEngagementVerification" Member="ParticipantEngagementVerifications">
146 <Type Name="ParticipantEngagementVerification">
147 <Column Name="TrackingKey" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
148 <Column Name="MeetingParticipantSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
149 <Column Name="Principal_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
150 <Column Name="DisplayTime" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
151 <Column Name="PreviousAlertDelta" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
152 <Association Name="MeetingParticipantSession_ParticipantEngagementVerification" Member="MeetingParticipantSession" ThisKey="MeetingParticipantSessionKey" OtherKey="MeetingParticipantSessionKey" Type="MeetingParticipantSession" IsForeignKey="true" />
153 <Association Name="Participant_ParticipantEngagementVerification" Member="Participant" ThisKey="Principal_ID" OtherKey="Principal_ID" Type="Participant" IsForeignKey="true" />
156 <Table Name="dbo.ParticipantLog" Member="ParticipantLogs">
157 <Type Name="ParticipantLog">
158 <Column Name="LogKey" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
159 <Column Name="Sco_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
160 <Column Name="Principal_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
161 <Column Name="Details" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
162 <Column Name="Created" Type="System.DateTime" DbType="SmallDateTime NOT NULL" CanBeNull="false" />
165 <Table Name="dbo.ParticipantMessageLog" Member="ParticipantMessageLogs">
166 <Type Name="ParticipantMessageLog">
167 <Column Name="MessageLogKey" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
168 <Column Name="Timestamp" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
169 <Column Name="SCO_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
170 <Column Name="Principal_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
171 <Column Name="Message" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
174 <Table Name="dbo.Participants" Member="Participants">
175 <Type Name="Participant">
176 <Column Name="Principal_ID" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
177 <Column Name="FirstName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
178 <Column Name="Email" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
179 <Column Name="LastName" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
180 <Association Name="Participant_ParticipantEngagement" Member="ParticipantEngagements" ThisKey="Principal_ID" OtherKey="Principal_ID" Type="ParticipantEngagement" />
181 <Association Name="Participant_ParticipantEngagementVerification" Member="ParticipantEngagementVerifications" ThisKey="Principal_ID" OtherKey="Principal_ID" Type="ParticipantEngagementVerification" />
182 <Association Name="Participant_ParticipantTracking" Member="ParticipantTrackings" ThisKey="Principal_ID" OtherKey="Principal_ID" Type="ParticipantTracking" />
185 <Table Name="dbo.ParticipantTracking" Member="ParticipantTrackings">
186 <Type Name="ParticipantTracking">
187 <Column Name="ParticipantTrackingKey" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
188 <Column Name="MeetingParticipantSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
189 <Column Name="Principal_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
190 <Column Name="StartDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
191 <Column Name="EndDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
192 <Association Name="MeetingParticipantSession_ParticipantTracking" Member="MeetingParticipantSession" ThisKey="MeetingParticipantSessionKey" OtherKey="MeetingParticipantSessionKey" Type="MeetingParticipantSession" IsForeignKey="true" />
193 <Association Name="Participant_ParticipantTracking" Member="Participant" ThisKey="Principal_ID" OtherKey="Principal_ID" Type="Participant" IsForeignKey="true" />
196 <Table Name="dbo.RecordingSessions" Member="RecordingSessions">
197 <Type Name="RecordingSession">
198 <Column Name="RecordingKey" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
199 <Column Name="MeetingSCO_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
200 <Column Name="RecordingSCO_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
201 <Column Name="Name" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
202 <Column Name="RecordingUrl" Type="System.String" DbType="VarChar(20) NOT NULL" CanBeNull="false" />
203 <Column Name="Duration" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
204 <Column Name="StartTime" Type="System.DateTime" DbType="SmallDateTime NOT NULL" CanBeNull="false" />
205 <Column Name="EndTime" Type="System.DateTime" DbType="SmallDateTime NOT NULL" CanBeNull="false" />
206 <Column Name="MeetingSessionKey" Type="System.Int32" DbType="Int" CanBeNull="true" />
207 <Column Name="SurveyLink" Type="System.String" DbType="VarChar(1000) NOT NULL" CanBeNull="false" />
208 <Column Name="Passcode" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
211 <Table Name="dbo.ServiceErrors" Member="ServiceErrors">
212 <Type Name="ServiceError">
213 <Column Name="ErrorKey" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
214 <Column Name="ServiceMethod" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
215 <Column Name="Message" Type="System.String" DbType="NVarChar(1000) NOT NULL" CanBeNull="false" />
216 <Column Name="StackTrace" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
217 <Column Name="Logged" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
220 <Table Name="dbo.BlockedPurchases" Member="BlockedPurchases">
221 <Type Name="BlockedPurchase">
222 <Column Name="ContentUrl" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
223 <Column Name="Email" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
224 <Column Name="FirstName" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
225 <Column Name="LastName" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
226 <Column Name="Ticket" Type="System.String" DbType="NVarChar(10) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
227 <Column Name="PurchaseDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
230 <Table Name="dbo.AdobeCertificateTransactions" Member="AdobeCertificateTransactions">
231 <Type Name="AdobeCertificateTransaction">
232 <Column Name="AdobeCertificateTransactionKey" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
233 <Column Name="Created" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
234 <Column Name="MeetingSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
235 <Column Name="Presenter" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
236 <Column Name="Fos" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />
239 <Table Name="dbo.CourseDetails" Member="CourseDetails">
240 <Type Name="CourseDetail">
241 <Column Name="ProjectCode" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
242 <Column Name="ReleaseCode" Type="System.String" DbType="NVarChar(50) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
243 <Column Name="Name" Type="System.String" DbType="NVarChar(150) NOT NULL" CanBeNull="false" />
244 <Column Name="CreatedDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
245 <Column Name="Presenter" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
246 <Column Name="Fos" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
247 <Column Name="Credits" Type="System.String" DbType="NVarChar(10) NOT NULL" CanBeNull="false" />
250 <Table Name="dbo.PurchasedCourses" Member="PurchasedCourses">
251 <Type Name="PurchasedCourse">
252 <Column Name="ContentUrl" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
253 <Column Name="CourseName" Type="System.String" DbType="NVarChar(150) NOT NULL" CanBeNull="false" />
254 <Column Name="Email" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
255 <Column Name="FirstName" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
256 <Column Name="LastName" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
257 <Column Name="Ticket" Type="System.String" DbType="NVarChar(10) NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
258 <Column Name="PurchaseDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
259 <Column Name="CertificateDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
260 <Column Name="Presenter" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
261 <Column Name="Fos" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
262 <Column Name="Credits" Type="System.String" DbType="NVarChar(10)" CanBeNull="true" />
263 <Column Name="FailedAttempts" Type="System.Int32" DbType="Int" CanBeNull="true" />
264 <Column Name="isManualCertificate" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
267 <Table Name="dbo.ParticipantPurchases" Member="ParticipantPurchases">
268 <Type Name="ParticipantPurchase">
269 <Column Name="Purchase_ID" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
270 <Column Name="FirstName" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
271 <Column Name="LastName" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
272 <Column Name="Email" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
273 <Column Name="PrincipalID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
274 <Column Name="MeetingName" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
275 <Column Name="MeetingDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
276 <Column Name="Ticket" Type="System.String" DbType="NVarChar(10) NOT NULL" CanBeNull="false" />
277 <Column Name="PurchaseDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
278 <Column Name="Credits" Type="System.Double" DbType="Float" CanBeNull="true" />
279 <Column Name="EarnedCertificate" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
280 <Column Name="Presenter" Type="System.String" DbType="NVarChar(100)" CanBeNull="true" />
281 <Column Name="MeetingSco" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
282 <Column Name="IsForced" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
283 <Column Name="DispositionProcessingState" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
286 <Function Name="dbo.ArchiveSessionEngagements" Method="ArchiveSessionEngagements">
287 <Parameter Name="sessionKey" Type="System.Int32" DbType="Int" />
288 <Return Type="System.Int32" />
290 <Function Name="dbo.UserServiceLog" Method="UserServiceLog">
291 <Parameter Name="sessionKey" Type="System.Int32" DbType="Int" />
292 <Parameter Name="principalId" Type="System.Int32" DbType="Int" />
293 <ElementType Name="UserServiceLogResult">
294 <Column Name="Created" Type="System.DateTime" DbType="SmallDateTime NOT NULL" CanBeNull="false" />
295 <Column Name="ServiceMethod" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
296 <Column Name="Details" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
299 <Function Name="dbo.CreateRebroadcastSession" Method="CreateRebroadcastSession">
300 <Parameter Name="recordingScoId" Type="System.Int32" DbType="Int" />
301 <Parameter Name="meetingScoId" Type="System.Int32" DbType="Int" />
302 <Parameter Name="meetingOwnerId" Type="System.Int32" DbType="Int" />
303 <Parameter Name="startTime" Type="System.DateTime" DbType="DateTime" />
304 <Parameter Name="endTime" Type="System.DateTime" DbType="DateTime" />
305 <Parameter Name="msDiff" Type="System.Double" DbType="Float" />
306 <Parameter Name="dayDiff" Type="System.Double" DbType="Float" />
307 <Parameter Name="name" Type="System.String" DbType="NVarChar(500)" />
308 <ElementType Name="CreateRebroadcastSessionResult">
309 <Column Name="" Member="Column1" Type="System.Int32" DbType="Int" CanBeNull="true" />
312 <Function Name="dbo.DeleteSession" Method="DeleteSession">
313 <Parameter Name="sessionKey" Type="System.Int32" DbType="Int" />
314 <Return Type="System.Int32" />
316 <Function Name="dbo.GetDuplicateEngagements" Method="GetDuplicateEngagements">
317 <Parameter Name="meetingParticipantSessionKey" Type="System.Int32" DbType="Int" />
318 <ElementType Name="GetDuplicateEngagementsResult">
319 <Column Name="ParticipantEngagementKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
320 <Column Name="MeetingParticipantSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
321 <Column Name="Principal_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
322 <Column Name="DisplayTime" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
323 <Column Name="ResponseTime" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
326 <Function Name="dbo.GetSessionReport" Method="GetSessionReport">
327 <Parameter Name="SessionKey" Parameter="sessionKey" Type="System.Int32" DbType="Int" />
328 <ElementType Name="GetSessionReportResult">
329 <Column Name="Name" Type="System.String" DbType="NVarChar(401)" CanBeNull="true" />
330 <Column Name="Principal_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
331 <Column Name="MeetingParticipantSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
332 <Column Name="StartDate" Type="System.DateTime" DbType="SmallDateTime" CanBeNull="true" />
333 <Column Name="EndDate" Type="System.DateTime" DbType="SmallDateTime" CanBeNull="true" />
336 <Function Name="dbo.SessionData" Method="SessionData">
337 <Parameter Name="meetingSessionKey" Type="System.Int32" DbType="Int" />
338 <ElementType Name="SessionDataResult">
339 <Column Name="MeetingSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
340 <Column Name="Timestamp" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
343 <Function Name="dbo.SessionPollReport" Method="SessionPollReport">
344 <Parameter Name="sessionKey" Type="System.Int32" DbType="Int" />
345 <ElementType Name="SessionPollReportResult">
346 <Column Name="MeetingSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
347 <Column Name="SCO_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
348 <Column Name="Name" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
349 <Column Name="StartDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
350 <Column Name="EndDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
351 <Column Name="OwnerPrincipal_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
352 <Column Name="Recording" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
353 <Column Name="MeetingKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
354 <Column Name="Interval" Type="System.Int32" DbType="Int" CanBeNull="true" />
355 <Column Name="Text" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
356 <Column Name="Duration" Type="System.Int32" DbType="Int" CanBeNull="true" />
359 <Function Name="dbo.GetHeartbeatTicks" Method="GetHeartbeatTicks" IsComposable="true">
360 <ElementType Name="GetHeartbeatTicksResult">
361 <Column Name="MeetingSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
362 <Column Name="Timestamp" Type="System.DateTime" DbType="SmallDateTime" CanBeNull="true" />
363 <Column Name="Principal_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
364 <Column Name="PreviousInterval" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
367 <Function Name="webcpe_reporting.GetMeetingSessionTotals" Method="GetMeetingSessionTotals" IsComposable="true">
368 <ElementType Name="GetMeetingSessionTotalsResult">
369 <Column Name="MeetingSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
370 <Column Name="Name" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
371 <Column Name="StartDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
372 <Column Name="EndDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
373 <Column Name="TotalMeetingMinutes" Type="System.Int32" DbType="Int" CanBeNull="true" />
374 <Column Name="TotalPauseMinutes" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
375 <Column Name="TotalMinutes" Type="System.Int32" DbType="Int" CanBeNull="true" />
378 <Function Name="dbo.GetParticipantTrackings" Method="GetParticipantTrackings" IsComposable="true">
379 <ElementType Name="GetParticipantTrackingsResult">
380 <Column Name="ParticipantTrackingKey" Type="System.Int32" DbType="Int" CanBeNull="true" />
381 <Column Name="MeetingParticipantSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
382 <Column Name="Principal_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
383 <Column Name="StartDate" Type="System.DateTime" DbType="SmallDateTime" CanBeNull="true" />
384 <Column Name="EndDate" Type="System.DateTime" DbType="SmallDateTime" CanBeNull="true" />
387 <Function Name="dbo.MeetingSessionsData" Method="MeetingSessionsData" IsComposable="true">
388 <ElementType Name="MeetingSessionsDataResult">
389 <Column Name="MeetingSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
390 <Column Name="Name" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
391 <Column Name="StartDate" Type="System.DateTime" DbType="SmallDateTime" CanBeNull="true" />
392 <Column Name="EndDate" Type="System.DateTime" DbType="SmallDateTime" CanBeNull="true" />
393 <Column Name="TotalSessionTime" Type="System.Int32" DbType="Int" CanBeNull="true" />
394 <Column Name="TotalSessionPauseTime" Type="System.Int32" DbType="Int" CanBeNull="true" />
395 <Column Name="ActualSessionTime" Type="System.Int32" DbType="Int" CanBeNull="true" />
396 <Column Name="SessionHeartbeatCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
399 <Function Name="dbo.ParticipantPauseTime" Method="ParticipantPauseTime" IsComposable="true">
400 <Parameter Name="MeetingParticipantSessionKey" Parameter="meetingParticipantSessionKey" Type="System.Int32" DbType="Int" />
401 <Return Type="System.Int32" />
403 <Function Name="dbo.ParticipantSessionEngagementCount" Method="ParticipantSessionEngagementCount" IsComposable="true">
404 <Parameter Name="MeetingParticipantSessionKey" Parameter="meetingParticipantSessionKey" Type="System.Int32" DbType="Int" />
405 <Return Type="System.Int32" />
407 <Function Name="dbo.ParticipantSessionHeartbeatCount" Method="ParticipantSessionHeartbeatCount" IsComposable="true">
408 <Parameter Name="MeetingParticipantSessionKey" Parameter="meetingParticipantSessionKey" Type="System.Int32" DbType="Int" />
409 <Return Type="System.Int32" />
411 <Function Name="dbo.ParticipantSessionTime" Method="ParticipantSessionTime" IsComposable="true">
412 <Parameter Name="MeetingParticipantSessionKey" Parameter="meetingParticipantSessionKey" Type="System.Int32" DbType="Int" />
413 <Return Type="System.Int32" />
415 <Function Name="dbo.SessionHeartbeatCount" Method="SessionHeartbeatCount" IsComposable="true">
416 <Parameter Name="MeetingSessionKey" Parameter="meetingSessionKey" Type="System.Int32" DbType="Int" />
417 <Return Type="System.Int32" />
419 <Function Name="dbo.SessionPauseTime" Method="SessionPauseTime" IsComposable="true">
420 <Parameter Name="MeetingSessionKey" Parameter="meetingSessionKey" Type="System.Int32" DbType="Int" />
421 <Return Type="System.Int32" />
423 <Function Name="dbo.SessionTime" Method="SessionTime" IsComposable="true">
424 <Parameter Name="MeetingSessionKey" Parameter="meetingSessionKey" Type="System.Int32" DbType="Int" />
425 <Return Type="System.Int32" />
427 <Function Name="dbo.CertificatesAwardedByRelease" Method="CertificatesAwardedByRelease" IsComposable="true">
428 <Parameter Name="name" Type="System.String" DbType="NVarChar(50)" />
429 <Return Type="System.Int32" />
431 <Function Name="dbo.PurchasedCoursesByRelease" Method="PurchasedCoursesByRelease" IsComposable="true">
432 <Parameter Name="name" Type="System.String" DbType="NVarChar(50)" />
433 <Return Type="System.Int32" />
435 <Function Name="dbo.CourseListingsData" Method="CourseListingsData" IsComposable="true">
436 <ElementType Name="CourseListingsDataResult">
437 <Column Name="Name" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
438 <Column Name="CreatedDate" Type="System.DateTime" DbType="SmallDateTime" CanBeNull="true" />
439 <Column Name="ProjectCode" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
440 <Column Name="ReleaseCode" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
441 <Column Name="Presenter" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
442 <Column Name="Fos" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
443 <Column Name="Credits" Type="System.String" DbType="NVarChar(10) NOT NULL" CanBeNull="false" />
446 <Function Name="dbo.CertficateData" Method="CertficateData" IsComposable="true">
447 <ElementType Name="CertficateDataResult">
448 <Column Name="Curl" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
449 <Column Name="Course" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
450 <Column Name="Email" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
451 <Column Name="Name" Type="System.String" DbType="NVarChar(401) NOT NULL" CanBeNull="false" />
452 <Column Name="Ticket" Type="System.String" DbType="NVarChar(10) NOT NULL" CanBeNull="false" />
453 <Column Name="pDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
454 <Column Name="cDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
455 <Column Name="isForced" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
458 <Function Name="dbo.PurchasedCoursesData" Method="PurchasedCoursesData" IsComposable="true">
459 <Parameter Name="releaseCode" Type="System.String" DbType="NVarChar(50)" />
460 <ElementType Name="PurchasedCoursesDataResult">
461 <Column Name="ContentUrl" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
462 <Column Name="ReleaseCode" Type="System.String" DbType="NVarChar(50)" CanBeNull="true" />
463 <Column Name="LearnerName" Type="System.String" DbType="NVarChar(401) NOT NULL" CanBeNull="false" />
464 <Column Name="Email" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
465 <Column Name="PurchaseDate" Type="System.DateTime" DbType="SmallDateTime" CanBeNull="true" />
466 <Column Name="CertificateDate" Type="System.DateTime" DbType="SmallDateTime" CanBeNull="true" />
467 <Column Name="Ticket" Type="System.String" DbType="NVarChar(10) NOT NULL" CanBeNull="false" />
468 <Column Name="FailedAttempts" Type="System.Int32" DbType="Int" CanBeNull="true" />
469 <Column Name="isForced" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
470 <Column Name="BlockedAccess" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
473 <Function Name="dbo.WebcastCertficateData" Method="WebcastCertficateData" IsComposable="true">
474 <ElementType Name="WebcastCertficateDataResult">
475 <Column Name="Sco" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
476 <Column Name="MeetingName" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
477 <Column Name="Email" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
478 <Column Name="Name" Type="System.String" DbType="NVarChar(401) NOT NULL" CanBeNull="false" />
479 <Column Name="Ticket" Type="System.String" DbType="NVarChar(10) NOT NULL" CanBeNull="false" />
480 <Column Name="pDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
481 <Column Name="mDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
482 <Column Name="Credits" Type="System.Double" DbType="Float" CanBeNull="true" />
483 <Column Name="isForced" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
486 <Function Name="dbo.WebcastPurchaseData" Method="WebcastPurchaseData" IsComposable="true">
487 <ElementType Name="WebcastPurchaseDataResult">
488 <Column Name="Sco" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
489 <Column Name="MeetingName" Type="System.String" DbType="NVarChar(500) NOT NULL" CanBeNull="false" />
490 <Column Name="Email" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
491 <Column Name="Name" Type="System.String" DbType="NVarChar(401) NOT NULL" CanBeNull="false" />
492 <Column Name="Ticket" Type="System.String" DbType="NVarChar(10) NOT NULL" CanBeNull="false" />
493 <Column Name="pDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
494 <Column Name="mDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
495 <Column Name="Credits" Type="System.Double" DbType="Float" CanBeNull="true" />
496 <Column Name="isForced" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
497 <Column Name="PrincipalID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
498 <Column Name="EarnedCert" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
501 <Function Name="dbo.ParticipantSessionsData" Method="ParticipantSessionsData" IsComposable="true">
502 <Parameter Name="MeetingSessionKey" Parameter="meetingSessionKey" Type="System.Int32" DbType="Int" />
503 <ElementType Name="ParticipantSessionsDataResult">
504 <Column Name="MeetingSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
505 <Column Name="MeetingParticipantSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
506 <Column Name="Name" Type="System.String" DbType="NVarChar(401)" CanBeNull="true" />
507 <Column Name="StartDate" Type="System.DateTime" DbType="SmallDateTime" CanBeNull="true" />
508 <Column Name="EndDate" Type="System.DateTime" DbType="SmallDateTime" CanBeNull="true" />
509 <Column Name="TotalSessionTime" Type="System.Int32" DbType="Int" CanBeNull="true" />
510 <Column Name="TotalSessionPauseTime" Type="System.Int32" DbType="Int" CanBeNull="true" />
511 <Column Name="ActualSessionTime" Type="System.Int32" DbType="Int" CanBeNull="true" />
512 <Column Name="SessionHeartbeatCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
513 <Column Name="SessionEngagementCount" Type="System.Int32" DbType="Int" CanBeNull="true" />
514 <Column Name="SessionCredit" Type="System.Decimal" DbType="Decimal(8,1)" CanBeNull="true" />
515 <Column Name="LoggedCredit" Type="System.Decimal" DbType="Decimal(8,1)" CanBeNull="true" />
518 <Function Name="dbo.GetRecordingCandidates" Method="GetRecordingCandidates" IsComposable="true">
519 <Parameter Name="meetingSessionKey" Type="System.Int32" DbType="Int" />
520 <ElementType Name="GetRecordingCandidatesResult">
521 <Column Name="MeetingSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
522 <Column Name="SCO_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
523 <Column Name="Name" Type="System.String" DbType="NVarChar(500)" CanBeNull="true" />
524 <Column Name="StartDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
525 <Column Name="EndDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
526 <Column Name="NotifyDateTime" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
527 <Column Name="Recording" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
528 <Column Name="MeetingParticipantSessionKey" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
529 <Column Name="Principal_ID" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
530 <Column Name="Participant" Type="System.String" DbType="NVarChar(401)" CanBeNull="true" />
531 <Column Name="Email" Type="System.String" DbType="NVarChar(200)" CanBeNull="true" />