VERIFICATION
Description:
The VERIFICATION table contains information about your verification records. These records include verification information for patients, guarantors, coverages, coverage members, hospital accounts, and encounters.

Primary Key
Column Name Ordinal Position
RECORD_ID 1

Column Information
Name Type Discontinued?
1 RECORD_ID NUMERIC No
The unique identifier (.1 item) for the verification record.
2 RECORD_STATUS_C_NAME VARCHAR No
Stores the record status (hidden, soft-deleted, etc...)
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
3 VERIF_RECORD_INI VARCHAR No
INI of the verified record
4 VERIF_RECORD_IDNT VARCHAR No
ID of the verified record. This item is not networked, because it can contain an EPT, EAR, CVG, or HAR ID, depending on the verification type.
5 VERIFICATION_TYPE_C_NAME VARCHAR No
The verification type of the record. This can be patient, encounter, guarantor, hospital account, coverage, or member.
May contain organization-specific values: Yes
Category Entries:
Patient
Patient Encounter
Guarantor
Hospital Account
Coverage
Coverage Member
Hospital Account 2
Patient Encounter Benefits
Coverage Encounter Benefits
MC Coverage Member
Waiting List
6 VERIF_STATUS_C_NAME VARCHAR No
The current verification status
May contain organization-specific values: Yes
7 LAST_VERIF_DATETIME DATETIME (UTC) No
Date and time of the last successful verification
8 LAST_VERIF_USER_ID VARCHAR No
User who performed the most recent verification
9 LAST_VERIF_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
10 NEXT_REVIEW_DATE DATETIME No
The date on which the verification status needs review
11 LAST_STAT_CHNG_DTTM DATETIME (UTC) No
The date on which the status was last changed
12 LAST_CHANGE_USER_ID VARCHAR No
The user who last changed the verification status
13 LAST_CHANGE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
14 ENC_PAT_ID VARCHAR No
ID for the patient of this encounter
15 ENC_PAT_VERIF_ID NUMERIC No
Verification record for the encounter patient
16 ENC_CSN NUMERIC No
Contact Serial Number (CSN) for the patient encounter associated with the verification. Applies to encounter and hospital account verification.
17 ENC_GUARANTOR_ID NUMERIC No
Responsible guarantor for this encounter
18 ENC_GUAR_VERIF_ID NUMERIC No
Verification record for the guarantor of this encounter
19 ENC_GUAR_SNAPSHOT_C_NAME VARCHAR No
The status of the encounter guarantor at the time the encounter was verified
The category values for this column were already listed for column: VERIF_STATUS_C_NAME
20 ENC_HOSP_ACCT_ID NUMERIC No
Hospital account for this encounter
21 ENC_HAR_VERIF_ID NUMERIC No
Verification record of the hospital account for this encounter
22 ENC_PAT_SNAPSHOT_C_NAME VARCHAR No
The status of the patient at the time the encounter or hospital account was verified.
The category values for this column were already listed for column: VERIF_STATUS_C_NAME
23 VERIF_SUBTYPE_C_NAME VARCHAR No
The verification subtype of the record. Subtypes can include things like address or BSN.
May contain organization-specific values: Yes
Category Entries:
Address
BSN
Contact Information
Primary Care Provider
Patient Contacts
Preferred Pharmacy
Sex and Gender
Race, Ethnicity, and Language
UDS Reg Items
24 SUB_PARENT_VRX_ID NUMERIC No
The parent verification record of the subtype verification record.
25 SUB_ORIGIN_EAF_ID_LOC_NAME VARCHAR No
The name of the revenue location.
26 LAST_SELF_VERIF_DATE DATETIME No
The date on which the verification status was changed the last time by patient (using the Welcome kiosk).
27 VERIF_RECORD_IDNT_NUMERIC NUMERIC No
ID of the verified record if the record's INI has a numeric ID type, or null if the verified record's ID is a string.