<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsProject" targetNamespace="http://tempuri.org/dsProject.xsd" xmlns:mstns="http://tempuri.org/dsProject.xsd" xmlns="http://tempuri.org/dsProject.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" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
<Connections>
<Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="cnPPDB" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="cnPPDB (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.cnPPDB.ConnectionString" Provider="System.Data.SqlClient">
</Connection>
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblProjectTableAdapter" GeneratorDataComponentClassName="tblProjectTableAdapter" Name="tblProject" UserDataComponentName="tblProjectTableAdapter">
<MainSource>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.tblProject" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetByID" GetMethodModifier="Public" GetMethodName="GetByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetByID" UserSourceName="GetByID">
<InsertCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspProjectInsert</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProjectTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="255" SourceColumn="ProjectTitle" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COENumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumn="COENumber" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COADept" Precision="0" ProviderType="NVarChar" Scale="0" Size="7" SourceColumn="COADept" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PPTypeID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="PPTypeID" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProjectDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="1000" SourceColumn="ProjectDescription" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OriginatorContactID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="OriginatorContactID" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PPSubmissionDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumn="PPSubmissionDate" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PPReceivedDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumn="PPReceivedDate" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@PartOfOperationalPlanYN" Precision="5" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="PartOfOperationalPlanYN" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProjectNotes" Precision="0" ProviderType="NVarChar" Scale="0" Size="1000" SourceColumn="ProjectNotes" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CreatedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="CreatedBy" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="ModifiedBy" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspProjectGetByID</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="ProjectID" DataSetColumn="ProjectID" />
<Mapping SourceColumn="ProjectTitle" DataSetColumn="ProjectTitle" />
<Mapping SourceColumn="COENumber" DataSetColumn="COENumber" />
<Mapping SourceColumn="COADept" DataSetColumn="COADept" />
<Mapping SourceColumn="ProjectDescription" DataSetColumn="ProjectDescription" />
<Mapping SourceColumn="OriginatorContactID" DataSetColumn="OriginatorContactID" />
<Mapping SourceColumn="PPSubmissionDate" DataSetColumn="PPSubmissionDate" />
<Mapping SourceColumn="PPReceivedDate" DataSetColumn="PPReceivedDate" />
<Mapping SourceColumn="PartOfOperationalPlanYN" DataSetColumn="PartOfOperationalPlanYN" />
<Mapping SourceColumn="ProjectNotes" DataSetColumn="ProjectNotes" />
<Mapping SourceColumn="BudgetNotes" DataSetColumn="BudgetNotes" />
<Mapping SourceColumn="ProjectRating" DataSetColumn="ProjectRating" />
<Mapping SourceColumn="ProjectRepeatYN" DataSetColumn="ProjectRepeatYN" />
<Mapping SourceColumn="ProjectEvalComments" DataSetColumn="ProjectEvalComments" />
<Mapping SourceColumn="CreatedOn" DataSetColumn="CreatedOn" />
<Mapping SourceColumn="CreatedBy" DataSetColumn="CreatedBy" />
<Mapping SourceColumn="ModifiedOn" DataSetColumn="ModifiedOn" />
<Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
<Mapping SourceColumn="ActiveYN" DataSetColumn="ActiveYN" />
<Mapping SourceColumn="EditableYN" DataSetColumn="EditableYN" />
<Mapping SourceColumn="ApprovedBudget" DataSetColumn="ApprovedBudget" />
<Mapping SourceColumn="Budget" DataSetColumn="Budget" />
<Mapping SourceColumn="Actual" DataSetColumn="Actual" />
<Mapping SourceColumn="Variance" DataSetColumn="Variance" />
<Mapping SourceColumn="PPStatusID" DataSetColumn="PPStatusID" />
<Mapping SourceColumn="GLCode" DataSetColumn="GLCode" />
<Mapping SourceColumn="EventCategoryID" DataSetColumn="EventCategoryID" />
<Mapping SourceColumn="CommitteeName" DataSetColumn="CommitteeName" />
<Mapping SourceColumn="BoardPortfolioID" DataSetColumn="BoardPortfolioID" />
<Mapping SourceColumn="BoardPortfolioName" DataSetColumn="BoardPortfolioName" />
<Mapping SourceColumn="PPStatus" DataSetColumn="PPStatus" />
</Mappings>
<Sources>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.mspProjectGetAll" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetAllProjects" GetMethodModifier="Public" GetMethodName="GetAllProjects" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetAllProjects" UserSourceName="GetAllProjects1">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspProjectGetAll</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.mspProjectUpdateByID" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorSourceName="UpdateByID" Modifier="Public" Name="UpdateByID" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="UpdateByID">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspProjectUpdateByID</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProjectTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="255" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EventCategoryID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProjectDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="1000" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PartOfOperationalPlanYN" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProjectNotes" Precision="0" ProviderType="NVarChar" Scale="0" Size="1000" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BoardPortfolioID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CommitteeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.mspProjectUpdateGLCodeByID" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorSourceName="UpdateGLCodeByID" Modifier="Public" Name="UpdateGLCodeByID" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="UpdateGLCodeByID">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspProjectUpdateGLCodeByID</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@GLCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.mspProjectUpdateOverallEvalByID" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorSourceName="UpdateOverallEvalByID" Modifier="Public" Name="UpdateOverallEvalByID" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy2" UserSourceName="UpdateOverallEvalByID">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspProjectUpdateOverallEvalByID</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@ProjectRating" Precision="5" ProviderType="SmallInt" Scale="0" Size="2" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@ProjectRepeatYN" Precision="5" ProviderType="SmallInt" Scale="0" Size="2" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProjectEvalComments" Precision="0" ProviderType="NVarChar" Scale="0" Size="1000" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.mspProjectUpdatePPStatusByID" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy2" GeneratorSourceName="UpdatePPStatusByID" Modifier="Public" Name="UpdatePPStatusByID" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy3" UserSourceName="UpdatePPStatusByID">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspProjectUpdatePPStatusByID</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PPStatusID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblProject_ServiceTableAdapter" GeneratorDataComponentClassName="tblProject_ServiceTableAdapter" Name="tblProject_Service" UserDataComponentName="tblProject_ServiceTableAdapter">
<MainSource>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetAll" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetAll" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetAll" UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="True">
<CommandText>SELECT
tblProject_Service.Project_ServiceID, tblProject_Service.ProjectID, tblProject_Service.ServiceID, tblProject_Service.CreatedOn, tblProject_Service.CreatedBy,tblProject_Service.ModifiedOn, tblProject_Service.ModifiedBy,tluService.ServiceStringID,tluService.ServiceText
FROM
tblProject_Service INNER JOIN tluService ON
tblProject_Service.ServiceID = tluService.ServiceID
ORDER BY
tblProject_Service.Project_ServiceID
</CommandText>
<Parameters>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="Project_ServiceID" DataSetColumn="Project_ServiceID" />
<Mapping SourceColumn="ProjectID" DataSetColumn="ProjectID" />
<Mapping SourceColumn="ServiceID" DataSetColumn="ServiceID" />
<Mapping SourceColumn="CreatedOn" DataSetColumn="CreatedOn" />
<Mapping SourceColumn="CreatedBy" DataSetColumn="CreatedBy" />
<Mapping SourceColumn="ModifiedOn" DataSetColumn="ModifiedOn" />
<Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
<Mapping SourceColumn="ServiceStringID" DataSetColumn="ServiceStringID" />
<Mapping SourceColumn="ServiceText" DataSetColumn="ServiceText" />
</Mappings>
<Sources>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.mspProject_ServiceGetByProjectID" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="True" GeneratorGetMethodName="GetByProjectID" GeneratorSourceName="FillByProjectID" GetMethodModifier="Public" GetMethodName="GetByProjectID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetByProjectID" UserSourceName="GetByProjectID1">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspProject_ServiceGetByProjectID</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.mspProject_ServiceInsertUpdateByProjectID" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorSourceName="UpdateByProjectID" Modifier="Public" Name="UpdateByProjectID" QueryType="Scalar" ScalarCallRetval="System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="UpdateByProjectID">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspProject_ServiceInsertUpdateByProjectID</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ServiceStringID" Precision="0" ProviderType="NVarChar" Scale="0" Size="15" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@YesNoOptionValue" Precision="5" ProviderType="SmallInt" Scale="0" Size="2" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CreatedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="mspDateVenueGetByProjectIDTableAdapter" GeneratorDataComponentClassName="mspDateVenueGetByProjectIDTableAdapter" Name="mspDateVenueGetByProjectID" UserDataComponentName="mspDateVenueGetByProjectIDTableAdapter">
<MainSource>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.mspDateVenueGetByProjectID" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetByProjectID" GetMethodModifier="Public" GetMethodName="GetByProjectID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetByProjectID" UserSourceName="GetByProjectID">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspDateVenueGetByProjectID</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="ProjectDateID" DataSetColumn="ProjectDateID" />
<Mapping SourceColumn="ProjectID" DataSetColumn="ProjectID" />
<Mapping SourceColumn="ProposedStartTime" DataSetColumn="ProposedStartTime" />
<Mapping SourceColumn="ProposedEndTime" DataSetColumn="ProposedEndTime" />
<Mapping SourceColumn="MgmtCommContactedYN" DataSetColumn="MgmtCommContactedYN" />
<Mapping SourceColumn="CreatedBy" DataSetColumn="CreatedBy" />
<Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
<Mapping SourceColumn="JKID" DataSetColumn="JKID" />
<Mapping SourceColumn="VenueID" DataSetColumn="VenueID" />
<Mapping SourceColumn="VenueName" DataSetColumn="VenueName" />
<Mapping SourceColumn="VenueTypeID" DataSetColumn="VenueTypeID" />
<Mapping SourceColumn="VenueAddress" DataSetColumn="VenueAddress" />
<Mapping SourceColumn="CityID" DataSetColumn="CityID" />
<Mapping SourceColumn="ProvinceAbbrev" DataSetColumn="ProvinceAbbrev" />
<Mapping SourceColumn="VenuePostalCode" DataSetColumn="VenuePostalCode" />
<Mapping SourceColumn="VenueCapacity" DataSetColumn="VenueCapacity" />
<Mapping SourceColumn="ProposedProjectDate" DataSetColumn="ProposedProjectDate" />
<Mapping SourceColumn="VenueNotes" DataSetColumn="VenueNotes" />
</Mappings>
<Sources>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.mspDateVenueInsertUpdateControl" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="UpdateByProjectID" Modifier="Public" Name="UpdateByProjectID" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="UpdateByProjectID">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspDateVenueInsertUpdateControl</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectDateID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ProposedProjectDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ProposedStartTime" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ProposedEndTime" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@JKID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@MgmtCommContactedYN" Precision="5" ProviderType="SmallInt" Scale="0" Size="2" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VenueName" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VenueTypeID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VenueAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="255" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CityID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VenuePostalCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="7" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@VenueCapacity" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VenueID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.mspProjectDateUpdateProposedProjectDateByID" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorSourceName="UpdateEventDateByID" Modifier="Public" Name="UpdateEventDateByID" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="UpdateEventDateByID">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspProjectDateUpdateProposedProjectDateByID</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectDateID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ProposedProjectDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblProject_TargetSegmentTableAdapter" GeneratorDataComponentClassName="tblProject_TargetSegmentTableAdapter" Name="tblProject_TargetSegment" UserDataComponentName="tblProject_TargetSegmentTableAdapter">
<MainSource>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.tblProject_TargetSegment" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="Text" ModifiedByUser="False">
<CommandText>DELETE FROM [dbo].[tblProject_TargetSegment] WHERE (([Project_TargetSegmentID] = @Original_Project_TargetSegmentID) AND ([ProjectID] = @Original_ProjectID) AND ([TargetSegmentID] = @Original_TargetSegmentID) AND ((@IsNull_IsPrimaryTargetYN = 1 AND [IsPrimaryTargetYN] IS NULL) OR ([IsPrimaryTargetYN] = @Original_IsPrimaryTargetYN)) AND ([CreatedOn] = @Original_CreatedOn) AND ((@IsNull_CreatedBy = 1 AND [CreatedBy] IS NULL) OR ([CreatedBy] = @Original_CreatedBy)) AND ([ModifiedOn] = @Original_ModifiedOn) AND ((@IsNull_ModifiedBy = 1 AND [ModifiedBy] IS NULL) OR ([ModifiedBy] = @Original_ModifiedBy)))</CommandText>
<Parameters>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Project_TargetSegmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Project_TargetSegmentID" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProjectID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProjectID" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TargetSegmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TargetSegmentID" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsPrimaryTargetYN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IsPrimaryTargetYN" SourceColumnNullMapping="True" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IsPrimaryTargetYN" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IsPrimaryTargetYN" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreatedOn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedOn" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CreatedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CreatedBy" SourceColumnNullMapping="True" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CreatedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CreatedBy" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ModifiedOn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedOn" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="True" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="False">
<CommandText>INSERT INTO [dbo].[tblProject_TargetSegment] ([ProjectID], [TargetSegmentID], [IsPrimaryTargetYN], [CreatedOn], [CreatedBy], [ModifiedOn], [ModifiedBy]) VALUES (@ProjectID, @TargetSegmentID, @IsPrimaryTargetYN, @CreatedOn, @CreatedBy, @ModifiedOn, @ModifiedBy);
SELECT Project_TargetSegmentID, ProjectID, TargetSegmentID, IsPrimaryTargetYN, CreatedOn, CreatedBy, ModifiedOn, ModifiedBy FROM tblProject_TargetSegment WHERE (Project_TargetSegmentID = SCOPE_IDENTITY())</CommandText>
<Parameters>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProjectID" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TargetSegmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TargetSegmentID" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IsPrimaryTargetYN" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IsPrimaryTargetYN" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreatedOn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedOn" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CreatedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CreatedBy" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedOn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedOn" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="False">
<CommandText>SELECT Project_TargetSegmentID, ProjectID, TargetSegmentID, IsPrimaryTargetYN, CreatedOn, CreatedBy, ModifiedOn, ModifiedBy FROM dbo.tblProject_TargetSegment</CommandText>
<Parameters>
</Parameters>
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="False">
<CommandText>UPDATE [dbo].[tblProject_TargetSegment] SET [ProjectID] = @ProjectID, [TargetSegmentID] = @TargetSegmentID, [IsPrimaryTargetYN] = @IsPrimaryTargetYN, [CreatedOn] = @CreatedOn, [CreatedBy] = @CreatedBy, [ModifiedOn] = @ModifiedOn, [ModifiedBy] = @ModifiedBy WHERE (([Project_TargetSegmentID] = @Original_Project_TargetSegmentID) AND ([ProjectID] = @Original_ProjectID) AND ([TargetSegmentID] = @Original_TargetSegmentID) AND ((@IsNull_IsPrimaryTargetYN = 1 AND [IsPrimaryTargetYN] IS NULL) OR ([IsPrimaryTargetYN] = @Original_IsPrimaryTargetYN)) AND ([CreatedOn] = @Original_CreatedOn) AND ((@IsNull_CreatedBy = 1 AND [CreatedBy] IS NULL) OR ([CreatedBy] = @Original_CreatedBy)) AND ([ModifiedOn] = @Original_ModifiedOn) AND ((@IsNull_ModifiedBy = 1 AND [ModifiedBy] IS NULL) OR ([ModifiedBy] = @Original_ModifiedBy)));
SELECT Project_TargetSegmentID, ProjectID, TargetSegmentID, IsPrimaryTargetYN, CreatedOn, CreatedBy, ModifiedOn, ModifiedBy FROM tblProject_TargetSegment WHERE (Project_TargetSegmentID = @Project_TargetSegmentID)</CommandText>
<Parameters>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProjectID" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TargetSegmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TargetSegmentID" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IsPrimaryTargetYN" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IsPrimaryTargetYN" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@CreatedOn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedOn" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CreatedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CreatedBy" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ModifiedOn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedOn" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Project_TargetSegmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Project_TargetSegmentID" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ProjectID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProjectID" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TargetSegmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TargetSegmentID" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsPrimaryTargetYN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IsPrimaryTargetYN" SourceColumnNullMapping="True" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IsPrimaryTargetYN" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IsPrimaryTargetYN" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_CreatedOn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="CreatedOn" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CreatedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CreatedBy" SourceColumnNullMapping="True" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CreatedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CreatedBy" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ModifiedOn" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ModifiedOn" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ModifiedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="True" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ModifiedBy" SourceColumnNullMapping="False" SourceVersion="Original">
</Parameter>
<Parameter AllowDbNull="False" AutogeneratedName="Project_TargetSegmentID" ColumnName="Project_TargetSegmentID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Project_TargetSegmentID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Project_TargetSegmentID" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="Project_TargetSegmentID" DataSetColumn="Project_TargetSegmentID" />
<Mapping SourceColumn="ProjectID" DataSetColumn="ProjectID" />
<Mapping SourceColumn="TargetSegmentID" DataSetColumn="TargetSegmentID" />
<Mapping SourceColumn="IsPrimaryTargetYN" DataSetColumn="IsPrimaryTargetYN" />
<Mapping SourceColumn="CreatedOn" DataSetColumn="CreatedOn" />
<Mapping SourceColumn="CreatedBy" DataSetColumn="CreatedBy" />
<Mapping SourceColumn="ModifiedOn" DataSetColumn="ModifiedOn" />
<Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
</Mappings>
<Sources>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tluVenueTableAdapter" GeneratorDataComponentClassName="tluVenueTableAdapter" Name="tluVenue" UserDataComponentName="tluVenueTableAdapter">
<MainSource>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.tluVenue" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetByID" GetMethodModifier="Public" GetMethodName="GetByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetByID" UserSourceName="GetByID">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspVenueGetByID</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VenueID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="VenueID" DataSetColumn="VenueID" />
<Mapping SourceColumn="VenueName" DataSetColumn="VenueName" />
<Mapping SourceColumn="VenueTypeID" DataSetColumn="VenueTypeID" />
<Mapping SourceColumn="VenueAddress" DataSetColumn="VenueAddress" />
<Mapping SourceColumn="CityID" DataSetColumn="CityID" />
<Mapping SourceColumn="VenuePostalCode" DataSetColumn="VenuePostalCode" />
<Mapping SourceColumn="VenueCapacity" DataSetColumn="VenueCapacity" />
<Mapping SourceColumn="VenueNotes" DataSetColumn="VenueNotes" />
</Mappings>
<Sources>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="mspProjectDateGetByIDTableAdapter" GeneratorDataComponentClassName="mspProjectDateGetByIDTableAdapter" Name="mspProjectDateGetByID" UserDataComponentName="mspProjectDateGetByIDTableAdapter">
<MainSource>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.mspProjectDateGetByID" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetByID" GetMethodModifier="Public" GetMethodName="GetByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetByID" UserSourceName="GetByID">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspProjectDateGetByID</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectDateID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="ProjectDateID" DataSetColumn="ProjectDateID" />
<Mapping SourceColumn="ProjectID" DataSetColumn="ProjectID" />
<Mapping SourceColumn="ProposedProjectDate" DataSetColumn="ProposedProjectDate" />
<Mapping SourceColumn="ProposedStartTime" DataSetColumn="ProposedStartTime" />
<Mapping SourceColumn="ProposedEndTime" DataSetColumn="ProposedEndTime" />
<Mapping SourceColumn="JKID" DataSetColumn="JKID" />
<Mapping SourceColumn="JKName" DataSetColumn="JKName" />
<Mapping SourceColumn="MgmtCommContactedYN" DataSetColumn="MgmtCommContactedYN" />
<Mapping SourceColumn="VenueID" DataSetColumn="VenueID" />
<Mapping SourceColumn="VenueName" DataSetColumn="VenueName" />
<Mapping SourceColumn="VenueTypeID" DataSetColumn="VenueTypeID" />
<Mapping SourceColumn="VenueAddress" DataSetColumn="VenueAddress" />
<Mapping SourceColumn="CityID" DataSetColumn="CityID" />
<Mapping SourceColumn="CityName" DataSetColumn="CityName" />
<Mapping SourceColumn="ProvinceAbbrev" DataSetColumn="ProvinceAbbrev" />
<Mapping SourceColumn="VenuePostalCode" DataSetColumn="VenuePostalCode" />
<Mapping SourceColumn="VenueCapacity" DataSetColumn="VenueCapacity" />
<Mapping SourceColumn="VenueNotes" DataSetColumn="VenueNotes" />
<Mapping SourceColumn="SeatingRating" DataSetColumn="SeatingRating" />
<Mapping SourceColumn="ParkingRating" DataSetColumn="ParkingRating" />
<Mapping SourceColumn="LocationRating" DataSetColumn="LocationRating" />
<Mapping SourceColumn="ServingRefreshmentsRating" DataSetColumn="ServingRefreshmentsRating" />
<Mapping SourceColumn="MaterialPresentedRating" DataSetColumn="MaterialPresentedRating" />
<Mapping SourceColumn="AudienceLearningRating" DataSetColumn="AudienceLearningRating" />
<Mapping SourceColumn="SpeakerKnowledgeStyleRating" DataSetColumn="SpeakerKnowledgeStyleRating" />
<Mapping SourceColumn="HandoutMaterialRating" DataSetColumn="HandoutMaterialRating" />
<Mapping SourceColumn="TimeManagementRating" DataSetColumn="TimeManagementRating" />
<Mapping SourceColumn="RefreshmentsRating" DataSetColumn="RefreshmentsRating" />
<Mapping SourceColumn="MarketingRating" DataSetColumn="MarketingRating" />
<Mapping SourceColumn="VolunteerServicesRating" DataSetColumn="VolunteerServicesRating" />
<Mapping SourceColumn="ItemsKeepSame" DataSetColumn="ItemsKeepSame" />
<Mapping SourceColumn="ItemsToChange" DataSetColumn="ItemsToChange" />
<Mapping SourceColumn="AdditionalComments" DataSetColumn="AdditionalComments" />
<Mapping SourceColumn="CreatedBy" DataSetColumn="CreatedBy" />
<Mapping SourceColumn="ModifiedBy" DataSetColumn="ModifiedBy" />
<Mapping SourceColumn="formattedStartTime" DataSetColumn="formattedStartTime" />
<Mapping SourceColumn="formattedEndTime" DataSetColumn="formattedEndTime" />
<Mapping SourceColumn="UnformattedProjectDate" DataSetColumn="UnformattedProjectDate" />
<Mapping SourceColumn="AbsoluteVenueName" DataSetColumn="AbsoluteVenueName" />
</Mappings>
<Sources>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.mspProjectDateUpdateEvalByID" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="UpdateEvalByID" Modifier="Public" Name="UpdateEvalByID" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="UpdateEvalByID">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspProjectDateUpdateEvalByID</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectDateID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SeatingRating" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ParkingRating" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LocationRating" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ServingRefreshmentsRating" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MaterialPresentedRating" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AudienceLearningRating" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SpeakerKnowledgeStyleRating" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@HandoutMaterialRating" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TimeManagementRating" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RefreshmentsRating" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MarketingRating" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VolunteerServicesRating" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ItemsKeepSame" Precision="0" ProviderType="NVarChar" Scale="0" Size="300" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ItemsToChange" Precision="0" ProviderType="NVarChar" Scale="0" Size="300" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AdditionalComments" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="mspProjectCommitteeGetByProjectIDTableAdapter" GeneratorDataComponentClassName="mspProjectCommitteeGetByProjectIDTableAdapter" Name="mspProjectCommitteeGetByProjectID" UserDataComponentName="mspProjectCommitteeGetByProjectIDTableAdapter">
<MainSource>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.mspProjectCommitteeGetByProjectID" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetByProjectID" GetMethodModifier="Public" GetMethodName="GetByProjectID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetByProjectID" UserSourceName="GetByProjectID">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspProjectCommitteeGetByProjectID</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProjectID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="BoardPortfolioID" DataSetColumn="BoardPortfolioID" />
<Mapping SourceColumn="BoardPortfolioName" DataSetColumn="BoardPortfolioName" />
<Mapping SourceColumn="BoardPortfolioAbbrev" DataSetColumn="BoardPortfolioAbbrev" />
<Mapping SourceColumn="IsPrimaryOrganizerYN" DataSetColumn="IsPrimaryOrganizerYN" />
<Mapping SourceColumn="CommitteeID" DataSetColumn="CommitteeID" />
<Mapping SourceColumn="CommitteeName" DataSetColumn="CommitteeName" />
<Mapping SourceColumn="ActiveYN" DataSetColumn="ActiveYN" />
</Mappings>
<Sources>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tluBoardPortfolioTableAdapter" GeneratorDataComponentClassName="tluBoardPortfolioTableAdapter" Name="tluBoardPortfolio" UserDataComponentName="tluBoardPortfolioTableAdapter">
<MainSource>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.tluBoardPortfolio" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="False" GeneratorGetMethodName="GetByID" GetMethodModifier="Public" GetMethodName="GetByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetByID" UserSourceName="GetByID">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspBoardPortfolioGetByID</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BoardPortfolioID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="BoardPortfolioID" DataSetColumn="BoardPortfolioID" />
<Mapping SourceColumn="BoardPortfolioName" DataSetColumn="BoardPortfolioName" />
<Mapping SourceColumn="BoardPortfolioAbbrev" DataSetColumn="BoardPortfolioAbbrev" />
<Mapping SourceColumn="AspnetUserRoleName" DataSetColumn="AspnetUserRoleName" />
<Mapping SourceColumn="ActiveYN" DataSetColumn="ActiveYN" />
</Mappings>
<Sources>
</Sources>
</TableAdapter>
</Tables>
<Sources>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.mspProjectInsert" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorSourceName="mspProjectInsert" MethodsParameterType="CLR" Modifier="Public" Name="mspProjectInsert" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="mspProjectInsert">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspProjectInsert</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProjectTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="255" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COENumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@COADept" Precision="0" ProviderType="NVarChar" Scale="0" Size="7" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PPTypeID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProjectDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="1000" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OriginatorContactID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PPSubmissionDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PPReceivedDate" Precision="23" ProviderType="DateTime" Scale="3" Size="8" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@PartOfOperationalPlanYN" Precision="5" ProviderType="SmallInt" Scale="0" Size="2" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProjectNotes" Precision="0" ProviderType="NVarChar" Scale="0" Size="1000" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CreatedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="cnPPDB (Web.config)" DbObjectName="PPDB.dbo.mspCOEDataInsertUpdateControl" DbObjectType="StoredProcedure" GenerateShortCommands="True" GeneratorSourceName="InsertUpdateCOEData" MethodsParameterType="CLR" Modifier="Public" Name="InsertUpdateCOEData" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy1" UserSourceName="InsertUpdateCOEData">
<SelectCommand>
<DbCommand CommandType="StoredProcedure" ModifiedByUser="False">
<CommandText>dbo.mspCOEDataInsertUpdateControl</CommandText>
<Parameters>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProjectTitle" Precision="0" ProviderType="NVarChar" Scale="0" Size="255" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="InputOutput" ParameterName="@COENumber" Precision="0" ProviderType="NVarChar" Scale="0" Size="10" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EventCategoryID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProjectDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="1000" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProjectNotes" Precision="0" ProviderType="NVarChar" Scale="0" Size="1000" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CreatedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ModifiedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PrimaryBoardPortfolioID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@KeyPartners" Precision="0" ProviderType="NVarChar" Scale="0" Size="200" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PrimaryTargetSegmentID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SecondaryTargetSegments" Precision="0" ProviderType="NVarChar" Scale="0" Size="200" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@ExpectedParticipants" Precision="5" ProviderType="SmallInt" Scale="0" Size="2" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ProposedStartDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ProposedStartTime" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ProposedEndDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ProposedEndTime" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ProposedJKLocationID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PPStatusID" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="dsProject" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsProject" msprop:Generator_DataSetName="dsProject">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="tblProject" msprop:Generator_UserTableName="tblProject" msprop:Generator_RowDeletedName="tblProjectRowDeleted" msprop:Generator_RowChangedName="tblProjectRowChanged" msprop:Generator_RowClassName="tblProjectRow" msprop:Generator_RowChangingName="tblProjectRowChanging" msprop:Generator_RowEvArgName="tblProjectRowChangeEvent" msprop:Generator_RowEvHandlerName="tblProjectRowChangeEventHandler" msprop:Generator_TableClassName="tblProjectDataTable" msprop:Generator_TableVarName="tabletblProject" msprop:Generator_RowDeletingName="tblProjectRowDeleting" msprop:Generator_TablePropName="tblProject">
<xs:complexType>
<xs:sequence>
<xs:element name="ProjectID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ProjectID" msprop:Generator_ColumnPropNameInRow="ProjectID" msprop:Generator_ColumnVarNameInTable="columnProjectID" msprop:Generator_ColumnPropNameInTable="ProjectIDColumn" type="xs:int" />
<xs:element name="ProjectTitle" msprop:Generator_UserColumnName="ProjectTitle" msprop:Generator_ColumnPropNameInRow="ProjectTitle" msprop:Generator_ColumnVarNameInTable="columnProjectTitle" msprop:Generator_ColumnPropNameInTable="ProjectTitleColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="COENumber" msprop:Generator_UserColumnName="COENumber" msprop:Generator_ColumnPropNameInRow="COENumber" msprop:Generator_ColumnVarNameInTable="columnCOENumber" msprop:Generator_ColumnPropNameInTable="COENumberColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="COADept" msprop:Generator_UserColumnName="COADept" msprop:Generator_ColumnPropNameInRow="COADept" msprop:Generator_ColumnVarNameInTable="columnCOADept" msprop:Generator_ColumnPropNameInTable="COADeptColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="7" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ProjectDescription" msprop:Generator_UserColumnName="ProjectDescription" msprop:Generator_ColumnPropNameInRow="ProjectDescription" msprop:Generator_ColumnVarNameInTable="columnProjectDescription" msprop:Generator_ColumnPropNameInTable="ProjectDescriptionColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="1000" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="OriginatorContactID" msprop:Generator_UserColumnName="OriginatorContactID" msprop:Generator_ColumnPropNameInRow="OriginatorContactID" msprop:Generator_ColumnVarNameInTable="columnOriginatorContactID" msprop:Generator_ColumnPropNameInTable="OriginatorContactIDColumn" type="xs:int" />
<xs:element name="PPSubmissionDate" msprop:Generator_UserColumnName="PPSubmissionDate" msprop:Generator_ColumnPropNameInRow="PPSubmissionDate" msprop:Generator_ColumnVarNameInTable="columnPPSubmissionDate" msprop:Generator_ColumnPropNameInTable="PPSubmissionDateColumn" type="xs:dateTime" minOccurs="0" />
<xs:element name="PPReceivedDate" msprop:Generator_UserColumnName="PPReceivedDate" msprop:Generator_ColumnPropNameInRow="PPReceivedDate" msprop:Generator_ColumnVarNameInTable="columnPPReceivedDate" msprop:Generator_ColumnPropNameInTable="PPReceivedDateColumn" type="xs:dateTime" minOccurs="0" />
<xs:element name="PartOfOperationalPlanYN" msprop:Generator_UserColumnName="PartOfOperationalPlanYN" msprop:Generator_ColumnPropNameInRow="PartOfOperationalPlanYN" msprop:Generator_ColumnVarNameInTable="columnPartOfOperationalPlanYN" msprop:Generator_ColumnPropNameInTable="PartOfOperationalPlanYNColumn" type="xs:short" minOccurs="0" />
<xs:element name="ProjectNotes" msprop:Generator_UserColumnName="ProjectNotes" msprop:nullValue="" msprop:Generator_ColumnPropNameInRow="ProjectNotes" msprop:Generator_ColumnPropNameInTable="ProjectNotesColumn" msprop:Generator_ColumnVarNameInTable="columnProjectNotes" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="1000" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="BudgetNotes" msprop:Generator_UserColumnName="BudgetNotes" msprop:Generator_ColumnPropNameInRow="BudgetNotes" msprop:Generator_ColumnVarNameInTable="columnBudgetNotes" msprop:Generator_ColumnPropNameInTable="BudgetNotesColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="1000" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ProjectRating" msprop:Generator_UserColumnName="ProjectRating" msprop:Generator_ColumnPropNameInRow="ProjectRating" msprop:Generator_ColumnVarNameInTable="columnProjectRating" msprop:Generator_ColumnPropNameInTable="ProjectRatingColumn" type="xs:short" minOccurs="0" />
<xs:element name="ProjectRepeatYN" msprop:Generator_UserColumnName="ProjectRepeatYN" msprop:Generator_ColumnPropNameInRow="ProjectRepeatYN" msprop:Generator_ColumnVarNameInTable="columnProjectRepeatYN" msprop:Generator_ColumnPropNameInTable="ProjectRepeatYNColumn" type="xs:short" minOccurs="0" />
<xs:element name="ProjectEvalComments" msprop:Generator_UserColumnName="ProjectEvalComments" msprop:Generator_ColumnPropNameInRow="ProjectEvalComments" msprop:Generator_ColumnVarNameInTable="columnProjectEvalComments" msprop:Generator_ColumnPropNameInTable="ProjectEvalCommentsColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="1000" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CreatedOn" msprop:Generator_UserColumnName="CreatedOn" msprop:Generator_ColumnPropNameInRow="CreatedOn" msprop:Generator_ColumnVarNameInTable="columnCreatedOn" msprop:Generator_ColumnPropNameInTable="CreatedOnColumn" type="xs:dateTime" />
<xs:element name="CreatedBy" msprop:Generator_UserColumnName="CreatedBy" msprop:Generator_ColumnPropNameInRow="CreatedBy" msprop:Generator_ColumnVarNameInTable="columnCreatedBy" msprop:Generator_ColumnPropNameInTable="CreatedByColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ModifiedOn" msprop:Generator_UserColumnName="ModifiedOn" msprop:Generator_ColumnPropNameInRow="ModifiedOn" msprop:Generator_ColumnVarNameInTable="columnModifiedOn" msprop:Generator_ColumnPropNameInTable="ModifiedOnColumn" type="xs:dateTime" />
<xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ActiveYN" msprop:Generator_UserColumnName="ActiveYN" msprop:Generator_ColumnPropNameInRow="ActiveYN" msprop:Generator_ColumnVarNameInTable="columnActiveYN" msprop:Generator_ColumnPropNameInTable="ActiveYNColumn" type="xs:short" />
<xs:element name="EditableYN" msprop:Generator_UserColumnName="EditableYN" msprop:Generator_ColumnPropNameInRow="EditableYN" msprop:Generator_ColumnVarNameInTable="columnEditableYN" msprop:Generator_ColumnPropNameInTable="EditableYNColumn" type="xs:short" />
<xs:element name="ApprovedBudget" msprop:Generator_UserColumnName="ApprovedBudget" msprop:Generator_ColumnPropNameInRow="ApprovedBudget" msprop:Generator_ColumnVarNameInTable="columnApprovedBudget" msprop:Generator_ColumnPropNameInTable="ApprovedBudgetColumn" type="xs:decimal" minOccurs="0" />
<xs:element name="Budget" msprop:Generator_UserColumnName="Budget" msprop:Generator_ColumnPropNameInRow="Budget" msprop:Generator_ColumnVarNameInTable="columnBudget" msprop:Generator_ColumnPropNameInTable="BudgetColumn" type="xs:decimal" minOccurs="0" />
<xs:element name="Actual" msprop:Generator_UserColumnName="Actual" msprop:Generator_ColumnPropNameInRow="Actual" msprop:Generator_ColumnVarNameInTable="columnActual" msprop:Generator_ColumnPropNameInTable="ActualColumn" type="xs:decimal" minOccurs="0" />
<xs:element name="Variance" msprop:Generator_UserColumnName="Variance" msprop:Generator_ColumnPropNameInRow="Variance" msprop:Generator_ColumnVarNameInTable="columnVariance" msprop:Generator_ColumnPropNameInTable="VarianceColumn" type="xs:decimal" minOccurs="0" />
<xs:element name="PPStatusID" msprop:Generator_UserColumnName="PPStatusID" msprop:Generator_ColumnPropNameInRow="PPStatusID" msprop:Generator_ColumnVarNameInTable="columnPPStatusID" msprop:Generator_ColumnPropNameInTable="PPStatusIDColumn" type="xs:int" />
<xs:element name="GLCode" msprop:Generator_UserColumnName="GLCode" msprop:Generator_ColumnVarNameInTable="columnGLCode" msprop:Generator_ColumnPropNameInRow="GLCode" msprop:Generator_ColumnPropNameInTable="GLCodeColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="EventCategoryID" msprop:Generator_UserColumnName="EventCategoryID" msprop:Generator_ColumnVarNameInTable="columnEventCategoryID" msprop:Generator_ColumnPropNameInRow="EventCategoryID" msprop:Generator_ColumnPropNameInTable="EventCategoryIDColumn" type="xs:int" minOccurs="0" />
<xs:element name="CommitteeName" msprop:Generator_UserColumnName="CommitteeName" msprop:Generator_ColumnVarNameInTable="columnCommitteeName" msprop:Generator_ColumnPropNameInRow="CommitteeName" msprop:Generator_ColumnPropNameInTable="CommitteeNameColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="BoardPortfolioID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="BoardPortfolioID" msprop:Generator_ColumnVarNameInTable="columnBoardPortfolioID" msprop:Generator_ColumnPropNameInRow="BoardPortfolioID" msprop:Generator_ColumnPropNameInTable="BoardPortfolioIDColumn" type="xs:int" />
<xs:element name="BoardPortfolioName" msprop:Generator_UserColumnName="BoardPortfolioName" msprop:Generator_ColumnVarNameInTable="columnBoardPortfolioName" msprop:Generator_ColumnPropNameInRow="BoardPortfolioName" msprop:Generator_ColumnPropNameInTable="BoardPortfolioNameColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="PPStatus" msprop:Generator_UserColumnName="PPStatus" msprop:Generator_ColumnVarNameInTable="columnPPStatus" msprop:Generator_ColumnPropNameInRow="PPStatus" msprop:Generator_ColumnPropNameInTable="PPStatusColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ProposedProjectDate" msprop:Generator_UserColumnName="ProposedProjectDate" msprop:Generator_ColumnVarNameInTable="columnProposedProjectDate" msprop:Generator_ColumnPropNameInRow="ProposedProjectDate" msprop:Generator_ColumnPropNameInTable="ProposedProjectDateColumn" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tblProject_Service" msprop:Generator_UserTableName="tblProject_Service" msprop:Generator_RowDeletedName="tblProject_ServiceRowDeleted" msprop:Generator_RowChangedName="tblProject_ServiceRowChanged" msprop:Generator_RowClassName="tblProject_ServiceRow" msprop:Generator_RowChangingName="tblProject_ServiceRowChanging" msprop:Generator_RowEvArgName="tblProject_ServiceRowChangeEvent" msprop:Generator_RowEvHandlerName="tblProject_ServiceRowChangeEventHandler" msprop:Generator_TableClassName="tblProject_ServiceDataTable" msprop:Generator_TableVarName="tabletblProject_Service" msprop:Generator_RowDeletingName="tblProject_ServiceRowDeleting" msprop:Generator_TablePropName="tblProject_Service">
<xs:complexType>
<xs:sequence>
<xs:element name="Project_ServiceID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Project_ServiceID" msprop:Generator_ColumnPropNameInRow="Project_ServiceID" msprop:Generator_ColumnVarNameInTable="columnProject_ServiceID" msprop:Generator_ColumnPropNameInTable="Project_ServiceIDColumn" type="xs:int" />
<xs:element name="ProjectID" msprop:Generator_UserColumnName="ProjectID" msprop:Generator_ColumnPropNameInRow="ProjectID" msprop:Generator_ColumnVarNameInTable="columnProjectID" msprop:Generator_ColumnPropNameInTable="ProjectIDColumn" type="xs:int" />
<xs:element name="ServiceID" msprop:Generator_UserColumnName="ServiceID" msprop:Generator_ColumnPropNameInRow="ServiceID" msprop:Generator_ColumnVarNameInTable="columnServiceID" msprop:Generator_ColumnPropNameInTable="ServiceIDColumn" type="xs:int" />
<xs:element name="CreatedOn" msprop:Generator_UserColumnName="CreatedOn" msprop:Generator_ColumnPropNameInRow="CreatedOn" msprop:Generator_ColumnVarNameInTable="columnCreatedOn" msprop:Generator_ColumnPropNameInTable="CreatedOnColumn" type="xs:dateTime" />
<xs:element name="CreatedBy" msprop:Generator_UserColumnName="CreatedBy" msprop:Generator_ColumnPropNameInRow="CreatedBy" msprop:Generator_ColumnVarNameInTable="columnCreatedBy" msprop:Generator_ColumnPropNameInTable="CreatedByColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ModifiedOn" msprop:Generator_UserColumnName="ModifiedOn" msprop:Generator_ColumnPropNameInRow="ModifiedOn" msprop:Generator_ColumnVarNameInTable="columnModifiedOn" msprop:Generator_ColumnPropNameInTable="ModifiedOnColumn" type="xs:dateTime" />
<xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ServiceStringID" msprop:Generator_UserColumnName="ServiceStringID" msprop:Generator_ColumnPropNameInRow="ServiceStringID" msprop:Generator_ColumnVarNameInTable="columnServiceStringID" msprop:Generator_ColumnPropNameInTable="ServiceStringIDColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="15" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ServiceText" msprop:Generator_UserColumnName="ServiceText" msprop:Generator_ColumnPropNameInRow="ServiceText" msprop:Generator_ColumnVarNameInTable="columnServiceText" msprop:Generator_ColumnPropNameInTable="ServiceTextColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="mspDateVenueGetByProjectID" msprop:Generator_UserTableName="mspDateVenueGetByProjectID" msprop:Generator_RowDeletedName="mspDateVenueGetByProjectIDRowDeleted" msprop:Generator_RowChangedName="mspDateVenueGetByProjectIDRowChanged" msprop:Generator_RowClassName="mspDateVenueGetByProjectIDRow" msprop:Generator_RowChangingName="mspDateVenueGetByProjectIDRowChanging" msprop:Generator_RowEvArgName="mspDateVenueGetByProjectIDRowChangeEvent" msprop:Generator_RowEvHandlerName="mspDateVenueGetByProjectIDRowChangeEventHandler" msprop:Generator_TableClassName="mspDateVenueGetByProjectIDDataTable" msprop:Generator_TableVarName="tablemspDateVenueGetByProjectID" msprop:Generator_RowDeletingName="mspDateVenueGetByProjectIDRowDeleting" msprop:Generator_TablePropName="mspDateVenueGetByProjectID">
<xs:complexType>
<xs:sequence>
<xs:element name="ProjectDateID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="ProjectDateID" msprop:Generator_ColumnPropNameInRow="ProjectDateID" msprop:Generator_ColumnVarNameInTable="columnProjectDateID" msprop:Generator_ColumnPropNameInTable="ProjectDateIDColumn" type="xs:int" minOccurs="0" />
<xs:element name="ProjectID" msprop:Generator_UserColumnName="ProjectID" msprop:Generator_ColumnPropNameInRow="ProjectID" msprop:Generator_ColumnVarNameInTable="columnProjectID" msprop:Generator_ColumnPropNameInTable="ProjectIDColumn" type="xs:int" minOccurs="0" />
<xs:element name="ProposedStartTime" msprop:Generator_UserColumnName="ProposedStartTime" msprop:Generator_ColumnPropNameInRow="ProposedStartTime" msprop:Generator_ColumnVarNameInTable="columnProposedStartTime" msprop:Generator_ColumnPropNameInTable="ProposedStartTimeColumn" type="xs:short" minOccurs="0" />
<xs:element name="ProposedEndTime" msprop:Generator_UserColumnName="ProposedEndTime" msprop:Generator_ColumnPropNameInRow="ProposedEndTime" msprop:Generator_ColumnVarNameInTable="columnProposedEndTime" msprop:Generator_ColumnPropNameInTable="ProposedEndTimeColumn" type="xs:short" minOccurs="0" />
<xs:element name="MgmtCommContactedYN" msprop:Generator_UserColumnName="MgmtCommContactedYN" msprop:Generator_ColumnPropNameInRow="MgmtCommContactedYN" msprop:Generator_ColumnVarNameInTable="columnMgmtCommContactedYN" msprop:Generator_ColumnPropNameInTable="MgmtCommContactedYNColumn" type="xs:short" minOccurs="0" />
<xs:element name="CreatedBy" msprop:Generator_UserColumnName="CreatedBy" msprop:Generator_ColumnPropNameInRow="CreatedBy" msprop:Generator_ColumnVarNameInTable="columnCreatedBy" msprop:Generator_ColumnPropNameInTable="CreatedByColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="JKID" msprop:Generator_UserColumnName="JKID" msprop:Generator_ColumnPropNameInRow="JKID" msprop:Generator_ColumnVarNameInTable="columnJKID" msprop:Generator_ColumnPropNameInTable="JKIDColumn" type="xs:int" minOccurs="0" />
<xs:element name="VenueID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="VenueID" msprop:Generator_ColumnPropNameInRow="VenueID" msprop:Generator_ColumnVarNameInTable="columnVenueID" msprop:Generator_ColumnPropNameInTable="VenueIDColumn" type="xs:int" minOccurs="0" />
<xs:element name="VenueName" msprop:Generator_UserColumnName="VenueName" msprop:Generator_ColumnPropNameInRow="VenueName" msprop:Generator_ColumnVarNameInTable="columnVenueName" msprop:Generator_ColumnPropNameInTable="VenueNameColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="VenueTypeID" msprop:Generator_UserColumnName="VenueTypeID" msprop:Generator_ColumnPropNameInRow="VenueTypeID" msprop:Generator_ColumnVarNameInTable="columnVenueTypeID" msprop:Generator_ColumnPropNameInTable="VenueTypeIDColumn" type="xs:int" minOccurs="0" />
<xs:element name="VenueAddress" msprop:Generator_UserColumnName="VenueAddress" msprop:Generator_ColumnPropNameInRow="VenueAddress" msprop:Generator_ColumnVarNameInTable="columnVenueAddress" msprop:Generator_ColumnPropNameInTable="VenueAddressColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CityID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="CityID" msprop:Generator_ColumnPropNameInRow="CityID" msprop:Generator_ColumnVarNameInTable="columnCityID" msprop:Generator_ColumnPropNameInTable="CityIDColumn" type="xs:int" minOccurs="0" />
<xs:element name="ProvinceAbbrev" msprop:Generator_UserColumnName="ProvinceAbbrev" msprop:Generator_ColumnPropNameInRow="ProvinceAbbrev" msprop:Generator_ColumnVarNameInTable="columnProvinceAbbrev" msprop:Generator_ColumnPropNameInTable="ProvinceAbbrevColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="3" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="VenuePostalCode" msprop:Generator_UserColumnName="VenuePostalCode" msprop:Generator_ColumnPropNameInRow="VenuePostalCode" msprop:Generator_ColumnVarNameInTable="columnVenuePostalCode" msprop:Generator_ColumnPropNameInTable="VenuePostalCodeColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="7" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="VenueCapacity" msprop:Generator_UserColumnName="VenueCapacity" msprop:Generator_ColumnPropNameInRow="VenueCapacity" msprop:Generator_ColumnVarNameInTable="columnVenueCapacity" msprop:Generator_ColumnPropNameInTable="VenueCapacityColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ProposedProjectDate" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ProposedProjectDate" msprop:Generator_ColumnVarNameInTable="columnProposedProjectDate" msprop:Generator_ColumnPropNameInRow="ProposedProjectDate" msprop:Generator_ColumnPropNameInTable="ProposedProjectDateColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="11" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="VenueNotes" msprop:Generator_UserColumnName="VenueNotes" msprop:nullValue="_empty" msprop:Generator_ColumnVarNameInTable="columnVenueNotes" msprop:Generator_ColumnPropNameInTable="VenueNotesColumn" msprop:Generator_ColumnPropNameInRow="VenueNotes" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="1000" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tblProject_TargetSegment" msprop:Generator_UserTableName="tblProject_TargetSegment" msprop:Generator_RowDeletedName="tblProject_TargetSegmentRowDeleted" msprop:Generator_RowChangedName="tblProject_TargetSegmentRowChanged" msprop:Generator_RowClassName="tblProject_TargetSegmentRow" msprop:Generator_RowChangingName="tblProject_TargetSegmentRowChanging" msprop:Generator_RowEvArgName="tblProject_TargetSegmentRowChangeEvent" msprop:Generator_RowEvHandlerName="tblProject_TargetSegmentRowChangeEventHandler" msprop:Generator_TableClassName="tblProject_TargetSegmentDataTable" msprop:Generator_TableVarName="tabletblProject_TargetSegment" msprop:Generator_RowDeletingName="tblProject_TargetSegmentRowDeleting" msprop:Generator_TablePropName="tblProject_TargetSegment">
<xs:complexType>
<xs:sequence>
<xs:element name="Project_TargetSegmentID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Project_TargetSegmentID" msprop:Generator_ColumnVarNameInTable="columnProject_TargetSegmentID" msprop:Generator_ColumnPropNameInRow="Project_TargetSegmentID" msprop:Generator_ColumnPropNameInTable="Project_TargetSegmentIDColumn" type="xs:int" />
<xs:element name="ProjectID" msprop:Generator_UserColumnName="ProjectID" msprop:Generator_ColumnVarNameInTable="columnProjectID" msprop:Generator_ColumnPropNameInRow="ProjectID" msprop:Generator_ColumnPropNameInTable="ProjectIDColumn" type="xs:int" />
<xs:element name="TargetSegmentID" msprop:Generator_UserColumnName="TargetSegmentID" msprop:Generator_ColumnVarNameInTable="columnTargetSegmentID" msprop:Generator_ColumnPropNameInRow="TargetSegmentID" msprop:Generator_ColumnPropNameInTable="TargetSegmentIDColumn" type="xs:int" />
<xs:element name="IsPrimaryTargetYN" msprop:Generator_UserColumnName="IsPrimaryTargetYN" msprop:Generator_ColumnVarNameInTable="columnIsPrimaryTargetYN" msprop:Generator_ColumnPropNameInRow="IsPrimaryTargetYN" msprop:Generator_ColumnPropNameInTable="IsPrimaryTargetYNColumn" type="xs:short" minOccurs="0" />
<xs:element name="CreatedOn" msprop:Generator_UserColumnName="CreatedOn" msprop:Generator_ColumnVarNameInTable="columnCreatedOn" msprop:Generator_ColumnPropNameInRow="CreatedOn" msprop:Generator_ColumnPropNameInTable="CreatedOnColumn" type="xs:dateTime" />
<xs:element name="CreatedBy" msprop:Generator_UserColumnName="CreatedBy" msprop:Generator_ColumnVarNameInTable="columnCreatedBy" msprop:Generator_ColumnPropNameInRow="CreatedBy" msprop:Generator_ColumnPropNameInTable="CreatedByColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ModifiedOn" msprop:Generator_UserColumnName="ModifiedOn" msprop:Generator_ColumnVarNameInTable="columnModifiedOn" msprop:Generator_ColumnPropNameInRow="ModifiedOn" msprop:Generator_ColumnPropNameInTable="ModifiedOnColumn" type="xs:dateTime" />
<xs:element name="ModifiedBy" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tluVenue" msprop:Generator_UserTableName="tluVenue" msprop:Generator_RowDeletedName="tluVenueRowDeleted" msprop:Generator_RowChangedName="tluVenueRowChanged" msprop:Generator_RowClassName="tluVenueRow" msprop:Generator_RowChangingName="tluVenueRowChanging" msprop:Generator_RowEvArgName="tluVenueRowChangeEvent" msprop:Generator_RowEvHandlerName="tluVenueRowChangeEventHandler" msprop:Generator_TableClassName="tluVenueDataTable" msprop:Generator_TableVarName="tabletluVenue" msprop:Generator_RowDeletingName="tluVenueRowDeleting" msprop:Generator_TablePropName="tluVenue">
<xs:complexType>
<xs:sequence>
<xs:element name="VenueID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="VenueID" msprop:Generator_ColumnVarNameInTable="columnVenueID" msprop:Generator_ColumnPropNameInRow="VenueID" msprop:Generator_ColumnPropNameInTable="VenueIDColumn" type="xs:int" />
<xs:element name="VenueName" msprop:Generator_UserColumnName="VenueName" msprop:Generator_ColumnVarNameInTable="columnVenueName" msprop:Generator_ColumnPropNameInRow="VenueName" msprop:Generator_ColumnPropNameInTable="VenueNameColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="VenueTypeID" msprop:Generator_UserColumnName="VenueTypeID" msprop:Generator_ColumnVarNameInTable="columnVenueTypeID" msprop:Generator_ColumnPropNameInRow="VenueTypeID" msprop:Generator_ColumnPropNameInTable="VenueTypeIDColumn" type="xs:int" />
<xs:element name="VenueAddress" msprop:Generator_UserColumnName="VenueAddress" msprop:Generator_ColumnVarNameInTable="columnVenueAddress" msprop:Generator_ColumnPropNameInRow="VenueAddress" msprop:Generator_ColumnPropNameInTable="VenueAddressColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CityID" msprop:Generator_UserColumnName="CityID" msprop:Generator_ColumnVarNameInTable="columnCityID" msprop:Generator_ColumnPropNameInRow="CityID" msprop:Generator_ColumnPropNameInTable="CityIDColumn" type="xs:int" />
<xs:element name="VenuePostalCode" msprop:Generator_UserColumnName="VenuePostalCode" msprop:Generator_ColumnVarNameInTable="columnVenuePostalCode" msprop:Generator_ColumnPropNameInRow="VenuePostalCode" msprop:Generator_ColumnPropNameInTable="VenuePostalCodeColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="7" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="VenueCapacity" msprop:Generator_UserColumnName="VenueCapacity" msprop:Generator_ColumnVarNameInTable="columnVenueCapacity" msprop:Generator_ColumnPropNameInRow="VenueCapacity" msprop:Generator_ColumnPropNameInTable="VenueCapacityColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="VenueNotes" msprop:Generator_UserColumnName="VenueNotes" msprop:Generator_ColumnVarNameInTable="columnVenueNotes" msprop:Generator_ColumnPropNameInRow="VenueNotes" msprop:Generator_ColumnPropNameInTable="VenueNotesColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="1000" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="mspProjectDateGetByID" msprop:Generator_UserTableName="mspProjectDateGetByID" msprop:Generator_RowDeletedName="mspProjectDateGetByIDRowDeleted" msprop:Generator_RowChangedName="mspProjectDateGetByIDRowChanged" msprop:Generator_RowClassName="mspProjectDateGetByIDRow" msprop:Generator_RowChangingName="mspProjectDateGetByIDRowChanging" msprop:Generator_RowEvArgName="mspProjectDateGetByIDRowChangeEvent" msprop:Generator_RowEvHandlerName="mspProjectDateGetByIDRowChangeEventHandler" msprop:Generator_TableClassName="mspProjectDateGetByIDDataTable" msprop:Generator_TableVarName="tablemspProjectDateGetByID" msprop:Generator_RowDeletingName="mspProjectDateGetByIDRowDeleting" msprop:Generator_TablePropName="mspProjectDateGetByID">
<xs:complexType>
<xs:sequence>
<xs:element name="ProjectDateID" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ProjectDateID" msprop:Generator_ColumnPropNameInRow="ProjectDateID" msprop:Generator_ColumnVarNameInTable="columnProjectDateID" msprop:Generator_ColumnPropNameInTable="ProjectDateIDColumn" type="xs:int" minOccurs="0" />
<xs:element name="ProjectID" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ProjectID" msprop:Generator_ColumnPropNameInRow="ProjectID" msprop:Generator_ColumnVarNameInTable="columnProjectID" msprop:Generator_ColumnPropNameInTable="ProjectIDColumn" type="xs:int" minOccurs="0" />
<xs:element name="ProposedProjectDate" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ProposedProjectDate" msprop:Generator_ColumnPropNameInRow="ProposedProjectDate" msprop:Generator_ColumnVarNameInTable="columnProposedProjectDate" msprop:Generator_ColumnPropNameInTable="ProposedProjectDateColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="11" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ProposedStartTime" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ProposedStartTime" msprop:Generator_ColumnPropNameInRow="ProposedStartTime" msprop:Generator_ColumnVarNameInTable="columnProposedStartTime" msprop:Generator_ColumnPropNameInTable="ProposedStartTimeColumn" type="xs:short" minOccurs="0" />
<xs:element name="ProposedEndTime" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ProposedEndTime" msprop:Generator_ColumnPropNameInRow="ProposedEndTime" msprop:Generator_ColumnVarNameInTable="columnProposedEndTime" msprop:Generator_ColumnPropNameInTable="ProposedEndTimeColumn" type="xs:short" minOccurs="0" />
<xs:element name="JKID" msdata:ReadOnly="true" msprop:Generator_UserColumnName="JKID" msprop:Generator_ColumnPropNameInRow="JKID" msprop:Generator_ColumnVarNameInTable="columnJKID" msprop:Generator_ColumnPropNameInTable="JKIDColumn" type="xs:int" minOccurs="0" />
<xs:element name="JKName" msdata:ReadOnly="true" msprop:Generator_UserColumnName="JKName" msprop:Generator_ColumnPropNameInRow="JKName" msprop:Generator_ColumnVarNameInTable="columnJKName" msprop:Generator_ColumnPropNameInTable="JKNameColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="MgmtCommContactedYN" msdata:ReadOnly="true" msprop:Generator_UserColumnName="MgmtCommContactedYN" msprop:Generator_ColumnPropNameInRow="MgmtCommContactedYN" msprop:Generator_ColumnVarNameInTable="columnMgmtCommContactedYN" msprop:Generator_ColumnPropNameInTable="MgmtCommContactedYNColumn" type="xs:short" minOccurs="0" />
<xs:element name="VenueID" msdata:ReadOnly="true" msprop:Generator_UserColumnName="VenueID" msprop:Generator_ColumnPropNameInRow="VenueID" msprop:Generator_ColumnVarNameInTable="columnVenueID" msprop:Generator_ColumnPropNameInTable="VenueIDColumn" type="xs:int" minOccurs="0" />
<xs:element name="VenueName" msdata:ReadOnly="true" msprop:Generator_UserColumnName="VenueName" msprop:Generator_ColumnPropNameInRow="VenueName" msprop:Generator_ColumnVarNameInTable="columnVenueName" msprop:Generator_ColumnPropNameInTable="VenueNameColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="VenueTypeID" msdata:ReadOnly="true" msprop:Generator_UserColumnName="VenueTypeID" msprop:Generator_ColumnPropNameInRow="VenueTypeID" msprop:Generator_ColumnVarNameInTable="columnVenueTypeID" msprop:Generator_ColumnPropNameInTable="VenueTypeIDColumn" type="xs:int" minOccurs="0" />
<xs:element name="VenueAddress" msdata:ReadOnly="true" msprop:Generator_UserColumnName="VenueAddress" msprop:Generator_ColumnPropNameInRow="VenueAddress" msprop:Generator_ColumnVarNameInTable="columnVenueAddress" msprop:Generator_ColumnPropNameInTable="VenueAddressColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CityID" msdata:ReadOnly="true" msprop:Generator_UserColumnName="CityID" msprop:Generator_ColumnPropNameInRow="CityID" msprop:Generator_ColumnVarNameInTable="columnCityID" msprop:Generator_ColumnPropNameInTable="CityIDColumn" type="xs:int" minOccurs="0" />
<xs:element name="CityName" msdata:ReadOnly="true" msprop:Generator_UserColumnName="CityName" msprop:Generator_ColumnPropNameInRow="CityName" msprop:Generator_ColumnVarNameInTable="columnCityName" msprop:Generator_ColumnPropNameInTable="CityNameColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ProvinceAbbrev" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ProvinceAbbrev" msprop:Generator_ColumnPropNameInRow="ProvinceAbbrev" msprop:Generator_ColumnVarNameInTable="columnProvinceAbbrev" msprop:Generator_ColumnPropNameInTable="ProvinceAbbrevColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="3" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="VenuePostalCode" msdata:ReadOnly="true" msprop:Generator_UserColumnName="VenuePostalCode" msprop:Generator_ColumnPropNameInRow="VenuePostalCode" msprop:Generator_ColumnVarNameInTable="columnVenuePostalCode" msprop:Generator_ColumnPropNameInTable="VenuePostalCodeColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="7" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="VenueCapacity" msdata:ReadOnly="true" msprop:Generator_UserColumnName="VenueCapacity" msprop:Generator_ColumnPropNameInRow="VenueCapacity" msprop:Generator_ColumnVarNameInTable="columnVenueCapacity" msprop:Generator_ColumnPropNameInTable="VenueCapacityColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="VenueNotes" msdata:ReadOnly="true" msprop:Generator_UserColumnName="VenueNotes" msprop:Generator_ColumnPropNameInRow="VenueNotes" msprop:Generator_ColumnVarNameInTable="columnVenueNotes" msprop:Generator_ColumnPropNameInTable="VenueNotesColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="1000" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="SeatingRating" msdata:ReadOnly="true" msprop:Generator_UserColumnName="SeatingRating" msprop:Generator_ColumnPropNameInRow="SeatingRating" msprop:Generator_ColumnVarNameInTable="columnSeatingRating" msprop:Generator_ColumnPropNameInTable="SeatingRatingColumn" type="xs:int" minOccurs="0" />
<xs:element name="ParkingRating" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ParkingRating" msprop:Generator_ColumnPropNameInRow="ParkingRating" msprop:Generator_ColumnVarNameInTable="columnParkingRating" msprop:Generator_ColumnPropNameInTable="ParkingRatingColumn" type="xs:int" minOccurs="0" />
<xs:element name="LocationRating" msdata:ReadOnly="true" msprop:Generator_UserColumnName="LocationRating" msprop:Generator_ColumnPropNameInRow="LocationRating" msprop:Generator_ColumnVarNameInTable="columnLocationRating" msprop:Generator_ColumnPropNameInTable="LocationRatingColumn" type="xs:int" minOccurs="0" />
<xs:element name="ServingRefreshmentsRating" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ServingRefreshmentsRating" msprop:Generator_ColumnPropNameInRow="ServingRefreshmentsRating" msprop:Generator_ColumnVarNameInTable="columnServingRefreshmentsRating" msprop:Generator_ColumnPropNameInTable="ServingRefreshmentsRatingColumn" type="xs:int" minOccurs="0" />
<xs:element name="MaterialPresentedRating" msdata:ReadOnly="true" msprop:Generator_UserColumnName="MaterialPresentedRating" msprop:Generator_ColumnPropNameInRow="MaterialPresentedRating" msprop:Generator_ColumnVarNameInTable="columnMaterialPresentedRating" msprop:Generator_ColumnPropNameInTable="MaterialPresentedRatingColumn" type="xs:int" minOccurs="0" />
<xs:element name="AudienceLearningRating" msdata:ReadOnly="true" msprop:Generator_UserColumnName="AudienceLearningRating" msprop:Generator_ColumnPropNameInRow="AudienceLearningRating" msprop:Generator_ColumnVarNameInTable="columnAudienceLearningRating" msprop:Generator_ColumnPropNameInTable="AudienceLearningRatingColumn" type="xs:int" minOccurs="0" />
<xs:element name="SpeakerKnowledgeStyleRating" msdata:ReadOnly="true" msprop:Generator_UserColumnName="SpeakerKnowledgeStyleRating" msprop:Generator_ColumnPropNameInRow="SpeakerKnowledgeStyleRating" msprop:Generator_ColumnVarNameInTable="columnSpeakerKnowledgeStyleRating" msprop:Generator_ColumnPropNameInTable="SpeakerKnowledgeStyleRatingColumn" type="xs:int" minOccurs="0" />
<xs:element name="HandoutMaterialRating" msdata:ReadOnly="true" msprop:Generator_UserColumnName="HandoutMaterialRating" msprop:Generator_ColumnPropNameInRow="HandoutMaterialRating" msprop:Generator_ColumnVarNameInTable="columnHandoutMaterialRating" msprop:Generator_ColumnPropNameInTable="HandoutMaterialRatingColumn" type="xs:int" minOccurs="0" />
<xs:element name="TimeManagementRating" msdata:ReadOnly="true" msprop:Generator_UserColumnName="TimeManagementRating" msprop:Generator_ColumnPropNameInRow="TimeManagementRating" msprop:Generator_ColumnVarNameInTable="columnTimeManagementRating" msprop:Generator_ColumnPropNameInTable="TimeManagementRatingColumn" type="xs:int" minOccurs="0" />
<xs:element name="RefreshmentsRating" msdata:ReadOnly="true" msprop:Generator_UserColumnName="RefreshmentsRating" msprop:Generator_ColumnPropNameInRow="RefreshmentsRating" msprop:Generator_ColumnVarNameInTable="columnRefreshmentsRating" msprop:Generator_ColumnPropNameInTable="RefreshmentsRatingColumn" type="xs:int" minOccurs="0" />
<xs:element name="MarketingRating" msdata:ReadOnly="true" msprop:Generator_UserColumnName="MarketingRating" msprop:Generator_ColumnPropNameInRow="MarketingRating" msprop:Generator_ColumnVarNameInTable="columnMarketingRating" msprop:Generator_ColumnPropNameInTable="MarketingRatingColumn" type="xs:int" minOccurs="0" />
<xs:element name="VolunteerServicesRating" msdata:ReadOnly="true" msprop:Generator_UserColumnName="VolunteerServicesRating" msprop:Generator_ColumnPropNameInRow="VolunteerServicesRating" msprop:Generator_ColumnVarNameInTable="columnVolunteerServicesRating" msprop:Generator_ColumnPropNameInTable="VolunteerServicesRatingColumn" type="xs:int" minOccurs="0" />
<xs:element name="ItemsKeepSame" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ItemsKeepSame" msprop:Generator_ColumnPropNameInRow="ItemsKeepSame" msprop:Generator_ColumnVarNameInTable="columnItemsKeepSame" msprop:Generator_ColumnPropNameInTable="ItemsKeepSameColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="300" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ItemsToChange" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ItemsToChange" msprop:Generator_ColumnPropNameInRow="ItemsToChange" msprop:Generator_ColumnVarNameInTable="columnItemsToChange" msprop:Generator_ColumnPropNameInTable="ItemsToChangeColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="300" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="AdditionalComments" msdata:ReadOnly="true" msprop:Generator_UserColumnName="AdditionalComments" msprop:Generator_ColumnPropNameInRow="AdditionalComments" msprop:Generator_ColumnVarNameInTable="columnAdditionalComments" msprop:Generator_ColumnPropNameInTable="AdditionalCommentsColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="500" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CreatedBy" msdata:ReadOnly="true" msprop:Generator_UserColumnName="CreatedBy" msprop:Generator_ColumnPropNameInRow="CreatedBy" msprop:Generator_ColumnVarNameInTable="columnCreatedBy" msprop:Generator_ColumnPropNameInTable="CreatedByColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ModifiedBy" msdata:ReadOnly="true" msprop:Generator_UserColumnName="ModifiedBy" msprop:Generator_ColumnPropNameInRow="ModifiedBy" msprop:Generator_ColumnVarNameInTable="columnModifiedBy" msprop:Generator_ColumnPropNameInTable="ModifiedByColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="formattedStartTime" msdata:ReadOnly="true" msprop:Generator_UserColumnName="formattedStartTime" msprop:Generator_ColumnPropNameInRow="formattedStartTime" msprop:Generator_ColumnVarNameInTable="columnformattedStartTime" msprop:Generator_ColumnPropNameInTable="formattedStartTimeColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="5" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="formattedEndTime" msdata:ReadOnly="true" msprop:Generator_UserColumnName="formattedEndTime" msprop:Generator_ColumnPropNameInRow="formattedEndTime" msprop:Generator_ColumnVarNameInTable="columnformattedEndTime" msprop:Generator_ColumnPropNameInTable="formattedEndTimeColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="5" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="UnformattedProjectDate" msdata:ReadOnly="true" msprop:Generator_UserColumnName="UnformattedProjectDate" msprop:Generator_ColumnVarNameInTable="columnUnformattedProjectDate" msprop:Generator_ColumnPropNameInRow="UnformattedProjectDate" msprop:Generator_ColumnPropNameInTable="UnformattedProjectDateColumn" type="xs:int" minOccurs="0" />
<xs:element name="AbsoluteVenueName" msdata:ReadOnly="true" msprop:Generator_UserColumnName="AbsoluteVenueName" msprop:Generator_ColumnVarNameInTable="columnAbsoluteVenueName" msprop:Generator_ColumnPropNameInRow="AbsoluteVenueName" msprop:Generator_ColumnPropNameInTable="AbsoluteVenueNameColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="mspProjectCommitteeGetByProjectID" msprop:Generator_UserTableName="mspProjectCommitteeGetByProjectID" msprop:Generator_RowDeletedName="mspProjectCommitteeGetByProjectIDRowDeleted" msprop:Generator_RowChangedName="mspProjectCommitteeGetByProjectIDRowChanged" msprop:Generator_RowClassName="mspProjectCommitteeGetByProjectIDRow" msprop:Generator_RowChangingName="mspProjectCommitteeGetByProjectIDRowChanging" msprop:Generator_RowEvArgName="mspProjectCommitteeGetByProjectIDRowChangeEvent" msprop:Generator_RowEvHandlerName="mspProjectCommitteeGetByProjectIDRowChangeEventHandler" msprop:Generator_TableClassName="mspProjectCommitteeGetByProjectIDDataTable" msprop:Generator_TableVarName="tablemspProjectCommitteeGetByProjectID" msprop:Generator_RowDeletingName="mspProjectCommitteeGetByProjectIDRowDeleting" msprop:Generator_TablePropName="mspProjectCommitteeGetByProjectID">
<xs:complexType>
<xs:sequence>
<xs:element name="BoardPortfolioID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="BoardPortfolioID" msprop:Generator_ColumnPropNameInRow="BoardPortfolioID" msprop:Generator_ColumnVarNameInTable="columnBoardPortfolioID" msprop:Generator_ColumnPropNameInTable="BoardPortfolioIDColumn" type="xs:int" />
<xs:element name="BoardPortfolioName" msprop:Generator_UserColumnName="BoardPortfolioName" msprop:Generator_ColumnPropNameInRow="BoardPortfolioName" msprop:Generator_ColumnVarNameInTable="columnBoardPortfolioName" msprop:Generator_ColumnPropNameInTable="BoardPortfolioNameColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="BoardPortfolioAbbrev" msprop:Generator_UserColumnName="BoardPortfolioAbbrev" msprop:Generator_ColumnPropNameInRow="BoardPortfolioAbbrev" msprop:Generator_ColumnVarNameInTable="columnBoardPortfolioAbbrev" msprop:Generator_ColumnPropNameInTable="BoardPortfolioAbbrevColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="IsPrimaryOrganizerYN" msprop:Generator_UserColumnName="IsPrimaryOrganizerYN" msprop:Generator_ColumnPropNameInRow="IsPrimaryOrganizerYN" msprop:Generator_ColumnVarNameInTable="columnIsPrimaryOrganizerYN" msprop:Generator_ColumnPropNameInTable="IsPrimaryOrganizerYNColumn" type="xs:short" minOccurs="0" />
<xs:element name="CommitteeID" msprop:Generator_UserColumnName="CommitteeID" msprop:Generator_ColumnPropNameInRow="CommitteeID" msprop:Generator_ColumnVarNameInTable="columnCommitteeID" msprop:Generator_ColumnPropNameInTable="CommitteeIDColumn" type="xs:int" minOccurs="0" />
<xs:element name="CommitteeName" msprop:Generator_UserColumnName="CommitteeName" msprop:Generator_ColumnPropNameInRow="CommitteeName" msprop:Generator_ColumnVarNameInTable="columnCommitteeName" msprop:Generator_ColumnPropNameInTable="CommitteeNameColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ActiveYN" msprop:Generator_UserColumnName="ActiveYN" msprop:Generator_ColumnPropNameInRow="ActiveYN" msprop:Generator_ColumnVarNameInTable="columnActiveYN" msprop:Generator_ColumnPropNameInTable="ActiveYNColumn" type="xs:short" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tluBoardPortfolio" msprop:Generator_UserTableName="tluBoardPortfolio" msprop:Generator_RowDeletedName="tluBoardPortfolioRowDeleted" msprop:Generator_RowChangedName="tluBoardPortfolioRowChanged" msprop:Generator_RowClassName="tluBoardPortfolioRow" msprop:Generator_RowChangingName="tluBoardPortfolioRowChanging" msprop:Generator_RowEvArgName="tluBoardPortfolioRowChangeEvent" msprop:Generator_RowEvHandlerName="tluBoardPortfolioRowChangeEventHandler" msprop:Generator_TableClassName="tluBoardPortfolioDataTable" msprop:Generator_TableVarName="tabletluBoardPortfolio" msprop:Generator_RowDeletingName="tluBoardPortfolioRowDeleting" msprop:Generator_TablePropName="tluBoardPortfolio">
<xs:complexType>
<xs:sequence>
<xs:element name="BoardPortfolioID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="BoardPortfolioID" msprop:Generator_ColumnPropNameInRow="BoardPortfolioID" msprop:Generator_ColumnVarNameInTable="columnBoardPortfolioID" msprop:Generator_ColumnPropNameInTable="BoardPortfolioIDColumn" type="xs:int" />
<xs:element name="BoardPortfolioName" msprop:Generator_UserColumnName="BoardPortfolioName" msprop:Generator_ColumnPropNameInRow="BoardPortfolioName" msprop:Generator_ColumnVarNameInTable="columnBoardPortfolioName" msprop:Generator_ColumnPropNameInTable="BoardPortfolioNameColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="BoardPortfolioAbbrev" msprop:Generator_UserColumnName="BoardPortfolioAbbrev" msprop:Generator_ColumnPropNameInRow="BoardPortfolioAbbrev" msprop:Generator_ColumnVarNameInTable="columnBoardPortfolioAbbrev" msprop:Generator_ColumnPropNameInTable="BoardPortfolioAbbrevColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="AspnetUserRoleName" msprop:Generator_UserColumnName="AspnetUserRoleName" msprop:Generator_ColumnPropNameInRow="AspnetUserRoleName" msprop:Generator_ColumnVarNameInTable="columnAspnetUserRoleName" msprop:Generator_ColumnPropNameInTable="AspnetUserRoleNameColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="256" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ActiveYN" msprop:Generator_UserColumnName="ActiveYN" msprop:Generator_ColumnPropNameInRow="ActiveYN" msprop:Generator_ColumnVarNameInTable="columnActiveYN" msprop:Generator_ColumnPropNameInTable="ActiveYNColumn" type="xs:short" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:tblProject" />
<xs:field xpath="mstns:ProjectID" />
</xs:unique>
<xs:unique name="tblProject_Service_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:tblProject_Service" />
<xs:field xpath="mstns:Project_ServiceID" />
</xs:unique>
<xs:unique name="tblProject_TargetSegment_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:tblProject_TargetSegment" />
<xs:field xpath="mstns:Project_TargetSegmentID" />
</xs:unique>
<xs:unique name="tluVenue_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:tluVenue" />
<xs:field xpath="mstns:VenueID" />
</xs:unique>
<xs:unique name="mspProjectCommitteeGetByProjectID_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:mspProjectCommitteeGetByProjectID" />
<xs:field xpath="mstns:BoardPortfolioID" />
</xs:unique>
<xs:unique name="tluBoardPortfolio_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:tluBoardPortfolio" />
<xs:field xpath="mstns:BoardPortfolioID" />
</xs:unique>
</xs:element>
</xs:schema>