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_RESEARCH_STUDY_NAME	VARCHAR	No
	The name of the research study record.
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
7	LINKED_SERIES_CSN_ID	NUMERIC	No
	If a recurring series of appointments was scheduled from this order, this item will contain the recur link (EPT 7150) of those appointments.
8	PRIM_SPECIALTY_GROUPER_ID_GROUPER_NAME	VARCHAR	No
	Record name
9	PRIM_SUBSPECIALTY_GROUPER_ID_GROUPER_NAME	VARCHAR	No
	Record name
10	PRIM_CONDITION_GROUPER_ID_GROUPER_NAME	VARCHAR	No
	Record name
11	PRIM_TREATMENT_GROUPER_ID_GROUPER_NAME	VARCHAR	No
	Record name
12	PRIM_KEYWORD_GROUPER_ID_GROUPER_NAME	VARCHAR	No
	Record name