MEM_LIST_REPL

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_LOC_NAME | VARCHAR | No |
The name of the revenue location.
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_BENEFIT_PLAN_NAME | VARCHAR | No |
The name of the benefit plan record.
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_MEM_GRP_NAME | VARCHAR | No |
The name of the member group
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