gender_concept_id

SACT

Source column Person_Stated_Gender_Code. Lookup gender concept.

Person_Stated_Gender_Code	gender_concept_id	notes
1	8507	Male
2	8532	Female
9	8551	Indeterminate (unable to be classified as either male or female)
X	8551	Not known

Notes

NHS Gender
OMOP Gender
Person_Stated_Gender_Code The patient’s Sex PERSON GENDER CODE CURRENT

select
	NHS_Number,
	max (Patient_Postcode) as Patient_Postcode,
	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.

Rtds Demographics

Source column Sex. Lookup gender concept.

Sex	gender_concept_id	notes
Male	8507
Female	8532
Unknown	8551
Not Stated	8551

Notes

OMOP Gender
Sex The patient’s Sex PERSON GENDER CODE CURRENT

select
	PatientId,
	max (DateOfBirth) as DateOfBirth,
	max (Sex) as Sex
from omop_staging.RTDS_1_Demographics d
where PatientId is not null
group by PatientId
	

Comment or raise an issue for this mapping.

CDS Person

Source column PersonCurrentGenderCode. Lookup gender concept.

PersonCurrentGenderCode	gender_concept_id	notes
1	8507	Male
2	8532	Female
9	8551	Indeterminate (unable to be classified as either male or female)
X	8551	Not known

Notes

NHS Gender
OMOP Gender
PersonCurrentGenderCode Patient PersonCurrentGenderCode PERSON GENDER CODE CURRENT

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

Comment or raise an issue for this mapping.