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