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