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.