DME_RENTAL_ACTION_HX

Description:

This table contains durable medical equipment (DME) rental record action history information, such as what action was taken, when, and by whom.

Primary Key

Column Name	Ordinal Position
RECORD_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	RECORD_ID	NUMERIC	No
	The unique identifier for the rental 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	ACTION_HX_INSTANT_DTTM	DATETIME (Local)	No
	The instant of the action in local time zone.
4	ACTION_HX_ACTION_C_NAME	VARCHAR	No
	The action taken. May contain organization-specific values: No Category Entries: Created Claim Modified Closed Claim Removed Reopened Initial Amount Modified Initial Maintenance Amount Modified Initial Cycles Modified Initial Maintenance Cycles Modified Rental Start Date Modified Maintenance Start Date Modified
5	ACTION_HX_USER_ID	VARCHAR	No
	The ID of the user performing the action.
6	ACTION_HX_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	OLD_VALUE	VARCHAR	No
	Value before it was modified by an action.
8	NEW_VALUE	VARCHAR	No
	Value after it was modified by an action.
9	ACTION_HX_COMMENT	VARCHAR	No
	Comment for action taken.
10	CLAIM_ID	NUMERIC	No
	Stores claim record ID for claim actions.
11	ACTION_HX_UTC_DTTM	DATETIME (UTC)	No
	The instant of the action in UTC.