PAT_MEM_ID

Description: |
This table is used to link patients to a member ID associated with one of the patients coverages.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PATIENT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PATIENT_ID | VARCHAR | No |
This is the Epic Patient ID.
2 | LINE | INTEGER | No |
The line number.
3 | MEMBER_ID | VARCHAR | No |
This is the patient's Member ID associated with a carrier. You can use this number to look up the patient and his/her family members.
4 | LONG_MEMBER_ID | VARCHAR | No |
This is the patient's Member ID preceded by a chart or Medical Record Number. This column contains the data that is stored in the Member ID super item (EPT 5001).
5 | MEM_ID_CARRIER_ID | VARCHAR | No |
Member ID maintained by a carrier
6 | MEM_ID_CARRIER_ID_CARRIER_NAME | VARCHAR | No |
The name of the carrier record.