<?xml version="1.0" encoding="utf-8"?><edmx:Edmx Version="4.0" xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx"><edmx:DataServices><Schema Namespace="prismCore.Models" xmlns="http://docs.oasis-open.org/odata/ns/edm"><EntityType Name="ApplicationUser"><Key><PropertyRef Name="Id" /></Key><Property Name="FirstName" Type="Edm.String" Nullable="false" MaxLength="50" /><Property Name="LastName" Type="Edm.String" Nullable="false" MaxLength="50" /><Property Name="PhoneInternationalFlag" Type="Edm.Boolean" Nullable="false" /><Property Name="Hometown" Type="Edm.String" /><Property Name="UserQuestions" Type="Collection(prismCore.Models.UserQuestion)" /><Property Name="O_ID" Type="Edm.Int32" Nullable="false" /><Property Name="SecQandAFailCount" Type="Edm.Int32" Nullable="false" /><Property Name="JobTitle" Type="Edm.String" MaxLength="50" /><Property Name="RequestedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="StatusId" Type="prismCore.Code.Constants.BaseStatusEnum" Nullable="false" /><Property Name="DisplayName" Type="Edm.String" Nullable="false" /><Property Name="LastPasswordChangedOn" Type="Edm.DateTimeOffset" /><Property Name="Id" Type="Edm.String" Nullable="false" /><Property Name="UserName" Type="Edm.String" /><Property Name="NormalizedUserName" Type="Edm.String" /><Property Name="Email" Type="Edm.String" /><Property Name="NormalizedEmail" Type="Edm.String" /><Property Name="EmailConfirmed" Type="Edm.Boolean" Nullable="false" /><Property Name="PasswordHash" Type="Edm.String" /><Property Name="SecurityStamp" Type="Edm.String" /><Property Name="ConcurrencyStamp" Type="Edm.String" /><Property Name="PhoneNumber" Type="Edm.String" /><Property Name="PhoneNumberConfirmed" Type="Edm.Boolean" Nullable="false" /><Property Name="TwoFactorEnabled" Type="Edm.Boolean" Nullable="false" /><Property Name="LockoutEnd" Type="Edm.DateTimeOffset" /><Property Name="LockoutEnabled" Type="Edm.Boolean" Nullable="false" /><Property Name="AccessFailedCount" Type="Edm.Int32" Nullable="false" /><NavigationProperty Name="Organization" Type="prismCore.Models.Organization" /></EntityType><ComplexType Name="UserQuestion"><Property Name="U_ID" Type="Edm.String" Nullable="false" /><Property Name="Q_ID" Type="Edm.Int32" Nullable="false" /><Property Name="Answer" Type="Edm.String" Nullable="false" /><Property Name="DisplayOrder" Type="Edm.Int32" Nullable="false" /><NavigationProperty Name="ApplicationUser" Type="prismCore.Models.ApplicationUser" Nullable="false" /><NavigationProperty Name="SecurityQuestion" Type="prismCore.Models.SecurityQuestion" Nullable="false" /></ComplexType><EntityType Name="SecurityQuestion"><Key><PropertyRef Name="ID" /></Key><Property Name="ID" Type="Edm.Int32" Nullable="false" /><Property Name="Questions" Type="Edm.String" Nullable="false" /><Property Name="CreatedOn" Type="Edm.DateTimeOffset" /><Property Name="UserQuestions" Type="Collection(prismCore.Models.UserQuestion)" /></EntityType><EntityType Name="Organization"><Key><PropertyRef Name="ID" /></Key><Property Name="ID" Type="Edm.Int32" Nullable="false" /><Property Name="PIN" Type="Edm.String" /><Property Name="OrganizationName" Type="Edm.String" /><Property Name="IsLegacy" Type="Edm.Boolean" Nullable="false" /><Property Name="IsActive" Type="Edm.Boolean" Nullable="false" /><Property Name="IsSameAsMailingAddress" Type="Edm.Boolean" Nullable="false" /><Property Name="CreatedBy" Type="Edm.Guid" Nullable="false" /><Property Name="CreatedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedBy" Type="Edm.Guid" Nullable="false" /><Property Name="ModifiedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ContactUserId" Type="Edm.String" MaxLength="128" /><Property Name="BillingContactId" Type="Edm.String" MaxLength="128" /><Property Name="DUNSNumber" Type="Edm.String" /><Property Name="NAICSId" Type="Edm.Int32" /><Property Name="SICId" Type="Edm.Int32" /><NavigationProperty Name="Addresses" Type="Collection(prismCore.Models.OrganizationAddress)" /><NavigationProperty Name="Users" Type="Collection(prismCore.Models.ApplicationUser)" /><NavigationProperty Name="ContactUser" Type="prismCore.Models.ApplicationUser" /><NavigationProperty Name="BillingContact" Type="prismCore.Models.ApplicationUser"><ReferentialConstraint Property="BillingContactId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="NAICS" Type="prismCore.Models.Entities.L_NAICS"><ReferentialConstraint Property="NAICSId" ReferencedProperty="NAICSId" /></NavigationProperty><NavigationProperty Name="SIC" Type="prismCore.Models.Entities.L_SIC"><ReferentialConstraint Property="SICId" ReferencedProperty="SICId" /></NavigationProperty></EntityType><EntityType Name="OrganizationAddress"><Key><PropertyRef Name="ID" /></Key><Property Name="ID" Type="Edm.Int32" Nullable="false" /><Property Name="OrganizationID" Type="Edm.Int32" /><Property Name="AddressType" Type="prismCore.Code.Constants.AddressTypeEnum" Nullable="false" /><Property Name="AddressLine1" Type="Edm.String" /><Property Name="AddressLine2" Type="Edm.String" /><Property Name="City" Type="Edm.String" /><Property Name="StateProv" Type="Edm.String" /><Property Name="PostalCodeNumber" Type="Edm.String" /><Property Name="CountryCd" Type="Edm.String" /><NavigationProperty Name="Organization" Type="prismCore.Models.Organization"><ReferentialConstraint Property="OrganizationID" ReferencedProperty="ID" /></NavigationProperty></EntityType><EntityType Name="OrganizationViewModel" BaseType="prismCore.Models.Organization"><NavigationProperty Name="MailingAddress" Type="prismCore.Models.OrganizationAddress" /><NavigationProperty Name="PhysicalAddress" Type="prismCore.Models.OrganizationAddress" /></EntityType><EntityType Name="CompaniesViewModel" BaseType="prismCore.Models.OrganizationViewModel"><Property Name="CompanyName" Type="Edm.String" Nullable="false" /><Property Name="ContactName" Type="Edm.String" Nullable="false" /><Property Name="FirstName" Type="Edm.String" /><Property Name="LastName" Type="Edm.String" /><Property Name="cntActiveMembers" Type="Edm.Int32" Nullable="false" /><Property Name="Email" Type="Edm.String" /></EntityType></Schema><Schema Namespace="prismCore.Models.Entities" xmlns="http://docs.oasis-open.org/odata/ns/edm"><EntityType Name="CompanyAdminNote"><Key><PropertyRef Name="CompanyAdminNoteId" /></Key><Property Name="CompanyAdminNoteId" Type="Edm.Int32" Nullable="false" /><Property Name="CompanyId" Type="Edm.Int32" /><Property Name="Notes" Type="Edm.String" Nullable="false" /><Property Name="CreatedByName" Type="Edm.String" Nullable="false" /><Property Name="CreatedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedByName" Type="Edm.String" Nullable="false" /><Property Name="ModifiedOn" Type="Edm.DateTimeOffset" Nullable="false" /><NavigationProperty Name="Organization" Type="prismCore.Models.Organization"><ReferentialConstraint Property="CompanyId" ReferencedProperty="ID" /></NavigationProperty></EntityType><EntityType Name="L_Chemical"><Key><PropertyRef Name="ChemicalId" /></Key><Property Name="ChemicalId" Type="Edm.Int32" Nullable="false" /><Property Name="ChemicalName" Type="Edm.String" Nullable="false" /><Property Name="CASNumber" Type="Edm.String" /><Property Name="TSCARN" Type="Edm.String" /><Property Name="EuropeanCommissionNumber" Type="Edm.String" /><Property Name="IsActiveForMN" Type="Edm.Boolean" /><Property Name="ChemicalNameSortBy" Type="Edm.String" /><Property Name="StatusId" Type="Edm.Int32" Nullable="false" /><Property Name="CreatedByName" Type="Edm.String" Nullable="false" /><Property Name="CreatedDate" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedDate" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedByName" Type="Edm.String" Nullable="false" /><Property Name="Notes" Type="Edm.String" /><Property Name="PFASNameHash" Type="Edm.Binary" Nullable="false" /></EntityType><EntityType Name="L_ChemicalFunction"><Key><PropertyRef Name="ChemicalFunctionId" /></Key><Property Name="ChemicalFunctionId" Type="Edm.Int32" Nullable="false" /><Property Name="ChemicalFunctionName" Type="Edm.String" Nullable="false" /><Property Name="StatusId" Type="Edm.Int32" Nullable="false" /><Property Name="WA_ChemicalFunctionName" Type="Edm.String" /><Property Name="WA_IsVisibleFlag" Type="Edm.String" /><Property Name="VT_ChemicalFunction" Type="Edm.String" /><Property Name="OR_ChemicalFunction" Type="Edm.String" /><Property Name="CreatedByName" Type="Edm.String" Nullable="false" /><Property Name="CreatedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedByName" Type="Edm.String" Nullable="false" /><Property Name="Notes" Type="Edm.String" /></EntityType><EntityType Name="L_ChemicalSubClass"><Key><PropertyRef Name="ChemicalSubClassId" /></Key><Property Name="ChemicalSubClassId" Type="Edm.Int32" Nullable="false" /><Property Name="ChemicalSubClassName" Type="Edm.String" Nullable="false" /><Property Name="StatusId" Type="Edm.Int32" Nullable="false" /><Property Name="Notes" Type="Edm.String" /><Property Name="CreatedByName" Type="Edm.String" Nullable="false" /><Property Name="CreatedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedByName" Type="Edm.String" Nullable="false" /><Property Name="ModifiedOn" Type="Edm.DateTimeOffset" Nullable="false" /></EntityType><EntityType Name="L_Country"><Key><PropertyRef Name="Code" /></Key><Property Name="Code" Type="Edm.String" Nullable="false" /><Property Name="CountryName" Type="Edm.String" Nullable="false" /></EntityType><EntityType Name="L_NAICS"><Key><PropertyRef Name="NAICSId" /></Key><Property Name="NAICSId" Type="Edm.Int32" Nullable="false" /><Property Name="NAICS" Type="Edm.String" Nullable="false" /><Property Name="NAICSDescription" Type="Edm.String" Nullable="false" /></EntityType><EntityType Name="L_PFASRange"><Key><PropertyRef Name="PFASRangeId" /></Key><Property Name="PFASRangeId" Type="Edm.Int32" Nullable="false" /><Property Name="Range" Type="Edm.String" Nullable="false" /><Property Name="StatusId" Type="Edm.Int32" Nullable="false" /><Property Name="Notes" Type="Edm.String" /><Property Name="CreatedByName" Type="Edm.String" Nullable="false" /><Property Name="CreatedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedByName" Type="Edm.String" Nullable="false" /><Property Name="ModifiedOn" Type="Edm.DateTimeOffset" Nullable="false" /></EntityType><EntityType Name="L_ReportingPeriod"><Key><PropertyRef Name="ReportingPeriodId" /></Key><Property Name="ReportingPeriodId" Type="Edm.Int32" Nullable="false" /><Property Name="IsActive" Type="Edm.Boolean" Nullable="false" /><Property Name="StateAbbrv" Type="Edm.String" Nullable="false" /><Property Name="StartDate" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="EndDate" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ReportingDeadline" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="PeriodName" Type="Edm.String" Nullable="false" /><Property Name="StatusId" Type="Edm.Int32" /><Property Name="CreatedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="CreatedBy" Type="Edm.String" Nullable="false" /><Property Name="ModifiedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedBy" Type="Edm.String" Nullable="false" /><Property Name="Notes" Type="Edm.String" /></EntityType><EntityType Name="L_SIC"><Key><PropertyRef Name="SICId" /></Key><Property Name="SICId" Type="Edm.Int32" Nullable="false" /><Property Name="SIC" Type="Edm.String" Nullable="false" /><Property Name="SICDescription" Type="Edm.String" Nullable="false" /></EntityType><EntityType Name="L_State"><Key><PropertyRef Name="Id" /></Key><Property Name="Id" Type="Edm.Int32" Nullable="false" /><Property Name="CountryCode" Type="Edm.String" /><Property Name="AlphaCode" Type="Edm.String" /><Property Name="StateName" Type="Edm.String" Nullable="false" /><Property Name="FIPSCode" Type="Edm.String" /><Property Name="UPDATED_BY" Type="Edm.String" /><Property Name="UPDATED_ON" Type="Edm.DateTimeOffset" Nullable="false" /><NavigationProperty Name="Country" Type="prismCore.Models.Entities.L_Country"><ReferentialConstraint Property="CountryCode" ReferencedProperty="Code" /></NavigationProperty><NavigationProperty Name="User" Type="prismCore.Models.ApplicationUser"><ReferentialConstraint Property="UPDATED_BY" ReferencedProperty="Id" /></NavigationProperty></EntityType><EntityType Name="Report"><Key><PropertyRef Name="ReportId" /></Key><Property Name="ReportId" Type="Edm.Int32" Nullable="false" /><Property Name="ReportName" Type="Edm.String" Nullable="false" /><Property Name="ReportingPeriodId" Type="Edm.Int32" /><Property Name="AccountableCompanyId" Type="Edm.Int32" /><Property Name="AccountableCompanyName" Type="Edm.String" /><Property Name="ReporterCompanyId" Type="Edm.Int32" /><Property Name="RecommendationNote" Type="Edm.String" /><Property Name="DisclosureId" Type="Edm.String" /><Property Name="PaymentType" Type="Edm.Int32" Nullable="false" /><Property Name="PaymentToken" Type="Edm.String" /><Property Name="MailCheckPayer" Type="Edm.String" /><Property Name="MailCheckNumber" Type="Edm.Int32" /><Property Name="MailCheckAmount" Type="Edm.Double" /><Property Name="MailCheckDate" Type="Edm.DateTimeOffset" /><Property Name="SubmittedDate" Type="Edm.DateTimeOffset" /><Property Name="StatusId" Type="Edm.Int32" Nullable="false" /><Property Name="IsCertified" Type="Edm.Boolean" Nullable="false" /><Property Name="CreatedByName" Type="Edm.String" /><Property Name="CreatedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedByName" Type="Edm.String" /><Property Name="ModifiedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="CopiedFromReportId" Type="Edm.Int32" /><Property Name="ModifiedBy" Type="Edm.String" /><Property Name="SubmittedBy" Type="Edm.String" /><Property Name="PublishedOn" Type="Edm.DateTimeOffset" /><Property Name="IsRenewed" Type="Edm.Boolean" Nullable="false" /><Property Name="ReportContactPhone" Type="Edm.String" /><Property Name="ReportContactCity" Type="Edm.String" /><Property Name="ReportContactAddressLine1" Type="Edm.String" /><Property Name="ReportContactAddressLine2" Type="Edm.String" /><Property Name="ReportContactStateProv" Type="Edm.String" /><Property Name="ReportContactPostalCodeNumber" Type="Edm.String" /><Property Name="ReportContactCountryCd" Type="Edm.String" /><Property Name="DepublishInProgress" Type="Edm.Boolean" Nullable="false" /><NavigationProperty Name="ReportAdminNotes" Type="Collection(prismCore.Models.Entities.ReportAdminNote)" /><NavigationProperty Name="ReportDocuments" Type="Collection(prismCore.Models.Entities.ReportDocument)" /><NavigationProperty Name="ReportPayments" Type="Collection(prismCore.Models.Entities.ReportPayment)" /><NavigationProperty Name="ReportBNPMs" Type="Collection(prismCore.Models.Entities.ReportBNPM)" /><NavigationProperty Name="L_ReportingPeriod" Type="prismCore.Models.Entities.L_ReportingPeriod"><ReferentialConstraint Property="ReportingPeriodId" ReferencedProperty="ReportingPeriodId" /></NavigationProperty><NavigationProperty Name="AccountableCompany" Type="prismCore.Models.Organization"><ReferentialConstraint Property="AccountableCompanyId" ReferencedProperty="ID" /></NavigationProperty><NavigationProperty Name="ReporterCompany" Type="prismCore.Models.Organization"><ReferentialConstraint Property="ReporterCompanyId" ReferencedProperty="ID" /></NavigationProperty><NavigationProperty Name="ModifiedByUser" Type="prismCore.Models.ApplicationUser"><ReferentialConstraint Property="ModifiedBy" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="SubmittedByUser" Type="prismCore.Models.ApplicationUser"><ReferentialConstraint Property="SubmittedBy" ReferencedProperty="Id" /></NavigationProperty></EntityType><EntityType Name="ReportAdminNote"><Key><PropertyRef Name="ReportAdminNoteId" /></Key><Property Name="ReportAdminNoteId" Type="Edm.Int32" Nullable="false" /><Property Name="ReportId" Type="Edm.Int32" /><Property Name="Notes" Type="Edm.String" Nullable="false" /><Property Name="CreatedByName" Type="Edm.String" Nullable="false" /><Property Name="CreatedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedByName" Type="Edm.String" Nullable="false" /><Property Name="ModifiedOn" Type="Edm.DateTimeOffset" Nullable="false" /><NavigationProperty Name="Report" Type="prismCore.Models.Entities.Report"><ReferentialConstraint Property="ReportId" ReferencedProperty="ReportId" /></NavigationProperty></EntityType><EntityType Name="ReportBNPMAdminNote"><Key><PropertyRef Name="ReportBNPMAdminNoteId" /></Key><Property Name="ReportBNPMAdminNoteId" Type="Edm.Int32" Nullable="false" /><Property Name="ReportBNPMId" Type="Edm.Int32" /><Property Name="Note" Type="Edm.String" Nullable="false" /><Property Name="CreatedByName" Type="Edm.String" Nullable="false" /><Property Name="CreatedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedByName" Type="Edm.String" Nullable="false" /><Property Name="ModifiedOn" Type="Edm.DateTimeOffset" Nullable="false" /><NavigationProperty Name="ReportBNPM" Type="prismCore.Models.Entities.ReportBNPM"><ReferentialConstraint Property="ReportBNPMId" ReferencedProperty="ReportBNPMId" /></NavigationProperty></EntityType><EntityType Name="UserAdminNote"><Key><PropertyRef Name="UserAdminNoteId" /></Key><Property Name="UserAdminNoteId" Type="Edm.Int32" Nullable="false" /><Property Name="UserId" Type="Edm.String" Nullable="false" /><Property Name="Notes" Type="Edm.String" Nullable="false" /><Property Name="CreatedByName" Type="Edm.String" Nullable="false" /><Property Name="CreatedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedByName" Type="Edm.String" Nullable="false" /><Property Name="ModifiedOn" Type="Edm.DateTimeOffset" Nullable="false" /></EntityType><EntityType Name="vAllDisclosure"><Key><PropertyRef Name="vAllDisclosureId" /></Key><Property Name="vAllDisclosureId" Type="Edm.Int64" Nullable="false" /><Property Name="ReportId" Type="Edm.Int32" Nullable="false" /><Property Name="AdditionalInformationId" Type="Edm.Int32" /><Property Name="ReportName" Type="Edm.String" Nullable="false" /><Property Name="AdditionalInformationName" Type="Edm.String" /><Property Name="DisclosureId" Type="Edm.String" /><Property Name="PeriodName" Type="Edm.String" Nullable="false" /><Property Name="StateAbbrv" Type="Edm.String" Nullable="false" /><Property Name="StatusId" Type="Edm.Int32" Nullable="false" /><Property Name="EditInProgress" Type="Edm.Boolean" Nullable="false" /><Property Name="SubmittedDate" Type="Edm.DateTimeOffset" /><Property Name="PublishedOn" Type="Edm.DateTimeOffset" /><Property Name="ReporterCompanyId" Type="Edm.Int32" Nullable="false" /><Property Name="ReporterCompanyName" Type="Edm.String" Nullable="false" /><Property Name="ReporterCompanyPin" Type="Edm.String" /><Property Name="AccountableCompanyId" Type="Edm.Int32" Nullable="false" /><Property Name="AccountableCompanyName" Type="Edm.String" Nullable="false" /><Property Name="AccountableCompanyPin" Type="Edm.String" /><Property Name="PaymentType" Type="Edm.Int32" Nullable="false" /><Property Name="OrderId" Type="Edm.String" /><Property Name="OrderOn" Type="Edm.DateTimeOffset" /><Property Name="PaymentAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="PaymentStatus" Type="Edm.Int32" /><Property Name="PaymentMadeByName" Type="Edm.String" /><Property Name="PaymentSucceededOn" Type="Edm.DateTimeOffset" /><Property Name="PaymentFailedOn" Type="Edm.DateTimeOffset" /><Property Name="DisplayPaymentStatus" Type="Edm.String" /><Property Name="ModifiedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedByName" Type="Edm.String" /><Property Name="SubmittedByUserDisplayName" Type="Edm.String" /><Property Name="HasReportAdminNotes" Type="Edm.Boolean" Nullable="false" /><Property Name="HasRequestedTradeSecret" Type="Edm.Boolean" Nullable="false" /><Property Name="HasAttachedFiles" Type="Edm.Boolean" Nullable="false" /></EntityType><EntityType Name="vBrandNames"><Key><PropertyRef Name="BrandName" /></Key><Property Name="BrandName" Type="Edm.String" Nullable="false" /></EntityType><EntityType Name="vCompanyRelationship"><Key><PropertyRef Name="CompanyRelationshipId" /></Key><Property Name="CompanyRelationshipId" Type="Edm.Int32" Nullable="false" /><Property Name="StatusId" Type="Edm.Int32" Nullable="false" /><Property Name="Status" Type="Edm.String" /><Property Name="ReportingCompanyId" Type="Edm.Int32" /><Property Name="ReportingCompanyName" Type="Edm.String" Nullable="false" /><Property Name="ReportingCompanyMailingAddress" Type="Edm.String" /><Property Name="AccountableCompanyId" Type="Edm.Int32" /><Property Name="AccountableCompanyName" Type="Edm.String" Nullable="false" /><Property Name="AccountableCompanyMailingAddress" Type="Edm.String" /><Property Name="RequestedBy" Type="Edm.String" /><Property Name="RequestedByName" Type="Edm.String" Nullable="false" /><Property Name="RequestedOn" Type="Edm.DateTimeOffset" /><Property Name="ApprovedBy" Type="Edm.String" /><Property Name="ApprovedByName" Type="Edm.String" /><Property Name="ApprovedOn" Type="Edm.DateTimeOffset" /><NavigationProperty Name="ReportingCompany" Type="prismCore.Models.Entities.vCompanys"><ReferentialConstraint Property="ReportingCompanyId" ReferencedProperty="ID" /></NavigationProperty><NavigationProperty Name="AccountableCompany" Type="prismCore.Models.Entities.vCompanys"><ReferentialConstraint Property="AccountableCompanyId" ReferencedProperty="ID" /></NavigationProperty></EntityType><EntityType Name="vCompanys"><Key><PropertyRef Name="ID" /></Key><Property Name="ID" Type="Edm.Int32" Nullable="false" /><Property Name="PIN" Type="Edm.String" /><Property Name="CompanyName" Type="Edm.String" Nullable="false" /><Property Name="IsLegacy" Type="Edm.Boolean" Nullable="false" /><Property Name="IsActive" Type="Edm.Boolean" Nullable="false" /><Property Name="ContactUserId" Type="Edm.String" /><Property Name="DUNSNumber" Type="Edm.String" /><Property Name="Email" Type="Edm.String" /><Property Name="PhoneNumber" Type="Edm.String" /><Property Name="FirstName" Type="Edm.String" /><Property Name="LastName" Type="Edm.String" /><Property Name="JobTitle" Type="Edm.String" /><Property Name="BillingContactEmail" Type="Edm.String" /><Property Name="BillingContactPhoneNumber" Type="Edm.String" /><Property Name="BillingContactFirstName" Type="Edm.String" /><Property Name="BillingContactLastName" Type="Edm.String" /><Property Name="BillingContactJobTitle" Type="Edm.String" /><Property Name="AddressLine1" Type="Edm.String" /><Property Name="AddressLine2" Type="Edm.String" /><Property Name="City" Type="Edm.String" /><Property Name="StateProv" Type="Edm.String" /><Property Name="PostalCodeNumber" Type="Edm.String" /><Property Name="CountryCd" Type="Edm.String" /><Property Name="AddressType" Type="Edm.Int32" Nullable="false" /><Property Name="NAICSId" Type="Edm.Int32" /><Property Name="NAICS" Type="Edm.String" /><Property Name="NAICSDescription" Type="Edm.String" /><Property Name="SICId" Type="Edm.Int32" /><Property Name="SIC" Type="Edm.String" /><Property Name="SICDescription" Type="Edm.String" /><Property Name="WithActiveMembers" Type="Edm.String" Nullable="false" /><Property Name="PhysicalAddress" Type="Edm.String" /><Property Name="MailingAddress" Type="Edm.String" /><Property Name="cntAdminNotes" Type="Edm.Int32" Nullable="false" /><Property Name="cntActiveMembers" Type="Edm.Int32" Nullable="false" /><NavigationProperty Name="AuthToSubmitFor" Type="Collection(prismCore.Models.Entities.vCompanyRelationship)" /><NavigationProperty Name="AuthToSubmitBy" Type="Collection(prismCore.Models.Entities.vCompanyRelationship)" /></EntityType><EntityType Name="vComponents"><Key><PropertyRef Name="ComponentName" /></Key><Property Name="ComponentName" Type="Edm.String" Nullable="false" /></EntityType><EntityType Name="vProductCodes"><Key><PropertyRef Name="ProductCode" /></Key><Property Name="ProductCode" Type="Edm.String" Nullable="false" /></EntityType><EntityType Name="vProductModels"><Key><PropertyRef Name="ProductModel" /></Key><Property Name="ProductModel" Type="Edm.String" Nullable="false" /></EntityType><EntityType Name="vReportBNPMDisplay"><Key><PropertyRef Name="ReportBNPMId" /></Key><Property Name="ReportBNPMId" Type="Edm.Int32" Nullable="false" /><Property Name="ReportId" Type="Edm.Int32" Nullable="false" /><Property Name="StatusId" Type="Edm.Int32" Nullable="false" /><Property Name="AccountableCompanyId" Type="Edm.Int32" Nullable="false" /><Property Name="ReporterCompanyId" Type="Edm.Int32" Nullable="false" /><Property Name="BrandName" Type="Edm.String" Nullable="false" /><Property Name="ProductModel" Type="Edm.String" Nullable="false" /><Property Name="ProductCodeTypeId" Type="Edm.Int32" Nullable="false" /><Property Name="ProductCodeType" Type="Edm.String" Nullable="false" /><Property Name="ProductCode" Type="Edm.String" Nullable="false" /><Property Name="ComponentName" Type="Edm.String" Nullable="false" /><Property Name="PFASIdentifierTypeId" Type="Edm.Int32" Nullable="false" /><Property Name="PFASIdentifierType" Type="Edm.String" Nullable="false" /><Property Name="PFASId" Type="Edm.Int32" /><Property Name="PFASName" Type="Edm.String" Nullable="false" /><Property Name="CASNumber" Type="Edm.String" /><Property Name="TSCARN" Type="Edm.String" /><Property Name="EuropeanCommissionNumber" Type="Edm.String" /><Property Name="FormattedPFAS" Type="Edm.String" Nullable="false" /><Property Name="PFASFunctionId" Type="Edm.Int32" Nullable="false" /><Property Name="PFASFunction" Type="Edm.String" Nullable="false" /><Property Name="PFASRangeId" Type="Edm.Int32" Nullable="false" /><Property Name="PFASRange" Type="Edm.String" Nullable="false" /><Property Name="IsTradeSecret" Type="Edm.Boolean" Nullable="false" /><Property Name="TradeSecret" Type="Edm.String" Nullable="false" /><Property Name="TradeSecretStatusId" Type="Edm.Int32" /><Property Name="TradeSecretStatus" Type="Edm.String" /><Property Name="ChemicalSubClassId" Type="Edm.Int32" /><Property Name="ChemicalSubClassName" Type="Edm.String" /><Property Name="CreatedByUserId" Type="Edm.String" Nullable="false" /><Property Name="CreatedByUser" Type="Edm.String" Nullable="false" /><Property Name="CreatedOn" Type="Edm.DateTimeOffset" /><Property Name="ModifiedByUserId" Type="Edm.String" Nullable="false" /><Property Name="ModifiedByUser" Type="Edm.String" Nullable="false" /><Property Name="ModifiedOn" Type="Edm.DateTimeOffset" /><Property Name="HasReportBNPMAdminNotes" Type="Edm.Boolean" Nullable="false" /></EntityType><EntityType Name="vSearch"><Key><PropertyRef Name="ReportBNPMId" /></Key><Property Name="ReportBNPMId" Type="Edm.Int32" Nullable="false" /><Property Name="AccountableCompanyId" Type="Edm.Int32" Nullable="false" /><Property Name="AccountableCompanyName" Type="Edm.String" Nullable="false" /><Property Name="BrandName" Type="Edm.String" Nullable="false" /><Property Name="ProductModel" Type="Edm.String" Nullable="false" /><Property Name="ProductCodeType" Type="Edm.String" Nullable="false" /><Property Name="ProductCode" Type="Edm.String" Nullable="false" /><Property Name="ComponentName" Type="Edm.String" Nullable="false" /><Property Name="PFASIdentifierType" Type="Edm.String" Nullable="false" /><Property Name="PFASId" Type="Edm.Int32" /><Property Name="PFASName" Type="Edm.String" /><Property Name="FormattedPFASName" Type="Edm.String" /><Property Name="PFASFunctionId" Type="Edm.Int32" Nullable="false" /><Property Name="PFASFunction" Type="Edm.String" Nullable="false" /><Property Name="ReportingPeriodId" Type="Edm.Int32" Nullable="false" /><Property Name="PeriodName" Type="Edm.String" Nullable="false" /><Property Name="PFASRangeId" Type="Edm.Int32" Nullable="false" /><Property Name="PFASRange" Type="Edm.String" Nullable="false" /><Property Name="SubmittedDate" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="PublishedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="PublicContactName" Type="Edm.String" Nullable="false" /><Property Name="PublicContactJobTitle" Type="Edm.String" /><Property Name="AccountableCompanyMailingAddress" Type="Edm.String" Nullable="false" /><Property Name="PublicContactEmail" Type="Edm.String" Nullable="false" /><Property Name="PublicContactPhoneNumber" Type="Edm.String" Nullable="false" /><Property Name="DisclosureId" Type="Edm.String" /></EntityType><EntityType Name="vQuestions"><Key><PropertyRef Name="ID" /></Key><Property Name="ID" Type="Edm.Int32" Nullable="false" /><Property Name="Questions" Type="Edm.String" Nullable="false" /></EntityType><EntityType Name="vUsersInfo"><Key><PropertyRef Name="ID" /></Key><Property Name="ID" Type="Edm.String" Nullable="false" /><Property Name="JobTitle" Type="Edm.String" /><Property Name="FirstName" Type="Edm.String" Nullable="false" /><Property Name="LastName" Type="Edm.String" Nullable="false" /><Property Name="PhoneInternationalFlag" Type="Edm.Boolean" Nullable="false" /><Property Name="FullName" Type="Edm.String" Nullable="false" /><Property Name="Email" Type="Edm.String" /><Property Name="IsEmailConfirmed" Type="Edm.String" Nullable="false" /><Property Name="PhoneNumber" Type="Edm.String" /><Property Name="O_ID" Type="Edm.Int32" Nullable="false" /><Property Name="StatusId" Type="Edm.Int32" Nullable="false" /><Property Name="RequestedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="LastLoggedOn" Type="Edm.String" Nullable="false" /><Property Name="RoleName" Type="Edm.String" Nullable="false" /><Property Name="RequestedBy" Type="Edm.String" Nullable="false" /><Property Name="Company" Type="Edm.String" Nullable="false" /><Property Name="PhysicalAddress" Type="Edm.String" /><Property Name="MailingAddress" Type="Edm.String" /><Property Name="WithActiveMembers" Type="Edm.String" /><Property Name="cntAdminNotes" Type="Edm.Int32" Nullable="false" /></EntityType><EntityType Name="ReportDocument"><Key><PropertyRef Name="ReportDocumentId" /></Key><Property Name="ReportDocumentId" Type="Edm.Int32" Nullable="false" /><Property Name="ReportId" Type="Edm.Int32" /><Property Name="DocumentTitle" Type="Edm.String" Nullable="false" /><Property Name="WA_PrimaryDocumentFlag" Type="Edm.String" /><Property Name="DocumentData" Type="Edm.Binary" Nullable="false" /><Property Name="DocumentExtension" Type="Edm.String" Nullable="false" /><Property Name="DocumentSize" Type="Edm.Int32" Nullable="false" /><Property Name="CreatedByName" Type="Edm.String" Nullable="false" /><Property Name="CreatedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedByName" Type="Edm.String" Nullable="false" /><Property Name="ModifiedOn" Type="Edm.DateTimeOffset" Nullable="false" /><NavigationProperty Name="Report" Type="prismCore.Models.Entities.Report"><ReferentialConstraint Property="ReportId" ReferencedProperty="ReportId" /></NavigationProperty></EntityType><EntityType Name="ReportPayment"><Key><PropertyRef Name="ReportPaymentId" /></Key><Property Name="ReportPaymentId" Type="Edm.Int32" Nullable="false" /><Property Name="ReportId" Type="Edm.Int32" /><Property Name="PaymentToken" Type="Edm.String" Nullable="false" /><Property Name="PaymentProvider" Type="Edm.String" Nullable="false" /><Property Name="ResponseJSON" Type="Edm.String" /><Property Name="PaymentStatus" Type="Edm.Int32" Nullable="false" /><Property Name="PaymentMadeBy" Type="Edm.String" Nullable="false" /><Property Name="PaymentMadeByName" Type="Edm.String" /><Property Name="OrderId" Type="Edm.String" /><Property Name="OrderOn" Type="Edm.DateTimeOffset" /><Property Name="PaymentAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="CreatedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedOn" Type="Edm.DateTimeOffset" /><Property Name="PaymentSucceededOn" Type="Edm.DateTimeOffset" /><Property Name="PaymentFailedOn" Type="Edm.DateTimeOffset" /><NavigationProperty Name="Report" Type="prismCore.Models.Entities.Report"><ReferentialConstraint Property="ReportId" ReferencedProperty="ReportId" /></NavigationProperty></EntityType><EntityType Name="ReportBNPM"><Key><PropertyRef Name="ReportBNPMId" /></Key><Property Name="ReportBNPMId" Type="Edm.Int32" Nullable="false" /><Property Name="ReportId" Type="Edm.Int32" /><Property Name="BrandName" Type="Edm.String" Nullable="false" /><Property Name="ProductModel" Type="Edm.String" Nullable="false" /><Property Name="ProductCodeTypeId" Type="Edm.Int32" Nullable="false" /><Property Name="OtherProductCodeName" Type="Edm.String" /><Property Name="ProductCode" Type="Edm.String" Nullable="false" /><Property Name="ComponentName" Type="Edm.String" Nullable="false" /><Property Name="PFASIdentifierTypeId" Type="Edm.Int32" Nullable="false" /><Property Name="OtherPFASIdentifierTypeName" Type="Edm.String" /><Property Name="PFASId" Type="Edm.Int32" /><Property Name="PFASFreeText" Type="Edm.String" /><Property Name="PFASFunctionId" Type="Edm.Int32" /><Property Name="PFASRangeId" Type="Edm.Int32" /><Property Name="IsTradeSecret" Type="Edm.Boolean" Nullable="false" /><Property Name="TradeSecretStatusId" Type="Edm.Int32" /><Property Name="ChemicalSubClassId" Type="Edm.Int32" /><Property Name="CreatedBy" Type="Edm.String" /><Property Name="CreatedOn" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedBy" Type="Edm.String" /><Property Name="ModifiedOn" Type="Edm.DateTimeOffset" Nullable="false" /><NavigationProperty Name="Report" Type="prismCore.Models.Entities.Report"><ReferentialConstraint Property="ReportId" ReferencedProperty="ReportId" /></NavigationProperty><NavigationProperty Name="PFAS" Type="prismCore.Models.Entities.L_Chemical"><ReferentialConstraint Property="PFASId" ReferencedProperty="ChemicalId" /></NavigationProperty><NavigationProperty Name="PFASFunction" Type="prismCore.Models.Entities.L_ChemicalFunction"><ReferentialConstraint Property="PFASFunctionId" ReferencedProperty="ChemicalFunctionId" /></NavigationProperty><NavigationProperty Name="PFASRange" Type="prismCore.Models.Entities.L_PFASRange"><ReferentialConstraint Property="PFASRangeId" ReferencedProperty="PFASRangeId" /></NavigationProperty><NavigationProperty Name="ChemicalSubClass" Type="prismCore.Models.Entities.L_ChemicalSubClass"><ReferentialConstraint Property="ChemicalSubClassId" ReferencedProperty="ChemicalSubClassId" /></NavigationProperty><NavigationProperty Name="CreatedByUser" Type="prismCore.Models.ApplicationUser"><ReferentialConstraint Property="CreatedBy" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="ModifiedByUser" Type="prismCore.Models.ApplicationUser"><ReferentialConstraint Property="ModifiedBy" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="ReportBNPMAdminNotes" Type="Collection(prismCore.Models.Entities.ReportBNPMAdminNote)" /></EntityType></Schema><Schema Namespace="prismCore.Code.Constants" xmlns="http://docs.oasis-open.org/odata/ns/edm"><EnumType Name="AddressTypeEnum"><Member Name="Mailing" Value="0" /><Member Name="Physical" Value="1" /></EnumType><EnumType Name="BaseStatusEnum"><Member Name="Pending" Value="0" /><Member Name="Active" Value="1" /><Member Name="Inactive" Value="2" /></EnumType></Schema><Schema Namespace="Default" xmlns="http://docs.oasis-open.org/odata/ns/edm"><Function Name="PublishedDisclosures" IsBound="true"><Parameter Name="bindingParameter" Type="Collection(prismCore.Models.Entities.vAllDisclosure)" /><ReturnType Type="Collection(prismCore.Models.Entities.vAllDisclosure)" /></Function><Function Name="SubmittedDisclosures" IsBound="true"><Parameter Name="bindingParameter" Type="Collection(prismCore.Models.Entities.vAllDisclosure)" /><ReturnType Type="Collection(prismCore.Models.Entities.vAllDisclosure)" /></Function><Function Name="TradeSecretDisclosures" IsBound="true"><Parameter Name="bindingParameter" Type="Collection(prismCore.Models.Entities.vAllDisclosure)" /><ReturnType Type="Collection(prismCore.Models.Entities.vAllDisclosure)" /></Function><EntityContainer Name="Container"><EntitySet Name="ApplicationUser" EntityType="prismCore.Models.ApplicationUser"><NavigationPropertyBinding Path="UserQuestions/ApplicationUser" Target="ApplicationUser" /></EntitySet><EntitySet Name="CompanyAdminNotes" EntityType="prismCore.Models.Entities.CompanyAdminNote" /><EntitySet Name="L_Chemical" EntityType="prismCore.Models.Entities.L_Chemical" /><EntitySet Name="L_ChemicalFunction" EntityType="prismCore.Models.Entities.L_ChemicalFunction" /><EntitySet Name="L_ChemicalSubClass" EntityType="prismCore.Models.Entities.L_ChemicalSubClass" /><EntitySet Name="L_Country" EntityType="prismCore.Models.Entities.L_Country" /><EntitySet Name="L_NAICS" EntityType="prismCore.Models.Entities.L_NAICS" /><EntitySet Name="L_PFASRange" EntityType="prismCore.Models.Entities.L_PFASRange" /><EntitySet Name="L_ReportingPeriod" EntityType="prismCore.Models.Entities.L_ReportingPeriod" /><EntitySet Name="L_SIC" EntityType="prismCore.Models.Entities.L_SIC" /><EntitySet Name="L_State" EntityType="prismCore.Models.Entities.L_State"><NavigationPropertyBinding Path="Country" Target="L_Country" /><NavigationPropertyBinding Path="User" Target="ApplicationUser" /></EntitySet><EntitySet Name="Reports" EntityType="prismCore.Models.Entities.Report"><NavigationPropertyBinding Path="L_ReportingPeriod" Target="L_ReportingPeriod" /><NavigationPropertyBinding Path="ModifiedByUser" Target="ApplicationUser" /><NavigationPropertyBinding Path="ReportAdminNotes" Target="ReportAdminNotes" /><NavigationPropertyBinding Path="SubmittedByUser" Target="ApplicationUser" /></EntitySet><EntitySet Name="ReportAdminNotes" EntityType="prismCore.Models.Entities.ReportAdminNote"><NavigationPropertyBinding Path="Report" Target="Reports" /></EntitySet><EntitySet Name="ReportBNPMAdminNotes" EntityType="prismCore.Models.Entities.ReportBNPMAdminNote" /><EntitySet Name="UserAdminNotes" EntityType="prismCore.Models.Entities.UserAdminNote" /><EntitySet Name="vAllDisclosures" EntityType="prismCore.Models.Entities.vAllDisclosure" /><EntitySet Name="vBrandNames" EntityType="prismCore.Models.Entities.vBrandNames" /><EntitySet Name="vCompanyRelationships" EntityType="prismCore.Models.Entities.vCompanyRelationship"><NavigationPropertyBinding Path="AccountableCompany" Target="vCompanys" /><NavigationPropertyBinding Path="ReportingCompany" Target="vCompanys" /></EntitySet><EntitySet Name="vCompanys" EntityType="prismCore.Models.Entities.vCompanys"><NavigationPropertyBinding Path="AuthToSubmitBy" Target="vCompanyRelationships" /><NavigationPropertyBinding Path="AuthToSubmitFor" Target="vCompanyRelationships" /></EntitySet><EntitySet Name="vComponents" EntityType="prismCore.Models.Entities.vComponents" /><EntitySet Name="vProductCodes" EntityType="prismCore.Models.Entities.vProductCodes" /><EntitySet Name="vProductModels" EntityType="prismCore.Models.Entities.vProductModels" /><EntitySet Name="vReportBNPMDisplays" EntityType="prismCore.Models.Entities.vReportBNPMDisplay" /><EntitySet Name="vSearch" EntityType="prismCore.Models.Entities.vSearch" /><EntitySet Name="vQuestions" EntityType="prismCore.Models.Entities.vQuestions" /><EntitySet Name="vUsersInfos" EntityType="prismCore.Models.Entities.vUsersInfo" /></EntityContainer></Schema></edmx:DataServices></edmx:Edmx>