-- MySQL Administrator dump 1.4 -- -- ------------------------------------------------------ -- Server version 5.0.18-nt /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -- -- Create schema dbd_test_reports -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ dbd_test_reports2; USE dbd_test_reports2; -- -- Table structure for table `dbd_test_reports`.`tblcaseproductcomission` -- DROP TABLE IF EXISTS `tblcaseproductcomission`; CREATE TABLE `tblcaseproductcomission` ( `CaseID` varchar(20) NOT NULL default '', `Income` double(19,2) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `dbd_test_reports`.`tblcaseproductcomission` -- /*!40000 ALTER TABLE `tblcaseproductcomission` DISABLE KEYS */; INSERT INTO `tblcaseproductcomission` (`CaseID`,`Income`) VALUES ('Bast3108060000020406',4094.00), ('Gate3108060000020404',500.00), ('Jone3108060000020405',3462.17), ('Kuma3108060000020402',500.00), ('McDe3108060000020403',600.00); /*!40000 ALTER TABLE `tblcaseproductcomission` ENABLE KEYS */; -- -- Table structure for table `dbd_test_reports`.`tblenquiries` -- DROP TABLE IF EXISTS `tblenquiries`; CREATE TABLE `tblenquiries` ( `CaseID` varchar(20) NOT NULL default '', `AllocatedTeam` int(11) NOT NULL default '0', `AllocatedAdmin` int(11) NOT NULL default '0', `AllocatedSalesConsultant` int(11) NOT NULL default '0', `AllocatedManager` int(11) NOT NULL default '0', `App1OccupationType` int(11) default NULL, `App2OccupationType` int(11) default NULL, `IntroducerID` int(11) default NULL, `Notes` text, `CreatedBy` int(11) default NULL, `CreatedOn` datetime default NULL, `UpdatedBy` int(11) default NULL, `UpdatedOn` datetime default NULL, `LinkCaseID` varchar(20) default NULL, `ComplaintYN` char(1) NOT NULL default 'N', `IntroducerTypeID` int(11) default NULL, `CommRuleType` char(1) default NULL, `AdditionalInformation` text, `EnquiryFG` char(3) NOT NULL default '', `IntroducerContactID` int(11) default '0', `TeamComp` varchar(50) default NULL, `TeamMember` varchar(50) default NULL, `Regulated` char(1) default NULL, `DateChecked` date default NULL, `CheckedBy` int(11) default NULL, `ThirdPartySystemID` varchar(30) default NULL, `GradeNotes` text, `Grade` int(11) default NULL, `TenancyEndDate` date default NULL, `IsPropPresentlyLet` char(1) default NULL, `WillPropBeLetToFamMem` char(1) default NULL, `ConnDetails` varchar(150) default NULL, `lSem1Marks` decimal(10,2) default NULL, `WillPropBeLetToFamMem_IfYes` decimal(10,2) default NULL, `ConnWithBDS` char(1) default NULL, `WllYouResideInProp` char(1) default NULL, `sp_comp_name` varchar(50) default NULL, `LtdCompName` varchar(255) default NULL, `ExpectedRentalInc` decimal(10,2) default NULL, `sp_fsa_number` varchar(50) default NULL, `CurrentRentPaid` decimal(10,2) default NULL, `DateOfIncorp` date default NULL, `ResiCommenceDate` date default NULL, `Dip_Product` varchar(50) default NULL, `AreUAppRepresentative` char(1) default NULL, `NetworkDetails` varchar(150) default NULL, `AreUDirectlyAuthorised` char(1) default NULL, `KFIDocsFaxNo` char(1) default NULL, `IsThisRegulatedLoan` char(1) default NULL, `WasThisAdvisedSale` char(1) default NULL, `AreAnyFeeToBeCharged` char(1) default NULL, `LiableForMaintOrChildCare` char(1) default NULL, `LiableForMaintOrChildCareMonthlyAmt` int(11) default NULL, `NewLessMortPayments` decimal(10,2) default NULL, `LessMonthlyLoanPayments` decimal(10,2) default NULL, `LessMonthCreditCardPay` decimal(10,2) default NULL, `LessMaintenancePay` decimal(10,2) default NULL, `IsExistingTenantsInOccupation` char(1) default NULL, `TypeOfMortgage` char(1) default NULL, `LevelOfService` char(1) default NULL, `AbleToMaintainMortPmt` char(1) default NULL, `MortTerms` char(1) default NULL, `MortRepaidOnAnInterest` char(1) default NULL, `Authorisation` int(11) default NULL, `CustomerContract` char(1) default NULL, `SuppliedKFIToApp` char(1) default NULL, `RegularFinancialCommitmentYN` char(1) default NULL, `PackagerName` varchar(100) default NULL, `PackagerCompanyName` varchar(100) default NULL, `PackagerAddress1` varchar(50) default NULL, `PackagerAddress2` varchar(50) default NULL, `PackagerAddress3` varchar(50) default NULL, `PackagerAddress4` varchar(50) default NULL, `PackagerAddress5` varchar(50) default NULL, `PackagerPostCode` varchar(20) default NULL, `PackagerTelephone` varchar(20) default NULL, `PackagerFax` varchar(20) default NULL, `PackagerMobile` varchar(20) default NULL, `PackagerEmail` varchar(100) default NULL, `PackagerIntroducerNo` varchar(20) default NULL, `PackagerOfficeContactName` varchar(100) default NULL, `PackagerMemberType` int(11) default NULL, `PackagerNetworkName` varchar(50) default NULL, `PackagerFSANumber` varchar(20) default NULL, `PackagerCCLNumber` varchar(50) default NULL, `PackagerDetOfficeContactName` varchar(20) default NULL, `PackagerDetails` text, `RepaidAtCompletion` char(1) default NULL, `RepaidAtCompletionNotes` text, `SaleArrangeBeforOctober` char(1) default NULL, `Archive` int(1) default NULL, `SolicitorID` int(11) default NULL, `SolicitorContactID` int(11) default NULL, `IntroChargeFeeYN` char(1) default NULL, `IntroChargeFee` decimal(10,2) default NULL, `IVASatisfyYN` char(1) default NULL, `IVAAdvise` varchar(255) default NULL, `AdverseArrearMonth` varchar(50) default NULL, `SecuredBorrowingYN` char(1) default NULL, `SolicitorByBdsFG` char(1) default NULL, `QuotationForPricePanelYN` char(1) default NULL, `DoYouHaveIVA` char(1) default NULL, `ArrearTwoCharge` varchar(50) default NULL, `NewExistPropertyType` int(1) default NULL, `LoanType` int(1) default NULL, `ServicesReqd` int(1) default NULL, `DeclerationAccept` int(1) default NULL, `NetworkID` int(11) default NULL, `Principal` varchar(20) default NULL, `FirmSelling` char(1) default NULL, `FirmSellingDetails` text, `TenantsOccupyProperty` char(1) default NULL, `TenantsOccupyPropertyDet` varchar(50) default NULL, `SpecityTenantsOccupyProperty` int(11) default NULL, `PackagerCompnayNo` varchar(20) default NULL, `PackagerDataProtNo` varchar(20) default NULL, `AdverseCredit` char(1) default NULL, `AnyPersonalGuarantees` char(1) default NULL, `AnyPersonalGuaranteesDet` text, `EvidanceOfIncome` varchar(20) default NULL, `IsLimitedComp` char(1) default NULL, `IsIntroAdviceApplicant` char(1) default NULL, `IsIntroNonAuthorise` char(1) default NULL, `IsIntroAuthNetwork` char(1) default NULL, `OtherIntroRemunerate` varchar(100) default NULL, `IsAssociatedRecords` char(1) default NULL, `DeclarationAgreedYN` char(1) default NULL, `Agreement` char(1) default NULL, `LtdCompRegNumber` varchar(50) default NULL, `AssetYN` char(1) default NULL, `NoOfExpInSector` int(3) default NULL, `SourceOfIncome` varchar(100) default NULL, `AdverseCreditDetails` text, `CreditHistoryNotes` text, `LoanNotes` text, `PersonalDetailsNotes` text, `EmploymentNotes` text, `Interviwer` varchar(255) default NULL, `ConductCreditSearch` char(1) default NULL, `EnquiryDate` datetime default NULL, `InterviewDate` datetime default NULL, `BestContactTime` varchar(255) default NULL, `BestContactNumber` varchar(255) default NULL, `ApplicantInformation` varchar(30) default NULL, `ApplicantInformationOther` varchar(100) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `dbd_test_reports`.`tblenquiries` -- /*!40000 ALTER TABLE `tblenquiries` DISABLE KEYS */; INSERT INTO `tblenquiries` (`CaseID`,`AllocatedTeam`,`AllocatedAdmin`,`AllocatedSalesConsultant`,`AllocatedManager`,`App1OccupationType`,`App2OccupationType`,`IntroducerID`,`Notes`,`CreatedBy`,`CreatedOn`,`UpdatedBy`,`UpdatedOn`,`LinkCaseID`,`ComplaintYN`,`IntroducerTypeID`,`CommRuleType`,`AdditionalInformation`,`EnquiryFG`,`IntroducerContactID`,`TeamComp`,`TeamMember`,`Regulated`,`DateChecked`,`CheckedBy`,`ThirdPartySystemID`,`GradeNotes`,`Grade`,`TenancyEndDate`,`IsPropPresentlyLet`,`WillPropBeLetToFamMem`,`ConnDetails`,`lSem1Marks`,`WillPropBeLetToFamMem_IfYes`,`ConnWithBDS`,`WllYouResideInProp`,`sp_comp_name`,`LtdCompName`,`ExpectedRentalInc`,`sp_fsa_number`,`CurrentRentPaid`,`DateOfIncorp`,`ResiCommenceDate`,`Dip_Product`,`AreUAppRepresentative`,`NetworkDetails`,`AreUDirectlyAuthorised`,`KFIDocsFaxNo`,`IsThisRegulatedLoan`,`WasThisAdvisedSale`,`AreAnyFeeToBeCharged`,`LiableForMaintOrChildCare`,`LiableForMaintOrChildCareMonthlyAmt`,`NewLessMortPayments`,`LessMonthlyLoanPayments`,`LessMonthCreditCardPay`,`LessMaintenancePay`,`IsExistingTenantsInOccupation`,`TypeOfMortgage`,`LevelOfService`,`AbleToMaintainMortPmt`,`MortTerms`,`MortRepaidOnAnInterest`,`Authorisation`,`CustomerContract`,`SuppliedKFIToApp`,`RegularFinancialCommitmentYN`,`PackagerName`,`PackagerCompanyName`,`PackagerAddress1`,`PackagerAddress2`,`PackagerAddress3`,`PackagerAddress4`,`PackagerAddress5`,`PackagerPostCode`,`PackagerTelephone`,`PackagerFax`,`PackagerMobile`,`PackagerEmail`,`PackagerIntroducerNo`,`PackagerOfficeContactName`,`PackagerMemberType`,`PackagerNetworkName`,`PackagerFSANumber`,`PackagerCCLNumber`,`PackagerDetOfficeContactName`,`PackagerDetails`,`RepaidAtCompletion`,`RepaidAtCompletionNotes`,`SaleArrangeBeforOctober`,`Archive`,`SolicitorID`,`SolicitorContactID`,`IntroChargeFeeYN`,`IntroChargeFee`,`IVASatisfyYN`,`IVAAdvise`,`AdverseArrearMonth`,`SecuredBorrowingYN`,`SolicitorByBdsFG`,`QuotationForPricePanelYN`,`DoYouHaveIVA`,`ArrearTwoCharge`,`NewExistPropertyType`,`LoanType`,`ServicesReqd`,`DeclerationAccept`,`NetworkID`,`Principal`,`FirmSelling`,`FirmSellingDetails`,`TenantsOccupyProperty`,`TenantsOccupyPropertyDet`,`SpecityTenantsOccupyProperty`,`PackagerCompnayNo`,`PackagerDataProtNo`,`AdverseCredit`,`AnyPersonalGuarantees`,`AnyPersonalGuaranteesDet`,`EvidanceOfIncome`,`IsLimitedComp`,`IsIntroAdviceApplicant`,`IsIntroNonAuthorise`,`IsIntroAuthNetwork`,`OtherIntroRemunerate`,`IsAssociatedRecords`,`DeclarationAgreedYN`,`Agreement`,`LtdCompRegNumber`,`AssetYN`,`NoOfExpInSector`,`SourceOfIncome`,`AdverseCreditDetails`,`CreditHistoryNotes`,`LoanNotes`,`PersonalDetailsNotes`,`EmploymentNotes`,`Interviwer`,`ConductCreditSearch`,`EnquiryDate`,`InterviewDate`,`BestContactTime`,`BestContactNumber`,`ApplicantInformation`,`ApplicantInformationOther`) VALUES ('Kuma3108060000020402',1,0,133,0,1,-1,17,'',1,'2006-08-31 00:00:00',0,NULL,NULL,'N',1,'Y',NULL,'Q',0,'#1#2#10#13#14#15#17#18','#135#133#158#110#115#102#138#103','1',NULL,NULL,'12345',NULL,NULL,'0000-00-00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.00',NULL,NULL,NULL,'0000-00-00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); INSERT INTO `tblenquiries` (`CaseID`,`AllocatedTeam`,`AllocatedAdmin`,`AllocatedSalesConsultant`,`AllocatedManager`,`App1OccupationType`,`App2OccupationType`,`IntroducerID`,`Notes`,`CreatedBy`,`CreatedOn`,`UpdatedBy`,`UpdatedOn`,`LinkCaseID`,`ComplaintYN`,`IntroducerTypeID`,`CommRuleType`,`AdditionalInformation`,`EnquiryFG`,`IntroducerContactID`,`TeamComp`,`TeamMember`,`Regulated`,`DateChecked`,`CheckedBy`,`ThirdPartySystemID`,`GradeNotes`,`Grade`,`TenancyEndDate`,`IsPropPresentlyLet`,`WillPropBeLetToFamMem`,`ConnDetails`,`lSem1Marks`,`WillPropBeLetToFamMem_IfYes`,`ConnWithBDS`,`WllYouResideInProp`,`sp_comp_name`,`LtdCompName`,`ExpectedRentalInc`,`sp_fsa_number`,`CurrentRentPaid`,`DateOfIncorp`,`ResiCommenceDate`,`Dip_Product`,`AreUAppRepresentative`,`NetworkDetails`,`AreUDirectlyAuthorised`,`KFIDocsFaxNo`,`IsThisRegulatedLoan`,`WasThisAdvisedSale`,`AreAnyFeeToBeCharged`,`LiableForMaintOrChildCare`,`LiableForMaintOrChildCareMonthlyAmt`,`NewLessMortPayments`,`LessMonthlyLoanPayments`,`LessMonthCreditCardPay`,`LessMaintenancePay`,`IsExistingTenantsInOccupation`,`TypeOfMortgage`,`LevelOfService`,`AbleToMaintainMortPmt`,`MortTerms`,`MortRepaidOnAnInterest`,`Authorisation`,`CustomerContract`,`SuppliedKFIToApp`,`RegularFinancialCommitmentYN`,`PackagerName`,`PackagerCompanyName`,`PackagerAddress1`,`PackagerAddress2`,`PackagerAddress3`,`PackagerAddress4`,`PackagerAddress5`,`PackagerPostCode`,`PackagerTelephone`,`PackagerFax`,`PackagerMobile`,`PackagerEmail`,`PackagerIntroducerNo`,`PackagerOfficeContactName`,`PackagerMemberType`,`PackagerNetworkName`,`PackagerFSANumber`,`PackagerCCLNumber`,`PackagerDetOfficeContactName`,`PackagerDetails`,`RepaidAtCompletion`,`RepaidAtCompletionNotes`,`SaleArrangeBeforOctober`,`Archive`,`SolicitorID`,`SolicitorContactID`,`IntroChargeFeeYN`,`IntroChargeFee`,`IVASatisfyYN`,`IVAAdvise`,`AdverseArrearMonth`,`SecuredBorrowingYN`,`SolicitorByBdsFG`,`QuotationForPricePanelYN`,`DoYouHaveIVA`,`ArrearTwoCharge`,`NewExistPropertyType`,`LoanType`,`ServicesReqd`,`DeclerationAccept`,`NetworkID`,`Principal`,`FirmSelling`,`FirmSellingDetails`,`TenantsOccupyProperty`,`TenantsOccupyPropertyDet`,`SpecityTenantsOccupyProperty`,`PackagerCompnayNo`,`PackagerDataProtNo`,`AdverseCredit`,`AnyPersonalGuarantees`,`AnyPersonalGuaranteesDet`,`EvidanceOfIncome`,`IsLimitedComp`,`IsIntroAdviceApplicant`,`IsIntroNonAuthorise`,`IsIntroAuthNetwork`,`OtherIntroRemunerate`,`IsAssociatedRecords`,`DeclarationAgreedYN`,`Agreement`,`LtdCompRegNumber`,`AssetYN`,`NoOfExpInSector`,`SourceOfIncome`,`AdverseCreditDetails`,`CreditHistoryNotes`,`LoanNotes`,`PersonalDetailsNotes`,`EmploymentNotes`,`Interviwer`,`ConductCreditSearch`,`EnquiryDate`,`InterviewDate`,`BestContactTime`,`BestContactNumber`,`ApplicantInformation`,`ApplicantInformationOther`) VALUES ('McDe3108060000020403',1,0,133,0,1,-1,17,'',1,'2006-08-31 00:00:00',0,NULL,NULL,'N',1,'Y',NULL,'Q',0,'#1#2#10#13#14#15#17#18','#135#133#158#110#115#102#138#103','1',NULL,NULL,'123456',NULL,NULL,'0000-00-00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.00',NULL,'0.00',NULL,'0000-00-00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); INSERT INTO `tblenquiries` (`CaseID`,`AllocatedTeam`,`AllocatedAdmin`,`AllocatedSalesConsultant`,`AllocatedManager`,`App1OccupationType`,`App2OccupationType`,`IntroducerID`,`Notes`,`CreatedBy`,`CreatedOn`,`UpdatedBy`,`UpdatedOn`,`LinkCaseID`,`ComplaintYN`,`IntroducerTypeID`,`CommRuleType`,`AdditionalInformation`,`EnquiryFG`,`IntroducerContactID`,`TeamComp`,`TeamMember`,`Regulated`,`DateChecked`,`CheckedBy`,`ThirdPartySystemID`,`GradeNotes`,`Grade`,`TenancyEndDate`,`IsPropPresentlyLet`,`WillPropBeLetToFamMem`,`ConnDetails`,`lSem1Marks`,`WillPropBeLetToFamMem_IfYes`,`ConnWithBDS`,`WllYouResideInProp`,`sp_comp_name`,`LtdCompName`,`ExpectedRentalInc`,`sp_fsa_number`,`CurrentRentPaid`,`DateOfIncorp`,`ResiCommenceDate`,`Dip_Product`,`AreUAppRepresentative`,`NetworkDetails`,`AreUDirectlyAuthorised`,`KFIDocsFaxNo`,`IsThisRegulatedLoan`,`WasThisAdvisedSale`,`AreAnyFeeToBeCharged`,`LiableForMaintOrChildCare`,`LiableForMaintOrChildCareMonthlyAmt`,`NewLessMortPayments`,`LessMonthlyLoanPayments`,`LessMonthCreditCardPay`,`LessMaintenancePay`,`IsExistingTenantsInOccupation`,`TypeOfMortgage`,`LevelOfService`,`AbleToMaintainMortPmt`,`MortTerms`,`MortRepaidOnAnInterest`,`Authorisation`,`CustomerContract`,`SuppliedKFIToApp`,`RegularFinancialCommitmentYN`,`PackagerName`,`PackagerCompanyName`,`PackagerAddress1`,`PackagerAddress2`,`PackagerAddress3`,`PackagerAddress4`,`PackagerAddress5`,`PackagerPostCode`,`PackagerTelephone`,`PackagerFax`,`PackagerMobile`,`PackagerEmail`,`PackagerIntroducerNo`,`PackagerOfficeContactName`,`PackagerMemberType`,`PackagerNetworkName`,`PackagerFSANumber`,`PackagerCCLNumber`,`PackagerDetOfficeContactName`,`PackagerDetails`,`RepaidAtCompletion`,`RepaidAtCompletionNotes`,`SaleArrangeBeforOctober`,`Archive`,`SolicitorID`,`SolicitorContactID`,`IntroChargeFeeYN`,`IntroChargeFee`,`IVASatisfyYN`,`IVAAdvise`,`AdverseArrearMonth`,`SecuredBorrowingYN`,`SolicitorByBdsFG`,`QuotationForPricePanelYN`,`DoYouHaveIVA`,`ArrearTwoCharge`,`NewExistPropertyType`,`LoanType`,`ServicesReqd`,`DeclerationAccept`,`NetworkID`,`Principal`,`FirmSelling`,`FirmSellingDetails`,`TenantsOccupyProperty`,`TenantsOccupyPropertyDet`,`SpecityTenantsOccupyProperty`,`PackagerCompnayNo`,`PackagerDataProtNo`,`AdverseCredit`,`AnyPersonalGuarantees`,`AnyPersonalGuaranteesDet`,`EvidanceOfIncome`,`IsLimitedComp`,`IsIntroAdviceApplicant`,`IsIntroNonAuthorise`,`IsIntroAuthNetwork`,`OtherIntroRemunerate`,`IsAssociatedRecords`,`DeclarationAgreedYN`,`Agreement`,`LtdCompRegNumber`,`AssetYN`,`NoOfExpInSector`,`SourceOfIncome`,`AdverseCreditDetails`,`CreditHistoryNotes`,`LoanNotes`,`PersonalDetailsNotes`,`EmploymentNotes`,`Interviwer`,`ConductCreditSearch`,`EnquiryDate`,`InterviewDate`,`BestContactTime`,`BestContactNumber`,`ApplicantInformation`,`ApplicantInformationOther`) VALUES ('Gate3108060000020404',1,0,133,0,1,-1,17,'',1,'2006-08-31 00:00:00',0,NULL,NULL,'N',1,'Y',NULL,'Q',0,'#1#2#10#13#14#15#17#18','#135#133#158#110#115#102#138#103','1',NULL,NULL,'123456',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); INSERT INTO `tblenquiries` (`CaseID`,`AllocatedTeam`,`AllocatedAdmin`,`AllocatedSalesConsultant`,`AllocatedManager`,`App1OccupationType`,`App2OccupationType`,`IntroducerID`,`Notes`,`CreatedBy`,`CreatedOn`,`UpdatedBy`,`UpdatedOn`,`LinkCaseID`,`ComplaintYN`,`IntroducerTypeID`,`CommRuleType`,`AdditionalInformation`,`EnquiryFG`,`IntroducerContactID`,`TeamComp`,`TeamMember`,`Regulated`,`DateChecked`,`CheckedBy`,`ThirdPartySystemID`,`GradeNotes`,`Grade`,`TenancyEndDate`,`IsPropPresentlyLet`,`WillPropBeLetToFamMem`,`ConnDetails`,`lSem1Marks`,`WillPropBeLetToFamMem_IfYes`,`ConnWithBDS`,`WllYouResideInProp`,`sp_comp_name`,`LtdCompName`,`ExpectedRentalInc`,`sp_fsa_number`,`CurrentRentPaid`,`DateOfIncorp`,`ResiCommenceDate`,`Dip_Product`,`AreUAppRepresentative`,`NetworkDetails`,`AreUDirectlyAuthorised`,`KFIDocsFaxNo`,`IsThisRegulatedLoan`,`WasThisAdvisedSale`,`AreAnyFeeToBeCharged`,`LiableForMaintOrChildCare`,`LiableForMaintOrChildCareMonthlyAmt`,`NewLessMortPayments`,`LessMonthlyLoanPayments`,`LessMonthCreditCardPay`,`LessMaintenancePay`,`IsExistingTenantsInOccupation`,`TypeOfMortgage`,`LevelOfService`,`AbleToMaintainMortPmt`,`MortTerms`,`MortRepaidOnAnInterest`,`Authorisation`,`CustomerContract`,`SuppliedKFIToApp`,`RegularFinancialCommitmentYN`,`PackagerName`,`PackagerCompanyName`,`PackagerAddress1`,`PackagerAddress2`,`PackagerAddress3`,`PackagerAddress4`,`PackagerAddress5`,`PackagerPostCode`,`PackagerTelephone`,`PackagerFax`,`PackagerMobile`,`PackagerEmail`,`PackagerIntroducerNo`,`PackagerOfficeContactName`,`PackagerMemberType`,`PackagerNetworkName`,`PackagerFSANumber`,`PackagerCCLNumber`,`PackagerDetOfficeContactName`,`PackagerDetails`,`RepaidAtCompletion`,`RepaidAtCompletionNotes`,`SaleArrangeBeforOctober`,`Archive`,`SolicitorID`,`SolicitorContactID`,`IntroChargeFeeYN`,`IntroChargeFee`,`IVASatisfyYN`,`IVAAdvise`,`AdverseArrearMonth`,`SecuredBorrowingYN`,`SolicitorByBdsFG`,`QuotationForPricePanelYN`,`DoYouHaveIVA`,`ArrearTwoCharge`,`NewExistPropertyType`,`LoanType`,`ServicesReqd`,`DeclerationAccept`,`NetworkID`,`Principal`,`FirmSelling`,`FirmSellingDetails`,`TenantsOccupyProperty`,`TenantsOccupyPropertyDet`,`SpecityTenantsOccupyProperty`,`PackagerCompnayNo`,`PackagerDataProtNo`,`AdverseCredit`,`AnyPersonalGuarantees`,`AnyPersonalGuaranteesDet`,`EvidanceOfIncome`,`IsLimitedComp`,`IsIntroAdviceApplicant`,`IsIntroNonAuthorise`,`IsIntroAuthNetwork`,`OtherIntroRemunerate`,`IsAssociatedRecords`,`DeclarationAgreedYN`,`Agreement`,`LtdCompRegNumber`,`AssetYN`,`NoOfExpInSector`,`SourceOfIncome`,`AdverseCreditDetails`,`CreditHistoryNotes`,`LoanNotes`,`PersonalDetailsNotes`,`EmploymentNotes`,`Interviwer`,`ConductCreditSearch`,`EnquiryDate`,`InterviewDate`,`BestContactTime`,`BestContactNumber`,`ApplicantInformation`,`ApplicantInformationOther`) VALUES ('Jone3108060000020405',1,0,133,0,1,-1,17,'',1,'2006-08-31 00:00:00',0,NULL,NULL,'N',1,'Y',NULL,'Q',0,'#1#2#10#13#14#15#17#18','#135#133#158#110#115#102#138#103','1',NULL,NULL,'123456',NULL,NULL,'0000-00-00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.00',NULL,'0.00',NULL,'0000-00-00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); INSERT INTO `tblenquiries` (`CaseID`,`AllocatedTeam`,`AllocatedAdmin`,`AllocatedSalesConsultant`,`AllocatedManager`,`App1OccupationType`,`App2OccupationType`,`IntroducerID`,`Notes`,`CreatedBy`,`CreatedOn`,`UpdatedBy`,`UpdatedOn`,`LinkCaseID`,`ComplaintYN`,`IntroducerTypeID`,`CommRuleType`,`AdditionalInformation`,`EnquiryFG`,`IntroducerContactID`,`TeamComp`,`TeamMember`,`Regulated`,`DateChecked`,`CheckedBy`,`ThirdPartySystemID`,`GradeNotes`,`Grade`,`TenancyEndDate`,`IsPropPresentlyLet`,`WillPropBeLetToFamMem`,`ConnDetails`,`lSem1Marks`,`WillPropBeLetToFamMem_IfYes`,`ConnWithBDS`,`WllYouResideInProp`,`sp_comp_name`,`LtdCompName`,`ExpectedRentalInc`,`sp_fsa_number`,`CurrentRentPaid`,`DateOfIncorp`,`ResiCommenceDate`,`Dip_Product`,`AreUAppRepresentative`,`NetworkDetails`,`AreUDirectlyAuthorised`,`KFIDocsFaxNo`,`IsThisRegulatedLoan`,`WasThisAdvisedSale`,`AreAnyFeeToBeCharged`,`LiableForMaintOrChildCare`,`LiableForMaintOrChildCareMonthlyAmt`,`NewLessMortPayments`,`LessMonthlyLoanPayments`,`LessMonthCreditCardPay`,`LessMaintenancePay`,`IsExistingTenantsInOccupation`,`TypeOfMortgage`,`LevelOfService`,`AbleToMaintainMortPmt`,`MortTerms`,`MortRepaidOnAnInterest`,`Authorisation`,`CustomerContract`,`SuppliedKFIToApp`,`RegularFinancialCommitmentYN`,`PackagerName`,`PackagerCompanyName`,`PackagerAddress1`,`PackagerAddress2`,`PackagerAddress3`,`PackagerAddress4`,`PackagerAddress5`,`PackagerPostCode`,`PackagerTelephone`,`PackagerFax`,`PackagerMobile`,`PackagerEmail`,`PackagerIntroducerNo`,`PackagerOfficeContactName`,`PackagerMemberType`,`PackagerNetworkName`,`PackagerFSANumber`,`PackagerCCLNumber`,`PackagerDetOfficeContactName`,`PackagerDetails`,`RepaidAtCompletion`,`RepaidAtCompletionNotes`,`SaleArrangeBeforOctober`,`Archive`,`SolicitorID`,`SolicitorContactID`,`IntroChargeFeeYN`,`IntroChargeFee`,`IVASatisfyYN`,`IVAAdvise`,`AdverseArrearMonth`,`SecuredBorrowingYN`,`SolicitorByBdsFG`,`QuotationForPricePanelYN`,`DoYouHaveIVA`,`ArrearTwoCharge`,`NewExistPropertyType`,`LoanType`,`ServicesReqd`,`DeclerationAccept`,`NetworkID`,`Principal`,`FirmSelling`,`FirmSellingDetails`,`TenantsOccupyProperty`,`TenantsOccupyPropertyDet`,`SpecityTenantsOccupyProperty`,`PackagerCompnayNo`,`PackagerDataProtNo`,`AdverseCredit`,`AnyPersonalGuarantees`,`AnyPersonalGuaranteesDet`,`EvidanceOfIncome`,`IsLimitedComp`,`IsIntroAdviceApplicant`,`IsIntroNonAuthorise`,`IsIntroAuthNetwork`,`OtherIntroRemunerate`,`IsAssociatedRecords`,`DeclarationAgreedYN`,`Agreement`,`LtdCompRegNumber`,`AssetYN`,`NoOfExpInSector`,`SourceOfIncome`,`AdverseCreditDetails`,`CreditHistoryNotes`,`LoanNotes`,`PersonalDetailsNotes`,`EmploymentNotes`,`Interviwer`,`ConductCreditSearch`,`EnquiryDate`,`InterviewDate`,`BestContactTime`,`BestContactNumber`,`ApplicantInformation`,`ApplicantInformationOther`) VALUES ('Bast3108060000020406',1,0,133,0,1,-1,17,'',1,'2006-08-31 00:00:00',1,'2006-09-04 10:47:10',NULL,'N',1,'Y',NULL,'Q',0,'#1#2#10#13#14#15#17#18','#135#133#158#110#115#102#138#103','1',NULL,NULL,'12345',NULL,NULL,'0000-00-00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0.00',NULL,'0.00',NULL,'0000-00-00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `tblenquiries` ENABLE KEYS */; -- -- Procedure `dbd_test_reports`.`sp_test` -- DROP PROCEDURE IF EXISTS `sp_test`; DELIMITER $$ CREATE PROCEDURE `sp_test`(pcaseid INT) BEGIN SET @sql = "DROP TEMPORARY TABLE IF EXISTS tmpOrders"; PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; SET @sql = "CREATE TEMPORARY TABLE tmpOrders AS SELECT CaseID, 100 AS Income FROM tblCaseProductComission GROUP BY CaseID "; PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; SELECT CaseID ,Income FROM ( SELECT e.CaseID AS CaseID ,COALESCE(prof.Income,0) AS Income FROM tblEnquiries e LEFT JOIN tmpOrders prof ON e.CaseID = prof.CaseID WHERE e.CreatedOn > '2006-08-01') AS Final; END $$ DELIMITER ; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;