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.