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.