public void CheckColumnSupplementaryDataModel()
{
var expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("SupplementaryDataId", 1, false),
ExpectedColumn.CreateVarChar("ConRefNumber", 2, false, 20),
ExpectedColumn.CreateVarChar("DeliverableCode", 3, false, 10),
ExpectedColumn.CreateInt("CalendarYear", 4, false),
ExpectedColumn.CreateInt("CalendarMonth", 5, false),
ExpectedColumn.CreateVarChar("CostType", 6, false, 20),
ExpectedColumn.CreateVarChar("StaffName", 7, true, 100),
ExpectedColumn.CreateVarChar("ReferenceType", 8, false, 20),
ExpectedColumn.CreateVarChar("Reference", 9, false, 100),
ExpectedColumn.CreateBigInt("ULN", 10, true),
ExpectedColumn.CreateVarChar("ProviderSpecifiedReference", 11, true, 200),
ExpectedColumn.CreateDecimal("Value", 12, true, 8, 2),
ExpectedColumn.CreateDecimal("HourlyRate", 13, true, 8, 2),
ExpectedColumn.CreateDecimal("TotalHoursWorked", 14, true, 8, 2),
ExpectedColumn.CreateDecimal("ProjectHours", 15, true, 8, 2),
ExpectedColumn.CreateDecimal("OrgHours", 16, true, 8, 2),
ExpectedColumn.CreateInt("SourceFileId", 17, false)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "SupplementaryData", expectedColumns, true);
}
public void CheckColumnLearnerDestinationandProgression()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("UKPRN", 1, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 2, false, 12),
ExpectedColumn.CreateBigInt("ULN", 3, false)
};
_fixture.SchemaTests.AssertTableColumnsExist("Valid", "LearnerDestinationandProgression", expectedColumns, true);
}
public void CheckColumnProcessingData()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateBigInt("Id", 1, false),
ExpectedColumn.CreateInt("UKPRN", 2, false),
ExpectedColumn.CreateBigInt("FileDetailsID", 3, false),
ExpectedColumn.CreateNvarChar("ProcessingStep", 4, false, 100),
ExpectedColumn.CreateNvarChar("ExecutionTime", 5, false, 20)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "ProcessingData", expectedColumns, true);
}
public void CheckColumnLLDDandHealthProblem()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("LLDDandHealthProblem_Id", 1, false),
ExpectedColumn.CreateInt("Learner_Id", 2, true),
ExpectedColumn.CreateInt("UKPRN", 3, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 4, true, 100),
ExpectedColumn.CreateBigInt("LLDDCat", 5, true),
ExpectedColumn.CreateBigInt("PrimaryLLDD", 6, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("Invalid", "LLDDandHealthProblem", expectedColumns, true);
}
public void CheckColumnLearnerHEFinancialSupport()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("LearnerHEFinancialSupport_Id", 1, false),
ExpectedColumn.CreateInt("LearnerHE_Id", 2, true),
ExpectedColumn.CreateInt("UKPRN", 3, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 4, true, 100),
ExpectedColumn.CreateBigInt("FINTYPE", 5, true),
ExpectedColumn.CreateBigInt("FINAMOUNT", 6, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("Invalid", "LearnerHEFinancialSupport", expectedColumns, true);
}
public void CheckColumnLearnerHE()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("LearnerHE_Id", 1, false),
ExpectedColumn.CreateInt("Learner_Id", 2, true),
ExpectedColumn.CreateInt("UKPRN", 3, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 4, true, 100),
ExpectedColumn.CreateVarChar("UCASPERID", 5, true, 1000),
ExpectedColumn.CreateBigInt("TTACCOM", 6, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("Invalid", "LearnerHE", expectedColumns, true);
}
public void CheckColumnContactPreference()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("ContactPreference_Id", 1, false),
ExpectedColumn.CreateInt("Learner_Id", 2, true),
ExpectedColumn.CreateInt("UKPRN", 3, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 4, true, 100),
ExpectedColumn.CreateVarChar("ContPrefType", 5, true, 100),
ExpectedColumn.CreateBigInt("ContPrefCode", 6, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("Invalid", "ContactPreference", expectedColumns, true);
}
public void CheckColumnProviderSpecDeliveryMonitoring()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("ProviderSpecDeliveryMonitoring_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("ProvSpecDelMonOccur", 6, true, 100),
ExpectedColumn.CreateVarChar("ProvSpecDelMon", 7, true, 1000)
};
_fixture.SchemaTests.AssertTableColumnsExist("Invalid", "ProviderSpecDeliveryMonitoring", expectedColumns, true);
}
public void CheckColumnEmploymentStatusMonitoring()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("EmploymentStatusMonitoring_Id", 1, false),
ExpectedColumn.CreateInt("LearnerEmploymentStatus_Id", 2, true),
ExpectedColumn.CreateInt("UKPRN", 3, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 4, true, 100),
ExpectedColumn.CreateDate("DateEmpStatApp", 5, true),
ExpectedColumn.CreateVarChar("ESMType", 6, true, 100),
ExpectedColumn.CreateBigInt("ESMCode", 7, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("Invalid", "EmploymentStatusMonitoring", expectedColumns, true);
}
public void CheckColumn()
{
ExpectedColumn[] expectedColumns =
{
ExpectedColumn.CreateBigInt("ID", 1, false),
ExpectedColumn.CreateBigInt("JobId", 2, false),
ExpectedColumn.CreateDateTime("DateTimeUtc", 3, false),
ExpectedColumn.CreateNvarChar("Filename", 4, true),
ExpectedColumn.CreateNvarChar("Source", 5, true),
ExpectedColumn.CreateNvarChar("UserId", 6, false),
ExpectedColumn.CreateInt("Event", 7, false),
ExpectedColumn.CreateNvarChar("ExtraInfo", 8, true),
ExpectedColumn.CreateNvarChar("UkPrn", 9, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "Audit", 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 CheckColumnLearningDeliveryFAM()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("LearningDeliveryFAM_Id", 1, false),
ExpectedColumn.CreateInt("LearningDelivery_Id", 2, true),
ExpectedColumn.CreateInt("UKPRN", 3, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 4, true, 100),
ExpectedColumn.CreateBigInt("AimSeqNumber", 5, true),
ExpectedColumn.CreateVarChar("LearnDelFAMType", 6, true, 100),
ExpectedColumn.CreateVarChar("LearnDelFAMCode", 7, true, 1000),
ExpectedColumn.CreateDate("LearnDelFAMDateFrom", 8, true),
ExpectedColumn.CreateDate("LearnDelFAMDateTo", 9, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("Invalid", "LearningDeliveryFAM", 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, false, 100),
ExpectedColumn.CreateBigInt("AimSeqNumber", 5, false),
ExpectedColumn.CreateVarChar("AFinType", 6, false, 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 CheckColumnLearningDeliveryWorkPlacement()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("LearningDeliveryWorkPlacement_Id", 1, false),
ExpectedColumn.CreateInt("LearningDelivery_Id", 2, true),
ExpectedColumn.CreateInt("UKPRN", 3, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 4, true, 100),
ExpectedColumn.CreateBigInt("AimSeqNumber", 5, true),
ExpectedColumn.CreateDate("WorkPlaceStartDate", 6, true),
ExpectedColumn.CreateDate("WorkPlaceEndDate", 7, true),
ExpectedColumn.CreateBigInt("WorkPlaceHours", 8, true),
ExpectedColumn.CreateBigInt("WorkPlaceMode", 9, true),
ExpectedColumn.CreateBigInt("WorkPlaceEmpId", 10, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("Invalid", "LearningDeliveryWorkPlacement", expectedColumns, true);
}
public void CheckColumnFileDetails()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateBigInt("ID", 1, false),
ExpectedColumn.CreateInt("UKPRN", 2, false),
ExpectedColumn.CreateNvarChar("Filename", 3, true, 50),
ExpectedColumn.CreateBigInt("FileSizeKb", 4, true),
ExpectedColumn.CreateInt("TotalLearnersSubmitted", 5, true),
ExpectedColumn.CreateInt("TotalValidLearnersSubmitted", 6, true),
ExpectedColumn.CreateInt("TotalInvalidLearnersSubmitted", 7, true),
ExpectedColumn.CreateInt("TotalErrorCount", 8, true),
ExpectedColumn.CreateInt("TotalWarningCount", 9, true),
ExpectedColumn.CreateDateTime("SubmittedTime", 10, true),
ExpectedColumn.CreateBit("Success", 11, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "FileDetails", expectedColumns, true);
}
public void CheckColumnValidationError()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateBigInt("Id", 1, false),
ExpectedColumn.CreateInt("UKPRN", 2, true),
ExpectedColumn.CreateVarChar("Source", 3, true, 50),
ExpectedColumn.CreateVarChar("LearnAimRef", 4, true, 1000),
ExpectedColumn.CreateBigInt("AimSeqNum", 5, true),
ExpectedColumn.CreateVarChar("SWSupAimID", 6, true, 1000),
ExpectedColumn.CreateNvarChar("ErrorMessage", 7, true, -1),
ExpectedColumn.CreateNvarChar("FieldValues", 8, true, 2000),
ExpectedColumn.CreateVarChar("LearnRefNumber", 9, true, 100),
ExpectedColumn.CreateVarChar("RuleName", 10, true, 50),
ExpectedColumn.CreateVarChar("Severity", 11, true, 2),
ExpectedColumn.CreateInt("FileLevelError", 12, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "ValidationError", 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);
}
public void CheckColumnLearningDeliveryHE()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("LearningDeliveryHE_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("NUMHUS", 6, true, 1000),
ExpectedColumn.CreateVarChar("SSN", 7, true, 1000),
ExpectedColumn.CreateVarChar("QUALENT3", 8, true, 1000),
ExpectedColumn.CreateBigInt("SOC2000", 9, true),
ExpectedColumn.CreateBigInt("SEC", 10, true),
ExpectedColumn.CreateVarChar("UCASAPPID", 11, true, 1000),
ExpectedColumn.CreateBigInt("TYPEYR", 12, true),
ExpectedColumn.CreateBigInt("MODESTUD", 13, true),
ExpectedColumn.CreateBigInt("FUNDLEV", 14, true),
ExpectedColumn.CreateBigInt("FUNDCOMP", 15, true),
new ExpectedColumn("STULOAD", "float", true, 16, numericPrecision: 4, numericScale: 1),
ExpectedColumn.CreateBigInt("YEARSTU", 17, true),
ExpectedColumn.CreateBigInt("MSTUFEE", 18, true),
new ExpectedColumn("PCOLAB", "float", true, 19, numericPrecision: 4, numericScale: 1),
new ExpectedColumn("PCFLDCS", "float", true, 20, numericPrecision: 4, numericScale: 1),
new ExpectedColumn("PCSLDCS", "float", true, 21, numericPrecision: 4, numericScale: 1),
new ExpectedColumn("PCTLDCS", "float", true, 22, numericPrecision: 4, numericScale: 1),
ExpectedColumn.CreateBigInt("SPECFEE", 23, true),
ExpectedColumn.CreateBigInt("NETFEE", 24, true),
ExpectedColumn.CreateBigInt("GROSSFEE", 25, true),
ExpectedColumn.CreateVarChar("DOMICILE", 26, true, 1000),
ExpectedColumn.CreateBigInt("ELQ", 27, true),
ExpectedColumn.CreateVarChar("HEPostCode", 28, true, 1000)
};
_fixture.SchemaTests.AssertTableColumnsExist("Invalid", "LearningDeliveryHE", expectedColumns, true);
}
