Summary Table

Categories Total Count
PII 0
URL 0
DNS 0
EKL 0
IP 0
PORT 0
VsID 0
CF 0
AI 0
VPD 0
PL 0
Other 0

File Content

?<?xml version="1.0" encoding="utf-8"?>
<Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="4.0">
<Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" />
<PropertyGroup>
<Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
<Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
<Name>EPRS.ODSDB</Name>
<SchemaVersion>2.0</SchemaVersion>
<ProjectVersion>4.1</ProjectVersion>
<ProjectGuid>{74cc15d4-c5a7-4da6-9986-9afb509df27e}</ProjectGuid>
<DSP>Microsoft.Data.Tools.Schema.Sql.Sql120DatabaseSchemaProvider</DSP>
<OutputType>Database</OutputType>
<RootPath>
</RootPath>
<RootNamespace>EPRS.ODSDB</RootNamespace>
<AssemblyName>EPRS.ODSDB</AssemblyName>
<ModelCollation>1033,CI</ModelCollation>
<DefaultFileStructure>BySchemaType</DefaultFileStructure>
<DeployToDatabase>True</DeployToDatabase>
<TargetFrameworkVersion>v4.5.1</TargetFrameworkVersion>
<TargetLanguage>CS</TargetLanguage>
<AppDesignerFolder>Properties</AppDesignerFolder>
<SqlServerVerification>False</SqlServerVerification>
<TargetDatabaseSet>True</TargetDatabaseSet>
<DefaultCollation>SQL_Latin1_General_CP1_CI_AS</DefaultCollation>
<Containment>None</Containment>
<IsNestedTriggersOn>True</IsNestedTriggersOn>
<IsTransformNoiseWordsOn>False</IsTransformNoiseWordsOn>
<TwoDigitYearCutoff>2049</TwoDigitYearCutoff>
<NonTransactedFileStreamAccess>OFF</NonTransactedFileStreamAccess>
<TargetRecoveryTimePeriod>0</TargetRecoveryTimePeriod>
<TargetRecoveryTimeUnit>SECONDS</TargetRecoveryTimeUnit>
<IsChangeTrackingOn>False</IsChangeTrackingOn>
<IsChangeTrackingAutoCleanupOn>True</IsChangeTrackingAutoCleanupOn>
<ChangeTrackingRetentionPeriod>2</ChangeTrackingRetentionPeriod>
<ChangeTrackingRetentionUnit>Days</ChangeTrackingRetentionUnit>
<IsEncryptionOn>False</IsEncryptionOn>
<IsBrokerPriorityHonored>False</IsBrokerPriorityHonored>
<Trustworthy>False</Trustworthy>
<AutoUpdateStatisticsAsynchronously>False</AutoUpdateStatisticsAsynchronously>
<PageVerify>TORN_PAGE_DETECTION</PageVerify>
<ServiceBrokerOption>DisableBroker</ServiceBrokerOption>
<DateCorrelationOptimizationOn>False</DateCorrelationOptimizationOn>
<Parameterization>SIMPLE</Parameterization>
<AllowSnapshotIsolation>False</AllowSnapshotIsolation>
<ReadCommittedSnapshot>False</ReadCommittedSnapshot>
<VardecimalStorageFormatOn>True</VardecimalStorageFormatOn>
<SupplementalLoggingOn>False</SupplementalLoggingOn>
<CompatibilityMode>120</CompatibilityMode>
<AnsiNullDefault>True</AnsiNullDefault>
<AnsiNulls>True</AnsiNulls>
<AnsiPadding>True</AnsiPadding>
<AnsiWarnings>True</AnsiWarnings>
<ArithAbort>True</ArithAbort>
<ConcatNullYieldsNull>True</ConcatNullYieldsNull>
<QuotedIdentifier>True</QuotedIdentifier>
<NumericRoundAbort>False</NumericRoundAbort>
<RecursiveTriggersEnabled>False</RecursiveTriggersEnabled>
<DatabaseChaining>False</DatabaseChaining>
<DatabaseState>ONLINE</DatabaseState>
<CloseCursorOnCommitEnabled>False</CloseCursorOnCommitEnabled>
<DefaultCursor>LOCAL</DefaultCursor>
<AutoClose>False</AutoClose>
<AutoCreateStatistics>True</AutoCreateStatistics>
<AutoShrink>False</AutoShrink>
<AutoUpdateStatistics>True</AutoUpdateStatistics>
<TornPageDetection>False</TornPageDetection>
<DatabaseAccess>MULTI_USER</DatabaseAccess>
<Recovery>BULK_LOGGED</Recovery>
<EnableFullTextSearch>True</EnableFullTextSearch>
<DefaultFilegroup>StagingData</DefaultFilegroup>
<GenerateCreateScript>True</GenerateCreateScript>
<TargetFrameworkProfile />
</PropertyGroup>
<PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
<OutputPath>bin\Release\</OutputPath>
<BuildScriptName>$(MSBuildProjectName).sql</BuildScriptName>
<TreatWarningsAsErrors>False</TreatWarningsAsErrors>
<DebugType>pdbonly</DebugType>
<Optimize>true</Optimize>
<DefineDebug>false</DefineDebug>
<DefineTrace>true</DefineTrace>
<ErrorReport>prompt</ErrorReport>
<WarningLevel>4</WarningLevel>
</PropertyGroup>
<PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
<OutputPath>bin\Debug\</OutputPath>
<BuildScriptName>$(MSBuildProjectName).sql</BuildScriptName>
<TreatWarningsAsErrors>false</TreatWarningsAsErrors>
<DebugSymbols>true</DebugSymbols>
<DebugType>full</DebugType>
<Optimize>false</Optimize>
<DefineDebug>true</DefineDebug>
<DefineTrace>true</DefineTrace>
<ErrorReport>prompt</ErrorReport>
<WarningLevel>4</WarningLevel>
</PropertyGroup>
<!-- VS10 without SP1 will not have VisualStudioVersion set, so do that here -->
<PropertyGroup>
<VisualStudioVersion Condition="'$(VisualStudioVersion)' == ''">10.0</VisualStudioVersion>
<!-- Default to the v10.0 targets path if the targets file for the current VS version is not found -->
<SSDTExists Condition="Exists('$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets')">True</SSDTExists>
<VisualStudioVersion Condition="'$(SSDTExists)' == ''">10.0</VisualStudioVersion>
</PropertyGroup>
<Import Project="$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
<ItemGroup>
<Folder Include="Properties" />
<Folder Include="Tables\" />
<Folder Include="Storage\" />
<Folder Include="Security\" />
<Folder Include="Storage\Filegroups" />
<Folder Include="Storage\Files" />
<Folder Include="Data Generation Plans" />
<Folder Include="Schema Comparisons" />
<Folder Include="Programmability" />
<Folder Include="Programmability\Stored Procedures" />
<Folder Include="Programmability\Functions" />
<Folder Include="Programmability\Database Triggers" />
<Folder Include="Views" />
<Folder Include="Security\Roles" />
<Folder Include="Security\Schemas" />
<Folder Include="SeedData" />
<Folder Include="TestScripts" />
</ItemGroup>
<ItemGroup>
<Build Include="Storage\Filegroups\AuditData.sql" />
<Build Include="Storage\Files\AuditData.sql" />
<Build Include="Storage\Files\AuditIndex.sql" />
<Build Include="Storage\Files\CoreData.sql" />
<Build Include="Storage\Files\CoreIndex.sql" />
<Build Include="Storage\Files\DefinitionData.sql" />
<Build Include="Storage\Files\DefinitionIndex.sql" />
<Build Include="Storage\Files\LogData.sql" />
<Build Include="Storage\Files\Primary.sql" />
<Build Include="Storage\Files\StagingData.sql" />
<Build Include="Storage\Files\StagingIndex.sql" />
<Build Include="Storage\Filegroups\StagingIndex.sql" />
<Build Include="Security\Roles\db_execute.sql" />
<Build Include="Security\Schemas\zraw.sql" />
<Build Include="Tables\Regions.sql" />
<Build Include="Tables\Stations.sql" />
<Build Include="Tables\Visns.sql" />
<Build Include="Tables\WebLogs.sql" />
<Build Include="Programmability\Functions\ufnGetErrorInfo.sql" />
<Build Include="Programmability\Functions\ufnSplit.sql" />
<Build Include="Programmability\Stored Procedures\uspRaiseErrorInfo.sql" />
<Build Include="Programmability\Stored Procedures\uspRptDetDataDictionary.sql" />
<Build Include="Programmability\Stored Procedures\uspRptDetStations.sql" />
<Build Include="Programmability\Functions\ufnGetBatchLogBatchDate.sql" />
<Build Include="Tables\BatchLogs.sql" />
<Build Include="Programmability\Functions\ufnGetAccessLevelConstant.sql" />
<Build Include="Programmability\Functions\ufnIsNationalUser.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspDoDeactivateInactiveUsers.sql" />
<Build Include="Programmability\Stored Procedures\uspGetADDomains.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspGetUserMaxSensitivityLevel.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspGetUserParentStations.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspGetUserRoleStatuses.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspGetUserStationRoles.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspGetUserStations.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspGetUserVisns.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspRptGetUserParentStationsList.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspRptGetUserParentStationsListWithNullHandler.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspRptGetUserVHARegionsListWithNullHandler.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspRptGetUserStationsList.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspRptGetUserStationsListWithNullHandler.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspRptGetUserVisnsList.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspRptGetUserVisnsListWithNullHandler.sql" />
<Build Include="Tables\seclyr.UserRoles.sql" />
<Build Include="Tables\seclyr.Users.sql" />
<Build Include="Tables\seclyr.Roles.sql" />
<Build Include="Tables\MenuItems.sql" />
<Build Include="Tables\seclyr.Modules.sql" />
<Build Include="Tables\seclyr.AccessLevels.sql" />
<Build Include="Tables\seclyr.SensitivityLevels.sql" />
<Build Include="Security\Schemas\seclyr.sql" />
<Build Include="Programmability\Stored Procedures\uspRptDetWebLogs.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspRptDetUserLoginActivity.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspRptDetUserMgt.sql" />
<Build Include="Programmability\Stored Procedures\uspRptGetADDomains.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspRptDetUserRoles.sql" />
<Build Include="Programmability\Stored Procedures\uspRptVizWebLogDistinctUsers.sql" />
<Build Include="Programmability\Stored Procedures\uspRptVizWebLogUserRoles.sql" />
<Build Include="Programmability\Stored Procedures\uspRptVizWebLogWeekly.sql" />
<Build Include="Programmability\Stored Procedures\uspRptVizWebLogADDomains.sql" />
<Build Include="Programmability\Stored Procedures\uspRptVizWebLogPageUsages.sql" />
<Build Include="Tables\SyncLogs.sql" />
<Build Include="Programmability\Stored Procedures\uspRptDetBatchLogs.sql" />
<Build Include="Programmability\Stored Procedures\uspRptDetSyncLogs.sql" />
<Build Include="Programmability\Stored Procedures\uspRptGetADDomainsWithSelectAll.sql" />
<Build Include="Tables\seclyr.ApplicationKeys.sql" />
<Build Include="Tables\MenuItemTypes.sql" />
<Build Include="Tables\zraw._fbcshcfa.sql" />
<Build Include="Tables\zraw._fbcshcfalines.sql" />
<Build Include="Tables\zraw._fbcsub92.sql" />
<Build Include="Tables\zraw._fbcsformtypes.sql" />
<Build Include="Tables\zraw._conConsult.sql" />
<Build Include="Tables\zraw._conConsultActivity.sql" />
<Build Include="Tables\zraw._fbcshcfaedit.sql" />
<Build Include="Tables\zraw._fbcshcfaprovider.sql" />
<Build Include="Tables\zraw._fbcshcfascore.sql" />
<Build Include="Tables\zraw._fbcshcfastatus.sql" />
<Build Include="Tables\zraw._fbcsinpatientauthorization.sql" />
<Build Include="Tables\zraw._fbcsoutpatientauthorization.sql" />
<Build Include="Tables\zraw._fbcsreasons.sql" />
<Build Include="Tables\zraw._fbcsreasonsxref.sql" />
<Build Include="Tables\zraw._fbcsreasontypes.sql" />
<Build Include="Tables\zraw._fbcsstatuses.sql" />
<Build Include="Tables\zraw._fbcssuspensionreasons.sql" />
<Build Include="Tables\zraw._fbcsub92edit.sql" />
<Build Include="Tables\zraw._fbcsub92lines.sql" />
<Build Include="Tables\zraw._fbcsub92provider.sql" />
<Build Include="Tables\zraw._fbcsub92score.sql" />
<Build Include="Tables\zraw._fbcsub92status.sql" />
<Build Include="Tables\Patients.sql" />
<Build Include="Tables\zraw._fbcsclaimsnotprocessed.sql" />
<Build Include="Tables\zraw._spatientSConsultActivityComment.sql" />
<Build Include="Programmability\Stored Procedures\uspSetBatchLogsReadyforBatch.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoDeleteRaw.sql" />
<Build Include="Programmability\Stored Procedures\uspSetBatchLogStatus.sql" />
<Build Include="Programmability\Stored Procedures\uspSetSyncLogs.sql" />
<Build Include="Tables\FaqCategories.sql" />
<Build Include="Tables\FaqItems.sql" />
<Build Include="Tables\zraw._fbcsfacility.sql" />
<Build Include="Tables\ClaimTypes.sql" />
<Build Include="Tables\FBCSUnprocessedClaims.sql" />
<Build Include="Tables\CallCenterPrograms.sql" />
<Build Include="Tables\ClaimAgeGroups.sql" />
<Build Include="Tables\Reasons.sql" />
<Build Include="Tables\DiagnosisCodes.sql" />
<Build Include="Tables\FBCSClaimDiagnoses.sql" />
<Build Include="Tables\ClaimStatuses.sql" />
<Build Include="Tables\RepricedStatuses.sql" />
<Build Include="Tables\MeansTestStatuses.sql" />
<Build Include="Tables\AdmissionSources.sql" />
<Build Include="Tables\AdmissionTypes.sql" />
<Build Include="Tables\FBCSHCFAEdits.sql" />
<Build Include="Tables\FBCSHCFAStatus.sql" />
<Build Include="Tables\FBCSUBLines.sql" />
<Build Include="Tables\FBCSUBScores.sql" />
<Build Include="Tables\FBCSUBClaimABCs.sql" />
<Build Include="Tables\FBCSUBClaimConditionCodes.sql" />
<Build Include="Tables\FBCSUBClaimInpatientDRGs.sql" />
<Build Include="Tables\FBCSUBClaimOccurrenceCodes.sql" />
<Build Include="Tables\FBCSUBClaimProcedureCodes.sql" />
<Build Include="Tables\FBCSUBClaims.sql" />
<Build Include="Tables\FBCSUBClaimValueCodes.sql" />
<Build Include="Tables\FBCSUsers.sql" />
<Build Include="Tables\FBCSProviders.sql" />
<Build Include="Tables\ConditionCodes.sql" />
<Build Include="Tables\DiagnosisRelatedGroups.sql" />
<Build Include="Tables\DischargeStatuses.sql" />
<Build Include="Tables\OccurrenceCodes.sql" />
<Build Include="Tables\ProcedureCodes.sql" />
<Build Include="Tables\ReasonTypes.sql" />
<Build Include="Tables\ValueCodes.sql" />
<Build Include="Tables\FBCSHCFAClaims.sql" />
<Build Include="Tables\FBCSUBStatuses.sql" />
<Build Include="Tables\zraw._dimActivityType.sql" />
<Build Include="Tables\zraw._dimClinicalProcedure.sql" />
<Build Include="Tables\zraw._dimGMRCProcedure.sql" />
<Build Include="Tables\zraw._dimLocation.sql" />
<Build Include="Tables\FBCSHCFAProvider.sql" />
<Build Include="Tables\FBCSHCFAScores.sql" />
<Build Include="Tables\FBCSFormTypes.sql" />
<Build Include="Tables\FBCSHCFAFacilities.sql" />
<Build Include="Tables\FBCSHCFALines.sql" />
<Build Include="Tables\FBCSSuspensionReasons.sql" />
<Build Include="Tables\FBCSUBEdit.sql" />
<Build Include="Tables\FBCSUBProvider.sql" />
<Build Include="Programmability\Stored Procedures\uspDoAdminNotifications.sql" />
<Build Include="Programmability\Stored Procedures\uspDoAdminNotificationsCount.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspGetUserMenuItems.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspGetUserReportItems.sql" />
<Build Include="Tables\StatusTypes.sql" />
<Build Include="Tables\RequestServices.sql" />
<Build Include="Tables\OneConsults.sql" />
<Build Include="Tables\zraw._t8mTriwestNotifications.sql" />
<Build Include="Tables\zraw._t8mTriwestSarReviews.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoCreateRawConsultIndexesPreCoreLoad.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoDropRawConsultIndexesPostCoreLoad.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoSetOneConsultsHasProvisionalDiagnosis.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoSynchOneConsults.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoSynchRawFKOneConsultStations.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoSyncRequestServices.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoSyncStatusTypes.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspMasterDoSynchOneConsultDataFromRaw.sql" />
<Build Include="Programmability\Stored Procedures\uspRptDetOneConsults.sql" />
<Build Include="Programmability\Stored Procedures\uspRptSumOneConsultsQrtlyMthly.sql" />
<Build Include="Programmability\Stored Procedures\uspGetStations.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspMasterDoSynchDataFromRaw.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspRptGetUserStationMaxSensitivityLevel.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspRptGetUserCCNRegionsList.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspRptGetUserCCNRegionsListWithNullHandler.sql" />
<Build Include="Tables\zraw._dimRequestService.sql" />
<Build Include="Tables\zraw._dimAssociatedStopCode.sql" />
<Build Include="Tables\zraw._dimStopCode.sql" />
<Build Include="Programmability\Stored Procedures\_DEMOuspRptPiiPatients.sql" />
<Build Include="Tables\States.sql" />
<Build Include="Tables\zraw._conConsultFactor.sql" />
<Build Include="Tables\ConsultFactors.sql" />
<Build Include="Tables\Consults.sql" />
<Build Include="Tables\ConsultActivities.sql" />
<Build Include="Tables\SConsultActivityComments.sql" />
<Build Include="Tables\ConsultFactorTypes.sql" />
<Build Include="Tables\StaffUsers.sql" />
<Build Include="Tables\zraw._dimSta3n.sql" />
<Build Include="Tables\zraw._ndimConsultFactorType.sql" />
<Build Include="Tables\StopCodes.sql" />
<Build Include="Tables\RecordStatuses.sql" />
<None Include="SeedData\seedRecordStatuses.sql" />
<Build Include="Tables\AssociatedStopCodes.sql" />
<None Include="SeedData\seedUrgencies.sql" />
<Build Include="Tables\Urgencies.sql" />
<Build Include="Tables\ActivityTypes.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspMasterDoCleanRaw.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspMasterDoShrinkReindexAll.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoSyncStations.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoCleanRequestServices.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoDynamicSliceStation6A.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoSyncStopCodes.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoCleanStopCodes.sql" />
<Build Include="Tables\Institutions.sql" />
<Build Include="Tables\Locations.sql" />
<Build Include="Tables\Protocols.sql" />
<Build Include="Tables\TIUDocumentDefinitions.sql" />
<Build Include="Tables\TIUDocuments.sql" />
<Build Include="Tables\zraw._DIMTIUDocumentDefinitions.sql" />
<Build Include="Tables\zraw._TIUTIUDocuments.sql" />
<Build Include="Tables\zraw._dimProtocol.sql" />
<Build Include="Tables\ProcedureSubspecialtyTypes.sql" />
<None Include="SeedData\seedStates.sql" />
<None Include="SeedData\seedRegions.sql" />
<None Include="SeedData\seedModules.sql" />
<None Include="SeedData\seedRoles.sql" />
<None Include="SeedData\seedVisns.sql" />
<None Include="SeedData\seedSensitivityLevels.sql" />
<None Include="SeedData\seedAccessLevels.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoSyncAssociatedStopCodes.sql" />
<Build Include="Programmability\Functions\ufnGetBatchLogsForTableProcessing.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoCleanAssociatedStopCodes.sql" />
<None Include="TestScripts\RegionVisnStationProcTests.sql" />
<Build Include="Programmability\Stored Procedures\uspRptDetUspUfnDictionary.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspMasterDoSyncDataFromRawConsultDomain.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoSynchRawFKsConsults.sql" />
<Build Include="Tables\zraw._ccract_city.sql" />
<Build Include="Tables\zraw._ccract_region.sql" />
<Build Include="Tables\zraw._ccrapac_waitinglisttype.sql" />
<Build Include="Tables\zraw._ccrapa_waitinglist.sql" />
<Build Include="Tables\zraw._ccract_hospital.sql" />
<Build Include="Tables\zraw._ccrarb_appointment.sql" />
<Build Include="Tables\zraw._ccrapac_stateppp.sql" />
<Build Include="Tables\RoleMenuItems.sql" />
<Build Include="Tables\ModuleMenuItems.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspMasterDoSyncDataFromRawCCRADomain.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoCleanTIUDocuments.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoSynchRawFKTIUDocuments.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoSyncTIUDocumentDefinitions.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoSyncTIUDocuments.sql" />
<Build Include="Tables\zraw._StaffUsers.sql" />
<Build Include="Programmability\Stored Procedures\uspGetAdministratorEmails.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspGetUserVHARegions.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspGetUserCCNRegions.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspRptGetUserVHARegionsList.sql" />
<Build Include="Tables\zraw._ccract_sex.sql" />
<Build Include="Tables\zraw._ccraarc_insurancetype.sql" />
<Build Include="Tables\zraw._ccraarc_itmmast.sql" />
<Build Include="Tables\zraw._ccraarc_ordsetdate.sql" />
<Build Include="Tables\zraw._ccraarc_ordsetdateitem.sql" />
<Build Include="Tables\zraw._ccraarc_ordsets.sql" />
<Build Include="Tables\zraw._ccraarc_package.sql" />
<Build Include="Tables\zraw._ccraarc_packagedet.sql" />
<Build Include="Tables\zraw._ccraarc_packagereason.sql" />
<Build Include="Tables\zraw._ccraarc_packagestatus.sql" />
<Build Include="Tables\zraw._ccract_careprov.sql" />
<Build Include="Tables\zraw._ccract_country.sql" />
<Build Include="Tables\zraw._ccract_loc.sql" />
<Build Include="Tables\zraw._ccract_taskassigngroup.sql" />
<Build Include="Tables\zraw._ccract_zip.sql" />
<Build Include="Tables\zraw._ccramr_nursingnotes.sql" />
<Build Include="Tables\zraw._ccramrc_icddx.sql" />
<Build Include="Tables\zraw._ccrapa_patmas.sql" />
<Build Include="Tables\zraw._ccrapa_personpackage.sql" />
<Build Include="Tables\zraw._ccrapa_personpackagedet.sql" />
<Build Include="Tables\zraw._ccrapa_waitinglisttransaction.sql" />
<Build Include="Tables\zraw._ccrapa_person.sql" />
<Build Include="Tables\zraw._ccrapac_caretype.sql" />
<Build Include="Tables\zraw._ccrapac_episodesubtype.sql" />
<Build Include="Tables\zraw._ccrapac_programfundingsource.sql" />
<Build Include="Tables\zraw._ccrapac_referralperiod.sql" />
<Build Include="Tables\zraw._ccrapac_refstatusreason.sql" />
<Build Include="Tables\zraw._ccrapac_sourceofaddition.sql" />
<Build Include="Tables\zraw._ccrapac_waitingliststatus.sql" />
<Build Include="Tables\zraw._ccrarb_apptschedule.sql" />
<Build Include="Tables\zraw._ccrarb_resource.sql" />
<Build Include="Tables\zraw._ccrass_group.sql" />
<Build Include="Tables\zraw._ccrass_user.sql" />
<Build Include="Tables\zraw._ccraTaskList.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoCleanConsultFactors.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoCleanConsults.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoSyncConsultFactors.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoSyncConsults.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoSyncRawFKAssociatedStopCodes.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoSyncRawFKConsultFactors.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoSyncRawFKStopCodes.sql" />
<Build Include="Tables\zraw._ccract_careprovgroup.sql" />
<Build Include="Tables\zraw._ccract_hospitaltrusts.sql" />
<Build Include="Tables\zraw._ccract_province.sql" />
<Build Include="Tables\zraw._ccract_state.sql" />
<Build Include="Tables\zraw._ccract_taskdisposition.sql" />
<Build Include="Tables\zraw._ccrapa_adm.sql" />
<Build Include="Tables\zraw._ccra_Qusxxes.sql" />
<Build Include="Tables\zraw._ccraTask.sql" />
<Build Include="Tables\zraw._ccrapa_adminsurance.sql" />
<Build Include="Tables\zraw._ccrapa_personcareprovider.sql" />
<Build Include="Tables\zraw._ccrapa_waitinglistguardate.sql" />
<Build Include="Tables\zraw._ccrapa_waitinglistinshistory.sql" />
<Build Include="Tables\zraw._ccrapac_contmethod.sql" />
<Build Include="Tables\zraw._ccrapac_contoutcome.sql" />
<Build Include="Tables\zraw._ccrapac_documenttype.sql" />
<Build Include="Tables\zraw._ccrapac_facilitytype.sql" />
<Build Include="Tables\zraw._ccrapac_nationalppp.sql" />
<Build Include="Tables\zraw._ccrapac_trust.sql" />
<Build Include="Tables\zraw._ccrapac_waitinglistpriority.sql" />
<Build Include="Tables\zraw._ccrapac_legalstatus.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspRptGetUserVHARegionMaxSensitivityLevel.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspRptGetUserCCNRegionMaxSensitivityLevel.sql" />
<Build Include="Programmability\Stored Procedures\seclyr.uspRptGetUserVisnMaxSensitivityLevel.sql" />
<Build Include="Tables\CCRAAppointments.sql" />
<Build Include="Tables\CCRAAppointmentTypes.sql" />
<Build Include="Tables\CCRACities.sql" />
<Build Include="Tables\CCRAHospitals.sql" />
<Build Include="Tables\CCRARegions.sql" />
<Build Include="Tables\CCRAWaitingLists.sql" />
<Build Include="Tables\CCRAWaitingListTypes.sql" />
<Build Include="Tables\zraw._ccraTaskCategory.sql" />
<None Include="SeedData\seedStatusTypes.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoCleanLocations.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoCleanOrderStatuses.sql" />
<Build Include="Programmability\Stored Procedures\zraw.uspDoCleanProtocols.sql" />
<Build Include="Tables\OrderStatuses.sql" />
</ItemGroup>
<ItemGroup>
<SqlCmdVariable Include="DefaultDataPath1">
<DefaultValue>C:\Databases</DefaultValue>
<Value>$(SqlCmdVar__1)</Value>
</SqlCmdVariable>
<SqlCmdVariable Include="Folder1">
<DefaultValue>Test</DefaultValue>
<Value>$(SqlCmdVar__2)</Value>
</SqlCmdVariable>
<SqlCmdVariable Include="LogPath1">
<DefaultValue>Test</DefaultValue>
<Value>$(SqlCmdVar__3)</Value>
</SqlCmdVariable>
</ItemGroup>
<ItemGroup>
<Build Include="Storage\Filegroups\AuditIndex.sql" />
<Build Include="Storage\Filegroups\CoreData.sql" />
<Build Include="Storage\Filegroups\CoreIndex.sql" />
<Build Include="Storage\Filegroups\DefinitionData.sql" />
<Build Include="Storage\Filegroups\DefinitionIndex.sql" />
<Build Include="Storage\Filegroups\StagingData.sql" />
</ItemGroup>
<ItemGroup>
<None Include="ReadMe.txt" />
<None Include="Schema Comparisons\SchemaCompare.scmp" />
<None Include="SeedData\seedStations.sql" />
<None Include="SeedData\_README.txt" />
</ItemGroup>
<PropertyGroup>
<PostBuildEvent>
</PostBuildEvent>
</PropertyGroup>
</Project>