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.