eligibility_person_or_org

Contains unique people or organizations that are in some way connected to a member

Primary Key:

• person_or_org_id

Checks:

• eligibility_person_or_org_name_first_check - (name_first = upper(name_first))
• eligibility_person_or_org_name_last_or_organization_check - (name_last_or_organization = upper(name_last_or_organization))
• eligibility_person_or_org_name_middle_check - (name_middle = upper(name_middle))
• eligibility_person_or_org_name_prefix_check - (name_prefix = upper(name_prefix))
• eligibility_person_or_org_name_suffix_check - (name_suffix = upper(name_suffix))

Foreign Keys:

• address_id => address_seen.address_id
• alternate_phone_number_id => phone.phone_id
• beeper_number_id => phone.phone_id
• cell_phone_number_id => phone.phone_id
• email_address_id => email.email_id
• fax_number_id => fax.fax_id
• home_phone_number_id => phone.phone_id
• phone_number_id => phone.phone_id
• work_phone_number_id => phone.phone_id

Indexes:

• eligibility_person_or_org_uq (Unique) - address_id, date_of_birth, name_last_or_organization, name_first, name_middle, name_prefix, name_suffix, gender_or_sex, contact_name, alternate_phone_number_id, beeper_number_id, cell_phone_number_id, email_address_id, fax_number_id, home_phone_number_id, phone_number_id, work_phone_number_id, phone_extension

Column	Data Type	Nullable	Indexed	Description
person_or_org_id	bigint	No	Yes	- Generated through expression:
entity_type	entity_type	No	No	Identifies whether row is a person or organization (From NM102) Generated through expression:
name_last_or_organization	text	No	Yes	Last name or organization name (From NM103) Generated through expression:
name_first	text	No	Yes	First / given name (From NM104) Generated through expression:
name_middle	text	No	Yes	Middle name (From NM105) Generated through expression:
name_prefix	text	No	Yes	Prefix to the name (From NM106) Generated through expression:
name_suffix	text	No	Yes	Suffix to the name (From NM107) Generated through expression:
address_id	bigint	Yes	Yes	Address (From N3, N4) Generated through expression:
date_of_birth	date	Yes	Yes	Date of birth (From DMG02) Generated through expression:
gender_or_sex	gender_or_sex_type	No	Yes	May be either the preferred gender or the sex assigned at birth of the individual (From DMG03) Generated through expression:
contact_name	text	No	Yes	Name of the contact (From PER02) Generated through expression:
alternate_phone_number_id	bigint	Yes	Yes	Alternate telephone number ID (From PER03/5/7 AP) Generated through expression:
beeper_number_id	bigint	Yes	Yes	Beeper number ID (From PER03/5/7 BN) Generated through expression:
cell_phone_number_id	bigint	Yes	Yes	Cell phone number ID (From PER03/5/7 CP) Generated through expression:
email_address_id	bigint	Yes	Yes	Electronic mail address ID (From PER03/5/7 EM) Generated through expression:
fax_number_id	bigint	Yes	Yes	Facsimile number ID (From PER03/5/7 FX) Generated through expression:
home_phone_number_id	bigint	Yes	Yes	Home phone number ID (From PER03/5/7 HP) Generated through expression:
phone_number_id	bigint	Yes	Yes	Telephone number ID (From PER03/5/7 TE) Generated through expression:
work_phone_number_id	bigint	Yes	Yes	Work telephone number ID (From PER03/5/7 WP) Generated through expression:
phone_extension	text	No	Yes	Telephone extension (From PER03/5/7 EX) Generated through expression:
primary_id_qualifier	identification_type	Yes	No	Data type of the primary identification code (From NM108) Generated through expression: