public void CheckColumnVersionInfo() { List <ExpectedColumn> expectedColumns = new List <ExpectedColumn> { ExpectedColumn.CreateInt("Version", 1, false), ExpectedColumn.CreateDate("Date", 2, false) }; _fixture.SchemaTests.AssertTableColumnsExist("dbo", "VersionInfo", expectedColumns, true); }
public void CheckColumnCollectionDetails() { List <ExpectedColumn> expectedColumns = new List <ExpectedColumn> { ExpectedColumn.CreateInt("UKPRN", 1, false), ExpectedColumn.CreateVarChar("Collection", 2, false, 3), ExpectedColumn.CreateVarChar("Year", 3, false, 4), ExpectedColumn.CreateDate("FilePreparationDate", 4, true) }; _fixture.SchemaTests.AssertTableColumnsExist("Valid", "CollectionDetails", expectedColumns, true); }
public void CheckColumnEmploymentStatusMonitoring() { List <ExpectedColumn> expectedColumns = new List <ExpectedColumn> { ExpectedColumn.CreateInt("UKPRN", 1, false), ExpectedColumn.CreateVarChar("LearnRefNumber", 2, false, 12), ExpectedColumn.CreateDate("DateEmpStatApp", 3, false), ExpectedColumn.CreateVarChar("ESMType", 4, false, 3), ExpectedColumn.CreateInt("ESMCode", 5, true) }; _fixture.SchemaTests.AssertTableColumnsExist("Valid", "EmploymentStatusMonitoring", expectedColumns, true); }
public void CheckColumnLearnerEmploymentStatus() { List <ExpectedColumn> expectedColumns = new List <ExpectedColumn> { ExpectedColumn.CreateInt("UKPRN", 1, false), ExpectedColumn.CreateVarChar("LearnRefNumber", 2, false, 12), ExpectedColumn.CreateInt("EmpStat", 3, false), ExpectedColumn.CreateDate("DateEmpStatApp", 4, false), ExpectedColumn.CreateInt("EmpId", 5, true), ExpectedColumn.CreateVarChar("AgreeId", 6, true, 6) }; _fixture.SchemaTests.AssertTableColumnsExist("Valid", "LearnerEmploymentStatus", expectedColumns, true); }
public void CheckColumnDPOutcome() { List <ExpectedColumn> expectedColumns = new List <ExpectedColumn> { ExpectedColumn.CreateInt("UKPRN", 1, false), ExpectedColumn.CreateVarChar("LearnRefNumber", 2, false, 12), ExpectedColumn.CreateVarChar("OutType", 3, false, 3), ExpectedColumn.CreateInt("OutCode", 4, false), ExpectedColumn.CreateDate("OutStartDate", 5, false), ExpectedColumn.CreateDate("OutEndDate", 6, true), ExpectedColumn.CreateDate("OutCollDate", 7, false) }; _fixture.SchemaTests.AssertTableColumnsExist("Valid", "DPOutcome", expectedColumns, true); }
public void CheckColumnAppFinRecord() { List <ExpectedColumn> expectedColumns = new List <ExpectedColumn> { ExpectedColumn.CreateInt("UKPRN", -1, false), ExpectedColumn.CreateVarChar("LearnRefNumber", 2, false, 12), ExpectedColumn.CreateInt("AimSeqNumber", 3, false), ExpectedColumn.CreateVarChar("AFinType", 4, false), ExpectedColumn.CreateInt("AFinCode", 5, false), ExpectedColumn.CreateDate("AFinDate", 6, false), ExpectedColumn.CreateInt("AFinAmount", 7, false) }; _fixture.SchemaTests.AssertTableColumnsExist("Valid", "AppFinRecord", expectedColumns, true); }
public void CheckColumnSourceFile() { List <ExpectedColumn> expectedColumns = new List <ExpectedColumn> { ExpectedColumn.CreateInt("UKPRN", 1, false), ExpectedColumn.CreateVarChar("SourceFileName", 2, false, 50), ExpectedColumn.CreateDate("FilePreparationDate", 3, true), ExpectedColumn.CreateVarChar("SoftwareSupplier", 4, true, 40), ExpectedColumn.CreateVarChar("SoftwarePackage", 5, true, 30), ExpectedColumn.CreateVarChar("Release", 6, true, 20), ExpectedColumn.CreateVarChar("SerialNo", 7, true, 2), ExpectedColumn.CreateDateTime("DateTime", 8, true) }; _fixture.SchemaTests.AssertTableColumnsExist("Valid", "SourceFile", expectedColumns, true); }
public void CheckColumnLearningDeliveryWorkPlacement() { List <ExpectedColumn> expectedColumns = new List <ExpectedColumn> { ExpectedColumn.CreateInt("UKPRN", 1, false), ExpectedColumn.CreateVarChar("LearnRefNumber", 2, false, 12), ExpectedColumn.CreateInt("AimSeqNumber", 3, false), ExpectedColumn.CreateDate("WorkPlaceStartDate", 4, false), ExpectedColumn.CreateDate("WorkPlaceEndDate", 5, true), ExpectedColumn.CreateInt("WorkPlaceHours", 6, true), ExpectedColumn.CreateInt("WorkPlaceMode", 7, false), ExpectedColumn.CreateInt("WorkPlaceEmpId", 8, true) }; _fixture.SchemaTests.AssertTableColumnsExist("Valid", "LearningDeliveryWorkPlacement", expectedColumns, true); }
public void CheckColumnLearningDeliveryFAM() { List <ExpectedColumn> expectedColumns = new List <ExpectedColumn> { ExpectedColumn.CreateInt("LearningDeliveryFAM_Id", 1, false), ExpectedColumn.CreateInt("UKPRN", 2, false), ExpectedColumn.CreateVarChar("LearnRefNumber", 3, false, 12), ExpectedColumn.CreateInt("AimSeqNumber", 4, false), ExpectedColumn.CreateVarChar("LearnDelFAMType", 5, false, 3), ExpectedColumn.CreateVarChar("LearnDelFAMCode", 6, false, 5), ExpectedColumn.CreateDate("LearnDelFAMDateFrom", 7, true), ExpectedColumn.CreateDate("LearnDelFAMDateTo", 8, true) }; _fixture.SchemaTests.AssertTableColumnsExist("Valid", "LearningDeliveryFAM", expectedColumns, true); }
public void CheckColumnDPOutcome() { List <ExpectedColumn> expectedColumns = new List <ExpectedColumn> { ExpectedColumn.CreateInt("DPOutcome_Id", 1, false), ExpectedColumn.CreateInt("UKPRN", 2, false), ExpectedColumn.CreateInt("LearnerDestinationandProgression_Id", 3, true), ExpectedColumn.CreateVarChar("LearnRefNumber", 4, true, 100), ExpectedColumn.CreateVarChar("OutType", 5, true, 100), ExpectedColumn.CreateBigInt("OutCode", 6, true), ExpectedColumn.CreateDate("OutStartDate", 7, true), ExpectedColumn.CreateDate("OutEndDate", 8, true), ExpectedColumn.CreateDate("OutCollDate", 9, true) }; _fixture.SchemaTests.AssertTableColumnsExist("Invalid", "DPOutcome", expectedColumns, true); }
public void CheckColumnAppFinRecord() { List <ExpectedColumn> expectedColumns = new List <ExpectedColumn> { ExpectedColumn.CreateInt("AppFinRecord_Id", 1, false), ExpectedColumn.CreateInt("UKPRN", 2, false), ExpectedColumn.CreateInt("LearningDelivery_Id", 3, true), ExpectedColumn.CreateVarChar("LearnRefNumber", 4, true, 100), ExpectedColumn.CreateBigInt("AimSeqNumber", 5, true), ExpectedColumn.CreateVarChar("AFinType", 6, true, 100), ExpectedColumn.CreateBigInt("AFinCode", 7, true), ExpectedColumn.CreateDate("AFinDate", 8, true), ExpectedColumn.CreateBigInt("AFinAmount", 9, true) }; _fixture.SchemaTests.AssertTableColumnsExist("Invalid", "AppFinRecord", expectedColumns, true); }
public void CheckColumnLearningDelivery() { List <ExpectedColumn> expectedColumns = new List <ExpectedColumn> { ExpectedColumn.CreateInt("LearningDelivery_Id", 1, false), ExpectedColumn.CreateInt("Learner_Id", 2, true), ExpectedColumn.CreateInt("UKPRN", 3, false), ExpectedColumn.CreateVarChar("LearnRefNumber", 4, true, 100), ExpectedColumn.CreateVarChar("LearnAimRef", 5, true, 1000), ExpectedColumn.CreateBigInt("AimType", 6, true), ExpectedColumn.CreateBigInt("AimSeqNumber", 7, true), ExpectedColumn.CreateDate("LearnStartDate", 8, true), ExpectedColumn.CreateDate("OrigLearnStartDate", 9, true), ExpectedColumn.CreateDate("LearnPlanEndDate", 10, true), ExpectedColumn.CreateBigInt("FundModel", 11, true), ExpectedColumn.CreateBigInt("ProgType", 12, true), ExpectedColumn.CreateBigInt("FworkCode", 13, true), ExpectedColumn.CreateBigInt("PwayCode", 14, true), ExpectedColumn.CreateBigInt("StdCode", 15, true), ExpectedColumn.CreateBigInt("PartnerUKPRN", 16, true), ExpectedColumn.CreateVarChar("DelLocPostCode", 17, true, 1000), ExpectedColumn.CreateBigInt("AddHours", 18, true), ExpectedColumn.CreateBigInt("PriorLearnFundAdj", 19, true), ExpectedColumn.CreateBigInt("OtherFundAdj", 20, true), ExpectedColumn.CreateVarChar("ConRefNumber", 21, true, 1000), ExpectedColumn.CreateVarChar("EPAOrgID", 22, true, 1000), ExpectedColumn.CreateBigInt("EmpOutcome", 23, true), ExpectedColumn.CreateBigInt("CompStatus", 24, true), ExpectedColumn.CreateDate("LearnActEndDate", 25, true), ExpectedColumn.CreateBigInt("WithdrawReason", 26, true), ExpectedColumn.CreateBigInt("Outcome", 27, true), ExpectedColumn.CreateDate("AchDate", 28, true), ExpectedColumn.CreateVarChar("OutGrade", 29, true, 1000), ExpectedColumn.CreateVarChar("SWSupAimId", 30, true, 1000), ExpectedColumn.CreateBigInt("PHours", 31, true), ExpectedColumn.CreateVarChar("LSDPostcode", 32, true, 1000), }; _fixture.SchemaTests.AssertTableColumnsExist("Invalid", "LearningDelivery", expectedColumns, true); }
public void CheckColumnLearner() { List <ExpectedColumn> expectedColumns = new List <ExpectedColumn> { ExpectedColumn.CreateInt("Learner_Id", 1, false), ExpectedColumn.CreateVarChar("LearnRefNumber", 2, true, 100), ExpectedColumn.CreateInt("UKPRN", 3, false), ExpectedColumn.CreateVarChar("PrevLearnRefNumber", 4, true, 1000), ExpectedColumn.CreateBigInt("PrevUKPRN", 5, true), ExpectedColumn.CreateBigInt("PMUKPRN", 6, true), ExpectedColumn.CreateBigInt("ULN", 7, true), ExpectedColumn.CreateVarChar("FamilyName", 8, true, 1000), ExpectedColumn.CreateVarChar("GivenNames", 9, true, 1000), ExpectedColumn.CreateDate("DateOfBirth", 10, true), ExpectedColumn.CreateBigInt("Ethnicity", 11, true), ExpectedColumn.CreateVarChar("Sex", 12, true, 1000), ExpectedColumn.CreateBigInt("LLDDHealthProb", 13, true), ExpectedColumn.CreateVarChar("NINumber", 14, true, 1000), ExpectedColumn.CreateBigInt("PriorAttain", 15, true), ExpectedColumn.CreateBigInt("Accom", 16, true), ExpectedColumn.CreateBigInt("ALSCost", 17, true), ExpectedColumn.CreateBigInt("PlanLearnHours", 18, true), ExpectedColumn.CreateBigInt("PlanEEPHours", 19, true), ExpectedColumn.CreateVarChar("MathGrade", 20, true, 1000), ExpectedColumn.CreateVarChar("EngGrade", 21, true, 1000), ExpectedColumn.CreateVarChar("PostcodePrior", 22, true, 1000), ExpectedColumn.CreateVarChar("Postcode", 23, true, 1000), ExpectedColumn.CreateVarChar("AddLine1", 24, true, 1000), ExpectedColumn.CreateVarChar("AddLine2", 25, true, 1000), ExpectedColumn.CreateVarChar("AddLine3", 26, true, 1000), ExpectedColumn.CreateVarChar("AddLine4", 27, true, 1000), ExpectedColumn.CreateVarChar("TelNo", 28, true, 1000), ExpectedColumn.CreateVarChar("Email", 29, true, 1000), ExpectedColumn.CreateVarChar("CampId", 30, true, 1000), ExpectedColumn.CreateBigInt("OTJHours", 31, true) }; _fixture.SchemaTests.AssertTableColumnsExist("Invalid", "Learner", expectedColumns, true); }
public void CheckColumnSupplementaryDataModel() { var index = 0; var expectedColumns = new List <ExpectedColumn> { ExpectedColumn.CreateInt("SupplementaryDataId", ++index, false), ExpectedColumn.CreateVarChar("ConRefNumber", ++index, false, 20), ExpectedColumn.CreateVarChar("DeliverableCode", ++index, false, 10), ExpectedColumn.CreateInt("CalendarYear", ++index, false), ExpectedColumn.CreateInt("CalendarMonth", ++index, false), ExpectedColumn.CreateVarChar("CostType", ++index, false, 20), ExpectedColumn.CreateVarChar("ReferenceType", ++index, false, 20), ExpectedColumn.CreateVarChar("Reference", ++index, false, 100), ExpectedColumn.CreateBigInt("ULN", ++index, true), ExpectedColumn.CreateVarChar("ProviderSpecifiedReference", ++index, true, 200), ExpectedColumn.CreateDecimal("Value", ++index, true, 8, 2), ExpectedColumn.CreateVarChar("LearnAimRef", ++index, true, 8), ExpectedColumn.CreateDate("SupplementaryDataPanelDate", ++index, true), ExpectedColumn.CreateInt("SourceFileId", ++index, false) }; _fixture.SchemaTests.AssertTableColumnsExist("dbo", "SupplementaryData", expectedColumns, true); }