SELECT
[Vw_AdjudicationApplicantDetails].[AdjudicationDetailID] AS [AdjudicationDetailID],
[Vw_AdjudicationApplicantDetails].[ApplicationNumber] AS [ApplicationNumber],
[Vw_AdjudicationApplicantDetails].[SurnameOrCompanyName] AS [SurnameOrCompanyName],
[Vw_AdjudicationApplicantDetails].[FirstNames] AS [FirstNames],
[Vw_AdjudicationApplicantDetails].[IDNumberOrBusinessRegistrationNo] AS [IDNumberOrBusinessRegistrationNo],
[Vw_AdjudicationApplicantDetails].[Title] AS [Title],
[Vw_AdjudicationApplicantDetails].[Association] AS [Association],
[Vw_AdjudicationApplicantDetails].[Decision] AS [Decision],
[Vw_AdjudicationApplicantDetails].[DecisionComments] AS [DecisionComments],
[Vw_AdjudicationApplicantDetails].[ApplicationRequestDetailID] AS [ApplicationRequestDetailID],
[Vw_AdjudicationApplicantDetails].[RequestType] AS [RequestType],
[Vw_AdjudicationApplicantDetails].[Member] AS [Member],
[Vw_AdjudicationApplicantDetails].[TelCell] AS [TelCell],
[Vw_AdjudicationApplicantDetails].[AdjudicationException] AS [AdjudicationException],
[Vw_AdjudicationApplicantDetails].[HasObjections] AS [HasObjections]
FROM [App].[Vw_AdjudicationApplicantDetails] AS [Vw_AdjudicationApplicantDetails]
SELECT
[Vw_AdjudicationPanel].[AdjudicationPanelID] AS [AdjudicationPanelID],
[Vw_AdjudicationPanel].[AdjudicationDetailID] AS [AdjudicationDetailID],
[Vw_AdjudicationPanel].[PanelMemberUserID] AS [PanelMemberUserID],
[Vw_AdjudicationPanel].[HasAttended] AS [HasAttended],
[Vw_AdjudicationPanel].[IsChairman] AS [IsChairman],
[Vw_AdjudicationPanel].[DateConfirmed] AS [DateConfirmed],
[Vw_AdjudicationPanel].[AddedAfterStart] AS [AddedAfterStart],
[Vw_AdjudicationPanel].[FullName] AS [FullName],
[Vw_AdjudicationPanel].[Attended] AS [Attended]
FROM [App].[Vw_AdjudicationPanel] AS [Vw_AdjudicationPanel]
SELECT
[Vw_ApplicationRequestDetails].[ApplicationRequestDetailID] AS [ApplicationRequestDetailID],
[Vw_ApplicationRequestDetails].[WorkflowInstanceID] AS [WorkflowInstanceID],
[Vw_ApplicationRequestDetails].[ApplicationNumber] AS [ApplicationNumber],
[Vw_ApplicationRequestDetails].[RequestType] AS [RequestType],
[Vw_ApplicationRequestDetails].[Cost] AS [Cost],
[Vw_ApplicationRequestDetails].[SurnameOrCompanyName] AS [SurnameOrCompanyName],
[Vw_ApplicationRequestDetails].[FirstNames] AS [FirstNames],
[Vw_ApplicationRequestDetails].[TradeName] AS [TradeName],
[Vw_ApplicationRequestDetails].[Member] AS [Member],
[Vw_ApplicationRequestDetails].[VerifiedMemberID] AS [VerifiedMemberID],
[Vw_ApplicationRequestDetails].[IDNumberOrBusinessRegistrationNo] AS [IDNumberOrBusinessRegistrationNo],
[Vw_ApplicationRequestDetails].[ApplicationRequestTypeID] AS [ApplicationRequestTypeID],
[Vw_ApplicationRequestDetails].[SourceApplicationID] AS [SourceApplicationID],
[Vw_ApplicationRequestDetails].[IsNewAssociationRequired] AS [IsNewAssociationRequired],
[Vw_ApplicationRequestDetails].[IsNewMemberRequired] AS [IsNewMemberRequired],
[Vw_ApplicationRequestDetails].[IsNewRouteRequired] AS [IsNewRouteRequired],
[Vw_ApplicationRequestDetails].[IsExceptionRequired] AS [IsExceptionRequired],
[Vw_ApplicationRequestDetails].[IsUpliftmentRequired] AS [IsUpliftmentRequired],
[Vw_ApplicationRequestDetails].[IsAdjustmentRequired] AS [IsAdjustmentRequired],
[Vw_ApplicationRequestDetails].[IsCancellationRequired] AS [IsCancellationRequired],
[Vw_ApplicationRequestDetails].[GazetteNumber] AS [GazetteNumber],
[Vw_ApplicationRequestDetails].[GazetteDetailID] AS [GazetteDetailID],
[Vw_ApplicationRequestDetails].[MeetingDate] AS [MeetingDate],
[Vw_ApplicationRequestDetails].[AdjudicationDetailID] AS [AdjudicationDetailID],
[Vw_ApplicationRequestDetails].[PaymentTypeID] AS [PaymentTypeID],
[Vw_ApplicationRequestDetails].[VehicleCount] AS [VehicleCount],
[Vw_ApplicationRequestDetails].[ChassisNumber] AS [ChassisNumber],
[Vw_ApplicationRequestDetails].[EngineNumber] AS [EngineNumber],
[Vw_ApplicationRequestDetails].[VehicleRegNumber] AS [VehicleRegNumber],
[Vw_ApplicationRequestDetails].[SeatedCapacity] AS [SeatedCapacity],
[Vw_ApplicationRequestDetails].[VehicleMake] AS [VehicleMake],
[Vw_ApplicationRequestDetails].[AdjudicationDecision] AS [AdjudicationDecision],
[Vw_ApplicationRequestDetails].[ApplicationDescription] AS [ApplicationDescription],
[Vw_ApplicationRequestDetails].[IsRenewal] AS [IsRenewal],
[Vw_ApplicationRequestDetails].[AssociationName] AS [AssociationName],
[Vw_ApplicationRequestDetails].[ModeID] AS [ModeID],
[Vw_ApplicationRequestDetails].[TaxNumber] AS [TaxNumber],
[Vw_ApplicationRequestDetails].[PrecheckDetailID] AS [PrecheckDetailID],
[Vw_ApplicationRequestDetails].[IsStillToBeAcquired] AS [IsStillToBeAcquired],
[Vw_ApplicationRequestDetails].[ProxyName] AS [ProxyName],
[Vw_ApplicationRequestDetails].[IsCancelled] AS [IsCancelled],
[Vw_ApplicationRequestDetails].[AdjudicationDecisionID] AS [AdjudicationDecisionID],
[Vw_ApplicationRequestDetails].[AdjudicationComment] AS [AdjudicationComment],
[Vw_ApplicationRequestDetails].[AdjudicationException] AS [AdjudicationException],
[Vw_ApplicationRequestDetails].[TelCell] AS [TelCell],
[Vw_ApplicationRequestDetails].[TelPhone] AS [TelPhone],
[Vw_ApplicationRequestDetails].[RegionID] AS [RegionID],
[Vw_ApplicationRequestDetails].[AdjudicationRegionID] AS [AdjudicationRegionID],
[Vw_ApplicationRequestDetails].[ExistingLicenceHolder] AS [ExistingLicenceHolder],
[Vw_ApplicationRequestDetails].[ExistingLicenceHolderID] AS [ExistingLicenceHolderID],
[Vw_ApplicationRequestDetails].[Region] AS [Region],
[Vw_ApplicationRequestDetails].[ExistingVehicleChassisNumber] AS [ExistingVehicleChassisNumber],
[Vw_ApplicationRequestDetails].[ExistingVehicleRegNumber] AS [ExistingVehicleRegNumber],
[Vw_ApplicationRequestDetails].[WorkflowStatus] AS [WorkflowStatus],
[Vw_ApplicationRequestDetails].[IsAdjudicationBypassed] AS [IsAdjudicationBypassed],
[Vw_ApplicationRequestDetails].[IsGazettingBypassed] AS [IsGazettingBypassed],
[Vw_ApplicationRequestDetails].[IsAssessorApprovalRequired] AS [IsAssessorApprovalRequired],
[Vw_ApplicationRequestDetails].[IsSeniorManagerApprovalRequired] AS [IsSeniorManagerApprovalRequired],
[Vw_ApplicationRequestDetails].[HasNewRoute] AS [HasNewRoute],
[Vw_ApplicationRequestDetails].[ExistingLicenceNumber] AS [ExistingLicenceNumber],
[Vw_ApplicationRequestDetails].[IsAutoVerificationRequired] AS [IsAutoVerificationRequired],
[Vw_ApplicationRequestDetails].[IsLtpsConversion] AS [IsLtpsConversion],
[Vw_ApplicationRequestDetails].[ProxyIDNumber] AS [ProxyIDNumber],
[Vw_ApplicationRequestDetails].[StandingCapacity] AS [StandingCapacity],
[Vw_ApplicationRequestDetails].[AdjudicationCount] AS [AdjudicationCount],
[Vw_ApplicationRequestDetails].[PhysicalAddress] AS [PhysicalAddress],
[Vw_ApplicationRequestDetails].[PhysicalAddressCode] AS [PhysicalAddressCode],
[Vw_ApplicationRequestDetails].[PostalAddress] AS [PostalAddress],
[Vw_ApplicationRequestDetails].[PostalAddressCode] AS [PostalAddressCode]
FROM [App].[Vw_ApplicationRequestDetails] AS [Vw_ApplicationRequestDetails]
SELECT
[Vw_ApplicationRequestDetails_Receipts].[ApplicationRequestDetailID] AS [ApplicationRequestDetailID],
[Vw_ApplicationRequestDetails_Receipts].[WorkflowInstanceID] AS [WorkflowInstanceID],
[Vw_ApplicationRequestDetails_Receipts].[ApplicationNumber] AS [ApplicationNumber],
[Vw_ApplicationRequestDetails_Receipts].[RequestType] AS [RequestType],
[Vw_ApplicationRequestDetails_Receipts].[Cost] AS [Cost],
[Vw_ApplicationRequestDetails_Receipts].[Member] AS [Member],
[Vw_ApplicationRequestDetails_Receipts].[ReceiptNumber] AS [ReceiptNumber],
[Vw_ApplicationRequestDetails_Receipts].[ReceiptDetailID] AS [ReceiptDetailID],
[Vw_ApplicationRequestDetails_Receipts].[PaymentTypeID] AS [PaymentTypeID],
[Vw_ApplicationRequestDetails_Receipts].[VehicleCount] AS [VehicleCount],
[Vw_ApplicationRequestDetails_Receipts].[ChassisNumber] AS [ChassisNumber],
[Vw_ApplicationRequestDetails_Receipts].[EngineNumber] AS [EngineNumber],
[Vw_ApplicationRequestDetails_Receipts].[VehicleRegNumber] AS [VehicleRegNumber],
[Vw_ApplicationRequestDetails_Receipts].[IsCancelled] AS [IsCancelled],
[Vw_ApplicationRequestDetails_Receipts].[ApplicationDescription] AS [ApplicationDescription],
[Vw_ApplicationRequestDetails_Receipts].[IDNumberOrBusinessRegistrationNo] AS [IDNumberOrBusinessRegistrationNo],
[Vw_ApplicationRequestDetails_Receipts].[AdjudicationCount] AS [AdjudicationCount]
FROM [App].[Vw_ApplicationRequestDetails_Receipts] AS [Vw_ApplicationRequestDetails_Receipts]
SELECT
[Vw_AssociationsPurificationCount].[AssociationID] AS [AssociationID],
[Vw_AssociationsPurificationCount].[NeoID] AS [NeoID],
[Vw_AssociationsPurificationCount].[AssociationName] AS [AssociationName],
[Vw_AssociationsPurificationCount].[AssociationDataReceived] AS [AssociationDataReceived],
[Vw_AssociationsPurificationCount].[AssociationDataMemberCount] AS [AssociationDataMemberCount],
[Vw_AssociationsPurificationCount].[AssociationDataLicenceCount] AS [AssociationDataLicenceCount],
[Vw_AssociationsPurificationCount].[TotalMemberVerificationsInProgress] AS [TotalMemberVerificationsInProgress],
[Vw_AssociationsPurificationCount].[TotalMembersVerified] AS [TotalMembersVerified],
[Vw_AssociationsPurificationCount].[TotalMembersCancelled] AS [TotalMembersCancelled],
[Vw_AssociationsPurificationCount].[TotalLicenceVerificationsInProgress] AS [TotalLicenceVerificationsInProgress],
[Vw_AssociationsPurificationCount].[TotalLicencesVerified] AS [TotalLicencesVerified],
[Vw_AssociationsPurificationCount].[TotalLicencesCancelled] AS [TotalLicencesCancelled],
[Vw_AssociationsPurificationCount].[TotalMembersCleaned] AS [TotalMembersCleaned],
[Vw_AssociationsPurificationCount].[TotalLicencesCleaned] AS [TotalLicencesCleaned]
FROM [App].[Vw_AssociationsPurificationCount] AS [Vw_AssociationsPurificationCount]
SELECT
[Vw_GazetteApplications].[ApplicationRequestDetailID] AS [ApplicationRequestDetailID],
[Vw_GazetteApplications].[ApplicationNumber] AS [ApplicationNumber],
[Vw_GazetteApplications].[Member] AS [Member],
[Vw_GazetteApplications].[ApplicationRequestTypeID] AS [ApplicationRequestTypeID],
[Vw_GazetteApplications].[RequestType] AS [RequestType],
[Vw_GazetteApplications].[AdjudicationDetailID] AS [AdjudicationDetailID],
[Vw_GazetteApplications].[WorkflowTemplateStepID] AS [WorkflowTemplateStepID],
[Vw_GazetteApplications].[GazetteDetailID] AS [GazetteDetailID],
[Vw_GazetteApplications].[GazetteNumber] AS [GazetteNumber],
[Vw_GazetteApplications].[GazetteDetailStatusID] AS [GazetteDetailStatusID],
[Vw_GazetteApplications].[IsGazettingBypassed] AS [IsGazettingBypassed],
[Vw_GazetteApplications].[Region] AS [Region]
FROM [App].[Vw_GazetteApplications] AS [Vw_GazetteApplications]
SELECT
[Vw_LicenceIssueDetails].[LicenceIssueDetailID] AS [LicenceIssueDetailID],
[Vw_LicenceIssueDetails].[ApplicationRequestDetailID] AS [ApplicationRequestDetailID],
[Vw_LicenceIssueDetails].[VerifiedLicenceID] AS [VerifiedLicenceID],
[Vw_LicenceIssueDetails].[VerifiedVehicleID] AS [VerifiedVehicleID],
[Vw_LicenceIssueDetails].[WorkflowInstanceID] AS [WorkflowInstanceID],
[Vw_LicenceIssueDetails].[LicenceReferenceNumber] AS [LicenceReferenceNumber],
[Vw_LicenceIssueDetails].[ApplicationReferenceNumber] AS [ApplicationReferenceNumber],
[Vw_LicenceIssueDetails].[RequestType] AS [RequestType],
[Vw_LicenceIssueDetails].[SurnameOrCompanyName] AS [SurnameOrCompanyName],
[Vw_LicenceIssueDetails].[VehicleRegNumber] AS [VehicleRegNumber],
[Vw_LicenceIssueDetails].[ApplicationDescription] AS [ApplicationDescription],
[Vw_LicenceIssueDetails].[CertificateNumber] AS [CertificateNumber],
[Vw_LicenceIssueDetails].[IsStillToBeAcquired] AS [IsStillToBeAcquired],
[Vw_LicenceIssueDetails].[ApplicationRequestTypeID] AS [ApplicationRequestTypeID],
[Vw_LicenceIssueDetails].[MemberFullName] AS [MemberFullName],
[Vw_LicenceIssueDetails].[MemberTaxReference] AS [MemberTaxReference],
[Vw_LicenceIssueDetails].[MemberIDNumber] AS [MemberIDNumber],
[Vw_LicenceIssueDetails].[MemberCell] AS [MemberCell],
[Vw_LicenceIssueDetails].[Association] AS [Association],
[Vw_LicenceIssueDetails].[VehicleVIN] AS [VehicleVIN],
[Vw_LicenceIssueDetails].[VehicleEngineNumber] AS [VehicleEngineNumber],
[Vw_LicenceIssueDetails].[VehicleRegistrationNumber] AS [VehicleRegistrationNumber],
[Vw_LicenceIssueDetails].[VehicleMake] AS [VehicleMake],
[Vw_LicenceIssueDetails].[VehicleSeatedCapacity] AS [VehicleSeatedCapacity],
[Vw_LicenceIssueDetails].[VehicleStandingCapacity] AS [VehicleStandingCapacity]
FROM [App].[Vw_LicenceIssueDetails] AS [Vw_LicenceIssueDetails]
SELECT
[Vw_LicenceUpliftmentExtensionRequestDetails].[LicenceUpliftmentExtensionRequestDetailID] AS [LicenceUpliftmentExtensionRequestDetailID],
[Vw_LicenceUpliftmentExtensionRequestDetails].[VerifiedLicenceID] AS [VerifiedLicenceID],
[Vw_LicenceUpliftmentExtensionRequestDetails].[WorkflowInstanceID] AS [WorkflowInstanceID],
[Vw_LicenceUpliftmentExtensionRequestDetails].[LicenceUpliftmentReferenceNumber] AS [LicenceUpliftmentReferenceNumber],
[Vw_LicenceUpliftmentExtensionRequestDetails].[SurnameOrCompanyName] AS [SurnameOrCompanyName],
[Vw_LicenceUpliftmentExtensionRequestDetails].[CertificateNumber] AS [CertificateNumber],
[Vw_LicenceUpliftmentExtensionRequestDetails].[MemberFullName] AS [MemberFullName],
[Vw_LicenceUpliftmentExtensionRequestDetails].[MemberTaxReference] AS [MemberTaxReference],
[Vw_LicenceUpliftmentExtensionRequestDetails].[MemberIDNumber] AS [MemberIDNumber],
[Vw_LicenceUpliftmentExtensionRequestDetails].[MemberCell] AS [MemberCell],
[Vw_LicenceUpliftmentExtensionRequestDetails].[WorkflowInstanceStatusID] AS [WorkflowInstanceStatusID]
FROM [App].[Vw_LicenceUpliftmentExtensionRequestDetails] AS [Vw_LicenceUpliftmentExtensionRequestDetails]
SELECT
[Vw_NewRouteRequestDetails].[NewRouteRequestDetailID] AS [NewRouteRequestDetailID],
[Vw_NewRouteRequestDetails].[WorkflowInstanceID] AS [WorkflowInstanceID],
[Vw_NewRouteRequestDetails].[VerifiedRouteID] AS [VerifiedRouteID],
[Vw_NewRouteRequestDetails].[RouteOrigin] AS [RouteOrigin],
[Vw_NewRouteRequestDetails].[RouteDestination] AS [RouteDestination],
[Vw_NewRouteRequestDetails].[RouteDescription] AS [RouteDescription],
[Vw_NewRouteRequestDetails].[NationalRouteNumber] AS [NationalRouteNumber],
[Vw_NewRouteRequestDetails].[BoardRouteNumber] AS [BoardRouteNumber],
[Vw_NewRouteRequestDetails].[RouteLength] AS [RouteLength],
[Vw_NewRouteRequestDetails].[ReferenceNumber] AS [ReferenceNumber],
[Vw_NewRouteRequestDetails].[WorkflowInstanceStatus] AS [WorkflowInstanceStatus],
[Vw_NewRouteRequestDetails].[EntityID] AS [EntityID],
[Vw_NewRouteRequestDetails].[ItemID] AS [ItemID],
[Vw_NewRouteRequestDetails].[IsAssessorVerificationRequired] AS [IsAssessorVerificationRequired]
FROM [App].[Vw_NewRouteRequestDetails] AS [Vw_NewRouteRequestDetails]
SELECT
[Vw_PrecheckDetailsIncomplete].[ApplicantName] AS [ApplicantName],
[Vw_PrecheckDetailsIncomplete].[OlPermitNumber] AS [OlPermitNumber],
[Vw_PrecheckDetailsIncomplete].[IDNumber] AS [IDNumber],
[Vw_PrecheckDetailsIncomplete].[ChassisNumber] AS [ChassisNumber],
[Vw_PrecheckDetailsIncomplete].[VehicleRegistrationNumber] AS [VehicleRegistrationNumber],
[Vw_PrecheckDetailsIncomplete].[ApplicationRequestTypeID] AS [ApplicationRequestTypeID],
[Vw_PrecheckDetailsIncomplete].[PrecheckDetailID] AS [PrecheckDetailID],
[Vw_PrecheckDetailsIncomplete].[SourceApplicationID] AS [SourceApplicationID],
[Vw_PrecheckDetailsIncomplete].[CreatedDate] AS [CreatedDate],
[Vw_PrecheckDetailsIncomplete].[ReasonIncomplete] AS [ReasonIncomplete]
FROM [App].[Vw_PrecheckDetailsIncomplete] AS [Vw_PrecheckDetailsIncomplete]
SELECT
[Vw_PurificationDetails].[PurificationDetailID] AS [PurificationDetailID],
[Vw_PurificationDetails].[PurificationDetailStatusID] AS [PurificationDetailStatusID],
[Vw_PurificationDetails].[Status] AS [Status],
[Vw_PurificationDetails].[WorkflowID] AS [WorkflowID],
[Vw_PurificationDetails].[ItemID] AS [ItemID],
[Vw_PurificationDetails].[ApplicationRequestTypeID] AS [ApplicationRequestTypeID],
[Vw_PurificationDetails].[SourceApplicationID] AS [SourceApplicationID],
[Vw_PurificationDetails].[PreCheckDetailID] AS [PreCheckDetailID],
[Vw_PurificationDetails].[ApplicantName] AS [ApplicantName],
[Vw_PurificationDetails].[IDNumber] AS [IDNumber],
[Vw_PurificationDetails].[VehicleRegistrationNumber] AS [VehicleRegistrationNumber],
[Vw_PurificationDetails].[ApplicationRequestDetailID] AS [ApplicationRequestDetailID],
[Vw_PurificationDetails].[Comments] AS [Comments],
[Vw_PurificationDetails].[NeoID] AS [NeoID],
[Vw_PurificationDetails].[NeoOLPermitNumber] AS [NeoOLPermitNumber]
FROM [App].[Vw_PurificationDetails] AS [Vw_PurificationDetails]
SELECT
[Vw_ReceiptDetails].[ReceiptDetailID] AS [ReceiptDetailID],
[Vw_ReceiptDetails].[ReceiptNumber] AS [ReceiptNumber],
[Vw_ReceiptDetails].[TotalCost] AS [TotalCost],
[Vw_ReceiptDetails].[PaymentType] AS [PaymentType],
[Vw_ReceiptDetails].[ApplicantData] AS [ApplicantData],
[Vw_ReceiptDetails].[ReceiptItems] AS [ReceiptItems],
[Vw_ReceiptDetails].[CreatedDate] AS [CreatedDate],
[Vw_ReceiptDetails].[CreatedById] AS [CreatedById],
[Vw_ReceiptDetails].[ReceiptBatchID] AS [ReceiptBatchID],
[Vw_ReceiptDetails].[AssociationName] AS [AssociationName],
[Vw_ReceiptDetails].[PaymentTypeID] AS [PaymentTypeID],
[Vw_ReceiptDetails].[ApplicationRequestDetailID] AS [ApplicationRequestDetailID]
FROM [App].[Vw_ReceiptDetails] AS [Vw_ReceiptDetails]
SELECT
[Vw_Associations].[AssociationName] AS [AssociationName],
[Vw_Associations].[AssociationNameAbbrev] AS [AssociationNameAbbrev],
[Vw_Associations].[ActiveMemberCount] AS [ActiveMemberCount],
[Vw_Associations].[Status] AS [Status],
[Vw_Associations].[Mode] AS [Mode],
[Vw_Associations].[Type] AS [Type],
[Vw_Associations].[Region] AS [Region],
[Vw_Associations].[AssociationID] AS [AssociationID],
[Vw_Associations].[AssociationDataReceived] AS [AssociationDataReceived],
[Vw_Associations].[AssociationDataMemberCount] AS [AssociationDataMemberCount],
[Vw_Associations].[AssociationDataLicenceCount] AS [AssociationDataLicenceCount],
[Vw_Associations].[TotalMemberVerificationsInProgress] AS [TotalMemberVerificationsInProgress],
[Vw_Associations].[TotalMembersVerified] AS [TotalMembersVerified],
[Vw_Associations].[TotalMembersCancelled] AS [TotalMembersCancelled],
[Vw_Associations].[TotalLicenceVerificationsInProgress] AS [TotalLicenceVerificationsInProgress],
[Vw_Associations].[TotalLicencesVerified] AS [TotalLicencesVerified],
[Vw_Associations].[TotalLicencesCancelled] AS [TotalLicencesCancelled],
[Vw_Associations].[TotalMembersCleaned] AS [TotalMembersCleaned],
[Vw_Associations].[TotalLicencesCleaned] AS [TotalLicencesCleaned]
FROM [Verified].[Vw_Associations] AS [Vw_Associations]
SELECT
[Vw_OperatingLicenceDetails].[LicenceID] AS [LicenceID],
[Vw_OperatingLicenceDetails].[ApplicationRequestDetailID] AS [ApplicationRequestDetailID],
[Vw_OperatingLicenceDetails].[AssociationName] AS [AssociationName],
[Vw_OperatingLicenceDetails].[OperatingLicenceNumber] AS [OperatingLicenceNumber],
[Vw_OperatingLicenceDetails].[ApplicationNumber] AS [ApplicationNumber],
[Vw_OperatingLicenceDetails].[IDNumberOrBusinessRegistrationNo] AS [IDNumberOrBusinessRegistrationNo],
[Vw_OperatingLicenceDetails].[NameOnLicence] AS [NameOnLicence],
[Vw_OperatingLicenceDetails].[PostalAddress] AS [PostalAddress],
[Vw_OperatingLicenceDetails].[RegistrationNumber] AS [RegistrationNumber],
[Vw_OperatingLicenceDetails].[GrossMass] AS [GrossMass],
[Vw_OperatingLicenceDetails].[EngineNumber] AS [EngineNumber],
[Vw_OperatingLicenceDetails].[VIN] AS [VIN],
[Vw_OperatingLicenceDetails].[VehicleMake] AS [VehicleMake],
[Vw_OperatingLicenceDetails].[SeatedCapacity] AS [SeatedCapacity],
[Vw_OperatingLicenceDetails].[StandingCapacity] AS [StandingCapacity],
[Vw_OperatingLicenceDetails].[VehicleType] AS [VehicleType],
[Vw_OperatingLicenceDetails].[CertificateNumber] AS [CertificateNumber],
[Vw_OperatingLicenceDetails].[DateOfIssue] AS [DateOfIssue],
[Vw_OperatingLicenceDetails].[DateOfExpiry] AS [DateOfExpiry],
[Vw_OperatingLicenceDetails].[CrossBorder] AS [CrossBorder],
[Vw_OperatingLicenceDetails].[LicensingBoard] AS [LicensingBoard],
[Vw_OperatingLicenceDetails].[YearOfFirstReg] AS [YearOfFirstReg],
[Vw_OperatingLicenceDetails].[ApplicationRequestTypeID] AS [ApplicationRequestTypeID],
[Vw_OperatingLicenceDetails].[LicenceExceptions] AS [LicenceExceptions],
[Vw_OperatingLicenceDetails].[LicenceStatus] AS [LicenceStatus],
[Vw_OperatingLicenceDetails].[VehicleID] AS [VehicleID],
[Vw_OperatingLicenceDetails].[AssociationID] AS [AssociationID],
[Vw_OperatingLicenceDetails].[LicenceStatusID] AS [LicenceStatusID],
[Vw_OperatingLicenceDetails].[MemberID] AS [MemberID]
FROM [Verified].[Vw_OperatingLicenceDetails] AS [Vw_OperatingLicenceDetails]
SELECT
[Vw_Places].[PlaceID] AS [PlaceID],
[Vw_Places].[Description] AS [Description],
[Vw_Places].[PlaceTypeID] AS [PlaceTypeID],
[Vw_Places].[PlaceType] AS [PlaceType],
[Vw_Places].[PlaceStatusID] AS [PlaceStatusID],
[Vw_Places].[OlasID] AS [OlasID],
[Vw_Places].[LtpsID] AS [LtpsID],
[Vw_Places].[NeoID] AS [NeoID]
FROM [Verified].[Vw_Places] AS [Vw_Places]
SELECT
[Vw_Vehicles].[VehicleID] AS [VehicleID],
[Vw_Vehicles].[ReferenceNumber] AS [ReferenceNumber],
[Vw_Vehicles].[RegistrationNumber] AS [RegistrationNumber],
[Vw_Vehicles].[VIN] AS [VIN],
[Vw_Vehicles].[Make] AS [Make],
[Vw_Vehicles].[Type] AS [Type],
[Vw_Vehicles].[EngineNumber] AS [EngineNumber],
[Vw_Vehicles].[SeatedCapacity] AS [SeatedCapacity],
[Vw_Vehicles].[StandingCapacity] AS [StandingCapacity],
[Vw_Vehicles].[GrossMass] AS [GrossMass],
[Vw_Vehicles].[CarryingCapacityID] AS [CarryingCapacityID],
[Vw_Vehicles].[YearOfManufacture] AS [YearOfManufacture],
[Vw_Vehicles].[CarryingCapacity] AS [CarryingCapacity]
FROM [Verified].[Vw_Vehicles] AS [Vw_Vehicles]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]
[ScriptIgnore]