MEM_LIST_DETAIL

Description:

The MEM_LIST _DETAIL table contains a list of members in a transaction like capitation computation or capitation receipt and reconciliation.

Primary Key

Column Name	Ordinal Position
MEM_LIST_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	MEM_LIST_ID	NUMERIC	No
	The ID of the transaction member list record computed as part of the specialty capitation payment process.
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	MEMBER_LIST	VARCHAR	No
	The ID of the member eligible for inclusion in specialty capitation payment computations.
4	COVERAGE_LIST	NUMERIC	No
	The ID of the coverage record for the member under which the member is eligible for inclusion in specialty capitation payment computations.
5	MEMBER_DOB	DATETIME	No
	The date of birth for the member eligible for inclusion in specialty capitation payment computations.
6	MEMBER_SEX_C_NAME	VARCHAR	No
	The sex of the member eligible for inclusion in specialty capitation payment computations. May contain organization-specific values: Yes Category Entries: Female Male Unknown Nonbinary X Other
7	MEMBER_CVG_ATTRS_EXTERNAL	VARCHAR	No
	Stores members' coverage attributes formatted by category list CVG 2001.
8	MEM_MCARE_CONTRACT_NUM	VARCHAR	No
	Stores the member's medicare advantage contract number.
9	WITHHOLD_REASON_C_NAME	VARCHAR	No
	The specialty capitation payment withhold reason category ID for a member in the transaction. May contain organization-specific values: No Category Entries: Member Suspended Member Limit Exceeded Rate Element Used Default Value
10	MEMBER_REGION_ID	NUMERIC	No
	The member's region ID.
11	MEMBER_MEDICAL_GROUP_ID	NUMERIC	No
	The member's medical group ID.