BENEFITS

Description: |
The BENEFITS table contains information specific to benefits collection (BEN) record.

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 benefit record.
2 | ENC_BENEFIT_VRX_ID | NUMERIC | No |
The verification record for the encounter's benefits.
3 | RECORD_CREATION_DT | DATETIME | No |
The date the record was created.
4 | PAT_ID | VARCHAR | No |
Patient ID
5 | VERIFICATION_DATE | DATETIME | No |
The most recent verification date of this BEN record. This will be used to facilitate easier BEN record searching in the future.
6 | ORIG_VERIFICATION_DATE | DATETIME | No |
The original verification date of the data on this BEN record when it was entered manually or by RTE and verified for the first time.
7 | RECORD_STATUS_C_NAME | VARCHAR | No |
The record's status.
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
8 | BENEFIT_PERIOD_COVERAGE_ID | NUMERIC | No |
Only populated on coverage-level benefits records. The record ID of the coverage associated with this benefit record.
9 | BENEFIT_PERIOD_START_DATE | DATETIME | No |
The start date for the benefits on this record. Only populated on coverage benefit records.