person_or_org
Contains unique people or organizations that are in some way connected to a member, provider, or payer
Primary Key:Checks:person_or_org_name_first_check-(name_first = upper(name_first))person_or_org_name_last_or_organization_check-(name_last_or_organization = upper(name_last_or_organization))person_or_org_name_middle_check-(name_middle = upper(name_middle))person_or_org_name_prefix_check-(name_prefix = upper(name_prefix))person_or_org_name_suffix_check-(name_suffix = upper(name_suffix))
address_id=>address_seen.address_idalternate_phone_number_id=>phone.phone_idbeeper_number_id=>phone.phone_idcell_phone_number_id=>phone.phone_idemail_address_id=>email.email_idfax_number_id=>fax.fax_idhome_phone_number_id=>phone.phone_idphone_number_id=>phone.phone_idwork_phone_number_id=>phone.phone_id
person_or_org_address_id_idx-address_idperson_or_org_alternate_phone_number_id_idx-alternate_phone_number_idperson_or_org_beeper_number_id_idx-beeper_number_idperson_or_org_cell_phone_number_id_idx-cell_phone_number_idperson_or_org_date_of_birth_idx-date_of_birthperson_or_org_email_address_id_idx-email_address_idperson_or_org_fax_number_id_idx-fax_number_idperson_or_org_home_phone_number_id_idx-home_phone_number_idperson_or_org_name_first_idx-name_firstperson_or_org_name_last_or_organization_idx-name_last_or_organizationperson_or_org_phone_number_id_idx-phone_number_idperson_or_org_uq(Unique) -address_id,date_of_birth,name_last_or_organization,name_first,name_middle,name_prefix,name_suffix,entity_type,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_extensionperson_or_org_work_phone_number_id_idx-work_phone_number_id
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
person_or_org_id | bigint | No | Yes | - |
address_id | bigint | Yes | Yes | Address (From N3, N4) |
date_of_birth | date | Yes | Yes | Date of birth (From DMG02) |
entity_type | entity_type | No | Yes | Identifies whether row is a person or organization (From NM102) |
name_last_or_organization | text | No | Yes | Last name or organization name (From NM103) |
name_first | text | No | Yes | First / given name (From NM104) |
name_middle | text | No | Yes | Middle name (From NM105) |
name_prefix | text | No | Yes | Prefix to the name (From NM106) |
name_suffix | text | No | Yes | Suffix to the name (From NM107) |
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) |
contact_name | text | No | Yes | Name of the contact (From PER02) |
alternate_phone_number_id | bigint | Yes | Yes | Alternate telephone number ID (From PER03/5/7 AP) |
beeper_number_id | bigint | Yes | Yes | Beeper number ID (From PER03/5/7 BN) |
cell_phone_number_id | bigint | Yes | Yes | Cell phone number ID (From PER03/5/7 CP) |
email_address_id | bigint | Yes | Yes | Electronic mail address ID (From PER03/5/7 EM) |
fax_number_id | bigint | Yes | Yes | Facsimile number ID (From PER03/5/7 FX) |
home_phone_number_id | bigint | Yes | Yes | Home phone number ID (From PER03/5/7 HP) |
phone_number_id | bigint | Yes | Yes | Telephone number ID (From PER03/5/7 TE) |
work_phone_number_id | bigint | Yes | Yes | Work telephone number ID (From PER03/5/7 WP) |
phone_extension | text | No | Yes | Telephone extension (From PER03/5/7 EX) |