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.