coordination_of_benefits_subscriber
Contains unique subscriber details for coordination of benefits
Primary Key:Checks:coordination_of_benefits_subscriber_check-((member_identification_code <> ''::text) OR (individual_health_identifier <> ''::text) OR (member_ssn <> ''::text))coordination_of_benefits_subscriber_name_first_check-(name_first = upper(name_first))coordination_of_benefits_subscriber_name_last_check-((name_last = upper(name_last)) AND (name_last <> ''::text))coordination_of_benefits_subscriber_name_middle_check-(name_middle = upper(name_middle))coordination_of_benefits_subscriber_name_prefix_check-(name_prefix = upper(name_prefix))coordination_of_benefits_subscriber_name_suffix_check-(name_suffix = upper(name_suffix))
address_id=>address_seen.address_id
coordination_of_benefits_subscriber_address_id_idx-address_idcoordination_of_benefits_subscriber_name_first_idx-name_firstcoordination_of_benefits_subscriber_name_last_idx-name_lastcoordination_of_benefits_subscriber_uq(Unique) -name_last,name_first,name_middle,name_prefix,name_suffix,member_identification_code,individual_health_identifier,member_ssn,address_id
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
coordination_of_benefits_subscriber_id | bigint | No | Yes | - |
name_last | text | No | Yes | Last name (From NM103 / HCFA item 9) |
name_first | text | No | Yes | First / given name (From NM104 / HCFA item 9) |
name_middle | text | No | Yes | Middle name (From NM105 / HCFA item 9) |
name_prefix | text | No | Yes | Prefix to the name (From NM106) |
name_suffix | text | No | Yes | Suffix to the name (From NM107) |
primary_id_qualifier | identification_type | Yes | No | Data type of the primary identification code (From NM108) |
member_identification_code | text | No | Yes | Member identifier (From NM109 code MI [837 claim]) |
individual_health_identifier | text | No | Yes | Unique Health Identifier for each individual in the United States (From NM109 code II) |
member_ssn | text | No | Yes | Social Security Number (From NM109 code 34 or REF SY) |
address_id | bigint | Yes | Yes | Address (From N3, N4) |