select	--checks for duplication
		SourceItemID,
		RowID,
		--red flags
		NHSOrg_CCGKey,
		pr.NHSOrganisationCode ProviderCode,
		pr.NHSOrganisationName ProviderName,
		Patient_DerivedKey,
		f.POD_DerivedKey,
		pod.PODCode,
		pod.PODDescription,
		pod.PODGroup1,
		FinancialYearKey,
		FinancialMonth_Derived,
		DataSetKey,
		YTDActualActivity,
		YTDActualCost,
		--p1s AE
		AEInitialAssessmentTimeDateKey,
		HRGKey,
		NHSOrgSiteKey,
		MainSpecialtyKey,
		--p1s IP
		SpellStartDateKey,
		PrimaryICD10DiagnosisKey,
		PrimaryOPCS4ProcedureKey,
		PbRLos,
		--p1s OP
		ActivityDateKey,
		--p2s AE
		ConsultantKey,
		--AAndEDiagnosisKey,
		AEInvestigationFirstKey,
		AETreatmentFirstKey,
		DischargeMethodKey,
		--p2s IP
		Consultant_ReferrerKey
from FactSLAM_PLD f
inner join DimNHSOrganisation pr
	ON f.NHSOrg_ProviderKey = pr.NHSOrganisationKey
inner join DimPointOfDeliveryDerived pod
	on f.POD_DerivedKey = pod.PointOfDeliveryKey