|
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 |
|
|
|
|
9 |
PRIM_SUBSPECIALTY_GROUPER_ID_GROUPER_NAME |
VARCHAR |
No |
|
|
|
|
10 |
PRIM_CONDITION_GROUPER_ID_GROUPER_NAME |
VARCHAR |
No |
|
|
|
|
11 |
PRIM_TREATMENT_GROUPER_ID_GROUPER_NAME |
VARCHAR |
No |
|
|
|
|
12 |
PRIM_KEYWORD_GROUPER_ID_GROUPER_NAME |
VARCHAR |
No |
|
|
|
|