coverage_coordination_of_benefits
Coordination of Benefits information for a member
Primary Key:Checks:coverage_coordination_of_benefits_account_suffix_check-(account_suffix = upper(account_suffix))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 = claims.clean_ssn(ssn))
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 | Snowflake ID for coverage coordination of benefits. Generated through expression: |
group_or_policy_number | text | No | Yes | Policy number is preferred, but group number may be supplied (From COB02) Generated through expression: |
coordination_status | coordination_of_benefits_status_type | Yes | Yes | Identifies whether coordination of benefits applies (From COB03) Generated through expression: |
account_suffix | text | No | Yes | Account Suffix Code (From REF 60) Generated through expression: |
policy_number | text | No | Yes | Policy number when supplied in COB02 with group number (From COB02) Generated through expression: |
group_number | text | No | Yes | Group number when policy number is supplied in COB02 (from REF 6P) Generated through expression: |
ssn | text | No | Yes | Social Security Number of the insured (From REF SY) Generated through expression: |
mutually_defined_id | text | No | Yes | Additional identifier as agreed upon by trading partners (From REF ZZ) Generated through expression: |
insurer_payer_id | bigint | Yes | Yes | Insurance company details (From NM1 loop) Generated through expression: |
cob_begin | date | Yes | Yes | Coordination of benefits start date (From DTP 344) Generated through expression: |
cob_end | date | Yes | Yes | Coordination of benefits end date (From DTP 345) Generated through expression: |