MOST_RECENT_CEV_ID
Description:
This table contains data for the most recent claim external values (CEV) records for each CEV context.

Primary Key
Column Name Ordinal Position
CLAIM_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 CLAIM_ID NUMERIC No
The unique identifier for the claim info 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 MOST_RECENT_CEV_ID NUMERIC No
The most recent CEV ID for the given CEV context.
4 CEV_CONTEXT_C_NAME VARCHAR No
This column contains the Claim External Values (CEV) context (direction of claim file, incoming or outgoing)
May contain organization-specific values: No
Category Entries:
Incoming - Initial
Outgoing
Incoming - Repriced
Incoming - Canceled
Outgoing - External Pricing
Incoming - External Pricing
Incoming - Rejected
5 CEV_UPDATE_DTTM DATETIME (Local) No
This column contains the update instant (local time zone) for the most recent Claim External Values (CEV) for the given CEV context.
6 CEV_UPDATE_UTC_DTTM DATETIME (UTC) No
Update instant for the most recent CEV for the given CEV context.