MEM_LIST_DETAIL_REPL
Description:
The MEM_LIST_DETAIL_REPL 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
Invalid Broker of Record
10 MEMBER_REGION_ID_LOC_NAME VARCHAR No
The name of the revenue location.
11 MEMBER_MEDICAL_GROUP_ID_LOC_NAME VARCHAR No
The name of the revenue location.