CVG_LOC_PCP
Description:
This table contains coverage level primary location and PCP information.

Primary Key
Column Name Ordinal Position
COVERAGE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 COVERAGE_ID NUMERIC No
The unique identifier for the coverage record.
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_ID VARCHAR No
The ID of the patient associated with the coverage level primary location and PCP.
4 PCP_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
5 PCP_TYPE_C_NAME VARCHAR No
The PCP type for the coverage level PCP.
May contain organization-specific values: Yes
Category Entries:
General
6 LOCATION_ID_LOC_NAME VARCHAR No
The name of the revenue location.
7 EFF_DATE DATETIME No
The effective date for the coverage level primary location and PCP.
8 TERM_DATE DATETIME No
The termination date for the coverage level primary location and PCP.
9 CHANGE_I_DTTM DATETIME (Local) No
The date and time the coverage level primary location and PCP were entered or changed.
10 CHANGE_USER_ID VARCHAR No
The user that entered or changed the coverage level primary location and PCP.
11 CHANGE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
12 PCP_CHANGE_RSN_C_NAME VARCHAR No
The reason for changing the coverage level PCP.
May contain organization-specific values: Yes
13 CHANGE_COMMENT VARCHAR No
The comment entered for the coverage level primary location and PCP.
14 DELETED_FLAG_YN VARCHAR No
Indicates whether this line of coverage level primary location and PCP information has been marked as deleted.
May contain organization-specific values: No
Category Entries:
No
Yes
15 CHANGE_REQ_BY_C_NAME VARCHAR No
The entity that requested a change to coverage level primary location and PCP.
May contain organization-specific values: Yes
Category Entries:
Member
Location
16 CVG_PCP_NETWORK_ID VARCHAR No
The selected network for the member. When Member Network Selection (HDF 18885) is on this item stores the selected network for the member. This network along with the networks the member matches to based on member matching criteria in the network record will make up the network records for the member.
17 CVG_PCP_NETWORK_ID_NETWORK_NAME VARCHAR No
The name of the network.
18 REGION_ID_LOC_NAME VARCHAR No
The name of the revenue location.
19 MEDICAL_GROUP_ID_LOC_NAME VARCHAR No
The name of the revenue location.
20 PCP_ADDRESS_IDENT VARCHAR No
COVERAGE PCP & LOCATION - PCP ADDRESS ID
21 CVG_PCP_ADD_INST_LOCAL_DTTM DATETIME (Local) No
The instant when the PCP and primary location are added.
22 CVG_PCP_ADD_USER_ID VARCHAR No
The user who adds the PCP and primary location.
23 CVG_PCP_ADD_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
24 CVG_PCP_PCP_RAW_IDENT VARCHAR No
The raw PCP ID received from source when not matched to a record.
25 CVG_PCP_PCP_RAW_NAME VARCHAR No
The raw PCP name received from source when not matched to a record.
26 CVG_PCP_LOC_RAW_IDENT VARCHAR No
The raw location ID received from source when not matched to a record.