APPT_REQUEST

Description:

This table stores information about appointment requests.

Primary Key

Column Name	Ordinal Position
REQUEST_ID	1

Column Information

	Name	Type	Discontinued?
1	REQUEST_ID	NUMERIC	No
	The unique identifier (.1 item) for the appointment request record. If the appointment request is also an order, this column can be joined to the ORDER_PROC_ID column in the ORDER_PROC tables.
2	REQ_IS_ACCIDENT_YN	VARCHAR	No
	Indicates whether or not the reason for visit is related to an accident, workers' compensation, or other third party liability guarantor. May contain organization-specific values: No Category Entries: Yes No
3	REQ_SPECIAL_BILL_ID	VARCHAR	No
	The unique ID of the research or client record that contains special billing flags for this visit. If you use IntraConnect, this is the Community ID (CID).
4	REQ_FIN_OUTPUT_ID	VARCHAR	No
	The unique ID of the Questionnaire Answers record that contains the results from running a Financial Decision Tree.
5	REQ_FIN_SCREEN_DTTM	DATETIME (Local)	No
	The instant that the financial screening was last run on this order or appointment request.
6	APPT_REQ_DECL_RSN_C_NAME	VARCHAR	No
	The reason provided by the patient for why they cancelled the scheduling ticket May contain organization-specific values: Yes Category Entries: Other Not interested Already completed