MEMBER_RESP_PERSON

Description:

This table stores information about the responsible person (or people) for a member, as stored in the coverage. It includes information about name, SSN, relationship to members, and demographics. Each member on a coverage can have multiple responsible parties. The responsible parties for a specific member and coverage can be retrieved by joining to CVG_ID using a coverage ID and MEM_RESP_MEMBER_ID a patient ID. For example, MEMBER_RESP_PERSON.CVG_ID = COVERAGE_MEMBER_LIST.COVERAGE_ID AND MEMBER_RESP_PERSON.MEM_RESP_MEMBER_ID = COVERAGE_MEMBER_LIST.PAT_ID.

Primary Key

Column Name	Ordinal Position
CVG_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CVG_ID	NUMERIC	No
	The unique identifier for the coverage record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	MEM_RESP_NAME	VARCHAR	No
	The name of the person responsible for the member.
4	MEM_RESP_CITY	VARCHAR	No
	The city of the person responsible for the member.
5	MEM_RESP_STATE_C_NAME	VARCHAR	No
	The state of the person responsible for the member. May contain organization-specific values: Yes
6	MEM_RESP_ZIP	VARCHAR	No
	The ZIP code of the person responsible for the member.
7	MEM_RESP_COUNTY_C_NAME	VARCHAR	No
	The county of the person responsible for the member. May contain organization-specific values: Yes
8	MEM_RESP_COUNTRY_C_NAME	VARCHAR	No
	The country of the person responsible for the member. May contain organization-specific values: Yes
9	MEM_RESP_EMAIL	VARCHAR	No
	The e-mail address of the person responsible for the member.
10	MEM_RESP_REL_C_NAME	VARCHAR	No
	The relationship between the member and the responsible person. May contain organization-specific values: Yes Category Entries: Case Manager Key Person Person or Other Entity Legally Responsible for a Child Executor of Estate Ex-spouse Other Insured Guardian Power of Attorney Legal Representative Responsible Party Parent Significant Other Spouse Authorized Representative
11	MEM_RESP_MEMBER_ID	VARCHAR	No
	The internal ID of the member for whom a responsible person is responsible.
12	MEM_RESP_ADDR_LN_1	VARCHAR	No
	This item contains line one of the member's responsible person address. The purpose of this item is to provide the ability for reporting administrators to retrieve line one of the address without having to join the member responsible person address table.
13	MEM_RESP_ADDR_LN_2	VARCHAR	No
	This item contains line two of the member's responsible person address. The purpose of this item is to provide the ability for reporting administrators to retrieve line two of the address without having to join the member responsible person address table.
14	MEM_RESP_HOUSE_NUM	VARCHAR	No
	The house number of the responsible person's address.
15	MEM_RESP_DISTRICT_C_NAME	VARCHAR	No
	The district category ID of the responsible person's address. May contain organization-specific values: Yes
16	MEM_RESP_EFF_DATE	DATETIME	No
	The effective date on which person became responsible for the member.
17	MEM_RESP_TERM_DATE	DATETIME	No
	The termination date on which person's responsibility for the member ends.
18	MEM_RESP_GUID	VARCHAR	No
	The line ID of the person responsible for the member. Used to reference this line uniquely.