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)