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.