coverage_coordination_of_benefits
Coordination of Benefits information for a member
Primary Key:Checks:coverage_coordination_of_benefits_check-((group_or_policy_number = ''::text) OR ((policy_number = ''::text) AND (group_number = ''::text)))coverage_coordination_of_benefits_group_number_check-(group_number = upper(group_number))coverage_coordination_of_benefits_group_or_policy_number_check-(group_or_policy_number = upper(group_or_policy_number))coverage_coordination_of_benefits_mutually_defined_id_check-(mutually_defined_id = upper(mutually_defined_id))coverage_coordination_of_benefits_policy_number_check-(policy_number = upper(policy_number))coverage_coordination_of_benefits_ssn_check-(ssn ~ '^[0-9]*$'::text)
insurer_payer_id=>insurer_payer.insurer_payer_id
coverage_coordination_of_bene_group_or_policy_number_coordi_idx(Unique) -group_or_policy_number,coordination_status,account_suffix,policy_number,group_number,ssn,mutually_defined_id,insurer_payer_id,cob_begin,cob_end
| Column | Data Type | Nullable | Indexed | Description |
|---|---|---|---|---|
coverage_coordination_of_benefits_id | bigint | No | Yes | - |
group_or_policy_number | text | No | Yes | Policy number is preferred, but group number may be supplied (From COB02) |
coordination_status | coordination_of_benefits_status_type | Yes | Yes | Identifies whether coordination of benefits applies (From COB03) |
account_suffix | text | No | Yes | Account Suffix Code (From REF 60) |
policy_number | text | No | Yes | Policy number when supplied in COB02 with group number (From COB02) |
group_number | text | No | Yes | Group number when policy number is supplied in COB02 (from REF 6P) |
ssn | text | No | Yes | Social Security Number of the insured (From REF SY) |
mutually_defined_id | text | No | Yes | Additional identifier as agreed upon by trading partners (From REF ZZ) |
insurer_payer_id | bigint | Yes | Yes | Insurance company details (From NM1 loop) |
cob_begin | date | Yes | Yes | Coordination of benefits start date (From DTP 344) |
cob_end | date | Yes | Yes | Coordination of benefits end date (From DTP 345) |