SELECT [Vw_AdjudicationApplicationDetails].[ApplicationAdjudicationID] AS [ApplicationAdjudicationID], [Vw_AdjudicationApplicationDetails].[AdjudicationDetailID] AS [AdjudicationDetailID], [Vw_AdjudicationApplicationDetails].[ApplicationLicenceID] AS [ApplicationLicenceID], [Vw_AdjudicationApplicationDetails].[ApplicationNumber] AS [ApplicationNumber], [Vw_AdjudicationApplicationDetails].[SurnameOrCompanyName] AS [SurnameOrCompanyName], [Vw_AdjudicationApplicationDetails].[FirstNames] AS [FirstNames], [Vw_AdjudicationApplicationDetails].[IDNumberOrBusinessRegistrationNo] AS [IDNumberOrBusinessRegistrationNo], [Vw_AdjudicationApplicationDetails].[Title] AS [Title], [Vw_AdjudicationApplicationDetails].[Association] AS [Association], [Vw_AdjudicationApplicationDetails].[Decision] AS [Decision], [Vw_AdjudicationApplicationDetails].[DecisionID] AS [DecisionID], [Vw_AdjudicationApplicationDetails].[DecisionComments] AS [DecisionComments], [Vw_AdjudicationApplicationDetails].[ApplicationDetailID] AS [ApplicationDetailID], [Vw_AdjudicationApplicationDetails].[ApplicationRequestTypeID] AS [ApplicationRequestTypeID], [Vw_AdjudicationApplicationDetails].[RequestType] AS [RequestType], [Vw_AdjudicationApplicationDetails].[Member] AS [Member], [Vw_AdjudicationApplicationDetails].[TelCell] AS [TelCell], [Vw_AdjudicationApplicationDetails].[HasObjections] AS [HasObjections], [Vw_AdjudicationApplicationDetails].[LicenceCount] AS [LicenceCount], [Vw_AdjudicationApplicationDetails].[AdjudicationException] AS [AdjudicationException], [Vw_AdjudicationApplicationDetails].[IsReadyForAdjudication] AS [IsReadyForAdjudication] FROM [App].[Vw_AdjudicationApplicationDetails] AS [Vw_AdjudicationApplicationDetails] SELECT [Vw_AdjudicationDetails].[AdjudicationDetailID] AS [AdjudicationDetailID], [Vw_AdjudicationDetails].[AdjudicationTypeID] AS [AdjudicationTypeID], [Vw_AdjudicationDetails].[AdjudicationType] AS [AdjudicationType], [Vw_AdjudicationDetails].[AdjudicationDetailStatusID] AS [AdjudicationDetailStatusID], [Vw_AdjudicationDetails].[ProvinceID] AS [ProvinceID], [Vw_AdjudicationDetails].[Province] AS [Province], [Vw_AdjudicationDetails].[MeetingDate] AS [MeetingDate], [Vw_AdjudicationDetails].[MeetingPlace] AS [MeetingPlace], [Vw_AdjudicationDetails].[MeetingTime] AS [MeetingTime], [Vw_AdjudicationDetails].[PreAdjudicationNotificationsSent] AS [PreAdjudicationNotificationsSent], [Vw_AdjudicationDetails].[PreAdjudicationLettersSent] AS [PreAdjudicationLettersSent], [Vw_AdjudicationDetails].[PreAdjudicationObjectionNotificationsSent] AS [PreAdjudicationObjectionNotificationsSent], [Vw_AdjudicationDetails].[PreAdjudicationObjectionLettersSent] AS [PreAdjudicationObjectionLettersSent], [Vw_AdjudicationDetails].[PostAdjudicationNotificationsSent] AS [PostAdjudicationNotificationsSent], [Vw_AdjudicationDetails].[PostAdjudicationLettersSent] AS [PostAdjudicationLettersSent], [Vw_AdjudicationDetails].[Region] AS [Region], [Vw_AdjudicationDetails].[CreatedByID] AS [CreatedByID], [Vw_AdjudicationDetails].[CreatedDate] AS [CreatedDate], [Vw_AdjudicationDetails].[UpdatedByID] AS [UpdatedByID], [Vw_AdjudicationDetails].[UpdatedDate] AS [UpdatedDate], [Vw_AdjudicationDetails].[AdjudicationFinalisedDate] AS [AdjudicationFinalisedDate], [Vw_AdjudicationDetails].[AdjudicationNumber] AS [AdjudicationNumber] FROM [App].[Vw_AdjudicationDetails] AS [Vw_AdjudicationDetails] 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_ApplicationDetails].[ApplicationDetailID] AS [ApplicationDetailID], [Vw_ApplicationDetails].[WorkflowInstanceID] AS [WorkflowInstanceID], [Vw_ApplicationDetails].[ApplicationNumber] AS [ApplicationNumber], [Vw_ApplicationDetails].[RequestType] AS [RequestType], [Vw_ApplicationDetails].[IncludeRenewalType] AS [IncludeRenewalType], [Vw_ApplicationDetails].[Cost] AS [Cost], [Vw_ApplicationDetails].[SurnameOrCompanyName] AS [SurnameOrCompanyName], [Vw_ApplicationDetails].[FirstNames] AS [FirstNames], [Vw_ApplicationDetails].[TradeName] AS [TradeName], [Vw_ApplicationDetails].[Member] AS [Member], [Vw_ApplicationDetails].[VerifiedMemberID] AS [VerifiedMemberID], [Vw_ApplicationDetails].[IDNumberOrBusinessRegistrationNo] AS [IDNumberOrBusinessRegistrationNo], [Vw_ApplicationDetails].[ApplicationRequestTypeID] AS [ApplicationRequestTypeID], [Vw_ApplicationDetails].[SourceApplicationID] AS [SourceApplicationID], [Vw_ApplicationDetails].[IsNewRouteRequired] AS [IsNewRouteRequired], [Vw_ApplicationDetails].[IsExceptionRequired] AS [IsExceptionRequired], [Vw_ApplicationDetails].[IsUpliftmentRequired] AS [IsUpliftmentRequired], [Vw_ApplicationDetails].[IsAdjustmentRequired] AS [IsAdjustmentRequired], [Vw_ApplicationDetails].[IsCancellationRequired] AS [IsCancellationRequired], [Vw_ApplicationDetails].[GazetteNumber] AS [GazetteNumber], [Vw_ApplicationDetails].[GazetteDetailID] AS [GazetteDetailID], [Vw_ApplicationDetails].[LicenceCount] AS [LicenceCount], [Vw_ApplicationDetails].[ApplicationDescription] AS [ApplicationDescription], [Vw_ApplicationDetails].[IsRenewal] AS [IsRenewal], [Vw_ApplicationDetails].[AssociationName] AS [AssociationName], [Vw_ApplicationDetails].[TaxNumber] AS [TaxNumber], [Vw_ApplicationDetails].[ProxyName] AS [ProxyName], [Vw_ApplicationDetails].[IsCancelled] AS [IsCancelled], [Vw_ApplicationDetails].[AdjudicationComment] AS [AdjudicationComment], [Vw_ApplicationDetails].[TelCell] AS [TelCell], [Vw_ApplicationDetails].[TelPhone] AS [TelPhone], [Vw_ApplicationDetails].[OfficeLocationID] AS [OfficeLocationID], [Vw_ApplicationDetails].[DivisionTypeID] AS [DivisionTypeID], [Vw_ApplicationDetails].[ProvinceID] AS [ProvinceID], [Vw_ApplicationDetails].[RegionID] AS [RegionID], [Vw_ApplicationDetails].[AdjudicationOfficeLocationID] AS [AdjudicationOfficeLocationID], [Vw_ApplicationDetails].[ExistingLicenceHolder] AS [ExistingLicenceHolder], [Vw_ApplicationDetails].[ExistingLicenceHolderID] AS [ExistingLicenceHolderID], [Vw_ApplicationDetails].[Region] AS [Region], [Vw_ApplicationDetails].[WorkflowStatus] AS [WorkflowStatus], [Vw_ApplicationDetails].[IsAdjudicationBypassed] AS [IsAdjudicationBypassed], [Vw_ApplicationDetails].[IsGazettingBypassed] AS [IsGazettingBypassed], [Vw_ApplicationDetails].[IsAssessorApprovalRequired] AS [IsAssessorApprovalRequired], [Vw_ApplicationDetails].[IsSeniorManagerApprovalRequired] AS [IsSeniorManagerApprovalRequired], [Vw_ApplicationDetails].[HasNewRoute] AS [HasNewRoute], [Vw_ApplicationDetails].[IsAutoVerificationRequired] AS [IsAutoVerificationRequired], [Vw_ApplicationDetails].[IsLtpsConversion] AS [IsLtpsConversion], [Vw_ApplicationDetails].[ProxyIDNumber] AS [ProxyIDNumber], [Vw_ApplicationDetails].[AdjudicationCount] AS [AdjudicationCount], [Vw_ApplicationDetails].[PhysicalAddress] AS [PhysicalAddress], [Vw_ApplicationDetails].[PhysicalAddressCode] AS [PhysicalAddressCode], [Vw_ApplicationDetails].[PostalAddress] AS [PostalAddress], [Vw_ApplicationDetails].[PostalAddressCode] AS [PostalAddressCode], [Vw_ApplicationDetails].[VerifiedAssociationID] AS [VerifiedAssociationID], [Vw_ApplicationDetails].[IsGazettingRequired] AS [IsGazettingRequired], [Vw_ApplicationDetails].[IsInspectionRequired] AS [IsInspectionRequired], [Vw_ApplicationDetails].[IsReferralRequired] AS [IsReferralRequired], [Vw_ApplicationDetails].[IsBusAndContract] AS [IsBusAndContract], [Vw_ApplicationDetails].[AdjudicationDetailID] AS [AdjudicationDetailID], [Vw_ApplicationDetails].[IsApplicantIndividual] AS [IsApplicantIndividual], [Vw_ApplicationDetails].[ApplicationIsObjected] AS [ApplicationIsObjected], [Vw_ApplicationDetails].[OnlyExistingRoutesOnLicense] AS [OnlyExistingRoutesOnLicense], [Vw_ApplicationDetails].[IsAllowedNewLicence] AS [IsAllowedNewLicence], [Vw_ApplicationDetails].[ForceGazetting] AS [ForceGazetting], [Vw_ApplicationDetails].[AdjudicationTypeID] AS [AdjudicationTypeID], [Vw_ApplicationDetails].[ApplicationStatusID] AS [ApplicationStatusID], [Vw_ApplicationDetails].[ApplicationSubStatusID] AS [ApplicationSubStatusID], [Vw_ApplicationDetails].[ApplicationCannoutBeAutoAssignedForAdjudication] AS [ApplicationCannoutBeAutoAssignedForAdjudication] FROM [App].[Vw_ApplicationDetails] AS [Vw_ApplicationDetails] SELECT [Vw_ApplicationDetails_InProgress].[ApplicationDetailID] AS [ApplicationDetailID], [Vw_ApplicationDetails_InProgress].[WorkflowInstanceID] AS [WorkflowInstanceID], [Vw_ApplicationDetails_InProgress].[ApplicationNumber] AS [ApplicationNumber], [Vw_ApplicationDetails_InProgress].[RequestType] AS [RequestType], [Vw_ApplicationDetails_InProgress].[IncludeRenewalType] AS [IncludeRenewalType], [Vw_ApplicationDetails_InProgress].[Cost] AS [Cost], [Vw_ApplicationDetails_InProgress].[SurnameOrCompanyName] AS [SurnameOrCompanyName], [Vw_ApplicationDetails_InProgress].[FirstNames] AS [FirstNames], [Vw_ApplicationDetails_InProgress].[TradeName] AS [TradeName], [Vw_ApplicationDetails_InProgress].[Member] AS [Member], [Vw_ApplicationDetails_InProgress].[VerifiedMemberID] AS [VerifiedMemberID], [Vw_ApplicationDetails_InProgress].[IDNumberOrBusinessRegistrationNo] AS [IDNumberOrBusinessRegistrationNo], [Vw_ApplicationDetails_InProgress].[ApplicationRequestTypeID] AS [ApplicationRequestTypeID], [Vw_ApplicationDetails_InProgress].[SourceApplicationID] AS [SourceApplicationID], [Vw_ApplicationDetails_InProgress].[IsNewRouteRequired] AS [IsNewRouteRequired], [Vw_ApplicationDetails_InProgress].[IsExceptionRequired] AS [IsExceptionRequired], [Vw_ApplicationDetails_InProgress].[IsUpliftmentRequired] AS [IsUpliftmentRequired], [Vw_ApplicationDetails_InProgress].[IsAdjustmentRequired] AS [IsAdjustmentRequired], [Vw_ApplicationDetails_InProgress].[IsCancellationRequired] AS [IsCancellationRequired], [Vw_ApplicationDetails_InProgress].[GazetteNumber] AS [GazetteNumber], [Vw_ApplicationDetails_InProgress].[GazetteDetailID] AS [GazetteDetailID], [Vw_ApplicationDetails_InProgress].[LicenceCount] AS [LicenceCount], [Vw_ApplicationDetails_InProgress].[ApplicationDescription] AS [ApplicationDescription], [Vw_ApplicationDetails_InProgress].[IsRenewal] AS [IsRenewal], [Vw_ApplicationDetails_InProgress].[AssociationName] AS [AssociationName], [Vw_ApplicationDetails_InProgress].[TaxNumber] AS [TaxNumber], [Vw_ApplicationDetails_InProgress].[ProxyName] AS [ProxyName], [Vw_ApplicationDetails_InProgress].[IsCancelled] AS [IsCancelled], [Vw_ApplicationDetails_InProgress].[AdjudicationComment] AS [AdjudicationComment], [Vw_ApplicationDetails_InProgress].[TelCell] AS [TelCell], [Vw_ApplicationDetails_InProgress].[TelPhone] AS [TelPhone], [Vw_ApplicationDetails_InProgress].[OfficeLocationID] AS [OfficeLocationID], [Vw_ApplicationDetails_InProgress].[DivisionTypeID] AS [DivisionTypeID], [Vw_ApplicationDetails_InProgress].[ProvinceID] AS [ProvinceID], [Vw_ApplicationDetails_InProgress].[RegionID] AS [RegionID], [Vw_ApplicationDetails_InProgress].[AdjudicationOfficeLocationID] AS [AdjudicationOfficeLocationID], [Vw_ApplicationDetails_InProgress].[ExistingLicenceHolder] AS [ExistingLicenceHolder], [Vw_ApplicationDetails_InProgress].[ExistingLicenceHolderID] AS [ExistingLicenceHolderID], [Vw_ApplicationDetails_InProgress].[Region] AS [Region], [Vw_ApplicationDetails_InProgress].[WorkflowStatus] AS [WorkflowStatus], [Vw_ApplicationDetails_InProgress].[IsAdjudicationBypassed] AS [IsAdjudicationBypassed], [Vw_ApplicationDetails_InProgress].[IsGazettingBypassed] AS [IsGazettingBypassed], [Vw_ApplicationDetails_InProgress].[IsAssessorApprovalRequired] AS [IsAssessorApprovalRequired], [Vw_ApplicationDetails_InProgress].[IsSeniorManagerApprovalRequired] AS [IsSeniorManagerApprovalRequired], [Vw_ApplicationDetails_InProgress].[HasNewRoute] AS [HasNewRoute], [Vw_ApplicationDetails_InProgress].[IsAutoVerificationRequired] AS [IsAutoVerificationRequired], [Vw_ApplicationDetails_InProgress].[IsLtpsConversion] AS [IsLtpsConversion], [Vw_ApplicationDetails_InProgress].[ProxyIDNumber] AS [ProxyIDNumber], [Vw_ApplicationDetails_InProgress].[AdjudicationCount] AS [AdjudicationCount], [Vw_ApplicationDetails_InProgress].[PhysicalAddress] AS [PhysicalAddress], [Vw_ApplicationDetails_InProgress].[PhysicalAddressCode] AS [PhysicalAddressCode], [Vw_ApplicationDetails_InProgress].[PostalAddress] AS [PostalAddress], [Vw_ApplicationDetails_InProgress].[PostalAddressCode] AS [PostalAddressCode], [Vw_ApplicationDetails_InProgress].[VerifiedAssociationID] AS [VerifiedAssociationID], [Vw_ApplicationDetails_InProgress].[IsGazettingRequired] AS [IsGazettingRequired], [Vw_ApplicationDetails_InProgress].[IsInspectionRequired] AS [IsInspectionRequired], [Vw_ApplicationDetails_InProgress].[IsReferralRequired] AS [IsReferralRequired], [Vw_ApplicationDetails_InProgress].[IsBusAndContract] AS [IsBusAndContract], [Vw_ApplicationDetails_InProgress].[AdjudicationDetailID] AS [AdjudicationDetailID], [Vw_ApplicationDetails_InProgress].[IsApplicantIndividual] AS [IsApplicantIndividual], [Vw_ApplicationDetails_InProgress].[ApplicationIsObjected] AS [ApplicationIsObjected], [Vw_ApplicationDetails_InProgress].[OnlyExistingRoutesOnLicense] AS [OnlyExistingRoutesOnLicense], [Vw_ApplicationDetails_InProgress].[IsAllowedNewLicence] AS [IsAllowedNewLicence], [Vw_ApplicationDetails_InProgress].[ForceGazetting] AS [ForceGazetting], [Vw_ApplicationDetails_InProgress].[AdjudicationTypeID] AS [AdjudicationTypeID], [Vw_ApplicationDetails_InProgress].[ApplicationStatusID] AS [ApplicationStatusID], [Vw_ApplicationDetails_InProgress].[ApplicationSubStatusID] AS [ApplicationSubStatusID], [Vw_ApplicationDetails_InProgress].[ApplicationCannoutBeAutoAssignedForAdjudication] AS [ApplicationCannoutBeAutoAssignedForAdjudication] FROM [App].[Vw_ApplicationDetails_InProgress] AS [Vw_ApplicationDetails_InProgress] SELECT [Vw_ApplicationDetails_Light].[ApplicationDetailID] AS [ApplicationDetailID], [Vw_ApplicationDetails_Light].[WorkflowInstanceID] AS [WorkflowInstanceID], [Vw_ApplicationDetails_Light].[WorkflowTemplateID] AS [WorkflowTemplateID], [Vw_ApplicationDetails_Light].[DivisionTypeID] AS [DivisionTypeID], [Vw_ApplicationDetails_Light].[ProvinceID] AS [ProvinceID], [Vw_ApplicationDetails_Light].[RegionID] AS [RegionID], [Vw_ApplicationDetails_Light].[LicenceCount] AS [LicenceCount], [Vw_ApplicationDetails_Light].[ApplicationNumber] AS [ApplicationNumber], [Vw_ApplicationDetails_Light].[ApplicationRequestTypeID] AS [ApplicationRequestTypeID], [Vw_ApplicationDetails_Light].[RequestType] AS [RequestType], [Vw_ApplicationDetails_Light].[IncludeRenewalType] AS [IncludeRenewalType], [Vw_ApplicationDetails_Light].[Member] AS [Member], [Vw_ApplicationDetails_Light].[TelCell] AS [TelCell], [Vw_ApplicationDetails_Light].[Email] AS [Email], [Vw_ApplicationDetails_Light].[IsCancelled] AS [IsCancelled], [Vw_ApplicationDetails_Light].[ApplicationDescription] AS [ApplicationDescription], [Vw_ApplicationDetails_Light].[IDNumberOrBusinessRegistrationNo] AS [IDNumberOrBusinessRegistrationNo], [Vw_ApplicationDetails_Light].[AdjudicationCount] AS [AdjudicationCount], [Vw_ApplicationDetails_Light].[AdjudicationOfficeLocationID] AS [AdjudicationOfficeLocationID], [Vw_ApplicationDetails_Light].[IsReceiptRequired] AS [IsReceiptRequired], [Vw_ApplicationDetails_Light].[IsAdjudicationRequired] AS [IsAdjudicationRequired], [Vw_ApplicationDetails_Light].[IsAdjustmentRequired] AS [IsAdjustmentRequired], [Vw_ApplicationDetails_Light].[IsGazettingRequired] AS [IsGazettingRequired], [Vw_ApplicationDetails_Light].[IsGazettingBypassed] AS [IsGazettingBypassed], [Vw_ApplicationDetails_Light].[IsInspectionRequired] AS [IsInspectionRequired], [Vw_ApplicationDetails_Light].[IsReferralRequired] AS [IsReferralRequired], [Vw_ApplicationDetails_Light].[IsBusAndContract] AS [IsBusAndContract], [Vw_ApplicationDetails_Light].[GazetteDetailID] AS [GazetteDetailID], [Vw_ApplicationDetails_Light].[IsLtpsConversion] AS [IsLtpsConversion], [Vw_ApplicationDetails_Light].[IsAdjudicationBypassed] AS [IsAdjudicationBypassed], [Vw_ApplicationDetails_Light].[WorkflowInstanceReference] AS [WorkflowInstanceReference], [Vw_ApplicationDetails_Light].[ApplicationStatusID] AS [ApplicationStatusID], [Vw_ApplicationDetails_Light].[ApplicationSubStatusID] AS [ApplicationSubStatusID], [Vw_ApplicationDetails_Light].[LiveryDocumentID] AS [LiveryDocumentID], [Vw_ApplicationDetails_Light].[IsNewRouteRequired] AS [IsNewRouteRequired], [Vw_ApplicationDetails_Light].[IsAssessorApprovalRequired] AS [IsAssessorApprovalRequired], [Vw_ApplicationDetails_Light].[IsSeniorManagerApprovalRequired] AS [IsSeniorManagerApprovalRequired], [Vw_ApplicationDetails_Light].[AdjudicationDetailID] AS [AdjudicationDetailID], [Vw_ApplicationDetails_Light].[LastAdjudicationDecisionID] AS [LastAdjudicationDecisionID], [Vw_ApplicationDetails_Light].[TotalVehicles] AS [TotalVehicles], [Vw_ApplicationDetails_Light].[IDType] AS [IDType], [Vw_ApplicationDetails_Light].[IsRenewal] AS [IsRenewal], [Vw_ApplicationDetails_Light].[IsFinalisationTasksRequired] AS [IsFinalisationTasksRequired], [Vw_ApplicationDetails_Light].[ProxyIDNumber] AS [ProxyIDNumber], [Vw_ApplicationDetails_Light].[IsApplicantIndividual] AS [IsApplicantIndividual], [Vw_ApplicationDetails_Light].[ApplicationIsObjected] AS [ApplicationIsObjected], [Vw_ApplicationDetails_Light].[OnlyExistingRoutesOnLicense] AS [OnlyExistingRoutesOnLicense], [Vw_ApplicationDetails_Light].[IsAllowedNewLicence] AS [IsAllowedNewLicence], [Vw_ApplicationDetails_Light].[ForceGazetting] AS [ForceGazetting], [Vw_ApplicationDetails_Light].[AdjudicationTypeID] AS [AdjudicationTypeID], [Vw_ApplicationDetails_Light].[PREDataReleased] AS [PREDataReleased], [Vw_ApplicationDetails_Light].[CopiedFromApplicationDetailID] AS [CopiedFromApplicationDetailID], [Vw_ApplicationDetails_Light].[RelatedTATApplicationRequestID] AS [RelatedTATApplicationRequestID], [Vw_ApplicationDetails_Light].[CreatedDate] AS [CreatedDate], [Vw_ApplicationDetails_Light].[RequiresProxy] AS [RequiresProxy], [Vw_ApplicationDetails_Light].[ApplicantProvinceID] AS [ApplicantProvinceID], [Vw_ApplicationDetails_Light].[ApplicantRegionID] AS [ApplicantRegionID], [Vw_ApplicationDetails_Light].[ServiceTypeID] AS [ServiceTypeID], [Vw_ApplicationDetails_Light].[ServiceTypeDescription] AS [ServiceTypeDescription], [Vw_ApplicationDetails_Light].[GazetteNoticeExpiryDate] AS [GazetteNoticeExpiryDate] FROM [App].[Vw_ApplicationDetails_Light] AS [Vw_ApplicationDetails_Light] SELECT [Vw_ApplicationDetails_Receipts].[ApplicationDetailID] AS [ApplicationDetailID], [Vw_ApplicationDetails_Receipts].[WorkflowInstanceID] AS [WorkflowInstanceID], [Vw_ApplicationDetails_Receipts].[OfficeLocationID] AS [OfficeLocationID], [Vw_ApplicationDetails_Receipts].[ApplicationNumber] AS [ApplicationNumber], [Vw_ApplicationDetails_Receipts].[RequestType] AS [RequestType], [Vw_ApplicationDetails_Receipts].[Cost] AS [Cost], [Vw_ApplicationDetails_Receipts].[Member] AS [Member], [Vw_ApplicationDetails_Receipts].[ReceiptNumber] AS [ReceiptNumber], [Vw_ApplicationDetails_Receipts].[ReceiptDetailID] AS [ReceiptDetailID], [Vw_ApplicationDetails_Receipts].[PaymentTypeID] AS [PaymentTypeID], [Vw_ApplicationDetails_Receipts].[LicenceCount] AS [LicenceCount], [Vw_ApplicationDetails_Receipts].[ChassisNumber] AS [ChassisNumber], [Vw_ApplicationDetails_Receipts].[EngineNumber] AS [EngineNumber], [Vw_ApplicationDetails_Receipts].[VehicleRegNumber] AS [VehicleRegNumber], [Vw_ApplicationDetails_Receipts].[IsCancelled] AS [IsCancelled], [Vw_ApplicationDetails_Receipts].[ApplicationDescription] AS [ApplicationDescription], [Vw_ApplicationDetails_Receipts].[IDNumberOrBusinessRegistrationNo] AS [IDNumberOrBusinessRegistrationNo], [Vw_ApplicationDetails_Receipts].[AdjudicationCount] AS [AdjudicationCount] FROM [App].[Vw_ApplicationDetails_Receipts] AS [Vw_ApplicationDetails_Receipts] SELECT [Vw_GazetteApplications].[ApplicationDetailID] AS [ApplicationDetailID], [Vw_GazetteApplications].[ApplicationNumber] AS [ApplicationNumber], [Vw_GazetteApplications].[Description] AS [Description], [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_LicenceCancelDetails].[LicenceCancelDetailID] AS [LicenceCancelDetailID], [Vw_LicenceCancelDetails].[OfficeLocationID] AS [OfficeLocationID], [Vw_LicenceCancelDetails].[WorkflowInstanceID] AS [WorkflowInstanceID], [Vw_LicenceCancelDetails].[LicenceCancelNumber] AS [LicenceCancelNumber], [Vw_LicenceCancelDetails].[OperatingLicenceNumber] AS [OperatingLicenceNumber], [Vw_LicenceCancelDetails].[DateOfIssue] AS [DateOfIssue], [Vw_LicenceCancelDetails].[DateOfExpiry] AS [DateOfExpiry], [Vw_LicenceCancelDetails].[NameOnLicence] AS [NameOnLicence], [Vw_LicenceCancelDetails].[CertificateNumber] AS [CertificateNumber], [Vw_LicenceCancelDetails].[LicenceStatus] AS [LicenceStatus] FROM [App].[Vw_LicenceCancelDetails] AS [Vw_LicenceCancelDetails] SELECT [Vw_LicenceIssueDetails].[LicenceIssueDetailID] AS [LicenceIssueDetailID], [Vw_LicenceIssueDetails].[ApplicationDetailID] AS [ApplicationDetailID], [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], [Vw_LicenceIssueDetails].[AccreditationID] AS [AccreditationID], [Vw_LicenceIssueDetails].[OperatingLicenceNumber] AS [OperatingLicenceNumber], [Vw_LicenceIssueDetails].[DateOfIssue] AS [DateOfIssue], [Vw_LicenceIssueDetails].[AccreditationNumber] AS [AccreditationNumber], [Vw_LicenceIssueDetails].[DivisionTypeID] AS [DivisionTypeID], [Vw_LicenceIssueDetails].[ProvinceID] AS [ProvinceID], [Vw_LicenceIssueDetails].[IsDocumentVerificationRequired] AS [IsDocumentVerificationRequired] 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], [Vw_NewRouteRequestDetails].[DivisionTypeID] AS [DivisionTypeID], [Vw_NewRouteRequestDetails].[ProvinceID] AS [ProvinceID] FROM [App].[Vw_NewRouteRequestDetails] AS [Vw_NewRouteRequestDetails] 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].[ApplicationDetailID] AS [ApplicationDetailID], [Vw_ReceiptDetails].[OfficeLocationID] AS [OfficeLocationID] FROM [App].[Vw_ReceiptDetails] AS [Vw_ReceiptDetails] SELECT [Vw_ApplicationRequestTypeDivisionSetup].[ApplicationRequestTypeDivisionSetupID] AS [ApplicationRequestTypeDivisionSetupID], [Vw_ApplicationRequestTypeDivisionSetup].[ApplicationRequestTypeID] AS [ApplicationRequestTypeID], [Vw_ApplicationRequestTypeDivisionSetup].[DivisionTypeID] AS [DivisionTypeID], [Vw_ApplicationRequestTypeDivisionSetup].[ProvinceID] AS [ProvinceID], [Vw_ApplicationRequestTypeDivisionSetup].[IsAssessorApprovalRequiredRule] AS [IsAssessorApprovalRequiredRule], [Vw_ApplicationRequestTypeDivisionSetup].[IsSeniorManagerApprovalRequiredRule] AS [IsSeniorManagerApprovalRequiredRule], [Vw_ApplicationRequestTypeDivisionSetup].[IsFinalisationTasksRequiredRule] AS [IsFinalisationTasksRequiredRule], [Vw_ApplicationRequestTypeDivisionSetup].[IsInspectionRequiredRule] AS [IsInspectionRequiredRule], [Vw_ApplicationRequestTypeDivisionSetup].[IsReferralRequiredRule] AS [IsReferralRequiredRule], [Vw_ApplicationRequestTypeDivisionSetup].[IsAdjudicationRequiredRule] AS [IsAdjudicationRequiredRule], [Vw_ApplicationRequestTypeDivisionSetup].[AdjudicationTypeRule] AS [AdjudicationTypeRule], [Vw_ApplicationRequestTypeDivisionSetup].[IsGazettingRequiredRule] AS [IsGazettingRequiredRule], [Vw_ApplicationRequestTypeDivisionSetup].[GazetteTypeRule] AS [GazetteTypeRule], [Vw_ApplicationRequestTypeDivisionSetup].[IsNew] AS [IsNew], [Vw_ApplicationRequestTypeDivisionSetup].[ApplicationRequestType] AS [ApplicationRequestType], [Vw_ApplicationRequestTypeDivisionSetup].[DivisionType] AS [DivisionType], [Vw_ApplicationRequestTypeDivisionSetup].[Province] AS [Province], [Vw_ApplicationRequestTypeDivisionSetup].[WorkflowReference] AS [WorkflowReference], [Vw_ApplicationRequestTypeDivisionSetup].[WorkflowStatus] AS [WorkflowStatus] FROM [Md].[Vw_ApplicationRequestTypeDivisionSetup] AS [Vw_ApplicationRequestTypeDivisionSetup] SELECT [Vw_ApplicationRequestTypeDocumentSetup].[ApplicationRequestTypeDocumentID] AS [ApplicationRequestTypeDocumentID], [Vw_ApplicationRequestTypeDocumentSetup].[DivisionTypeID] AS [DivisionTypeID], [Vw_ApplicationRequestTypeDocumentSetup].[ProvinceID] AS [ProvinceID], [Vw_ApplicationRequestTypeDocumentSetup].[ApplicationRequestTypeID] AS [ApplicationRequestTypeID], [Vw_ApplicationRequestTypeDocumentSetup].[DocumentTypeID] AS [DocumentTypeID], [Vw_ApplicationRequestTypeDocumentSetup].[WorkflowTemplateID] AS [WorkflowTemplateID], [Vw_ApplicationRequestTypeDocumentSetup].[IsCancelled] AS [IsCancelled], [Vw_ApplicationRequestTypeDocumentSetup].[IsAvailableForUpload] AS [IsAvailableForUpload], [Vw_ApplicationRequestTypeDocumentSetup].[IsMandatory] AS [IsMandatory], [Vw_ApplicationRequestTypeDocumentSetup].[IsNew] AS [IsNew], [Vw_ApplicationRequestTypeDocumentSetup].[ApplicationRequestType] AS [ApplicationRequestType], [Vw_ApplicationRequestTypeDocumentSetup].[DivisionType] AS [DivisionType], [Vw_ApplicationRequestTypeDocumentSetup].[Province] AS [Province], [Vw_ApplicationRequestTypeDocumentSetup].[WorkflowReference] AS [WorkflowReference], [Vw_ApplicationRequestTypeDocumentSetup].[WorkflowStatus] AS [WorkflowStatus] FROM [Md].[Vw_ApplicationRequestTypeDocumentSetup] AS [Vw_ApplicationRequestTypeDocumentSetup] SELECT [Vw_DivisionTypeAnnexureMappings].[DivisionTypeAnnexureMappingID] AS [DivisionTypeAnnexureMappingID], [Vw_DivisionTypeAnnexureMappings].[DivisionTypeID] AS [DivisionTypeID], [Vw_DivisionTypeAnnexureMappings].[ProvinceID] AS [ProvinceID], [Vw_DivisionTypeAnnexureMappings].[ServiceTypeID] AS [ServiceTypeID], [Vw_DivisionTypeAnnexureMappings].[VehicleTypeID] AS [VehicleTypeID], [Vw_DivisionTypeAnnexureMappings].[AnnexureDocumentID] AS [AnnexureDocumentID], [Vw_DivisionTypeAnnexureMappings].[IsCancelled] AS [IsCancelled], [Vw_DivisionTypeAnnexureMappings].[DivisionType] AS [DivisionType], [Vw_DivisionTypeAnnexureMappings].[Province] AS [Province], [Vw_DivisionTypeAnnexureMappings].[ServiceType] AS [ServiceType], [Vw_DivisionTypeAnnexureMappings].[VehicleType] AS [VehicleType] FROM [Md].[Vw_DivisionTypeAnnexureMappings] AS [Vw_DivisionTypeAnnexureMappings] SELECT [Vw_LicencingBoards].[LicencingBoardID] AS [LicencingBoardID], [Vw_LicencingBoards].[Description] AS [Description], [Vw_LicencingBoards].[ProvinceID] AS [ProvinceID], [Vw_LicencingBoards].[Province] AS [Province], [Vw_LicencingBoards].[IsCancelled] AS [IsCancelled], [Vw_LicencingBoards].[IsNew] AS [IsNew], [Vw_LicencingBoards].[WorkflowReference] AS [WorkflowReference], [Vw_LicencingBoards].[WorkflowStatus] AS [WorkflowStatus] FROM [Md].[Vw_LicencingBoards] AS [Vw_LicencingBoards] SELECT [Vw_OfficeLocations].[OfficeLocationDescription] AS [OfficeLocationDescription], [Vw_OfficeLocations].[OfficeLocationID] AS [OfficeLocationID], [Vw_OfficeLocations].[LocationName] AS [LocationName], [Vw_OfficeLocations].[LocationAddress] AS [LocationAddress], [Vw_OfficeLocations].[DivisionTypeID] AS [DivisionTypeID], [Vw_OfficeLocations].[ProvinceID] AS [ProvinceID], [Vw_OfficeLocations].[RegionID] AS [RegionID], [Vw_OfficeLocations].[LicencingBoardID] AS [LicencingBoardID], [Vw_OfficeLocations].[PaymentClerkUserID] AS [PaymentClerkUserID], [Vw_OfficeLocations].[AssessorUserID] AS [AssessorUserID], [Vw_OfficeLocations].[SeniorManagerApproverUserID] AS [SeniorManagerApproverUserID], [Vw_OfficeLocations].[InspectionCapturerUserID] AS [InspectionCapturerUserID], [Vw_OfficeLocations].[ReferralCapturerUserID] AS [ReferralCapturerUserID], [Vw_OfficeLocations].[HandlesGazetting] AS [HandlesGazetting], [Vw_OfficeLocations].[GazetteNumberPrefix] AS [GazetteNumberPrefix], [Vw_OfficeLocations].[AdjudicationOfficerUserID] AS [AdjudicationOfficerUserID], [Vw_OfficeLocations].[AdjudicationSecrataryUserID] AS [AdjudicationSecrataryUserID], [Vw_OfficeLocations].[AdjudicationAgendaEmails] AS [AdjudicationAgendaEmails], [Vw_OfficeLocations].[AdjudicationHearingQuorumCount] AS [AdjudicationHearingQuorumCount], [Vw_OfficeLocations].[AdjudicationMeetingQuorumCount] AS [AdjudicationMeetingQuorumCount], [Vw_OfficeLocations].[MaxAdjudicationAutoApplicationCount] AS [MaxAdjudicationAutoApplicationCount], [Vw_OfficeLocations].[DocumentStoreLocationID] AS [DocumentStoreLocationID], [Vw_OfficeLocations].[PaymentTypeID] AS [PaymentTypeID], [Vw_OfficeLocations].[BusinessRuleBypassApproverUserID] AS [BusinessRuleBypassApproverUserID], [Vw_OfficeLocations].[AdjudicationContactName] AS [AdjudicationContactName], [Vw_OfficeLocations].[AdjudicationContactTelPhone] AS [AdjudicationContactTelPhone], [Vw_OfficeLocations].[AdjudicationContactEmail] AS [AdjudicationContactEmail], [Vw_OfficeLocations].[RouteCapturerUserID] AS [RouteCapturerUserID], [Vw_OfficeLocations].[RouteApproverUserID] AS [RouteApproverUserID], [Vw_OfficeLocations].[WorkflowReference] AS [WorkflowReference], [Vw_OfficeLocations].[WorkflowStatus] AS [WorkflowStatus] FROM [Md].[Vw_OfficeLocations] AS [Vw_OfficeLocations] SELECT [Vw_OfficeLocationSetup].[OfficeLocationID] AS [OfficeLocationID], [Vw_OfficeLocationSetup].[LocationName] AS [LocationName], [Vw_OfficeLocationSetup].[LocationAddress] AS [LocationAddress], [Vw_OfficeLocationSetup].[DivisionTypeID] AS [DivisionTypeID], [Vw_OfficeLocationSetup].[ProvinceID] AS [ProvinceID], [Vw_OfficeLocationSetup].[RegionID] AS [RegionID], [Vw_OfficeLocationSetup].[LicencingBoardID] AS [LicencingBoardID], [Vw_OfficeLocationSetup].[PaymentClerkUserID] AS [PaymentClerkUserID], [Vw_OfficeLocationSetup].[AssessorUserID] AS [AssessorUserID], [Vw_OfficeLocationSetup].[SeniorManagerApproverUserID] AS [SeniorManagerApproverUserID], [Vw_OfficeLocationSetup].[InspectionCapturerUserID] AS [InspectionCapturerUserID], [Vw_OfficeLocationSetup].[ReferralCapturerUserID] AS [ReferralCapturerUserID], [Vw_OfficeLocationSetup].[HandlesGazetting] AS [HandlesGazetting], [Vw_OfficeLocationSetup].[GazetteNumberPrefix] AS [GazetteNumberPrefix], [Vw_OfficeLocationSetup].[AdjudicationOfficerUserID] AS [AdjudicationOfficerUserID], [Vw_OfficeLocationSetup].[AdjudicationSecrataryUserID] AS [AdjudicationSecrataryUserID], [Vw_OfficeLocationSetup].[AdjudicationAgendaEmails] AS [AdjudicationAgendaEmails], [Vw_OfficeLocationSetup].[AdjudicationHearingQuorumCount] AS [AdjudicationHearingQuorumCount], [Vw_OfficeLocationSetup].[AdjudicationMeetingQuorumCount] AS [AdjudicationMeetingQuorumCount], [Vw_OfficeLocationSetup].[MaxAdjudicationAutoApplicationCount] AS [MaxAdjudicationAutoApplicationCount], [Vw_OfficeLocationSetup].[DocumentStoreLocationID] AS [DocumentStoreLocationID], [Vw_OfficeLocationSetup].[PaymentTypeID] AS [PaymentTypeID], [Vw_OfficeLocationSetup].[BusinessRuleBypassApproverUserID] AS [BusinessRuleBypassApproverUserID], [Vw_OfficeLocationSetup].[AdjudicationContactName] AS [AdjudicationContactName], [Vw_OfficeLocationSetup].[AdjudicationContactTelPhone] AS [AdjudicationContactTelPhone], [Vw_OfficeLocationSetup].[AdjudicationContactEmail] AS [AdjudicationContactEmail], [Vw_OfficeLocationSetup].[RouteCapturerUserID] AS [RouteCapturerUserID], [Vw_OfficeLocationSetup].[RouteApproverUserID] AS [RouteApproverUserID], [Vw_OfficeLocationSetup].[DivisionType] AS [DivisionType], [Vw_OfficeLocationSetup].[Province] AS [Province], [Vw_OfficeLocationSetup].[WorkflowReference] AS [WorkflowReference], [Vw_OfficeLocationSetup].[WorkflowStatus] AS [WorkflowStatus] FROM [Md].[Vw_OfficeLocationSetup] AS [Vw_OfficeLocationSetup] SELECT [Vw_VehicleMakes].[VehicleMakeID] AS [VehicleMakeID], [Vw_VehicleMakes].[Description] AS [Description], [Vw_VehicleMakes].[IsCancelled] AS [IsCancelled], [Vw_VehicleMakes].[IsNew] AS [IsNew], [Vw_VehicleMakes].[WorkflowReference] AS [WorkflowReference], [Vw_VehicleMakes].[WorkflowStatus] AS [WorkflowStatus] FROM [Md].[Vw_VehicleMakes] AS [Vw_VehicleMakes] SELECT [Vw_VehicleModels].[VehicleModelID] AS [VehicleModelID], [Vw_VehicleModels].[VehicleMakeID] AS [VehicleMakeID], [Vw_VehicleModels].[VehicleMake] AS [VehicleMake], [Vw_VehicleModels].[Description] AS [Description], [Vw_VehicleModels].[SeatedCapacityExcludingDriver] AS [SeatedCapacityExcludingDriver], [Vw_VehicleModels].[StandingCapacity] AS [StandingCapacity], [Vw_VehicleModels].[IsCancelled] AS [IsCancelled], [Vw_VehicleModels].[GrossWeight] AS [GrossWeight], [Vw_VehicleModels].[TareWeight] AS [TareWeight], [Vw_VehicleModels].[VehicleTypeID] AS [VehicleTypeID], [Vw_VehicleModels].[VehicleType] AS [VehicleType], [Vw_VehicleModels].[CarryingCapacityID] AS [CarryingCapacityID], [Vw_VehicleModels].[CarryingCapacity] AS [CarryingCapacity], [Vw_VehicleModels].[IsValidModel] AS [IsValidModel], [Vw_VehicleModels].[WorkflowReference] AS [WorkflowReference], [Vw_VehicleModels].[WorkflowStatus] AS [WorkflowStatus] FROM [Md].[Vw_VehicleModels] AS [Vw_VehicleModels] SELECT [Vw_Settings].[SettingName] AS [SettingName], [Vw_Settings].[SettingDescription] AS [SettingDescription], [Vw_Settings].[SettingValue] AS [SettingValue], [Vw_Settings].[SettingDetail] AS [SettingDetail] FROM [System].[Vw_Settings] AS [Vw_Settings] SELECT [Vw_Associations].[AssociationID] AS [AssociationID], [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] FROM [Verified].[Vw_Associations] AS [Vw_Associations] SELECT [Vw_OperatingLicenceDetails].[LicenceID] AS [LicenceID], [Vw_OperatingLicenceDetails].[ApplicationDetailID] AS [ApplicationDetailID], [Vw_OperatingLicenceDetails].[AssociationName] AS [AssociationName], [Vw_OperatingLicenceDetails].[AccreditationNumber] AS [AccreditationNumber], [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], [Vw_OperatingLicenceDetails].[DivisionTypeID] AS [DivisionTypeID] 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].[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].[Model] AS [Model], [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]