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