ED_FOLLOWUP_AUDIT
Description:
Each record in ED_FOLLOWUP_AUDIT corresponds to a patient's edited follow-up information -- i.e. information for where and when a patient was told to follow up with other providers. This table does not include the current follow-up information.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect this is the Unique Contact Identifier (UCI).
2 LINE INTEGER No
The line number for the information associated with this edit. Multiple pieces of information can be associated with this contact.
3 PAT_ENC_DATE_REAL FLOAT No
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 CM_CT_OWNER_ID VARCHAR No
The Community ID (CID) of the deployment owner for this contact.
6 PROV_ID VARCHAR No
The unique ID associated with the provider record with whom the patient should follow up.
7 CONTACT_INFO VARCHAR No
The contact information for the patient's follow-up.
8 SUMMARY VARCHAR No
A summary of the patient contact.
9 EDIT_COUNT NUMERIC No
Stores the number of units (days/weeks/months) for follow up associated with this contact.
10 ED_FUP_UNIT_TYPE_C_NAME VARCHAR No
Stores whether patient has to follow-up in days/weeks/months or on a specific day.
May contain organization-specific values: No
Category Entries:
None specified
Days
Weeks
Months
Date
11 LOC_ID NUMERIC No
The unique ID number of the office location for the follow-up.
12 ED_FU_PRN_USED_C_NAME VARCHAR No
This column shows a 1 if there is something written in the comments field.
May contain organization-specific values: No
Category Entries:
Yes
13 ED_FU_PRN_TEXT VARCHAR No
The free text entry from the comments field for providers to enter any other information they deem important.
14 DEPARTMENT_ID NUMERIC No
The Department ID associated with the department with whom the patient should follow up.
15 ED_FU_OTHER VARCHAR No
The free text entry that contains with whom the patient should follow up.
16 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
17 USER_ID VARCHAR No
The unique ID associated with the user record who entered this follow-up information.
18 USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
19 ED_FU_INST DATETIME (Local) No
The date and time when this follow-up information was filed.
20 ED_FUEDIT_DATE DATETIME No
Stores the history of the follow-up dates entered for an encounter.
21 ED_FUEDIT_ADDR_KEY VARCHAR No
The edit trail for the ED Follow Up Provider Address Key.
22 IP_FUEDIT_ORD_ID NUMERIC No
The edit trail of the follow-up provider order IDs specified for the encounter