V_EHI_CVG_VERIF_HX_FILTER_PAT

Description: |
EHI Filter view for audit trail of historical (i.e. old data model) coverage verification changes on a coverage record.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
CVG_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | CVG_ID | NUMERIC | No |
The ID of the coverage (CVG) 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 | VERF_HX_PRV_STAT_C_NAME | VARCHAR | No |
When the verification status is changed, this column contains the old status.
May contain organization-specific values: Yes
4 | VERF_HX_NEW_STAT_C_NAME | VARCHAR | No |
When the verification status is changed, this column contains the new status.
The category values for this column were already listed for column: VERF_HX_PRV_STAT_C_NAME
5 | VERF_HX_USER_ID | VARCHAR | No |
When the verification status is changed, this column contains the user who caused the change.
6 | VERF_HX_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
7 | VERF_HX_CHANGE_DT | DATETIME | No |
When the verification status is changed, this column contains the date of the change
8 | VERF_HX_NXT_RVW_DT | DATETIME | No |
When the verification status is changed, this column contains the calculated next review date.
9 | VERF_HX_MEM_PAT_ID | VARCHAR | No |
When the verification status is changed at the member level, this column contains the member's patient ID.