subscriber_or_patient

Contains unique subscribers and patients associated with a claim

Primary Key:

• subscriber_or_patient_id

Checks:

• subscriber_or_patient_name_first_check - (name_first = upper(name_first))
• subscriber_or_patient_name_last_check - (name_last = upper(name_last))
• subscriber_or_patient_name_middle_check - (name_middle = upper(name_middle))
• subscriber_or_patient_name_prefix_check - (name_prefix = upper(name_prefix))
• subscriber_or_patient_name_suffix_check - (name_suffix = upper(name_suffix))

Foreign Keys:

• address_id => address_seen.address_id
• phone_number_id => phone.phone_id

Indexes:

• subscriber_or_patient_address_id_idx - address_id
• subscriber_or_patient_date_of_birth_idx - date_of_birth
• subscriber_or_patient_name_first_idx - name_first
• subscriber_or_patient_name_last_idx - name_last
• subscriber_or_patient_phone_number_id_idx - phone_number_id
• subscriber_or_patient_uq (Unique) - address_id, date_of_birth, name_last, name_first, name_middle, name_prefix, name_suffix, gender_or_sex, contact_name, phone_number_id, phone_extension

Column	Data Type	Nullable	Indexed	Description
subscriber_or_patient_id	bigint	No	Yes	- Generated through expression:
address_id	bigint	Yes	Yes	Address (From N3, N4 / UB04 FL09 for patient, FL38/FL58 for subscriber / HCFA item 5 for patient / item 7 for subscriber) Generated through expression:
date_of_birth	date	Yes	Yes	Date of birth (From DMG02 / UB04 FL10 / HCFA item 3 for patient, item 11a for subscriber) Generated through expression:
name_last	text	No	Yes	Last name (From NM103 / UB04 FL08b for patient, FL38/FL58 for subscriber / HCFA item 2 for patient, item 4 for subscriber) Generated through expression:
name_first	text	No	Yes	First / given name (From NM104 / UB04 FL08b for patient, FL38/FL58 for subscriber / HCFA item 2 for patient, item 4 for subscriber) Generated through expression:
name_middle	text	No	Yes	Middle name (From NM105 / UB04 FL08b for patient, FL38/FL58 for subscriber / HCFA item 2 for patient, item 4 for subscriber) 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 / UB04 FL08b for patient, FL38/FL58 for subscriber) 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 / UB04 FL11 / HCFA item 3 for patient, 11a for subscriber) Generated through expression:
contact_name	text	No	Yes	Name of the contact (From PER02) Generated through expression:
phone_number_id	bigint	Yes	Yes	Telephone number ID (From PER03/5/7 TE / HCFA item 5 for patient / item 7 for subscriber) 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: