|
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 |
|
|
|
|
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. |
|
|