gender_source_value

SUS Outpatient Person

• Value copied from PersonCurrentGenderCode

• PersonCurrentGenderCode Patient PersonCurrentGenderCode PERSON GENDER CODE CURRENT

	select
		NHSNumber,
		max(DateofBirth) as DateOfBirth,
		max(EthnicCategory) as EthnicCategory,
		max(Sex) as PersonCurrentGenderCode
	from [omop_staging].[sus_OP]
	where NHSNumber is not null
	group by NHSNumber
	

Comment or raise an issue for this mapping.

SUS Inpatient Person

• Value copied from PersonCurrentGenderCode

• PersonCurrentGenderCode Patient PersonCurrentGenderCode PERSON GENDER CODE CURRENT

	select
		NHSNumber,
		max(DateofBirth) as DateOfBirth,
		max(EthnicGroup) as EthnicCategory,
		max(Sex) as PersonCurrentGenderCode
	from omop_staging.sus_APC
	where NHSNumber is not null
	group by NHSNumber
	

Comment or raise an issue for this mapping.

SUS A&E Person

• Value copied from PersonCurrentGenderCode

• PersonCurrentGenderCode Patient PersonCurrentGenderCode PERSON GENDER CODE CURRENT

	select
		NHSNumber,
		max(DateofBirth) as DateOfBirth,
		max(EthnicCategory) as EthnicCategory,
		max(Sex) as PersonCurrentGenderCode
	from omop_staging.sus_AE
	where NHSNumber is not null
	group by NHSNumber
	

Comment or raise an issue for this mapping.

SACT Person

• Value copied from Person_Stated_Gender_Code

• Person_Stated_Gender_Code The patient’s Sex PERSON GENDER CODE CURRENT

	select
		NHS_Number,
		max (Date_Of_Birth) as Date_Of_Birth,
		max (Person_Stated_Gender_Code) as Person_Stated_Gender_Code
	from omop_staging.sact_staging
	group by NHS_Number
	

Comment or raise an issue for this mapping.