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.