Patient table. Contains patient specific information such as DOB, DOD, and sex.
Date of death is obtained by 2 methods:
1. If the patient died in the hospital, the died_in_hospital flag is 'Y' and the date of discharge is used as the date of death.
2. Patient social security numbers are matched to the US death records to obtain out of hospital date of death.
| Name | Type | Nullable | Default value | Comment |
|---|
| SUBJECT_ID | NUMBER(7) | N | | Table record unique identifier, the subject id. |
| SEX | VARCHAR2(1) | Y | | The patient gender |
| DOB | DATE | N | | Date of birth for the patient |
| DOD | DATE | Y | | Date of death for the patient. Null if still alive as of March 2009 |
| HOSPITAL_EXPIRE_FLG | VARCHAR2(1) | N | 'N' | Whether or not the patient died in the hospital |