Cancer Pathology Data > Patient

Entity

Data Element

Definition

Format

Valid Values

Purpose and Use

CCO Usage *

HL7 Field

Changes

Patient

Health Insurance Number

Health insurance number of the patient.

VARCHAR2(12)

Must be 10 numeric digits. Must contain valid modulus-10 check digit. Must contain only A-Z or 0-9 for non-OHIP numbers.

Used for patient identification, to identify OHIP vs. non-OHIP patients, and for registry record linkage.

RE

PID-3

Patient

Surname

Last name of patient.

VARCHAR2(40)

Must start with A-Z.

Used for patient identification and for registry record linkage.

R

PID-5

Patient

First Given Name

First name of patient.

VARCHAR2(40)

Must start with A-Z.

Used for patient identification and for registry record linkage.

R

PID-5

Patient

Birth Date

Date of birth of patient.

VARCHAR2(16)

YYYYMMDD 

Used for patient identification, to calculate age at diagnosis and for registry record linkage.

R

PID-7

Patient

Gender Code

Gender code of patient.

VARCHAR2(1)

M = Male

F = Female

H = Hermaphrodite, Undetermined

T=Transsexual                                    

O = Other

U = Unknown

Used for gender classification and for incidence statistics.

R

PID-8

Patient

City

City of patient's residence.

VARCHAR2(50)

N/A 

Used to determine geographical area of residence at time of diagnosis.

RE

PID-11

Patient

Province Code

Province code of patient's residence.

VARCHAR2(2)

Two character province code.

Used to determine geographical area of residence at time of diagnosis.

RE

PID-11

Patient

Country Code

Country code of patient's residence.

VARCHAR2(4)

Refer to Appendix 4.3 for valid country codes.

Used to determine geographical area of residence at time of diagnosis.

RE

PID-11

Patient

Postal Code

Postal code of patient’s residence.

VARCHAR2(9)

Must be in format ANA NAN only.

Used to determine geographical area of residence at time of diagnosis and for incidence statistics.

RE

PID-11

Patient

Date of Death

Date and time of death (time portion optional).

VARCHAR2(16)

YYYYMMDD[HHMMSS]

The date and time at which the patient death occurred in the format: YYYYMMDD. This field should only be valued only if the report is an autopsy.

RE

PID-29

Patient

Vital Status

Death Indicator.

VARCHAR2(1)

Y/N

Indicates whether or not the patient is deceased in the format: “Y” or “N”. This field should only be set to “Y” if the report is an autopsy and otherwise set to “N”.

RE

PID-30