MEM_LIST

Description:

This table contains member context information for capitation transactions.

Primary Key

Column Name	Ordinal Position
MEM_LIST_ID	1

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	EFFECTIVE_DATE	DATETIME	No
	The effective date of the specialty capitation payment computation.
3	ELIGIBILITY_DATE	DATETIME	No
	The test date used to determine if a member is eligible for inclusion in specialty capitation payment computations.
4	SERV_AREA_ID	NUMERIC	No
	The ID of the service area that defines the context of the specialty capitation payment computation.
5	CARRIER_ID	VARCHAR	No
	The ID of the carrier that defines the context of the specialty capitation payment computation.
6	CARRIER_ID_CARRIER_NAME	VARCHAR	No
	The name of the carrier record.
7	NETWORK_ID	VARCHAR	No
	The ID of the network that defines the context of the specialty capitation payment computation.
8	NETWORK_ID_NETWORK_NAME	VARCHAR	No
	The name of the network.
9	BENEFIT_PLAN_ID	NUMERIC	No
	The ID of the benefit plan that defines the context of the specialty capitation payment computation.
10	RKP_ID	VARCHAR	No
	The unique ID of the risk panel for the member.
11	RKP_ID_RISK_PANEL_NAME	VARCHAR	No
	The name of the risk panel.
12	LOB_ID	VARCHAR	No
	The unique ID of the line of business for the member.
13	LOB_ID_LOB_NAME	VARCHAR	No
	The name of the line of business record.
14	MGRP_ID	VARCHAR	No
	The unique ID of member group for the member.
15	MEM_LIST_TYPE_C_NAME	VARCHAR	No
	The type of member list that this record represents. May contain organization-specific values: No Category Entries: Member List Addition Subtraction Change Addition Change Subtraction
16	ADJUST_ORIG_LIST_ID	NUMERIC	No
	The ID of the transaction member list that this list adjusts.
17	LOAD_BATCH_DATE	DATETIME	No
	The date that the member list was loaded into the system.
18	ASSOC_EXT_VAL_C_NAME	VARCHAR	No
	The member group association value for the member list. May contain organization-specific values: Yes
19	CAPITATION_CODE_C_NAME	VARCHAR	No
	The capitation code associated with the transaction. May contain organization-specific values: Yes
20	PRODUCT_TYPE_C_NAME	VARCHAR	No
	The product type associated with the member list. May contain organization-specific values: Yes