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.