PAT_COB_INFO

Description: |
This table contains a list of coordination of benefits savings bucket (COB) coverages to which a member belongs, and information specific to that COB coverage, such as insurance company and subscriber name.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ID | VARCHAR | No |
Unique patient ID associated with the Coordination of Benefits (COB) information.
2 | LINE | INTEGER | No |
Line number of Coordination of Benefits (COB) information on patient.
3 | COB_INS_CO_NAME | VARCHAR | No |
Name of the insurance company for Coordination of Benefits (COB) information.
4 | COB_INS_CO_ADDR | VARCHAR | No |
Address of insurance company for Coordination of Benefits (COB) information.
5 | COB_INSURED_NAME | VARCHAR | No |
Name of subscriber on Coordination of Benefits (COB) coverage.
6 | COB_GRP_POLICY_NUM | VARCHAR | No |
Group/policy number on Coordination of Benefits (COB) coverage.
7 | COB_GRP_NAME_EMPR | VARCHAR | No |
Group/employer name on Coordination of Benefits (COB) coverage.
8 | COB_STATUS_C_NAME | VARCHAR | No |
Status of information for a member/Coordination of Benefits (COB) coverage.
May contain organization-specific values: Yes
9 | COB_INS_PHONE | VARCHAR | No |
Phone number of contact at Coordination of Benefits (COB) insurance company.
10 | COB_INS_CONTACT | VARCHAR | No |
Contact at Coordination of Benefits (COB) insurance company.
11 | COB_INSURED_DOB | DATETIME | No |
Date of birth for subscriber on a Coordination of Benefits (COB) coverage.
12 | COB_MEM_RELX_C_NAME | VARCHAR | No |
Relationship of member to the subscriber on a Coordination of Benefits (COB) coverage.
May contain organization-specific values: Yes
Category Entries:
Self
Spouse
Child
Employee
Unknown
13 | COB_MEM_EFF_DATE | DATETIME | No |
Effective date of member on a Coordination of Benefits (COB) coverage.
14 | COB_MEM_TERM_DATE | DATETIME | No |
Termination date for a member on a Coordination of Benefits (COB) coverage.
15 | COB_MEM_COMMENT | VARCHAR | No |
Free-text comment for a member on a Coordination of Benefits (COB) coverage (member-level).
16 | COB_COMMENT | VARCHAR | No |
Free-text comment associated with a Coordination of Benefits (COB) coverage (coverage-level).
17 | COB_MEM_PRI_YN | VARCHAR | No |
Indicates if the Coordination of Benefits (COB) coverage should be considered primary for the member (Y=COB coverage is primary, N=COB coverage is not primary).
May contain organization-specific values: No
Category Entries:
Primary
Unknown
Secondary
Tertiary
Supplemental
18 | COB_MEMBERS | VARCHAR | No |
Returns internal member IDs associated with Coordination of Benefits (COB) coverage.
19 | COB_PART_D_RX_BIN | VARCHAR | No |
The Beneficiary Identification Number (BIN) used for Part D Coordination of Benefits
20 | COB_PART_D_RX_PCN | VARCHAR | No |
The Processor Control Number (PCN) used for Part D Coordination of Benefits
21 | COB_PART_D_RX_GRP | VARCHAR | No |
The group used for Part D Coordination of Benefits
22 | COB_PART_D_RX_ID | VARCHAR | No |
The ID used for Part D Coordination of Benefits
23 | COB_COVERAGE_ID | NUMERIC | No |
The ID of the indemnity coverage that is associated with this Coordination of Benefits (COB) coverage.
24 | COB_SUB_EMPLOYMENT_STATUS_C_NAME | VARCHAR | No |
The employment status of the subscriber on this Coordination of Benefits (COB) coverage.
May contain organization-specific values: Yes
Category Entries:
Full Time
Part Time
Not Employed
Self Employed
Retired
On Active Military Duty
Student - Full Time
Student - Part Time
Unknown
25 | COB_MEM_COURT_DECREE_C_NAME | VARCHAR | No |
The court decree for the member on this Coordination of Benefits (COB) coverage.
May contain organization-specific values: Yes
Category Entries:
Not Applicable (no court decree concerning healthcare expenses)
Subscriber is the parent responsible for healthcare expenses
Subscriber is the spouse of the parent responsible for healthcare expenses
Subscriber is a parent jointly responsible for healthcare expenses
Subscriber is the spouse of a parent jointly responsible for healthcare expenses
Subscriber is the parent not responsible for healthcare expenses
Subscriber is the spouse of the parent not responsible for healthcare expenses
26 | COB_MEM_SUB_CUSTODY_C_NAME | VARCHAR | No |
The subscriber custody for the member on this Coordination of Benefits (COB) coverage.
May contain organization-specific values: Yes
Category Entries:
Not Applicable (parents married, widowed parent, etc)
Subscriber is the custodial parent
Subscriber is a joint custody parent
Subscriber is the spouse of the custodial parent
Subscriber is the spouse of a joint custody parent
Subscriber is the non-custodial parent
Subscriber is the spouse of the non-custodial parent
27 | COB_SUBSCRIBER_NUM | VARCHAR | No |
The identifier for Coordination of Benefits (COB) coverages that is shared by all members on the same coverage.
28 | COB_MEMBER_NUM | VARCHAR | No |
Coordination of Benefits (COB) member identification number.
29 | MCARE_IS_SEC_PAYER_RSN_C_NAME | VARCHAR | No |
The Medicare is Secondary Payer (MSP) reason category ID for the COB coverage.
May contain organization-specific values: No
Category Entries:
Working Aged
ESRD
Conditional Payment
Automobile Insurance, No fault
WC
Federal (public)
Disabled
Black Lung
Veterans
Liability
Workers Compensation Set Aside (WCSA)
30 | EMPLOYERS_CITY | VARCHAR | No |
The city for the employer's address on the COB coverage.
31 | EMPLOYERS_TAX_STATE_C_NAME | VARCHAR | No |
The state category ID for the employer's address on the COB coverage.
May contain organization-specific values: Yes
32 | EMPLOYERS_ZIP | VARCHAR | No |
The ZIP code for the employer's address on the COB coverage.
33 | INSURER_TYPE_C_NAME | NUMERIC | No |
The COB Insurer Type category ID for this COB coverage on the patient.
May contain organization-specific values: No
Category Entries:
Insurance or indemnity
HMP
Preferred provider organization
Third party administrator arrangement under an administrative service only contract without stop loss from any entity
Third party administrator arrangement with stop loss insurance issued from any entity
Self-insured/self-administered
Collectively-bargained health and welfare
Multiple employer health plan with at least one employer who has more than 100 full and/or part-time employees
Hospitalization only plan which covers only Inpatient services
Medicare services only plan which covers only noninpatient services
Medicare supplemental plan: Medigap, Medicare Wraparound Plan or Medicare Carve Out Plan