For this entity, a record will be created in AER_PATIENT table. If the relevant data is available, records in AER_PATIENT_RECORD will be created with RECORD_TYPE set to:
General practitioner
Specialist
Hospital
Study, depending on which field elements contains data.
For this entity information will be taken from AER_PATIENT table and AER_PATIENT_RECORD table.
In AER_PATIENT_RECORD table, if a record with RECORD_TYPE field is equal to
1(General practitioner), its RECORD_NO field is exported to 'patientgpmedicalrecordnumb'
2(Specialist), its RECORD_NO field is exported to 'patientspecialistrecordnumb'
3(Hospital), its RECORD_NO field is exported to 'patienthospitalrecordnumb'
4(Study), it’s RECORD_NO field is exported to 'patientinvestigationnumb'
Patient Age Information population logic:
Patient age information will be populated based upon the most precise information available. Only one of the elements describing age will be used based on below priorities.
Age at time of onset of reaction/event
Patient age group
Date of birth
The most precise patient age information will be populated from AER_PATIENT table based on below table.
|
AGE and AGE_UNIT |
AGE_GROUP |
DOB |
Exported tags |
|
Age at the time of event Available |
Age group is available |
Date of birth is available |
<patientonsetage> and <patientonsetageunit> |
|
Not available |
Age group is available |
Date of birth is available |
<patientageagoup> |
|
Not available |
Not available |
Date of birth is available |
<patientbirthdateformat> and <patientbirthdate> |
Date of birth
Age at time of onset of reaction/event
Patient age group
The most precise patient age information for English will be populated from AER_PATIENT table based on below table.
|
DOB |
AGE and AGE_UNIT |
AGE_GROUP |
Exported tags |
|
Date of birth is available |
Age at the time of event Available |
Age group is available |
<patientbirthdateformat> and <patientbirthdate> |
|
Imprecise date of birth is available |
Age at the time of event Available |
Age group is available |
<patientonsetage> and <patientonsetageunit> |
|
Not available |
Age at the time of event Available |
Age group is available |
<patientonsetage> and <patientonsetageunit> |
|
Not available |
Not available |
Age group is available |
<patientageagoup> |
Patient Gestation Period/unit fields will be populated irrespective of the availability of other "Patient Age" fields.
Parent age information will be populated based on the most precise information available.
The priorities to populate parent age information will be as specified below:
Parent DOB
Parent Age at the time of event
|
B.1.1 - Patientinitial |
B.1.1.1d - Patientinvestigationnumb |
B.1.2.3 - Patientagegroup |
B.1.6a & B.1.6b - Lastmenstrualdateformat & Patientlastmenstrualdate |
|
B.1.1.1a - Patientgpmedicalrecordnumb |
B.1.21a & B.1.2.1b - Patientbirthdateformat & Patientbirthdate |
B.1.3 - Patientweight |
|
|
B.1.1.1b - Patientspecialistrecordnumb |
B.1.2.2a & B.1.2.2b - Patientonsetage & Patientonsetageunit |
B.1.4 - Patientheight |
|
|
B.1.1.1c - Patienthospitalrecordnumb |
B.1.2.2.1a & B.1.2.2.1b - Gestationperiod & Gestationperiodunit |
B.1.5 - Patientsex |
|
Back to ICHICSR Safety Report