DME_RENTAL_INFO
Description:
This table contains durable medical equipment (DME) member rental tracking record information, such as the member, service, and the amount or number of cycles on the rental so far.

Primary Key
Column Name Ordinal Position
RECORD_ID 1

Column Information
Name Type Discontinued?
1 RECORD_ID NUMERIC No
The unique identifier for the rental record.
2 RECORD_STATUS_C_NAME VARCHAR No
The record status (hidden, soft-deleted, etc).
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
3 PAT_ID VARCHAR No
The unique identifier of the member attached to this rental record.
4 VENDOR_ID_VENDOR_NAME VARCHAR No
The name of the vendor.
5 PROC_ID_PROC_NAME VARCHAR No
The name of each procedure.
6 STATUS_C_NAME VARCHAR No
The status of this rental record.
May contain organization-specific values: No
Category Entries:
Rental
Maintenance
Capped
Closed
7 TOTAL_CYCLES INTEGER No
The total number of cycles so far on this rental record.
8 DME_PRICING_ID NUMERIC No
The Durable Medical Equipment (DME) Pricing record attached to this rental record.
9 DME_PRICING_ID_RECORD_NAME VARCHAR No
The name of the pricing record.
10 TOTAL_AMOUNT NUMERIC No
The total amount paid so far on this rental record.
11 RECORD_CREATION_DATE DATETIME No
Stores the date the record was created.
12 MAINT_TOTAL_AMOUNT NUMERIC No
Tracks the total of all maintenance payments made for the rental.
13 MAINT_TOTAL_CYCLES NUMERIC No
Tracks the number of cycle payments made for the rental during the maintenance period.
14 RENTAL_CLOSE_REASON_C_NAME VARCHAR No
The reason for closing a rental manually.
May contain organization-specific values: Yes
No Entries Defined
15 INITIAL_AMOUNT NUMERIC No
The initial amount specified for the rental on manual rental creation. Prevents this amount from being overwritten during adjudication.
16 INITIAL_CYCLES INTEGER No
The initial number of cycles specified for the rental on manual rental creation. Prevents this number from being overwritten during adjudication.
17 INITIAL_MAINT_AMOUNT NUMERIC No
The initial maintenance amount specified for the rental on manual rental creation. Prevents this amount from being overwritten during adjudication.
18 INITIAL_MAINT_CYCLES INTEGER No
The initial number of maintenance cycles specified for the rental on manual rental creation. Prevents this number from being overwritten during adjudication.
19 RENTAL_START_DATE DATETIME No
This is the start date for the rental. Rental cycles will be calculated based off of this starting date.
20 MAINT_START_DATE DATETIME No
The start date for maintenance on the rental. Maintenance cycles are calculated based on this starting date.