RFL_APPT_REQUEST

Description: |
This table stores appointment request information for home health/hospice initial and resumption visit scheduling.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
CAREPLAN_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | CAREPLAN_ID | VARCHAR | No |
The unique identifier (.1 item) for the care plan 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 | CM_PHY_OWNER_ID | VARCHAR | No |
The Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect.
4 | REG_PAT_ENC_CSN_ID | NUMERIC | No |
This item stores the CSN of the Home Health/Hospice Admission or ROC Planning encounter that generated the appointment requests.
5 | APPT_REQ_DISCIPLINE_C_NAME | VARCHAR | No |
Stores the home care discipline associated with the appointment request order for the CSN.
May contain organization-specific values: Yes
6 | APPT_REQUEST_ID | NUMERIC | No |
Stores the appointment request ORD associated with the CSN
7 | REFERRAL_ID | NUMERIC | No |
Stores the referral (RFL) ID that associated with the appointment request ORD for the line.
8 | LCP_APPT_REQ_SUG_STAT_C_NAME | VARCHAR | No |
Stores the status associated with this appointment request suggestion. Categories can be found in I ECT 15520.
May contain organization-specific values: No
Category Entries:
Suggested By System
Saved for Later
Not a Suggestion - Created by User
Sent to Scheduling
9 | SUG_EDITED_YN | VARCHAR | No |
Denotes whether an appointment request suggestion was edited by an end user. Backing category list is ECT 101.
May contain organization-specific values: No
Category Entries:
No
Yes
10 | SUG_RULE_ID | VARCHAR | No |
Denotes which CER rule was used to create this appointment request suggestion.
11 | SUG_RULE_ID_RULE_NAME | VARCHAR | No |
The name of the rule.
12 | SUG_PRC_ID_PRC_NAME | VARCHAR | No |
The name of the visit type.
13 | SUG_START_DATE | DATETIME | No |
The start date of the target range of this visit within the appointment request suggestion.
14 | SUG_END_DATE | DATETIME | No |
The end date of the target range of this visit within the appointment request suggestion.
15 | SUG_NOTE_ID | VARCHAR | No |
Appointment notes for this visit within the appointment request suggestion.