ED_FOLLOWUP_INFO

Description: |
This table stores follow-up information related to a patient's encounter.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ENC_CSN_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ED_FUP_PROVIDER_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
2 | ED_FUP_CONTACT | VARCHAR | No |
Stores contact information for each follow-up item. For example if the follow-up item is a provider then it will store contact information for that provider, if the follow-up item is a department then it will store department contact information, etc.
3 | ED_FUP_SUMMARY | VARCHAR | No |
Stores follow-up summary for each follow-up entry. This summary is generated by combining various follow-up items for each follow-up entry.
4 | ED_FUP_NUM_UNITS | INTEGER | No |
Indicates number of day(s)/week(s)/month(s) or a date on which patient should follow-up.
5 | ED_FUP_UNIT_TYPE_C_NAME | VARCHAR | No |
Stores whether patient has to follow-up in day(s)/week(s)/month(s) or on a specific day.
May contain organization-specific values: No
Category Entries:
None specified
Days
Weeks
Months
Date
6 | ED_FUP_PRN_USED_YN | VARCHAR | No |
Indicates whether PRN text was used in conjunction with the follow-up information. Y indicates that there is PRN text, which will be stored in column ED_FUP_PRN_TEXT of this table. A null value indicates that there is no PRN text for the follow-up information.
May contain organization-specific values: No
Category Entries:
Yes
7 | ED_FUP_PRN_TEXT | VARCHAR | No |
If ED_FUP_PRN_USED is 'Y' then this item will contain the PRN (as needed) text comment.
8 | ED_FUP_DEPT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
9 | ED_FUP_OTHER | VARCHAR | No |
Free text info entered for follow-up.
10 | ED_FUP_HOW_C_NAME | VARCHAR | No |
Stores how the patient should follow up (Call, Make an appointment, etc.).
May contain organization-specific values: No
Category Entries:
None specified
Call
Make Appointment
Go To
11 | ED_FUP_OUT_POS_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
12 | PAT_ENC_DATE_REAL | FLOAT | No |
This is a numeric representation of the date of this contact in your system. The integer portion of the number specifies the date of the contact. The digits after the decimal point indicate multiple contacts on one day.
13 | PAT_ENC_CSN_ID | NUMERIC | No |
The serial number for the patient contact of the patient record. This number is unique across all patient contacts in the system.
14 | LINE | INTEGER | No |
The line number of the follow-up entry for the patient.
15 | ED_FOLLOWUP_DATE | DATETIME | No |
Stores the date for a particular follow-up item. For example, if on 8/31/2011 a user enters a follow-up in 6 months, this column stores 2/29/2012.
16 | FUP_SER_ADDRESS_KEY | VARCHAR | No |
For Emergency Department Follow-ups, this item stores the address key for the selected provider. This address key is used to select the address to send Transition of Care documents to.
17 | FUP_ORD_ID | NUMERIC | No |
Stores the unique order ID of the order from which the follow-up was generated.