Attribute groups

Some data access policies grant data access to groups of attributes, while others can allow access only for certain attributes.

PII attributes are combined into PII attribute groups. For more information on attribute groups, see:

For more information on individual Omics Attributes, see: Table 2-1

Table 2-1 Omics Data Attributes

Subject and Patient Attributes Description Table API Procedure Input Parameter

SUBJ_ODB

Defines whether patient omics data is granted (Y) or denied (N) in a configuration

W_EHA_VPD_CONFIG

I_SUBJ_ODB

SUBJ_ODB_EXP_DT

Defines expiration date for N value in SUBJ_ODB

W_EHA_VPD_CONFIG

I_SUBJ_ODB_EXP_DT

PT_ODB

Defines whether patient omics data is granted (Y) or denied (N) in a given configuration

W_EHA_VPD_CONFIG

I_PT_ODB

PT_ODB_EXP_DT

Defines expiration date for N value in PT_ODB

W_EHA_VPD_CONFIG

I_PT_ODB_EXP_DT

Table 2-2 Personally Identifiable Attribute Groups for Subjects

Subject Attribute Groups Description Table Column(s) API Procedure Input Parameter

SUBJ_ADD

Subject Address

W_EHA_SUBJECT_D

CITY, POSTAL_CODE, STREET_ADDRESS_1, STREET_ADDRESS_2, STREET_ADDRESS_3

I_SUBJ_ADD

SUBJ_CONSENT

Subject Consent Dates

W_EHA_ENC_PATIENT_H

CONSENT_START_DT, CONSENT_END_DT

I_SUBJ_CONSENT

SUBJ_DATE

Subject Lifecycle Dates

W_EHA_SUBJECT_D

DOB, DECEASED_DT

I_SUBJ_DATE

SUBJ_DX

Subject Diagnosis Dates

W_EHA_DX_SUBJECT_H

DIAGNOSIS_ONSET_DT, DIAGNOSIS_REPORTED_DT, DIAGNOSIS_END_DT, AGE_AT_FIRST_ONSET

I_SUBJ_DX

SUBJ_ENC

Subject Encounter Dates

W_EHA_ENC_SUBJECT_H

ENCOUNTER_START_DT, ENCOUNTER_END_DT

I_SUBJ_ENC

SUBJ_HIST

Subject History

W_EHA_SBJ_HISTORY_SBJ_H

SUBJECT_HISTORY_START_DT, SUBJECT_HISTORY_END_DT

I_SUBJ_HIST

SUBJ_ID

Subject Identifier

W_EHA_SUBJECT_D

SUBJECT_IDENTIFIER

I_SUBJ_ID

SUBJ_MED

Subject Medication Dates

W_EHA_SUBADMN_SUBJECT_H

SUBADMN_START_DT, SUBADMN_END_DT

I_SUBJ_MED

SUBJ_NAME

Subject Name

W_EHA_SUBJECT_D

FIRST_NAME, MIDDLE_NAME, LAST_NAME

I_SUBJ_NAME

SUBJ_OBSV

Subject Observation Dates

W_EHA_OBSV_SUBJECT_H

OBSV_DT

I_SUBJ_OBSV

SUBJ_PROC

Subject Procedure Dates

W_EHA_PROC_SUBJECT_H

PROCEDURE_START_DT, PROCEDURE_END_DT

I_SUBJ_PROC

SUBJ_SPEC

Subject Specimen Identifier and Collection Date

W_EHA_SPECIMEN_SUBJECT_H

SPECIMEN_COLLECTION_DT,

SPECIMEN_NUMBER

I_SUBJ_SPEC

Table 2-3 Personally Identifiable Attribute Groups for Patients

Patient Attribute Groups Description Table Column(s) API Procedure Input Parameter

PT_ADD

Patient Address

W_EHA_RESEARCH_PATIENT_D

CITY, POSTAL_CODE, STREET_ADDRESS_1, STREET_ADDRESS_2, STREET_ADDRESS_3

I_PT_ADD

PT_CONSENT

Patient Consent Dates

W_EHA_CONSENT_PATIENT_H

CONSENT_START_DT, CONSENT_END_DT

I_PT_CONSENT

PT_DATE

Patient Lifecycle Dates

W_EHA_RESEARCH_PATIENT_D

DOB, DECEASED_DT

I_PT_DATE

PT_DX

Patient Diagnosis Dates

W_EHA_DX_PATIENT_H

DIAGNOSIS_ONSET_DT, DIAGNOSIS_ REPORTED_DT, DIAGNOSIS_END_DT, AGE_AT_FIRST_ONSET

I_PT_DX

PT_ENC

Patient Encounter Dates

W_EHA_ENC_PATIENT_H

ENCOUNTER_START_DT, ENCOUNTER_END_DT

I_PT_ENC

PT_HIST

Patient History

W_EHA_PT_HISTORY_PT_H

PATIENT_HISTORY_START_DT, PATIENT_HISTORY_END_DT

I_PT_HIST

PT_ID

Patient Identifier

W_EHA_RESEARCH_PATIENT_D

PATIENT_IDENTIFIER

I_PT_ID

PT_MED

Patient Medication Dates

W_EHA_SUBADMN_PATIENT_H

SUBADMN_START_DT, SUBADMN_END_DT

I_PT_MED

PT_NAME

Patient Name

W_EHA_RESEARCH_PATIENT_D

FIRST_NAME, MIDDLE_NAME, LAST_NAME

I_PT_NAME

PT_OBSV

Patient Observation Dates

W_EHA_OBSV_PATIENT_H

OBSV_DT

I_PT_OBSV

PT_PROC

Patient Procedure Dates

W_EHA_PROC_PATIENT_H

PROCEDURE_START_DT, PROCEDURE_END_DT

I_PT_PROC

PT_SPEC

Patient Specimen Identifier and Collection Date

W_EHA_SPECIMEN_PATIENT_H

SPECIMEN_COLLECTION_DT, SPECIMEN_NUMBER

I_PT_SPEC