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.