﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="TrainingRecordDataSet" targetNamespace="http://tempuri.org/TrainingRecordDataSet.xsd" xmlns:mstns="http://tempuri.org/TrainingRecordDataSet.xsd" xmlns="http://tempuri.org/TrainingRecordDataSet.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="Web.config" AppSettingsPropertyName="TabletContext" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="TabletContext (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.TabletContext.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="REPORT_usp_GetRecordDetails1TableAdapter" GeneratorDataComponentClassName="REPORT_usp_GetRecordDetails1TableAdapter" Name="REPORT_usp_GetRecordDetails1" UserDataComponentName="REPORT_usp_GetRecordDetails1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TabletContext (Web.config)" DbObjectName="CompliantWebIONOS_20220509.dbo.REPORT_usp_GetRecordDetails" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.REPORT_usp_GetRecordDetails</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@OrganizationId" Precision="19" ProviderType="BigInt" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@TrainingRecordId" Precision="19" ProviderType="BigInt" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@UserId" Precision="19" ProviderType="BigInt" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="300" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DocumentNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@VersionNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@CategoryId" Precision="19" ProviderType="BigInt" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DeadlineFromDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DeadlineToDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@LineManagerIds" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DepartmentIds" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@SubDepartmentIds" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CategoryIds" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UserIds" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserName" DataSetColumn="UserRole" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="REPORT_usp_GetRecordDetails2TableAdapter" GeneratorDataComponentClassName="REPORT_usp_GetRecordDetails2TableAdapter" Name="REPORT_usp_GetRecordDetails2" UserDataComponentName="REPORT_usp_GetRecordDetails2TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="TabletContext (Web.config)" DbObjectName="CompliantWebIONOS_20220509.dbo.REPORT_usp_GetRecordDetails" DbObjectType="StoredProcedure" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
                    <CommandText>dbo.REPORT_usp_GetRecordDetails</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@OrganizationId" Precision="19" ProviderType="BigInt" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@TrainingRecordId" Precision="19" ProviderType="BigInt" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@UserId" Precision="19" ProviderType="BigInt" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@Status" Precision="0" ProviderType="NVarChar" Scale="0" Size="300" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DocumentNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@VersionNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@CategoryId" Precision="19" ProviderType="BigInt" Scale="0" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DeadlineFromDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DeadlineToDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@LineManagerIds" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@DepartmentIds" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@SubDepartmentIds" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@CategoryIds" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DataTypeServer="nvarchar" DbType="String" Direction="Input" ParameterName="@UserIds" Precision="0" ProviderType="NVarChar" Scale="0" Size="2147483647" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserName" DataSetColumn="UserName" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="TrainingRecordDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="TrainingRecordDataSet" msprop:Generator_UserDSName="TrainingRecordDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="dsTrainingRecord" msprop:Generator_TableClassName="dsTrainingRecordDataTable" msprop:Generator_TableVarName="tabledsTrainingRecord" msprop:Generator_RowChangedName="dsTrainingRecordRowChanged" msprop:Generator_TablePropName="dsTrainingRecord" msprop:Generator_RowDeletingName="dsTrainingRecordRowDeleting" msprop:Generator_RowChangingName="dsTrainingRecordRowChanging" msprop:Generator_RowEvHandlerName="dsTrainingRecordRowChangeEventHandler" msprop:Generator_RowDeletedName="dsTrainingRecordRowDeleted" msprop:Generator_RowClassName="dsTrainingRecordRow" msprop:Generator_UserTableName="dsTrainingRecord" msprop:Generator_RowEvArgName="dsTrainingRecordRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CourseName" msprop:Generator_ColumnVarNameInTable="columnCourseName" msprop:Generator_ColumnPropNameInRow="CourseName" msprop:Generator_ColumnPropNameInTable="CourseNameColumn" msprop:Generator_UserColumnName="CourseName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DeadlineDate" msprop:Generator_ColumnVarNameInTable="columnDeadlineDate" msprop:Generator_ColumnPropNameInRow="DeadlineDate" msprop:Generator_ColumnPropNameInTable="DeadlineDateColumn" msprop:Generator_UserColumnName="DeadlineDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DocumentNo" msprop:Generator_ColumnVarNameInTable="columnDocumentNo" msprop:Generator_ColumnPropNameInRow="DocumentNo" msprop:Generator_ColumnPropNameInTable="DocumentNoColumn" msprop:Generator_UserColumnName="DocumentNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrainingStatus" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTrainingStatus" msprop:Generator_ColumnPropNameInRow="TrainingStatus" msprop:Generator_ColumnPropNameInTable="TrainingStatusColumn" msprop:Generator_UserColumnName="TrainingStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_UserColumnName="UserName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PassedDateTime" msprop:Generator_ColumnVarNameInTable="columnPassedDateTime" msprop:Generator_ColumnPropNameInRow="PassedDateTime" msprop:Generator_ColumnPropNameInTable="PassedDateTimeColumn" msprop:Generator_UserColumnName="PassedDateTime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="UserRole" msprop:Generator_ColumnVarNameInTable="columnUserRole" msprop:Generator_ColumnPropNameInRow="UserRole" msprop:Generator_ColumnPropNameInTable="UserRoleColumn" msprop:Generator_UserColumnName="UserRole" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrainingProvider" msprop:Generator_ColumnVarNameInTable="columnTrainingProvider" msprop:Generator_ColumnPropNameInRow="TrainingProvider" msprop:Generator_ColumnPropNameInTable="TrainingProviderColumn" msprop:Generator_UserColumnName="TrainingProvider" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TrainerSignature" msprop:Generator_ColumnVarNameInTable="columnTrainerSignature" msprop:Generator_ColumnPropNameInRow="TrainerSignature" msprop:Generator_ColumnPropNameInTable="TrainerSignatureColumn" msprop:Generator_UserColumnName="TrainerSignature" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="TrainerName" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTrainerName" msprop:Generator_ColumnPropNameInRow="TrainerName" msprop:Generator_ColumnPropNameInTable="TrainerNameColumn" msprop:Generator_UserColumnName="TrainerName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="201" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SessionDuration" msprop:Generator_ColumnVarNameInTable="columnSessionDuration" msprop:Generator_ColumnPropNameInRow="SessionDuration" msprop:Generator_ColumnPropNameInTable="SessionDurationColumn" msprop:Generator_UserColumnName="SessionDuration" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VersionNo" msprop:Generator_ColumnVarNameInTable="columnVersionNo" msprop:Generator_ColumnPropNameInRow="VersionNo" msprop:Generator_ColumnPropNameInTable="VersionNoColumn" msprop:Generator_UserColumnName="VersionNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Competency" msprop:Generator_ColumnVarNameInTable="columnCompetency" msprop:Generator_ColumnPropNameInRow="Competency" msprop:Generator_ColumnPropNameInTable="CompetencyColumn" msprop:Generator_UserColumnName="Competency" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InitialTrainingDate" msprop:Generator_ColumnVarNameInTable="columnInitialTrainingDate" msprop:Generator_ColumnPropNameInRow="InitialTrainingDate" msprop:Generator_ColumnPropNameInTable="InitialTrainingDateColumn" msprop:Generator_UserColumnName="InitialTrainingDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Comments" msprop:Generator_ColumnVarNameInTable="columnComments" msprop:Generator_ColumnPropNameInRow="Comments" msprop:Generator_ColumnPropNameInTable="CommentsColumn" msprop:Generator_UserColumnName="Comments" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TraineeSignature" msprop:Generator_ColumnVarNameInTable="columnTraineeSignature" msprop:Generator_ColumnPropNameInRow="TraineeSignature" msprop:Generator_ColumnPropNameInTable="TraineeSignatureColumn" msprop:Generator_UserColumnName="TraineeSignature" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="REPORT_usp_GetRecordDetails1" msprop:Generator_TableClassName="REPORT_usp_GetRecordDetails1DataTable" msprop:Generator_TableVarName="tableREPORT_usp_GetRecordDetails1" msprop:Generator_RowChangedName="REPORT_usp_GetRecordDetails1RowChanged" msprop:Generator_TablePropName="REPORT_usp_GetRecordDetails1" msprop:Generator_RowDeletingName="REPORT_usp_GetRecordDetails1RowDeleting" msprop:Generator_RowChangingName="REPORT_usp_GetRecordDetails1RowChanging" msprop:Generator_RowEvHandlerName="REPORT_usp_GetRecordDetails1RowChangeEventHandler" msprop:Generator_RowDeletedName="REPORT_usp_GetRecordDetails1RowDeleted" msprop:Generator_RowClassName="REPORT_usp_GetRecordDetails1Row" msprop:Generator_UserTableName="REPORT_usp_GetRecordDetails1" msprop:Generator_RowEvArgName="REPORT_usp_GetRecordDetails1RowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserRole" msdata:Caption="UserName" msprop:Generator_ColumnVarNameInTable="columnUserRole" msprop:Generator_ColumnPropNameInRow="UserRole" msprop:Generator_ColumnPropNameInTable="UserRoleColumn" msprop:Generator_UserColumnName="UserRole" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TotalAssignUserOfDept" msprop:Generator_ColumnVarNameInTable="columnTotalAssignUserOfDept" msprop:Generator_ColumnPropNameInRow="TotalAssignUserOfDept" msprop:Generator_ColumnPropNameInTable="TotalAssignUserOfDeptColumn" msprop:Generator_UserColumnName="TotalAssignUserOfDept" type="xs:string" minOccurs="0" />
              <xs:element name="Passed" msprop:Generator_ColumnVarNameInTable="columnPassed" msprop:Generator_ColumnPropNameInRow="Passed" msprop:Generator_ColumnPropNameInTable="PassedColumn" msprop:Generator_UserColumnName="Passed" type="xs:string" minOccurs="0" />
              <xs:element name="Failed" msprop:Generator_ColumnVarNameInTable="columnFailed" msprop:Generator_ColumnPropNameInRow="Failed" msprop:Generator_ColumnPropNameInTable="FailedColumn" msprop:Generator_UserColumnName="Failed" type="xs:string" minOccurs="0" />
              <xs:element name="RequiresTraining" msprop:Generator_ColumnVarNameInTable="columnRequiresTraining" msprop:Generator_ColumnPropNameInRow="RequiresTraining" msprop:Generator_ColumnPropNameInTable="RequiresTrainingColumn" msprop:Generator_UserColumnName="RequiresTraining" type="xs:string" minOccurs="0" />
              <xs:element name="MissedDatelineDate" msprop:Generator_ColumnVarNameInTable="columnMissedDatelineDate" msprop:Generator_ColumnPropNameInRow="MissedDatelineDate" msprop:Generator_ColumnPropNameInTable="MissedDatelineDateColumn" msprop:Generator_UserColumnName="MissedDatelineDate" type="xs:string" minOccurs="0" />
              <xs:element name="CourseName" msprop:Generator_ColumnVarNameInTable="columnCourseName" msprop:Generator_ColumnPropNameInRow="CourseName" msprop:Generator_ColumnPropNameInTable="CourseNameColumn" msprop:Generator_UserColumnName="CourseName" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="REPORT_usp_GetRecordDetails2" msprop:Generator_TableClassName="REPORT_usp_GetRecordDetails2DataTable" msprop:Generator_TableVarName="tableREPORT_usp_GetRecordDetails2" msprop:Generator_RowChangedName="REPORT_usp_GetRecordDetails2RowChanged" msprop:Generator_TablePropName="REPORT_usp_GetRecordDetails2" msprop:Generator_RowDeletingName="REPORT_usp_GetRecordDetails2RowDeleting" msprop:Generator_RowChangingName="REPORT_usp_GetRecordDetails2RowChanging" msprop:Generator_RowEvHandlerName="REPORT_usp_GetRecordDetails2RowChangeEventHandler" msprop:Generator_RowDeletedName="REPORT_usp_GetRecordDetails2RowDeleted" msprop:Generator_RowClassName="REPORT_usp_GetRecordDetails2Row" msprop:Generator_UserTableName="REPORT_usp_GetRecordDetails2" msprop:Generator_RowEvArgName="REPORT_usp_GetRecordDetails2RowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserName" msprop:Generator_ColumnVarNameInTable="columnUserName" msprop:Generator_ColumnPropNameInRow="UserName" msprop:Generator_ColumnPropNameInTable="UserNameColumn" msprop:Generator_UserColumnName="UserName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PassedTrainingNumber" msprop:Generator_ColumnVarNameInTable="columnPassedTrainingNumber" msprop:Generator_ColumnPropNameInRow="PassedTrainingNumber" msprop:Generator_ColumnPropNameInTable="PassedTrainingNumberColumn" msprop:Generator_UserColumnName="PassedTrainingNumber" type="xs:string" minOccurs="0" />
              <xs:element name="TotalTraining" msprop:Generator_ColumnVarNameInTable="columnTotalTraining" msprop:Generator_ColumnPropNameInRow="TotalTraining" msprop:Generator_ColumnPropNameInTable="TotalTrainingColumn" msprop:Generator_UserColumnName="TotalTraining" type="xs:string" minOccurs="0" />
              <xs:element name="PassedPercentage" msprop:Generator_ColumnVarNameInTable="columnPassedPercentage" msprop:Generator_ColumnPropNameInRow="PassedPercentage" msprop:Generator_ColumnPropNameInTable="PassedPercentageColumn" msprop:Generator_UserColumnName="PassedPercentage" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>