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.